Print/Export an A/R Aging Report

Below you will find two different A/R Aging Reports; a printable version and an exportable version.

Exportable A/R Aging

AVSRepVieAR_Aging_-_Excel_v2.AVS

To install the script:

  1. Log in as an Administrator-type user.
  2. Navigate to Administration > Scripts.
  3. Select the Action Menu > Load Installer and point to the script file (AVS) that is attached above.

To export the report:

  1. Navigate to Accounts Receivable > Accounts Receivable Reports.
  2. Highlight the AR Aging - Excel report and click Print.
  3. Select the date to run the report "As of".
  4. Choose the save location and enter a filename for the file that will be exported.
  5. Choose how the report should be aged; by Invoice Date or by Due Date.
    • Navigate to Administration > System Setup > AR & AP Aging to see your default Age By setting.
  6. The export file will be saved and it will automatically open in Excel.

The exported AR Aging will automatically age "By Day" -- If System Setup > AR & AP Aging is set to age "By Month" then the exported version might not agree with the printed version.

Printable A/R Aging

The instructions below are for the standard, printable, A/R Aging Report. If you need an exportable version of this report, download and install the script above.

1. Select the A/R Aging Report

Navigate to Accounts Receivable ➤ Accounts Receivable Reports.

Select the A/R Aging report and click Print.

Select the A/R Aging Report

2. Reporting Options

Specifications

  • Print Aging as of: The cutoff date for receivables included in the report.
  • All Aging Accounts: If you have more than one A/R Aging GL Account you can either select to include all of them in the report or just one specific GL Account.
  • Account Number & Name:
    • If the All Aging Accounts box is unchecked, use these GL Account fields to select a single Accounts Receivable account to include in the report ...
    • ... Or you can enter a Client Deposits GL Account here if you want to print an A/R Aging report that ONLY includes Client Deposits Liability items.
  • Include Deposit Liability Items: Use this setting in conjunction with the All Aging Accounts setting to include Client Deposits along with the typical A/R Aging items. If left unchecked, the report will only consider balance due items posted to the AR Aging asset accounts.

Report Type

  • Detail Aging vs Summary Aging: The Detail Aging report shows each A/R Line Item for each Client. The Summary Aging report shows a total for each Client.
  • Get Selection: Click the Get Selection button to query for a list of Clients to run the AR report on.

Options

  • Age By Invoice Date vs. Due Date: The default selected here is chosen in System Setup: A/R & A/P. Aging with be calculated either on the day after the Due Date or the Invoice Date.
  • Sort By Name vs. Number/Code: The report can be sorted either alphabetically by Client Name or sequentially by Client Number.

If you want to tie out to a single GL Account on the Trial Balance, leave the All Aging Accounts box unchecked and enter a single GL account in the Account Number field.

Reporting Options (single account)

If you want a full analysis of your overall Accounts Receivable, check both boxes; All Aging Accounts and Include Deposit Liability Items.

Reporting Options (all aging accounts)

3. Examples of printed A/R Aging Reports:

A/R Aging Detail Report

A/R Aging Detail Report.

A/R Aging Summary Report

A/R Aging Summary Report.