How to Download & Convert HNB Bank Statements to Excel

Hatton National Bank (HNB) is one of Sri Lanka's largest and most trusted licensed commercial banks, serving personal, SME, and corporate customers across the island. If you need to convert your HNB account statement from PDF to Excel — for bookkeeping, tax filing, or financial planning — this guide explains exactly how to download your statement from the HNB portal and convert it to a clean spreadsheet using eBankStatementConverter.com.

How to Download Your HNB Statement as PDF

HNB offers online statement access through HNB SOLO Internet Banking. Follow these steps:

1. Log in to HNB SOLO Internet Banking at hnbsolo.hnb.lk using your User ID and password.
2. Navigate to Accounts — From the main menu, select Accounts > Account Summary to see all linked accounts.
3. Select your account — Click on the Current Account, Savings Account, or Salary Account you need the statement for.
4. Go to Account Statement — From the account detail view, click Account Statement or look for a Download Statement option in the menu.
5. Set the date range — Choose the start and end dates for the period you need. HNB allows custom date ranges rather than fixed monthly statements.
6. Download as PDF — Click Generate Statement and then select Download PDF or Export to PDF. Save the file to your device.
7. HNB Mobile App — Log in to the HNB Mobile app, navigate to your account, tap Statement, set the date range, and tap Download PDF.

If you encounter issues accessing e-statements, contact HNB Customer Care on 0112 462 462 or visit your nearest HNB branch. Business and corporate customers with HNB trade finance or term loan accounts should contact their Relationship Manager for statement exports.

How to Convert Your HNB Statement to Excel

1. Visit eBankStatementConverter.com — Go to the Convert page.
2. Upload your HNB PDF — Drag and drop the statement PDF or click to browse. Convert 2 pages free without registering.
3. AI processes the HNB format — Our AI engine recognises the HNB statement layout (which includes date, description, debit, credit, and balance columns in LKR) and extracts all transaction rows accurately.
4. Preview and verify — Review the extracted data. HNB statements often include descriptions in both English and Sinhala/Tamil for certain transaction types. The AI extracts the full description text as-is.
5. Download Excel or CSV — Download your converted file in .xlsx or .csv format.

What Data Gets Extracted from HNB Statements?

• Transaction date
• Transaction description / narration
• Debit (withdrawal) amounts in LKR
• Credit (deposit) amounts in LKR
• Running balance
• Account holder name and account number
• Branch name
• Statement period, opening balance, and closing balance

Tips for HNB Statement Conversion

• LKR formatting — HNB statements use Sri Lankan Rupee formatting with commas as thousand separators. Our AI converts these to clean numeric values in the Excel output.
• Custom date ranges — Since HNB allows custom date ranges (not just monthly), you can download a 3-month or 6-month statement as a single PDF and convert it all at once.
• SOLO Business Banking statements — HNB Business accounts managed through SOLO Business Banking have a slightly different statement layout. Both personal and business formats are supported.
• HNB credit card statements — HNB Visa and Mastercard credit card statements can also be uploaded and converted. The format differs from current account statements but is fully supported.

Why Convert HNB Statements to Excel?

Sri Lankan businesses, accountants, and individuals use converted HNB statements for a range of purposes:

• Income Tax Return filing — Individuals and businesses use Excel data to categorise income and expenses for Inland Revenue Department (IRD) tax returns in Sri Lanka.
• Bookkeeping and accounting — Small businesses in Sri Lanka use Excel or accounting software like QuickBooks (available locally) to manage accounts. Converted HNB statements feed directly into these tools.
• Bank reconciliation — Compare HNB statement data against your own records in Excel using VLOOKUP or conditional formatting to spot discrepancies.
• Loan and credit applications — Finance companies and leasing companies in Sri Lanka require bank statements in spreadsheet format to assess creditworthiness.
• Business financial reporting — SMEs use monthly Excel data to produce cash flow forecasts, profit and loss summaries, and board reports.