Once your C. Hoare & Co statement is uploaded, what you get back depends on which export format you actually need next. The converted data maps neatly into the exact format your next step requires. Choose Excel if the transactions move into a spreadsheet for manual review and adjustment. CSV is the right choice when the data must feed a reconciliation tool or a custom script that expects a plain, delimited file. QBO exports map columns directly into QuickBooks fields: the description, date, amount, and reference appear where the ledger expects them, not shifted a column to the left. The export is what you actually asked for on the screen, so you are never forced to accept a format you did not select.
If a transaction description on your C. Hoare & Co statement is long enough to wrap across two or three lines, it still needs to land in a single row once converted. When a transaction description wraps across two or three lines on the statement page, the extraction engine links those fragments back into a single record. It treats the line break as a soft return, not as the start of a new row, so a merchant name truncated by the bank’s own column width is restored to a single cell in the export. The running-balance check still runs against every transaction row, and that check is applied after the multiline join, which means the final row count in the output matches the bank’s own count of entries.
When your C. Hoare & Co 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. A photographed or scanned statement is read with optical character recognition, and the result is treated with the same running-balance verification as a clean digital file. The printed closing figure on the statement page is compared against the extracted total row for row; any mismatch is flagged so a misread digit, a 3 scanned as an 8, does not pass unnoticed. The audit flag is precise: it tells you which row does not add up rather than rejecting the whole document. This lets you correct one line and accept the rest, which saves time when the scan is otherwise legible.