We turn your HSBC statement PDF into a spreadsheet with the columns the statement prints. HSBC leaves most rows without a balance, so we work out each missing balance and check every one we can.
What an HSBC statement looks like
- An HSBC statement has five columns: Date, Payment type and details, Paid out, Paid in and Balance.
- The details start with a payment type code:
)))for a contactless payment, VIS for a Visa debit card payment, BP for a bill payment, CR for a credit, and others such as DD, TFR and ATM. We keep the code at the start of the description cell. What each code means. - The date is printed only on the first transaction of each day, written like 09 May 22.
- HSBC usually prints the balance once a day, against the day's last transaction.
- BALANCE BROUGHT FORWARD and BALANCE CARRIED FORWARD lines come through as rows of their own.
What your spreadsheet looks like
Where HSBC printed no balance, we work it out from the rows around it, fill
it in, and mark the row filled in the Ledger column.
| Date | Payment type and details | Paid out | Paid in | Balance | Ledger |
|---|---|---|---|---|---|
| 06 May 22 | BALANCE BROUGHT FORWARD | 640.00 | ok | ||
| 09 May 22 | ))) CORNER SHOP | 6.75 | 633.25 | filled | |
| VIS ONLINE STORE | 29.99 | 603.26 | filled | ||
| CR EMPLOYER LTD | 1,500.00 | 2,103.26 | ok |
The rows above are an example, not a real statement.
How we test it
We test against three HSBC statements: 174 transactions in all, and the Ledger column flags none of them. Of the 174, 59 balance against a balance HSBC printed. We fill in the other 115, which are mostly the rows HSBC prints no balance for.
Convert an HSBC statement
- Drop the PDF in the box on this page, and we show you its first page converted.
- Sign up with your email address to download it. You do not need a card. Your free trial converts up to 5 pages of a statement, 15 pages in all.
- To convert every page, choose a plan on the pricing page.
To bring the transactions into your books, download the file for your accounting software from your list of statements, then import it into Xero, QuickBooks or FreeAgent. You get this file on the free trial and on the Standard and Plus plans. Lite gives Excel and CSV.
Once the statement is in your account, we delete the PDF when its conversion finishes. If you drop it in and do not sign in, we delete it too. Our privacy policy says what we keep, and for how long.
Read next
- Bank Statement Codes: What DD, BGC, FPI and the Rest Mean
- Why a Converted Bank Statement Does Not Balance
Other banks
- Convert ANZ Bank Statements to Excel
- Convert Commonwealth Bank (CommBank) Statements to Excel
- Convert ICICI Bank Statements to Excel
- Convert Metro Bank Statements to Excel
- Convert Monzo Bank Statements to Excel
- Convert Nationwide Bank Statements to Excel
- Convert Lloyds Bank Statements to Excel
- Convert NatWest Bank Statements to Excel
- Convert Santander Bank Statements to Excel
- Convert TSB Bank Statements to Excel
- Convert Virgin Money Bank Statements to Excel
We convert other banks' statements too. See every bank page.