BPM Country Reports

AR Aging

This section describes the fields and actions on the AR Aging workspace, as well as instructions on how to generate the report.

Quick Links: Selection Criteria | Generate Report | Report Fields | Limitations | Admin Setup

Overview

This report is a copy of the standard AR Aging report, but this links to the Outstanding Customer Invoices report. There are a couple of key differences between the AR Aging report and the Outstanding Customer Invoices report. Specifically:

  • The Aging report filters out records that summarize to zero if these records also do so on the lowest drill-down level (that is, records that do not add to the balance on any level of detail). On the Outstanding report, such records are included because they add value and insight.
  • The Aging report may also list payments made without a corresponding invoice, while the Outstanding report does not because it concentrates on invoices and credit memos. For example, if a payment is made by a customer in the General Journal even if there is no customer invoice, that payment will appear in the Aging report as a negative balance but is filtered out in the Outstanding report. However, if that same payment is reconciled against an invoice, the Outstanding report will list the invoice and the reconciled amount as the paid amount.
Note: While this report was created primarily to address an Australian statutory requirement, it can also be utilized by companies from other countries. Reach out to Consulting or Customer Care for more information.

Report Workspace

Navigation

To open the report workspace, select Reporting » Country Reports » Australia » AR Aging.

Or, go to Reporting » BI Launch Pad and click Open BI Launch Pad. The report is located on the Business Performance Management » Reporting » Australia folder.

Selection Criteria

Field Description
Currency Type Select a currency type from the drop-down list. Available options are:
  • Company
  • Customer
  • Enterprise
Include Blocked Select this check box to include blocked customers in the list.
Include Inactive Customers Select this check box to include inactive customers in the list.
Separate Blocked Select this check box to include blocked customers but in a separate list.
Statement Date Use this field to filter the entries to be included in the report. Only open entries and reconciliations entered before or on the statement date you specify are included in the report.
Customer Group Use this field to select a customer group.
Country Use this field to select a country.
Sales Person No. Use this field to search for or enter a sales person number.
Project Manager No. Use this field to search for or enter a project manager number.
Customer No. Use this field to search for or enter a customer number.
Control Account Use this field to select a control account.
Job No. Use this field to search for or enter a job number.
Company No. Use this field to search for or enter a company number.

Dimensions

Field Description
Location Name Use this field to filter entries by location.
Entity Name Use this field to filter entries by entity.
Project Name Use this field to filter entries by project.
Purpose Name Use this field to filter entries by purpose.
Spec. 1 - 3 Name Use this field to filter entries by other specs as needed.
Local Spec. 1 - 3 Name Use this field to filter entries by other local specs as needed.
Level 1 - 5 Customer No. Use this field to filter entries by customer number level.

Generate the Report

Export the Report

To generate the report:

  1. Go to Reporting » Country Reports » Australia » AR Aging.
  2. Enter the selection criteria for running the report.
  3. Click Run. The screen refreshes and displays the generated report.

    To keep a copy, click the Download icon. In the dialog box, specify the parameters for the export file (file type, reports and options), then click Export.

Submit the Report

Not applicable for this report.

Report Description

Report Fields and Descriptions

Header Column Description
Currency Displays the currency used for the report.
Company No. & Name This column displays the number and name for the current drill-down level. The drill-down levels are:
  • Company
  • Customer
  • Job
  • Transaction
Balance, Total This column displays the total amount outstanding on customer invoices, including entries that are not yet due, based on the statement date. Clicking the value in this field will take you to the Outstanding Customer Invoices report.
Aging, Total Current This column displays the current outstanding amount.
0-30 days This column displays the amount outstanding that is up to 30 days old.
31-60 days This column displays the amount outstanding that is between 31 and 60 days old.
61-90 days This column displays the amount outstanding that is between 61 and 90 days old.
91-120 days This column displays the amount outstanding that is between 91 and 120 days old.
121+ days This column displays the amount outstanding that is more than 120 days old.
DSO This column displays the days of sales outstanding. This is calculated as the sum of individual outstanding balances of entries multiplied by the number of days they are due. The resulting value is then divided by the total outstanding balance.

Limitations

None reported.

Admin Setup

Maconomy Setup

Not applicable for this report.

External Setup

Not applicable for this report.