Home » Categories » Solutions by Business Process » Finance » Sales and Purchase Ledgers

Aged Analysis of Debtors / Creditors

Datafile Software

Aged Analysis of Debtors / Creditors

The Aged Analysis report analyses the outstanding transactions, and groups them into your defined ageing periods, which can be helpful in debtor chasing and payment generation.

This report only includes open item accounts, though the total balance of any balance forward accounts can be printed at the end of the report to ensure that the final totals reflect the complete ledger. The program uses the "As At” date as the basis from which to calculate the age of the transactions, and normally ages on the original transaction date, although Diamond and Premier users can set the report to age on the transaction due date.

As well as the standard prompts there are several additional parameters that you can answer:

Change the Aged Analysis

The default ageing periods are displayed, and these are used if you leave this option blank. However, if you reply Y to this question, then you can change the ageing periods, for this run only, to any set of values you want.For example, the default periods may be 30, 60, 90 days etc. but for this report you wish them to be weekly. Overtype the values with 7, 14, 21, 28 and 35.

If using Monthly analysis terms this option is not applicable.

Which Type of Accounts Printed

This option allows you to filter the accounts printed which are based on the age of the outstanding balances. The options available are:

All Accounts – all accounts are included even if there is no outstanding balance.

If Account Balance – only accounts with a non-zero balance are included

With Any Balance Over n Days – only accounts with a balance over n days are included (n is the values defined for the aged analysis periods above).

Include Account Address

If you select this option then the full address of each account is printed as part of the detail for each account.

Include Transaction Detail

If you select this option, then in addition to summaries of the transactions for an account, the individual transactions are listed with their values printing in the proper ageing columns.

Include Telephone

One extra item from the accounts file may be specified as an extra item for printing on the aged debtors’ report. Typically the extra item chosen is the customer’s telephone number so that the report may be used to telephone late payers. Here you decide whether or not you want this extra item printed this time.Diamond and Premier users can nominate a different account item to be printed if required.

Exclude Transactions with Flags

If you choose to print transactions on this report (see question above) you can decide here whether to exclude printing any transactions which have any of the flags which could apply. Enter the letters which correspond to the flags you wish to omit — the letters you can choose are shown on the right of this question on the screen.

For the sales ledger you can exclude transactions with flags of B, C and D. For the purchase ledger you can exclude transactions with flags C, D, P and U.

Report Comment Printed

You can add a report comment to this report of up to 40-characters in length here.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Cheque Printing (Purchase Ledger) - Application User Facilities
Viewed 1625 times since Mon, Jul 2, 2012
Copy Notice for Invoice Reprints (Sales Ledger)
Viewed 1590 times since Mon, Jul 2, 2012
Account Statements (Sales Ledger) - Database Profiles
Viewed 2215 times since Mon, Jul 2, 2012
Set Application Code Formats
Viewed 1563 times since Mon, Jul 2, 2012
Include Currency Accounts in Auto-Payment Procedures
Viewed 1484 times since Fri, May 27, 2016
Sub-Contractor Accessory - Transaction Entry
Viewed 1610 times since Mon, Jul 2, 2012
Save and Exit - Document Design Manager
Viewed 1548 times since Mon, Jul 2, 2012
Allocations (Sales Ledger)
Viewed 1936 times since Mon, Jul 2, 2012
Document Design Manager
Viewed 1971 times since Mon, Jul 2, 2012
Audit Pointers and Balances
Viewed 1660 times since Mon, Jul 2, 2012