How to Download & Convert Commercial Bank Statements to Excel

Commercial Bank of Ceylon PLC is Sri Lanka's largest private sector bank, with a wide network of branches and ATMs across the island and international operations in Bangladesh, Myanmar, the Maldives, and Italy. If you hold a Commercial Bank account and need to convert your PDF statement to Excel for accounting, tax, or financial planning purposes, this guide explains exactly how to do it step by step.

How to Download Your Commercial Bank Statement as PDF

Commercial Bank provides e-statement access through its online banking portal and mobile app. Here's how to get your PDF:

1. Log in to Commercial Bank Online Banking at combank.net using your username and password. First-time users need to register with their account number and OTP.
2. Navigate to Accounts — From the dashboard, click on Accounts > Account Summary to see your linked accounts.
3. Select the account — Click on the Current Account, Savings Account, or Salary Account you need.
4. Request Statement — Look for the Account Statement or e-Statement option. Select a date range (Commercial Bank allows custom ranges).
5. Download as PDF — Click Generate or Download and choose PDF format. Save the file to your device.
6. Flash Mobile Banking App — Open the Commercial Bank Flash app, select your account, tap Statement, set the date range, and tap Download to export the PDF.

For older statements not available online, contact Commercial Bank's Contact Centre on 0112 353 353 or visit your home branch. Commercial Bank Corporate Banking customers should contact their Relationship Manager for bulk statement downloads.

How to Convert Your Commercial Bank Statement to Excel

1. Visit eBankStatementConverter.com — Click Convert Now on the homepage.
2. Upload your Commercial Bank PDF — Drag and drop the statement, or browse for it. 2 pages are free with no signup.
3. AI processes the statement — Our AI engine detects the Commercial Bank of Ceylon statement layout and extracts all transaction data including dates, narrations, debit/credit amounts, and running balances.
4. Check the preview — Commercial Bank narrations sometimes include reference numbers and counterparty details. The AI preserves the full description in the output.
5. Download Excel or CSV — Save your converted spreadsheet in .xlsx or .csv format.

What Data Gets Extracted from Commercial Bank Statements?

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

Tips for Commercial Bank Statement Conversion

• LKR number formatting — Commercial Bank uses comma-delimited LKR amounts (e.g., 1,500,000.00). Our AI converts these cleanly to Excel numbers without comma formatting issues.
• FCY accounts — Commercial Bank offers foreign currency (USD, EUR, GBP) accounts. If your statement shows multiple currencies, the AI extracts the currency code and amount for each row.
• Commercial Bank Mastercard statements — Credit card statements from Commercial Bank Visa/Mastercard have a different PDF layout from current account statements. Both are supported.
• Long date ranges — If you request a 3-month or 6-month custom date range, the resulting PDF may be large. Our batch processor handles multi-page PDFs seamlessly.

Why Convert Commercial Bank Statements to Excel?

Whether you are a sole trader, a company director, or an accountant in Sri Lanka, converting Commercial Bank statements to Excel brings significant efficiency benefits:

• VAT and income tax returns — Sri Lankan businesses use Excel statement data to separate input VAT transactions, prepare WHT (Withholding Tax) reconciliations, and file Inland Revenue returns accurately.
• Audit support — External auditors frequently request bank statement data in Excel format for sampling and analytical review procedures.
• Accounting software import — Import the CSV into QuickBooks, Tally ERP (widely used in Sri Lanka), or Microsoft Dynamics for automated bank reconciliation.
• Working capital management — Finance teams use Excel pivot tables on Commercial Bank data to monitor daily cash balances, outstanding payments, and collections.
• Loan applications — Banks and finance companies require recent bank statements in spreadsheet format as part of SME and personal loan assessments.