Barclays statement to Excel or CSV

How this statement is structured

The tested header is Date · Description · Money out · Money in · Balance. A date may appear once for several following transactions, while a running balance may be printed only at the end of a segment.

Statement controls recognized

• Start balance
• Money in
• Money out
• End balance

What the spreadsheet can contain

• Inherited transaction dates
• Money-out and money-in direction
• Multiline card and payment descriptions
• Available balance checkpoints

Validation performed before confidence

• Credits and debits are compared with Money in and Money out
• Movements between balance anchors are reconciled as a segment
• The final ledger balance is compared with End balance

Opening balance + credits − debits = ending balance

What you must review

• Foreign-currency amounts and exchange rates inside descriptions are narrative, not extra transactions
• Continued-page text and legal footers must be excluded
• New Barclays statement templates may require review

Convert the statement

1. Download the original PDF directly from your bank or provider.
2. Open the converter and select the PDF. Statement contents are processed locally in your browser.
3. Confirm the detected currency, transaction count, balances and warnings.
4. Compare every row with the source before downloading Excel or CSV.