How to Convert Bank Statement PDFs to Excel

Fastest Ways to Convert Bank Statement PDFs to Excel

Choose the method from the records you have. A bank export avoids recognising text from a PDF, so it is the first route for transaction data.

Records Available	Method	Result to Check
Internet banking access and the required history	Download CSV, then import it into Excel	Correct account, period and complete transaction list
PDF with selectable transaction text	Convert its table to Excel or CSV	One row per transaction, with intact descriptions and amounts
Scanned or photographed statement	Apply OCR, then extract the table	Characters and columns match the page image
Mixed PDFs across many accounts	Convert and consolidate with source fields	Each row retains its account and source reference

Try selecting a transaction description in the PDF. If you can copy readable text, start with table extraction. If you can only select an image, the statement needs OCR. A PDF can contain both text pages and scanned pages, so inspect more than its cover.

Before you start, obtain authorised access to the records and choose a conversion method your firm permits for client information. Keep the source PDFs unchanged. Use copies for conversion and preserve an untouched export before cleaning its rows.

A CSV download contains transaction fields separated by commas. Extracting a PDF means rebuilding those fields from the statement’s page layout. Both can produce a spreadsheet, but only PDF extraction starts from the exact document supplied in the matter.

Exporting From CommBank, ANZ and Other Banks

Download transaction history as CSV when it covers your required period. The account holder or an authorised user must perform the export through their own banking access.

The banks’ help pages describe these routes. Their export windows differ from the periods available as formal PDF statements.

Bank and Channel	Export Route	History and Formats
CommBank NetBank	Open the account’s transactions, select the required period and export CSV	CommBank’s transaction-history help describes up to two years. New NetBank supports CSV and has removed OFX and QIF exports.
ANZ Internet Banking	Account, Transactions tab, Download, Time period, Software package, Download	Up to two years for open accounts. Select CSV for a spreadsheet.
Westpac Online Banking	Overview, Exports and reports, Transactions, export option	Up to three years under Westpac’s Online Banking terms. CSV, OFX and QIF are listed, alongside QBO.
NAB Internet Banking	Accounts, Transaction history, account and date range, Export	Up to 731 days. NAB lists spreadsheet, QIF and PDF exports.

CommBank’s NetBank transaction-history guidance supplies the two-year viewing window. Its feature-change guidance confirms CSV remains available after OFX and QIF removal. After exporting, compare the earliest and latest rows with your selected period. Split a busy period into smaller exports if the downloaded rows stop early.

ANZ’s statement and export guidance gives the Download path and two-year window. Choose CSV from the software-package options to open the data in Excel. The same page distinguishes account statements from the transaction record. Its separate 120-day Transaction Report is a different download.

Westpac’s detailed export instructions let you choose the date range, accounts, file format and date format. Its Online Banking terms state the three-year transaction-history window. Select CSV for Excel, or OFX or QIF when your accounting software needs those formats.

NAB’s transaction-history guidance describes the 731-day window and Export control. Clear filters that exclude transactions before downloading the full period. For business users, NAB Connect’s report instructions explicitly list CSV for Simple reports and CSV, PDF or QIF for Advanced reports.

ANZ’s business banking guide lists CSV and software-package exports, but it does not identify every option by OFX or QIF extension. Use the CSV route here. NAB’s cited help lists QIF, with no OFX option listed. Keep the banking channel attached to each format: CommBiz and NetBank have different export menus.

To bring a CSV into Excel:

1. Open a blank workbook and import the CSV through the text/CSV import command.
2. Confirm the delimiter separates the fields into columns. Set account identifiers to text so leading zeroes survive.
3. Confirm the date interpretation and decimal separator. Check a debit and a credit against the bank record.
4. Save the working file as an Excel workbook. Retain the original CSV alongside it.

In a legal matter, preserve the formal statements when you need the bank-issued document, opening and closing balances or page references. A filtered transaction export cannot supply a missing statement page.

Free and Paid Converters for Digital PDFs

A PDF converter reads the text and its position on the page, then groups it into spreadsheet rows and columns. Adobe Acrobat’s online PDF-to-Excel converter is one example for digital PDFs. Its output is an XLSX workbook, which you can save as CSV after checking it.

Preserve Identifiers When Importing CSV

A bank’s CSV transaction export is the no-cost route when the required history is available. For a digital PDF, convert to CSV with an approved converter and import the resulting file under the same controls. CSV describes the output format, not whether the conversion service is free.

Opening a CSV directly can remove leading zeroes or change long numeric identifiers. Excel stores only 15 significant digits in a number. Applying text formatting afterwards cannot restore discarded digits. Microsoft’s identifier-preservation guidance explains why these fields must enter as text.

1. Keep the untouched CSV and open a blank workbook. In Windows Excel, choose Data, From Text/CSV, then Transform Data before loading.
2. Confirm the delimiter and encoding in the preview. A comma delimiter must produce separate transaction fields, including descriptions containing quoted commas.
3. In the query editor, remove an automatically inferred Changed Type step if it converts identifiers. Set account numbers and payment references to Text before any numeric conversion.
4. Set the date column with Change Type, Using Locale. Choose Date and the locale matching the source’s day/month/year or month/day/year order.
5. Check amount types and the debit/credit sign convention. Load the data only after the preview agrees with the source.
6. Compare complete identifiers, including leading zeroes and final digits, against the untouched export before matching transactions. Reconcile debit and credit totals and statement balances.

In Microsoft 365 for Mac, start from Data, Get Data (Power Query), then Text/CSV. Use the query editor’s type controls before loading. Microsoft’s locale instructions explain source-specific date interpretation. A later display-format change cannot repair a value already imported incorrectly.

Follow this sequence for each statement:

1. Select the source PDF in your approved converter and choose Excel or CSV output.
2. Open the result and locate the first and last transaction on each source page.
3. Join wrapped descriptions only when they belong to the same transaction. Remove repeated headers and footers from the transaction table.
4. Keep separate debit and credit fields, or a consistent signed amount. Add the source filename and page to each row.
5. Check the statement totals using the procedure below before combining files.

A free conversion can leave a description on a second row, treat a carried-forward balance as a transaction or import a footer as data. Paid conversion also needs these checks. Choose between products through the bank statement converter comparison when you need to compare their workflows.

Client statements contain account identifiers and private spending details. Before uploading them, read the provider’s file-retention terms and your firm’s requirements. Establish the processing location, who can access files, whether content is reused and how saved copies are deleted.

Adobe’s conversion page says files are processed on Adobe servers and deleted unless you sign in to save them. Its privacy policy lists Adobe and service-provider servers, with personal-information processing mainly in the US and India. That general policy does not promise Australian processing for your upload.

For any free online converter, distinguish temporary conversion from account storage or a sharing link. When the terms do not meet your firm’s requirements, use an approved local converter or the firm’s contracted processing service.

Scanned Statements and OCR Errors

OCR recognises characters in a statement image before a converter can assemble transaction rows. Smallpdf’s PDF-to-Excel page separates Basic conversion of selectable text from Advanced with OCR. It lists OCR as a Smallpdf Pro feature.

Smallpdf’s privacy notice distinguishes saved files and temporary processing. It states that account-user files are deleted within one hour unless saved to storage. Saved-file deletion generally takes up to 14 days. For logged-out files, the notice describes a reasonable period after last opening, which extends when the file is reopened.

Rotate sideways pages and obtain a clearer scan when numbers are blurred or cut off. Then inspect the extracted rows beside the source image.

Symptom	Check	Correction
A withdrawal appears as money received	Compare debit and credit column positions with the page	Correct the field mapping and review the affected page
Balance change has the wrong direction	Inspect minus signs and debit/credit indicators	Restore the sign from the source
Transactions appear in an impossible order	Read the dates on the page	Correct misread characters and date interpretation
Two payments occupy one row	Compare description and amount lines	Separate the transactions using their source lines
Totals differ by a decimal place	Inspect punctuation and digit spacing	Correct the amount and recalculate the period

Do not guess an unreadable amount from the surrounding balance. Obtain a readable source before using that transaction in a total.

Checking the Spreadsheet Against the PDF

Check each statement period separately before combining accounts. For a deposit account, the balance equation is opening balance plus credits minus debits equals closing balance.

For this hypothetical statement, the opening balance is $2,000, credits total $3,500 and debits total $2,700. The expected closing balance is $2,800: $2,000 + $3,500 - $2,700. A spreadsheet closing at $3,000 has a $200 difference to resolve.

If debit totals are in B2:B100 and credit totals in C2:C100, enter the opening balance in E2. Calculate the expected close with =E2+SUM(C2:C100)-SUM(B2:B100). Subtract the PDF’s closing balance from that result. The expected difference is zero.

Use positive debit and credit values in that formula. When your amount column already gives debits negative signs, add its net total to the opening balance instead. Credit-card statements can show the amount owed with a different sign convention, so follow the statement’s labels.

1. Match the statement’s account, opening balance and closing balance to the spreadsheet.
2. Compare credit and debit totals separately. Equal net balances can hide an omitted debit and an equal omitted credit.
3. Compare every transaction with its source page. Check the date, debit/credit sign, individual amount and complete description.
4. Count transactions on each page and compare the spreadsheet row count. Join multiline descriptions to their transaction without creating an extra payment or dropping the continuation text.
5. Check every page against its page numbering. Compare first and last transactions across page boundaries for missing or duplicated rows.
6. Compare consecutive statement periods. Investigate a gap in coverage or an opening balance that differs from the previous close.
7. Retain the source references when you sort, filter or combine the verified rows.

For example, suppose a source page contains two debits of $120 and $80. The extracted rows incorrectly show $170 and $30. Both versions total $200, so the closing balance and debit total still agree. Comparing individual amounts reveals both errors. The same review must catch a duplicated row paired with an omitted row of equal value.

A missing page can leave a period incomplete even when the remaining rows look plausible. An account-and-period register helps expose missing statements across a large bundle. For matching verified rows to accounting records, use the bank statement reconciliation guide.

Keep the description text intact during conversion. Use the bank statement abbreviations guide to interpret codes without replacing the source wording.

When a Legal Matter Needs More Than a Conversion

For court use, preserve each row’s source filename and page so the transaction is traceable to the original statement. Categorisation and reconciliation across supplied accounts make it possible to analyse spending and distinguish internal transfers from money entering or leaving the matter.

FinTrace saves lawyers, forensic accountants and investigators hours of conversion and statement review. The service processes thousands of PDF documents, including scans, into one categorised Excel ledger and a clear findings report. Advanced AI workflows use structured extraction and source-grounding checks to preserve transaction facts. Independent reviews support the analysis.

The report flags suspicious transactions and follows transfers across supplied accounts. Findings cite the source PDF filename and page, putting the supporting evidence directly at hand. Forensic accountants use the ledger to accelerate their own analysis and spend more time on interpretation.

Typical ledger fields include the account, date, description, debit, credit and category, alongside source fields. FinTrace’s workbook also includes person and financial-year fields. These let you filter cash withdrawals across accounts without rebuilding separate spreadsheets.

FinTrace performs this statement-analysis work at a fraction of the cost of manual review or engaging a forensic accountant for the same work. Each matter receives a written quote with a fixed base fee plus a per-page component. The FinTrace and DocuClipper comparison explains the choice between running conversions yourself and engaging an analysis service.

For a multi-account bundle or a long scanned history, Request a matter assessment. Describe the matter and timeframe. Include the approximate page and account counts. Statements come after assessment and quote acceptance.

OFX Files: What They Are and How to Open Them

An OFX file is a structured Open Financial Exchange export for financial applications. Banks use the format to pass account and transaction data to accounting or budgeting software. The OFX working group maintains the specification.

CSV is a table of fields separated by commas. OFX uses labelled data fields that describe financial records. A PDF statement preserves the bank’s document layout. Changing a filename from .ofx to .pdf does not convert its contents.

To open an OFX file:

1. Keep an untouched copy and select the bank-file import command in software that supports OFX.
2. Choose the destination account and import the file. Check the period, currency and debit/credit signs before accepting the transactions.
3. Export the imported transaction list to CSV or Excel if you need a spreadsheet.
4. Compare its rows and balances with the bank statements before using it in the matter.

You can also open a copy in a plain text editor to inspect its labelled fields. A dedicated OFX-to-CSV converter can produce a spreadsheet directly. Use the same privacy and validation checks as for a PDF converter.

Printing an OFX transaction list to PDF creates your own report. It cannot recreate the bank’s formal statement with its original pagination and presentation. Retain the bank-issued PDFs alongside the OFX export and use those statements for the source references in your analysis.