cancel
Showing results for 
Search instead for 
Did you mean: 
LRBCORP
Level 2

How do I separate a deposit of multiple checks when one of them is the payment of an invoice and also get it to MATCH?

I deposited two checks. One was a credit from an insurance company. The other was the payment of an outstanding invoice. They showed up as one deposit and now it will not reconcile. I need to receive the payment but that payment is not matching because the value is more when it is added to the second check.
3 Comments 3
JenPM
Level 3

How do I separate a deposit of multiple checks when one of them is the payment of an invoice and also get it to MATCH?

Hello LRBCORP,

 

It sounds like when you receive the payment or enter deposits you deposit it straight to your checking/bank account. is that correct? In other words the "deposit to" account when making a deposit is your bank account, correct?

 

When you have two checks or seperate deposits that are showing as 1 combined amount on your bank statement, you would use the account "undeposited funds". 

 

To explain further, receive the payment on your invoice like you normally would EXCEPT instead of depositing the funds directly to your bank account, change the Deposit to: account to "undeposited Funds."

 

This serves as a temporary holding account. Create the deposit for your insurance check as well, except make sure you deposit it to "Undeposited Funds" like you did with your received payment. 

 

When you have both of these entered, click on make deposit in the top right, and you should see both of your deposits listed in your make a deposit window. Click both and make sure that it adds up to the combined amount that is showing on your bank statement. 

Then click make deposit. This will record one combined amount so you should be able to match this to the deposit that is showing in your bank feed. :) However when you click on it, it will also show the breakout of the 2 checks. So you get a summary combined transaction as well as being able to see the check details and breakout.

 

Depositing directly to your bank account usually works if you deposit each transaction seperately, but if you start to combine deposits or deposit them together, Undeposited funds comes in to save the day!

 

Please see the following article as well to see screenshots and additional explantations. you can skip down to the section labeled "Grouped Payments".

 

Please let me know if you have any questions or if anything isn't making sense.

https://quickbooks.intuit.com/learn-support/getting-started-with-quickbooks/how-to-use-the-undeposit...

JoesemM
Moderator

How do I separate a deposit of multiple checks when one of them is the payment of an invoice and also get it to MATCH?

Hello there, @LRBCORP.

 

Let me guide you on how to match the transactions in QuickBooks Online.

 

You'll have to manually create all the transactions in QuickBooks Online. If you want to create the transactions in the bank register, please follow these steps:

  1. Click the Gear icon.
  2. Below Your Company, select Chart of Accounts.
  3. Choose an account and click View register.
  4. Click the drop-down arrow below the Date column

Then use the find match to look for all those transactions.

  1. Go to the Banking menu or Transactions menu.
  2. Select the blue tile for the account you want to review
  3. Then click the Match button.

Once you've done, receive the payments and make a deposit so you'll be able to reconcile the transaction.

 

Also, I've added these articles about reconciliation that might help you in the future: 

If there’s anything else I can help you with, post a comment below. I’ll be right here to assist further.

 

vpcontroller
Level 11

How do I separate a deposit of multiple checks when one of them is the payment of an invoice and also get it to MATCH?

@LRBCORP 

 

From the Banking Review tab, find the Deposit transaction you want to match with customer payment plus insurance refund.

  • Click the Deposit transaction row in question.
  • Click "Find match" radio button
  • Match transactions screen will open. See the screenshot below for reference.
  • Select transaction to match for Invoice payment
  • Click RESOLVE button
  • Under Add resolving transactions section, add insurance refund deposit
  • The total deposit should match now
  • Save

Example: Total Deposit = $1,300 (Customer Invoice payment = $1,200+ Insurance refund deposit = $100).

 

find_match-add_resolving_transactions.PNG

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

Need to get in touch?

Contact us