Blog

Home / quickbooks / Overpayment of Vendor Bill – How to Handle in Quickbooks


Overpayment of Vendor Bill – How to Handle in Quickbooks

Don't know which accounting software to use?

Become a Small Biz Doer Member.

You'll be introduced to the basics of bookkeeping and accounting terminology, find out what accounting software can do, and be given criteria for evaluating what software is best for your company.

Become a Member!

You overpaid a bill or bills that were sent to you by one of your vendors, so how do you handle this bill overpayment in QuickBooks?

The first step in QuickBooks is to overpay the bill and get a credit. The second step is to either get a refund from the vendor and enter it as a deposit or use the overpayment credit on a another bill you received from the vendor.

Overpay the bill(s)

  1. Go to Pay Bills (vendor > pay bills)
  2. Select the appropriate bill(s) that you overpaid (by putting a check mark next to the bill)
  3. In the Amt. to Pay column, add the overpayment amount to a bill that you will be paying
  4. Continue as usual and pay selected bills

What this overpayment will do is create a credit with the vendor.

Option A – Receive the credit as a refund

If you will not purchase anything further from the vendor, you can request a refund. You have to physically contact the person yourself and get the company to give you a refund.

When / if you get the refund, this is what you do.

  1. Go to Record Deposits (banking > make deposits)
  2. For the Received From choose the vendor’s name and the From Account choose Accounts Payable
  3. Receive the payment

This effectively creates a bill from your vendor that you can then use your credit to pay off.

Option B – Pay another bill using the credit

To use the credit against a bill:

  1. Go to Pay Bills (vendor > pay bills)
  2. Select the appropriate bill(s) that you want to pay using the credit
  3. Below the bills click on the Credit button and use the credits (if you have credit left over, highlight another bill and repeat until either the credit is used up or the bills are all paid)
  4. Continue as usual and pay selected bills

Need a better way to do bookkeeping?

Our courses teach you how to set up, manage, and understand your business financials. You'll learn bookkeeping basics, a document management system, how to use accounting software, and how to keep your books up to date.

Spend less time worrying about bookkeeping and more time making smarter business decisions.

Become a Small Biz Doer Member for only $15!




14 Comments


K. Kersey
July 5, 2012, 6:04 pm

Quickbooks 2012 will not let you overpay a vendor.

    smallbizdoer
    July 6, 2012, 8:50 am

    Hi K. Kersey,

    Are you able to give a bit more detail or send me a screen shot to greg at smallbusinessdoer.com? I have QuickBooks 2012 and I just tried to overpay a vendor and it worked just like the instructions I wrote above.

K. Kersey
July 6, 2012, 12:03 pm

Yes, true it does. But my problem was that the amount was $334 in quickbooks and I saved the information but when I went to pay it through online banking I transposed the number to $343. I noticed the error when I went to do a bank reconciliation. When I went back into Quickbooks to updated witht he amount that I did pay it would not let me pay more than the amount that was originally owed.

    smallbizdoer
    July 6, 2012, 12:06 pm

    Ok, gotchya. I think the simplest thing to do would be to delete your payment in QuickBooks. Go to "Write Checks", find the transaction, and delete it. You will now be able to repay (and overpay) the bill by going to "Pay Bills". Let me know if that works.

JimmyB
November 5, 2012, 1:22 pm

What about receiving the credit back to a credit card? This process you describe only works if the vendor refunds you with a check. Please advise. Thanks

    smallbizdoer
    November 9, 2012, 9:28 am

    Hi Jimmy,

    If you're receiving a refund to your credit card, you still do step 1 by overpaying the bill. The second step is to go to "Enter Credit Card Charges" and make sure to use to select "Refund/Credit". For the account, use "Accounts Payable" and for the "Customer:Job", use the name of the vendor that you overpaid.

    To double check you did it correctly, go to the vendor from "VendorS Center" and you'll should see that the credit is used up.

MARIA ZANDER
January 18, 2013, 12:43 pm

Thanks a lot your answers are very simple and easy to follow.

Jen
September 30, 2013, 9:53 am

This is fabulous and exactly what I needed to figure out! Thank you so much!

Lgel
October 3, 2013, 11:23 am

So cash gets credited with the overpayment. Then to which GL account will the overpayment debit be applied to? Thanks

    smallbizdoer
    October 3, 2013, 8:09 pm

    Hi Lgel, this is what happens when you overpay.

    Debit – Accounts Payable
    Credit – Cash / Bank account (whichever account you received the money to)

Annie
October 14, 2013, 1:39 pm

Thank you for your help. It never occurred to me to check and see if a bill had been created. So simple.

Derek
November 11, 2013, 12:20 pm

I found your thread, and hope you can help. I paid a vendor twice on my own error. They deposited the check, so they cut me a new check to repay me the funds. While your post seems to be what I need, it doesn't make sense to me. In step 1, you suggest to go to "pay bills" and select the bill I over paid….however, since it was already paid, it's no longer in the pay bills list to check.

Then again following option B, the vendor name is not in the list at (vendor > pay bills).

Hope I am making sense here…..thank you!

    smallbizdoer
    November 11, 2013, 7:00 pm

    Hi Derek,

    In your case, you can first use the "Write Checks" function to write a check to the vendor. Make sure under "Customer:Job" to use the Vendor's name. Also make sure to use the "Accounts Payable" account for the account.

    Then go to "Record Deposits" and receive the refund. For "Received From", use the vendor name and for "From Account", use the "Accounts Payable" account.

    Next, go to "Pay Bills", find the bill, and pay it using the Credit (by using the "Set Credits" button).

    Make sense?

smallbizdoer
December 9, 2013, 3:02 pm

Hi JD13,

I would talk to your accountant / bookkeeper as I can't give advice regarding your taxes / payments. Sorry I can't help you out.