cancel
Showing results for 
Search instead for 
Did you mean: 
Brea4
Level 2

How to fix a reconciled transaction

How do i fix a reconciled transaction in QBO 

I need to change what account i put it under

Solved
Best answer September 29, 2021

Best Answers
Catherine_B
QuickBooks Team

How to fix a reconciled transaction

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. 

View solution in original post

16 Comments 16
Catherine_B
QuickBooks Team

How to fix a reconciled transaction

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. 

Brea4
Level 2

How to fix a reconciled transaction

Thank u so much i appreciate ur quick response :)

Brea4
Level 2

How to fix a reconciled transaction

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

Beck4D
Level 1

How to fix a reconciled transaction

Keeps asking for a password to un-reconcile a transaction

 

Charies_M
Moderator

How to fix a reconciled transaction

Help is here, Beck4D.

 

Since you're asked for a password when unreconciling transactions, it's possible that your user access is limited.

 

If you're not the admin of the account, I suggest reaching out to the admin and ask to grant you a permission to make changes with reconciliation.

 

adding these great resources to become more familiar with the different user types in QBO:

Feel free to read through this article for the entire process on how to undo reconciliation: How to Unreconcile a Transaction or Undo a Reconciliation.

 

Feel free to visit these links about reconciliation in QBO for reference:

Should you have anything else you'd like to go over while unreconciling, feel free to reach out to us again. I'm always here to assist you further.

Learning 100
Level 1

How to fix a reconciled transaction

What if the bank feed  went to wrong account can I transfer the charge to correct account but it’s doing the opposite of the correct change 

Rea_M
Moderator

How to fix a reconciled transaction

Hello there, @Learning 100. Welcome to the Community.

 

Let's go to the Banking or Transactions menu to transfer your bank feed transactions to the correct account so you can keep your accounts updated in QuickBooks Online (QBO).

 

Before we start, can you provide more information on why transferring the charge to the correct account is doing the opposite instead of correcting it? Any additional details are a great help in providing you with the appropriate fix for this matter.

 

You'll have to make sure you review and categorize downloaded transactions before adding them to your register. This way, you can keep your financial data accurate and updated. Since you want to transfer your bank feed transactions to the correct account, you need to select the right one in the Category field. Here's how:

 

  1. Go to Bookkeeping, then Transactions, and select Bank transactions.
  2. Select the tile for the account you want to review.
  3. Go to the For review tab to start your review.
  4. Find the transaction and select it to open its details.
  5. Choose the correct account in the Category field.
  6. Click the Add button. Repeat steps as necessary.

 

In case you want to review matched or added bank feed transactions, please see Step 3 in this article: Categorize and match online bank transactions in QuickBooks Online.

 

Also, I encourage you to reconcile your accounts in QBO regularly (every month). This helps monitor your income and expense transactions and detect any possible errors accordingly. You may want to check out this article as your reference to guide you in doing and fixing reconciliations in QBO: Learn the reconcile workflow in QuickBooks.

 

If there's anything else you need or if you have other banking concerns and questions about managing transactions in QBO, I'm always ready to help. Take care, @Learning 100.

CbryanGG
Level 1

How to fix a reconciled transaction

The transaction I want to unreconciled is link to a split payment. If I unreconcile just the one transaction will it just have that amount left that I unreconciled in the bank to reconcile? hope that makes sense.

 

Summary

I paid amex card $3500 which was 5 bills one which was selected incorrectly and should have been another bill

Mickey911
Level 1

How to fix a reconciled transaction

Thanks for this information.

 

I'm auditing a full year in QuickBooks (desktop) to correct errors. Will the change you suggested doing to change a category be tracked somewhere (general ledger?), so that others would be able to see what I've changed? 

 

Thank you. Mickey

Mickey911
Level 1

How to fix a reconciled transaction

If I follow the information to make changes to a reconciled transaction, is there some report I can print to show the changes that I make?

DivinaMercy_N
Moderator

How to fix a reconciled transaction

Hello there, @Mickey911. I got your back to help run a report to see changes made to reconciled transactions in QuickBooks Online (QBO).

 

Thanks for sharing the steps you've performed. To help you with this, you can pull up the Audit Log report. Here's how:

 

  1. Go to the Gear icon and select Audit Log.
  2. Next, filter the UserDate Changed, and Events fields and select the correct detail.
  3. Then, look for the specific transaction and click the View link.
  4. Once opened, click the Print icon to print the data. 

 

For reference, check out this article: Use the audit log in QuickBooks Online.

 

You can also run a reconciliation report for reference when you perform future reconciliations. For detailed instructions, read this link: View, print, or export a reconciliation report.

 

I'm always ready to lend a hand if you have any other concerns managing your transactions in QuickBooks. Have a good one, and stay safe. 

AMANDADEXEN87
Level 1

How to fix a reconciled transaction

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. 

Mickey911
Level 1

How to fix a reconciled transaction

I don't see the Gear icon. I'm using desktop, not QB Online...not sure if that matters.

Thank you. Mickey

MichelleBh
Moderator

How to fix a reconciled transaction

We have different steps in QuickBooks Desktop, Mickey. And I'm pleased to walk you through the detailed processes so you can print them. So others can see what changes you've made to your reconciliation info. 

 

In QuickBooks Desktop, we called the Audit Log an Audit Trail report. To run this, follow the steps below: 

 

  1. Go to the Reports menu on the upper right side. 
  2. In the Accountant and Taxes section and select Audit Trail.
  3. Click the Customize Report button. 
  4.  Choose Columns in the Display tab.
  5. From there, add the StateAction, User Edit? and any other column you want to include. 
  6. Hit OK, then Refresh

 

For reference, check out this article: Customize reports in QuickBooks Desktop. 

 

In addition, you can run the Previous Reconciliation report to show the transactions cleared, plus any changes made to those transactions since the reconciliation. See the sample screenshot below for reference: 

 

For more details, see this link and scroll down to the bottom: Review the reconciliation report

 

Moreover, check out the following articles below to learn how to do a mini reconciliation and fix some issues: 

 

 

I'm always here, ready to provide further assistance to help achieve your goal. Keep safe, Mickey. 

rharvey1971
Level 1

How to fix a reconciled transaction

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

JamaicaA
QuickBooks Team

How to fix a reconciled transaction

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.

Need to get in touch?

Contact us