UK
To get an HSBC statement into Zoho Books, convert the PDF into a CSV carrying Date, Description and either one signed Amount or separate Debit and Credit columns, confirm the figures reconcile against HSBC's printed running balance, then upload that file under Banking > the relevant account > Import Statement. Zoho Books won't read an HSBC PDF; it imports CSV, TSV, XLS and CAMT.053 files. So the job is really about producing a clean, checked CSV before Zoho ever sees it. This is a file import you run yourself, not a live bank feed pushing transactions over an API.
People mix those two up, and it costs them. A bank feed keeps a connected HSBC account current and only reaches back a few months. A statement import is for everything the feed leaves behind: last year's books, a closed account, a backlog you're finally clearing, or a client who hands you nothing but PDFs. For statements that already exist as a PDF, the import route is the one that actually works.
How HSBC lays out a statement, and why it bites here
HSBC UK statements, personal and business alike, print transactions in date order across five columns: Date, a transaction-type code, Paid Out, Paid In, and Balance down the right. That Balance column is the running balance — it carries forward line by line, so each row equals the one above it plus Paid In, minus Paid Out. Zoho Books doesn't want the running balance. It wants the movement on each line. But hold on to that balance column while you check the conversion, because it's the thing that proves nothing went missing.
Two HSBC habits trip up a careless conversion. First, the bank prints the date only on the first transaction of each day; the rows underneath leave the date cell blank. Copy a few days straight out of the PDF and those blank cells shift descriptions onto the wrong rows, or quietly fold two same-day payments into one. Second, HSBC often drops the year from line dates — you'll see 14/03 rather than 14/03/2025 — even though the full DD/MM/YYYY date sits in the statement period at the top. A good conversion reads that header, then back-fills the right year and the repeating day onto every row.
The type codes are worth knowing too, because they end up in your Description field: DD for Direct Debit, SO for standing order, BACS for salary and supplier payments, TRF for transfers, VIS for Visa debit spending, ATM for cash withdrawals, and CHQ for cheques. None of that breaks an import on its own, but it does decide how readable your transactions look once they land in Zoho.
Convert an HSBC statement for Zoho Books in five steps
Run these in order. Each one assumes the step before came out clean.
- Gather every HSBC PDF you need, in date order, no gaps. Pull them from online banking under Statements and documents, or the account's Statements section in the app. A missing month means a missing opening balance, and the import after it starts from the wrong figure.
- Convert each PDF to a spreadsheet. Extract the lines into CSV or Excel. Scanned or photographed HSBC statements are images, not text, so they need OCR; text PDFs still need care so wrapped descriptions and blank date cells don't scramble the rows.
- Check it reconciles. Confirm that opening balance plus Paid In, minus Paid Out, equals HSBC's BALANCE CARRIED FORWARD, matching the Balance column row by row. The first line where your recomputed total stops agreeing with the printed balance is exactly where a transaction was dropped or misread.
- Shape the columns for Zoho Books. Cut it down to Date, Description and the money. Either keep one signed Amount column — negative for money out, positive for money in — or split Paid Out and Paid In into separate Debit and Credit columns. Strip the £ sign and any thousands commas, and note your date format; Zoho asks you to confirm it during import.
- Import into Zoho Books. Go to Banking, open the HSBC account, choose Import Statement, upload the CSV, map your columns to Zoho's fields (Date, Description, Debit/Credit or Amount), and finish. The lines arrive in the Uncategorised list, ready to match and reconcile.
Match the Zoho Books import format
Zoho Books' statement import is built around a date, a description, and the amount of each transaction. You give it the amount in one of two shapes. The tidy option is a single Amount column where money out is negative and money in is positive. The other is two columns — a Debit (or Withdrawals) column for money out and a Credit (or Deposits) column for money in. Both import cleanly; pick one and keep the whole file consistent.
HSBC column | What Zoho Books needs | How to handle it |
|---|---|---|
Date | Date | Keep it; confirm the format during import |
Description / type code | Description | Keep it; merge any wrapped second lines back together |
Paid Out | Amount (negative) or Debit | Negative in the signed column, or its own Debit column |
Paid In | Amount (positive) or Credit | Positive in the signed column, or its own Credit column |
Balance (running balance) | — not imported | Use it to check the conversion, then drop it |
A few things make Zoho reject a row, so clear them before uploading: currency symbols left in the numbers, thousands separators, blank rows, and merged header cells. An empty Description on the odd row is fine. An empty amount is not. If you want the field-by-field detail, the Zoho Books CSV import format guide goes deeper.
Why reconciling first is the step that actually matters
Pulling the HSBC PDF into rows is the easy half. Knowing the file is *complete* is the hard half, and it's the step almost every converter skips. A tool can hand you a neat-looking CSV that's quietly short one transaction, and a tidy file that's wrong is worse than an obvious mess — because you trust it, import it, and find the gap weeks later when Zoho won't reconcile.
This is the wedge that sets Export Bank Statement apart. It converts the HSBC PDF — including scanned and photographed copies, through OCR — into clean CSV or Excel, then runs the running-balance check itself. It recomputes the totals against HSBC's BALANCE CARRIED FORWARD and flags any statement that doesn't reconcile, so a dropped or misread line surfaces before it reaches Zoho Books, not at quarter-end. On one business account, 63 transactions across two numbered sheets, the check caught a single transfer dropped at a page break. Finding it took a minute rather than an afternoon of hunting later.
It exports in Zoho Books' native bank-import CSV format, so the columns map without reshaping. Be clear on what that means, though: you convert, then you import. It doesn't push transactions into Zoho Books over a live bank-feed API, and it isn't a bookkeeping service — you decide what gets imported and how it's reconciled inside Zoho. For the broader walkthrough beyond HSBC, see importing PDF statements into Zoho Books, and for the HSBC format itself the HSBC UK statement page covers the conversion side in detail.
Frequently asked questions
Can Zoho Books import an HSBC PDF statement directly?keyboard_arrow_down
No. Zoho Books imports CSV, TSV, XLS and CAMT.053 files, not PDFs. An HSBC PDF has to be converted to a CSV first, then uploaded under Banking > the account > Import Statement. There's no PDF reader inside the bank-import flow, so the conversion happens before Zoho is involved.
What columns does Zoho Books need from an HSBC statement?keyboard_arrow_down
Three pieces of data: Date, Description and the amount. Map HSBC's Paid Out and Paid In into one signed Amount column (negative for money out) or into separate Debit and Credit columns. Leave HSBC's running-balance column out of the file — Zoho doesn't import it, though you should use it to verify the conversion first.
How does the conversion handle HSBC's blank date cells?keyboard_arrow_down
HSBC prints the date only on the first transaction of each day and leaves the rest blank. A good conversion carries that day's date down onto every row beneath it and back-fills the year from the statement period, so the CSV has a full date on every transaction before it reaches Zoho Books.
Will the Zoho Books bank feed pull in my old HSBC statements?keyboard_arrow_down
No. A Zoho bank feed keeps a connected HSBC account current and only reaches back a short way. Older HSBC history has to be imported manually as a CSV. That's exactly why converting the PDF matters for catch-up work, migrations and prior-year books.
Does this work for scanned or photographed HSBC statements?keyboard_arrow_down
Yes, with OCR. Older HSBC statements and phone photos are images rather than text, so copy-paste returns nothing. OCR reads the figures off the picture, and the same running-balance check then runs to confirm nothing was misread — useful, because OCR is precisely where a 1 gets read as a 7.
Try it on your own statement
Clean Excel/CSV, with every transaction checked to balance.