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

Article ID: 1298
Created On: Mon, Jul 2, 2012 at 10:58 AM
Last Updated On: Mon, Jun 19, 2023 at 3:59 PM

Online URL: https://kb.datafile.co.uk/article/aged-analysis-of-debtors-creditors-1298.html