Customer Detailed Ledger
The Customer Age Analysis (CAA), also known as Debtors Age Analysis, is used by organisations to manage collections. The age analysis has columns that are divided into date ranges of current, 30, 60, 90, 120, and 180+ days. These date ranges are based on the calendar month and not necessarily the number of days in the month.
Credit limits are shown on the age analysis and there is a setting to allow Work in Progress to be shown.
A transaction appears on the age analysis once the Header Status is in an accounting status (the accounting checkbox is checked for that status).
Navigation: Main Menu > Accounting > Customer Age Analysis > Right-click an entry > Open Detailed Ledger
Buttons Explained
| Button | Description |
|---|---|
| View | Generates a list of entries as per the selected data filters. |
| Arrow on View Button | Arrow on View Button > Reset Data Filter |
| Output | Prints, previews or emails reports if Output Templates are created. Lists the same options that are available under Customer Age Analysis. |
Filters Explained
- The filters for the detailed ledger are identical to those for the age analysis.
Fields Explained
| Field | Description |
|---|---|
| Field Chooser (*) | Allows users to add or remove columns. |
| TransID | The system-generated number for the transaction. |
| Status | The Status of the transaction. |
| Trans | The transaction type’s code (e.g. SI for Supplier Invoice). |
| No. | The transaction number. |
| Date | The date of the transaction. |
| Reference | The reference entered on the transaction. |
| Currency | The Currency in which the transaction is. |
| Debit | The amount that was debited for the specific line item. |
| Credit | The amount that was credited for the specific line item. |
| Balance | The running total (balance) on the account. |
| Widget | A submenu that can be accessed by right clicking the line: – Open Transaction: Opens the original transaction. |
Footer Explained
| Field | Description |
|---|---|
| Opening | The opening balance at the start of the selected period. |
| Movement | The movement for the selected period. |
| Closing | The closing balance at the end of the selected period. |
