The accounts receivable (A/R) balance on the Chart of Accounts (COA) does not match the A/R balance on the A/R Aging Detail or Open Invoices report.
There are several causes for this issue:
To correct different settings:
To correct rebuilt names:
To repair damaged links or data:
To find and fix Transactions that do not have a Customer/Job name assigned:
Once you have completed these you can compare the Balance Sheet Standard and A/R Aging or Open invoices reports to verify whether these totals now match. If you still find a discrepancy between the reports use the Balance Sheet by Year and Aging Summary to determine the next year of the discrepancy and repeat Sections II and III of these steps to find and edit the other transactions that are causing the discrepancy.
To compare Open Invoice reports:
To compare the Open Invoice Report to the Customer Balance Summary:
If the A/R Aging Detail and the Open Invoices report still do not agree with the COA, your next step is to troubleshoot the cash-basis balance sheet.
Note: The Customer Snapshot feature helps you manage customer accounts. You can use it to assess your customers' average days to pay, outstanding balance and credits, and purchase history, which lets you make timely decisions about customer requests.