Can QuickBooks import QIF files?

No. QuickBooks Online accepts .csv, .txt, .qbo, .ofx and .qfx uploads. QuickBooks Desktop takes Web Connect (.qbo) and IIF files. Converting QIF to QBO gets your data into either one.

Is this QIF to QBO converter free, and do I need an account?

Yes. Converting a QIF file to QBO is free, with no account required. Files are encrypted with AES-256 and deleted automatically.

How does the converter know my QIF date format?

It looks at the dates in your file. A day above 12 settles the order. If every date could go either way, check the preview and switch the QIF date format option if needed.

Will my Quicken or Money categories come across?

No. QBO files carry transactions, not categories. You'll categorize them in QuickBooks during review, and QuickBooks Online bank rules can help with repeat payees.

Can I convert an old Microsoft Money file?

Yes, once it's exported as QIF. Open it in Microsoft Money, use File › Export, and choose Loose QIF. Then upload that file here.

Why not import the QIF file into Quicken instead?

Current Quicken for Windows blocks QIF imports into checking, savings and credit card accounts. For those accounts it expects a QFX file. For QuickBooks, QBO is the format you need.

Convert QIF to QBO Free for QuickBooks

How to convert a QIF file to QBO

01
Upload the QIF file.
Drop the .qif file you exported from Quicken, Microsoft Money or your bank. No file handy? Click Try a sample QIF file.
02
Confirm the settings.
Check the detected date format, then pick the account type. If you use QuickBooks Desktop, choose the bank it should see.
03
Review and download.
Scan the first 10 transactions for correct months and amounts. Then click Download QBO file.

QIF to QBO converter example

This fictional QIF uses apostrophe-year dates and a comma-separated amount. The converted QBO contains the transaction totals and generated IDs, not Quicken categories or split allocations. Bank details in this example are fictional.

QIF input

!Type:Bank
D3/ 4'26
T-48.75
POffice Depot
^
D3/ 9'26
T3,200.00
PClient payment – Acme LLC
^
D3/16'26
T-650.00
N3017
PCheck 3017
^

QBO output

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
  <SIGNONMSGSRSV1>
    <SONRS>
      <STATUS>
        <CODE>0</CODE>
        <SEVERITY>INFO</SEVERITY>
      </STATUS>
      <DTSERVER>20261024231308[0:GMT]</DTSERVER>
      <LANGUAGE>ENG</LANGUAGE>
      <FI>
        <ORG>Sample Bank</ORG>
        <FID>00000</FID>
      </FI>
      <INTU.BID>00000</INTU.BID>
    </SONRS>
  </SIGNONMSGSRSV1>
  <BANKMSGSRSV1>
    <STMTTRNRS>
      <TRNUID>0</TRNUID>
      <STATUS>
        <CODE>0</CODE>
        <SEVERITY>INFO</SEVERITY>
      </STATUS>
      <STMTRS>
        <CURDEF>USD</CURDEF>
        <BANKACCTFROM>
          <BANKID>000000000</BANKID>
          <ACCTID>0000</ACCTID>
          <ACCTTYPE>CHECKING</ACCTTYPE>
        </BANKACCTFROM>
        <BANKTRANLIST>
          <DTSTART>20260304000000[0:GMT]</DTSTART>
          <DTEND>20260317000000[0:GMT]</DTEND>
          <STMTTRN>
            <TRNTYPE>DEBIT</TRNTYPE>
            <DTPOSTED>20260304120000[0:GMT]</DTPOSTED>
            <TRNAMT>-48.75</TRNAMT>
            <FITID>9c13041a8c8049ad29b1ef6c2e568dd9b77c700c00af3e72eeea184f23084fb4</FITID>
            <NAME>Office Depot</NAME>
          </STMTTRN>
          <STMTTRN>
            <TRNTYPE>CREDIT</TRNTYPE>
            <DTPOSTED>20260309120000[0:GMT]</DTPOSTED>
            <TRNAMT>3200.00</TRNAMT>
            <FITID>59cf0c9628c3c59f8ddd47fa16c0be5a44b98153f66a366f5b524638880c3917</FITID>
            <NAME>Client payment – Acme LLC</NAME>
          </STMTTRN>
          <STMTTRN>
            <TRNTYPE>DEBIT</TRNTYPE>
            <DTPOSTED>20260316120000[0:GMT]</DTPOSTED>
            <TRNAMT>-650.00</TRNAMT>
            <FITID>03b72fc52b6fc935c65fe308f26d1f1265e55116c73c196ab05b79460985dec6</FITID>
            <CHECKNUM>3017</CHECKNUM>
            <NAME>Check 3017</NAME>
          </STMTTRN>
        </BANKTRANLIST>
        <LEDGERBAL>
          <BALAMT>0.00</BALAMT>
          <DTASOF>20261231235959[0:GMT]</DTASOF>
        </LEDGERBAL>
      </STMTRS>
    </STMTTRNRS>
  </BANKMSGSRSV1>
</OFX>

QIF to QBO field mapping

QIF marks each line with a single letter, and a caret (^) ends each transaction. Here's how those letters become QBO tags, plus the values QBO needs that QIF never had.

QIF field	QBO field	Note
D (date)	DTPOSTED	Read using your QIF date format setting. The apostrophe in 3/ 4'26 means a 2000s year.
T (amount)	TRNAMT	Commas are removed. Negative stays money out.
P (payee)	NAME	The payee as it appeared in your QIF file.
M (memo)	MEMO	Carried over when present.
N (check number)	CHECKNUM	Carried over for checks.
L (category)	Not carried	QBO files hold no categories. You assign them in QuickBooks when you review.
S, $ (split lines)	Not carried	QBO has no splits. The transaction total from T is kept.
Not in QIF	FITID	A unique ID is added to each transaction so QuickBooks can track it.
!Type:Bank or !Type:CCard	ACCTTYPE	Set by the Account type option.
Not in QIF	INTU.BID	Set by the Bank shown in QuickBooks option.

How to import your converted QIF into QuickBooks

QuickBooks treats the converted file like a Web Connect download from your bank. Pick the tab for your version.

QuickBooks Online

QuickBooks Online · Documentation checked 2026-10-25

Open Transactions › Bank transactions. In the newer menu, it's All apps › Accounting › Bank transactions.
Click Link account ▾, then Upload from file.
Choose the .qbo file you downloaded.
Pick the QuickBooks account to add the transactions to, then confirm.
Open the For review tab. Categorize, add or match each transaction.

Intuit: manually upload transactions

QuickBooks Desktop

QuickBooks Desktop Web Connect · Documentation checked 2026-10-25

Make a backup before you start: File › Back Up Company › Create Local Backup.
Choose File › Utilities › Import › Web Connect Files.
Select the .qbo file you downloaded.
Choose an existing account, or create a new one, when QuickBooks asks.
Review and add the transactions in Bank Feeds.

Intuit: set up and import Bank Feeds

Where to get your QIF file

Show me where to download it

From Quicken for Windows, go to File › File Export › QIF File. Choose the account and the date range you want, then save.

From Microsoft Money, go to File › Export and choose Loose QIF. Export one account at a time and give each file a clear name.

From your bank, look for Download or Export in online banking and pick the QIF or Quicken (QIF) option. Does your bank also offer QuickBooks Web Connect (.qbo)? Download that instead and skip this step. Got a .qfx file? Use our QFX to QBO converter.

What are QIF and QBO files?

What is a QIF file?

A QIF file is an older plain-text transaction format read by GnuCash, Moneydance, Banktivity, Xero and some Quicken accounts. It has no bank transaction IDs. Quicken for Windows restricts QIF imports to supported cash, asset and liability accounts; use QFX for checking, savings and credit cards.

What is a QBO file?

A QBO file is QuickBooks Web Connect, a bank-transaction format used by QuickBooks Online and supported QuickBooks Desktop editions. It is based on OFX and includes Intuit institution details. Transaction IDs help the importer recognise previously imported entries; review matches and duplicates before accepting them.

Convert QIF to QBO because neither QuickBooks Online nor QuickBooks Desktop imports QIF, while both import QBO.

QIF to QBO errors and fixes

Error	Cause	Fix
QuickBooks won't accept your .qif file	QuickBooks Online and QuickBooks Desktop don't import QIF.	Convert it to QBO here, then import the QBO file.
March 4 shows up as April 3	QIF dates don't say whether the month or day comes first.	Change the QIF date format option and check the preview before you download.
"QuickBooks is unable to verify the financial institution information for this download"	The institution is not accepted, the identifiers do not match, or Web Connect services are unavailable for this edition.	Confirm that the selected bank and institution IDs match your own account, and that your software supports that bank's Web Connect service. Correct the details and reconvert; do not substitute an unrelated bank.
The same transactions appear twice	Two QIF exports covered overlapping dates. QIF files carry no IDs that would flag a repeat.	Export ranges that don't overlap. Exclude the extra copies in For review or Bank Feeds.

QIF to QBO converter questions

Limitations

Use the details for the bank that holds your account. A directory listing or an Intuit bank ID does not guarantee acceptance by QuickBooks or Quicken; your edition, subscription and the institution's Web Connect support also matter.

File privacy

File-converter uploads and results are temporarily stored in private storage. Uploads are deleted after a successful conversion; abandoned uploads and results are automatically deleted after about an hour. Download links are temporary.

How to convert a QIF file to QBO

Upload the QIF file.

Confirm the settings.

Review and download.

QIF to QBO converter example

QIF input

QBO output

QIF to QBO field mapping

How to import your converted QIF into QuickBooks

QuickBooks Online

QuickBooks Desktop

Where to get your QIF file

What are QIF and QBO files?

What is a QIF file?

What is a QBO file?

QIF to QBO errors and fixes

QIF to QBO converter questions

Limitations

File privacy

Related converters

CSV QBO

QFX QBO

CSV QIF

QBO IIF

QBO CSV

OFX QFX

Ready to convert your QIF file?