Overview of accounts receivable or payable aging analysis report
Menu paths
- To view the accounts receivable report, go to Finance ➔ Accounts receivable ➔ Receivables ➔ Aging Analysis.
- To view the accounts payable report, go to Finance ➔ Accounts payable ➔ Payables ➔ Aging Analysis.
Introduction
The Accounts Receivable (A/R) Aging Analysis report displays
the outstanding amounts from debtors while the Accounts Payable (A/P) Aging Analysis report shows
amounts 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.
Fields
Criteria section
Sorting
Select the option to display the report based on the sorting selection. Sorting by due date means by aging, which is dependent on the aging
criterion.
Age
The outstanding invoices are grouped by this aging
criterion.
Invoice currency
Select an option to view the report by a specific currency, the
system default currency, the invoice currency, or others.
Additional criteria
Click this to define more criteria for accounts receivable or accounts payable.
Accounts receivable additional
criteria screen
Debtor data
Select this check box to display additional data about the
debtor such as the address, contact, bank account, et cetera.
Minimum age
Type the minimum age of outstanding amounts to display only those above this number will be shown in the report.
New page every debtor
Select this check box to print all debtors on a
new page.
Only with notes
Select this check box to display transactions with notes attached.
Summarize
Select this check box to view the amount owed by each debtor for each
aging group, without the invoice details.
Exclude unknown debtor
Select this check box to exclude unknown debtors from the
report.
Accounts payable additional
criteria screen
Include tax creditors
Select this check box to display amounts owed to tax
creditors.
Note: Other fields are similar to the accounts receivable additional criteria screen, and thus have
the same functionalities. The only differences are these options are now applicable
for creditors instead of debtors.
Range section
Reference date
Select a date to display transactions prior to the date
selected.
Status
Select the relevant status to filter the customers by their status.
Type
Select the relevant option to show only customer data or
employee data or even both.
Debtor / Name / Post code / Classification
/ Due date
This field will be labeled differently based on the option selected at Sorting. Define a range required to show only the selected range in the
report.
Items
Select the All check box to display all outstanding amounts or Due to display amounts that are supposed to be paid before
the reference date.
Project
Select a range of projects or select the All check box to display outstanding amounts for all projects.
Cost centre
Define a range of cost centres to view outstanding amounts of the selected cost centres or select the All check box to display to outstanding amounts for all cost centres.
Account employee
Define the range of debtor accounts to be
included into the report or select the All check box to include all debtor accounts.
Intermediary
This is another field to filter unnecessary debtor accounts.
Scenario
Select a debtor scenario to display the group of debtors based on the selected scenario.
Blocked
Select an option to display only blocked amounts, to exclude blocked
amounts, or to include them into the report.
Payment method
Select an option to display transactions using this payment method.
Currency section
Summary: Foreign Currency
Select this check box to display a short summary for each
debtor and each currency for the total amounts owed. This is available only when All – Default Currency is selected at Invoice currency.
Amounts in foreign currencies are converted to the default
currency in the report using different exchange rates. Define the type
of exchange rate to be used by selecting one of the following:
- Original – Uses the exchange rate
that was used when creating the invoice.
- Current – Uses the exchange rate of the current date.
- Historical
– Uses the exchange rate of a selected date.
Date
Select a date to use the exchange rate for the selected date.
Note: This is enabled only if the Historical exchange rate
has been selected.
Buttons
Start
Click this to generate the report.
Close
Click this to exit.
Main Category: |
Attachments & notes |
Document Type: |
Support - On-line help |
Category: |
|
Security level: |
All - 0 |
Sub category: |
|
Document ID: |
10.765.514 |
Assortment: |
Exact Globe+
|
Date: |
26-09-2022 |
Release: |
|
Attachment: |
|
Disclaimer |