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>Form Reports.
2. In the list of reports find the category Cards and then select Customer Trial Balance (summary) or search for the report in the name field
3. Highlight the report F-017
4. In the detail area click on 'Show report using parameters' action button 
    Customer Trial Balance Summary

   

5. The window 'customer trial balance parameters' will open
   
   

6.  Show me

   

7. Enter the last day of the month in question, eg if you are running the trial balance for April 2020 then insert the last day of april.
8. 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. 
9. Click OK and report runs
10. 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.