SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Gafana
Level 1

How do I get Quickbooks Online to always prioritize matching cashed checks in bank transactions with CHECKS written in quickbooks that match the amount & check # rather than random expenses?

I have hundreds of checks cashed on our bank account every month and maybe 75% of the time, Quickbooks Online properly matches the cashed check with the associated check that was written in Quickbooks. However, if the amount of the check that was cashed matches some other random expense, regardless of where that expense is from (e.g. transactions from credit cards, ATM withdrawals, ACH transactions, etc), it always matches the cashed check to one of these random transactions rather than prioritizing the actual check that was written in quickbooks with the matching amount and matching check number.

 

It's identifying the check number correctly on the bank transaction but still not prioritizing the matching written check. It's absolutely silly and causing me hours of work manually unmatching a few hundred checks, manually rematching them correctly, then fixing the other transactions it incorrectly matched it to originally.

 

Basically, how do I get Quickbooks Online to always prioritize matching cashed checks in bank transactions with CHECKS written in quickbooks that match the amount & check # rather than random expenses?

2 Comments 2
CharmieH
QuickBooks Team

How do I get Quickbooks Online to always prioritize matching cashed checks in bank transactions with CHECKS written in quickbooks that match the amount & check # rather than random expenses?

Matching your bank transactions efficiently is our top priority, Gafana. I'll provide more explanations about matching transactions in QBO.

 

QuickBooks helps you by suggesting possible matches for your transactions, but you get to confirm them. It provides suggestions mainly for regular bank transactions and automatically matches transactions linked to QuickBooks PayrollBill Pay, and Payments.

 

QuickBooks recommends matches that have the same dollar amount and occur on the same date or within a date range from 90 days before to 20 days after the transaction.

 

Check numbers won't matter when matching transactions. If the suggested matches don't seem right, or if there are none, you can always select 'Find other matches' to do the matching manually.

 

Additionally, you can also provide direct feedback to our engineering team. They can consider your suggestion and potentially include it in future updates. We value customer feedback as it helps us enhance the various features of our products.

 

Here’s how:

 

  1. Select the Gear icon, then choose Feedback.
  2. Enter your comments or product suggestions.
  3. Select Next to submit.

 

You can also set up bank rules to help you automatically categorize transactions from your bank. Check this resource for more information.

 

Hit the Reply button below if you need more help. The Community team is here to back you up.

AccountantAtAcgile
Level 2

How do I get Quickbooks Online to always prioritize matching cashed checks in bank transactions with CHECKS written in quickbooks that match the amount & check # rather than random expenses?

QuickBooks Online prioritizes matching bank transactions by amount and date, not check number. This causes it to incorrectly match cashed checks to random expenses. Manual matching is currently the only solution.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us