cancel
Showing results for 
Search instead for 
Did you mean: 
pro-lighting
Level 1

overpayment on invoice through EFT

Hello - I have received a payment from customer towards an invoice through EFT. They have overpaid this invoice by $260. I am trying to receive this transaction into QB Desktop Pro Plus 2023 by matching up to the invoice after downloading our bank feeds. Obviously it will not allow me to match to this invoice because of the overpayment. How do I receive in this deposit & then create a credit memo back to our customer?

Appreciate any help on this

Solved
Best answer September 01, 2023

Best Answers
JaeAnnC
QuickBooks Team

overpayment on invoice through EFT

We're delighted to have you join the QuickBooks Community, @pro-lighting. I'm glad to help you match the deposit to the invoice and issue a credit memo to your customer in QuickBooks Desktop (QBDT).

 

Since we're unable to match the deposit to the invoice because of the amount difference, we can add more details to the transaction to enter the credit memo. To do that:

 

  1. Go to Banking, click Bank Feeds, then Bank Feeds Center.
  2. Select the Bank Account and click Transaction List.
  3. Locate the deposit. Under the Action column, select Add more details.
  4. Put a checkmark on the transaction you want to match.
  5. Select the customer's name under Received From. In the From Account column, choose Accounts Receivable, then enter the Amount.
  6. Click Add to QuickBooks.
    image (33).pngimage (34).png

Once done, you won't need to create a credit memo separately because the amount will now appear as an open credit for your customer. You can use this to apply to their future invoices.

image (35).png

However, if you want to give a refund using cash or check, you can follow the steps outlined below.

 

  1. Go to Customers and select Create Credit Memos/Refunds. Click Use credit to give refund, then Yes.
  2. Select Accounts Receivable for the Account. Enter the Amount and the Customer's name. Then, Save & Close.
  3. Link the check to the overpayment. For the step-by-step guide, please refer to Option 2: Give a refund in this article: Give your customer a credit or refund in QuickBooks Desktop for Windows.
    image (36).png

 

Furthermore, I recommend reconciling your accounts in QBDT to ensure they align with your bank and credit card statements. This practice will ensure that they are accurately balanced.

 

Please don't hesitate to swing by the Community whenever you need additional assistance with customer refunds. We're always more than willing to lend you a helping hand. Stay safe and have a wonderful day!

View solution in original post

3 Comments 3
JaeAnnC
QuickBooks Team

overpayment on invoice through EFT

We're delighted to have you join the QuickBooks Community, @pro-lighting. I'm glad to help you match the deposit to the invoice and issue a credit memo to your customer in QuickBooks Desktop (QBDT).

 

Since we're unable to match the deposit to the invoice because of the amount difference, we can add more details to the transaction to enter the credit memo. To do that:

 

  1. Go to Banking, click Bank Feeds, then Bank Feeds Center.
  2. Select the Bank Account and click Transaction List.
  3. Locate the deposit. Under the Action column, select Add more details.
  4. Put a checkmark on the transaction you want to match.
  5. Select the customer's name under Received From. In the From Account column, choose Accounts Receivable, then enter the Amount.
  6. Click Add to QuickBooks.
    image (33).pngimage (34).png

Once done, you won't need to create a credit memo separately because the amount will now appear as an open credit for your customer. You can use this to apply to their future invoices.

image (35).png

However, if you want to give a refund using cash or check, you can follow the steps outlined below.

 

  1. Go to Customers and select Create Credit Memos/Refunds. Click Use credit to give refund, then Yes.
  2. Select Accounts Receivable for the Account. Enter the Amount and the Customer's name. Then, Save & Close.
  3. Link the check to the overpayment. For the step-by-step guide, please refer to Option 2: Give a refund in this article: Give your customer a credit or refund in QuickBooks Desktop for Windows.
    image (36).png

 

Furthermore, I recommend reconciling your accounts in QBDT to ensure they align with your bank and credit card statements. This practice will ensure that they are accurately balanced.

 

Please don't hesitate to swing by the Community whenever you need additional assistance with customer refunds. We're always more than willing to lend you a helping hand. Stay safe and have a wonderful day!

pro-lighting
Level 1

overpayment on invoice through EFT

This is EXACTLY what I needed & saving this for future reference! Thank you!

Candice C
QuickBooks Team

overpayment on invoice through EFT

Hey there, @pro-lighting

 

Thanks for keeping us updated. 

 

I'm glad my colleague was able to provide you with the information you needed. 

 

If you have any other questions, don't hesitate to ask. Have a wonderful day! 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us