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

How to match auto bank feed to supplier credits and bills as when a 'find match' from the Bank payment

Hi-How to match auto bank feed to supplier credits and bills as when a 'find match' from the Bank payment feed is initiated ONLY bills appear NO cr? If I go to "Pay Bills"I can select the cr BUT then I end up creating dupl.payment as the bank feed shows that payment already. Pls help asap Tks

3 REPLIES 3
Highlighted
Moderator

How to match auto bank feed to supplier credits and bills as when a 'find match' from the Bank payment

Thanks for posting in the Community, @Hom.

 

When using the Find Match option on the Banking page, you'll only see the bill, not the supplier credit.

 

Based on the information you've shared, you'll need to link the supplier credit to the bill first. This won't create a duplicate since the downloaded transaction from your bank is different from the one you have in QuickBooks Online (QBO).

 

Here's how:

 

  1. In QBO, go to the + New option at the top left.
  2. Select Expense or Cheque (both both of them recognise and record the expense). 
  3. Choose the supplier name in the Payee drop-down.
  4. Leave the Ref/Cheque no, Date, Amount and Memo fields blank.
  5. In the Add to Expense or Add to Cheque section, tick Add for the outstanding bill and supplier credit.
  6. Select Save and close.

 

Once done, you can now match the downloaded bank transaction. For further guidance on how to do it, check out this article and proceed to the Match an existing transaction section: Categorise and match online bank transactions in QuickBooks Online.

 

For more insights about managing supplier credits in QBO, please refer to this article: How do I handle supplier credits and refunds?

 

Let me know if you have any other questions or concerns by leaving a comment below. I'll be more than happy to help. Have a good one!

Highlighted
Level 2

How to match auto bank feed to supplier credits and bills as when a 'find match' from the Bank payment

Hi Thanks for the response a week ago. Followed the instruction to set the 1st part of the course ie select the inv.& Cr notes matching the auto bank feed payment amount. The step +New>Expense>Leave Ref/Cheque noDateAmount and Memo fields blank>Add to Expense>Save and close produced an error message 

"Something's not quite right. You must specify a date"' PLUS one cannot really leave the amount 'BLANK' as when the inv and cr notes are selected, it adds the amount to total and the fields are populated.

I may have missed something in your instructions.

What I am looking for is to 'match the auto feed payments to the supplier bills and credits 'easily' as QBO unlike other packages do not display credits of suppliers for matching-only inv!. Hope you can assist again. Many thanks [email address removed]

Highlighted
QuickBooks Team

How to match auto bank feed to supplier credits and bills as when a 'find match' from the Bank payment

You're almost there, Hom!

 

As mentioned, you'll only see the bill, not the supplier credit when matching transactions. So what you need to do is to link them.

 

Once you select the supplier name in the Payee drop-down, the Add to Expense or Add to Cheque section appears. From there, click the Add on both Bill and Supplier Credit

 

Before clicking Save and close, please make sure that the bill and supplier credit have the green checkmarks.

 

If you need detailed guide, you'll want to check these articles:

Post again here if you need anything else. Wishing you all the best!