Bank reconciliation often raises questions about matching transactions, creating rules, and managing exceptions. To address these common challenges, we are launching a blog series focused on frequently asked questions and practical guidance for making the reconciliation process more efficient and accurate.
In the first blog of the series, we explore bank rules in Sage Intacct. Future posts will cover additional bank reconciliation topics, including matching transactions and creating reconciliations.
Bank rules in Sage Intacct can help finance teams manage bank transactions and complete reconciliations more efficiently. Creation rules can create transactions that have not already been recorded in Intacct, while matching rules can connect bank activity to existing transactions.
Selecting the right type of rule is an important first step. From there, users need to choose specific filters, test the rule and confirm that it works as intended. If a rule does not trigger or a bank feed becomes disconnected, a few common troubleshooting steps can help identify the issue.
Before creating a rule, it is important to understand how bank and credit card activity appears in the feed.
For bank accounts, transactions generally appear as:
For credit card accounts, transactions generally appear as:
Identifying the correct transaction type will help determine the filters used in a creation or matching rule.
When deciding which rule to use, ask the following questions:
Creation rules are used for transactions that do not need to post to a subledger and have not already been entered in Intacct.
Examples include:
Transactions created as journal entries do not update 1099 information in the same way as a subledger transaction. Because of this, creation rules should not be used for transactions that need to update the 1099 field.
Creation rules should also not recreate transactions entered through another process. For example, payroll checks already imported through ADP should not be created again through a bank rule.
Matching rules are used when the transaction has already been recorded in Intacct and needs to be matched to an activity from the bank.
Examples include:
Matching rules can be especially useful when several transactions recorded in Intacct appear as one lump-sum transaction at the bank.
For more helpful tips and tricks about Sage Intacct, subscribe to our blog and stay up-to-date with our latest tutorials. We're dedicated to providing valuable resources for businesses looking to optimize their financial management with Sage Intacct.
Sage Intacct R2 2026: What You Need to Know about the Latest Release
No Plaid? No Problem: Automating Bank Feeds in Sage Intacct
Create Expanded Columns and a Summary for Reports in Sage Intacct