cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Accept credit card payments in QuickBooks Online.Explore QuickBooks Payments
Brendon R
Level 1

Need to match supplier refund with overpayment - both appear in bank

We ordered items from a supplier and paid in full. Then cancelled some items and a refund has been received. I have bills for all the items received but how do I match the overpayment and refund in bank? (Overpayment + bills leaves the refund as a balance but no way to match)

1 REPLY 1
Janiqueca_T
QuickBooks Team

Need to match supplier refund with overpayment - both appear in bank

Hi Brendon. I see you mentioned an overpayment, just to clarify, in QuickBooks Online, this happens when a bill payment exceeds the amount of the original bill it’s linked to. If you edited either the bill or the bill payment, try restoring them to their original amounts. This helps keep your records straight and makes handling the supplier refund process much smoother.

 

From what I understand, there are currently two downloaded bank transactions sitting in your bank feed waiting to be matched. The good news is that we’d only have to match the original Bill payment to the money out transaction.

 

The next step is accounting for the supplier refund that you have received, which is a straightforward two-step process. You’ll just need to create a Supplier Credit and then a Bank deposit. This lets QuickBooks know that the money you received in your bank account offsets the credit from your supplier.

 

To create a Supplier Credit, here’s how:

 

  1. Go to Suppliers.
  2. Select the supplier who sent the refund.
  3. Select the New transaction dropdown, then click Supplier credit.
  4. In Item details, fill out the items, quantity, and rates that were cancelled.
  5. Click Save and close.

 

Then create a Bank Deposit:

 

  1. Go to + New, then click Bank deposit.
  2. Select the correct Account and date.
  3. Under Add funds to this deposit, select the supplier in the Received From column.
  4. Set the Account to Creditors (or Accounts Payable).
  5. Type the refund amount, then click Save and close.

 

Once done, link the bank deposit record and supplier credit by going to +Create > Pay bills. You can then match the supplier refund bank transaction to the recorded bank deposit.

 

If you have more questions or need clarification, just let us know. We're here to help.

Need to get in touch?

Contact us