How to Import Sri Lankan Bank Statements into Xero When Bank Feeds Aren’t Available

If you use Xero for accounting in Sri Lanka, getting bank transactions into Xero is straightforward when your account has an available bank feed.

But when a suitable feed isn’t available, you may need to download the bank statement and import the transactions manually.

Xero supports manual bank statement imports, including CSV files. The problem for accountants and bookkeepers often starts when the statement they receive from a client is a PDF or scanned document rather than a clean CSV.

Instead of going directly from the bank to Xero, the workflow becomes:

Bank statement PDF → Extract transactions → Check the data → CSV → Xero → Reconciliation

Xero bank feeds vs manual imports

A bank feed automatically brings transactions from a participating bank or financial institution into Xero.

When a suitable feed isn’t available, Xero allows you to add the bank account and import statement data manually.

This can be useful when working with Sri Lankan clients who send their bank statements by email rather than providing access to a connected bank account.

If the bank already provides a clean CSV or another format supported by your Xero workflow, you can usually work with that file directly.

The bigger problem is when the only document you have is a PDF.

Can you import a Sri Lankan bank statement into Xero?

Yes, but the statement needs to be in a format Xero can work with.

For CSV imports, Xero requires at least:

• Transaction date
• Transaction amount

Additional information such as the payee, description and reference can also be included to make the transactions easier to identify and reconcile.

Xero expects income and expenses to be represented in the Amount column, with income as positive amounts and expenses as negative amounts.

This is why a bank statement PDF cannot simply be treated as a Xero import file.

A PDF is designed to display information as a document. A CSV contains structured transaction data.

Why copying a PDF into Excel can cause problems

A bank statement may show information such as:

• Date
• Description
• Debit
• Credit
• Balance

But copying that information directly into Excel doesn’t always preserve the original structure.

You may end up with:

• Debit and credit values in separate columns
• Dates in inconsistent formats
• Descriptions split across several rows
• Running balances mixed with transaction amounts
• Repeated headers between pages
• Empty rows
• Numbers with missing or incorrect decimal points

You can fix these problems manually, but doing so for several months of statements or multiple client accounts can become another bookkeeping task.

What if the client’s statement is scanned?

A scanned bank statement is more difficult because the transaction information is stored as an image rather than selectable text.

Normal copy and paste may not work at all.

OCR can recognise the text, but financial statements require more than simply reading characters.

For example, if the original statement contains 125,000.00 and the extraction produces 12,500.00, the resulting spreadsheet can still look completely normal.

The same problem can occur if a transaction is missed, a date is misread or an amount ends up in the wrong column.

Before importing the data into Xero, it is therefore important to check the extracted transactions against the original statement.

How to convert a Sri Lankan bank statement for Xero

If you only have a PDF or scanned statement, Banksheet can handle the extraction stage.

Upload the statement to Banksheet and it extracts the transactions into structured data. It supports scanned PDFs, including documents with skewed pages and poor contrast.

Banksheet also checks extracted rows against the statement’s own running balance.

The workflow is:

Upload the statement → Extract transactions → Check the balances → Export the data → Import into Xero

This can save you from manually rebuilding every transaction in Excel before starting the Xero import.

Step 1: Get the bank statement

Start with the statement for the account and period you need to reconcile.

If your bank has already provided a CSV or another format that works with Xero, use that file directly.

If the client has only provided a PDF, particularly a scanned PDF, you will need to extract the transactions before importing them.

This distinction is important: don’t convert structured data unnecessarily. Convert the PDF when the PDF is the only usable source you have.

Step 2: Extract the transactions

Upload the PDF to Banksheet.

The transactions are extracted into structured data that you can review before using them in your accounting workflow.

This can be particularly useful when a client sends a statement by email and you don’t have access to their online banking.

Instead of manually entering every date, description, debit, credit and balance, you start with the extracted transaction data.

Step 3: Check the running balance

This is an important check when working with extracted financial data.

A spreadsheet can look clean even when something has gone wrong.

For example, if one transaction is missed halfway through a statement, the rows before and after it may still appear correctly formatted.

The running balance provides another way to identify a possible extraction problem.

Banksheet checks the extracted rows against the statement’s own running balance as part of its verification process.

This doesn’t replace reviewing the original statement, but it gives you an additional check before the data reaches your accounting system.

Step 4: Export the transaction data

After reviewing the extracted transactions, export them in the format you need.

For a manual Xero workflow, CSV is commonly used.

Xero provides a CSV bank statement template and allows you to map the columns in an imported file to the relevant bank statement fields.

The important fields include:

• Date — the transaction date
• Amount — the income or expense amount
• Payee — where available
• Description — transaction details
• Reference — additional reference information

Xero’s import requirements mean that the exported data needs to be structured correctly before you upload it.

Step 5: Import the CSV into Xero

Once your CSV is ready, open the relevant bank account in Xero and select the option to import a bank statement.

Upload the CSV and map the columns to the appropriate Xero fields.

You may also need to confirm the date format.

This is worth checking carefully. A date such as 05/06/2026 can be interpreted differently depending on the format being used.

For Sri Lankan accounting work, make sure the date format matches the original statement before completing the import.

Step 6: Review and reconcile

Don’t consider the process finished as soon as the CSV has been uploaded.

Review the imported transactions before continuing with reconciliation.

Xero can identify transactions that may already exist as duplicates, and you can then continue with the normal reconciliation process.

The complete workflow is:

Statement → Extraction → Verification → CSV → Xero → Reconciliation

What if your bank does have a Xero feed?

If your particular bank and account are eligible for an Xero bank feed, using the feed may be more convenient because transactions can be brought into Xero automatically.

Xero recommends checking the available banks when adding a bank account.

In Xero, you can go to Accounting → Bank accounts → Add bank account and search for your bank.

If the bank or account isn’t available for the feed you need, manual statement import remains an option.

So the goal isn’t to replace a working bank feed.

It’s to have a practical workflow when the feed isn’t available or when the only statement you have is a PDF.

A practical workflow for Sri Lankan accountants

For an accountant handling several clients, the process can be as simple as:

Client sends the PDF statement

↓

Upload it to Banksheet

↓

Extract the transactions

↓

Check the running balance

↓

Export the transaction data

↓

Import the CSV into Xero

↓

Review and reconcile

This is particularly useful when clients send statements by email and you need to work from the documents they provide.

Don’t convert a file you don’t need to convert

If your client already gives you a clean CSV that works with Xero, use it.

If the bank provides another supported structured format that fits your workflow, use that instead.

The PDF conversion workflow is most useful when the statement you actually have is a PDF or scanned document.

That’s where manually entering every transaction can become unnecessary work.

Try Banksheet with a Sri Lankan bank statement

If you have a Sri Lankan bank statement in PDF format and need to get the transactions into Xero, you can try Banksheet.

Upload the statement, check the extracted transactions and export the data for your accounting workflow.

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

Have a PDF statement sitting in your inbox? Upload it to Banksheet and turn it into structured transaction data before importing it into Xero.