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.

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

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!

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. 

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!

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.

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. 

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!