Matching bank transaction to multiple journal entries

Hi @KZ2018,

Welcome to the Community. I can help you match transactions in bank feeds to your journal entries.

There are times that some of the transactions can’t find their match from existing records. Details from the downloaded data and the journal should match to ensure it shows up.

Here are the possible reasons:

• The payees don’t match
• The amounts don't match
• The dates don't match or is not close
• The transaction is older than 6 months.
  Tip: You can still find a match when you select the Find match section
• The bank account on the payment is not the same as the bank where the match is located
• The payment has been reconciled
• The transaction is already matched to something else
• There’s a multi-currency issue with the exchange rates

Please make sure to choose the correct date range for the transactions. It'll help the system find the journal entry from the register.

Here's how:

1. Go to Banking, select the transaction, and click Match.
2. From the Match transactions page, select Journal Entries under Show drop-down.
3. Make sure the From and To date are correct.
4. Locate the journal entry, check, then Save.

Also, you can use this article to review added transactions or unmatch them in QuickBooks: Categorize and match online bank transactions in QuickBooks Online.

Please let me know if you need more assistance matching transactions in bank feeds. I'm always willing to lend a hand.

Hi,

Thank you for the info. Unfortunately, none of that worked. I don't know if it was because I had to match the combo of a debit entry and a credit entry (which resulted in a net debit) and QBO wasn't able to see the linkage. I ended up netting out the amounts in the journal entry rather than writing them as 2 separate entries. That worked and allowed me to match it with the bank feed.

Hello,

I followed the steps you provided to match checks from bank feed to journal entries that our payroll provider posted to QBO, and could not find them. I made sure date range were correct and selected "journal entry" from drop down list. Is there a reason I was not able to find them? 

Hello.

I followed the steps you provided to match my checks that cleared the bank with journal entries my payroll provider posted to QBO credit to payroll liability and debit to payroll expense. However, when I tried to match the checks to offset the payroll liability account, it was not appearing. I made sure to select the Journal Entry option from drop down and correct date range. Please help. Thank you.

Thank you for joining the thread, @Answer Needed.

Allow me to chime in and help you verify why your transactions don't match in QuickBooks Online (QBO).

To begin, please verify that the transaction is in the same bank account. Since it's a journal entry, also ensure that the bank is credit in your Journal Entry.

Additionally, ensure that the transaction amount and date are the same as in the downloaded transactions. We can also toggle off the Suggested Matches button when matching transactions to see the whole list. From there, you can see all the possible matches that aren't filtered out yet. 

Moreover, here's an article I'd like to share to help you automatically categorize transactions from your bank: Set up bank rules to categorize online banking transactions in QuickBooks Online.

Feel free to leave a comment below if you need further assistance in matching your transactions. I am here to help.