Skip to main content
April 23, 2021
Solved

Refund Included in my Bank Deposit

  • April 23, 2021
  • 1 reply
  • 0 views

I had a customer's card get over charged. The bill was $75 and he mistakenly paid $100.00.

 

I waited until the payment had settled and the next morning refunded his over payment of $25.00. That same day another customer was charged $997. Resulting in a deposit to our bank account of $972.

 

When I got to match the bank deposit to the credit and the invoice I cannot get the Credit to show as available to include in the deposit. 

 

I have tried Checks, Refund Receipts, Credit Card Refund and Credit Memos but none of them have shown up as an item I can include in that days deposit. Any ideas? Thank you!

Best answer by KlentB

I can help you in handling that transaction, miniprincess.

 

The credit won't show on the Match transactions page since the two transactions have different amounts. In this case, you can just exclude the downloaded bank deposit. Then, manually clear the credit and invoice in the bank register. I'll show you how:

 

  1. Select Accounting from the sidebar menu.
  2. Go to Chart of Accounts.
  3. Find the account holding the transaction, then select View register from the Action column. 
  4. Locate the invoice and the applied credit, then click the transaction to expand the view.
  5. Review the Check column. 
  6. Keep clicking the checkbox  until it shows a letter to mark the transaction as cleared.
  7. Click Save, then close your account register.

I'm also adding these articles to help manage your bank transactions and keep your accounts up-to-date:

 

You can always tag my name in your posts and comments if you need more help in accomplishing your other tasks. I'll be more than happy to assist you again.

1 reply

KlentB
KlentBAnswer
April 23, 2021

I can help you in handling that transaction, miniprincess.

 

The credit won't show on the Match transactions page since the two transactions have different amounts. In this case, you can just exclude the downloaded bank deposit. Then, manually clear the credit and invoice in the bank register. I'll show you how:

 

  1. Select Accounting from the sidebar menu.
  2. Go to Chart of Accounts.
  3. Find the account holding the transaction, then select View register from the Action column. 
  4. Locate the invoice and the applied credit, then click the transaction to expand the view.
  5. Review the Check column. 
  6. Keep clicking the checkbox  until it shows a letter to mark the transaction as cleared.
  7. Click Save, then close your account register.

I'm also adding these articles to help manage your bank transactions and keep your accounts up-to-date:

 

You can always tag my name in your posts and comments if you need more help in accomplishing your other tasks. I'll be more than happy to assist you again.

KlentB
April 24, 2021

Hi miniprincess,

 

Hope you’re doing great. I wanted to see how everything is going about the issue in your bank transactions yeterday. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.

 

Looking forward to your reply. Have a pleasant day ahead!

April 28, 2021

Yes, this process worked. It's odd to me that we can't match up a credit card refund along with a charge because the total amount does match the deposit and it was able to be done in Quickbooks desktop without much of a problem. Sometimes it feels like 50% of QBO is a work around. Thank you for your assistance in clearing this!