Menu

Tools

Explore

LK · LKR · .CSV

Sri Lanka bank statementsGoogle Sheets

Convert Sri Lanka bank statement PDFs from ComBank and more.

Loading converter...

Secure Financial Data Processing

Sri Lanka Bank Statements and GOOGLE_SHEETS

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. MintConvert normalises all LKR amounts to numeric values and dates to YYYY-MM-DD ready for import into QuickBooks and Tally ERP. Fiscal year: April 1 – March 31.

Supported Sri Lanka Banks

Example Output

DateDescriptionDebit (LKR)Credit (LKR)Balance
2024-03-15ComBank ATM Withdrawal2,000.0048,500.00
2024-03-18Salary Credit75,000.001,23,500.00

How It Works

  1. Download your PDF

    Log into your Sri Lanka bank's online portal and download your statement as a PDF.

  2. Upload to MintConvert

    Drag and drop the PDF. MintConvert auto-detects which Sri Lanka bank issued it.

  3. Download .CSV

    Clean GOOGLE_SHEETS in under 30 seconds LKR amounts preserved, dates normalised.

Why MintConvert

  • 1 Sri Lanka banks ComBank bank-specific parsers for each.
  • LKR amounts Numeric LKR import-ready for QuickBooks.
  • Date normalisation DD/MM/YYYY → YYYY-MM-DD across all Sri Lanka banks.
  • 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.
  • Privacy first Documents processed in-memory only never stored.
  • Free to start 3 free conversions/month. No credit card required.

Frequently Asked Questions

Which Sri Lanka banks are supported for GOOGLE_SHEETS conversion?

MintConvert supports Commercial Bank of Ceylon all with bank-specific parsers.

Is LKR formatting preserved in the GOOGLE_SHEETS output?

Yes all LKR amounts output as numeric values compatible with QuickBooks and Tally ERP.

Can I use this 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 date format does the output use for Sri Lanka statements?

MintConvert normalises all dates from DD/MM/YYYY to YYYY-MM-DD consistent across all 1 supported Sri Lanka banks.

What accounting software in Sri Lanka is compatible?

The output is compatible with QuickBooks, Tally ERP, Sage, Odoo. QBO output works with QuickBooks Online and Desktop.

What is the fiscal year for Sri Lanka?

Sri Lanka fiscal year: April 1 – March 31. MintConvert processes statements for any date range.