cancel
Showing results for 
Search instead for 
Did you mean: 
ap36
Level 1

How do I unmatch a transaction on a bank account that is no longer available online?

 
5 Comments 5
Ashley H
QuickBooks Team

How do I unmatch a transaction on a bank account that is no longer available online?

Hello there, @ap36.

 

I'd like to ask a couple of questions to get a better understanding of this transaction:

  • Is this transaction needing to be unmatched because it was mismatched?
  • Is the bank account disconnect completely from the Online Bank Feed?

If you can get back to me with more details, I'd be happy to assist you further. In the meantime, here's a Community Article that you may find useful: Unmatch or move bank transactions after reviewing them.

 

I'll keep an eye out for your response. Have a nice day!

ap36
Level 1

How do I unmatch a transaction on a bank account that is no longer available online?

Ashley H, Thank you for the response. The answers are as follows:

  • yes, the transaction was originally mismatched
  • yes, the bank account is completely disconnected because it was closed due to fraud. We wanted to leave it open because of issues with the previous bookkeeping processing.  However the bank closed it after 30 days of no activity without first discussing with us.
JasroV
QuickBooks Team

How do I unmatch a transaction on a bank account that is no longer available online?

Thanks for the clarification, @ap36.

 

You'll want to go to the Reviewed tab on your Baking page and undo the transactions from there. Doing so will unmatch those transactions. Let me guide you how.

 

In your QuickBooks Online (QBO):

  1. Go the Banking or Transactions menu and select the Banking tab.
  2. Select the bank account you want to review.
  3. Click the Reviewed tab.
  4. Find the transaction you want to unmatch.
  5. Select the blue transaction link in the Added or Matched column to see the matched transaction.
  6. Click the Undo link from the Action column. The transaction will go back to the For Review tab. 
  7. Then go back to the For Review tab and find a new match.

Here's an article you can read for more details: Unmatch or move bank transactions after reviewing them.

 

However, if you've reconciled the transaction you want to unmatch, I recommend getting in touch with your accountant for advice. This way. we'll ensure the accuracy of your accounts after making these changes.

 

 Also. you might want to check this great resource that can guide in reconciling your account accurately: Reconcile an account in QuickBooks Online.

 

 Know that we're always here to have your back. Should you have other concerns or questions, you're always welcome to post here anytime. Have a wonderful day!

ap36
Level 1

How do I unmatch a transaction on a bank account that is no longer available online?

Thank you JasroV! However, the issue is the bank account is no longer open or attached to the bank. Thank you, for trying to help.

Angelyn_T
QuickBooks Team

How do I unmatch a transaction on a bank account that is no longer available online?

Thank you for getting back to us here on the Community page, @ap36.

 

In this case, you can prepare an Excel CSV file for your bank transactions and upload it to your QuickBooks Online account so the transactions will become available on the bank feeds. Just make sure that the bank that was no longer attached to QuickBooks is added to the Chart of Accounts. If not, here's how to add the account:

 

  1. Click on Chart of Accounts from the Gear icon.
  2. Select the New button beside Run Report.
  3. Choose the account's type and detail type.
  4. Add the account's name, then fill in the rest of the information.
  5. Hit Save and Close to record the account.

Once completed, proceed with uploading the file.

 

  1. Go to Banking at the left pane, then select Banking beside Rules.
  2. Click on the drop-down beside the Update button, then select File upload.
  3. Tap Browse, then select a file to upload.
  4. Click Next, then pick a bank account where you want to upload the file under the QuickBooks Account section.
  5. Follow the on-screen instructions to continue the process.

For additional reference, check out this article: Import bank transactions using Excel CSV files.

 

Once the transactions become available on the Banking page, then I suggest following the steps provided by JasroV above about unmatching transactions.

 

Let me know if you have any other questions. I'm a few clicks away to help. Have a good day!

Need to get in touch?

Contact us