Accounts Receivable Summary ReportLast updated on 03/22/2022
Purpose of the Accounts Receivable Summary Report:
This report provides a summary of customers who have outstanding balances with aging information.
Common uses for this report:
Use this report to identify the customers whose payments are past due.
How to find this report:
Click Reports > Search [Accounts Receivable Summary] > Click the report name. Then you will be able to set filters and run the report.
Filter by business unit. This report can be run by a single business unit or all business units.
Filter by status. This report can be run by posted, exported, or all invoices.
Select the checkbox to ignore deposits.
Include pinned customer notes
Select the checkbox to ignore pinned customer notes.
View or download the report
Click Update to view the report.
The report can be downloaded in three different formats:
Export to Excel (.xlsx) (click the dropdown arrow next to Download PDF)
Export to Comma separated (.csv) (click the dropdown arrow next to Download PDF)
Export to Excel (Allow Long-Running) (click the dropdown arrow next to Download PDF)
You can print statements by location from the report. Click Print Statements to view the statements.
Explanation of report columns
The report includes the following columns:
The Bill To customer name on the invoice.
The Bill To customer phone number on the invoice.
The outstanding balance for a customer.
(Report columns continued)
< = 30
Outstanding balance for less than or equal to 30 days.
Outstanding balance for 31 to 60 days .
Outstanding balance for 61 to 90 days.
Outstanding balance for 91-120 days
Outstanding balance for greater than 120 days.
Explanation of report totals:
Balance is calculated by taking the sum of the entire column.
Current is calculated by taking the sum of all Current outstanding balances.
Passed 30 is calculated by taking the sum of all Passed 30 outstanding balances.
Passed 60 is calculated by taking the sum of all Passed 60 outstanding balances.
Passed 90 is calculated by taking the sum of all Passed 90 outstanding balances.
Passed 120 is calculated by taking the sum of all Passed 120 outstanding balances.
Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.
Disclaimer: Information provided in this article is for informational purposes only and it should not be construed to be legal advice. Information provided in this article may also not constitute the most up-to-date legal or other information. You should not act or refrain from acting on the basis of any information in this article to meet any compliance requirements without seeking independent legal or other professional advice.