Whichever order your Lloyds Bank International statement prints its columns in, each one still has to land in the right place once it reaches a spreadsheet. Column mapping gives you control over how every data point is placed in the export. You decide which fields go where: date into one column, description into the next, credit and debit amounts where your ledger ledger expects them. The engine presents a preview of the extracted table with a simple column picker. You can remap any column with a single click, and your mapping is remembered for every statement document that shares the same layout. No template to save, no macro to record. The raw transaction data stays intact; only the column assignment changes. This is particularly helpful when the statement uses a layout where debits and credits flow through a single amount column with a separate sign indicator: you can split those into two clean money-in and money-out columns before the file ever hits your accounting package.
Once your Lloyds Bank International statement is uploaded, what you get back depends on which export format you actually need next. The export step gives you exactly the file format your workflow requires. Choose Excel for spreadsheet review and manual adjustments, CSV when you need a plain data feed for another tool, or QBO to move the transactions straight into QuickBooks for reconciliation. The export respects the column mapping you configured, so the output is already shaped to match your ledger structure. Running-balance verification happens before the file is written: the engine checks every line's arithmetic against the statement's own printed closing figure, flagging any row that does not add up. You get a clean, audit‑ready file where the numbers tie out, without rekeying a single figure.