AR02 — Aged Trial Balance

Operational Reports > Accounts Receivable

Who would use this report?

Finance and accounts receivable staff

What is in this report?

ar02Accounts receivable values in historical ageing buckets by invoice date or due date, including retrospective.

Recalculates ageing from transaction level dates.

When you run this reportA set of data deliberately laid out to communicate business information. Depending on the context, 'report' may refer to report specification or report output. Report (more precisely, report specification) is the generic term for the objects created or edited in Cognos Analytics. Pronto Xi Business Intelligence offers a suite of standard reports. as a summary, in addition to displaying the relevant data, the report displays a value for each bucket with a percentage of the total. You can drill on each bucket's value for any given customer to see a detailed viewA set of data connected to a cube, deliberately laid out to communicate business information. of that data.

This report includes both summary and detail options and is generated by aggregating the transactional data. If you have purged pxiPronto Xi transactions through the History settings, this report will not return complete values - it will not reconcile with the General Ledger, either current or retrospective.

How do I use it?

Select Summary or Detail to view the summary or detail version of the report.

Sort options:

• Display by — sortArrange elements of a list in a certain order. The most-used orders are numerical order and lexicographical order. the report by Customer Code, Customer Territory, Customer Rep, or Customer Type

• Rank By — sort, in each group, in alphabetically ascending or descending order, or by the total amount ascending or descending

FiltersSelectively remove data from view. include:

• Period Selection — run the report for any period from the beginning of the time dimensionA broad grouping of data about a major aspect of a business, such as products. A dimension provides the context of a fact and is used in queries to group related facts together. In Analytics Dashboards, a dimension provides a perspective of a DMR Schema. Dimensions tend to be discrete and are often hierarchical. A dimension can contain one or more hierarchies. For example, Product Name, Style, Colour, Size. to the current Accounts Receivable period and forward 11 periods

• Age Report by — display the report by either Invoice Date or Due date

• Balance selection — filter the values in the Amount column

• Account Balance Range — enter a range of account balance ranges on which to report, based upon the total for the supplier

• Customer — search by customer code, customer keyword, or customer code range

• Show Foreign/Mirrored Currency Values — display or hide foreign or mirrored currency values

• Select Mirrored Currency — select the mirrored currency to display

• Show Transacted/Customer Currency Values — specify whether to show or hide the transacted (customer) currency values

Other filters include Rep, Territory, Customer Type, Customer Status, and Ageing Buckets to display — select one or more ageing buckets to display.

What can I do in the report?

You can switch between the summary and detail versions of the report.

You can sort by Display by and Rank By.

You can filter by Period Selection, Age Report by, and Balance Selection.

You can click the Name links to drill to more detail in pxiPronto Xi.

You can click any other links in this report to drill to the AR02D1 - Aged Trial Balance - Detail report to analyse the data.