Gå til hovedinnhold

How to create custom reconciliation rules in the bank module

This guide shows how to set up custom rules for auto-reconciliation in the bank module in Accountflow.

Oppdatert for over en måned siden

Step by step: Create and use reconciliation rules

1. Go to the account you want to reconcile

  • Go to Account under Reconciliation in the menu on the left, and click the desired account in the account overview.

  • The account must use the Bank template to be able to use reconciliation rules.

  • Click Reconciliation Settings.

2. Create a new rule

  • Click + Add rule.

  • Select the type of rule you want to create:

    • One to one: one bank transaction matches one general ledger transaction.

    • One to many: one general ledger transaction matches multiple bank transactions.

    • Many to one: multiple general ledger transactions match one bank transaction.

    • Many to many: multiple general ledger and bank transactions match together.

💡 By default, four predefined rules are set up. You can edit, delete, and add more if needed.

3. Set up rule parameters

  • Give the rule a name and description.

  • Specify Priority if you have multiple rules – the system uses the rules in the order you set here.

  • Use the Text fields to filter content in the description from general ledger (GL) and/or bank.

  • You can also use Regex for advanced filtering.

💡 Use text filtering if you want the system to find transactions with e.g. the word “customers” in the description.

4. Adjust date range and offset

  • The Date range determines how many days the system should look for a match.

  • Offset shifts this range forward or backward in time.

    • Example: Date range 5 and offset 10 = search 10–14 days after the general ledger transaction.

    • Use negative offset to search backwards in time.

5. Preview and save

  • Click Preview to see which transactions are matched based on the rules you set.

  • Click Save when everything looks correct.

💡 The system previews which lines it can reconcile based on the rules you created.

6. Import settings from other accounts (optional)

  • If you want to use the same rules you already set up on another account or in another company, click Import settings to retrieve the rules.

Svarte dette på spørsmålet?