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 new Customer Snapshot feature in QuickBooks 2011 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.
If these solutions don't resolve the issue, you can read discussions and post messages and questions relating to your issue on the Intuit QuickBooks Community site for free. You can contact an agent for additional guidance. Fees may apply.