When Accounts Receivable Balances Do Not Match Reports in QuickBooks Desktop
QuickBooks Desktop users in French Canadian files see AR in the chart of accounts differ from AR reports. We explain the causes and the accepted fixes.
Quickbooky.com has fielded a recurring complaint from QuickBooks Desktop readers working in French Canadian company files. The accounts receivable balance shown in the chart of accounts does not agree with the balance in the accounts receivable reports. The number on the balance sheet seems to live in one place, while the aging and open invoice figures live in another. The gap is not always a sign of bad data, though it can be. The accepted answer for this issue walks through a sequence of checks that moves from simple report settings to a repair pass.
Symptoms we hear about
The most common report we receive is a side-by-side mismatch. A reader opens the chart of accounts, notes the accounts receivable total, then opens an AR aging report or an open invoices report. The totals do not match. Sometimes the discrepancy appears only when a date range is set to something other than all dates. In other cases the chart total looks right but the aging detail is short by a few old invoices. Some readers also see a balance summary that includes an amount missing from the detail report.
Common causes of the mismatch
A mismatch between the chart of accounts and the AR reports usually comes from one of four areas. The first is report settings. Two reports can use different date baselines, aging methods, or opening balance options. The second is rebuilt names. A rebuilt name is an entry QuickBooks could not place in a standard name list, so the software keeps it aside. These entries can hold balances that do not flow through normal customer reports. The third is damaged links or damaged data in the company file. The fourth is transactions that lack a customer or project name.
Align the report dates and settings first
The accepted solution begins with two reports. Run the Accounts Receivable aging detail report with the date range set to All. In the customization options, set the report date option to Report Date. Then run the Open Invoices report, also with All dates, and change the opening balance or aging option to Report Date. Put both reports on screen at the same time using the multi-window view and tile them vertically. Compare the totals line by line. If both reports now agree with each other but not with the chart of accounts, the issue is likely in a name list or in the file data rather than the report settings.
Look for rebuilt names and missing customer details
After the report settings are consistent, the next area to inspect is the Other Names list. Re-sort the main name list, the chart of accounts, and the item list. Then open the Other Names list and look for entries with a number and a rebuilt marker. If you find one, open a quick report for that name to see what type of account it should belong to, then change the name type so it moves to the proper list. This matters because a rebuilt name can store an AR balance that the standard customer reports do not pick up.
Also check for transactions that have no customer or project name. A payment, invoice, or credit memo that carries only a project name or no name at all can sit outside the customer balance summary. Find these transactions and assign the correct customer or project so they land in the right aging bucket.
Compare the open invoice and balance summary views
Once names are corrected, compare the Open Invoices report to the customer balance summary. The open invoices report should show the detail behind each unpaid balance, while the customer balance summary shows the total by customer. If a customer total does not match the invoices listed under that customer, inspect that customer’s transactions for credits, discounts, or overpayments that may not appear where expected.
When file damage is the likely cause
QuickBooks Desktop can develop damaged list links or transaction links. The accepted guidance is to run the built-in data verification and repair routine on the company file. If verification reports no problem, the next move is to examine the rebuilt names and missing customer or project names more closely. The AR balance mismatch often disappears after the file is repaired and the lists are re-sorted.
What usually brings the balances back
Readers who resolve this issue usually start with the report settings rather than the file. In many cases, the two reports simply used different date baselines. Changing both to Report Date makes the totals line up. When the mismatch survives that adjustment, a rebuilt name or a transaction with a missing customer name is the next most common culprit. File repair clears the remaining cases. The accepted solution treats the chart-of-accounts balance as the reference point, then works outward until the reports agree.