How to Convert Sri Lankan Bank Statement PDFs for QuickBooks Desktop

A client sends you a bank statement PDF. You need to get the transactions into QuickBooks Desktop, but the statement isn’t in a format you can import directly.

You could enter the transactions manually, but that takes time, especially when you’re working with several accounts or months of statements.

One option is to extract the data into Excel or CSV and prepare an IIF file for import. Here’s how the process works and what to check before you start.

Is IIF the Right Way to Import Bank Transactions?

IIF stands for Intuit Interchange Format. It’s a tab-separated file format that QuickBooks Desktop uses to import certain transactions and lists.

However, IIF isn’t the only option. QuickBooks Desktop also supports Web Connect imports using .QBO files. These transactions appear in Bank Feeds, where you can review and match them with existing records. Whether this option is available depends on your bank and its services. If you already have a compatible QBO file, you may not need IIF. But if you’re preparing accounting transactions for bulk import, IIF may suit your workflow.

Step 1: Convert the Bank Statement PDF to Excel or CSV

First, extract the transactions from the bank statement.

If your client can provide a structured file that works with your existing accounting process, use that instead. Otherwise, you’ll need PDF bank statement extraction software to turn the statement into usable data.

The extracted file should preserve transaction dates, descriptions, deposits, withdrawals and balances where available.

Banksheet can help extract data from PDF and scanned bank statements into Excel or CSV. Scanned or faded statements still need careful checking because OCR can misread figures or miss rows.

Step 2: Check the Transactions

Before you convert a bank statement to IIF, check the extracted data against the original document.

For example, if your opening balance is LKR 250,000 and a customer deposits LKR 75,000, the new balance should be LKR 325,000. A withdrawal of LKR 12,500 should bring it down to LKR 312,500.

Check the running balance, dates, decimal points and missing transactions. If something doesn’t match, correct it before preparing the import file.

Step 3: Prepare the QuickBooks IIF File

An Excel or CSV file isn’t automatically a valid IIF file. QuickBooks expects a specific structure, including the appropriate headers and fields for the transaction type.

Intuit provides an IIF import kit and sample files that you can use as templates. Follow the sample that matches the transaction you’re importing rather than relying on a generic CSV-to-IIF converter. 

Before importing, check that:

• Account names match the accounts in your QuickBooks company file.
• Dates and transaction amounts are correct.
• Deposits and withdrawals use the appropriate transaction structure.
• Required accounts already exist.
• Reference numbers and other details haven’t been changed during extraction.

Also consider how each transaction should be recorded. A bank charge, supplier payment and customer receipt may require different treatment. IIF imports don’t automatically link transactions to existing invoices or bills, so you may need to match them afterwards. 

Important: Banksheet’s Excel/CSV output isn’t a ready-to-import IIF file. You’ll need a separate process or tool to prepare the IIF file from the checked data.

Step 4: Import the IIF File into QuickBooks Desktop

Before importing, back up your QuickBooks company file.

For supported versions of QuickBooks Desktop for Windows, the general process is:

1. Open your company file and sign in as an administrator.
2. Go to File → Utilities → Import → IIF Files.
3. Select the IIF import option.
4. Choose your prepared file and follow the prompts.

The exact steps can vary by version. QuickBooks Desktop 2019 and later includes an improved IIF import tool that reports successful and failed records and creates a file containing failed transactions when errors occur. Check the documentation for your edition before importing. Intuit also states that IIF files cannot be transferred directly between different country versions of QuickBooks. 

Step 5: Review and Reconcile

Once the import is complete, check that the transactions appear in the correct accounts.

Look for duplicate entries, missing transactions, incorrect dates and amounts that don’t match the original statement. If customer payments or supplier payments need to be linked to existing records, complete that work too.

Finally, reconcile the account against the bank statement. Importing the transactions doesn’t mean the account is automatically reconciled.

A Practical Workflow for Sri Lankan Accountants

Whether you’re working with statements from Commercial Bank, Bank of Ceylon, HNB, Sampath Bank or another local bank, the process is much the same:

Bank statement PDF → Excel/CSV → Check the data → Prepare IIF → QuickBooks Desktop → Reconcile

If your client already provides a compatible QBO file, you may be able to use Bank Feeds instead. Otherwise, Banksheet can help with the PDF bank statement extraction stage before you prepare the data for import.

Try Banksheet with a real statement and check the extracted transactions against the original. It’s a practical way to see whether it saves you time before you prepare your QuickBooks import.