Convert HSBC CSV to QuickBooks (.QBO)
Works with HSBC CSV and Excel exports Nothing uploaded
HSBC UK gives you statements as PDFs and a downloadable CSV (or Excel) from the transaction list, filter your dates on the dashboard and click Download. There is no native .QBO or Web Connect file for personal or business current accounts, so a CSV is what most bookkeepers end up with.
HSBC's CSV is one of the more awkward in UK banking. The file is typically headerless, no column titles row, and uses a single signed Amount column (debits negative, credits positive) alongside the date and a long description string. Without a header row, QuickBooks Online's importer can't auto-map the columns, and the date often arrives as DD/MM/YYYY, which QuickBooks misreads as US-style MM/DD. The result: failed imports or transactions landing on the wrong day.
QBO Maker handles all of this client-side. It detects the missing header, reads the signed amount, normalises the DD/MM/YYYY date, and writes a clean .QBO you can import through QuickBooks Web Connect, no column mapping, no manual cleanup. Your statement is processed entirely in the browser and never uploaded. Convert your HSBC CSV now.
.QBO QuickBooks accepts. For HSBC, its dates are usually DD/MM/YYYY, and amounts arrive as a single signed column (debits negative, credits positive), both detected automatically.A typical HSBC export has columns like Date, Description, Amount and uses DD/MM/YYYY dates. QBO Maker auto-detects these, just confirm the mapping.
How to import HSBC statements into QuickBooks
- Export your transactions from HSBC online banking as CSV or Excel.
- Open the QBO Maker converter and drop the file in.
- Confirm the auto-detected date, amount (or separate debit/credit) and description columns.
- Choose .QBO as the output and click download.
- In QuickBooks Online: Transactions → Bank transactions → Upload from file, then select the .QBO. In Desktop: Banking → Bank Feeds → Import Web Connect File.
HSBC-specific things to watch for
- No header row. HSBC's downloaded CSV often omits column titles entirely, so QuickBooks' auto-mapper fails. QBO Maker recognises the headerless layout and assigns columns for you.
- UK date order. Dates are DD/MM/YYYY; QuickBooks defaults to US MM/DD/YYYY and silently shifts dates. The converter normalises them so 03/04/2026 stays the 3rd of April.
- Single signed amount. One
Amountcolumn carries both spends and deposits via sign, which the QuickBooks CSV template doesn't always accept.QBO sidesteps this completely. - HSBCnet differs. Business HSBCnet exports use a different structure from personal HSBC UK CSVs, so check which file you have before converting.
QuickBooks Online vs Desktop
QuickBooks Online: Transactions → Bank transactions → Upload from file → choose your .QBO. QuickBooks Desktop: Banking → Bank Feeds → Import Web Connect File. Desktop is stricter about the bank ID.
Frequently asked questions
Does HSBC offer a QBO or Web Connect download?
No. HSBC UK current accounts provide PDF, CSV and Excel only, there is no direct .QBO or Web Connect export. QBO Maker fills that gap by turning your HSBC CSV into a proper .QBO file QuickBooks can import.
My HSBC CSV has no column headers, will the converter still work?
Yes. The headerless export is the norm for HSBC UK. QBO Maker detects it and maps Date, Description and Amount automatically, so you don't need to add a header row by hand in Excel first.
Why are my HSBC transaction dates wrong after importing into QuickBooks?
HSBC uses UK DD/MM/YYYY order. QuickBooks often assumes US MM/DD/YYYY, so a date like 05/06/2026 becomes May 6 instead of June 5. Converting to .QBO with QBO Maker locks the dates in correctly before QuickBooks sees them.
Can I also produce a QFX file for Quicken from my HSBC export?
Yes. The same HSBC CSV can be turned into .QFX for Quicken or .OFX for other software, see CSV to QFX. The conversion logic is identical; only the output wrapper changes.
Convert your HSBC statement now
Free, in your browser, nothing uploaded. We will set the date format and currency for you.
Open the converter