Skip to main content
January 4, 2020
Solved

How do I fix my ending balance after I reconciled a month?

  • January 4, 2020
  • 1 reply
  • 0 views

I reconciled November and realized I made an error in a payment to a contractor which I log as an expense after the fact. When I realized the overpayment error, I adjusted the expense. Now, I'm trying to go in to reconcile December and I'm getting an error that I cannot reconcile because my account isn't ready to reconcile yet, since my beginning balance is now off by the amount I corrected. How do I adjust the ending balance in November, so that I can proceed to reconcile December?

Best answer by AlcaeusF

Welcome to the Community, @alimartinez.

 

In QuickBooks Online (QBO), changing or adjusting a reconciled transaction will affect your beginning balance for the next reconciliation. To fix this, you need to remove the status of the reconciled transaction before making any changes.

 

Here's how:

 

  1. In QBO, go to the Accounting menu at the left pane to get to the Chart of Accounts.
  2. Locate the reconciled account, then tick View register under Action column.
  3. Find the expense transaction, then in the reconcile status column (indicated by a checkmark), repeatedly select the top line of the transaction to change the status (for reconciled, for cleared, and Blank for not reconciled or cleared). 
  4. Hit Save.

 

Once the status is Blank, you can now make the necessary changes. To reconcile it again, follow the same steps above and change the status back to R. After that, continue to reconcile December.

 

Just in case, I'll add these articles for future reference:

 

 

I want to make sure everything is taken care of for you, so let me know if you have any other issues or concerns by leaving a comment. I'm always happy to help. Have a great weekend!

1 reply

AlcaeusF
AlcaeusFAnswer
January 4, 2020

Welcome to the Community, @alimartinez.

 

In QuickBooks Online (QBO), changing or adjusting a reconciled transaction will affect your beginning balance for the next reconciliation. To fix this, you need to remove the status of the reconciled transaction before making any changes.

 

Here's how:

 

  1. In QBO, go to the Accounting menu at the left pane to get to the Chart of Accounts.
  2. Locate the reconciled account, then tick View register under Action column.
  3. Find the expense transaction, then in the reconcile status column (indicated by a checkmark), repeatedly select the top line of the transaction to change the status (for reconciled, for cleared, and Blank for not reconciled or cleared). 
  4. Hit Save.

 

Once the status is Blank, you can now make the necessary changes. To reconcile it again, follow the same steps above and change the status back to R. After that, continue to reconcile December.

 

Just in case, I'll add these articles for future reference:

 

 

I want to make sure everything is taken care of for you, so let me know if you have any other issues or concerns by leaving a comment. I'm always happy to help. Have a great weekend!

January 5, 2020

Thank you! All fixed now and December has been reconciled!