Skip to main content
January 14, 2021
Question

Matching Bank Records to Existing Bills

  • January 14, 2021
  • 1 reply
  • 0 views

Hello,

 

Within the Bank Feed screen, when I select the "Add One to Quickbooks" button at the bottom of the Downloaded Transaction area, it only sometimes gives me the option to match to an existing bill.  Other times it skips that question and directly opens a screen labelled "Enter Credit Card Charges".  Why is this?  How do I fix this so I can match to a Bill I have already entered?

 

Thanks,

1 reply

Rebecca R
January 14, 2021

Hello again Bookeeping101. I hope you're well.

 

The Bank Feeds feature in QuickBooks Desktop enables you to download your bank and credit card transactions by connecting to your financial institution. This makes processing your transactions a more efficient process, which allows you to spend more time doing what you love. It's a win-win! I love that you've been making the most of this feature. I'll go over how the process of matching your transactions works so you can be sure you're doing it correctly.

 

Once your statement downloads, the next step as you know, is to match the transactions to the ones you've entered into QuickBooks. As long as the transaction has been entered into QuickBooks, doesn't have any typos or errors, was entered into the correct account, and the financial institution hasn't made any errors, the transactions should match up when you follow the steps above:

 

  1. Navigate to the Banking menu.
  2. Choose Bank Feeds, then select Bank Feeds Centre.
  3. Open the window to Match Transactions and choose the correct account from the Financial Institution dropdown. 
  4. Choose to Review Statement, download and view your statement, then find the Match Transactions window and ensure that the Show QuickBooks Transactions checkbox is selected. 
  5. Once the matches are completed, you'll see results on screen. Hit OK to close the window and review the status that QuickBooks has assigned to the statement.
  6. You'll have the option to agree with the match (do nothing) or disagree with the match and simply unmatch the transaction.

 

In this instance, it sounds like your transactions aren't matching the transaction you've entered into QuickBooks. In that case you'll need to match these transactions manually. To do that, follow the steps above up to number 4, then choose the transaction that you need to match to a transaction. Find the transaction in the QuickBooks Transactions to match to and make sure the amounts line up. Hit Match when you're satisfied.

 

If you're following these steps, you should have no trouble matching your transactions to bills you've entered into QuickBooks. If you do, please reach out and I'll be happy to help.