NDB Bank Statement to Excel: Convert PDF Statements

If you have an NDB Bank statement in PDF format and need the transactions in Excel, manually copying the data can take a lot of time.

This can become even more difficult when the statement is a scanned copy received from a client. Dates, descriptions, debit and credit amounts, and balances need to stay in the correct columns if you want to use the data for bookkeeping or reconciliation.

NDB offers e-statements for personal and corporate accounts, including transaction-level details. Its digital banking services also allow customers to view and download statements. 

But an accountant may still receive a PDF, printed statement or scanned copy from a client instead of structured transaction data.

NDB bank statement to Excel

If you search for an NDB bank statement to Excel or an NDB PDF converter, you’ll find different ways to extract transactions from a bank statement.

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

A typical NDB statement contains information such as the transaction date, value date, description, reference, debit amount, credit amount and running balance. 

When the PDF contains selectable text, extracting this information can be relatively straightforward.

A scanned statement is different. The transaction information is stored as an image, so the converter first has to recognise the text and then place each value in the correct column.

Why copying an NDB 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 appearing in the wrong format
• Descriptions breaking across multiple lines
• Debit and credit amounts moving into the wrong columns
• Reference numbers being separated from their transactions
• Decimal points being missed
• Rows not lining up correctly
• Scanned pages that cannot be copied directly

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

For several months of transactions or multiple client accounts, checking and cleaning every row can quickly become another bookkeeping task.

What if the NDB statement is scanned?

A scanned bank statement is essentially an image inside a PDF.

Because there is no selectable text, normal copy and paste may not work. OCR can read the information from the scanned page and turn it into structured transaction data.

But financial documents need more than simple text recognition.

An amount can be read incorrectly while still looking like a normal number in Excel. A transaction can also be missed without being immediately obvious.

This is why it is useful to check the extracted transactions against the statement’s running balance.

Convert an NDB statement with Banksheet

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

NDB is one of the banks currently supported by Banksheet.

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

Instead of manually entering each transaction, you can review the extracted data and work with the resulting file.

Why balance verification matters

Getting the transactions into Excel is only part of the process.

Imagine one transaction is missed during extraction. The rows around it may still look correctly formatted, so the mistake can be difficult to notice by looking at the spreadsheet alone.

The running balance provides another way to check the extraction.

Banksheet checks each extracted row against the statement’s own running balance, helping identify cases where the transaction data does not follow the balance shown on the original statement.

Excel or CSV: which should you use?

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

CSV can be more convenient when you need to move transaction data into another accounting or bookkeeping system.

NDB’s corporate digital banking services also support statement downloads and MT940 statements, so businesses may already have several ways to obtain their banking data. 

If you already have structured data from NDB, you may not need a PDF converter. The PDF-to-Excel workflow is more useful when the statement you have is a PDF, scan or other document that is not ready to work with in a spreadsheet.

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

Try converting an NDB bank statement

If you have an NDB PDF that you don’t want to enter 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 NDB statement, check the extracted transactions, and export the result to Excel or CSV.