Convert Bank of Ceylon Bank Statements to CSV

To convert your Bank of Ceylon PDF statement to CSV, upload your PDF file to the converter, allow the extraction engine to process the transaction tables, and download the standardized CSV file. The tool captures dates, descriptions, debits, credits, and running balances without requiring manual text selection or copy-pasting.

How do I convert a Bank of Ceylon statement to CSV?

1. Download your Bank of Ceylon bank statement in PDF format from online banking, or scan your printed paper statement.
2. Upload the PDF file to the BankStmtConverter processing tool.
3. The extraction engine analyzes the tabular structure, isolates individual transaction rows, and validates line totals against opening and closing balances.
4. Download the generated CSV file and open it in Microsoft Excel, Google Sheets, or import it directly into your accounting software.

If you prefer an uncompressed spreadsheet with formulas intact instead of raw text, you can also use our Bank of Ceylon statement to Excel converter.

What data gets extracted from Bank of Ceylon statements?

Bank of Ceylon statements contain both customer metadata and detailed transaction grids. The conversion tool strips away repetitive page headers, disclaimers, and decorative logos to focus strictly on the underlying financial ledger. The extracted fields include:

• Transaction Date: The day the entry posted to your account, output consistently in DD/MM/YYYY format.
• Value Date: The effective interest or clearance date when recorded separately on corporate or current accounts.
• Description / Particulars: The full narration of the transaction, including cheque numbers, ATM transaction codes, vendor details, and branch clearance references.
• Debit Amount: Outgoing payments, bank charges, withdrawals, and direct debits expressed in Sri Lankan Rupees (LKR).
• Credit Amount: Deposits, inwards fund transfers, salary credits, and interest payments.
• Balance: The running ledger balance after each transaction.

Working with your converted CSV in accounting software

CSV (Comma-Separated Values) is the universal file standard for financial data interchange. Unlike proprietary formats, a clean CSV allows complete flexibility for custom column mapping in popular accounting software such as Zoho Books, QuickBooks Online, Xero, and Tally Prime.

When importing your Bank of Ceylon CSV into software like Xero or QuickBooks, you will typically assign three to five primary fields:

• Date Column: Mapped to the transaction posting date.
• Amount Column: You can choose either a single "Amount" column (where debits are negative numbers and credits are positive) or separate "Debit" and "Credit" columns depending on your target software requirements.
• Payee / Description: Mapped to the particulars field to maintain audit trails for supplier reconciliations.
• Reference: Mapped to cheque numbers or electronic reference IDs embedded in the narration.

If your workflow involves importing feeds directly into cloud software without manual CSV column mapping, explore our guide on converting Bank of Ceylon statements to Xero format.

Comparison: Manual entry vs. automated CSV conversion

Example output for Bank of Ceylon transactions

Below is a representation of how typical Bank of Ceylon current account transactions appear once parsed into standard tabular CSV data:

Does it work with scanned or photographed Bank of Ceylon statements?

Yes. Many businesses in Sri Lanka retain paper statements or receive scanned PDF archives from branch visits. The converter features built-in optical character recognition (OCR) trained on financial tables.

The OCR system recognizes printed numbers, Sinhala/English mixed alphanumeric branch references, and decimal alignments. Before outputting the CSV, the system computes the sum of all parsed debit and credit transactions against the statement's printed opening and closing balances to ensure zero line omissions.

Data privacy and security

Financial records contain sensitive personal and business information. All files uploaded to BankStmtConverter are encrypted in transit via TLS and processed on isolated servers. Statements are automatically deleted from our servers immediately after extraction. Your financial data is never stored permanently, shared with third parties, or used to train public machine learning models.

We support financial institutions across the region. Review our full directory of Sri Lanka bank statement converters to process statements from other commercial and state banks.