cancel
Showing results for 
Search instead for 
Did you mean: 
dLearned
Level 3

Matching bank items

I am trying to go back to reconcile a significant period of bank statements and have numerous transactions that have not/will not match.  Examples (ACH that automatically creates an expense item, but the expense was added as an upcoming expense when the bill was received - so my statement shows 2 expenses that are duplicates.  Checks issued that match to deposit transfers but aren't matched for some reason leaving 2 payments on the register).  Is there a way to "match" a manually entered transaction to a downloaded transaction if there is no "match" link to click?  How do I link 2 transactions so they are only in the register once without deleting validly entered transactions?

Solved
Best answer August 03, 2021

Best Answers
Mark_R
QuickBooks Team

Matching bank items

I've got your back, @dLearned.

 

In QuickBooks Online (QBO), you have the option to manually match the transactions entered in QuickBooks to your downloaded ones. Here's how:

 

  1. In your QBO account, click Banking from the left menu.
  2. Select the appropriate bank account.
  3. In the For review tab, locate the transaction you want to match.
  4. Then, select the Find match radio button. This will route you to the Match transactions window.
  5. Find and select the transactions entered in QuickBooks, then click Save. Make sure the amount and date of the transactions are the same to find a match.

 

I'm adding this article for more guidance: Categorize and match online bank transactions in QuickBooks Online.

 

On the other hand, you can exclude the duplicate expenses from the Banking page to get rid of them. For the detailed steps and information, you can read through this article: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Once you're all set, you can proceed with reconciling your bank account in your QBO account. This way, you can make sure the transactions from QuickBooks match your bank statement.

 

Should you need any additional assistance while managing your bank transactions, you can leave a comment below. I'll be sure to get back to you.

View solution in original post

2 Comments 2
Mark_R
QuickBooks Team

Matching bank items

I've got your back, @dLearned.

 

In QuickBooks Online (QBO), you have the option to manually match the transactions entered in QuickBooks to your downloaded ones. Here's how:

 

  1. In your QBO account, click Banking from the left menu.
  2. Select the appropriate bank account.
  3. In the For review tab, locate the transaction you want to match.
  4. Then, select the Find match radio button. This will route you to the Match transactions window.
  5. Find and select the transactions entered in QuickBooks, then click Save. Make sure the amount and date of the transactions are the same to find a match.

 

I'm adding this article for more guidance: Categorize and match online bank transactions in QuickBooks Online.

 

On the other hand, you can exclude the duplicate expenses from the Banking page to get rid of them. For the detailed steps and information, you can read through this article: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Once you're all set, you can proceed with reconciling your bank account in your QBO account. This way, you can make sure the transactions from QuickBooks match your bank statement.

 

Should you need any additional assistance while managing your bank transactions, you can leave a comment below. I'll be sure to get back to you.

View solution in original post

dLearned
Level 3

Matching bank items

Thank you.  I had to undo some matches, and then it seems to have worked!  Thanks so much.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up