Skip to main content
P
ProSite
December 3, 2020
Question

QB Checks Not Matching Bank Download

  • December 3, 2020
  • 2 replies
  • 0 views

When we write checks from Quickbooks, why are they not matching in the download file from our bank automatically? Most are showing up as "Split" in the "Account" field in the Matching tab. 

2 replies

J
JonpriL
December 3, 2020

Hello @ProSite,

 

Let me help share information about how you can work well with your bank transactions in QuickBooks.

 

To start with, you can easily match your downloaded transaction as long as the amount and date are the same as the existing ones in your register.

 

Saying your transactions did not match automatically, have you created a rule to accomplish this. That being said, here's an article you can read to learn more about how you can match your bank transactions: Add and match Bank Feed transactions in QuickBooks Desktop.

 

Additionally, I've also included this helpful article for the troubleshooting steps in case you'll bump into issues while working with your bank transactions: Learn how to fix some of the OL and OLSU Bank Feeds errors in QuickBooks Desktop.

 

If you have any other concerns, please let mow by leaving any comments below. I'll be here to lend a hand. Stay safe and well!

P
ProSiteAuthor
December 3, 2020

I have reviewed those solutions. It appears that it's saying we have to create Rules for each vendor in order to match them to the check created in QB? That doesn't make sense to me. 

 

If, when we write the check, we put in the vendor name, category, etc. why wouldn't it automatically match up on the downloaded bank statement?

MaryLandT
MaryLandT
December 3, 2020

Thank you for getting back to us, ProSite.

 

I can share some details about why those checks aren't matching in QuickBooks Desktop. You don't have to make a bank rule for each vendor.

 

You can find those checks on the register and verify that they're not matched to another downloaded transaction or have been reconciled. Both of these will prevent a transaction from being able to be matched.

 

You need to clear those reconciled checks so you can match them. Let me show you how:

 

  1. Go to the Lists menu, then Chart of Accounts.
  2. Double-click the account, then locate the check.
  3. Change the status by clicking the Checkmark column.
  4. Then, go back to the Bank Feeds and match your transactions.

Once done, make sure to go back to your register, and put a checkmark. Doing this will keep the balance accurate.

 

Let me know if you need additional information about matching transactions. I'm always glad to help you.

J
JuicysBurgers
January 19, 2023

the "match" has been working for many years, I don't remember doing anything.

 

 

Terms & ConditionsAccessibility statement