Convert QFX to QBO Free for QuickBooks

Your bank gave you a Quicken file, but your books are in QuickBooks. This QFX to QBO converter writes a Web Connect file for supported QuickBooks Desktop editions. Acceptance also depends on your bank's institution details and services.

.ofx / .qfx / .qbo · Up to 10.49 MB

Files are temporarily stored for conversion and automatically deleted after about an hour. No signup or page credits used.

  • Encrypted with AES-256
  • Temporary private storage; automatic deletion
  • Preview before you download

How to convert a QFX file to QBO

  1. 01

    Upload the QFX.

    Upload the bank's QFX download. The converter reads transaction dates, payees, amounts and IDs. You can change the bank details in the next step.

  2. 02

    Pick the bank and account type.

    Under Bank shown in QuickBooks, choose your bank. Set Account type to match the QuickBooks account. Then scan the preview.

  3. 03

    Download and import.

    Save the .qbo file and import it through Web Connect in QuickBooks Desktop. Or upload it to QuickBooks Online.

QFX vs QBO: what changes in the file

The converter keeps the transactions and their IDs while writing a QBO file. The header and date format can change. You can change the bank details before converting.

QFX input

OFXHEADER:100
DATA:OFXSGML
VERSION:102
<OFX>
<SIGNONMSGSRSV1><SONRS>
<FI><ORG>Sample Bank<FID>00000</FI>
<INTU.BID>00000
</SONRS></SIGNONMSGSRSV1>
<BANKMSGSRSV1><STMTTRNRS><STMTRS>
<CURDEF>USD
<BANKACCTFROM><BANKID>000000000<ACCTID>0000000000<ACCTTYPE>CHECKING</BANKACCTFROM>
<BANKTRANLIST><DTSTART>20260401<DTEND>20260430
<STMTTRN><TRNTYPE>CREDIT<DTPOSTED>20260403<TRNAMT>3200.00<FITID>QX0403-01<NAME>Client payment – Acme LLC</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260408<TRNAMT>-59.99<FITID>QX0408-01<NAME>Office Depot</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260415<TRNAMT>-1150.00<FITID>QX0415-01<NAME>Payroll – Sample Payroll Co</STMTTRN>
</BANKTRANLIST>
<LEDGERBAL><BALAMT>9840.01<DTASOF>20260430</LEDGERBAL>
</STMTRS></STMTTRNRS></BANKMSGSRSV1>
</OFX>

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>20261024231310[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>0000000000</ACCTID>
          <ACCTTYPE>CHECKING</ACCTTYPE>
        </BANKACCTFROM>
        <BANKTRANLIST>
          <DTSTART>20260403000000[0:GMT]</DTSTART>
          <DTEND>20260416000000[0:GMT]</DTEND>
          <STMTTRN>
            <TRNTYPE>CREDIT</TRNTYPE>
            <DTPOSTED>20260403120000[0:GMT]</DTPOSTED>
            <TRNAMT>3200.00</TRNAMT>
            <FITID>QX0403-01</FITID>
            <NAME>Client payment – Acme LLC</NAME>
          </STMTTRN>
          <STMTTRN>
            <TRNTYPE>DEBIT</TRNTYPE>
            <DTPOSTED>20260408120000[0:GMT]</DTPOSTED>
            <TRNAMT>-59.99</TRNAMT>
            <FITID>QX0408-01</FITID>
            <NAME>Office Depot</NAME>
          </STMTTRN>
          <STMTTRN>
            <TRNTYPE>DEBIT</TRNTYPE>
            <DTPOSTED>20260415120000[0:GMT]</DTPOSTED>
            <TRNAMT>-1150.00</TRNAMT>
            <FITID>QX0415-01</FITID>
            <NAME>Payroll – Sample Payroll Co</NAME>
          </STMTTRN>
        </BANKTRANLIST>
        <LEDGERBAL>
          <BALAMT>9840.01</BALAMT>
          <DTASOF>20260430235959[0:GMT]</DTASOF>
        </LEDGERBAL>
      </STMTRS>
    </STMTTRNRS>
  </BANKMSGSRSV1>
</OFX>

QFX to QBO field mapping

Transaction values and existing IDs are kept. You can change the bank details in the settings. The header and date format can change.

QFX fieldQBO fieldNote
INTU.BIDINTU.BIDSet from Bank shown in QuickBooks. This is the ID QuickBooks Desktop checks before import.
FI › ORG / FIDFI › ORG / FIDUpdated to match the bank you chose.
BANKACCTFROM (BANKID, ACCTID, ACCTTYPE)BANKACCTFROM, or CCACCTFROM for credit cardsSet by Account type. Account and routing numbers stay as they were.
DTPOSTEDDTPOSTEDUnchanged.
TRNAMTTRNAMTUnchanged. Negative amounts are money out.
NAME / MEMONAME / MEMOUnchanged. NAME is the payee text you see when reviewing in QuickBooks.
FITIDFITIDUnchanged, so QuickBooks can skip transactions it has already imported.
CHECKNUM, TRNTYPECHECKNUM, TRNTYPEUnchanged.
LEDGERBALLEDGERBALUnchanged. The account balance on the date of the download.

Import the QBO file into QuickBooks

QuickBooks Desktop only takes Web Connect files with a .qbo extension, so that's where this file matters most. QuickBooks Online takes it too.

QuickBooks Desktop

QuickBooks Desktop Web Connect · Documentation checked

  1. Back up your company file first: File › Back Up Company › Create Local Backup.
  2. Go to File › Utilities › Import › Web Connect Files.
  3. Select the .qbo file and click Open.
  4. Choose Use an existing QuickBooks account and pick the bank or card account. Pick a new account only if this is its first import.
  5. Click Continue, then review and add the transactions in Bank Feeds.

Intuit: set up and import Bank Feeds

QuickBooks Online

QuickBooks Online · Documentation checked

  1. Go to Transactions › Bank transactions. In the newer menu, it's All apps › Accounting › Bank transactions.
  2. Click the arrow on Link account and choose Upload from file.
  3. Choose the .qbo file and click Continue.
  4. Pick the QuickBooks account the transactions belong to, then confirm.
  5. Review and accept the transactions in the For review tab.

QuickBooks Online also accepts .qfx files. Try uploading the original QFX first. Convert it only if QuickBooks Online rejects it.

Intuit: manually upload transactions

Where your QFX file comes from

Show me where to download it

A QFX file is a download from a bank's website, meant for Quicken. Look for it on the account's transaction or activity page.

  1. Sign in to the bank's site and open the account.
  2. Find Download, Export or a download icon.
  3. Pick the date range.
  4. Choose Quicken (.qfx) or Quicken Web Connect as the format.
  5. Save the file.

Check the format list first. If the bank also offers QuickBooks (.qbo) or QuickBooks Web Connect, download that instead. You won't need to convert anything.

Working from a client's files? Ask for the bank's .qfx download, not their Quicken data file (.qdf). Quicken can't export QFX, so the download has to come from the bank.

What are QFX and QBO files?

What is a QFX file?

A QFX file is Quicken Web Connect, used for bank and credit card downloads. It is based on OFX and adds Intuit institution details. Transaction IDs help identify previously imported entries. Acceptance depends on the institution and your Quicken edition and services.

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.

QFX and QBO hold the same transactions, but QuickBooks Desktop's Web Connect import only accepts .qbo files with a bank ID it recognizes.

QFX to QBO import errors and fixes

ErrorCauseFix
"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 verify message, even with the right bankThe QuickBooks Desktop edition no longer has supported Web Connect services.

Update to a supported QuickBooks Desktop version, then import again.

The file opens in Quicken, or QuickBooks Desktop won't list itYour computer links .qfx to Quicken, and Web Connect in QuickBooks Desktop looks for .qbo.

Convert to QBO, then import with File › Utilities › Import › Web Connect Files.

Some transactions don't appear after importQuickBooks already has those transaction IDs (FITIDs), so it skips them as duplicates.

No fix needed. Check Bank Feeds or the register for the earlier import.

QuickBooks Online won't accept the QFX uploadQuickBooks Online couldn't read the QFX file as uploaded.

Convert to QBO here and upload the .qbo through Upload from file.

QFX to QBO converter FAQ

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.

Ready to convert your QFX file?

Upload a QFX file Have a PDF bank statement? Convert it directly