Hello, @alex51.
I wish you didn't have to go through all that just to match your bank transactions. Allow me to assist you in sorting this out.
In QuickBooks Online (QBO), we can create rules that automatically categorize transactions. When you set up a bank rule, you no longer have to look for a match on your bank feed transactions manually. The more we utilize bank rules, the better it gets at categorizing. Here's how:
- From the Banking menu, choose Rules.
- In the upper-right corner, click on New Rule.
- Fill in the required fields of the form.
- Set the rule conditions. You can set a single rule with up to 5 conditions. Set and include the following, then select + Add a condition.
- In the Conditions fields, specify whether the rule applies to Description, Bank text, or Amount. Then select Contains, Doesn't contain or Is exactly to decide how QuickBooks applies the rules.
- At the bottom, ensure that Automatically confirm transactions this rule applies to is turned on.
- Select the settings for the rule. Select the Transaction type, Category, Tags, and the Payee to apply.
- Click on Save.
QuickBooks automatically applies your rules to transactions in the For review tab. These are the ones you need to review every day.
Also, in QBO, there are cases where some of the transactions can't find their match from existing records. You may click on this article to know the possible reasons: Find out why there are transactions that don’t have a match.
Additionally, I've included an article that will guide you in case you want to categorize your banking transactions in the future: Assign, Categorize, Edit, and Add your Downloaded Banking Transactions.
Should you need any additional assistance in matching your bank transactions, I'm just a reply away. Have a great day!
