Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27
Buy nowI 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?
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 Payroll, Bill 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:
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here