Aged Balances Report - Accounts Receivable

This report prints customer aged balances, including transaction detail. You can determine the output and format of the report by selecting various options before the report runs.

Header Details

• Report process date and time
• Page number

Line Details

• Customer code
• Customer name
• Currency
• Total amount due
• Current period value
• Overdue 1 period value
• Overdue 2 period value
• Overdue 3 period value
• Overdue 4 period value
• Hold value
• Future value
• Branch
• Transaction date
• Transaction type (for example, invoice, receipt, credit note, journal)
• Transaction reference/Customer order number
• Transaction amount
• Currency

The report displays sub-totals depending on the Group by/Print group summary options selected in the Parameters below, and a grand total value is also displayed if the Print listing summary option is selected.

Age By

You can select the aging intervals by selecting a number and period, for example, 1/Months. This determines the intervals that are calculated and displayed on the top right of the parameter form, and those on which the report output will be based. The From/To dates can also be edited if required to report on a date range that differs from Greentree calculated ranges using the Age By parameters.

Future/Past Intervals

You can specify the number of past/future intervals you want to include in the report. The maximum number of intervals is 5, including future and past.

Criteria by transaction branch

If this report option is selected, the Branch Code filter will be using the transaction branch, otherwise the customer's branch is used as standard. If you select this option, the Group by filter is disabled as Branch is assumed to be the default group option.