Setting Up Rules for Imported Transactions

Background

As an Accounting Basic or Premium customer who imports your bank transactions, you can add rules to automatically assign your transactions to your accounts and departments, if you have set up departments.  This prevents you from having to select an account and department for each transaction you import.  For more details on importing transactions, see the following help articles:

• Connecting Your Bank Accounts For Accounting Journal Entries
• Manually Importing Your Bank Transactions

How to Set Up Imported Transaction Rules

You can add rules from your Settings page, or you can add a rule from an imported transaction.

From Settings:

1. Go to Settings > Accounting Settings > General Settings > Transaction Rules.
2. Click “Add a Rule.”
3. In the “Include” box, add the text or alphanumeric characters that regularly appear in your transaction description that you want to include. You can enter more than one word in this box.  Each additional word will be looked at as an “AND,” so the transaction would need to include each word you add. You can also enter partial words, if needed.
4. If you want to add criteria to have the rule look at the text previously entered “OR” other text, click “Add Additional Criteria” and enter the additional text.
5. If you want to exclude text, enter the text in the “Exclude” box
6. Add a name to your rule.
7. Select the account to post these transactions.
8. If you have set up departments, assign a department.  This is optional.
9. If there are any existing transactions already posted in your ledger that match your rule, they will appear in the Matching Transactions list.  This will show you the types of transactions that your new rule would apply to in the future.

From an Imported Transaction:

1. Go to your main Accounting menu > Financial Tasks > Manage Imported Transactions.
2. If you have transactions waiting to be posted, either automatically from your bank, or a manual spreadsheet import, they will appear here.  
3. Choose a transaction you want to set a rule for.  Click the gear icon at the end of the row, and choose “Create a new rule for this transaction.” Follow the same steps as above to create the rule.
4. You can also add this transaction to an existing rule you have added. 
   • Click the gear icon at the end of the row, and choose Add this transaction to an existing rule. 
   • Select from your rules you have set up
   • Click “Continue.”

When your bank transactions are imported, and a rule is applied, you will see a magic wand icon at the by the category if it was automatically assigned.  If you hover your mouse over the icon, you’ll see the name of the rule this transaction is assigned to.  If needed, you can override the account and/or department that the rule assigned.

If you are automatically importing your transactions and see a clock icon at the category, we are using your history to determine the correct account, based on what you have previously categorized.  You can choose to set up a rule for this type of transaction, or allow the history to determine the account.

Note: If a transaction matches more than one rule, the most recently created rule is applied.

Was this article helpful? *

• Yes
• No

Comments:

Submit

Your feedback will not receive a reply. If you have a specific issue, please reach out to our support team here.