Turn a PDF bank statement into a file QuickBooks Desktop can read. Upload your statement and BankXLSX extracts every transaction, then writes an IIF file with TRNS and SPL lines that imports under File, Utilities, Import, IIF Files. The same upload also downloads as QBO for bank feeds, or as CSV and Excel.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940, BAI2, NACHA, camt.053, CSV
Uploading...
To convert a bank statement to IIF, upload the PDF to BankXLSX, review the date, description and amount rows it reads, and download the IIF file on the Plus plan. Each transaction is a balanced TRNS and SPL pair: the bank or card account on one line and Uncategorized Income or Uncategorized Expenses on the other, ready to recategorize in QuickBooks. Import it under File, Utilities, Import, IIF Files. QuickBooks Desktop cannot read a PDF, so this conversion is the step that turns months of statement pages into posted transactions.
QuickBooks Desktop imports lists and transactions through IIF, a tab-delimited text format, plus QBO and CSV through add-ons. A PDF is none of those, so the data has to be reshaped first. Here is what usually goes wrong.
The File, Utilities, Import menu only accepts IIF (and Web Connect QBO). A PDF bank statement has nowhere to go until you convert it into one of those formats.
Direct Connect and Web Connect feeds cover recent activity for supported banks, but fail for closed accounts, old periods, and many smaller institutions, so you fall back to the PDF.
IIF uses a strict !TRNS, !SPL, !ENDTRNS structure with tab separators. One stray comma or a missing column and QuickBooks rejects the whole file or posts to the wrong account.
Pasting a PDF table into a sheet jams date, payee, and amount into one cell, and IIF needs them cleanly separated before it will import.
Amounts copied from a PDF carry dollar signs and commas as text, but IIF needs plain signed numbers (debits negative, deposits positive) or the totals will not balance.
Typing hundreds of lines into a template by hand is slow, and a single mistyped amount throws off the QuickBooks reconciliation for hours.
Upload the PDF and the converter reads the transaction table directly, then writes an IIF file QuickBooks Desktop accepts, with CSV and Excel copies for review.
Every statement lands as date, description, debit, credit, and balance, the exact fields an IIF !TRNS line needs.
Download IIF or QBO on the Plus plan and CSV or XLSX on every plan, all from the same upload.
OCR pulls transactions from scanned PDFs and phone photos in JPG, PNG, HEIC, and TIFF, not just digital PDFs.
Upload a full statement or a year of them and the converter stitches every page into one continuous transaction list.
Templates tuned to how Chase, Bank of America, Wells Fargo, and dozens of other US banks print their statements.
256-bit encryption in transit and you can delete your uploaded files whenever you want.
No software to install and no credit card to start.
Drag your PDF, scanned statement, or photo into the box above. Password-protected PDFs work too.
Tip: Multi-page and multi-month files are fine.
The AI reads every transaction into clean date, description, and amount columns you can export.
Tip: Most statements finish in under a minute.
Download the IIF file, then import it through File, Utilities, Import, IIF Files. Recategorize the Uncategorized Income and Uncategorized Expenses lines afterward.
Tip: Create the bank account in QuickBooks first so lines post correctly.
Millions of US businesses still run QuickBooks Desktop. The clean export fits the way those teams catch up books and reconcile.
Catch up months of client transactions in Desktop without retyping a single line from the PDF.
Post historical statements for closed or unsupported accounts that no longer have a live bank feed.
Get a year of statements into QuickBooks Desktop for reconciliation and tax prep.
Move legacy statement history into a Desktop company file before a year-end close or a migration.
IIF stands for Intuit Interchange Format. It is a plain text file with tab separated columns that QuickBooks Desktop reads through File, Utilities, Import, IIF Files. Transactions live in a three line block: a !TRNS line for the main entry, one or more !SPL lines for the offsetting splits, and an !ENDTRNS line to close it. Each !TRNS line carries a transaction type, date, the bank account name, a name or payee, and a signed amount. Because the format is unforgiving about tabs and column order, the reliable path is to get clean, correctly signed rows first, then drop them into a working template.
Start from the converter output, which already separates date, description, debit, credit, and balance. For an IIF transaction line you need the date in MM/DD/YYYY, a single signed amount (money out negative, money in positive), the bank account name exactly as it appears in QuickBooks, and a payee. Starting from a bank CSV download instead of a PDF? The CSV to IIF converter writes the same file from it. Here is how the converted columns line up with what an IIF line expects.
| Converted column | IIF field | Notes |
|---|---|---|
| Date | DATE | MM/DD/YYYY format |
| Description | NAME / MEMO | Use as payee and memo text |
| Debit / Credit | AMOUNT | One signed number: debits negative, deposits positive |
| (your bank) | ACCNT | Must match the QuickBooks account name exactly |
| TRNSTYPE | TRNSTYPE | Usually CHECK, DEPOSIT, or GENERAL JOURNAL |
If you would rather skip hand building the IIF and your import tool reads CSV, the PDF bank statement to CSV converter gives you the same rows in a file most QuickBooks Desktop importers accept directly.
Both land in QuickBooks Desktop, but they behave differently. IIF imports a list of transactions you control line by line, which is ideal for historical statements, closed accounts, and bulk catch-up work. QBO (Web Connect) brings transactions into the Bank Feeds center for matching, which suits ongoing reconciliation for a connected account. Pick by the job.
| Use this when you want to | IIF | QBO (Web Connect) |
|---|---|---|
| Post historical or closed-account statements | Best choice | Often blocked |
| Bulk import many transactions at once | Best choice | Works |
| Match against the bank feed for review | No | Best choice |
| Control account and split mapping by hand | Best choice | Limited |
Either way, create the bank account in QuickBooks before you import. If a transaction names an account that does not exist, QuickBooks silently creates a new one, which is the most common reason an import looks wrong afterward.
IIF is a QuickBooks Desktop format. If you run QuickBooks Online, you import a three column CSV (date, description, amount) under Transactions, Bank transactions, Upload, not an IIF file. The QuickBooks CSV import format reference covers that layout and the four column variant in detail. For the full picture on Desktop, including the Web Connect QBO path and what to do when bank feeds stop working on an older version, see our guide on how to import bank transactions into QuickBooks Desktop. Our walkthrough on how to convert bank statements to QuickBooks covers the Online CSV path, and you can also push a statement straight to a QuickBooks file with a dedicated bank statement to QuickBooks converter.
Upload the PDF statement to BankXLSX, review the date, description and amount rows, and download the IIF file on the Plus plan. Import it through File, Utilities, Import, IIF Files in QuickBooks Desktop. Each transaction arrives as a TRNS line for the bank or card account and an SPL line posted to Uncategorized Income or Uncategorized Expenses, which you recategorize in QuickBooks.
No. QuickBooks Desktop imports transactions through IIF and Web Connect (QBO) files, not PDFs. Convert the PDF statement first. BankXLSX reads the statement and writes either file on the Plus plan, so there is no template to build by hand.
An IIF file, short for Intuit Interchange Format, is a tab-delimited text file QuickBooks Desktop uses to import and export lists and transactions. Transactions use a !TRNS line, one or more !SPL split lines, and an !ENDTRNS line. The headers tell QuickBooks which field each column maps to, so the column order and tabs must be exact.
Create the bank account in QuickBooks first, then go to File, Utilities, Import, IIF Files and select your file. For a PDF statement, convert it with BankXLSX and download the IIF file, and confirm the account name in QuickBooks matches the one in the file so the lines post to the right register.
An IIF !TRNS line needs a transaction type (such as CHECK or DEPOSIT), a date in MM/DD/YYYY, the bank account name (ACCNT), a name or payee, and a single signed amount with debits negative and deposits positive. The matching !SPL line carries the offsetting account. The IIF file from BankXLSX has all of these filled in, with the offsetting account set to Uncategorized Income or Uncategorized Expenses.
No. IIF is a tab-delimited text format for importing lists and transactions you control line by line, ideal for historical and bulk imports. QBO (Web Connect) feeds transactions into the Bank Feeds center for matching and is meant for ongoing reconciliation of a connected account. They both target QuickBooks Desktop but serve different jobs.
Bank feeds usually fail for closed accounts and old periods, so the dependable path is the PDF statement. Convert it with BankXLSX, download the IIF file, and import it through File, Utilities, Import. This is how bookkeepers post legacy history that no live feed will pull.
It can if the same transactions already exist from a bank feed or a prior import. Import a statement only once, and for an account that also uses Bank Feeds, post historical IIF data only for periods the feed did not cover. Reviewing the register by date range before importing is the fastest way to avoid duplicates.
The IIF download is part of BankXLSX Plus at $149 a month, or $74 a month billed yearly, with 1,920 pages a month and unlimited users. You can create an account and run a one-time 15 page demo (5 pages per statement) with no credit card to see how your statement is read before you subscribe.
Get clean CSV rows for any importer.
Export to QuickBooks Web Connect (QBO).
Convert PDF statements to Excel.
Cancel anytime from your account settings · refund policy
Get started converting bank statements to spreadsheets.
USD
per month
per month
$288 charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | 800 pages |
| Pro AI Best accuracy | 80 pages |
Scale statement conversion across your team with automation.
USD
per month
per month
$888 charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | 1,920 pages |
| Pro AI Best accuracy | 192 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
per month
$ charged today
One shared monthly allowance, up to half of it per day
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
Try it once, free: sign up and convert up to 15 pages (5 per statement) with no credit card. The demo does not renew.
