Menu

Tools

Explore

LK · LKR · 1 Banks

Sri Lanka Bank Statement Converter

Convert Sri Lanka bank statement PDFs to CSV, Excel (.xlsx), JSON, or QuickBooks (.qbo) files. Works with major Sri Lanka banks and helps with IRD income tax filing, Sri Lanka VAT returns, and accounting software import.

Bank Statements in Sri Lanka

Banks in Sri Lanka usually provide statements as downloadable PDF files through online banking portals. These PDFs contain transaction tables with dates, descriptions, debit and credit amounts, and balances.

MintConvert extracts these transaction tables and converts them into structured formats like CSV, Excel (.xlsx), JSON, or QuickBooks (.qbo). This allows the data to be analysed in spreadsheets or imported into accounting software used in Sri Lanka.

Major Sri Lanka Banks Supported

MintConvert supports bank statement PDFs from major banks in Sri Lanka, including:

  • Commercial Bank of Ceylon bank statements can be converted to CSV, Excel, JSON, or QuickBooks.

Why MintConvert

  • 1 supported banksComBank
  • LKR preservedAmounts exported as numeric values
  • Date normalisationDD/MM/YYYY → YYYY-MM-DD
  • IRD income tax filing, Sri Lanka VAT returns, and accounting software importIn Sri Lanka, bank statements are required for income tax return filing with the Inland Revenue Department (IRD) and as supporting documents for VAT returns.
  • 4 output formatsCSV, Excel, JSON, QuickBooks
  • Free to start5 conversions/month with no credit card

Frequently Asked Questions

Which Sri Lanka banks are supported?

MintConvert supports Commercial Bank of Ceylon with bank-specific parsers for each bank's PDF format.

Can I use converted Sri Lanka statements for IRD income tax filing, Sri Lanka VAT returns, and accounting software import?

In Sri Lanka, bank statements are required for income tax return filing with the Inland Revenue Department (IRD) and as supporting documents for VAT returns.

What currency format is used in the output?

All LKR amounts are exported as numeric values with no symbols.

What date format is used?

MintConvert normalises dates from DD/MM/YYYY to YYYY-MM-DD.

Which accounting software works with the output?

CSV and Excel outputs work with QuickBooks, Tally ERP, Sage, Odoo. QuickBooks uses the QBO format.