Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
I
ibexie
July 30, 2022
Solved

Issue with reconciliation numbers not matching

  • July 30, 2022
  • 8 replies
  • 77 views

I'm trying to reconcile my most recent credit card statement, but when I got to the reconciliation screen it says "Your account isn't ready to reconcile" and the "Previous Balance" number is wrong. It doesn't match the beginning balance on my current cc statement, the end balance on my previous cc statement, or even the ending balance on the previous reconciliation report from quickbooks itself. Which of course all match and are the correct number. 

 

It also says "There's a discrepancy because at least one transaction was changed or deleted after it was reconciled." But I don't see any deleted transactions.

 

This is a strange one. For some reason the "Previous Balance" number in the reconciliation window is just wrong. But it's right everywhere else. Any ideas?

Best answer by Emma_P

Why is my beginning balance wrong when I reconcile in QuickBooks Online, and how do I fix a "changed or deleted after it was reconciled" discrepancy?

 

Your beginning balance is off because a transaction that was part of your last reconciliation was later edited, deleted, moved, or unreconciled. It changed that period's ending balance and this period's beginning balance.
That is exactly what the "changed or deleted after it was reconciled" message means. The fix is to open the reconciliation discrepancy report, correct whatever changed until the discrepancy total is zero, and then reconcile.

Find what changed

  1. Go to All apps, then Accounting, then Reconcile.
  2. When QuickBooks flags that the beginning balance is off, select the link to view the transactions that changed since your last reconciliation (the reconciliation discrepancy report).

Correct each item until the discrepancy is zero

  1. If an amount or date was changed, open the transaction and restore it to match your statement.
  2. If a reconciled transaction was unreconciled, open the account register, and in the checkmark column click until it shows R again, then Save.
  3. If a transaction was deleted, recreate it exactly as it was, then mark it reconciled (R) in the register. This is why the fix screen looked empty, since a deleted transaction is no longer in the register.
  4. Confirm the report's total discrepancy difference is 0.00 and that the beginning balance now matches last month's ending balance.

Reconcile again

  1. Enter the correct ending balance and ending date from your statement.
  2. Check off the transactions that appear on your statement, then finish.

If the numbers still won't line up, or you're not sure why a reconciled transaction was changed, it's worth looping in your accountant before making any adjustment, so a real error doesn't get masked. Details: Fix issues with your beginning balance for accounts you've reconciled before.

If your issue turns out to be with the ending balance instead (a mismatch when you're closing out the reconciliation itself, rather than the starting number), see the related article: Fix issues at the end of a reconciliation in QuickBooks Online.

Official sources drawn from:

8 replies

M
MadelynCModerator
Moderator
July 30, 2022

Let’s sort this out, @ibexie.


Most balance issues are caused by an incorrect opening balance, voided, deleted, or modified amount of a previously cleared transaction.


To resolve this, review the opening and beginning balances. Make sure you've entered the correct amount. You can use your actual bank statement to compare the figures. I’m glad to show you the steps:

 

  1. Sign in to your bank's website, or find your bank statement.
  2. Check the account's balance for the same day as the opening balance in QuickBooks.
  3. Compare the two balances.


If they're accurate, check the ending balance you entered. Here’s how:

 

  1. In the Reconciliation window, select Edit info.
  2. Review the Ending balance and Ending date.
  3. Make edits if needed.
  4. When you're done, select Save.


You can also review your account register to ensure everything’s correct and intact. Check out these resources to learn what causes balance issues and how to fix them:

 


If you need to make changes for your completed reconciliation, you can use this article as a reference: Learn the reconcile workflow in QuickBooks. Instructions are located on the bottom part of the page.


Please let me know if you have any other questions or concerns besides reconciliation. I’ll be here to help. Keep safe always!

I
ibexieAuthor
July 30, 2022

Thanks for your reply.

 

I've followed your steps, and I'm still having trouble. The opening balance is correct. But I can't find an "Edit info" button in the Reconciliation Window. When I click "Fix the Issue" in the reconciliation window it takes me a new screen that asks me to correct the transactions above, but there are no transactions above.

 

The fundamental issue is that the closing balance from last month's reconcile (according to the reconcile report) is a different number than the "Beginning Balance" in the Reconcile Window when I try to reconcile this month's statement. What would cause that to happen?

Emma_P
Emma_PCommunity ManagerAnswer
Community Manager
August 6, 2026

Why is my beginning balance wrong when I reconcile in QuickBooks Online, and how do I fix a "changed or deleted after it was reconciled" discrepancy?

 

Your beginning balance is off because a transaction that was part of your last reconciliation was later edited, deleted, moved, or unreconciled. It changed that period's ending balance and this period's beginning balance.
That is exactly what the "changed or deleted after it was reconciled" message means. The fix is to open the reconciliation discrepancy report, correct whatever changed until the discrepancy total is zero, and then reconcile.

Find what changed

  1. Go to All apps, then Accounting, then Reconcile.
  2. When QuickBooks flags that the beginning balance is off, select the link to view the transactions that changed since your last reconciliation (the reconciliation discrepancy report).

Correct each item until the discrepancy is zero

  1. If an amount or date was changed, open the transaction and restore it to match your statement.
  2. If a reconciled transaction was unreconciled, open the account register, and in the checkmark column click until it shows R again, then Save.
  3. If a transaction was deleted, recreate it exactly as it was, then mark it reconciled (R) in the register. This is why the fix screen looked empty, since a deleted transaction is no longer in the register.
  4. Confirm the report's total discrepancy difference is 0.00 and that the beginning balance now matches last month's ending balance.

Reconcile again

  1. Enter the correct ending balance and ending date from your statement.
  2. Check off the transactions that appear on your statement, then finish.

If the numbers still won't line up, or you're not sure why a reconciled transaction was changed, it's worth looping in your accountant before making any adjustment, so a real error doesn't get masked. Details: Fix issues with your beginning balance for accounts you've reconciled before.

If your issue turns out to be with the ending balance instead (a mismatch when you're closing out the reconciliation itself, rather than the starting number), see the related article: Fix issues at the end of a reconciliation in QuickBooks Online.

Official sources drawn from:
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement