Convert Barclays statement to CSV — accurate & reconciled

How Barclays statements are structured

Barclays statements follow the classic UK clearing-bank layout: an opening or brought-forward balance up top, then a running list of transactions with date, description, and separate money-out and money-in columns, usually with a running balance printed beside each row. The two-column amounts are the feature that most often trips up naive converters. Our engine reads the two columns explicitly — a figure in the money-out column is a debit, a figure in the money-in column is a credit — and uses the printed running balance as a per-row cross-check, so a misread digit surfaces immediately instead of at the end. Long payment references that wrap onto a second line are merged back into the transaction they belong to before export. Final reconciliation runs the full math: the brought-forward balance plus every extracted transaction must equal the closing balance printed for the period. If anything is off, the results page reports the exact amount involved — nothing is adjusted silently to make the totals tie. Barclays US products share a comparable sectioned layout and convert the same way.