Providers can run the Revenue Report to gain insights into earnings, billed amounts, and payments received—broken down by the type of charge for a selected time period. It helps answer key questions like:
How much revenue was earned from tuition or other categories?
What were the total amounts billed and paid?
How much was collected in service fees?
What discounts or credits were issued?
This report is also a helpful reference when auditing journal entries in Quickbooks.
Create a Revenue Report
How to read the Revenue Report
The Revenue Report provides a breakdown of your program’s billed and received amounts by charge category for a selected date range. It’s designed to give clear insights into your financial activity.
Here are a few key things to keep in mind:
Billed amounts are based on charge due dates, while paid amounts are based on actual payment dates—including payments made toward charges from earlier periods
Refunds are included in the paid amount, while credits are displayed separately.
Partial payments are prorated across categories, and unapplied payments are totaled
Service fees passed to families are not included in this report
Payments are reflected regardless of whether they’ve been deposited
Custom Revenue Report
brightwheel's powerful Custom Report Builder allows administrators to pull billing revenue data and then customize the way the data is presented to best fit your needs. Review our Custom Reports resource for more information.
FAQs
Will this tell me how much I billed for a given charge category?
Will this tell me how much I billed for a given charge category?
Yes, the report allows you to see how much you billed for a specific charge category within a chosen time frame. It includes the original billed amount, adjustments, and discounts, all based on invoices with due dates falling between the selected filter dates.
Will this tell me how much I received (money paid) for a given charge category?
Will this tell me how much I received (money paid) for a given charge category?
Yes, the report will show you how much money was received (paid) for each charge category within the chosen time frame. It's important to note that the paid amount represents payments made during the specified filter dates, which may include payments related to charges due before that same time period.
How are we handling partially paid invoices?
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?
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?
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?
How are refunds presented?
Refunds are related to payments and are rolled into the “Paid Amount”
How are credits represented?
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?
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?
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 service fees to families?
What if I pass all service 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?
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