cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
Ascot Promotions
Level 1

Matching Refund Receipt

Having trouble matching a charge from our online payment provider. 

Our payment provider batch all payments received for that day and pay us as a single payment the next day. 

On one particular day, we refunded a large order, which meant that our total payout for that day was a negative value. 

 

I have created a refund receipt, but when I go to the usual "Bank Deposit" option and select all of the payments to include (including the refund receipt), I get the following error message: 

"Something's not quite right
You must specify a transaction amount that is 0 or greater."
 
Is there any other way I can batch all of the necessary payments (plus 1 refund) to appear as a single transaction on our bank account, so I can then match it with the charge?
 
Thanks
Joe
 
Solved
Best answer 2 weeks ago

Accepted Solutions
EmmaM
QuickBooks Team

Matching Refund Receipt

Hello Ascot Promotions, Thanks for the screenshot, Okay in that case it is not something which you're going to be able to bulk match as it will not bring up the money in when it shows as as a money out. It is not going to let deposit a minus amount, the best thing to do is to deposit the income and not the refund receipt and go to the refund receipt change the transaction within the receipt so it is bank and not undeposited funds that it is paid from and save the refund receipt and then the total in the bank will be correct and exclude the transactions in  the banking so it will still show overall for day that it was negative. 

View solution in original post

3 REPLIES 3
EmmaM
QuickBooks Team

Matching Refund Receipt

Hello Ascot , You could add all the payments into the bank from the bank deposit and then on the banking section select the bulk amount line and find a match and tick them all plus the refund receipt, let us know if that works if not if you could provide a screenshot of the deposit and refund receipt and the banking page showing the bulk amount t hat would be great.Thanks

Ascot Promotions
Level 1

Matching Refund Receipt

Hi Emma, 

 

Thanks for your reply. I have tried your suggestion but when I click on the "find a match" option, I am only presented with supplier bills and expenses (money out). There are no customer invoices (money in) for me to mark as received. This is because the transaction on the bank is seen as a "spent" transaction, so only shows expenses and bills (money out).

 

I have tested with a different "received" transaction, and when I click on "find a match" for this, I am shown a list of customer invoices (money in) but no bills/expenses (money out). 

 

Below is a screen shot of the bank deposit page, which is the usual way I add all the payments. On this page, I am able to select all the necessary transactions (including the refund) and the figure shown matches the figure on the bank statement (-£91.60). However, when I hit save, I am presented with the error message "you must specify a transaction amount that is 0 or greater".

 

Any help would be greatly appreciated! 

 

Capture1.jpg

EmmaM
QuickBooks Team

Matching Refund Receipt

Hello Ascot Promotions, Thanks for the screenshot, Okay in that case it is not something which you're going to be able to bulk match as it will not bring up the money in when it shows as as a money out. It is not going to let deposit a minus amount, the best thing to do is to deposit the income and not the refund receipt and go to the refund receipt change the transaction within the receipt so it is bank and not undeposited funds that it is paid from and save the refund receipt and then the total in the bank will be correct and exclude the transactions in  the banking so it will still show overall for day that it was negative. 

View solution in original post