Customer Balances report
Posted by Cameron Telfer, Last modified by Duncan Clarke on 20 December 2017 05:43 PM

This report is accessed via Reports, then Accounting. Enter the month end date for the report. The report will show the balances and charges / payments for individual Customers, with totals at the bottom of the report, however you can choose to only print the totals. It is recommended that you print one copy of the full Customer balances report at the end of the month.

This report shows all Customers, whether active or inactive, who have a non-zero balance at the end of the month, or who have had charges and /or payments applied during the month. The report also includes all charges and payments that were not applied to any particular Customer but were made as cash sales – this will be shown under the MISCL Customer on the report.

There are 4 columns on the report:

  • Prev Month Balance – should equal last month’s Bal Mth End
  • Charges – The total charged during the month – Should equal the month’s Income Charged Report.
  • Payments – Payments received for the month – Should equal the month’s Income Received Report.
  • Bal Mth End – The balance as at the month end date.
  • Current Balance – The balance as at the moment the report is run.
(2 vote(s))
Not helpful

Comments (0)