Bank Statement to Excel: The Complete Guide

The fastest and most accurate way to get a bank statement into Excel is to skip the PDF entirely and download the transactions as CSV from online banking, where that is offered. When it is not — an older period, a closed account, or a client who supplies only PDFs — converting the PDF is the fallback, and the method depends on whether the file is digital or scanned.

Key takeaways

• Try the bank's own CSV, QIF or OFX export first. No conversion, no extraction error, no third party.

• Exports usually cover a limited window. Older periods generally must come from the PDF.

• Digital PDFs and scanned PDFs are different problems requiring different tools.

• Whatever method you use, reconcile against the printed closing balance before trusting the data.

Method 1: download the transactions directly from your bank

This is the right answer whenever it is available, and it is available more often than people assume.

Most online banking platforms offer a download or export option on the transactions or statements screen, in formats including CSV, QIF, OFX and QFX. CSV opens directly in Excel. The file comes from the bank's own records rather than from reading a document, so there is no extraction step and therefore no extraction error.

Where to look: the account's transaction list, rather than the statements or documents area. Statements are usually PDF-only; the transaction list is usually where export lives. Look for a download icon, or a menu item labelled Export, Download transactions, or Download activity.

The catch — date range. Banks limit how far back the export reaches. Ninety days is common, twelve months is frequent, and longer histories are often available only as PDF statements. If you need last year's data and the export only goes back three months, you are converting a PDF.

Other limits worth knowing:

• Some banks cap the number of transactions per export, requiring several downloads.

• Closed accounts often lose online access entirely, taking the export with them.

• Business accounts sometimes expose export only in a separate cash-management portal.

• The CSV column layout varies by bank, so it may still need reshaping for your accounting software — see the CSV formats guide.

If the export covers your period, stop here. Nothing below beats it.

Method 2: convert a digital PDF statement

If the statement was generated by the bank's software — you can select text in it with your cursor — it is a digital PDF, and the transactions can be extracted from the text layer.

Try Excel first. Excel's Get Data → From File → From PDF finds tables in many documents. You already have it, it costs nothing, and for simple single-page statements it often works. Its table detection is general-purpose, so it degrades on the harder statement layouts described below.

Understand what makes a statement hard. Four structures cause most extraction errors:

1. No ruling lines. Column boundaries have to be inferred from alignment.

2. Descriptions that wrap onto a second line, which look identical to a transaction with no amount.

3. Page breaks interrupting the transaction list with headers, footers and carried-forward balances.

4. Direction carried by section headings such as "Deposits and Additions" versus "Withdrawals", rather than by a sign on each row.

The full explanation of why these break generic tools covers the mechanism. The practical consequence is that general converters do well on simple statements and inconsistently on complex ones — and the errors are quiet, producing a clean-looking sheet with wrong rows in it.

Use a statement-aware converter for the hard cases. A tool that knows the document is a statement can use constraints a general tool cannot: dates advancing through the period, the running balance acting as a checksum on every row, and section headings supplying debit/credit direction.

Method 3: convert a scanned statement

If nothing highlights when you try to select text, the PDF is an image and there is no text to extract. Optical character recognition has to create the characters first.

This adds a recognition error rate on top of the layout problem, and in amount columns those errors are dangerous because they produce plausible numbers rather than obvious mistakes — 5 read as S, 8 as 3, or a decimal point read as a thousands separator.

Two things help far more than tool choice:

• Ask for the digital original. Five minutes spent requesting a downloadable statement removes the entire error class.

• Improve the scan. 300 DPI, flat, greyscale, evenly lit. Scan quality determines most of the outcome before any software runs.

The scanned statement guide covers identification, scanning and verification in detail.

Method 4: manual entry

Slow, but sometimes correct. For a single page with fifteen transactions, typing them takes about the same time as evaluating a converter, and there is no ambiguity about the result.

It stops being reasonable at scale, and it introduces its own error mode — transposition — which is at least familiar and detectable by the same reconciliation check as everything else.

Which method should you use?

How do I verify the result — whatever method I used?

Reconcile. This is the single most useful step in the whole process and it takes under a minute.

1. Note the opening balance printed on the statement.

2. Apply every extracted transaction in order — add credits, subtract debits.

3. Compare the result to the closing balance printed on the statement.

If it matches to the cent, every amount, every sign and every row is almost certainly correct. If it does not, the discrepancy is diagnostic: a difference equal to one transaction means a row was dropped or duplicated; a difference of exactly twice a transaction means a sign is inverted; a difference of a round factor of ten suggests a misplaced decimal.

Three supporting checks worth thirty seconds each:

• Row count against the PDF, page by page.

• First and last transaction on each page, since errors cluster at boundaries.

• Sort by amount in both directions to surface outliers from misread digits.

Getting the data into accounting software

Extraction and import are separate problems, and the second has its own rules.

QuickBooks Online accepts a 3-column layout (Date, Description, Amount) or a 4-column layout (Date, Description, Credit, Debit), with a 350 KB and 1,000-line limit per upload. Xero requires only Date and Amount, but expects income and expenses in a single signed column — positive for income, negative for expenses — and accepts up to 100,000 rows.

Those two shapes are incompatible by default, which is why a converter with a stable output schema matters: reshaping a fixed date/description/debit/credit/balance output for either target is a predictable step, where a layout that varies per bank has to be re-mapped every time. Details and the common rejection causes are in the CSV formats guide.

Converting statements here

This tool exists for Methods 2 and 3. It takes digital or scanned bank statement PDFs and returns CSV or Excel with a fixed schema — date, description, debit, credit, balance — handling multi-page continuity and section-based debit/credit direction, with batch upload of up to 10 files.

Pricing is per page with no subscription: 50 free credits on signup, one credit per page, paid credits valid for a year and refundable within 7 days if unused. File limits are 50 MB signed in and 10 MB anonymously.

On data handling: source PDFs are deleted from storage immediately after processing, anonymous output files are auto-deleted after 24 hours, and documents are never used to train AI models. Full detail in the privacy policy.

The free credits are enough to run the reconciliation test above on your own hardest statement, which is a better basis for a decision than any claim on this page. Convert a statement.

Frequently asked questions

How do I convert a bank statement PDF to Excel for free?

First check whether your bank offers a direct CSV or OFX export from online banking — that is free, accurate and needs no conversion. If the period is outside the export window, try Excel's built-in Get Data → From File → From PDF, which works on simpler statements. Free tiers of dedicated converters cover occasional use beyond that.

Can Excel open a bank statement PDF directly?

Yes. Excel's Get Data feature imports from PDF and detects tables automatically. It uses general-purpose table detection, so results are good on simple, well-spaced statements and less reliable on borderless layouts with wrapped descriptions or transactions continuing across pages. It is worth trying first because it costs nothing.

How far back can I download bank transactions as CSV?

It varies by bank. Ninety days is a common minimum and twelve months is frequent; some banks offer several years. Older periods are typically available only as PDF statements, which is the main reason PDF conversion is needed at all. Closed accounts often lose online access entirely.

How do I check that a converted statement is accurate?

Reconcile it. Take the opening balance from the statement, apply every extracted transaction in order, and compare the result to the printed closing balance. A match to the cent validates every amount and sign simultaneously. Then check row counts against the original and inspect the first and last rows on each page.

What is the best format to convert a bank statement into?

CSV for importing into accounting software, since QuickBooks Online and Xero both accept it and it avoids formatting that import routines can misread. Excel is better for reviewing and correcting data first. Producing both — reviewing in Excel, importing the CSV — is a practical default.

Can I convert several months of statements at once?

Yes, with a converter that supports batch upload; this one accepts up to 10 files at a time. Keep each statement as its own file rather than merging them, because each period's opening and closing balances are what let you reconcile that period independently.