Overview

Customer trial balance (summary) provides you with details on what each of your customers owe you, showing current, 30 days, 60 days, 90 days, 120 day and the overall total. 

Image of report result

Running the report

1. In the Navigation panel, go to Reports then Form Reports.
2. Select Customer Trial Balance (summary)
3. Select the parameter 

4. Click on Show Report Using Parameters, screen as per below will appear

    Show me

   

5. Enter the date required.
6. Start Customer and End Customer fields
   1. If you require all customers leave both fields blank
   2. If you require 1 customer key in same card id into both fields
   3. If you require specific range of customers based on card id enter start customer and end customer for that range. 
7. Click OK and report runs
8. Result appears as above image.

Use Case

Its end of month and your accounts staff want to check the accounts that are overdue by 60 days or more, run the above report for these results and highlight the ones you want chased up.