LedgerPort

QIF to QBO converter

Move transactions from a QIF file into QuickBooks by converting them to a QBO Web Connect file. The file is converted in your browser and never uploaded.

Your file is read on this device. It is never uploaded.

Enter your licence key

The key is on the page you saw after paying, and on your invoice.

  1. Add your QIF file Drop it on the box above or click to choose it.
  2. Check the preview Confirm the dates, payees and amounts look right.
  3. Download Save the QBO file and import it into QuickBooks.

From QIF to QuickBooks

QuickBooks does not import QIF. Converting to QBO lets the transactions arrive through bank feeds, where you can match and categorise them. Bank, cash and credit card registers in the QIF file are read; investment registers and category lists are left out.

QIF files carry no transaction IDs, so the converter creates one for each transaction from its date, amount and payee. The same file always gives the same IDs.

Importing the QBO file

QuickBooks Desktop: choose File → Utilities → Import → Web Connect Files, select the file, and pick the account. QuickBooks Online: go to Transactions → Bank transactions, open the menu next to Link account, and choose Upload from file. The import guide has the full steps, and there is a page on fixing import errors.

Questions and answers

Are QIF categories carried over?

No. A QBO file has no field for categories; you assign accounts in QuickBooks when you review the transactions.

The dates came out wrong. Why?

QIF does not say whether dates are month-first or day-first. The converter works it out when it can; otherwise set Day and month order yourself and check the preview.

Is my file uploaded?

No. The file is read and converted by this page on your own device. It works with your internet connection switched off.

Is it free?

Your first 10 documents are free, whatever their size, with no card and no licence key. After that, plans start at $9. See pricing.