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

A partial deposit that was suppose to be part of $940 was added in the $340 deposit. I am having a match receipts issue.

I have made two deposits ($940 and $340) on separate days and the issue is matching the sales receipts. A partial deposit that was suppose to be part of $940 was added in the $340 deposit. 

 

Example: A $20 deposit was made in part of $340, instead of $940.

 

Problem: I cannot match my sales receipts. When I try to match $940 deposit to sales receipts, it's under $20. 

 

How can I resolve this in the best and most efficient manner? 

7 Comments 7
JessT
Moderator

A partial deposit that was suppose to be part of $940 was added in the $340 deposit. I am having a match receipts issue.

Hi fcharlie125,

 

You can edit/open the $340 deposit and uncheck the transaction that is not supposed to be part of it. This step makes it available again for deposits. Therefore, you can add it to the $940 deposit.

 

Let me know if you have other questions in mind.

fcharlie125
Level 1

A partial deposit that was suppose to be part of $940 was added in the $340 deposit. I am having a match receipts issue.

Thank you @JessT for the response!

 

I forgot to mention that there's no sales receipt for that exact amount. It was a part of a sales receipt. 

 

I am stuck here. 

AileneA
QuickBooks Team

A partial deposit that was suppose to be part of $940 was added in the $340 deposit. I am having a match receipts issue.

Hello, fcharlie125. 

 

The sales receipts will only show up in the Match transactions section if you deposit them to the Undeposited Funds account. I recommend reviewing your sales transactions and ensure a bank account isn't selected.  

 

Also, you may not be able to automatically find match for a number of reasons, if the transaction is outside of the date range you are searching, the difference to resolve is too large, the sales receipt is over 90 days old etc.

 

Additionally, I recommend the following resources, which contains information about matching transactions and customizing transactions in QuickBooks:

 

 

Add a comment below if you have any other questions. I'm a few clicks away to help. Happy weekend and keep safe always!

fcharlie125
Level 1

A partial deposit that was suppose to be part of $940 was added in the $340 deposit. I am having a match receipts issue.

@AileneAThe real issue is that I have shorthanded the first deposit based on my cash sale receipts. A few days later, I have made another deposit and made sure to add the amount that was missed.  

 

Deposit #1: $940,

---Cash Sale Receipts: $960

Deposit #2: $340

----Cash Sales Receipts: $320

 

Another issue is that the $20 is part of a bigger cash sale receipts. It's hard for me match it.

 

JessT
Moderator

A partial deposit that was suppose to be part of $940 was added in the $340 deposit. I am having a match receipts issue.

Hi fcharlie125,

 

Thank you for the additional details, and thank goodness I got your post again.

 

Alright, I'll show you how to record the additional and the lacking amount from these deposits respectively.

 

On your first deposit, just deduct the $20 from it so you'll end up having a total of $940. You can put the amount as another line and make sure it's a negative number, like in the screenshot. Make sure you choose the right account for it.

 

For sample purposes, I assume the money went to Cash on Hand so I used that account.

 

 

On the second deposit, just add another line item again with a positive $20. Use the same account, so the money will just reverse in that account.

 

 

After entering the transactions, match the downloaded transactions to the deposits, not to the sales receipts anymore.

That will do it. If you have any other concerns, please comment below.

fcharlie125
Level 1

A partial deposit that was suppose to be part of $940 was added in the $340 deposit. I am having a match receipts issue.

I have another scenario...

 

@JessT  @AileneA I deposited $940 and the sale receipts adds up to $960 for matching purposes. (I've fixed it with your solution above). 

 

The $20 difference was included in the $340, and the sale receipt adds up to $340.  (I couldn't fix this part)

 

Does your solution above apply to this scenario? 

MirriamM
Moderator

A partial deposit that was suppose to be part of $940 was added in the $340 deposit. I am having a match receipts issue.

Hello again, fcharlie125.

 

The solution provided by my colleagues above applies to your concern for the $340 Deposit and $320 Sales Receipt. To resolve this, I recommend following the steps above outlined by JessT.

 

Once everything is okay, you can now start categorizing or matching them to straighten out your books. After that, you have the option to do your regular bank reconciliation

 

If you have additional assistance with QuickBooks, let me know. I'll be around to provide further assistance. Have a nice day.

Need to get in touch?

Contact us