All articles
Rules & automations

Apply rules to existing transactions

How to apply assignment rules retroactively to already imported transactions.

New rules and existing transactions

When you create a new assignment rule, it initially only applies to future transactions — i.e. on the next import or sync. Already existing transactions stay unchanged.

To apply a rule retroactively to existing transactions, use the bulk-apply function.

Use bulk-apply

On every rule card under Settings -> Assignment rules you'll find the "Apply to existing transactions" button. Click it to run the rule against all matching transactions.

What happens on bulk-apply?

  1. Kontavio scans all transactions that match the rule's conditions
  2. Only unreviewed transactions are considered — already reviewed transactions are not overwritten
  3. The matching transactions receive the defined actions (type, category, customer/vendor, scope)
  4. The rule's match counter is updated

Tip: Manually reviewed transactions are protected. You don't need to worry about bulk-apply overwriting your carefully assigned transactions.

Practical example

You import 200 transactions from your Wise account. Many are still uncategorized. Now you create a rule:

  • Condition: Description contains "AWS"
  • Action: Type = Expense, Category = "Software & Tools", Scope = Business

You click "Apply to existing transactions" — and 15 of the 200 transactions are automatically categorized as "Software & Tools". The match counter jumps to 15.

Order of rules

The same applies to bulk-apply: rules are processed in the displayed order. The first matching rule wins. If two rules could match the same transaction, only the first is applied.

Order example

  • Rule 1: "Description contains AMAZON WEB SERVICES" -> Category: Server hosting
  • Rule 2: "Description contains AMAZON" -> Category: Office supplies

A transaction with the description "AMAZON WEB SERVICES" is correctly assigned to "Server hosting" because rule 1 hits first.

Tip: Carefully review the conditions of a rule before using bulk-apply. Test the rule first on a few transactions by checking it manually. A condition that's too broad like "Description contains A" would hit almost every transaction.

  1. Import your bank statements
  2. Scroll through the transactions and spot patterns (e.g. "SPOTIFY" appears 12 times)
  3. Create a rule from the transaction detail dialog
  4. Apply it to existing transactions
  5. Repeat for additional patterns

This way you automate your bookkeeping step by step and have less and less to assign manually.

Ready to get started?

Kontavio was built specifically for digital nomads with LLCs. Try it for free.

Start for free