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

How do you correct a deleted online bank matched transaction that is still showing on the account it was matched to?

I just started a new job that uses Quickbooks online.  The bank account reconciliation is showing a difference because of deleted transactions.  I ran the discrepancy report and looked at the deleted transactions.  They have been matched to transactions and show up there as an online banking match but not in the bank account.  How do I record the transaction and re-match?  Can I un-match, re-add, and then match again?

3 Comments 3
CharleneMaeF
QuickBooks Team

How do you correct a deleted online bank matched transaction that is still showing on the account it was matched to?

My main goal is to ensure the discrepancy in your reconciliation gets sorted out, PCHCLT. I'll be glad to lay down the steps to fix this.

 

The Chart of Accounts shows all your transactions, both added manually in QuickBooks and categorized from your downloaded transactions in the Banking menu. However, the Categorized tab will only show those bank feed transactions you've categorized or added to your register. 

 

Also, when QuickBooks downloads the bank data, it matches them with transactions already entered. Otherwise, it creates a new record for you to review and approve.

 

Since the entry is deleted, I recommend adding it manually to the program. Then, reconcile it to resolve the discrepancy. Here's how:

 

  1. Go to the Gear icon and then select Chart of accounts.
  2. Find the previously reconciled account.
  3. Select View register from the Actions column.
  4. Choose the type of transaction you want to add under the Add check drop-down menu.
  5. Fill out the fields to complete the transaction.
  6. Hit Save.

 

Once done, locate the entry and double-click the Check () column until the sign shows. It indicates that the transaction is now reconciled.

 

If the discrepancy persists, I recommend following the steps in this article to fix this: Fix issues at the end of a reconciliation in QuickBooks Online.

 

Finally, you can run, print, or export the reconciliation report in QuickBooks. It'll be helpful if you have trouble reconciling the following month and when you meet with your accountant.

 

This thread's still open, so feel free to add other concerns you might have about your bank transactions or reconciliation. If you need help with vendor entries, reports, and settings, let us know, and my team and I will chime in again to assist.

PCHCLT
Level 1

How do you correct a deleted online bank matched transaction that is still showing on the account it was matched to?

How do I handle/correct the Payment that is showing as matched to the online banking transaction?  If I add back the transaction I will have nothing to match it to.

ShyMae
QuickBooks Team

How do you correct a deleted online bank matched transaction that is still showing on the account it was matched to?

I'm here to help you handle the payment that is showing as matched to the online banking transaction, PCHCLT. 

 

Yes, you're correct that when you add back the transaction, you'll have nothing to match it to. To fix this, you'll need to undo the matched transactions, re-add the payment, and then match it again. 

 

Here's how to do it:

 

  1. Hover the Transactions in the left navigation panel, then select the bank account you want to review.
  2. In the Categorized tab, locate the matched transaction, then click Undo
  3. Click the For Review tab, locate the bank transaction, and then match it with the payment. 

 

Afterward, click the Go to bank register, then locate the entry in the register. 

 

  1. On the Bank Register page, find the transaction you've matched. 
  2. Click the box in the checkmark column until you see an R It indicates that the transaction is now reconciled.
  3. Once done, select Save.

Sample.PNG

I'd still recommend consulting your accountant to ensure the accuracy of your books. If you don't have one, you can find a professional through this link: https://quickbooks.intuit.com/find-an-accountant/

 

For additional reference, you can check out these articles as a guide to reconciling your accounts:

 

 

I can back you up again if you need further assistance with your reconciliation and transactions, PCHCLT. Feel free to leave your response below. Best wishes! 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us