To import the IIF file click File - Utilities - Import - IIF Files. The Converter takes your data, as you provide, and formats an IIF file, what Quickbooks expects. It means that you provide data and Quickbooks will import it. IIF considered the low-level format of the system. If expense accounts are missing, then Quickbooks will create them. So if your Vendor records are missing or they are not matching with what you have, then Quickbooks will create new Vendor records. Now we are going to switch to Quickbooks and check Chart of Accounts, which is a Checking Account, it does exist and if it doesn't exist when you're importing the IIF file - Quickbooks will create everything, that is missing. We will click 'Convert' and create a sample.iif file. The CSV file from a bank is usually will have the category missing, and you need to open a file in Excel and add the category column, enter doc expense, income Account Name and done convert. So you set the Account Name, which you have in Quickbooks, not Account Number. But usually, when you download from your bank, the CSV file is for a specific account. To create complete IIF files, your CSV file must have a category column, because an IIF file requires two accounts for each transaction.įor one account that is Bank or Credit Card Account Name, you can also specify a separate column, called Account Name, and Map this column in the Mapping. If this is a Credit Card file with amounts (like expenses are positive, and payments to the account are negative), you can use 'change +/-' to reverse amounts. You can set the date format, and the year if it is missing. If needed, on the left sidebar, there are some controls to set, to tell the Converter how your CSV file is formatted. We need to set the Account Name, that will be used for an IIF file in the right-side panel, as a Checking Account Name. All transactions are for the Checking account. The Converter recognizes this file automatically, so there is no need to remap this file.

It has the Payee name column, which matching Vendor names in QuickbooksĪnd there is a Check column with an optional check number. It has the category, which provides expense (or income) account names The CSV file has four transactions with properly marked column names:

Quickbooks import excel and csv toolkit