QIF to QuickBooks Online: Import QIF and Upload Bank Transactions to QBO

Convert a QIF to QuickBooks Online the reliable way: turn any bank or card QIF into a .qbo Web Connect file that imports cleanly, no field mapping or errors.

Totals reconcile to the original QuickBooks Online and Desktop
.qif → .qbo
No file handy?

No account needed for your first conversions. We never store your bank login.

QuickBooks Online does not import QIF files at all, so a QIF export from Quicken or Microsoft Money has nowhere to go on its own. Converting the QIF to a .qbo Web Connect file solves that: you upload the .qbo and QuickBooks imports it as a standard bank feed, with no field mapping and no format wrestling. The converter at the top of this page does that conversion in one pass.

Drop in a QIF export from any US bank, credit card, or personal-finance tool. You get back a .qbo file that imports into QuickBooks Online (and QuickBooks Desktop), plus Excel and CSV copies. The converter reads each transaction's QIF tags, the date (D), payee (P), and amount (T), and checks the parsed total against your original file before you export, so nothing is silently dropped.

A real .qbo file QuickBooks accepts

Built for the QIF files Quicken and finance tools actually export, checked before it exports.

Reconciliation

Every total checked against your file

The converter adds up the transactions it parsed and matches that to your file total before you export, so nothing is silently dropped.

Web Connect

A genuine .qbo, not a renamed QIF

Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.

QIF tags

Your QIF tags read for you

Date, payee, and amount are read straight from the QIF tags, so there is nothing to map and no layout to match.

Volume

A year of QIF files in one batch

Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.

Dates and amounts

Dates and amounts fixed for you

Mixed date formats, apostrophe years, currency symbols, and split lines in a QIF are cleaned up and summed before the .qbo is built.

Exports

Excel and CSV in the same download

One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.

How to convert your QIF to QuickBooks

Three steps. No column-mapping wizard.

1

Upload your QIF file

Drag in a .qif export from Quicken, your bank, or another finance tool. Any QIF type works.

2

Review the reconciled rows

Every transaction is parsed and checked against your file total. You see the rows before exporting.

3

Import into QuickBooks

Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.

Questions worth answering

The specifics that decide whether the import is clean. If your case is not here, message us in chat.

How do I import a QIF file into QuickBooks Online?

QuickBooks Online has no QIF import, so you convert first. Upload your QIF in the converter above, download the .qbo, then in QuickBooks Online go to Transactions, Bank transactions, choose the account, and select Upload from file. Pick the .qbo and review the imported transactions. The .qbo path removes the field-mapping step entirely.

Does QuickBooks Online accept QIF files?

No. QuickBooks Online accepts a strict CSV or a .qbo Web Connect file for bank and credit card transactions, but not QIF. Quicken's QIF format was never supported in QuickBooks Online. Converting your QIF to a .qbo is the dependable way to bring those transactions into the bank feed.

Can you import a QIF file into QuickBooks Online?

Not directly, but yes by converting it. QuickBooks Online imports .qbo Web Connect files, and the converter above reshapes your QIF into exactly that. It reads the QIF tags and writes the precise OFX structure QuickBooks expects, so the file imports as a clean bank feed instead of being rejected.

Why won't my QIF import into QuickBooks Online?

Because QuickBooks Online does not read QIF in the first place. There is no upload path for a .qif file, so it will not load no matter how clean the file is. The fix is to convert the QIF to a .qbo, which QuickBooks Online does accept under Bank transactions, Upload from file.

How do I upload bank transactions to QuickBooks Online?

Download or export the transactions as a QIF from your bank or finance software, convert that QIF to a .qbo, and upload the .qbo under Transactions, Bank transactions, Upload from file. The .qbo imports as a Web Connect bank feed, so QuickBooks routes every transaction straight into the review queue for categorizing and matching.

What is the difference between a QIF and a QBO file?

A QIF is a Quicken Interchange Format text file: tagged records (D for date, P for payee, T for amount, M for memo) separated by a caret, with no fixed account identity. A .qbo file is a QuickBooks Web Connect file in OFX format with a defined layout and bank IDs QuickBooks reads natively. Converting QIF to QBO turns a legacy Quicken export into the precise file QuickBooks was built to accept.

Can I import credit card transactions from a QIF?

Yes. Credit card QIF files convert the same way as bank QIF files. Export the activity from your card account or Quicken, convert it to a .qbo, and import it into the matching credit card account in QuickBooks Online; the credit card QIF to QuickBooks guide covers the sign convention in full. Charges need to import as negative and payments as positive, which the converter sets correctly when it builds the .qbo file.

How many transactions can I import into QuickBooks Online at once?

A CSV upload is capped at 350 KB, roughly a thousand rows, and QIF has no native path at all, so long histories used to be a problem. A .qbo import is not held to that 350 KB limit, so converting your QIF lets you bring a full year of transactions into QuickBooks in a single file.

Can I import a QIF into QuickBooks Desktop too?

QuickBooks Desktop dropped QIF transaction import, but it imports .qbo Web Connect files directly. Convert your QIF to a .qbo, then in Desktop go to File, Utilities, Import, Web Connect Files; the QIF to QuickBooks Desktop guide walks through it. The same converted file works for both QuickBooks Online and Desktop, so you only convert once.

Convert a QIF to QBO in three steps

Upload your QIF export in the converter above. The tool reads the date (D), payee (P), and amount (T) tags from every record, normalizes the dates to MM/DD/YYYY, signs each amount correctly, and checks the running total against your file. Download the .qbo and import it under Transactions, Bank transactions, Upload from file. The whole pass takes under a minute, with no mapping wizard to fight.

How the converter reads your QIF file

QIF stores each transaction as a small block of tagged lines: D for the date, T for the amount, P for the payee, M for an optional memo, L for a category, and N for a check or reference number, with each record closed by a caret on its own line. The converter reads those tags directly, so there are no columns to line up and no template to match. It maps the date, payee, and amount into the OFX fields QuickBooks reads, so the file QuickBooks receives is already correct.

Who uses a QIF to QuickBooks Online converter

Bookkeepers and accountants doing catch-up work rely on it most, because clients hand over a year of bank and card QIF exports that QuickBooks Online cannot read. Small business owners use it to import accounts QuickBooks cannot connect by bank feed, and anyone migrating off Quicken or Microsoft Money uses it to move historical transactions into QuickBooks without retyping them.

Import older transactions the bank feed cannot reach

A live bank feed in QuickBooks Online usually pulls only the last 90 days, and it skips closed accounts and the gap before you connected. Your bank or your old Quicken file still holds those older months as exportable QIF. Convert each QIF to a .qbo and you can backfill any period into QuickBooks, well beyond what the feed alone would ever import.

Does the converted file balance to my QIF?

Convert your first file free.

Upload a QIF export, get a QuickBooks-ready .qbo back in seconds. No card to try it.

Related guides

Yes, and that check is the whole point. Before the .qbo downloads, the converter sums every transaction it parsed and compares it to the total in your QIF. If a record is missing or misread, you catch it in the preview instead of discovering it weeks later during reconciliation. You export only once the parsed rows match your file. Working from a Quicken export? Use the QIF to QBO converter to turn any .qif file into the same import-ready file, convert any QIF to QBO from the home page, read the full guide to importing bank statements into QuickBooks, compare the best QIF to QBO converters on price and features, batch many files at once with the bulk QIF to QBO converter, or learn what a .qbo file is and why QuickBooks needs it.