Accountants · problem and fix
QuickBooks reconciliation difference not zero: causes and fixes on Mac for accountants
If your QuickBooks reconciliation difference will not reach zero, check three numbers first: the statement end date, the ending balance and the opening balance. A stuck difference usually traces back to one of a few causes, and each one has a clear check. This guide covers those causes, the fixes you can do yourself, and where Lazur helps and where it does not.
The short answer
- Check the statement end date, ending balance and opening balance before anything else.
- Run Reports > Banking > Reconciliation Discrepancy to see which cleared transactions changed.
- A difference divisible by 9 often points to swapped digits, such as $202.00 typed for $220.00.
- Back up, then undo the reconciliation and redo it, or run a Special Reconciliation, before you plug.
- Use Enter Adjustment or a suspense account only as a last resort, with a written reason.
What reconciliation difference not reaching zero costs you
Time that does not bill
No study on this topic measures how many hours a stuck reconciliation costs, so this page does not put a number on it. What you can see is the cost of waiting. The close slips, the client waits, and the next account waits behind this one.
A wrong balance in front of a client
A difference you cannot explain is a risk to the balance sheet. A plug can hide an error that reaches the reports your client or lender reads. Xero's accountant guide says even a small difference signals that something was missed.
Errors that carry forward
The start point of a reconciliation is last month's work. A wrong opening balance moves into every later month. Panko's review of spreadsheet research describes spreadsheet errors as common and non-trivial. That research covers spreadsheets in general, not reconciliations.
Strain on the team
Accounting Today reports on ICPAS's Righting Retention survey. It ranks too many hours and burnout as the second most-cited reason for leaving accounting jobs. The survey does not give a percentage. A stuck reconciliation adds to that load, but the survey does not measure it.
Why it happens
Wrong statement end date or ending balance
The statement has an end date, and QuickBooks pulls transactions up to that date. If you pick the wrong date, you pull in the wrong items. Sage's knowledge base lists the end balance against the statement as the first thing to check. Read the ending balance from the statement PDF, cents included, and compare it with what you entered.
Opening balance does not match last reconciled
The opening balance should equal the balance on your last reconciled statement. If it does not, the error is in an earlier month. Redmond Accounting warns that an incorrect opening balance creates a difference that is impossible to close without a fake adjustment. Fix the earlier period instead of this one.
Bank fees or interest not posted
The bank charges a fee or pays interest, and the statement shows it. The books never recorded it, so the cleared balance is off. Sage lists bank charges or interest not posted as adjustments as a separate check. Post the item, then reconcile again.
Missing, duplicate or mis-grouped transactions
A deposit might be entered twice. A check might never be recorded. A batch deposit might be entered as separate lines while the bank shows one total. Sage lists matched transactions that are missing, duplicated, differ in value, or are grouped incorrectly. Xero adds that delayed bank feeds can make transactions look missing.
Wrong amount, often swapped digits
A typed amount can be off by a swap, such as 220 typed as 202. Redmond calls a difference divisible by 9 a classic sign of a transposed digit. The check does not prove the cause, but it tells you where to look first. Open the entries and compare each amount with its source document.
Reconciled transactions changed later
A cleared item can be edited, deleted or voided after you reconciled it. The difference then shows up in a later month, where it is hard to trace. Intuit's Reconciliation Discrepancy report flags reconciled transactions that were later modified, deleted or voided. Run it before you guess.
How to fix it
These work with or without any app.
Confirm the statement balance with the bank
Xero advises confirming that the statement balance matches the bank before you investigate. Use the bank's own statement or portal, not a forwarded copy. If the number differs, stop and get the right statement first. Investigating against the wrong number wastes time you cannot get back.
Check the end date, ending balance and opening balance
Confirm the statement end date and the ending balance, cents included. Then compare the beginning balance QuickBooks shows with your last reconciled statement. Intuit's Mac steps start with the beginning balance, then the ending balance, then matching items.
Run the Reconciliation Discrepancy report
Go to Reports > Banking > Reconciliation Discrepancy, choose the account, and select OK. Intuit says the report lists transactions changed since the last reconciliation. For each row, fix or re-enter the transaction, undo the previous reconciliation, or let QuickBooks post an offsetting adjustment.
Test the divisible by 9 rule
Divide the difference by 9. If it divides evenly, search the account for a transposed amount. Scroll the register for entries with swapped digits, and compare each one with its source document. Fix the amount, then reconcile again.
Undo the reconciliation, then reconcile again
Back up the company file first. Then undo the reconciliation from the one with the discrepancy forward, and reconcile again after the fix. QuickBooks Pro users can reach only the most recent previous reconciliation. The Mac menu path for Undo Last Reconciliation is not confirmed here, so check the Banking menu for your version.
Use a Special Reconciliation for affected items
If undoing everything is too heavy, Intuit's Mac article describes a Special Reconciliation that covers only the affected transactions. Use it after you have fixed the cause. Keep a note of which transactions you included, so the next reconciliation is easy to trace.
Last resort: a documented adjustment
If the cause stays hidden, an adjustment can close the period. Intuit's Enter Adjustment posts a journal entry to a special expense account. Sage can post to suspense code 9998 and recommends checking with an accountant if you are unsure. Write the reason, the amount and the date you plan to reverse it.
Your QuickBooks reconciliation shows a difference, and it will not go to zero no matter how many times you match items. That is frustrating, and it is also a clue. The difference is the gap between what the bank says and what your books say, once you have marked items as cleared. Something on one side is wrong, missing, or in the wrong place. The causes are well known, and the checks are fast.
Why a QuickBooks difference stays put
QuickBooks starts from the opening balance. It adds the items you mark as cleared, then compares the result with the statement's ending balance. The difference is whatever is left over. A wrong starting point leaves the same gap in every month. A single wrong amount on a cleared item leaves a gap equal to that error.
Redmond Accounting uses a simple case. The statement shows $220.00, but the books show $202.00 after the cleared items. The difference is $18.00. That amount divides evenly by 9, which Redmond calls a classic sign of a transposed digit. Swap two digits, and the gap becomes a multiple of 9.
Check the three numbers before anything else
Start at the top of the reconciliation window. Run these three checks in order. Each one takes a minute, and each one rules out a group of causes.
- Statement end date: confirm the end date you entered matches the date printed on the statement PDF.
- Ending balance: type the ending balance exactly as the statement shows it, cents included, not from memory.
- Opening balance: compare the beginning balance QuickBooks shows with the balance on your last reconciled statement. If they differ, the problem sits in an earlier month.
Xero's accountant guide gives a similar first step. It says to confirm the statement balance matches the bank before you investigate. Use the bank's own figure, not a copy someone forwarded. Xero also notes that delayed bank feeds can make transactions look missing. Wait, then check the feed again before you add anything.
The causes that come back again and again
Bank fees and interest are an ordinary cause. The statement shows a fee or interest, but nobody posted it in the books. Sage's knowledge base lists unposted bank charges and interest as a separate check. Post the item as an adjustment, then reconcile again.
Missing and duplicate transactions come next. A deposit may be entered twice. A check may never have been recorded. Sage also flags matched items that differ in value or are grouped incorrectly. A batch deposit that appears as one bank line must match the books as one line.
A reconciled transaction can change after you reconcile it. Someone edits the amount, deletes the entry, or voids a check. The difference then appears in a later month, where it is harder to trace. Intuit's Reconciliation Discrepancy report flags reconciled transactions that were later modified, deleted or voided. Run it first.
Find the cause in QuickBooks Desktop for Mac
Start with a backup. Intuit's beginning-balance steps say to back up the company file before you undo anything. Then use the reports below. The menu names come from Intuit's help articles for QuickBooks Desktop for Mac Plus. Check them against your version, because menus change between releases.
- Back up the company file before you change any reconciliation.
- Open Reports > Banking > Reconciliation Discrepancy, choose the account, and select OK.
- Open Reports > Accountant & Taxes > Audit Trail to trace changes to cleared transactions.
- Open Edit > Find > Advanced and search the memo for Balance Adjustment, if an earlier reconciliation posted one.
- Open Reports > Banking > Previous Reconciliation to see the last reconciled period. Pro users can reach only the most recent one.
Write down what each report shows before you change anything. Record the dates, amounts and names of the flagged rows. That list makes the fix faster. It also gives you a record if someone asks later why the month changed.
Fix it without a plug
Once you find the cause, fix the entry first. Then pick one route. The first route undoes the reconciliation from the one with the discrepancy forward, then reconciles again. The second route is a Special Reconciliation that covers only the affected transactions. Intuit's Mac article lists both.
Undo has limits. Intuit's beginning-balance article says QuickBooks Pro users can reach only the most recent previous reconciliation. The exact Mac menu path for Undo Last Reconciliation is not confirmed here. Look in the Banking menu for your version, and check Intuit's help for your release if it is not where this page says.
When a plug is the only option
Sometimes the cause stays hidden. The error may come from a bank, or from a month that is too old to rebuild. Then you may need an adjustment to close the period. Vendors handle that differently. Intuit's Enter Adjustment posts a journal entry to a special expense account. Sage can post to suspense code 9998, which it says temporarily corrects the balance.
Redmond Accounting suggests a different route for a suspected bank error. It uses a journal entry to a wash account, and that entry should be reversed once the bank corrects its error. Whatever you choose, write down the amount, the reason and the date you plan to reverse it.
A worked example from start to finish
Here is the transposition case from start to finish. The statement ending balance is $220.00. The cleared balance in the books is $202.00. The difference is $18.00. Because $18.00 divides by 9, you look for a swapped amount first. You find an entry typed as $202.00 that should read $220.00.
| Item | Amount | What to do |
|---|---|---|
| Statement ending balance | $220.00 | Confirm against the bank PDF |
| Cleared balance in QuickBooks | $202.00 | Find the entry with swapped digits |
| Difference | $18.00 | Divisible by 9, so check for transposition |
Fix the amount, then check the difference again. It should now read zero. If it does not, you have a second cause. Run the discrepancy report again and repeat the three checks at the top of this page.
Mistakes that make a difference worse
- Plugging the difference on the first try, before you find the cause.
- Changing the statement ending balance so it matches the books.
- Reconciling again without undoing the earlier reconciliation first.
- Ignoring a small difference. Xero says even a small one signals that something was missed.
- Skipping the backup before you undo anything.
- Working from a copy of the statement instead of the bank's version.
Bank statements hold client account data. Follow your firm's rules on client data before you paste a statement into any tool, including Lazur. Remove account numbers when your rules ask for it. If you are not sure what the rules allow, ask your employer before you share anything.
QuickBooks Online and Xero use different menus
The same causes show up in QuickBooks Online and Xero. The menu names and report names are different. Redmond's troubleshooting article is written for QuickBooks Online, and its divisible-by-9 check works in any product. Xero's accountant guide covers timing differences, missing entries, bank fees, and wrong amounts or accounts.
QuickBooks Online menu paths are not verified on this page. Check the help article for your product before you follow a menu path. The checks in this guide apply to each product, even when the buttons differ.
Keep the difference from coming back
Xero recommends a written policy for how long items may stay open before escalation. It also suggests senior sign-off on higher-risk reconciliations, and locking the period once balances match. Those habits stop a small gap from living for months.
If you track open items in Excel, add a check cell. Subtract the cleared total from the statement balance, and format the result so zero is easy to spot. Panko's review of spreadsheet research says spreadsheet errors are common and non-trivial. A check cell will not fix a bad entry, but it shows the gap early. For more on working in Excel, see Excel for accountants on Mac.
Where Lazur fits, and where it does not
Lazur is a voice assistant for the Mac. Hold ⌥ ⌘ to ask about anything on screen, and Lazur answers out loud. Ask where a menu item lives, and Lazur circles it and labels it. Ask it to guide you through a step, and it walks you one click at a time, waiting for each click.
Lazur does not click buttons for you, and it does not edit your QuickBooks file. It is not an add-in for QuickBooks or any other app. Its best use here is the reading part of the job. Ask what a flagged row means. Hold fn to dictate notes into the file. Ask it to draft a request to the client, then edit the draft and send it from your own mail app.
Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and they are not stored. Content is never used to train AI models. The 3-day Pro trial needs no credit card, and details are on the pricing page. Those facts do not replace your firm's rules on client data.
What to gather before you call support
- Your QuickBooks product and version, such as QuickBooks Desktop for Mac Plus or QuickBooks Online.
- The statement PDF, with its end date and ending balance.
- The exact difference, including cents.
- The output of the Reconciliation Discrepancy report, saved or printed.
- A short list of what you already checked, in the order you checked it.
A short list like that saves time with support or a colleague. It also stops you from repeating a check you already ran. If the difference is still open after all of this, you have a clear record to hand to the person who signs off.
Faster with Lazur
Where Lazur helps with reconciliation difference not reaching zero
Hold ⌥ ⌘ and say what you want. Lazur sees your Chrome window. Lazur draws a circle and a label around the button or menu you need.
- 1
Hold ⌥⌘ and talk
- 2
Lazur draws a circle and a label around the button or menu you need.
- 3
You stay in Chrome. Nothing to copy into a chat window.
More things to say in Chrome
- “Where is the Reconciliation Discrepancy report?”
- “Walk me through undoing the last reconciliation, one click at a time.”
- “Explain what this flagged row means.”
- “Draft a note asking the client for the statement PDF.”
- “Research the reconciliation help for my QuickBooks version.”
- “Remind me Friday to recheck the statement.”
Free for 3 days, then $18/month. Download for Mac
You say“Where is the Reconciliation Discrepancy report?”
Lazur · points at itLazur circles the Reconciliation Discrepancy item under Banking and labels it. It says the menu path out loud, then waits while you make the click.
What accountants say to Lazur for this
Each one is a single hold of ⌥ ⌘.
“Where is the Reconciliation Discrepancy report?”
Lazur circles the menu item on your screen and labels it. It does not click for you.
Points at it
“Walk me through undoing the last reconciliation, one click at a time.”
Lazur guides you one click at a time and waits for each click before it moves on.
Walks you through it
“Explain what this flagged row means.”
Lazur answers out loud and explains what the flagged change could be.
Explains what's on screen
“Draft a note asking the client for the statement PDF.”
Lazur types a draft you can edit, then you send it from your own mail app.
Drafts it
“Research the reconciliation help for my QuickBooks version.”
Lazur runs the search in its own Chrome tabs and returns a summary and a report.
Researches in the background
“Remind me Friday to recheck the statement.”
Lazur adds the reminder to Apple Reminders.
Handles the small stuff
“Dictate my notes for the client file.”
Hold fn to dictate clean text at the cursor, in any app.
Types what you say
A plan you can start this week
- Day 1
Confirm the three numbers
Pull the statement PDF from the bank. Check the end date, ending balance and opening balance against QuickBooks. Write the three numbers in the file before you change anything.
- Day 2
Run the discrepancy report
Run Reports > Banking > Reconciliation Discrepancy for the account. Note the date and amount of each flagged row. Save or print the output so you can refer back to it.
- Day 3
Check swapped digits and bank items
Divide the difference by 9. Scroll the register for swapped amounts. Check the bank statement for fees and interest that never reached the books. Post anything you find, then recheck the difference.
- Day 4
Undo and reconcile again
Back up the company file. Undo the reconciliation from the affected month forward, then reconcile again. If you can reach only the latest previous reconciliation, note that limit in the file.
- Day 5
Escalate what you cannot explain
If the difference stays, write down every check and its result. Send the file to your senior with the statement, the report output and your list. Ask for sign-off before anyone posts a plug.
Questions people ask
Why does my QuickBooks reconciliation difference stay the same after I recheck the statement?
The statement may be right, and the starting point may be wrong. Compare the opening balance with your last reconciled statement. A wrong starting point leaves the same gap every month, so fix the earlier period instead of this one.
What does a difference divisible by 9 mean?
Redmond Accounting calls it a classic sign of a transposed digit. An example is $202.00 typed for $220.00, which gives an $18.00 difference. It is a clue, not proof. Open the entries and check each amount against the source document.
Can I enter an adjustment to make the difference zero?
You can, but treat it as a last resort. Intuit's Enter Adjustment posts a journal entry to a special expense account. Sage uses suspense code 9998 and recommends checking with an accountant if you are unsure. Write down the reason and the date you plan to reverse it.
Where is the Reconciliation Discrepancy report on a Mac?
In QuickBooks Desktop for Mac, go to Reports > Banking > Reconciliation Discrepancy. Choose the account, then select OK. The report lists transactions changed since your last reconciliation.
Will undoing a reconciliation affect my transactions?
Back up the company file before you undo anything, because Intuit's steps say to back up first. Then review the transactions in the account before you reconcile again. Exactly what changes on undo is not verified here, so check Intuit's help for your version.
Does Lazur fix the reconciliation for me?
No. Lazur does not click buttons or operate QuickBooks for you. It can circle a menu item, explain a flagged row, guide you one click at a time and draft a note to your client. You still make the changes.
Is this the same in QuickBooks Online or Xero?
The causes are the same, but the menus differ. Check the help article for your product before you follow any menu path on this page.
Sources
- Reconcile accounts in QuickBooks for Mac · Intuit · checked 2026-11-08
- Reconciliation Discrepancy · Intuit · checked 2026-11-08
- Fix beginning balance issues in QuickBooks Desktop · Intuit · checked 2026-11-08
- Fix a bank reconciliation difference that isn't zero · Sage (UK Knowledge Base) · checked 2026-11-08
- Troubleshooting Reconciling in QuickBooks Online · Redmond Accounting · checked 2026-11-08
- How to master bank reconciliation for your accounting practice · Xero · checked 2026-11-08
- Illinois CPAs spot numerous issues with accountant retention · Accounting Today · checked 2026-11-08
- Spreadsheet Errors: What We Know. What We Think We Can Do · arXiv (Raymond Panko) · checked 2026-11-08
Fix reconciliation difference not reaching zero with Lazur, free for 3 days
Hold a key and ask. Lazur sees your screen, points at the button and talks you through it, in any Mac app. No credit card.