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!

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 no, Date, Amount 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]

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:

• Categorise and match online bank transactions in QuickBooks Online
• Reconcile an account in QuickBooks Online

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

Hi,

Good day to you. I have the same issue that you have mentioned the solution here, but unfortunately, after following all the steps still in my banking area of QuickBooks I am not able to match the expense. Therefore, I am not able to finish my reconciliation.

Would you please advise me regarding this issue?

I highly appreciate your kind assistance.

Sincerely yours,

Parisa.

I appreciate you for following the steps provided by my colleague on how to match the transactions, @Parisa.

Since you're still unable to match the expense transactions, let's check your bank register and verify that they're not matched to another downloaded transaction or have been reconciled. There will be two Green squares in the Reconcile status column if they've been matched. Additionally, an R will signify that it's reconciled. Both of these will prevent a transaction from being able to be matched.

If it's already reconciled, you can clear the transaction in the bank register and match it with the expense, you can follow these steps:

1. On the left panel, select Accounting > Chart of Accounts.
2. Click the View register link of the bank account where the check was added.
3. Find and select the transactions. Under the Reconcile (indicated by a checkmark) column, click the blank field until you see the letter C. 
4. Press the Save button after.

In case QuickBooks doesn't still recognize the match, you can manually match the transactions: 

1. Click Banking.
2. Under For Review tab, select the transaction.
3. Select the Find match button.
4. Select the transaction.
5. Click Save.

You can refer to this article, for detailed steps: Categorise and match online bank transactions in QuickBooks Online.

Also, you can create a bank rule so transactions are automatically added. The bank rules will speed up the review process. For more details, you can visit this article: Set up bank rules to categorise online banking transactions in QuickBooks Online.

Once everything is matched, you can now reconcile the transactions. Check out this guide on how to do it in QuickBooks Online: 

• Reconcile an account in QuickBooks Online
• Fix issues the first time you reconcile an account in QuickBooks Online

That's it. This should help you point in the right direction. Let me know if you have further questions. I'll be here to answer them. Have a great day!

Yeah doesn't work unless you have some open bills.

Take this scenario - you pay your business insurance £500 you create a bill, pay the bill, match the payment and the bill and it's all done.

6 months later you change insurance provider and they refund you £250 of your remaining insurance so you have a credit in the banking section, there is no existing bill it's closed and paid off. 

QuickBooks is so horrible to use it's easiest just to exclude these and hope your accountant doesn't notice.

Re: step 5, I don't seem to have an "Add the Expense" or "Add to the Cheque" section. Can you walk me through that?

I'm glad to walk you through where to see the Add the Expense or Add to the Cheque option, LO21.

You'll want to make sure that the supplier has an outstanding credit. That way, the Add to Expense or Add to Cheque option will show up once you select a Payee. I'm adding this screenshot as your guide.

I'm adding these articles as your guide while managing bank transactions and supplier's creditds.

• Learn how to review downloaded bank and credit card transactions and put them in the correct account....

• Learn how to refund a customer or supplier or record a customer or supplier refund in QuickBooks Onl....

Get back to me if there are other features you want to see while working on your bank transactions. I'm always right here to help you.

Final step didn't work.

I added a deposit and account was the supplier account.  Matched on bank feed

When I go into supplier account I do not see the deposit to match to the credit note .

help.

thanks

Jenny

Hi Jenny, thanks for joining this thread - please un-match the deposit in the categorised bank feed and then go back to the suppliers account to create the cheque to link the deposit to the supplier credit.