One moment please...
 
 
Exact Globe+   
 

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:  Date: 26-09-2022
 Release:  Attachment:
 Disclaimer