Customer Age Analysis
Overview
- Use the Customer Age Analysis to manage Debtors (Receivables).
- The Default View lists all the outstanding accounts with totals for each 30-day interval.
- The Transaction View displays all the outstanding invoices.
- The Customer Age Analysis also includes features to send Customer reminders and Statements.
Settings
Info
These Settings are required to use the Customer Age Analysis.
User Settings
Note
The defaults are the values for new databases and new users. Your database may have different values.
| Setting | Description | Default |
|---|---|---|
| Accounting: Customer Age Analysis - Access Allowed |
| None |
| Default Templates: Customer Age Analysis | Lets you select a different template to display the age analysis (if different templates were created). | None |
| General: Batch Updates - Access Allowed | Yes or No. | No |
General Settings
| Setting | Description | Default |
|---|---|---|
| Maximum amount allowed to clear on Age Analysis | Enter an Amount.
| 1 |
List View
Info
The List View shows all the customers with active balances or transactions.
Buttons Explained
| Button | Description |
|---|---|
| Reset | Resets the Data Filters to default. |
| View | Displays the age analysis as per the selected filters. |
| Output | Outputs PDF documents:
|
| Actions > Batch Update |
|
| Menu |
|
Data Filters Explained
| Filter | Description |
|---|---|
| Set | Sets a specific time frame such as Today, This Month, This Year or Fin Year. |
| ← → | Adjusts the date in the direction of the arrow. |
| Date | Lets you customise the dates. |
| Periods | Checkbox to calculate the ageing on Accounting Periods and not calendar dates. |
| Rep | Dropdown list of all the reps to select one, or all. The filter uses the rep selected on the customer account (the default rep) which may differ from the rep chosen on a specific transaction. |
| All Accounts | Checkbox to include all customer accounts, even those with zero balances. |
| Local Currency | Shows all the outstanding amounts in the local currency. |
Fields Explained: Default View
| Field | Description |
|---|---|
| Field Chooser (*) | Lets you add or remove columns. |
| Status | Indicates the status of the customer. |
| Account | The Name of the customer. |
| Category |
|
| Acc No | The customer's Account Number. |
| Terms | The Terms given to the customer. |
| Contact | The customer's Contact person. |
| Rep | The Sales Representative who normally deals with the customer. |
| Remind | The reminder date. |
| Region | The customer's region. |
| Currency | The Currency in which invoices and other documents are issued. |
| QT Access | Checkbox indicating whether the customer has access to Quotations. |
| CPN Access | Checkbox indicating whether the customer has access to Campaigns. |
| SO Access | Checkbox indicating whether the customer has access to Sales Orders. |
| WO Access | Checkbox indicating whether the customer has access to Work Orders. |
| DN Access | Checkbox indicating whether the customer has access to Delivery Notes. |
| CI Access | Checkbox indicating whether the customer has access to Customer Invoices. |
| Credit Limit |
|
| Overdrawn | The outstanding amount that exceeds the credit limit. |
| Total + WIP |
|
| Columns for Days Outstanding |
|
| Current | The Current amount due. |
| Unallocated | Displays a total of payments or credit notes that are not allocated to invoices. |
| Total | The Total amount due by the customer. |
| Menu (...) | A submenu that lets you:
|
Fields Explained: Transaction View
| Field | Description |
|---|---|
| Field Chooser (*) | Lets you add or remove columns. |
| Trans ID | The system-generated Transaction Number. |
| Status | Indicates the status of the transaction. |
| Ledger ID | The system-generated Ledger Number. |
| Trans | A code indicating the source document (e.g. CI for Customer Invoice). |
| No. | The source document's number (e.g. Invoice number). |
| Date | The transaction's date. |
| Due Date | The transaction's due date. |
| Category |
|
| Company | The customer's Name. |
| Contact | The customer's Contact person. |
| Rep | The Sales Representative who normally deals with the customer. |
| Reference | The reference on the source document. |
| Order No. | The customer's order number on the transaction. |
| QT No. | The linked Quotation Number. |
| Terms | The terms given to the customer. |
| Total | The total amount outstanding on the account. |
| CUR | The Currency in which invoices and other documents are issued. |
| Ageing | The number of days the invoices are outstanding. |
| Overdue | The number of days the account is overdrawn. |
| Columns for Days Outstanding | Columns are available for:
|
| Outstanding | The total amount due by the customer. |
| Menu (...) | Click it once to show the eye icon, then click the eye icon to open the transaction. |