Whichever order your Barclays Bank Canada statement prints its columns in, each one still has to land in the right place once it reaches a spreadsheet. The column layout in your statement is identified automatically. Each field, whether it is a date, a description, a debit, a credit, or a running balance, is mapped to the correct column in the export. You can review and adjust this mapping before you download the file, so the output always fits your ledger’s structure precisely.
When your Barclays Bank Canada statement arrives as a scan or a photo of the page rather than a clean export, the numbers on it are just pixels until they are extracted. When a statement has been scanned or photographed, the engine reads the image with OCR. The running balance is then verified against the printed closing figure on the document. If a character is misread and a row no longer adds up, that row is flagged for your review; the rest of the file remains intact and usable.
Whether you need your Barclays Bank Canada statement in Excel, CSV or QBO, the underlying extracted table stays the same; only the export step differs. You can choose the exact file format your workflow needs next. The engine exports to Excel, CSV, or QBO directly. Every verified transaction is written into the export without column drift or mangled dates, so the file drops into your accounting software without cleanup.