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

Matching refunds receips and invoices to the same deposit

This question has been driving me up the wall. I have read lots of other answers and none of them make sense to me.

 

I have deposits into my business checking account from my merchant account. For a given deposit there are payments and refunds receipts. This means the deposit amount does not add up to the total of several invoices it also needs to include the refunded amount. I am unable to match a deposit to a refund receipt?!? only to invoices, which obviously is useful if one ever processes a refund. I can match a refund receipt to an amount in the spent column.

 

I have read about using a bank deposit to rectify the above situation, I have had no success using this to match deposits. UPDATE finally success but you have to be kidding me that this is the best way to do this. Manually receiving each payment to deposited funds!?! you must be joking.

 

I wish to create either manual entries in my bank feed for review so I can break a deposit into its respective invoice and refund amounts in the received and spent columns respectively. Alternatively I would like to be able to match a deposit to both invoices and refund receipts.

 

This is a recurring issue that I need resolution to if I am to continue using Quickbooks.

1 Comment 1
Rejeil_O
QuickBooks Team

Matching refunds receips and invoices to the same deposit

Hi there, @endless questions.

 

I can see the importance of matching your deposit to your refund receipts. However, this is the best workaround to match the two transactions where you can deposit all the receive payment to Undeposited funds account and then get the refund transaction to the undeposited funds. Once done, you can create a bank deposit and deposit the payments as well as the refund receipts. 

 

You can follow these steps to deposit the payments to undeposited funds.

 

  1. Go to the + New.
  2. Select either Receive Payment.
  3. Choose the customer from the Customer drop-down arrow.
  4. Click the checkbox in the invoice you’re about to receive.
  5. From the Deposit to fields, select Undeposited Funds.

 

For the Sales receipts, you can refer to this link for the steps: Deposit payments into the Undeposited Funds account in QuickBooks Online.

 

Once done, you can make a refund transaction using an undeposited funds account, and after that create a bank deposit and deposit all the received payment and also the refund receipt.

 

For more detailed information about banking transactions like transfer funds and also reconciliation, you can visit the QuickBooks Online Help Article.

 

If you have additional questions, feel free to leave a message in the comment section. I'll be happier to help. Take care and have a great day!

Need to get in touch?

Contact us