On the website, click Reports, then locate the Billing section to find and download the following Billing reports:
Important
We've redesigned the Detailed Transaction Breakdown report and split it into two improved reports: the Categorized Transaction Summary report and the Registration Payments report.
When you open the reports, you'll find the content format remains consistent. This uniform format ensures easy navigation and interpretation of the information across different reports without adjusting to different layouts or structures.
Family Balance Report
This Excel report displays the total invoiced amount, total paid and current outstanding balance for each family for the selected month and room.
Example: Family Balance Report
Report Columns
Family Name
Student Names
Room
Tags
Family ID
Charges
Payments
Balance
Available Report Filters
Date (monthly)
Balance Type
Room(s)
Transactions Reports
Under the Transactions reports, there are 3 reports that can be generated. Click the title of the report to view an example.
Transactions > All Transactions - displays payments and invoices for each family for the selected date range.
Transactions > Deposit Report - displays payment details for each family for the selected date rage.
Transactions > Custom - creating a custom transaction report allows you to select the transaction types you wish to view (invoices and payments by cash, check, card, ACH and other).
Report Columns
Date
Student
Room
Tags
Parent Names
Type: Invoice, Payment
Card Type
Transaction Type: Online, In Person
Description
Due Date
Status
Amount
Net Amount
Balance
Internal Note
Receipt Number
Service Start Date
Service End Date
Available Report Filters
Date Range
Report Type: All Transactions, Deposit Report, Custom
Format: Procare, FACTS
Categorized Transaction Summary
Generates a categorized summary and breakdown of invoice, payment and refund transactions for a selected date range.
Understanding Starting Balances
Starting Sum of Debit Balances: Calculation of the sum of money owed to the center by families as of the selected start date for the report’s date range. The report reviews each family's account balance: if the balance is positive, it is included in the Starting Sum of Debit Balances.
Starting Sum of Credit Balances: Calculation of sum of credits the center owes up to the reports selected start date. The report looks at each family’s balance; if the balance is negative, the balance total is added to the Starting sum of Debit Balances
Example: Categorized Transaction Summary
Report Columns
Categorized Summary Tab
Starting Sum of Debit Balances
Starting Sum of Credit Balances
Balance Forward
The following colums are available for Charges, Reunds, Credits, Subsidy, Payments and Lead Payments
Type
Sub Type
Description
Count
Amount
Net Amount
Ending Sum of Debit Balances
Ending Sum of Credit Balances
Ending Balance
Change in Debit Balances
Change in Credit Balances
Detailed List Tab
Date
Type: Invoice, Payment, Credit and Refund
Sub Type
Card Type
Transaction Type
Description
Student Name
Parent Names
Family ID
Room
Tags
Receipt Number
Service Start Date
Service End Date
Due Date
Status: Sent, Not Sent, Success
Amount
Total Amount
Available Report Filters
Date Range
Registration Payments
Provides a record of payments and refunds process through Leads or Registration.
Example: Registration Payments
Report Columns
Date
Type: Payment, Reund
Description
Student Name
Room
Tags
Status
Amount
Tuition Billing Plans Report
Exports details for all children with current Tuition billing plans.
Example: Tuition Billing Plans Report
Report Columns
Student Name
Room
Tags
Family ID
Parent Names
Plan Name
Plan Status
Plan Cycle
Plan Start Date
Plan End Date
Item
Amount
Total Amount
Available Report Filters
Room(s)
Attendance Billing Plans Report
Exports details for all children with current Attendance billing plans.
Example: Attendance Billing Plans Report
Report Columns
Student Name
Room
Tags
Family ID
Parent Names
Plan Name
Plan Template
Plan Cycle
Plan Start Date
Plan End Date
Invoice Generation Date
Billing Start Date
Billing End Date
First Invoice Date
First Invoice Due Date
Charge Name
Start Time
End Tme
Days Applies
Rooms Applies
Charge Rate
Charge Type
Late Fee Rate
Available Report Filters
Room(s)
Aging Report
The Aging report provides a family account balance for each month over the last 6 months.
Example: Aging Report
Report Columns
Family
Room
Tags
Family ID
Current Balance
Balance listed for last 6 months
Available Report Filters
Monthly
Bank Deposit Slip
Generate a PDF deposit slip for cash, check and other payment types.
Example: Bank Deposit Slip
Available Report Filters
Date Range
Deposit Date
Transaction Type
Ledger Detailed Transaction Report
The Ledger Detailed Transaction report provides a list of all transactions for each ledger.
Example: Ledger Detailed Transaction Report
Report Columns
Date
Ledger
Ledger Kind
Description
Student Names
Type
Amount
Balance
Service Start Date
Service End Date
Available Report Filters
Date (month)
Ledger