Convert Bank of Ceylon Statements to Xero CSV

To convert a Bank of Ceylon statement to Xero format, upload your PDF document to BankStmtConverter, let the parser extract each transaction row, and download the pre-formatted Xero CSV file. The resulting spreadsheet is structured specifically for Xero's bank feed import screen, mapping transaction dates, descriptions, references, and amounts directly into their corresponding fields without manual adjustments.

How to convert Bank of Ceylon statements for Xero import

1. Upload your Bank of Ceylon PDF statement (native electronic PDF or scanned copy) to the converter.
2. Select Xero as your target output format.
3. Review the preview table to verify that opening and closing balances match your original statement.
4. Download the processed CSV file and open your Xero dashboard to import the transactions.

Preparing Bank of Ceylon transaction data for Xero

Bank of Ceylon statements record debits, credits, running balances, value dates, and detailed narrative descriptions across domestic accounts. When importing bank data directly into Xero, the software expects precise column headers: Date, Amount (or distinct Spent and Received columns), Payee, Description, and Reference.

The converter parses multi-line transaction narratives common in Bank of Ceylon accounts—such as SLIPS transfers, CEFT transactions, local cheque deposits, and standing orders—and standardizes them into distinct fields. Dates are automatically converted into the standard DD/MM/YYYY format recognized by Xero organizations in Sri Lanka, preventing the common import errors caused by date discrepancies.

Importing the converted statement into Xero

Once you have downloaded your converted CSV file, log in to Xero and navigate to Accounting > Bank Accounts. Find your Bank of Ceylon account, click Manage Account, and select Import a Statement. Browse for the converted CSV file and upload it.

Because the output columns are structured specifically for Xero, the column mapping step matches automatically. You can proceed directly to the reconciliation screen, where Xero will match transaction lines against existing bills, invoices, and bank rules. If you need standard spreadsheets for audit working papers or internal models before running reconciliation, you can also generate a Bank of Ceylon Excel file or a standard Bank of Ceylon generic CSV.

Worked example: Bank of Ceylon PDF to Xero format

Consider a typical sequence of business transactions recorded in Sri Lankan Rupees (LKR) on a Bank of Ceylon corporate statement:

When processed for Xero, the tool cleans the narrative and outputs the single-column amount layout preferred by Xero's importer:

Methods for moving Bank of Ceylon statements into Xero

Accountants handling Sri Lankan clients have a few approaches for importing legacy or unlinked bank statements. The table below outlines how automated conversion compares to manual data entry and generic optical recognition tools:

Working with scanned or photographed statements

Older records, branch printouts, or physical mail statements from Bank of Ceylon often exist only as scanned paper. The converter uses an optical character recognition (OCR) engine trained on banking layouts to read tabular data from images and raster PDFs.

During processing, every transaction amount is added to the running sum and verified against the printed opening and closing balances on the statement. If a scan is smudged or incomplete, the system identifies the exact row where the math diverges, allowing you to review and correct figures before uploading the data to Xero.

Security and data privacy

Financial records contain sensitive company information. Uploaded Bank of Ceylon files are processed automatically over encrypted channels and permanently deleted from our servers immediately after extraction. Your financial data is never stored long-term, sold, or used to train machine learning models. You can view all supported institutions across the region on our Sri Lanka bank directory.