If you are an HSBC customer you will already know that getting old statements out of the online banking system is a nightmare. You can download recent statements as CSV files but any statements considered 'Previous' are not available for download. You can view them on the screen but what if you want an electronic copy for your records?

• Online Bank Statements

It would be great if HSBC allowed you to download your statements as PDF files every month as American Express do. So what can you do instead? You can view a statement and then save the web page but the HTML is so complicated these always look messy. I've created a VBA script within Microsoft Excel that allows you to save the web page of an old statement and then process it. This gives you a nice neat, simple HTML file and a CSV file.

The example below shows the HTML output of a typical bank statement after processing: The script also creates a simple HTML index so you can easily browse the statements. How Does It Work? You view each statement online. You then save each page from your browser as an HTML file (the awful navigation within the HSBC online banking system doesn't make this as easy as it should be!). Shove all the files in the 'input' directory. Run the script. The 'outputhtml' and 'outputcsv' folders are then filled with processed versions.

Here you can download or print out forms and documents related to the banking services we have to offer. Skip page header and navigation. And take your completed form to any HSBC branch for processing. Credit Cards. Customer Dispute Form (PDF, 1.1 MB) Customer Dispute Form (PDF. Email Statement request form (1.24 MB) Email Statement. Top free hsbc bank statement template downloads. The Income Statement Template for Excel is an Excel spreadsheet for those who prefer to do their own valuation and/or analysis and would rather not spend the significant time needed to create the financial statements. Bank2OFX converts bank and credit card files to OFX format. Understanding Your Statement Hsbc Singapore with Hsbc Bank Statement Template Bank Statement Template Soap Format for Hsbc Bank Statement Template Hsbc Bank Statement Request - Fill Online, Printable, Fillable in Hsbc Bank Statement Template Bank Statement Template.hsbc Example Output - Letterhead.

Use the index.htm file to browse. You now have a proper record of your statements. Here are some reasons why the current HSBC online statement facility sucks: - You can not download old statements into a sensible electronic format - You can only download CSV files for recent statements - CSV files are fine but a nicely formatted PDF would be a lot nicer - In order to view old statements you have to make lots of mouse clicks.

When you use the 'Return to list' button you are dumped back in the current year rather than the year you were looking. This results in hundreds of mouse clicks just to review a handful of old statement.

HSBC want you to go paperless 'to save the environment' but then give you a crap system to replace it. I would urge all HSBC customers to email HSBC and demand a proper way of obtaining statements electronically. A PDF download would be nice! Give my PDF downloads of my statements and I will go paperless on all my accounts. Come on HSBC it's not rocket science (well not for me anyway). Note: As with anything related to online banking you should take appropriate precautions when downloading stuff off the internet. If you are not able to check my macro code and see how it works please get someone who can do it for you.

Online Bank Statements

Its clean but don't take my word for it!