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?
C
ChristineD65
December 21, 2020
Question

Match a manual transaction

  • December 21, 2020
  • 10 replies
  • 58 views

The upload from the bank filtered out a transaction as a duplicate.  It's not, we actually did have a payment for the exact amount, to the same vendor, on the same date (third party contractor payments)
There are journal entries for both transactions, but I can only match one, because the bank feed only lists one.
I tried manually creating the deposit, but cannot figure out how to then match the transaction to the journal entry.

Please help

10 replies

L
lin_jcaj
Level 9
December 21, 2020

I can help you get this sorted out, ChristineD65.

 

We can only match a downloaded transaction to a single one in QuickBooks Online. If a payment was created, you may not need to create a Journal Entry. This is to avoid doubling your expenses and match the bank transaction to it.

 

Please double-check the both the payment and the journal entry, and remove the one that 's not needed. Here's how:

 

  1. Go to the Banking menu and select Banking.
  2. In the For Review tab, put a checkmark on the boxes for those duplicates.
  3. Click on Exclude.

Transactions will then be moved to the Excluded tab.

 

That's it! If you have any other concerns or questions about banking, I'll be right here to keep helping.

C
ChristineD65Author
December 22, 2020

No, I think you got this backwards. 
There is only one downloaded bank transaction, but it is supposed to be two.  I think QBO only accepted one because they look like duplicates.  They actually aren't, there were two payment made on the same day for the same amount, to the same vendor. 
There are two existing journal entries in QBO, one for each payment.  This is correct. 

The problem is that I can't match both of the journal entries because one of the bank transactions is missing in QBO.  I've tried manually creating the missing transaction, but that will not allow me to connect it to the journal entry.

 

M
Maybelle_SQuickBooks Team
QuickBooks Team
August 28, 2023

This makes sense but what if I have to split a portion of a bank transaction and match said portion to a journal entry? How would I do that?


Let's work together to match your transactions in QuickBooks Online (QBO), Lookingforanswers1978.

 

In QBO, we can log all of your transactions that require alignment with the bank transactions. Afterward, you can utilize the "Find match" function to incorporate the corresponding journal entry.

 

 

Here's how:

 

  1. Go to the +New button.
  2. Choose the transaction types you want to record.
  3. Enter the necessary information.
  4. Hit Save and close.

     

Once done, match the transactions. I'll guide you on how to do it.

 

  1. Go to the Banking menu.
  2. Select the transaction.
  3. Click Find match.

 

Additionally, I've attached an article you can utilize to help locate transactions in your account registers so you can examine or modify them: Find, review, and edit transactions in account registers in QuickBooks Online.

 

Fill me in if you have further questions about matching transactions in QuickBooks. I'm always around to help you out. Have a good day!

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