News & Insights

Sage recently introduced a more flexible and robust way to match incoming transactions for reconciliation. Matching rules enable you to take that extra step in analyzing transactions against your Sage Intacct data for a faster, simpler reconciliation with less manual matching.

NOTE: Previously, incoming transactions for an import file or a bank feed were matched using matching attributes. Matching attributes won’t be available after this release. Before you can reconcile with an import file or bank feeds, you need to set up matching rules for an account.

Details
In this release, you can create matching rules to ignore leading zeroes on incoming checks and match by amount and doc number. You can look forward to even more matching capabilities in the future. But for now, let’s take a deeper dive into how matching rules work and setting them up.

New permissions
Before you can set up matching rules and rule sets, enable the Cash Management permissions for Bank Transactions Rules and Bank Transactions Rule Sets.

Matching rules
Matching rules define how incoming transactions are matched against your Sage Intacct data. For example, you can set up a rule to ignore leading zeroes. Each rule requires you to include a matching condition to match by amount. If you want, you can create a more advanced rule that only looks to match certain Sage Intacct transactions. For example, you might want to match transactions by document number and amount, but only look at transactions from a certain bank.

Matching rule sets
After you create a rule, add it to a rule set. Rule sets act as containers for rules. Within the rule set, you can prioritize which rule you want to run first. As a best practice, make sure that your most specific rule runs first.

When you’re satisfied with how your rule set looks, assign it to an account. An account can only have one rule set. However, you can assign one rule set to multiple accounts.