Skip to content
Toolspike

Bank Statement Converter

Convert PDF bank and credit card statements, or CSV, OFX, QIF and Excel files from a bank, to Excel, CSV, QuickBooks QBO or IIF, Quicken QFX, OFX, QIF or Tally XML, checked against the balance and printed totals. Files with text are read in your browser; scans and photos can be read with AI.

Reads PDFs with text in your browser; scans and photos go to AI only when you choose

5 statement pages free every day with a free account, and every row and the balance check to see first. A Statement Pass covers bigger jobs, paid once.

  • Stays on your deviceA PDF with text is read in this browser and never uploaded. A scan is sent to our AI provider only if you choose.
  • Checked against the balanceEvery row has to land on the running balance the bank printed, so a misread figure shows up before it reaches your books.
  • Nothing keptNo statement or download is stored on our servers, and a password only opens the file.

See it before you upload

From PDF lines to rows your books accept

The first rows of the made-up sample statement, as printed and as you download them. Press “Try a sample statement” above to open all of it.

What the statement prints

  1. 08/01POS PURCHASE BLUE DOOR COFFEE #12 SEATTLE WA5.45Withdrawals
  2. 08/02CHECK 10451,200.00Withdrawals
  3. 08/03ACH DEPOSIT NORTHWIND LLC PAYROLL2,500.00Deposits
  4. 08/05WIRELESS BILL AUTOPAY89.99Withdrawals
  5. 08/08POS PURCHASE BLUE DOOR COFFEE #12 SEATTLE WA6.10Withdrawals

What you download

  1. Blue Door Coffee SeattleRestaurants and takeaway−$5.45Aug 1
  2. Check 1045Uncategorized−$1,200.00Aug 2
  3. Northwind LLC PayrollPayroll and wages+$2,500.00Aug 3
  4. Wireless Bill AutopayPhone and internet−$89.99Aug 5
  5. Blue Door Coffee SeattleRestaurants and takeaway−$6.10Aug 8

Reconciled: every running balance matches

Opens in the software you use

  • QuickBooks OnlineQBO or CSV
  • QuickBooks DesktopQBO or IIF
  • XeroOFX or CSV
  • QuickenQFX
  • SageCSV
  • WaveCSV
  • FreeAgentCSV
  • MYOBOFX or QIF
  • Zoho BooksCSV, OFX or QIF
  • GnuCashOFX or QIF
  • Excel and Google SheetsXLSX or CSV
  • TallyXML

Product names belong to their owners; Toolspike is not connected with them. Each file is one that program’s own import reads.

Insights on every statement

Average daily balance
$7,103.26
Biggest spending category
Rent and mortgage, $2,000.00
Recurring payment found
Blue Door Coffee Seattle, weekly, about $5.45
Returned, NSF or overdraft rows
1

Figures from the made-up sample. Your own statements get the same panel, and the full lists in the Insights sheet of the Excel download.

Turn a PDF bank statement into Excel, QuickBooks or Tally, checked against its own balances

Add a statement from your bank or card issuer and its transactions are read into a table: date, description, reference, money in, money out and the running balance. Each row is checked against the balance printed beside it, as are printed totals and daily balances, so a misread figure or a skipped line shows up before it reaches your books.

Download Excel, CSV, JSON, QuickBooks or Quicken Web Connect, IIF, OFX, QIF or Tally XML, each row with a payee and a category, or a PDF report of the checks. PDFs with text and CSV, OFX, QIF or Excel files are read by your browser and not uploaded; a scan or a photo can be read with AI instead.

What Bank Statement Converter gives you

Checked against the balances

Opening balance plus credits, minus debits, has to land on the balance printed on each row or in the daily balance table. Section totals such as Total Checks Paid are compared with their rows, and a row that breaks the chain is marked with the likely cause.

PDFs, bank files, scans and photos

CSV, OFX, QFX, QBO, QIF and Excel files from a bank open like PDFs. A statement holding several accounts is split into one per account. Scans and phone photos can be read with AI, each page counting as 2.

Formats your software imports

CSV laid out for QuickBooks Online, Xero, Sage, Wave, FreeAgent or YNAB, or with the columns and date style you choose. Keep only some dates, get one file per statement as a ZIP, or copy the rows into a spreadsheet.

Several months in one file

Add up to 12 statements and export them together, oldest first, with repeated rows kept once, gaps between balances pointed out and transfers between your accounts matched.

Find, compare and fix rows

Search by words or amount, filter the rows, and see any row outlined on its page. Correct, add or delete rows, set a category on many at once, and undo a change.

Insights, income and a report

Recurring payments, categories, returned items, income by month and its sources, and days below a balance you choose. A document check lists signs that a PDF was edited, as hints rather than proof.

How to use Bank Statement Converter

  1. Add your statements

    Choose PDF statements, bank files or photos of a paper statement, and type the password of a protected file.

  2. Check the rows

    Read the checks, open any marked row to compare it with the page, and fix it if needed.

  3. Download

    Pick the format your software imports, adjust its settings, and download the file or the report.

Other names for this tool

People also look for this as bank statement to excel, pdf bank statement to excel, bank statement to csv, pdf to qbo, pdf to ofx, bank statement to tally and credit card statement to excel. It is the same tool on this page.

Limitations

  • Scanned pages and photos are read with AI: each page counts as a run, up to 40 pages at a time, and a figure can be misread, so check any row the balance check marks.
  • Up to 12 files of 25 MB each at a time; photos added together count as one statement.
  • The IIF file posts every row against one account you name, to be recategorised in QuickBooks Desktop.
  • Categories and recurring payments are worked out from descriptions and dates, so check them before relying on them; nothing is sent anywhere to do it.
  • The document check points out signs that a PDF was edited; it cannot prove that a statement is genuine.

Questions about Bank Statement Converter

Is my statement uploaded?

Not a PDF with text, nor a CSV, OFX, QIF or Excel file: your browser opens and reads it, and every download is made there. A scan or a photo has no text, so when you choose to read it with AI, the image of each page is sent to our AI provider and we keep no copy. A password only opens the file and is not kept.

How do I know the rows are right?

Each row is checked against the running balance printed beside it, and the totals against the opening and closing balances, whether it was read from the text or with AI. Rows where the balance breaks are marked, with the likely reason, and you can compare them with the page before exporting.

Does it sort transactions into categories?

Yes. Each row gets a category from its description, such as Groceries, Utilities or Payroll and wages, using merchant names from the US, Canada, the UK, Australia, New Zealand and India. Change any row, or add rules, and the Excel, CSV, QIF and JSON downloads follow.

Which banks does it work with?

Any bank or card issuer whose statement PDF has selectable text. It reads the column layout of each file rather than a list of known banks, so debit and credit columns, sections such as Deposits and Checks Paid, Cr and Dr markers, and signed amounts all work.

Why does it say my statement has no text layer?

The file is a scan or a photo of paper, so it holds a picture of the page rather than text. Read its pages with AI, where each page counts as 2 pages, or download a fresh copy from online banking, which nearly always has text.

How do I import the QBO or IIF file into QuickBooks?

For QBO, choose File, Utilities, Import, Web Connect Files in QuickBooks Desktop, or upload it from the bank transactions page in QuickBooks Online; rows keep the same ID each time, so repeats are recognised. For IIF, name the account exactly as in QuickBooks, then choose File, Utilities, Import, IIF Files.

How do I import the XML into Tally?

In TallyPrime press Alt+O, choose Import and then Transactions, and give the path of the vouchers file. Import the ledger file under Masters first if the ledgers do not exist yet, because Tally rejects a voucher that names a missing ledger.

What does "worked out from the balance" mean on a row?

Some statements print an amount with no sign or column to say which way the money went, or hide the minus sign. The direction is then taken from the running balance: if the balance rose by that amount, it was money in. Those rows are marked for checking.

Can it read credit card statements?

Yes. A card statement is recognised from phrases such as payment due date, purchases are counted as money owed rather than money out, and the QBO and OFX files use the credit card format that accounting software expects.

Can it tell whether a statement was edited?

It looks for signs such as a figure in a different font, size or position from the rest of its column, text printed over other text, missing pages, and an editing program in the file details. These are hints, not proof, because a genuine statement saved again in a PDF program can show the same signs.

Is my statement uploaded or stored?

A PDF with text and a CSV, OFX, QIF or Excel file are not: your browser opens them and makes every download. A scan or a photo is sent as page images to our AI provider only when you choose to read it with AI, and we keep no copy. A password only opens the file.