cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
userlgolimpi
Level 1

How to recon if supplier (vendor) statement from June is paid at the end of the month. In July goods are returned but credit reflects on statement no cash refund or EFT?

I need reconcile from Bank to invoices but the amounts wont match. I cant apply supplier credits as bills have already been paid. How do i resolve the difference?
1 Comment 1
Rea_M
Moderator

How to recon if supplier (vendor) statement from June is paid at the end of the month. In July goods are returned but credit reflects on statement no cash refund or EFT?

I'll make sure you're able to reconcile your supplier transactions in QuickBooks Online (QBO), @userlgolimpi. This way, you can keep your financial data and books updated.

 

Since the goods are returned in July, you'll have to enter a Supplier credit in QBO. Then, match it to the credit that reflects on your bank statement before you reconcile your account. With this, you're able to resolve the difference between your bank record and in QuickBooks.

 

You can enter a supplier credit depending on how you record your purchases. Given that you enter bills to track your expenses, you need to make sure the credit hits the expense account you use for the supplier.

 

To do this, you'll first have to create a supplier credit by following these steps:

 

  1. Select + New.
  2. Select Supplier credit.
  3. In the Supplier dropdown, select your supplier.
  4. Depending on how you record purchases with this supplier, enter the Category details or Item details. Usually, this is the category, product, or service you’re getting credit for.
  5. Select Save and close82.PNG

 

Then, apply the supplier credit to the bill. Here's how:

 

  1. Select + New.
  2. Select Pay bills or Pay bill.
  3. Select a bill for your supplier from the list. You'll see the available credit with this supplier in the Credit Applied field.
  4. Complete the rest of the fields like you normally do.

 

In case you'll want to enter expenses or write cheques to enter supplier credits, you can check out this article to learn more about this: Enter a credit from a supplier.

 

Once you're done, match the Supplier credit to the credit that reflects on your statement. For the step-by-step guide, you can refer to this article: Categorise and match online bank transactions in QuickBooks Online.

 

Then, you're now set to reconcile your account. I'd recommend performing this process every month. This will help monitor your expenses and detect any possible errors accordingly. For the complete guide, check out this article: Reconcile an account in QuickBooks Online.

 

Also, I'm adding this article to guide you anytime you need help doing or fixing a reconciliation in QBO: Learn the reconcile workflow in QuickBooks.

 

Let me know how it goes in the comments below. If you have other reconciliation concerns and questions about managing supplier transactions in QBO, I'm always around to help. Take care, and I wish you continued success, @userlgolimpi.