Is the Accounts Receivable (A/R) balance on your Chart of Accounts (COA) different from the AR balance on your AR reports? Here are some possible reasons and recommended solutions to help you resolve it!
The difference in the (A/R) balance in the COA, Open Invoices, and other reports may be caused by one of the following:
To fix the problem, you need to:
If the reports still do not agree with the COA, proceed to the next solution.
Check the reports again. If they still do not agree with the COA, proceed to the next solution.
Try to resolve data damage on your company file. If the verification detects no problem, run the reports again. If they still don't agree with the COA, proceed to the next solution.
When you have determined year when the discrepancy started, proceed to Step 2.
If there is still a discrepancy, proceed to Step 3.
Once you have completed these steps, 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 Steps 1 and 2 to find and edit the other transactions that are causing the discrepancy.
If the A/R Aging Detail and the Open Invoices report still do not agree with the COA, try to resolve a Balance Sheet out of balance.