If this content does not match what you see in your account, you may be on our legacy billing platform.
We want to help you run your businesses more effectively. That’s why we’re continually investing in the reports you need to understand your center’s financial health, including the Revenue Report.
Table of Contents
Overview
The Revenue Report will show you how much you earned in a given time period. You can see billed and paid amounts by charge category, making it easy to answer questions like:
How much tuition [or other charge category] revenue did I earn this month?
How much tuition [or other charge category] did I bill families for?
How much tuition [or other charge category] was paid?
How much did I pay in processing fees?
How much in discounts or credits did I give out?
This report will also show you how much your center paid in processing fees if you are not passing fees along to your families. It can also be used as an input for auditing, journal entries in Quickbooks (see our Quickbooks Compatibility Guide), and more.
Report Details
This report will quickly and easily show how much your program billed and how much was received for a given charge category (those in your Library)
The billed amount will be based on due dates — if you select 8/1/22 - 8/31/22, we will pull all charges due between those two dates
Billed amounts shown in the web view are net of adjustments and discounts; however, when you export the report, you will see the discounts and adjustments broken out separately
The paid amount is based on the payment date — if you select 8/1/22 - 8/31/22, we will pull all payments against the associated charges between those two dates
Payments in the time frame could include payments against charges billed before these dates
Refunds are rolled into the paid amount
Credits are shown as a separate column
For partially paid invoices, payments are pro-rated against charges on that invoice
Unapplied payments reflect the total payment amount between the filtered dates that are not applied to any invoices
If you pass processing fees to families, the ACH and CC fee rows will show $0 since these are not considered costs to the program.
Payments in the selected date range will show, irrespective of deposit status. Meaning payments that have not yet been deposited to the admin's bank account will still be included in this report.
Exporting the Revenue Report
Update the 'Start/End date' filters as needed
Use the 'Group by' drop-down filter as needed
Click Apply Filters
Click Export or Print
If exporting, choose to Download right in the browser or select/add email addresses and click the purple Email to button to send
FAQs
Will this tell me how much I billed for a given charge category?
YES. You can run the report for a given time period and see how much you billed families for each charge category in your library. We will show the original billed amount, any adjustments to that amount, and discounts before getting to the current billed amount. Note: the billed amount reflects charges on invoices due between the two filter dates.
Will this tell me how much I received (money paid) for a given charge category?
YES. You can run the report for a given time period and see how much your families paid for each charge category in your library. Note: the paid amount reflects payments made between the two filter dates – those payments could have been related to charges that were due before that same time period.
How are we handling partially paid invoices?
We will prorate payments against charges in a partially paid invoice and reflect that in the charge revenue section. Example: An invoice has a $100 tuition charge and a $50 registration fee. That invoice was paid $75, which is 50% of the invoice total. We will apply that 50% to the charge amounts, showing up as $50 of the tuition charge paid and $25 of the registration fee paid.
How are offline payments reflected?
Offline payments such as cash or check will have both a
post date (date payment was recorded on the account) and a payment date (date amount was recorded as paid) this report will consider offline payments by the date they are recorded as paid not the date they are posted.
If a payment is posted on 1/15 but is marked as paid on 1/10 they would see the payment when filtering for 1/10 not 1/15
How are discounts presented?
Discounts are at the charge level and are shown in total for each charge category. This report does not currently include the total amount by discount category (ie to answer “How much in ‘Sibling Discounts’ did I give out?”)
How are refunds presented?
Refunds are related to payments and are rolled into the “Paid Amount”
How are credits represented?
Credits are at the charge level and are shown in total for each charge category. This report does not currently include the total amount by credit category. Credits that have been created but not applied to an invoice do not appear in this report.
What are the “Other” revenue categories?
Unapplied payments = total payments made that are not applied to any invoices and therefore charges
Can admins see expected (future) revenue for invoices that posted?
YES. If an admin billed a family for charges that are due in the future, they will be able to see how much they billed for that is due in a future time range! For example, if today is 9/1 and the admin posted 10 invoices totaling $1,000 due on 9/15, if they filter for 9/15 - 9/30, they will see the $1,000 billed amount for the charges in those invoices.
What if I pass all processing fees to families?
Then the ACH and CC fee rows will show $0, as these are not considered costs to a center.
Is this for cash or accrual-based accounting?
Generally, both.
Accrual basis = billed amounts in a given time period, even if not paid
This is the Amt Billed column
Cash basis = paid amounts in a given time period
This is the Amt Paid column