Prepare one account per statement file for extraction. A combined file containing several bank or card accounts needs to be separated so the imported movements can be matched to the correct source account.
- Identify each account section in the bank’s original statement.
- Obtain separate bank statements where possible, or prepare complete account-specific files that preserve all pages and balances for each account.
- Select or confirm the corresponding Statement account when reviewing each file.
A shared bank name or company owner does not make separate account balances interchangeable. The account’s last digits and currency help distinguish them.
Check file boundaries
Do not split in the middle of a transaction table without keeping enough evidence to identify the account and period. Retain the complete original statement alongside the account-specific working files.
After extraction, compare each account independently with its source. If a row belongs to another account, stop before posting and investigate the mapping. Moving amounts between accounts to make a combined total agree can conceal the original source mismatch and complicate later reconciliation.
Was this article helpful?
Tell us whether this answered the question you came with.