Debtors Aged Trial Balance
Menu Selection: Reports - Debtors - Aged Trial Balance
Purpose
The Debtors Aged Trial Balance is used to report on sales for each Debtor, the last cash paid, the balance of the account, and the aging through current, 30. 60 and 90 days. This report may typically be used for Debtors reconciliation and posting of Debtors cash receipts.
Parameters
| Parameter | Instructions |
| From Customer To Customer |
To limit the output of the report specify non blank From and To Customer. |
| From Category To Category |
To limit the output of the report specify non blank From and To Category. A debtor can have up to 3 categories. This report will only show debtors who have the selected categories in any of the 3 debtor categories. |
| From Turnover To Turnover |
To limit the output of the report specify non blank From and To Turnover. |
| From Sales Exec To Sales Exec |
To limit the output of the report specify non blank From and To Sales Exec. |
| From Postcode To Postcode |
To limit the output of the report specify non blank From and To Postcode. |
| Overdue Only | If this parameter is set to Y, the report will show debtors that have 60 or 90 day balances. Otherwise the report will only show debtors who's account has a non zero balance. |
| Show Detail | If this parameter is set to Y, the report will list all outstanding invoices and undistributed cash in the account. |
| Show Complete | If this parameter is set to Y, the report will list the complete transaction history for the account. This parameter overrides the Show Detail parameter. |
| Zero Balances | If this parameter is set to Y, the report will show all debtors. This parameter overrides the Overdue Only parameter. Otherwise the report will only show debtors who's account has a non zero balance. |
General information on reporting can be located here.
About This Report
| Column | Description |
| Debtor | Displays the debtors account key. |
| Name | Displays the debtors name. |
| Phone | Displays the contact phone number for the debtor. |
| Last Cash | Displays the date cash was last received from the debtor. |
| Balance | Aged Balances |
| Current | Aged Balances |
| 30 Days | Aged Balances |
| 60 Days | Aged Balances |
| 90+ Days | Aged Balances |
If *** appears beside the 90+ Days column, this indicates that there is a problem in the debtor's account.
Typically running the Document - Utility - Redistribute - Debtors process will fix the problem. Re run this report.
If, after running this process, the *** still appear on the report, then the some ledger entries in the account have duplicate reference numbers. To correct this, run a Document - Utility - Elim Dups - Debtors followed by the Document - Utility - Reindex process.