Convert Bank of Ceylon Bank Statements to Excel

To convert a Bank of Ceylon (BOC) bank statement to Excel, upload your PDF statement to the converter, let the system parse every transaction table, and download a structured .xlsx spreadsheet. The converter extracts the transaction date, value date, reference numbers, narration details, debits, credits, and running balances into dedicated columns ready for financial analysis.

How to convert your Bank of Ceylon statement to Excel

1. Upload your Bank of Ceylon PDF statement to the converter tool.
2. The parser reads tabular transaction data across single or multi-page documents, including scanned copies.
3. Mathematical verification checks that opening balance plus total deposits minus total withdrawals equals the closing balance.
4. Download your formatted Microsoft Excel file (.xlsx) with clean, unmerged cells.

What data gets extracted from Bank of Ceylon statements?

Bank of Ceylon statements contain structured transaction tables that must be organized accurately for bookkeeping. The converter extracts each row and maps it to specific spreadsheet columns:

• Transaction Date and Value Date: Preserved in standard DD/MM/YYYY formatting so Excel recognizes values as true date serials rather than plain text strings.
• Particulars / Narration: Full transaction text, including CEFT transfer references, SLIPS descriptions, cheque numbers, standing orders, and branch codes.
• Reference Numbers: Unique transaction identifiers separated into distinct fields for easier reconciliation.
• Withdrawals (Debits): Recorded as numeric currency values in Sri Lankan Rupees (LKR).
• Deposits (Credits): Recorded as numeric currency values in Sri Lankan Rupees (LKR).
• Running Balance: Extracted row by row to verify transaction continuity.

If you prefer raw flat files instead of formatted workbooks, you can also use our Bank of Ceylon CSV converter to feed external databases or custom scripts.

Working with Bank of Ceylon data in Microsoft Excel

Exporting your BOC statement to Excel (.xlsx) allows you to perform custom financial modeling, tax calculations, and reconciliation workflows without manual data entry. Unlike basic PDF copy-paste operations, the output uses clean grid structures without merged cells, split transaction rows, or broken decimal places.

Reconciliation with Excel formulas

Once your Bank of Ceylon transactions are in Excel, you can verify monthly totals using standard formulas. For example, sum your monthly debits and credits to ensure full alignment with bank charges and interest payments:

=SUM(D2:D50) for total withdrawals and =SUM(E2:E50) for total deposits.

You can also use =SUMIFS() to aggregate recurring payments like utility bills, vendor payouts, or local statutory tax deductions:

=SUMIFS(D2:D100, B2:B100, "*CEFT*")

Building Pivot Tables for expense categorization

Because the generated spreadsheet standardizes dates and numeric columns, you can insert a Pivot Table immediately. Group transactions by month, filter by transaction type (such as cash withdrawals, merchant settlements, or fund transfers), and generate category breakdowns for your monthly management accounts.

Example output: Bank of Ceylon Excel format

The converted workbook places each transaction component into standardized columns, allowing direct import into local accounting packages or custom financial templates used across Sri Lankan financial institutions.

Scanned and photographed statements

Older Bank of Ceylon archives or branch-printed passbook sheets are often only available as physical paper scans or low-resolution image PDFs. The converter uses optical character recognition (OCR) configured specifically for banking typography. It straightens skewed pages, detects faint table borders, and converts raster text into real numeric values. The tool then performs an automated check against the printed statement balances to detect missing lines before creating the Excel file.

Data privacy and file security

Bank statements contain sensitive commercial and personal information. Files uploaded for conversion are processed through encrypted connections and permanently removed from processing servers after generation. Your bank records are never stored long-term, indexed, or used for machine learning models. You can view our coverage options and conversion limits on the pricing page or check other supported institutions via our supported banks directory.