The Billing Transactions report provides administrators with comprehensive information about all of the transactions that have been recorded on the school’s ledger during a specified date range. This allows the flexibility to filter/sort the report to fit precise needs and choose to download and save the report.
Table of Contents
View the Billing Transactions Report
The Billing Transactions Report can be viewed online from an administrator brightwheel account. It's available in the Billing Tab and includes several multi-select filters that administrators can use to define which transactions should be included in the report.
When viewing this report online, it will include:
Post Date: The date a transaction was posted (For offline payments, the Date paid is shown)
Student name: The name of the student the transaction is associated with
Transaction type: the associated type based on the parameters selected to report on
Transaction description: Transaction description (this would include “Category” for Charges in the format ‘Category: Description’). Any transaction notes are displayed below the description.
Amount: For charges with discounts, this will be the Net Amount Charged after subtracting discounts and be displayed with an icon (additional information on discounts on export)
Log in on the web
Click to open the Billing page on the purple sidebar menu
Jump to the Reports tab
Click to open the Billing Transactions Report
Select the Earliest post date and Latest post date
💡By default, the dates will be set to list all of the transactions on your account in the last 30 days but can be adjusted as needed.
Select the Transaction type(s) that should be included in the report
Set the Student, Room, and Student status filters, if desired
Click Apply Filters
Export the Billing Transactions Report
Exporting this report is the best way to obtain a fully comprehensive and malleable report of each payment that has been processed through brightwheel. Exports can be easily sent to any administrators at the program or outside email addresses.
View and filter the report as outlined above
Click the gray Export button
Deselect any fields you don't want to be included in the export
Select recipients from the list, or add email addresses for new recipients
Click the orange Send to button
The exported report will be sent via email and can be opened in Excel, Google Sheets, Numbers, or any other spreadsheet tool.
Exported Report Fields
By default, this report contains the following columns listed below. These options can be de-selected during the Export process outlined above to only report on what's needed!
Due date (would only show for charges but is valuable)
Transaction description (this would include “Category” for Charges)
Dates of service
Student last name
Student first name
Payment method type
Original charge amount
Payment amount (excludes processing fees)
Parent processing fee amount
Discount description (for multiple discounts, add additional columns)
Discount type (“percent” or “fixed”)