cancel
Showing results for 
Search instead for 
Did you mean: 
spensersh
Level 1

Match multiple journal entries to one bank transaction

My third party payroll company auto-uploaded two separate Journal Entries to QBO, with $1000 debited to Checking Account and $800 Credited to Checking Account. My banking feed shows $200 (the net of above). How do I match this $200 to the two above journal entires?

 

I've seen QBO support posts regarding multiple bank transactions matching to one journal entry but not the other way around: multiple journal entries for one bank transaction.

7 Comments 7
JoesemM
Moderator

Match multiple journal entries to one bank transaction

I'm here to help you with matching them, @spensersh.

 

You can match the downloaded transaction with the two journal entries. We'll have to click the Match radio button so that will program will automatically locate the journal entry associated with it. Let me show you how:

 

  1. Select Banking from the sidebar menu then goes to the Banking tab.
  2. Choose the appropriate bank account then click the For Review tab.
  3. Locate then click downloaded check to expand the view. 
  4. Tick the Match radio button.
  5. Review the Records found, then select the link next to each record to get more details.
  6. Check the Deposit to field on the forms.
  7. When you’re done, select Match.
  8. If not, select it then tick the Find match button. 

Capture.PNGCapture.PNG

Also, you can double-check again the date, amount, category, and check numbers of the entries are aligned. This is to make sure those transactions will match.

 

I've also included an article that will help you in categorizing and editing your downloaded banking transactions.

 

If you're about to reconcile your account, I recommend reading our reconciliation guide to ensure that your QuickBooks accounts accurate.

 

That should do it. Please know that I'm just a post away if you have any other questions about matching transactions in QuickBooks. It'll always be my pleasure to help. Have a great day ahead.

aysha-ingeniousi
Level 1

Match multiple journal entries to one bank transaction

In the example that spenserHW provided, the journal entry for the credit doesnt show up on the list when you click "find match". I supposed it's b/c its a credit and the total bank feed is debit. whats the work around here?

FateCandylaneT
QuickBooks Team

Match multiple journal entries to one bank transaction

It's nice seeing you in this thread, aysha. I'll share information to ensure you can match transactions in bank feeds to your journal entries.

 

There are instances that some of the credit transactions don't find their match in the existing records. Let's verify that the details from the downloaded data match the information in your journal entries.

 

Here are some of the possible reasons:

 

  • The amounts, payees, or dates don't match.
  • The bank account on the payment is not the same as the bank where the match is located.
  • The transaction is matched to other data.
  • There's a multi-currency issue with the exchange rates.

 

You can check out this reference to guide you in reviewing the added transactions and categorizing them in the correct accounts: Categorize and match online bank transactions in QuickBooks Online.

 

Let us know in the comments below if you have additional questions about matching these transactions in QBO. We're always here, willing to assist you. Keep safe!

aysha-ingeniousi
Level 1

Match multiple journal entries to one bank transaction

None of those are the issue for us. The journal entry has not been already matched or reconciled and is definitely the same bank account as the transaction. I believe the issue is that the bank transaction is made up of 3 journals - 2 of which are "payments" and one is a "deposit" - attached is the screenshot from the bank register. the journal entry that includes the deposit does not show up on the list of journal entries when I click "find match". I've checked the dates to make sure its not a filter issue.

MJoy_D
Moderator

Match multiple journal entries to one bank transaction

I can share additional information that can help you with matching a bank transaction to your journal entry, @aysha-ingeniousi

 

It's also possible that the dates don't match or do not close or the transaction is older than 6 months. Also, make sure to choose the correct date range for the transactions. It'll help the system find the journal entry from the register.

 

Follow the steps below:

 

  1. Go to the Banking menu and select the transaction. 
  2. Click Match. 
  3. From the Match transactions page, click on Journal Entries under Show dropdown.
  4. Make sure the From and To date are correct.
  5. Locate the journal entry.
  6. Click on Save once you're done.

 

For more information about matching, adding, or viewing multiple matches, check out this article: Categorize and match online bank transactions in QuickBooks Online. It'll also tell you more about why there are transactions that don’t have a match.

 

To make sure that your account in QuickBooks matches your bank and credit card statements, here's how you can reconcile an account in QuickBooks Online.

 

Please let me know if you need more assistance matching transactions in bank feeds. I'm always willing to help. Have a great rest of the day!

aysha-ingeniousi
Level 1

Match multiple journal entries to one bank transaction

As I mentioned in the previous post, the dates are not the issue - I made sure the from and to dates are covered.

MaryLandT
Moderator

Match multiple journal entries to one bank transaction

I hear you and completely understand, aysha-ingeniousi.

 

Let's match the journal entry (JE) with the bank transaction in QuickBooks Online. Before proceeding, here are a few reasons the match may not have been recognized.

 

  • The JE was recorded in a different bank account.
  • The JE has been reconciled.
  • The JE has been previously matched to another bank downloaded transaction.

 

Aside from the information above, you may want to double-check other details, like amount, category, and check numbers of the entries are aligned. This is to make sure those checks will match.

 

For more in-depth information about finding a match in QuickBooks, refer to these articles.

 

 

Stay in touch on how this goes by clicking the Reply button. I'm always around whenever you need help.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us