Matching Multiple Deposits to Multiple Journal Entries

Thank you so much!!

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?

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? 

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:

• Tips for Working in QuickBooks Online’s Bank Feeds: Matching Transactions
• Categorize and match online bank transactions

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.

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!

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!