LedgerBox

Convert QIF to QBO

QuickBooks Desktop stopped reading QIF files for bank accounts. Choose your QIF and download the same transactions as a QBO.

Free, with no account. LedgerBox pays for it because the people who need it often have a PDF statement too, and reading those is what LedgerBox sells.

QIF to QBO

Step 1 of 3

The file is read and rewritten in your browser. Nothing is uploaded and nothing is stored.

How the conversion works

  1. Choose your QIF file

    Quicken's own date format is read, including the space-padded days and the apostrophe before a two-digit year.

  2. Check what was read

    The converter shows the row count and the first rows, with the account type it took from the QIF section header.

  3. Download the QBO

    Import it into QuickBooks Desktop through File, Utilities, Import, Web Connect Files.

What a QBO file is

QIF is Quicken's older format: a section header, then one block of single-letter fields per transaction. It carries no account block, no statement period, and no closing balance, which is why QuickBooks moved to Web Connect.

The converter builds the account block QBO needs and takes the statement period from the first and last transaction dates. The section header decides whether the file is written as a bank account or a credit card, because the same amounts mean opposite things under the two.

What the conversion keeps

A QBO file has a place for some of what a QIF file holds and not for the rest. Both lists come from the two formats, so neither can claim something the file cannot say.

Carried across

  • The transaction date
  • The amount, with its sign
  • The description or payee
  • The check number
  • Whether the account is a bank or a credit card

Dropped

Nothing. Everything the source file states has a place in the output.

QIF to QBO questions

Is my file uploaded anywhere?

No. The file is read and rewritten in your browser. Nothing is uploaded and nothing is stored. You can turn off your network connection and the converter still works.

What happens to the categories in my QIF?

Categories are dropped. A QBO file has no category field, and QuickBooks assigns categories on the way in from its own rules.

Can I convert a PDF bank statement here?

No. This tool reads data files, not documents. LedgerBox reads PDF and photographed statements and writes the same output formats.

Do I need an account?

No. There is no account, no email field, and no limit on how many files you convert.

The converter reads data files. LedgerBox reads the statement itself.

Upload a PDF or a photo of a statement and download the rows. No card required.

Convert a statement