HSBC Bank Statement to Excel (UK and International)

TL;DR: HSBC statements in the UK typically show Date, Payment type and details, Paid out, Paid in and Balance. Convert the PDF, combine Paid in and Paid out into one signed amount, keep dates in day/month/year (or ISO), and check that the running balance matches every line. For international and multi-currency accounts, keep each currency separate.

HSBC is a global bank, and we see its statements from many countries: UK personal and business accounts, expatriate and international accounts, and statements from HSBC in other markets. Layouts differ by country and product, but the UK layout is the one most people bring us, and its conventions apply to many other English-language HSBC statements too.

This guide focuses on UK-style statements, with notes on international and multi-currency accounts.

Understanding the layout

A typical UK current account statement shows:

Date	Payment type and details	Paid out	Paid in	Balance

Some lines have a balance; some don't, because several transactions on the same day may share one balance at the end of the day. That's the single most important thing to know when converting: a tool or formula that expects a balance on every line will report errors that aren't there. There's usually a summary near the top with the opening balance, total payments in, total payments out, and the closing balance.

Transaction types are often abbreviated. You'll commonly see codes such as:

• DD: direct debit
• SO: standing order
• BP: bill payment
• CR: credit
• DR: debit
• VIS: card payment (Visa debit)
• ATM: cash withdrawal
• CHQ: cheque

Your statement may use additional or slightly different codes; there's usually a key on the statement explaining them. Keep the code in its own column after conversion. It's very handy for categorizing.

Getting the statements

In general terms:

1. Log on to HSBC online banking or the app.
2. Select the account.
3. Look for Statements or View statements.
4. Choose the period and download the PDF.

Online banking usually also offers a transaction download for recent activity in spreadsheet-friendly formats. For older statements than are available online, contact the bank.

Converting the PDF

1. Upload to SheetStatement.
2. The converter reads Paid out and Paid in into separate columns, carries the date down to every transaction on that date, and captures the payment type code.
3. It checks the balance against each printed balance and the closing balance.
4. Review flagged rows and export.

Our HSBC bank page lists tested layouts.

Dates carried down

On UK statements, the date often appears only on the first transaction of each day, with the following lines on that day left blank in the date column. A converter should fill the date down to every row. If you're cleaning a file yourself: select the Date column, Go To Special > Blanks, type = and the up arrow, then Ctrl+Enter. Then paste as values.

Balances on some lines only

When only the last transaction of a day shows a balance, verify at the day level: your running balance at the end of each day should equal the printed balance on the last line of that day. A converter that understands this checks each printed balance. In your own sheet, compare only on rows where the Balance column isn't blank:

=IF([@Balance]="","",ROUND([@Running]-[@Balance],2)=0)

Paid out, Paid in and a signed amount

For most uses, a single signed Amount column is easier:

=N([@[Paid in]])-N([@[Paid out]])

Keep the original two columns as well if you're handing the file to someone who expects the statement layout. Accountants in the UK are used to seeing Paid out and Paid in side by side, and some prefer it.

Date formats

UK statements use day/month/year, often with a short month name (for example, 14 Mar 26). After conversion, make sure dates are real Excel dates with four-digit years. If you work in an Excel set to US settings, be extra careful: 04/03/2026 means 4 March in the UK and April 3 in the US. Converting to ISO (2026-03-04) for combined workbooks avoids ambiguity.

When importing into accounting software, use the date format the software expects for your organization's region. Xero and QuickBooks both let you specify or confirm the format on import.

Categorizing with payment type codes

The payment type code makes categorization rules simpler and more reliable. A few patterns:

• DD and SO are recurring commitments: rent, utilities, subscriptions, loans, insurance. Filter by them to see your fixed costs at a glance.
• VIS card payments are mostly day-to-day spending.
• ATM is cash.
• CR often covers incoming payments such as salary or customer receipts.
• Transfers between your own accounts may appear under their own codes or with descriptions naming the other account.

Use the code plus a keyword in your rules table, for example code DD and keyword "COUNCIL" → Council tax. See Excel formulas for categorizing transactions for how to build a rules lookup.

Personal budgeting with a UK current account

For personal use, an HSBC current account statement converted to Excel makes a good budgeting base. A structure that suits UK households:

• Fixed commitments (DD and SO): rent or mortgage, council tax, energy, water, broadband, mobile, insurance, subscriptions, loan repayments.
• Everyday spending (VIS and contactless): groceries, transport, eating out, shopping.
• Cash (ATM).
• Income (CR and similar): salary, benefits, transfers in.
• Transfers: to and from your own savings, ISAs or other accounts.

A pivot with payment type in the rows is a quick first view: it shows how much leaves by direct debit each month, which is your baseline. Then a pivot by category shows where the flexible money goes.

Two habits help. First, check your direct debits once a quarter. Filter for DD, list the payees, and ask whether you still use each one. Second, look at the dates. If many direct debits leave just before payday, moving some collection dates can smooth the month; many providers let you choose.

Joint accounts

Joint current accounts are common, and the statement shows all activity regardless of who made it. If you want to split spending between account holders, card payments may include partial card numbers or the cardholder's name in the details, depending on the layout. Add a Cardholder column and fill it by rule where the information is there. Where it isn't, a shared-expenses category and a simple settle-up calculation is usually enough.

Savings and ISAs

HSBC savings accounts and cash ISAs produce their own statements, usually short: transfers in, interest, perhaps a transfer out. Convert them alongside the current account if you want a full picture, and tag transfers between accounts so they don't count as income or spending. For an ISA, keeping a simple record of contributions per tax year is useful because of annual allowance limits; your statements are the evidence, but HSBC's own ISA statements or annual summaries are the authoritative source for allowance purposes.

Statements from HSBC in other countries

If your statements come from HSBC outside the UK, the layout may differ: column names in another language, different date formats, different transaction codes, or a debit/credit layout instead of Paid out/Paid in. The approach doesn't change:

1. Identify the columns and the date format before converting.
2. Convert and check the balance against the opening and closing balance printed on the statement.
3. Add Currency and, if useful, Country columns.
4. Standardize to one date format and a signed amount before combining with other statements.

If the statement is in a language you don't read, a converter still extracts the numbers and dates reliably; translating descriptions is a separate step, and you can keep the original text alongside your notes.

Business accounts

HSBC business statements follow a similar structure, often with more transactions and more payment types (BACS payments in, faster payments, card settlements). Practical extras:

• Keep the payment type and the full details text.
• For customer receipts, put the payer and any reference in their own columns. References often contain invoice numbers, which make matching much faster.
• For card settlements from a merchant provider, remember the deposit is usually net of fees.

For bookkeeping, export directly to your software's format: bank statement to Xero is popular with UK small businesses, and bank statement to QuickBooks also works for QuickBooks UK.

Preparing for Self Assessment or your accountant

If you're self-employed in the UK, your accountant will likely ask for your business bank statements for the tax year, which runs from 6 April to 5 April rather than the calendar year. When collecting statements, make sure they cover the right dates: you'll often need the statements that include early April at both ends. Filter your converted data by the tax year's dates, tag transfers and personal items, and give your accountant both the PDFs and the categorized spreadsheet. How items are treated for tax is their call; your job is complete, well-labeled data. Our guide to bank statements for tax preparation covers the general process, which applies in the UK too.

Multi-currency and international accounts

HSBC offers accounts in several currencies and international products. Statements for these may show:

• A separate section or statement per currency.
• Exchange rates on conversions between currencies.
• Fees for international transfers.

Rules we follow:

1. One currency per table (or a Currency column on every row). Never sum across currencies without converting.
2. Keep the original amount and, if needed, add a converted amount column with a documented rate source.
3. Treat conversions between your own currency accounts as transfers, noting the rate if shown.
4. For accounting software, import each currency's statement into a matching currency bank account and let the software handle conversion.

A worked example

A UK sole trader's HSBC business account for March:

• Opening balance: £3,420.18
• Payments in: £6,200.00
• Payments out: £5,118.43
• Closing balance: £4,501.75

After conversion, the signed amounts sum to £1,031.57, so the calculated closing balance is £4,451.75, which is £50.00 below the statement.

The day-level balance check shows all days match until 18 March, when the calculated balance is £50.00 lower than the printed one. On 18 March, the PDF shows three transactions: a card payment of £12.40, a DD of £37.60 and a CR of £50.00 refund from a supplier. The CR line wasn't captured because its "Paid in" amount was printed slightly offset into the Balance column on that page. We add it as a £50.00 credit, and every day now balances.

Notice how the day-level check did the work. Instead of comparing 140 lines with the PDF, we compared three. That's why it's worth verifying against every printed balance, not just the closing one.

Troubleshooting

Blank dates. Fill down, as above.

Balance check fails on every line. You may be checking lines that don't have a printed balance. Compare only on lines with a balance.

Dates swapped. Day/month confusion. Convert to ISO or check the software's date setting.

Amounts in the wrong column. Paid in read as Paid out (or vice versa) flips the sign. The day-level balance check will show a difference of twice the amount.

Codes merged into the details. Split them with =LEFT([@Details],FIND(" ",[@Details])-1) if the code is the first word; check against the key on the statement.

Multiple currencies in one file. Split by currency before analysis.

Using statements for applications

UK and international applications (mortgages, rentals, visas) often ask for recent statements. Provide the official PDFs. Converting them first helps you spot large or unusual transactions that might need explaining. See our guides on bank statements for a mortgage application and on preparing statements for a visa application.

Security

Use a converter that encrypts files and deletes them after processing; see our security page. For international accounts, be especially careful when sharing statements across borders by email.

Our take

HSBC's UK statements are tidy once you know their conventions: dates that appear once per day, balances that appear once per day, and payment codes that do half the categorization for you. Fill the dates down, verify day by day, combine Paid in and Paid out into one signed amount, and keep currencies apart.

Troubleshooting HSBC conversions

Paid in and Paid out don't add up to the change in balance. Check for a balance-forward line counted as a transaction, a missing page, or a "balance carried forward" line at the bottom of a page. Remove the balance lines and compare transaction counts per page with the PDF.

Descriptions are split over two lines. Long payee names and references often wrap. A good converter merges them; if you're cleaning by hand, attach the second line to the transaction above it before categorizing.

Foreign currency transactions show two amounts. Card purchases abroad may show the original currency amount and the converted amount, plus a non-sterling fee as a separate line. Use the account-currency amount in your amount column, keep the foreign amount in a notes column if you need it, and include the fee line.

Statements from different HSBC regions look different. Layouts vary between countries and account types. Don't build a template that relies on exact column positions; rely on column headings instead, or use a converter that recognizes the layout.

Multi-currency accounts. Each currency balance usually has its own section or statement. Keep them in separate tables, each in its own currency, and convert only for reporting with a stated rate.

A second worked example: a landlord's rental income summary

A landlord with one rental property receives rent into an HSBC current account that also carries personal spending. For their accountant, they convert twelve monthly statements, filter for the tenant's standing order reference, and tag the property's costs: letting agent fees, repairs, insurance. A PivotTable gives yearly totals for income and each cost type. They send the summary and the PDFs; the accountant decides what's allowable. Our article on bank statements for tax preparation has a fuller checklist.

Mini checklist

• Every month in the period, every page.
• Balance lines removed, wrapped descriptions merged.
• One currency per table.
• Totals checked per statement.
• Originals stored unedited.

FAQ

Can I download HSBC statements in Excel format?

Online banking typically lets you download recent transactions in spreadsheet-friendly formats. Statements themselves are PDFs, which you can convert to Excel for older periods or exact records.

Why are some dates blank after converting an HSBC statement?

UK statements often print the date only on the first transaction of each day. Fill the date down to every row on that day.

What do DD, SO and VIS mean on my statement?

They're payment type codes, commonly direct debit, standing order and Visa debit card payment. Check the key on your statement for the full list.

How do I verify a statement that only shows some balances?

Compare your running balance with the printed balance only on lines that show one, typically the last transaction of each day, and confirm the closing balance.

How should I handle multi-currency HSBC accounts?

Keep each currency in its own table or with a Currency column, keep original amounts, and import each into a matching currency account in your accounting software.

Can I import HSBC statements into Xero or QuickBooks?

Yes. Export a Xero CSV or a QuickBooks file per account, use your organization's date format, and import into the matching bank account.