cancel
Showing results for 
Search instead for 
Did you mean: 
Community Contributor *

Split large deposit of cash and checks to cash sales and multiple invoices

I've read the multiple topics about splitting deposits among multiple invoices but that still has not helped me. I have a deposit which is $3000, 500 of which was cash 2500 was checks for multiple invoices. I accepted payment for the invoices with a total of 2500. When I go to match the deposit with the invoices I can't match to the invoices and send the 500 as cash sales to its individual account. If I try to match the invoices and save it give me

"Something’s not quite right-

The selected and downloaded transaction amounts don’t match. To continue, resolve the difference."
I've tried transferring to Undeposited Funds but the amount is already deposited in the bank and can't be transferred out. 
 
Any suggestions? Other than deposit checks for invoices individually and separate from cash deposits? (Which I'm going to do in the future)
Solved
Best answer 05-03-2019

Accepted Solutions
QuickBooks Team

Re: Split large deposit of cash and checks to cash sales and multiple invoices

Hi BeerOutside,

 

I would like to clarify how you entered or batched the cash to the income account so I can further help you on how to match them. If you entered them as a Journal entry, you'll have to make sure that you associated the correct account for it to show in the Match transaction window. 

 

On the other hand, if you haven't recorded them in QuickBooks we can turn on Resolve to add a resolving transaction. Please refer to the sample screenshot below. 

Let me know for updates. I'll be around to help you. 

9 Comments
QuickBooks Team

Re: Split large deposit of cash and checks to cash sales and multiple invoices

Hey there, BeerOutside.


Thanks for letting us know the steps you’ve taken to resolve the issue.  I’ll help you get past the error so you’re able to match the payments to multiple invoices.


To fix this, you’ll have to open the $2500 check in the For Review screen and manually enter the amount for each invoices associated to the payment. While the remaining $500 cash, go back to the For Review page and match the fund to the correct invoice.


For detailed information, click on this link and go directly to the Find matching transactions section.


Please keep me posted on whether or not this help. I’ll be on a look out for your response.

 

Experienced Member

Re: Split large deposit of cash and checks to cash sales and multiple invoices

I'm having the same challenge.....but I'm not sure I follow the reply here.  For the remaining $500 cash in this scenario, there would not be an invoice to match it to, correct?  So they what do you do? 

 

Thanks! 

Allison

Highlighted
QuickBooks Team

Re: Split large deposit of cash and checks to cash sales and multiple invoices

Hi there, @allisontmease.

 

Please allow me to help match the transactions in QuickBooks Online (QBO).

 

To match the transactions, you may need to receive the payment of the invoice amounting to $2500 with Check as the payment method and deposit the amount. After, receive the payment amounting to $500 with Cash as the payment method and deposit the payment.

 

Once done, you can now match the transactions individually. 

 

To learn more about matching transactions in QBO, you can check this article: Add and match downloaded banking transactions.

 

You can always add a post/comment below if you have any other questions about matching transactions in QBO. I'll be happy to help you!

Community Contributor *

Re: Split large deposit of cash and checks to cash sales and multiple invoices

This is not exactly what I'm trying to do. The 500 cash is not for an invoice, its for sales income. The 2500 is for two different invoices for different clients. In the For Review screen it all shows up together as one deposit of 3000. 

QuickBooks Team

Re: Split large deposit of cash and checks to cash sales and multiple invoices

Thanks for the additional information, BeerOutside. 

 

When you find the match of the $3000 deposit, make sure to include the two invoices and the sales receipt to solve the difference. 

 

Let me show you how: 

  1. From the Banking page, click the For Review tab. 
  2. Search and select the deposit
  3. Then, click the Find match radio button. 
  4. Filter to only Open invoices and then the Sales receipt. Also the date range (From and To).
  5. You can also Search the customer's name to easily locate the transaction. 
  6. Make sure that the difference is now $3000. 

Let me know if you have additional concerns. I'm here to help!

Community Contributor *

Re: Split large deposit of cash and checks to cash sales and multiple invoices

Thank you for your reply. But we're still missing something. I don't have a cash sales receipt. I do cash sales of beer. So the $500 is for 100 beers that I don't have the receipts for. I batch all the cash into an income account "Beer Sales". I can find the two invoices and match them but there is not cash receipt to match it to leaving me with the message in the OP.

QuickBooks Team

Re: Split large deposit of cash and checks to cash sales and multiple invoices

Hi BeerOutside,

 

I would like to clarify how you entered or batched the cash to the income account so I can further help you on how to match them. If you entered them as a Journal entry, you'll have to make sure that you associated the correct account for it to show in the Match transaction window. 

 

On the other hand, if you haven't recorded them in QuickBooks we can turn on Resolve to add a resolving transaction. Please refer to the sample screenshot below. 

Let me know for updates. I'll be around to help you. 

Community Contributor *

Re: Split large deposit of cash and checks to cash sales and multiple invoices

Resolve like above! Didn't get advised about this little gem in all the conversations I've had in the last six months trying to get this one transaction added. 

Community Contributor *

Re: Split large deposit of cash and checks to cash sales and multiple invoices

I take that back, tried the resolve thing and it worked! Thank you this has stumped every person I have talked to about it in the last six months. Cheers!