cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

I have a supplier with no open invoices, but has a supplier credit, which has now been refunded, how do i now match the bank deposit to the supplier credit note?

the bank transactions are downloaded directly from the bank and i am currently showing a deposit for a supplier, i have raised a supplier credit for the same amount but when i try to match from the bank transaction screen it only brings up customer invoices and when i try to create a cheque on the supplier account it says "You cannot add a credit for a supplier without any open bills".  we won't be using this supplier again and i have no open bills.

please help!

Solved
Best answer February 07, 2019

Accepted Solutions
Highlighted
Level 2

I have a supplier with no open invoices, but has a supplier credit, which has now been refunded, how do i now match the bank deposit to the supplier credit note?

This answer depends on the Control Account used for your suppliers, in most UK cases it's either Creditors or Accounts Payable, to save my typing I'll assume Creditors.

Allocate the bank deposit to the payee name and the correct bank account and date etc, under Account choose "Creditors" and enter the amount and No VAT as vat code (if this is being completed using downloaded bank transactions choose supplier name and account detail as Creditor)

If done correctly you should now see the deposit in the Supplier Account.

If you have auto match credits turned on this next step may be unnecessary.

I know it sounds strange but next to the deposit there will be an option to "Make Payment", click this, QBO should automatically bring the credit to the bottom of the cheque payment screen and total payment should be £0, and both deposit and credit should have a check mark and be paid off in full.

View solution in original post

13 REPLIES 13
Highlighted
Level 1

I have a supplier with no open invoices, but has a supplier credit, which has now been refunded, how do i now match the bank deposit to the supplier credit note?

Thank You!! this worked perfectly
Highlighted
Level 2

I have a supplier with no open invoices, but has a supplier credit, which has now been refunded, how do i now match the bank deposit to the supplier credit note?

Glad to hear.
Highlighted
Level 2

I have a supplier with no open invoices, but has a supplier credit, which has now been refunded, how do i now match the bank deposit to the supplier credit note?

Glad to hear.
Highlighted
Level 1

I have a supplier with no open invoices, but has a supplier credit, which has now been refunded, how do i now match the bank deposit to the supplier credit note?

Please could I ask for help in this matter. Im getting the same pop-up "you cannot add a credit for a supplier without any open bills'. Ive used "Trade Creditors' as the control account.  I've entered the Supplier Credit. Deposit is in the supplier account. But still have an entry in the Trade Creditors. How do I get passed the pop-up, & match the cheque against the credit?
Highlighted
Level 2

I have a supplier with no open invoices, but has a supplier credit, which has now been refunded, how do i now match the bank deposit to the supplier credit note?

This answer depends on the Control Account used for your suppliers, in most UK cases it's either Creditors or Accounts Payable, to save my typing I'll assume Creditors.

Allocate the bank deposit to the payee name and the correct bank account and date etc, under Account choose "Creditors" and enter the amount and No VAT as vat code (if this is being completed using downloaded bank transactions choose supplier name and account detail as Creditor)

If done correctly you should now see the deposit in the Supplier Account.

If you have auto match credits turned on this next step may be unnecessary.

I know it sounds strange but next to the deposit there will be an option to "Make Payment", click this, QBO should automatically bring the credit to the bottom of the cheque payment screen and total payment should be £0, and both deposit and credit should have a check mark and be paid off in full.

View solution in original post

Highlighted
Level 2

I have a supplier with no open invoices, but has a supplier credit, which has now been refunded, how do i now match the bank deposit to the supplier credit note?

Hi,

 

I have tried following the steps but I have invoices to match and then a credit. So on the bank feeds I have matched the invoices & then 'resolved difference' putting this to the supplier, creditors, no VAT.

When I look at the supplier account there is the bank deposit there but no 'make payment' button. 

Any ideas?

Highlighted
QuickBooks Team

I have a supplier with no open invoices, but has a supplier credit, which has now been refunded, how do i now match the bank deposit to the supplier credit note?

Hello Charlotte_DRH

 

In the instance that you have no bills on the account and no make payment button you can create a dummy bill in order to be able to have access to this option.

 

If you create a bill for the same supplier,make it for a penny,just so it is more clear it is a dummy bill(it will be deleted in a later step)filling in  date and VAT and use the save button(not the save and close).

 

You will then see a make payment in the top right if you click on that you should see the dummy invoice ticked as well as your deposit and the credit note.If you make sure the credit note and deposit are ticked and then untick the dummy invoice and save and close.

Then it is just a case of clicking into the 1penny bill you have created and going to more on the bottom black banner and then delete

 

Any queries on this just reply back here on the Community

 

Emma

Highlighted
Level 1

I have a supplier with no open invoices, but has a supplier credit, which has now been refunded, how do i now match the bank deposit to the supplier credit note?

Hi, I followed this process; however after deleting the dummy bill I'm left with £0.01 overdue on the Supplier account. How do I remedy this?

 

Thanks

Rob

Highlighted
Moderator

I have a supplier with no open invoices, but has a supplier credit, which has now been refunded, how do i now match the bank deposit to the supplier credit note?

Thanks for checking this out, Robert Nisbet.

 

One possible reason why you're left with a 0.01 overdue on your Supplier account is that, the amount from the dummy bill created remained after deleting the bill. To fix this, just open the Bill Payment and manually change the amount to zero.

 

I'll be your guide on how to achieve this.

 

  1. Go to Expenses on your left menu and choose the Expenses tab.
  2. Locate the Bill Payment.
  3. From the amount field, manually change it to 0.
  4. Click Save and close.

After performing the above steps, there should no longer be an overdue on your Supplier account.

 

If you need further assistance or follow-up questions, just leave me a reply below and I'll be sure to get back to you. Take care and have a good one. 

Highlighted
Level 1

I have a supplier with no open invoices, but has a supplier credit, which has now been refunded, how do i now match the bank deposit to the supplier credit note?

Hi.

 

The Amount already shows zero.  In the deposit, the Original Amount is £176.61, and the Open Balance is £176.61, however the Payment is £176.60.  Whenever I try to edit anything and Save, it asks for an account for the transaction in the Bank/Credit account box.  So I cannot save any changes I make.

Highlighted
QuickBooks Team

I have a supplier with no open invoices, but has a supplier credit, which has now been refunded, how do i now match the bank deposit to the supplier credit note?

Thank you for getting back to us here on the Community page, @Robert Nisbet.

 

Yes, you have to select a bank account from the section so you'll be able to successfully record the changes. Then, delete the dummy bill to zero out the balance as suggested above.

 

If the problem continues, I suggest deleting and recreating the entries.

 

Let me know if you have any other questions. I'm a few clicks away to help. Have a good day!

Highlighted
Level 1

I have a supplier with no open invoices, but has a supplier credit, which has now been refunded, how do i now match the bank deposit to the supplier credit note?

Thank you so much for this answer! I have struggled with this problem myself for a couple of hours and to just read this and have this finally solved is a life saver!

Highlighted
QuickBooks Team

I have a supplier with no open invoices, but has a supplier credit, which has now been refunded, how do i now match the bank deposit to the supplier credit note?

You're always welcome, @SUSUZ.

 

Please know that our doors are always here on the Community page. If you have any other questions in the future, feel free to leave a comment below. Also, you can read our help articles if you need related topics while working with QuickBooks.

 

Keep safe!