Family Debtor Balance Report

Use: 

This report displays the balance of family accounts that are in debit or credit to enable you to manage family accounts and assist in understanding total monies currently owing to your centre. 

Family account balances of $0.00 are not displayed in this report, only those owing money or in credit.


Report Output type:

This report can be run in PDF format or in Microsoft Excel format. 

If you run the report in Excel, you can sort and filter data to your needs (e.g. you may want to filter out any families with credits to display total money owing).


Calculated as at Date:

This date defaults to the current date. However, for the report to display current / up-to-the-minute, accurate family account balances, you need to enter this date as the last date of your current billing period. The reason for this is so that any changes in enrolment, payments or possible future credits are taken into account.


To check your current billed to dates, go to Administration > Auto Generate Lesson Invoices, and check for the furthest date billed for any of your Fee Calculation Templates.

Example of previous invoice history showing current billed to dates.


Enter your furthest billed date into the report "Calculated as at" field and click "View Report".


Report information:

The report information will display: 

Family ID number  -  Family name  -  Amount in Debit / Credit  -  Family status ("Active" for active families, blank for inactive families)


The report is ordered by account balance, from highest balance to lowest balance.




Last updated: 3 June 2022

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.