Import Your Data into QuickBooks


Import Overview

At this point, you have converted your bank account or credit card transactions into QuickBooks format. The last step is to import that data into QuickBooks. It's super quick and easy to do.

In summary:

  • Start QuickBooks
  • Backup your data
  • Select the file to import

Step-by-Step Instructions

Step 1 - Start Quickbooks

  • Start QuickBooks and open your company file

Step 2 - Backup Your Company File

It's a good idea to regularly backup your company data file, just in case. Assuming you have already told QuickBooks how to backup your data, do this:

  • Select BACKUP COPY
  • Click FINISH
Backup your data

Step 3 - Import your data

  • Select FILE > UTILITIES > IMPORT > IIF Files...
  • QuickBooks import utility
  • Navigate to the folder with your downloaded credit card statement and select the .IIF file (or, select the file and click OPEN). Your data will immediately be imported and you'll see this message:
  • QuickBooks import complete

    Click OK.

  • TIP: You can actually watch the magic of your transactions being posted as they are imported. Before doing this Step 3, just open your bank or credit card account (from the Chart of Accounts list, double-click the account to open the register) and size the window to, say, half of your screen. When you import the IIF file, you'll see the transactions being added one by one. It's nice to see all that data being entered without you having to type it!
  • TIP: If you receive any error messages, check here for solutions: HELP/CONTACT

After importing successfully, the .IIF file is no longer needed. You may delete it or you might want to move it to another folder so that you do not accidentally import it again (for example, move your imported files to a folder named Has been imported into QB). Note that QuickBooks has no way to know if an .IIF file has already been imported -- it will import again if you tell it to.

What to do next

You’re done! You can now use QuickBooks to view the imported transactions, reconcile the credit card or bank account, view reports, etc.

Go back to: Convert Your Statements

Return to: Main Page