A/R Aging Report
An Accounts Receivable Aging Report, or A/R Aging Report, is an accounting document that gives you an overview of outstanding payments from active and inactive accounts and how long they are past due.
Important Information About Customer Balances
Important Information About Customer Balances
The A/R Aging Report shows all balances (in red) and credits (in green) for active and inactive accounts. The report is designed to give an overview of all outstanding payments from customers, so accounts with balances will continue to appear.
To remove an account with outstanding balances from this report, you would need to either settle the balance or deactivate the account. If you believe an account is showing an incorrect balance, you may need to reconcile the account or review the customer's billing history for accuracy.
Follow these steps to create an A/R Aging Report:
Step 1 - Report Page
Select the Reports tab on the left of your Admin portal.
Step 2 - Set Location (if applicable)
Next, if you have multiple Locations AND they each have their own payment account, you can change the Location in the upper-right corner. The report will ONLY be for the transactions associated with the Location/payment account you choose.
NOTE: If your company has multiple Locations, but only uses one payment account, the report will show ALL Locations regardless of which Location you have it on.
Step 3 - A/R Aging Report
Select A/R Aging Reports. NOTE: The only transactions that will show here are for the Location you chose in Step 1.
Step 4 - Adjust Invoice Due Dates (optional)
The A/R Aging Report uses the posted date of either the Invoice or, if the transaction is not on an Invoice, the posted transaction date by default. If you want the Report to use Invoice due dates instead, check the box in the upper left corner.
Step 5 - Select Date/Time Range
Select the clock icon at the top of the screen to select the date range and time you would like the Report to reflect. NOTE: The "Reset to Now" button does not currently work. You will have to manually set the calendar back to today's date.
Step 6 - Print or Download the Report
Print this Report for your records by simply clicking the Print Notices button at the top right-hand side of the screen. You can also download the report as a CSV file by clicking the cloud icon.
Step 7- Manage Billing Histories
Once you have identified which payments are past due, you can easily view each Customer’s billing history by selecting the Account Holder’s name. This will bring you to their Account, where you can select “Billing” and then scroll down to their transaction history.
Step 8 - Send Invoice Reminders
If you want to remind your Customer of their past-due invoices, you have a few options:
Bulk SMS
Using the SMS icon at the top right of the pop-up, you can send a bulk text to every Customer included in the report. Remember to select if you would like to text the Primary Account Holders or both Primary and Secondary Account Holders.
Bulk Email
Select the email icon to copy relevant emails and then paste these emails into a new BCC message within your email account.
Print Past Due Notices
If you prefer to give physical outstanding payment notices to your Customers, select the Print Past Due Notices icon. This will populate two notices per page, which can then be cut in half and delivered.
A/R Payment Report
An Accounts Receivable Payment Report, or A/R Payment Report, is an accounting document that gives you an overview of outstanding payments from Customers in the last three months and the last 12 months.
Step 1 - Reports Page
Select the Reports tab on the left of your Admin portal. Next, select A/R Aging Reports.
Step 2 - Select Date Range
Click the down arrow under "Timeframe" at the top to select the date range you would like the Report to reflect. You can choose between "3 months" and "12 months."
What to View in this Report:
Account Names (Primary and/or Secondary Account Holders)
Contact info - Click the contact info icon to call or email the Account Holder
Payments made in the last 3 or 12 months, depending on the timeframe chosen
Click on the down arrow beside the Payments to see more details
Total current balance (last column)
What to Do in this Report:
Send text messages to everyone on the Report by clicking the SMS bubble
Click the email icon to copy everyone’s email addresses
Export or print the report
Print Past Due Notices to those who have outstanding balances