Bank Import Pre-settings
The Bank Import Pre-settings view is a powerful automation tool designed to streamline the bank reconciliation process. By defining specific rules based on transaction descriptions or amounts, the system can automatically categorize and map imported bank statement lines to the correct ledger accounts. This saves significant time during the reconciliation phase and ensures that recurring expenses are consistently recorded without manual intervention.
Accessing Pre-settings
To configure these rules, navigate through the system as follows:
- Path: Banking > Settings > Bank Import Pre-settings.
Configuring Automation Rules
The input section allows you to create specific logic that the system applies to every new file you upload:
- Select bank: Choose if the rule applies to a specific bank account or "All banks" globally.
- From: Select the type of account or category from the dropdown menu (e.g., Miscellaneous).
- To the order of: Enter the name of the person, vendor, or entity associated with the transaction.
- Keyword: Type a specific word or phrase found in your bank statement (e.g., "Petrol" or "Rent") that the system should use as a trigger.
- Minimum price: The lowest monetary value the rule should apply to.
- Maximum price: The highest monetary value the rule should apply to.
- Negative only: Click this tick box if the rule should only apply to withdrawals or payments (negative values).
- Add new: Click this button to save and activate the rule.
Rule Management
The list below the input fields shows all previously created settings, allowing for easy maintenance:
- Edit Icon: Used to modify the details of an existing pre-setting if transaction patterns change.
- Delete Icon: Used to permanently remove a rule that is no longer required.
How it Works
Once these rules are saved, the system performs the following:
- Scans newly imported bank statements for the defined Keywords.
- Checks if the transaction amount falls between the Min and Max prices.
- Automatically suggests the Account and Counterparty in the Imported Bank Inquiry view.