cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get your Payroll questions answered by a QuickBooks Product Manager here - intuit.me/31Nl3My
andy11
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
Richard TBS
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

15 REPLIES 15
andy11
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
Richard TBS
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.
Richard TBS
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.
lornaloux
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?
Richard TBS
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

Charlotte_DRH
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?

EmmaM
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

Robert Nisbet
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

Charies_M
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. 

Robert Nisbet
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.

Angelyn_T
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!

SUSUZ
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!

Angelyn_T
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!

 

 

SP24
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 have a similar problem.  

Supplier credit has been entered on QB, direct bank feed is showing equivalent amount, but how to match the two?  I have followed the guidance on creating a deposit, but when I go to enter a cheque I receive the message about not having any open invoices.  I have tried creating a 0.01 bill to then and followed the instructions, but all that shows when I go to 'make payment' is the supplier credit and the 0.01 bill - no deposit.  I can't then match if I untick the 0.01 bill.

Can anybody advise please?

 

Thanks

 

EmmaM
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 SP24, The deposit should show as long as you have selected creditors in the account section in add funds to this deposit and selected the supplier in the payee. The only reason usually if you have done this why it may not is if you have more than one creditors chart of account( for example if you moved from desktop QuickBooks and it has moved the multiple creditor accounts) if you have one than one if you can make sure it is pointing to the default creditors account. If you need any further help on this just reply back here and we'd be happy to assist further.-Emma