How to Import Sri Lankan Bank Statements into QuickBooks Online

If you use QuickBooks Online for accounting in Sri Lanka, you may receive bank transactions from clients in several different formats.

Some clients can send you a file that is ready to import. Others may send a PDF bank statement. You may also receive a scanned copy when the client does not have the original electronic file.

QuickBooks Online supports manual bank transaction uploads, including CSV, TXT, QBO and OFX files. It can also accept an account statement as a PDF or image in supported workflows and use AI to extract the transactions. For the PDF or image workflow, the statement needs to be in English. For accountants and bookkeepers, the difficult part is often not getting the bank statement.

It is getting the transactions out of that statement in a form you can actually use. 

Can you import a Sri Lankan bank statement into QuickBooks Online?

Yes.

QuickBooks Online lets you manually upload transactions when you cannot connect the bank account or when you need to add transactions from an earlier period. For transaction-list uploads, QuickBooks currently supports files such as:

CSV

TXT

QBO

OFX

QuickBooks also lets you upload an account statement as a PDF or image in supported workflows. It extracts the information and shows the original statement alongside the extracted transactions so you can review them before saving.

For CSV files, QuickBooks accepts either:

Date | Description | Amount

or:

Date | Description | Credit | Debit

With the three-column format, money coming into the account is positive and money going out is negative. So the file you start with makes a difference.

If you already have a clean QBO or CSV file, importing the transactions is relatively straightforward.

If all you have is a PDF, there may be some preparation involved. 

What Sri Lankan bank statements can you use?

Sri Lankan banks provide customers with different ways to download account information.

Commercial Bank’s Digital Business service provides account statements in PDF format and supports MT940 statements. 

BOC Smart Online Banking provides downloads in PDF, XLS, QIF, OFX and MT940 formats. The downloaded information can include the transaction date, value date, description, reference number, debit and credit. 

People’s Bank’s corporate internet banking service provides statement downloads in PDF, TXT, CSV and MT940 formats. 

So if your client sends you a suitable CSV or another file that QuickBooks accepts, there may be no reason to convert it.

The problem is more likely to come when the client sends a PDF or scanned statement.

Why a PDF bank statement can take extra work

A PDF can contain all the information you need without actually being ready for accounting software.

You may be able to read the transaction date, description, debit, credit and running balance clearly on the statement. But copying it into Excel is a different story.

The description might end up on two or three lines. A debit or credit amount can land in the wrong column. You might also get page headings mixed in with the transactions, or the running balance could be picked up as another amount.

Even small formatting problems can mean spending more time cleaning the file before you can import the transactions.

For one short statement, that may not matter much.

For several months of transactions or several client accounts, manual cleanup becomes another data-entry job.

This is where a free bank statement converter can be useful if you need to turn a PDF into structured transaction data. Depending on the file you have, you may be looking for a free bank statement converter to excel, free bank statement converter to csv, or free bank statement converter pdf to excel.

What if the bank statement is scanned?

A scanned bank statement can be more difficult because the transactions may be stored as an image rather than normal text.

OCR can recognise the characters on the page, but that does not automatically mean the transaction has been extracted correctly.

The date, description and amount still need to stay together.

For example, if the statement shows:

125,000.00

you do not want the extracted file to contain:

12,500.00

A missing transaction can be another problem. If you are working with hundreds of rows, it is not always obvious that one transaction disappeared during extraction.

That is why it is important to check extracted financial data against the original bank statement.

Can QuickBooks Online read a PDF bank statement?

Yes.

This is important because you do not necessarily need to convert every PDF into Excel before using QuickBooks Online.

QuickBooks currently allows an English PDF or image statement to be uploaded directly in supported workflows. Its AI extracts the information and gives you a side-by-side view of the statement and the extracted transactions. You can review and edit the information before saving it. So if QuickBooks reads your client’s PDF correctly, you can work with it directly. 

A separate bank statement converter can still be useful when you receive scanned documents, several client statements or statements that you want to extract and check separately before importing them.

If you are specifically looking for a free bank statement converter ai, the same point applies: extracting the data is only one part of the process. You still need to check the transactions against the original statement.

Where Banksheet can help

Banksheet is designed to extract transactions from bank statement PDFs.

It can work with scanned PDFs, including documents with skewed pages or poor contrast.

It also checks the extracted transaction rows against the running balance shown on the statement.

This gives you another way to spot a possible extraction problem before you export the transactions.

For example:

Bank statement → Banksheet → Extract transactions → Check running balance → Export → QuickBooks Online

This can be useful when you are working from statements sent by clients rather than directly from their online banking accounts.

It can also be useful when you need a free bank statement converter pdf to CSV workflow before moving the data into another accounting system.

How to prepare a Sri Lankan bank statement for QuickBooks

Step 1: Get the statement

Start with the bank statement for the account and period you need.

If your client can provide a QBO, OFX or suitable CSV file that already works with QuickBooks, use that file.

If the client only has a PDF or scanned statement, you can work from that instead.

Step 2: Extract the transactions

If you are working with a PDF, you can upload it to Banksheet and extract the transaction information.

This can save you from manually entering every transaction into Excel.

It is particularly useful when the statement contains a large number of transactions or when the source document is scanned.

You should still compare the extracted information with the original statement.

Step 3: Check the transaction data

Before importing the transactions into QuickBooks, check the important fields.

Look at:

Dates

Descriptions

Debit amounts

Credit amounts

Running balances

Missing transactions

Banksheet checks the extracted rows against the running balance on the statement.

That can help identify an error that may not be obvious when looking at one transaction on its own.

It is an additional check, not a replacement for reviewing the original statement.

Step 4: Prepare the QuickBooks file

If you are importing a CSV, make sure it follows QuickBooks’ requirements.

QuickBooks accepts:

Date | Description | Amount

or:

Date | Description | Credit | Debit

QuickBooks recommends keeping the dates in one consistent format and recommends DD/MM/YYYY. It also has some specific requirements for CSV files, including removing “amount” from Credit and Debit headers, leaving zero-only amount cells blank and removing numbers from the Description field. If your file contains unnecessary columns, cleaning them up before importing can also make the column-mapping process easier. 

Step 5: Upload the transactions

In QuickBooks Online, go to Accounting → Bank transactions and choose the option to upload transactions.

Select the account, upload the file and map the columns to the appropriate QuickBooks fields.

Check the mapping carefully before continuing.

A file can be formatted correctly but still import incorrectly if, for example, the debit and credit columns are mapped to the wrong fields.

For transaction-list uploads, QuickBooks allows up to 1,000 lines per upload. The file must also be in English and no larger than 350 KB. If you have a larger statement, you may need to split it into smaller batches. 

Step 6: Review and reconcile

Importing the transactions is not the final step.

QuickBooks recommends matching and categorising the uploaded transactions and then reconciling them to make sure they have been recorded correctly. The original bank statement should remain available as the source document.

The spreadsheet or imported transaction file is the working data. 

What if QuickBooks already reads the PDF?

You may not need another converter.

If you have an English PDF or image statement and QuickBooks can extract it correctly, you can review the transactions directly in QuickBooks.

Banksheet is more useful when you want to handle the extraction separately.

For example, you may have several statements from different clients, scanned documents that need extra checking, or simply want to verify the transaction data before sending it into your accounting software.

That gives you a separate extraction and checking stage before the accounting work begins.

Don’t convert a file unnecessarily

If your client gives you a QBO file that works with QuickBooks, use it.

If you have a suitable CSV or OFX file, use that too.

There is no reason to convert a clean transaction file just because a PDF converter is available.

The PDF-to-Excel or PDF-to-CSV process is more useful when the document you actually have is a PDF, scan or image.

QuickBooks also recommends converting a PDF to Excel before converting it to CSV in its guidance for PDF bank statements, because Excel makes it easier to review and edit the extracted information. 

For accountants working from client-provided documents, knowing when not to convert a file can save just as much time as converting one.

The same applies if you are searching for a free bank statement converter to tally prime. If you already have a file in a format that works with your accounting workflow, there is no need to convert it unnecessarily.

You may also see searches such as icici bank statement pdf to excel converter online free. That is a separate search for ICICI Bank statements and is not part of the Sri Lankan bank statement workflow covered here.

What about Xero?

The same issue comes up when the next step is Xero.

Xero supports manual bank statement imports using formats including CSV, OFX, QFX, QIF and QuickBooks files. For CSV imports, you can edit the file before importing it and map the columns to Xero’s bank statement fields.

Xero’s current documentation also says PDF bank statement imports are only available to organisations in the US and Canada, so a Sri Lankan accountant should not assume that a PDF can simply be uploaded directly into Xero.

That makes a PDF-to-CSV or PDF-to-Excel step useful when the client has only provided a PDF.

A simple workflow is:

Sri Lankan bank statement PDF → Extract transactions → Excel/CSV → Xero → Reconcile

The original statement remains the source document while the extracted file becomes the data you work with.

A practical workflow for Sri Lankan accountants

If you manage several client accounts, the process can be quite simple.

Your client sends you a bank statement.

↓

You upload the PDF to Banksheet.

↓

The transactions are extracted.

↓

You check the transactions against the running balance.

↓

You export the transaction data.

↓

You upload the file to QuickBooks Online.

↓

You review and categorise the transactions.

↓

You reconcile them with the bank statement.

This means you do not have to manually type every transaction simply because a client sent you a PDF instead of a spreadsheet.

Try Banksheet with a Sri Lankan bank statement

If you have a Sri Lankan bank statement in PDF format, you can use Banksheet to extract the transaction data before continuing with your accounting workflow.

Upload the statement, review the extracted transactions and check them against the statement’s running balance before exporting the data.

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

Have a PDF bank statement sitting in your inbox? Upload it to Banksheet and turn the document into structured transaction data before working with it in QuickBooks Online.