The Accounts Receivable (A/R) Aging Analysis report displays
the outstanding amount from debtors while the Accounts Payable (A/P) shows
amount due to creditors. These reports group the expected cash flows into
different aging groups in order for you to see how much is going in and out for
certain periods. You can view the A/R report using [Finance / Accounts Receivable
/ Receivables / Aging Analysis] and the A/P report using Finance / Accounts
Payable / Payables / Aging Analysis].
Explanation of fields
This selection allows you to choose how the report should be
sorted. Sorting by due date means by aging, which is dependent on the aging
The outstanding invoices are grouped by this aging
You can choose to view the report by specific currency, the
system default currency, the invoice currency, etc.
Clicking on this button will prompt another selection window
as shown below.
The A/R additional
Checking this option will display additional data about the
debtor such as the address, contact, bank account, etc.
This criterion filters the age of outstanding amounts such
that only those above this number will be shown in the report.
New Page Every Debtor
By selecting this option, all debtors will be printed on a
Only with Notes
If you check this selection, the report will only show
transactions with notes attached.
You can opt to view the amount owed by each debtor for each
aging group, without the invoice details using this selection.
Exclude Unknown Debtor
Checking this option will exclude unknown debtor from the
The A/P additional
Include tax creditors
Select this criterion to also display amounts owed to tax
Other fields are similar to the A/R screen, and thus have
the same functionality. Only differences are these options are now applicable
for creditors instead of debtors
The report will only display transactions prior to the date
Use this selection to filter the customers by their status.
You can specify whether to show only customer data or
employee data or even both.
Debtor / Name / Post Code / Classification
/ Due Date
This selection will change based on the Sorting order
selected, in which you can choose a range to show only the selected in the
Choosing all items will display all outstanding amounts, but
if you select Due, then only the amounts that are supposed to be paid before
the reference date will be shown in the report.
Filter the report by selecting a range of projects.
You can also select to view only outstanding amounts of particular
Use this selection to filter which debtor accounts to be
included into the report.
Another criterion to filter out unnecessary debtor accounts.
You can select the group of debtors by specifying the debtor
Choose to display only blocked amounts, to exclude blocked
amounts or to include them into the report.
Specify a payment method and only transactions using this
method will be shown in the report.
Summary: Foreign Currency
Checking this option will show a short summary for each
debtor and each currency for the total amounts owed. This selection is only
available when All – Default Currency is selected for Invoice Currency.
Amounts in foreign currency are converted to the default
currency in the report using different exchange rates. You can specify the type
of exchange rate to be used by choosing from this selection.
- Original – Uses the exchange rate
that was used when creating the invoice.
- Current – Uses the current date’s
– Uses a selected date’s exchange rate.
You can select a particular date’s exchange rate to be used
in the report. This date selection is only enabled if Historical exchange rate
has been selected previously.
At the bottom of the screen, these buttons are available.
Click on this button to generate the report.
Clicking on this button exits the report selection and
returns to the main menu.