Banks

Convert HSBC Bank Statements to Excel

Convert HSBC statement PDFs to Excel and CSV. HSBC prints a balance once a day, so we work out the rest and check every one we can. 15 pages free.

Drop your statement here PDF up to 25 MB. Scans and photos saved as PDF, and password-protected PDFs, work too.

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

  1. Drop the PDF in the box on this page, and we show you its first page converted.
  2. 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.
  3. 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.

Other banks

We convert other banks' statements too. See every bank page.

Convert your own statement.

We read every row, check every balance, and give you a file for your spreadsheet or your books.