Billing Reports

On the website, click Reports, then locate the Billing section to find and download the following Billing reports:

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)
• Room

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.

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

Export current tuition plan details for all children.

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

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