How to Run and Review the Aging Summary by Account Report

The Aging Summary Report provides an overview of accounts or clients that are overdue on payments. It details the outstanding amounts and the number of days each account/client is past due. It’s recommended to run this report on your payment processing date and to check it regularly until all outstanding balances are cleared and the account/client is removed from the list.

  1. In ARC, select the Reporting page found in the Menu on the left side of the screen. 
  2. Under “Choose a Report” select Aging Summary By Account in the drop down menu.
  3. Under “Filter By” select Magazine in the drop down menu
  4. Under “Name” select the name of your Publication in the dropdown menu
  5. Click “Display”.
  6. The names of accounts or clients with outstanding invoices will appear in the report box in blue letters. The cause of the missed payment may appear in parenthesis next to the account name
    1. Examples: Account Name (declined card), Account Name (expired card), Account Name (payment error)
    2. Accounts or clients that do not show a cause listed in parenthesis next to the name are invoiced and pay by method other than a credit card
  7. The amount owed by the account or client will be displayed in the column or columns indicating the number of days they are past due.
  8. The total combined amount of past due days will be shown at the end of each row in the last column for the specific account or client.
  9. The total combined amount for all accounts or clients regarding the number of days past due will be shown at the bottom of each past due column in the report box.

00:00: This guide will explain the Aging Summary by Accounts report in ARC

00:05: The Aging Summary report provides an overview of accounts or clients that are

00:09: overdue on payments.

00:10: It details the outstanding amounts and the number of days

00:14: each account is past due.

00:15: It’s recommended to run this report on your payment processing date and to check it

00:20: regularly until all outstanding balances are cleared and the account is removed from

00:25: the list.

00:25: This is an example of a clean report with no aging accounts.

00:31: In ARC, click on the Reporting tab on the left hand side.

00:35: From the drop down menus, select the Aging Summary by Account report, filter

00:40: by Magazine and select your

00:42: magazine. Click display to run the report.

00:45: The names of accounts with outstanding invoices will generate. The cause of the

00:49: missed payment may appear in parenthesis next to the account name such as declined

00:54: or expired card.

00:56: If there is not a cause listed this indicates the account pays by invoice or with a

01:01: method other than a credit card

01:03: If there is not a cause listed this indicates the account pays by invoice or with a

01:08: method other than a credit card.

01:10: The past due amount for each account will appear in the column showing

01:14: how many days it's overdue. The total overdue amount for each account will be listed

01:19: in the last column of that row. At the bottom of the report,

01:22: the total past due amount

01:24: for all accounts will be shown for each column of overdue days.

01:29: This guide covered steps to navigate and utilize the Aging Summary by Account

01:33: Report in ARC.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us