📝 Overview
The Accounts Receivable (AR) Reconciliation Report pulls outstanding balance data based on invoice date and is designed to be used alongside the Accounts Receivable Report for the most accurate picture of outstanding and updated balances. Because totals on both reports update dynamically — as invoices are edited or balances are paid — this report is best used as a comparative tool rather than a standalone reference.
The Accounts Receivable report will display all clients who have a balance with your business. Statements can easily be emailed or printed right from the report for payment collection.
🎥 Accounts Receivable Overview Video
📈 Accounts Receivable Reconciliation Report
This report provides a summary of payments, invoices and taxes to help you reconcile changes in accounts receivable balance for the selected period. Please note that payments will net out any refunds. Also please note that the date used for data inclusion in this report is the invoice date.
Click the arrow to learn about the Accounts Receivable Reconciliation Report
Click the arrow to learn about the Accounts Receivable Reconciliation Report
Follow the steps below to access the AR Reconciliation Report:
Click Reports
Click Billing
Select Account Receivable Reconciliation
At the top, select Filter to adjust report by date range as needed. Additionally, the top is where you will find the Export option, which allows the report to be downloaded or printed
How This Report Works
The totals on this report will update whenever an open invoice is edited (e.g., items are added or removed on a different day) or when a balance is paid. Clients will no longer appear on the AR reports once payment is made in full, which also causes totals to change over time.
This report is best used in conjunction with the Accounts Receivable Report to compare figures and get the most accurate view of outstanding balances.
💡 An Accounts Receivable Out of Period Sales report is also available to capture items added to invoices outside of the selected date range — helping fill in any gaps in the data.
⚠️ Invoice Date vs. Record Creation Date: Reports that pull data based on invoice date and reports that pull data based on record creation date will not produce matching totals when compared. This is expected behavior — the figures are compiled from different data sources.
📉 Accounts Receivable Report
Use the accounts receivable report to see the total amounts that are currently past due and how far past due these amounts are. Use this information to monitor potential collection issues and to manage your cash flow.
Click the arrow to learn about the accounts receivable report
Click the arrow to learn about the accounts receivable report
If you have any reopened invoices, you will see a warning banner explaining
there are invoices with a reopened status. Until these are posted, you may have difficulty reconciling, as any balances, payments, and overpayment credits may not yet settled. There will be links to a list of the reopened invoices.
First, click Filter on the top to get the date range that is needed.
Once the report is generated, you can use the Statements button on the top header to either Email or Print the statements. Fill out the form with the specific details that need to be applied to the statements and click to Email or Print (dependent on option chosen).
💡 Pro Tip: Client's with credits will appear on this report, with the total credit amount in parenthesis. When filtering the report, selecting At least $1.00 in the Total Due field will remove any client's with credits.
❓Frequently Asked Questions (FAQs)
Find answers to common questions or additional details that may not be covered in the main instructions.
Click the arrow to view frequently asked questions
Click the arrow to view frequently asked questions
Why do the totals on my AR Reconciliation Report keep changing?
Click the arrow to see the answer
Click the arrow to see the answer
Totals update any time an open invoice is edited — such as when items are added or removed on a different date — or when a balance is paid in full. Clients are removed from the report once their balance reaches zero, which also affects the running totals.
Why don't my AR Reconciliation Report and Accounts Receivable Report totals match?
Click the arrow to see the answer
Click the arrow to see the answer
These two reports pull data from different sources. The AR Reconciliation Report is based on invoice date, while other reports may use record creation date. Because the data is compiled differently, the totals will not align — this is expected and not an error.
What is the Accounts Receivable Out of Period Sales report?
Click the arrow to see the answer
Click the arrow to see the answer
This report captures items that were added to invoices outside of the selected date range. It is useful for identifying transactions that may not appear in the standard AR Reconciliation Report due to date filtering, helping ensure a more complete view of outstanding balances.
How do I remove clients with credits from the Accounts Receivable report.
Click the arrow to see the answer
Click the arrow to see the answer
Client's with credits will appear on this report, with the total credit amount in parenthesis. When filtering the report, selecting At least $1.00 in the Total Due field will remove any client's with credits.