Sampath Bank Statement to Excel: Cleaning Up Statements for Reconciliation

If you have a Sampath Bank statement in PDF format and need the transactions in Excel, cleaning up the data manually can take a lot of time.

This can become more difficult when the statement is a scanned copy from a client. Dates, descriptions, debit and credit amounts, and balances may not stay neatly separated when you try to move the information into a spreadsheet.

Sampath Bank customers can use Sampath Vishwa for online banking, while accountants and businesses may still receive statements as PDFs, printed documents or scanned copies from clients.

Sampath Bank statement to Excel

If you search for a Sampath Bank statement to Excel or Sampath statement export, you’ll find different ways to turn statement data into a spreadsheet.

The basic process is simple: take the statement, extract the transactions, and organise them into rows that can be opened in Excel or imported into another accounting system.

The problem is that the format of the original statement can affect how clean the result is.

A digital PDF may contain selectable text, while a scanned statement is essentially an image. If the columns, descriptions or amounts are not recognised correctly, you may end up spending time cleaning the spreadsheet after conversion.

Common problems when cleaning a Sampath statement

Copying a statement directly into Excel might seem like the easiest option.

With a longer statement, you may find yourself fixing:

• Dates appearing in the wrong format
• Descriptions breaking across multiple lines
• Debit and credit amounts ending up in the wrong columns
• Transaction rows not lining up correctly
• Missing decimal points
• Scanned pages that cannot be copied directly

For a short statement, these issues may only take a few minutes to fix.

For several months of transactions or multiple client accounts, the cleanup can become part of the bookkeeping work itself.

What if the Sampath statement is scanned?

A scanned statement is an image inside a PDF, so normal copy and paste may not work.

OCR can read the text from scanned pages and convert it into transaction data. But recognising the text is only part of the process when you are dealing with financial records.

For example, an incorrectly read amount can still look like a normal transaction in Excel. A missed transaction can also go unnoticed if you only check the individual rows.

This is why checking the extracted transactions against the statement’s running balance can be useful.

Convert a Sampath statement with Banksheet

Banksheet is designed to convert bank statements into structured transaction data, including scanned PDFs with skewed pages and poor contrast.

Sampath Bank is one of the banks currently supported by Banksheet.

You upload the Sampath 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 Sampath statement → Extract the transactions → Check the balances → Export to Excel or CSV

Instead of manually rebuilding the statement in a spreadsheet, you can review the extracted transactions and work with the resulting file.

Using the statement for Xero reconciliation

Once your Sampath transactions are in a structured format, the next step may be importing them into your accounting workflow.

Xero’s reconciliation process involves comparing your accounting records with the transactions on the bank statement. Xero also provides tools for manually importing transactions when a bank feed isn’t being used. 

This is where a clean export can make the process easier.

Rather than starting with a PDF and manually entering each transaction, you can first extract the statement into structured data and then use the appropriate import format for your accounting workflow.

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

Excel or CSV: which should you use?

Excel is useful when you want to review, sort, filter or edit the transactions before using them.

CSV can be more convenient when you need to move transaction data between systems.

The right format depends on the accounting software and workflow you are using.

Try it on a Sampath Bank statement

If you have a Sampath Bank PDF that you don’t want to clean up manually, you can try Banksheet.

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

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