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

alimartinez · ‎January 04, 2020

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?

FritzF · ‎January 04, 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 R status of the reconciled transaction before making any changes.

Here's how:

In QBO, go to the Accounting menu at the left pane to get to the Chart of Accounts.
Locate the reconciled account, then tick View register under Action column.
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 (R for reconciled, C for cleared, and Blank for not reconciled or cleared).
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!

View solution in original post

FritzF · ‎January 04, 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 R status of the reconciled transaction before making any changes.

Here's how:

In QBO, go to the Accounting menu at the left pane to get to the Chart of Accounts.
Locate the reconciled account, then tick View register under Action column.
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 (R for reconciled, C for cleared, and Blank for not reconciled or cleared).
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!

alimartinez · ‎January 05, 2020

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

chellegirl28 · ‎March 12, 2021

I got ahead of myself and reconciled an account before I should have. I had to delete some transactions and now it is causing issues when I want to reconcile the account again. What do I do to fix it if the transaction needed to be deleted?

My bank statements match with the bank registers but everything is off with the reconciliations.

CharleneMaeF · ‎March 12, 2021

I'm here to ensure your books is accurate, chellegirl28.

If the ending balance of the deleted transaction period caused the issue, I'd suggest reaching out to your accountant. They'll be able to undo the entire reconciliation, then reconcile it correctly. You can also check out this link, https://quickbooks.intuit.com/find-an-accountant/, to find one.

I've also included these articles for more details on how to resolve reconciliation issues:

In case you'll reconcile a transaction by mistake in the future, you can check out this article to learn how to handle them: Undo or Remove Transactions From Reconciliations.

Once the reconciliation is correct, you can view, print or export the report for that session to ensure you'll have a handle for future reference.

I suggest getting back to this thread if you need further assistance in managing your QuickBooks transactions. We're always here to help you.

Topics

Training

Community

Resources

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