Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
D
dLearned
August 3, 2021
Solved

Matching bank items

  • August 3, 2021
  • 1 reply
  • 0 views

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?

Best answer by Mark_R

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.

1 reply

M
Mark_RModeratorAnswer
Moderator
August 3, 2021

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.

D
dLearnedAuthor
August 3, 2021

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

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement