Solved

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?

Forum|Forum|7 years ago
February 7, 2019
6 replies
0 views

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!

QuickBooks Online

Best answer by Richard TBS

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.

A

arkvalleyinfoAuthor

Thank You!! this worked perfectly

Glad to hear.

Glad to hear.

arkvalleyinfoAuthor

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?

R

Richard TBSAnswer

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.

C

Charlotte_DRH

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?

E

EmmaM

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

Angelyn_T

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!

S

SP24

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

E

EmmaM

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded