Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
AC_Counting
March 12, 2025
Solved

I accidentally clicked Undo Last Reconciliation in QuickBooks Desktop and now the beginning balance is wrong. How do I fix it?

  • March 12, 2025
  • 18 replies
  • 267 views

I have Quickbooks Premier Plus Manufacturing and Wholesale Edition 2023 on my desktop. 

 

I was balancing my February bank statement and accidentally clicked on the Undo Last Reconciliation after I reconciled February. It didn't undo the reconciliation as far as I can tell since the February invoices are showing that they've been cleared on the checkbook, but if I click on Begin Reconciliation again, the beginning balance is incorrect.

 

This is an account that doesn't get much use. We're going to be closing it so there's not much in there. The February beginning balance should be $30.23, ending <$61.25>. After I clicked on the Undo Last Reconciliation, it's now showing a beginning balance for the next reconciliation as <$975.10>. I have NO idea where that number came from because there aren't any reconciliations with that number.

 

When I click on Locate Discrepancies, what pops up is a blank report with no numbers. I've clicked on GOTO, chose both amounts, but it doesn't even find the $30.23 which is right there at the end of January on the checkbook. I don't think the GOTO option is working.

 

How do I fix this?

Best answer by sofiamdc-2341

Don't force an adjustment to make it balance; the wrong beginning balance almost always has a findable cause, and in QuickBooks Desktop it's often a statement-date mismatch after an undo. Since your January report is still correct, the clean fix is to diagnose with the discrepancy report, then undo back to that known-good point and re-reconcile forward, checking the statement date each time.

 

Step 1: Back up, then find what changed

Start by protecting the file and pulling the two reports that show what moved.

  1. Back up your company file first (File, then Back Up Company).
  2. Go to Reports, then Banking, then Reconciliation Discrepancy, choose the account, and review the list of transactions changed since your last reconciliation (note the Entered/Last Modified dates).
  3. Also check Reports, then Banking, then Missing Checks, for anything skewing the balance.
  4. Rule out a stray forced adjustment: go to Edit, then Find, choose Memo, type Balance Adjustment, and select Find. A past forced adjustment is a common source of an unexplained beginning balance like the one you're seeing.

References: Fix beginning balance issues in QuickBooks Desktop and Fix issues when you're reconciling in QuickBooks Desktop.

 

Step 2: Check for a statement-date mismatch (the likely culprit)

QuickBooks Desktop assigns a statement date to each transaction as it clears and calculates the beginning balance from cleared transactions dated before the current statement date, so a prior reconciliation saved with a statement date later than the current one can make the beginning balance look wrong. Review your Previous Reconciliation reports (Reports, then Banking, then Previous Reconciliation) and confirm each statement date is correct. Details: Resolve common issues on the Previous Reconciliation report.

 

Step 3: Undo back to the last correct point, then redo forward

Work backward to your known-good month, clear out old adjustments, then rebuild in date order.

  1. Go to Banking, then Reconcile, and select Undo Last Reconciliation (this reverts the beginning balance to the previous reconciliation's beginning balance).
  2. Undo only back to the last period whose beginning balance was correct (your January).
  3. Before redoing, delete any statement service charges, interest adjustments, and balance adjustments for each affected period from the register, so an old adjustment doesn't distort the redo.
  4. Re-reconcile each month forward, separately and in date order, entering the correct statement date and ending balance for each. Guide: Reconcile an account in QuickBooks Desktop.

Unchecking February's cleared transactions in the register to redo that month is also a valid approach, but run the discrepancy report first so you're fixing the actual cause rather than the symptom.

 

About letting QuickBooks post the difference

Avoid using Enter Adjustment to force it to balance; an adjustment doesn't fix the underlying error and tends to cause problems in later periods. Since this affects prior-period balances, it's worth having your accountant review before making any adjustment (this isn't accounting advice).

 

If you share the correct January ending balance and the statement dates you used for January and February, we can help pinpoint whether a date mismatch is behind that unexpected beginning balance.

 

18 replies

AC_Counting
March 12, 2025

To add to my post above, I went to Reports --> Banking --> Previous Reconciliation, and it shows that the last statement I reconciled was 02/28/25.

 

I'm even more confused.

March 12, 2025

Hello there, @AC_Counting.

 

To correct the beginning balance for your upcoming reconciliation, you'll have to undo the reconciliations back to January 31—the point at which there were no errors in your balances. I will guide you through the steps, and we will determine the reason for the inflated amount that appears after undoing your reconciliation.  


Before adjusting any reconciliations, it's essential to create a backup. This ensures you maintain a recent copy of your accounting records in case of data loss.

 

To undo the reconciliation, please follow the steps below:
 

  1. Go to the Accountant menu, then select Reconcile.
  2. Choose an Account or the Bank to reconcile.
  3. Click Undo Last Reconciliation repeatedly until you reach the last reconciled date without any errors.
  4. Once done, double-check the Beginning Balance from the data to your Bank Statement.
  5. Enter the correct Ending Balance, then click Continue.
  6. You can now resume your reconciliation, starting from February and continuing through to the current date.

 

You've mentioned that your beginning balance appears inflated. It is likely due to transactions from March being incorrectly recorded and reconciled as part of February. Please review the reconciliation and compare it with your bank statement to resolve this issue.

 

When you see a blank report after selecting "Locate Discrepancies" for February, it means there were no changes made to the transactions during that month.

 

Lastly, I've included an article on how to save the settings of your customized report for future use: Create, access, and modify memorized reports.

 

If you need further assistance with the undoing reconciliation, feel free to add comments by utilizing the Reply button below. I'm just a few clicks away to help.

AC_Counting
March 14, 2025

I went to Banking, clicked on Reconcile, the box popped up, clicked on Undo Last Reconciliation, but the "previous beginning balance" of the previous month is wrong as well so I didn't go any further. The previous month was correct initially, but now it's wanting to be incorrect? I don't understand what's going on. 

 

However, I did click on Previous Reports, and January's is showing the correct amount on the display there. 

 

Would it be better to wait until the end of March, have an incorrect beginning balance, a correct ending balance, and let Quickbooks fix the difference? Or is that going to cause an even bigger problem?

 

Should I go into the checkbook and uncheck the transactions that were cleared on the February statement, but would that let me re-do the February reconciliation?

sofiamdc-2341
Community Manager
August 6, 2026

Don't force an adjustment to make it balance; the wrong beginning balance almost always has a findable cause, and in QuickBooks Desktop it's often a statement-date mismatch after an undo. Since your January report is still correct, the clean fix is to diagnose with the discrepancy report, then undo back to that known-good point and re-reconcile forward, checking the statement date each time.

 

Step 1: Back up, then find what changed

Start by protecting the file and pulling the two reports that show what moved.

  1. Back up your company file first (File, then Back Up Company).
  2. Go to Reports, then Banking, then Reconciliation Discrepancy, choose the account, and review the list of transactions changed since your last reconciliation (note the Entered/Last Modified dates).
  3. Also check Reports, then Banking, then Missing Checks, for anything skewing the balance.
  4. Rule out a stray forced adjustment: go to Edit, then Find, choose Memo, type Balance Adjustment, and select Find. A past forced adjustment is a common source of an unexplained beginning balance like the one you're seeing.

References: Fix beginning balance issues in QuickBooks Desktop and Fix issues when you're reconciling in QuickBooks Desktop.

 

Step 2: Check for a statement-date mismatch (the likely culprit)

QuickBooks Desktop assigns a statement date to each transaction as it clears and calculates the beginning balance from cleared transactions dated before the current statement date, so a prior reconciliation saved with a statement date later than the current one can make the beginning balance look wrong. Review your Previous Reconciliation reports (Reports, then Banking, then Previous Reconciliation) and confirm each statement date is correct. Details: Resolve common issues on the Previous Reconciliation report.

 

Step 3: Undo back to the last correct point, then redo forward

Work backward to your known-good month, clear out old adjustments, then rebuild in date order.

  1. Go to Banking, then Reconcile, and select Undo Last Reconciliation (this reverts the beginning balance to the previous reconciliation's beginning balance).
  2. Undo only back to the last period whose beginning balance was correct (your January).
  3. Before redoing, delete any statement service charges, interest adjustments, and balance adjustments for each affected period from the register, so an old adjustment doesn't distort the redo.
  4. Re-reconcile each month forward, separately and in date order, entering the correct statement date and ending balance for each. Guide: Reconcile an account in QuickBooks Desktop.

Unchecking February's cleared transactions in the register to redo that month is also a valid approach, but run the discrepancy report first so you're fixing the actual cause rather than the symptom.

 

About letting QuickBooks post the difference

Avoid using Enter Adjustment to force it to balance; an adjustment doesn't fix the underlying error and tends to cause problems in later periods. Since this affects prior-period balances, it's worth having your accountant review before making any adjustment (this isn't accounting advice).

 

If you share the correct January ending balance and the statement dates you used for January and February, we can help pinpoint whether a date mismatch is behind that unexpected beginning balance.