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_v4.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 Excel file.
  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. Select the GL accounts to include. This list will include any account with the Setup Type of A - AR Aging or L - Client Deposits.
  7. The 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.