Help Center › Banking
Bank auto-mapping rules
See, add, change or delete the rules that match bank statement narrations to ledgers, so future imports are mapped for you.
A rule links a bank narration, such as "NEFT-SALARY", to a ledger. When you import a bank statement, any line whose narration matches a rule is mapped to that ledger by itself. Rules are learned for you: every line you map and post in a bank statement import saves a rule. This screen lets you check and fix them.
Before you start
- The ledgers you want to map to must exist in Chart of Accounts.
Steps
- Open Import & Export > Bank Auto-Mapping Rules.
- Look through the table. Rules used most often are at the top.
- To find a rule, type part of the narration in the search box, such as "NEFT" or "charges", and click Search or press Enter.
- Change or delete any rule that maps to the wrong ledger. See the sections below.
To go back to the import screen, click Bank Import at the top.
Add a rule by hand
- Click Add Rule. The New rule row opens.
- In Pattern, type the words from the narration, for example "NEFT-SALARY-ABC LTD".
- In Direction, choose Any, Debit (paid out) or Credit (received).
- In Maps to ledger, pick the ledger.
- Click Create rule. A message shows the saved pattern and its ledger.
Click Close to hide the row without saving.
Change the ledger on a rule
- Click the pencil icon (Change ledger) on the rule.
- Pick the new ledger.
- Click Save. Click Cancel to leave it as it was.
Only the ledger can be changed. To change the pattern, delete the rule and add a new one.
Delete a rule
- Click the red bin icon (Delete rule) on the rule.
- Confirm the message. Rule deleted. appears.
After you delete a rule, future imports will not map that narration by themselves until you map it again.
How matching works
- The pattern is cleaned before it is saved: it is turned to lowercase, and runs of 4 or more digits and dates are hidden. So a cheque or reference number that changes every month does not stop the match.
- The table shows the cleaned pattern in Pattern (normalized narration).
- A Dr tag means the rule works only on money paid out. A Cr tag means only on money received. No tag means it works on both.
- Hits shows how many times the rule has been used, and Last used shows when.
Fields
| Field | What to enter |
|---|---|
| Pattern | Words that appear in the bank narration. Make it specific enough to match only the lines you mean. |
| Direction | Debit (paid out) for payments, Credit (received) for receipts, Any for both. Use a direction when the same words appear on both sides but should go to different ledgers. |
| Maps to ledger | The ledger these lines should be posted to. |
Common problems
- Pattern is required. — the Pattern box is empty. Type the narration words.
- Pick a ledger first. — no ledger is picked. Pick one in Maps to ledger.
- Pattern normalizes to empty — pick something more specific — the pattern was only numbers or dates, which are hidden. Add words from the narration.
- A rule for this pattern already exists — a rule with the same cleaned pattern is already saved. Search for it and change its ledger instead.
- Imports keep mapping a line to the wrong ledger — a wrong rule was learned. Search for the narration here and change or delete the rule.