When your money crosses borders, your bookkeeping needs to keep up. If you are a freelancer billing clients in London while living in the US, or an expat keeping one foot in two countries, an HSBC account is a natural fit — but getting those transactions into QuickBooks can turn into a monthly chore. You can convert HSBC bank statement PDF to CSV in a few minutes and import the result straight into QuickBooks Online, skipping the manual retyping entirely. This guide walks you through the cross-border wrinkles most tutorials ignore: foreign-currency rows, mismatched date formats, wire transfers, and multi-account statements.
Download the right HSBC statement PDF first
Start inside HSBC online banking — the US site or the HSBC US mobile app — and open Statements under your account menu. Choose the full monthly statement PDF, not a printed copy of the on-screen activity summary, because the official PDF carries complete transaction detail, running balances, and fee disclosures that a converter can parse reliably. Pick the correct account first: your checking, your savings, or your HSBC Global Money account each generate their own statement. If you hold accounts in more than one country — say HSBC US plus HSBC Expat or HSBC UK — download each statement separately. Mixing jurisdictions in a single file creates headaches later, since QuickBooks bank rules expect one account, one currency context, and one consistent format per import. Our HSBC statement guide covers the bank's statement layouts in more detail.
Convert the PDF to a clean CSV
Upload the HSBC PDF to a converter and choose CSV as the output format. A good converter reads the statement's table structure — posting date, description, debit, credit, and balance — and rebuilds it as tidy rows you can open in Excel or Google Sheets. Before you download the file, scan the preview for the rows that usually trip people up: incoming and outgoing wire transfers, which HSBC lists with reference numbers and sometimes splits across two lines; monthly maintenance fees; and Global Money currency exchanges. Fix merged or split rows now rather than after import. If you want a spreadsheet copy for manual review first, you can convert the statement PDF to Excel and save the CSV from there — our CSV conversion guide walks through both paths step by step.
Handle foreign-currency rows before QuickBooks sees them
This is where HSBC statements differ from a typical domestic bank. Foreign-currency transactions often appear twice on the PDF: the original amount in euros, pounds, or rupees, and the converted US-dollar figure HSBC applied. QuickBooks imports one home currency per CSV, so set your rule before uploading. The simplest approach is to keep the USD-converted amount as the transaction amount and add a notes column recording the original currency, the original amount, and the exchange rate — for example "EUR 480 @ 1.0842". That preserves your audit trail for tax time without confusing the import. If you run QuickBooks with multicurrency turned on, you can instead import the original-currency amounts into the matching foreign-currency account — but never mix converted and original amounts in one file. Also watch for HSBC's foreign transaction fees, which post as separate small line items; categorize those as bank fees rather than folding them into the purchase itself.
Normalize dates and keep accounts in separate files
Date formats are the quiet killer of clean imports. HSBC US statements print dates as MM/DD/YYYY, but HSBC UK and HSBC Expat statements use DD/MM/YYYY. A row dated 04/07 means April 7 in one file and July 4 in the other — and QuickBooks will import the wrong one without any warning. Open the CSV and reformat every date to a single unambiguous format such as YYYY-MM-DD before you upload. While the spreadsheet is open, confirm you have one file per account: checking, savings, and Global Money should never share a CSV, since each maps to a different QuickBooks bank account. Delete any "balance forward" summary rows or page headers the converter carried over, leaving only genuine transactions with dates, descriptions, and amounts.
Import the CSV into QuickBooks Online
In QuickBooks Online, go to Transactions, then Bank transactions, and choose Upload from file. Select the CSV for one HSBC account and map the columns: Date, Description, and Amount. QuickBooks accepts both three-column (date, description, amount) and four-column (date, description, expense, income) layouts, so check which one your file uses before mapping. After the upload, the transactions land in the For review tab — approve them in batches, assign categories, and let bank rules memorize recurring items like your HSBC monthly fee or regular client wires. Import one account completely before starting the next. Finish with a monthly reconciliation of each bank statement so your QuickBooks balance always matches what HSBC reports.
Frequently asked questions
Can I import an HSBC PDF directly into QuickBooks?
No. QuickBooks Online imports CSV files (plus QBO and OFX through bank feeds), not PDFs. Convert the statement to CSV first, clean it up, and then upload it.
How should I handle an HSBC statement with two currencies?
Decide on one rule per file: either keep HSBC's USD-converted amounts and note the original currency and exchange rate in a notes column, or import original-currency amounts into a matching foreign-currency account in QuickBooks. Never mix the two in one CSV.
Why did QuickBooks misread my transaction dates?
HSBC US uses MM/DD/YYYY while HSBC UK and HSBC Expat use DD/MM/YYYY. Reformat every date to YYYY-MM-DD in the CSV before uploading so there is no ambiguity.
Can I put checking and savings transactions in one CSV?
You should not. Each account maps to a separate bank account in QuickBooks, so keep one CSV per account and import them one at a time.
Stop retyping cross-border transactions by hand. Convert Statement turns your HSBC bank statement PDF into a clean, QuickBooks-ready CSV in minutes — see pricing and run your first conversion today.