Convert HSBC statement PDFs to Excel, Xero and CSV.
Xero, QuickBooks Online, Sage files from the PDF.
Statement PDFs from HSBC UK are not password-protected. HSBC lets you download the transaction list from the account screen as CSV or Excel, filtered to a date range.
Drop your HSBC statement here
PDF, scan or photo. Up to 12 files at a time.
Not ready to upload your own? See a sample result
5 pages free, no account. Amounts stay in GBP.
Last updated
How to download a HSBC statement as a PDF
- Log on to HSBC UK online banking. In the quick links panel choose 'Statements'.
- Select the statement type (bank account or credit card), then the account.
- Choose the year and the month. Each month is a separate PDF.
- Click 'Download' and the PDF saves to your computer. There is also a 'Share' option if you are sending it to someone else.
- In the HSBC UK Mobile Banking app: open the account, tap 'View statements', pick the month, and use the share sheet to save it.
Then drop the file above; several months of HSBC statements at once come back as one workbook.
Is the HSBC PDF password-protected?
Statement PDFs from HSBC UK are not password-protected. The only locked files we see are the annual credit card summaries some customers receive by email, and those are rare.
What HSBC statements look like
Date, Payment type and details, Paid out, Paid in, Balance. Balance printed only on the last transaction of each day.
The transaction table is headed Date, Payment type and details, Paid out, Paid in, Balance. The balance is only printed on the last entry of each day, so a day with six card payments shows five blank balance cells and one figure. Every line starts with a short code: VIS for Visa debit, DD for direct debit, BP for bill payment, SO for standing order, CR for a credit received, ATM for cash, TFR for a transfer between your own accounts. Dates are written as 02 Jan 26, with the year included. The opening and closing balances sit in a summary box on page one, and statements for busy accounts often run to five or six pages because each description wraps onto a second line.
Why not use HSBC's own export?
HSBC lets you download the transaction list from the account screen as CSV or Excel, filtered to a date range. That download comes from the live transaction feed rather than the issued statement, so it has no statement opening balance, no running balance, and the descriptions are sometimes shorter than the printed ones. Online banking keeps six years of statement PDFs (HSBC's own figure), which is a longer reach than the transaction filter offers. If you are catching up more than a few months, or you want the payment type codes preserved, the monthly PDFs are the more dependable route.
Where HSBC statements trip up converters
- Payment type codes (VIS, DD, BP, SO, CR) are preserved at the start of the description so you can categorise by them.
- Balance only on day-end rows; we compute the rest and verify against them.
Which software HSBC customers import into
HSBC customers most often import into Xero, QuickBooks Online, Sage, Excel.
- Tally XML. TallyPrime XML export: Receipt and Payment vouchers for Alt+O import, alongside Excel, CSV, QuickBooks and Xero.
- Non-expiring pack. $19 buys 100 pages that never expire, and no statement is charged more than 15 pages.
- API and email-in. REST API and email-in on every plan, including the free one.
- Your file. Deletion of your file starts when processing ends; results are kept 7 days with an account, 1 day without.
- Balance check. There is no per-bank template: every row is added up against the opening and closing balances printed on the statement, and a misread is flagged, not hidden. How the balance check works
HSBC questions
What do the codes like BP, DD and VIS at the start of each HSBC line mean?
They tell you how the money moved, not what it was for. BP is a bill payment you made, DD a direct debit taken by a company, SO a standing order, VIS a Visa debit card payment, CR a credit paid in, ATM a cash withdrawal and TFR an internal transfer. stmtai keeps the code at the front of the description, so in Xero or QuickBooks you can write a rule such as "description starts with DD" and code all your direct debits in one go.
Most rows on my HSBC statement have an empty Balance cell. Is that a problem?
No, HSBC only prints the balance on the last transaction of each day. stmtai carries the running balance forward through the blank rows and then checks its own figure against every printed one. If they ever disagree the row is flagged rather than silently accepted.
Does the HSBC Kinetic business statement convert the same way as a personal one?
Kinetic statements use the same column set and the same payment type codes, so yes. The main difference is that Kinetic statements tend to be longer and have more BP and CR lines from customer payments, which is exactly where keeping the codes and the full reference text pays off.
How do I convert a HSBC statement PDF to Excel?
Download it from HSBC using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.
How many HSBC statements can I convert at once?
Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.