BOC Bank Statement to Excel: Stop Retyping Scanned Statements

If you have a Bank of Ceylon (BOC) bank statement in PDF format and need the transactions in Excel, manually copying everything can take a lot of time.

This is especially frustrating when the statement is a scanned copy from a client. Dates, descriptions, payments, receipts and balances don’t always copy neatly into a spreadsheet.

BOC customers using its Smart Online Banking service can download account records in several formats, including PDF and XLS. The system also provides options such as QIF, OFX and MT940.

But accountants and businesses can still end up working with PDF statements, printed statements or scanned copies, particularly when a client sends an older statement or a document that was originally printed and scanned.

BOC bank statement to Excel

If you search for a BOC bank statement to Excel or Bank of Ceylon statement converter, you’ll find different types of bank statement conversion tools.

The basic idea is simple: upload the PDF, extract the transactions, and turn them into rows that can be opened and worked with in Excel.

The problem is that not every PDF is equally easy to convert.

With a clean digital statement, extraction can be relatively straightforward. But when a BOC statement is scanned, photographed, faded or skewed, the converter has to recognise the information from an image.

Why copying a BOC statement manually can be a problem

Opening the PDF and copying the transactions into Excel might seem like the quickest option.

With a longer statement, you may find yourself fixing:

• Dates that don’t stay in the right format
• Descriptions breaking across columns
• Payments and receipts moving into the wrong columns
• Decimal points being missed
• Rows that don’t line up
• Pages that cannot be copied because they are scanned

For a few transactions, fixing these mistakes isn’t difficult. For months of statements or several client accounts, manual cleanup can quickly become another bookkeeping task.

What if the BOC statement is scanned?

A scanned bank statement is essentially an image inside a PDF. Normal copy and paste may not work at all.

OCR can read the text from scanned pages and turn it into structured transaction data. But with financial documents, extraction is only part of the process.

If a transaction is missed or a number is read incorrectly, the extracted row may still look normal. Checking the transactions against the statement’s running balance can help identify problems that are difficult to spot by looking at individual rows.

Convert a BOC statement with Banksheet

Banksheet is built for the type of bank statements accountants often receive from clients, including scanned PDFs with skewed pages and poor contrast.

BOC is one of the banks currently supported by Banksheet.

You upload the BOC statement and Banksheet extracts the transactions into structured data. It then checks each extracted row against the statement’s own running balance.

The basic process is:

Upload the BOC statement → Extract the transactions → Check the balances → Export to Excel or CSV

This lets you work with the transaction data without manually entering everything from the PDF.

Excel or CSV: which one should you use?

Excel is useful when you want to review, sort, filter or edit transactions.

CSV is useful when you need to move the transaction data into another accounting or bookkeeping system.

Banksheet currently supports both Excel and CSV exports and can also export data for accounting tools such as QuickBooks and Xero.

Try converting a BOC bank statement

If you have a BOC PDF that you don’t want to copy into Excel manually, you can try Banksheet.

The free plan currently includes 100 pages, all export formats, and no credit card is required.

Upload your BOC statement, check the extracted transactions, and export the result to Excel or CSV.