Reconciliation Errors: Reconciliation Rule and Rule Set

To ensure a smooth and error-free reconciliation process in Sage Intacct, it is essential to configure your Reconciliation Rules and Rule Sets properly. Without these, you may encounter the following common errors:

  • "There are no rules associated with the rule set".
  • "Could not create banktxnrulerun record!"
  • "Apply a matching rule set to this account before reconciling with an import or bank feeds."

Follow the steps below to resolve these issues and streamline your bank reconciliation process.

Step 1: Create a Reconciliation Rule

  1. Navigate to Cash Management → Setup → Reconciliation rules → Matching and creation rules.

  2. Click Add to create a new rule. Sage requires at least one rule to be created.
    There are two types of rules you can create: Match Rule and Create Rule. 

    • Match Rule - Automatically matches imported bank transactions with existing Sage transactions.
    • Create Rule - Generates new Sage transactions based on imported bank data.

  3. Once your rule is configured, click Save.

Tips

  • A commonly used rule is one that matches by Document Number, or at a minimum, ensure you create a rule that matches based on Amount.

  • Add a Filter Rule to pre-filter transactions before applying your matching or creation rules.

Step 2: Apply Rule(s) to Rule Set

  1. Navigate to Cash Management → Setup → Reconciliation rules → Rule sets.

  2. Click Add to create a new rule set. You can select an existing one as well.

  3. Click Select Rules and check the rule(s) you want to add to the Rule Set. Click Add once you've selected your rules and click Save.

Step 3: Add the Rule Set to Bank Account

  1. On the Rule sets page, go to the Accounts tab and click Select accounts.

  2. Select the bank account(s) you want associated with the Rule set and click Add.

  3. Click Save to apply the changes.

Your reconciliation setup is now complete. With your rule set correctly configured and assigned, Sage will automatically match or create transactions during bank reconciliation, eliminating common errors and saving you time.

If you need any more help or want to explore more advanced rule configurations, please refer to the Sage help documentation.