Skip to main content
May 10, 2023
Question

Dealing with Overpayment

  • May 10, 2023
  • 2 replies
  • 0 views
I use QB and it is linked to our bank account - we have received an overpayment from a client which we have resolved and can see it in the Bank Deposit but can't see it in the Customer Account?

2 replies

May 10, 2023

Hello liza-careandcomp

 

You can record a refund to your client using an expense if they want you to reimburse the accidental overpayment. Using an expense to record the refund reduces your bank's balance and offsets the customer's open credit caused by the overpayment. (Tip: entering the full amount of the payment received on the 'receive payment' screen will close the invoice and automatically creates an unapplied credit of the overpayment amount on the customers account). 

 

To record the refund for your customer:

 

1. Select + New > Expense (if you're in Business view, follow the steps to switch to Accountant view first.)
2. Select the customer you want to refund from the Payee ▼ dropdown.
3. From the Payment account ▼ dropdown, select the bank account where you deposited the overpayment to.
4. On the first line of the Category column, select Accounts Receivable.
5. Enter the overpayment amount in the Amount field.
6. Fill out the other fields as you see fit, then select Save and close.

 

To link the refund to the overpayment:

 

1. Select + New > Receive payment.
2. Select the same customer you used for the check or expense when recording the refund.
3. Fill out the other fields as you see fit.
4. Under the Outstanding Transaction section, select the checkbox for the expense you created when recording the refund.
Note: If you have automation to apply bill payments turned on, this step is done for you.
5. Make sure the payment is equal to the open balance, then select Save and close.

 

May 11, 2023

Sorry I should also have said that I don't want to refund the overpayment - I want it to stay on the Customer's account until another invoice is issued and then used against that invoice. 

Also we allocate our payments via the bank and "match" the payments.

Many Thanks

May 11, 2023

Hello Liza-careandcomp,  If you want to see it in the customer account you will need to record it as a deposit to debtors with the customer's name in the received from section. Then you can allocate it to the open invoice and the overpayment will remain as an open balance until you allocate it to another invoice.

February 6, 2024

I have a similar situation. I have an invoice and a payment that is more than the invoice. I put in the total amount of payment a left the overpayment as a credit in QuickBooks Desktop Pro Plus 2023. The deposit states the amount is the original amount of the invoice paid NOT the check received payment amount. i.e. invoice was $3,200 payment was $3,500 and deposit should be $3,500. Credit left on customer account is $300. How do you get the deposit to read the $3,500?

 

February 6, 2024

Let me help you go over your sales transactions to correct the amounts involved, @fclark.

 

QuickBooks will automatically record the difference ($300) between the payment ($3,500) and invoice ($3,200) as credit. Once deposited, the $3,500 should appear as it now exists in your bank regardless of the overpayment. To clear the customer balance, you can apply it to future invoices since it will be recorded under the A/R account.

 

I'm adding some screenshots for reference:

 

To learn the options you can use with the overpayment, refer to this article: Give your customer a credit or refund in QuickBooks Desktop for Windows.

 

To learn what you can do with the payments, check out this guide: Void or refund customer payments in QuickBooks Desktop.

 

Feel free to comment below for any follow-up questions about customer payments and invoices. I'll always do my best to assist you. Stay safe.

February 6, 2024

All looks good except for one thing. On the home screen in Record deposits it shows (2). The $3200 and the 3500. I checked just the $3500, but it leaves the other. What do you do with that? I don't want a red deposit pending to show in Record deposits.