Support more complex bank reconciliation matching rules

Enabled for Public preview General availability
Users by admins, makers, or analysts - Oct 2, 2023

Business value

Bank reconciliation helps the matching between bank statement lines and bank transactions to track and verify the accounting entry and transaction detail. With matching rules, bank reconciliation can be automated. In earlier releases, only a 1:1 matching rule is supported, which can cover only a small ratio of automation. With more complex matching rules, the reconciliation process can be further automated.

Feature details

With this new feature, users can define more complex matching rules between multiple bank statement lines and multiple bank account transactions. Automatic bank reconciliation matching will be done for the following scenarios:

  • 1:N - One bank statement line matches with multiple bank transactions
  • N:1 - Multiple bank statement lines match with one bank transaction
  • M:N - Multiple bank statement lines match with multiple bank transactions

See also

Set up bank reconciliation matching rules (docs)

Use cash and bank processes (learn)