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
stuart14
Level 1

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?

The supplier invoice (expense) and the supplier credit are both already entered on QB. When I try to match the bank transaction, I can't select the supplier credit already entered on QB.
Solved
Best answer April 07, 2020

Accepted Solutions
John C
QuickBooks Team

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?

Hi stuart14

 

You will have to delete the expense and create a bill, then when you select ,make payment you will be able to link the supplier credit, the payment will link to the amount on your banking page.

View solution in original post

15 REPLIES 15
Ashleigh1
QuickBooks Team

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?

Hello Stuart14, 

 

Welcome to the Community page,

 

Have you linked the invoice and the supplier credit together?

 

When you are in the invoice, if you click on receive payment it will show the invoice and the credit applied, once both of these are ticked and you save and close this it should then find the match on the banking page on that transaction for you. 

stuart14
Level 1

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?

Thanks Ashleigh1,

 

Your suggestion NEARLY works.

I get an error message "You cannot add a credit for a supplier without any open bills".

Rather than creating an "expense" for the supplier invoice, do I have to create a "bill"?

John C
QuickBooks Team

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?

Hi stuart14

 

You will have to delete the expense and create a bill, then when you select ,make payment you will be able to link the supplier credit, the payment will link to the amount on your banking page.

View solution in original post

Ire Return
Level 1

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?

Hi, and if i cant match to the original invoice? I have received a refund from supplier to my bank. I have a supplier credit already in the system. But I still cant match these two together

JenoP
QuickBooks Team

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?

Hi there, Ire Return.

 

QuickBooks will consider it a match if they have the same amount and transaction dates fall within a 90-day period. If the date is beyond 90 days, change the From and To dates when find a match. Here's how:

 

  1. Click the transaction that you need to match, then click Find match.
  2. Change the From and To dates to include the date of both transactions.
  3. If you can already see the invoice, check the box before it and click Save.

Here's a guide for more details: Categorise and match online bank transactions in QuickBooks Online.

 

Let me know if you need anything else. 

 

Ire Return
Level 1

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?

Thank you.

I have a supplier credit that was returned to my bank account on 21st of April. When I do "Find Match", system gives me just all possible sales (like open sales invoices, sales receipts...) . There is no option on drop-down list to choose purchases (supplier credits). 

Thank you,

Ashleigh1
QuickBooks Team

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?

Hello Ire Returns, 

 

To be able to record this you will need to link the supplier credit to a deposit in Quickbooks. Then you could add the refund from the bank to creditors then make payment on a bill and link the supplier credit and the deposit together that way. To match it up on the banking page. 

 

AndrewBI
Level 1

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?

The problem is that when I go to pay a bill it shows that there is a credit, when actually there is no credit that is due, all previous bills from the suppllier have been paid? There are no bills from the supplier that equate to the credit being shown. No bills have been entered twice nor have they been paid twice. There is a bill for the credit amount but back in Nov 2018 and a cheque for the payment. But the bill is not marked as being paid. Have run a reconcilliation which does not show anywere this amount and the reconcilliation checks out.

Maybelle_S
QuickBooks Team

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?

Hello there, @AndrewBI.

 

To isolate this issue, we can link the cheque to the bill to mark the bill as being paid. However, I'd also recommend seeking assistance from your accountant so you'll be guided when linking the transactions.

 

Here's how:

  1. Open the Bill.
  2. Click the Make Payment button below the amount of the bill. 
  3. On the Bill Payment page, check the Bill in the Outstanding Transactions section.
  4. Mark the Cheque transaction in the Credits section.
  5. Click Save and Close

You can refer to these articles for more detailed information about managing supplier-related transactions:

Also, if you want to know how much you're paying each supplier every month, you can visit these articles:

Stay in touch with us if you have other questions. I'm more than happy to help. Take care!

MikeTombs
Level 3

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?

Why don't open supplier credits appear in the list of transactions that can be matched? If paying one or more invoices and deducting one or more credit notes, the credit notes don't appear when trying to match the bank payment to the underlying transactions.

JenoP
QuickBooks Team

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?

Hi there, MikeTombs.

 

A customer's credit needs to be applied to a customer's invoice before it can be matched to a downloaded transaction. This is because it's not yet considered a payment unless used in an open transaction. Check out these articles for more details: 

 

 

Also, make sure that the date is correct to make sure that you can see the applied credit when looking a or a match. If you can't still see it, follow these steps to check if it's caused by a browser issue:

 

Start by using an incognito/private browsing session or a different browser. Here are some of keyboard shortcuts to quickly open an incognito session: 

 

  • Ctrl Shift N  for Google Chrome
  • Ctrl Shift P  for Firefox
  • Control Option +if you're using Safari
  • Ctrl Shift P for Microsoft Edge

 

Once done, go back to your account and check if you can already see the credit when looking for a match. If you can, follow the steps in this article to delete your browsing history: Clear Cache And Cookies To Fix Issues When Using QuickBooks Online.

 

Let me know if you have follow-up questions. We're always here to help. 

MikeTombs
Level 3

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?

Thanks, but that doesn't help. There are already workarounds - I just want it to work properly.

 

The query was about suppliers not customers. In any event, allocating credit notes to specific invoices ignores the fact that the invoices may have been paid already so the credit notes are being taken against unrelated invoices, the credit notes may be more general in nature, later credit notes may be taken earlier than the due date of the related invoices (yes, people do that) and it's just an extra processing step. Open credits just need to appear with open invoices when allocating payments from bank transactions. Judging by the comments in the Facebook group, nobody is happy with this fault in QBO. Credit notes should always just be considered the same as invoices, but with a negative value.

ShiellaGraceA
QuickBooks Team

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?

Thanks for getting back to us here today, @MikeTombs.

 

As mentioned by my colleague @JenoP, credit notes need to be applied first to an invoice before it can be matched. Thus, it won't also appear when matching payments.

 

At the moment, transactions that are posted in the bank are the ones that can be matched. While credit notes are only posted in the AP/ or A/R account. 

 

I'm also attaching this link here if you need help with other tasks in QBO. It has topics with articles that'll help you along the way.

 

Let me know if you still have questions or concerns with credit notes or the account. I'll be around for you. Take care and stay safe.

twoteds
Level 1

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?

Hello Mike , you are absolutely correct, the work around (which I do not understand) is total rubbish.

If you send a remittance to your supplier, it will show a value for the invoice which does not match that which was sent by that supplier. Not only that but they will not see the settlement of the credit note either.

This is a massive limitation to QB and effects direct debit payment to suppliers as well. Why have they not sorted this out? Good luck Mike!

MikeTombs
Level 3

How to match a single bank transaction which relates to a supplier invoice and a supplier credit?


@twoteds wrote:

Hello Mike , you are absolutely correct, the work around (which I do not understand) is total rubbish.

If you send a remittance to your supplier, it will show a value for the invoice which does not match that which was sent by that supplier. Not only that but they will not see the settlement of the credit note either.

This is a massive limitation to QB and effects direct debit payment to suppliers as well. Why have they not sorted this out? Good luck Mike!


As you will have seen, the QBO response is 'Do unnecessary additional work because we programmed it incorrectly and can't be bothered to fix it'. It really doesn't help when they just explain how to work around their faults.