Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
May 4, 2021
Question

Matching transactions

  • May 4, 2021
  • 1 reply
  • 23 views

Hello, 

 

I am having a difficult time matching transactions from the bank feed. The transactions either don't show up at all, or the dates that they cleared are incorrect. I have been manually categorizing transactions instead of matching them and I noticed many invoices still say unpaid. 

 

I am assuming this is occurring because I did not match them so technically they still stand unpaid. This has happened for about 3 months, which I have reconciled already, and I just want to clean this mess up before it gets worse. 

 

I am not sure how to approach this issue. I tried undoing the transactions I categorized and then matching them, but I find the same exact issue, the dates are way off, it will reflect several incorrect vendors, or it won't show at all. 

 

Thank you in advance for the help! 

 

Samantha Breeden

1 reply

Moderator
May 4, 2021

Hello, SamanthaSB. 

 

When you use the bank feed in QuickBooks Online, you'll be able to add or match your transactions to ensure QuickBooks Online matches what's in your real-life bank account.  

 

  1. Go to the Banking menu, and then hit the Banking tab.
  2. If QuickBooks has found a possible match for the bank transaction, QuickBooks displays an outlined green box under the Category or Match column that says 1 record found message to the matching transaction.
  3. Tick the boxes next to the transaction and then Accept.
  4. For multiple invoices, click the deposit transaction and then tap the Find match radio-button. This will open the Match transactions page where you can choose the transactions to match.
  5. For duplicate records, mark the box next to the transaction and then choose Exclude

 

For details about matching downloaded transactions, check out these guides:

 

 

Additionally, you can set up a bank rule to automatically categorize your transactions. Please refer to this article for the steps: Set up bank rules to categorize online banking transactions in QuickBooks Online

 

Feel welcome to message me anytime if you still have questions or concerns. I'm always here to help. Take care and have a lovely day ahead.

May 4, 2021

Thank you so much for your feedback @AileneA 

 

The problem I am facing is when I match transactions it automatically sets the category to Undeposited funds. Is there a way to update the category after matching transactions from the bank feed? 

Tori B
QuickBooks Team
January 17, 2022

I found my issue, if the transaction is Reconciled it will not try to match, remove the "R" and it shows up for me!


Good morning, @JosephHK

 

Thanks for sharing what worked for you. It's customers like you that make having the QuickBooks Community so resourceful. 

 

Please feel free to reach back out any time and let us know if there's any way we can lend a hand. Take care!