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

Matching Multiple Deposits to Multiple Journal Entries

Hello, 

 

I had a fishy situation happen with my ERP program and how it handled a deposit. This resulted in 3 journal entries needing to be matched with 2 deposits. 

 

How do I do this? Thank you!!

Solved
Best answer April 27, 2021

Best Answers
Giovann_G
Moderator

Matching Multiple Deposits to Multiple Journal Entries

Thanks for posting in the Community, StefLM.

 

I can guide you in handling those transactions.

 

You have the option to match a journal entry. The system allows you to match a single bank feed entry with multiple journal entries. I'll show you how.

 

1. Go to the Banking page.

2. In the For review tab, locate the deposit.

3. QuickBooks will find the match for the record. select it, then click on Match.

4. If not, click the deposit then tick the Find match button.

5. Then, checkmark the journal entries to be the match.

 

If you have multiple deposits but only a single journal entry, then you'll want to skip the matching part. Instead, you can exclude them and manually clear the journal entries in the register.

 

Here's how to exclude:

 

1. Go to the Banking page, then select the Fore review tab.

2. Find the deposit transaction and check it.

3. Hit the Exclude button.

 

Here's how to clear the journal entries:

 

1. Go to the Accounting menu, select Chart of Accounts.

2. Find the bank and click View register.

3. Locate the Journal transaction, click the " check mark" column until a " C" appears.

4. Hit Save.

 

Also, you can reach out to your accountant before making some changes. To make sure that there are no other accounts affected on this transactions.

 

Here's a  handy material for more info: Reconcile an account in QuickBooks Online.

 

Add a comment below if you have further questions about managing your transactions. We're always here to help you. Stay safe.

 

View solution in original post

7 Comments 7
Giovann_G
Moderator

Matching Multiple Deposits to Multiple Journal Entries

Thanks for posting in the Community, StefLM.

 

I can guide you in handling those transactions.

 

You have the option to match a journal entry. The system allows you to match a single bank feed entry with multiple journal entries. I'll show you how.

 

1. Go to the Banking page.

2. In the For review tab, locate the deposit.

3. QuickBooks will find the match for the record. select it, then click on Match.

4. If not, click the deposit then tick the Find match button.

5. Then, checkmark the journal entries to be the match.

 

If you have multiple deposits but only a single journal entry, then you'll want to skip the matching part. Instead, you can exclude them and manually clear the journal entries in the register.

 

Here's how to exclude:

 

1. Go to the Banking page, then select the Fore review tab.

2. Find the deposit transaction and check it.

3. Hit the Exclude button.

 

Here's how to clear the journal entries:

 

1. Go to the Accounting menu, select Chart of Accounts.

2. Find the bank and click View register.

3. Locate the Journal transaction, click the " check mark" column until a " C" appears.

4. Hit Save.

 

Also, you can reach out to your accountant before making some changes. To make sure that there are no other accounts affected on this transactions.

 

Here's a  handy material for more info: Reconcile an account in QuickBooks Online.

 

Add a comment below if you have further questions about managing your transactions. We're always here to help you. Stay safe.

 

StefLM
Level 1

Matching Multiple Deposits to Multiple Journal Entries

Thank you so much!!

3PC
Level 1

Matching Multiple Deposits to Multiple Journal Entries

Hello,

 

I have a similar situation where my bank did a "deposit correction" of a few dollars so now I need to match two deposits with about 15 journal entries. How would I do this most efficiently?

3PC
Level 1

Matching Multiple Deposits to Multiple Journal Entries

Hello, I had a similar situation where I need to match two deposits to about 15 journal entries. What is the most efficient way to do this? 

LieraMarie_A
QuickBooks Team

Matching Multiple Deposits to Multiple Journal Entries

Hi there, @3PC. Let me share some insights on how to clear up your banking feeds.

 

QuickBooks Online only allows us to match a single entry with multiple journal entries. You can use the Search field to locate transactions by amount, reference number, or memo. 

 

Here's how:

  1. Go to the Transaction menu and select Banking.
  2. Select the tile for the account you want to review.
  3. Navigate to the For Review tab to start your review.
  4. Select the deposit to expand the view.
  5. Choose Find match.
  6. You can use filters/search to locate transactions. Remember to use a dollar sign or decimal point when searching for dollar amounts.
  7. Select the matched transaction.
  8. Click Save.

 

While we're unable to match two deposits with fifteen journal entries, I'd suggest excluding them. Then, manually clear them from your register. 

 

Here's how to exclude:

  1. Go to the Banking page, then select the Fore review tab.
  2. Find the deposit transaction and check it.
  3. Click the Exclude button.

 

Once done, follow these steps to clear your transactions:

  1. Go to the Accounting menu, select Chart of Accounts.
  2. Find the bank and click View register.
  3. Locate the Journal transaction.
  4. Click the checkmark column until a "C" appears.
  5. Click Save.

 

Here are some resources that will help you in managing your bank feeds:

 

Fill me in if you need any further assistance while working with bank feeds. I'm always here ready to help. Have a wonderful day.

NateP2
Level 1

Matching Multiple Deposits to Multiple Journal Entries

I have the exact scenario that StefLM describes - 2 bank deposits and I'm trying to reconcile 3 journal entries between the 2 bank deposits.  I'm able to exclude and find the journal entries in Chart of Accounts but nothing that I can see to click on until I see a C or an R.  Have these procedures for QBO changed?  If not, what could I be missing?  Thanks!

RoseJillB
QuickBooks Team

Matching Multiple Deposits to Multiple Journal Entries

Allow me to chime in on this thread to assist you, @NateP2.

 

Excluding your bank transaction from the Bank Feeds and clearing your Journal Entries (JE) in the Chart of Accounts (COA) is correct to enable you to reconcile the transactions. Regarding the process of QuickBooks in clearing the transactions, it still has the same process as you click the status field until it shows a C and R.

 

If the transaction shows a blank in the checkmark column, this means that the transaction has not yet been cleared or reconciled. To override the transactions you have, we can manually clear this by clicking the transaction and tapping the field until it shows C or Cleared.

 

In addition, here’s an article you can refer to start reconciling your account. Doing so will keep your books balanced and accurate: Reconcile an account in QuickBooks Online.

 

Let me know if you have more concerns about clearing transactions from COA or managing your account. I’m rooting for your business to prosper. Have a good one!

Need to get in touch?

Contact us