Skip to main content
B
Brea4
September 29, 2021
Solved

How to fix a reconciled transaction

  • September 29, 2021
  • 4 replies
  • 0 views

How do i fix a reconciled transaction in QBO 

I need to change what account i put it under

Best answer by Catherine_B

Hi there, Brea4.

 

Editing reconciled transactions can cause discrepancies on your previous and next reconciliation balances balance. I suggest reaching out to an accountant so they can help you manage the reconciled transaction so it won't mess up your books. 

 

If you need to edit the transaction, you can follow these steps: 

 

  1. Click Accounting.
  2. Go to the Chart of Accounts tab.
  3. Select the bank account, then click View register.
  4. Look for the transactions and check if you can see R in the column. 
  5. Select the transaction and repeatedly click the R status until it's blank or unreconciled. 
  6. Click Edit. Make the changes and then save.

You can go back to the register and manually reconcile the transaction by clicking the Reconciliation status column to, then click Save. 

 

Once done, try to reconcile the new month and check if there are any other issues. If there are any discrepancies, you can check this article to help you fix them: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

Let me know if there's anything else I can assist you with. Post a comment below, and I'll be sure to get back to you. 

4 replies

C
Catherine_BAnswer
September 29, 2021

Hi there, Brea4.

 

Editing reconciled transactions can cause discrepancies on your previous and next reconciliation balances balance. I suggest reaching out to an accountant so they can help you manage the reconciled transaction so it won't mess up your books. 

 

If you need to edit the transaction, you can follow these steps: 

 

  1. Click Accounting.
  2. Go to the Chart of Accounts tab.
  3. Select the bank account, then click View register.
  4. Look for the transactions and check if you can see R in the column. 
  5. Select the transaction and repeatedly click the R status until it's blank or unreconciled. 
  6. Click Edit. Make the changes and then save.

You can go back to the register and manually reconcile the transaction by clicking the Reconciliation status column to, then click Save. 

 

Once done, try to reconcile the new month and check if there are any other issues. If there are any discrepancies, you can check this article to help you fix them: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

Let me know if there's anything else I can assist you with. Post a comment below, and I'll be sure to get back to you. 

B
Brea4Author
September 30, 2021

Thank u so much i appreciate ur quick response :)

B
Brea4Author
September 30, 2021
This post has been deleted.

Perfect thank u so much i appreciate the quick answer :)

A
AMANDADEXEN87
April 20, 2023

Hello, I am working on QB desktop and I need to post a payment to an invoice where the month was already reconciled and it was reconciled back in July of 2022 leaving a balance of $283.20 and customer verified that check was indeed sent and cashed by our company. I am cleaning up AR, just started here a few months ago. 

R
rharvey1971
January 31, 2024

I have a transaction that was reconciled in the wrong month, how to fix that?

J
JamaicaA
January 31, 2024

I’d be glad to assist you with unreconciling previous statements so they will not throw off your records, rharvey1971.

 

You can use the Undo a reconciliation feature for QuickBooks Online Accountant. It will help you unbind the entire reconciliation from within the register. See this guide for the steps: Undo a client’s reconciliation in QuickBooks Online Accountant.

 

Otherwise, manually unreconcile each transaction if using other versions. Here are the steps:

 

  1. Go to the Transactions tab on the left panel and select Chart of Accounts.
  2. Choose the account you’re working on, and click on View Register.
  3. Locate the transaction you want to unreconcile.
  4. Keep tapping the R status until it shows blank or cleared (C).
  5. Press Save, then pick Yes in the confirmation window.

 

I also recommend consulting with your accountant before performing any of these. They can help you decide or provide another method according to your situation.

 

 This article will help you learn more: Undo or remove transactions from reconciliations in QuickBooks Online.

 

To ensure all your transactions are organized in the correct account, refer to this module: Understand Chart of Accounts in QuickBooks.

 

I hope these instructions help you in resolving the transaction that was reconciled in the wrong month. If you encounter any issues along the way, please let me know. I am always here to assist you.

Terms & ConditionsAccessibility statement