Import Transactions — Advanced

Overview

The Advanced tab of the Import Transactions dialog provides duplicate detection, field transformations, and AI-powered envelope matching. These settings fine-tune how imported transactions are processed and matched against your existing records.

Smart Import

The Smart Import group is a toggleable section that enables automatic duplicate detection. When enabled, imported transactions are compared against existing records using amount, date proximity, payee similarity, and optionally check number uniqueness.

Setting	Description
Unclear Missing Transactions	Unclears existing cleared transactions within the matching window that have no corresponding imported transaction. This helps flag transactions that may have been removed by the bank.
Assume Check Numbers are Unique	Treats check numbers as unique identifiers when matching. Two transactions with the same check number are considered the same record.
Max Valid Check Number	Sets the highest check number the importer treats as a real check. Numbers above this threshold are ignored during check-number matching.
Matching Threshold:	Controls how closely an imported transaction must resemble an existing one to be considered a match. A lower value requires closer similarity.

Data Transformation

The Data Transformation group contains field-level corrections that adjust the imported data before it is written to the ledger.

Setting	Description
Swap Payable To and Memo	Exchanges the payee and memo fields. Useful when a bank file stores the description in the memo column.
Swap Payment and Deposit	Exchanges the payment and deposit amounts. Useful when a bank file reverses the sign convention.
Use dd/mm/yyyy Date Format	Parses dates in day/month/year order instead of month/day/year. Enable this for international bank files.
AI Envelope Matching	Automatically assigns envelopes to imported transactions based on payee similarity to past transactions.
Score:	The minimum similarity score an AI envelope match must reach to be applied. Higher values require closer matches.
Days:	The number of days of transaction history the AI examines when looking for payee matches.
Payable Regex Filter:	A regular expression applied to the payee field before matching. Use this to strip bank-added prefixes or suffixes that interfere with matching.
Memo Regex Filter:	A regular expression applied to the memo field before matching.

Per-Account Settings

All Advanced tab settings are saved on the selected account and restored when you next import into the same account.