Turn a bank or credit card CSV into an IIF file that QuickBooks Desktop imports as checks, deposits and credit card charges, posted to the accounts you choose.
Free, no sign-up
Your file never leaves your computer
For QuickBooks Desktop
Converted in your browser. Nothing is uploaded.No file handy?
File:
Check that we read your columns correctly
Tell us about the account
Preview
Date
Description
Amount
How to import the IIF file into QuickBooks Desktop
Back up your company file. QuickBooks can't undo an IIF import.
Go to File, then Utilities, Import, IIF Files.
Select the .iif file you downloaded here. If QuickBooks asks how you want to import it, choose the option that imports the file straight away.
Open the account's register to check the new transactions, then recategorize them from the uncategorized accounts as needed.
QuickBooks Online doesn't import IIF files. For QuickBooks Online, use the CSV to QBO converter.
How the transactions are recorded
Each payment becomes a check, and each deposit becomes a deposit, on the QuickBooks account you name. For a credit card, charges become credit card charges and payments or refunds become credit card refunds.
Every transaction needs a second side in QuickBooks, so payments are balanced against Uncategorized Expense and deposits against Uncategorized Income unless you choose other accounts. After importing, you can recategorize them in the register or with a report.
IIF or QBO?
A QBO file goes through bank feeds, where you review and match each transaction before it's added. An IIF file goes straight into your register as finished transactions. Use IIF for history you've already reviewed, for catch-up work where speed matters, or for QuickBooks Desktop versions that no longer support bank feeds. Use QBO when you want to review and match transactions first.