Skip to main content
R
Rosie_41
January 29, 2022
Question

Match Paid Bills with Bank Feeds confusion

  • January 29, 2022
  • 1 reply
  • 0 views

Hello
I would like to know how do I match a paid bill with the bank feed for reconciliation purposes. I have now realized that you have to "match" the transactions which is all well and good. But what I am confused about is why is there an option to, say, pay for a bunch bulk invoices for a total of $430, because that's what you've paid the suppler,  mark it as paid, and then find that you can't actually match that "transaction" with the bank feed? What do I need to do? Thanks.

1 reply

LieraMarie_A
LieraMarie_A
January 29, 2022

Hi there, @Rosie_41. I'm here to ensure you can match your bill payment with the bank feed transaction.

 

QuickBooks Online bank feeds feature allows you to match your payment to an open bill. When you enter the payment using "Pay Bills," you'll have to link the bill payment with the bank feed transaction.

 

Have you tried using the filters available when finding a match? There are a few ways to find what you're looking for. You can select a specific transaction type and time period to narrow down the results. You can also use the Search field to locate transactions by amount, reference number, or memo. 

 

  1. Go to the Transaction menu and select Banking.
  2. Select the tile for the account you want to review.
  3. Select the For Review tab to start your review.
  4. Select the deposit to expand the view.
  5. Choose Find match.
  6. You can use filters/search to locate transactions. Remember to use a dollar sign or decimal point when searching for dollar amounts.

 

If you're still unable to find a match, let's perform basic troubleshooting steps. Issues like this are usually the result of outdated or corrupt cache files in your web browser. We can clear them in just a few easy steps. Let's start by accessing your account through an incognito window to rule out the possibility of a webpage issue. You can refer to these shortcut keys to open an incognito window in all supported browsers:

  • Chrome: Ctrl+Shift+N
  • Firefox: Ctrl+Shift+P
  • Safari: Command+Shift+N

 

If it's responsive, I recommend that you clear your browser's cache. By clearing them, you can remove that historical data and access QuickBooks with a clean slate. You can also switch to a different supported browser to see if it has something to do with your browser.

 

Here are some resources that will help you in managing your bank feeds:

 

Please come back and let me know if you need more help with categorising your transactions. It's my priority that you find the success you need.

R
Rosie_41Author
January 30, 2022

Hi thanks for the reply but you are referring to an open bill. I am talking about a closed bill that has been paid before the bank feed or because I did not look at the feed. Should I exclude that amount sitting in the bank feed as I cannot match it with anything now, as I don't want to double up on payments?  I have looked through my individual invoices which are marked 'paid', so going by other posts, my best option is to exclude, knowing that I have those invoices paid. Please advise if this is the best way. Thank you.

T
TirzahC
January 30, 2022

Hello there, Rosie_41.

 

QuickBooks Online lets you match transactions with the same amount. Since the system doesn't allow you to match the deposit to your open invoice, I'd suggest excluding the transaction from the banking page and manually receiving the payment.

 

Here's how to exclude the deposit:

  1. Click Transactions in the left panel and choose Banking.
  2. In the For Review tab, select the transactions you want to Exclude. 
  3. Tap on the Exclude button.

Check out this article to know more about this process: Exclude expenses from downloaded bank transactions. Once excluded, you can follow the steps in this article to manually record the payment: Record invoice payments in QuickBooks Online

 

Additionally, I recommend editing, assigning, and categorizing your transactions. Also, you can match them to the existing entries in the software. Just go to the For Review tab from the Banking menu. Doing so will help you ensure the accuracy of your financial records.

 

If you need some resources, these links are for you:

Keep me posted if there's anything else you need. I'm always around here in the Community forum to help.

Terms & ConditionsAccessibility statement