UK
Barclays and HSBC UK both lay their statements out as a dated transaction grid with a running balance down the right, but the detail differs in ways that matter when you're converting them. Barclays uses separate money-in and money-out columns with a description in plain text, and prints the full date on every line. HSBC UK uses a five-column layout (Date, transaction-type code, Paid Out, Paid In, Balance), abbreviates the transaction type to codes like DD and BACS, and prints the date only once per day. Both are usually proper text-based PDFs, and both carry a running-balance column you can verify against, which is the part that decides whether a converted file is trustworthy.
Here's the side-by-side, then the quirks that catch people out, then how each one converts and reconciles the same way through the tool.
The formats at a glance
This table compares the two layouts as they appear on a standard UK current-account statement. Figures here are illustrative format examples, not real account data.
Feature | Barclays | HSBC UK |
|---|---|---|
Transaction columns | Date, Description, Money Out, Money In, Balance | Date, transaction-type code, Paid Out, Paid In, Balance |
Debit / credit split | Two columns: Money Out and Money In | Two columns: Paid Out and Paid In |
Running balance | Yes, updates line by line down the right | Yes, updates line by line down the right |
Date on every row | Yes, full date on each transaction | No, date printed only on the first transaction of each day |
Year shown on line dates | Usually shown in full | Often dropped (14/03 not 14/03/2025); full date sits in the period header |
Transaction type | Written out in the description | Short codes: DD, SO, BACS, TRF, VIS, ATM, CHQ |
Opening / closing labels | Opening and closing balance in a summary | BALANCE BROUGHT FORWARD / BALANCE CARRIED FORWARD |
Typical file type | Text-based PDF (older copies scanned) | Text-based PDF (older copies scanned) |
Multi-page business runs | Common; totals roll across all pages | Common; totals roll across all sheets |
The headline takeaway: the column logic is close, but HSBC compresses information that Barclays spells out. HSBC expects you to read the day from the row above and the year from the page header, and to know what BACS or SO means. Barclays leaves less to interpretation on the page.
How Barclays lays out a statement
A Barclays personal or business statement reads left to right as a date, a plain-text description, a Money Out column, a Money In column, and a running Balance on the far right. The description carries the detail, so a card payment, a direct debit and a transfer all sit in readable English rather than a code. The full date appears on every transaction line, which keeps each row self-contained.
Because Barclays statements are normally generated as text-based PDFs, the numbers are real text under the surface rather than a flattened image. That's why they convert cleanly: the data is already there to be read. The exception is an older account where your only copy is something scanned at a branch or photographed on a phone. That PDF is really a picture, and reading it needs OCR.
Business statements are where Barclays format scales up. A busy Barclays business current account can run to dozens of pages in a single month, and the running balance carries across all of them from the opening figure to the closing one. The layout stays consistent page to page, which is exactly what makes the running balance usable as a completeness check.
How HSBC UK lays out a statement
HSBC UK puts the transaction-type code where you might expect a longer description. The five columns run Date, type code, Paid Out, Paid In, and Balance. At the top sits a summary box, usually top right, with the IBAN, BIC, sort code, eight-digit account number, the statement period, and the opening and closing balances. The opening figure is labelled BALANCE BROUGHT FORWARD and the closing one BALANCE CARRIED FORWARD.
The type codes are the part newcomers stumble over. Once you know them they're quick to read:
- DD — Direct Debit
- SO — standing order
- BACS — salary and supplier payments
- TRF — transfers between accounts
- VIS — Visa debit card spending
- ATM — cash machine withdrawals
- CHQ — cheques, with CR and DR marking credits and debits
So a line that reads "SO" is a standing order; "VIS" is card spending. The codes are compact, but they assume you know the shorthand.
The two HSBC quirks that trip up converters
This is where the formats really part company, and where a careless extraction goes wrong. HSBC prints the date only on the first transaction of each day. Every row beneath it that shares the same day leaves the date cell blank. A naive extractor can misalign those blanks, push a description onto the wrong row, or merge two transactions that happen to share a date. You wouldn't spot it by eye. The closing balance would simply come out wrong.
The second quirk: HSBC often drops the year from the line dates, showing 14/03 rather than 14/03/2025. The full DD/MM/YYYY date lives in the statement period at the top, so a good extraction reads that header first, then back-fills the right year and the repeating day onto every row. The result is a complete date on every single transaction in your spreadsheet, even though the original printed it once.
Barclays sidesteps both problems by printing the full date on each line. So while Barclays statements tend to convert without surprises, HSBC statements reward an extractor that understands the format and punish one that doesn't.
The one thing both formats share, and why it matters
For all the differences, Barclays and HSBC agree on the most useful feature: a running balance that updates line by line. That single column is what lets you check completeness rather than just trusting it. Take the opening balance, add everything in the credit column, subtract everything in the debit column, and you should land exactly on the stated closing balance. If you don't, a transaction is missing, misread or out of place.
That test is the whole point of the reconciliation check in Export Bank Statement, and it runs the same way on both banks. When you upload a Barclays PDF, the tool treats the running-balance column as a checksum: opening, plus money in, minus money out, should equal the closing line. When you upload an HSBC PDF, it uses BALANCE BROUGHT FORWARD and BALANCE CARRIED FORWARD as the bookends and checks the Paid In and Paid Out columns against them, after rebuilding the dates HSBC left implied. If either ties out, you get a confirmation. If either is off by a penny, the statement is flagged before you trust a single figure. Most converters don't do this, and on HSBC's compressed format it earns its keep more than almost anywhere.
Be clear on what that proves. The check is a completeness and consistency test, not a fraud verdict. It catches the structural footprint of a missing or misread line, which is the most common real problem, but it can't certify a statement as genuine. There's more on that distinction in the piece on bank statement red flags, and a step-by-step in the bank reconciliation checklist.
Converting each one: same path, different pitfalls
The conversion path is identical for both. Download the PDF from online banking or the app, upload it at /convert, let the tool extract every line and reconcile the running balance, then download a clean .xlsx for Excel or Google Sheets, or a CSV for accounting software.
What differs is where each format strains. Barclays usually converts without drama because the dates are complete and the descriptions are plain text. The thing to watch is an older scanned copy, where OCR has to read figures off an image and the odd misread can creep in, which the reconciliation check is there to catch. HSBC needs the extractor to handle the blank date cells and the missing year correctly. Get that wrong and rows misalign silently; get it right and you finish with a complete, dated, balanced spreadsheet.
Both banks' bank-specific guides go deeper on the steps: there's a walkthrough for Barclays and one for HSBC UK.
If the numbers are heading into accounting software, export the CSV rather than the .xlsx. Export Bank Statement writes it in the native bank-import format that Xero, QuickBooks and Zoho Books expect, so the columns map without reshaping. One honest caveat: you convert the PDF, then import that CSV into your software, where it lands as reconcilable statement lines. It is not a live bank-feed connection and doesn't pretend to be one. Files are processed then deleted immediately, and never used to train AI.
Frequently asked questions
What is the main difference between a Barclays and an HSBC statement?keyboard_arrow_down
Barclays prints a full date on every transaction line and describes each payment in plain text, with separate Money Out and Money In columns. HSBC UK prints the date only on the first transaction of each day, compresses the payment type into codes such as DD, SO and BACS, and uses a five-column Date, type, Paid Out, Paid In, Balance layout. Both share a running-balance column down the right.
What do the codes on an HSBC statement mean?keyboard_arrow_down
They are transaction-type abbreviations. DD is a Direct Debit, SO a standing order, BACS a salary or supplier payment, TRF a transfer, VIS Visa debit card spending, ATM a cash withdrawal, and CHQ a cheque, with CR and DR marking credits and debits. Barclays writes these out in the description rather than coding them.
Does Barclays show a running balance like HSBC?keyboard_arrow_down
Yes. Both Barclays and HSBC UK statements carry a running balance that updates line by line down the right-hand side. That shared column is what makes either statement checkable: opening balance plus credits minus debits should equal the stated closing balance.
Why does HSBC leave some date cells blank?keyboard_arrow_down
HSBC prints the date once per day, on that day's first transaction, and leaves it blank on the rows below that share the same date. It also often drops the year from line dates, keeping the full date in the statement period header. A good converter reads the header and back-fills the day and year onto every row.
Do Barclays and HSBC statements convert and reconcile the same way?keyboard_arrow_down
The path is the same: upload the PDF, extract every line, reconcile the running balance, download Excel or a CSV. The reconciliation check verifies opening plus money in minus money out against the closing balance for both. The difference is in extraction: HSBC's blank dates and missing year need handling that Barclays' fully dated lines don't.
Try it on your own statement
Clean Excel/CSV, with every transaction checked to balance.