QuickBooks does have some limits in the import area. This is a partial list of limitations:
- QuickBooks will import most transaction types, but not all. Paychecks & Sales Orders are two transaction types that can’t be imported.
- For those using Advanced Inventory, QuickBooks does not support Advanced Inventory fields for import, but also requires them to be filled out on transactions. To import you need to first turn off Advanced Inventory, then import, then turn it back on.
- QuickBooks won’t import custom fields on transactions.
- QuickBooks will import transactions using your home currency only.
- For Employee records, only basic information such as Name and Address and a few other fields common to other types of names can be imported.
- For Lists, such as Items, Customer, & Vendors, some lesser used and newer fields are not supported. These fields include credit card fields for names and units of measure, the MPN, and location information for items.
QuickBooks can import most data using IIF files. Different types of IIF files can be created using our tools.
QuickBooks will import most types of Transactions, most types of List records, and also Budgets and other data.
It can also import and export memorized reports, but not using IIF files. Instead, you can export these reports directly from the Memorized reports list using Premier and Enterprise versions (most recent versions.)
It can import and export Custom Templates for sales transactions (Invoices, Credit Memos, …) from the Templates list. (We’re not sure if Premier and above is required for this.)
IIF stands for Intuit Interchange Format, a file format for importing data into financial software. QuickBooks will export IIF files that contain lists & will import IIF files that contain both lists & transactions. The format is daunting for many non-programmer types. Several of our tools make it easier, including the IIF Transaction Creator, the List Importer, and the Transaction Copier.
QuickBooks doesn’t support my bank or credit card for online banking. How can I import my Online Banking data into QuickBooks?
The IIF Transaction Creator can use CSV and other text files opened in Excel. It will help you convert these files to IIF files for import into QuickBooks. This is a good way to imported banking or credit card transactions where you don’t enter them as you go. They’re imported directly into your register.
The QIF to OFX Converter will import QIF files or use worksheet data downloaded from your bank. It will create OFX, QFX, and QBO files you can import into the online banking center in QuickBooks or Quicken. This is useful is you enter most transactions as you go, and want to reconcile them against the bank’s data.
Yes. Opening balances for lists are created by importing transactions in combination with lists. For import, this means both a new list item & an accompanying transaction must be imported.
Setting this up manually is rather cumbersome, though it’s easy when using our List Importer where all you have to do is specify the opening balance amount for each account or name and the rest is taken care of.
No, it does not include built- in export for transactions. However, QuickBooks does expose its data to 3rd party tools and that can be used to create IIF files with transactions. Then those files can be imported into another QuickBooks file. Our Transaction Copier takes advantage of this capability and so allows you to copy transactions from one QuickBooks file to another.
Yes! QuickBooks can import transactions using the IIF file standard. Generally, this can be quite complicated to setup and is considered ‘programming’ by Intuit, and they don’t support questions about IIF. Several of our addins can help with this task, allowing you to convert simple spreadsheets into IIF files.
List items include Accounts, Customers, Vendors, Sales Items, and so on.
Transactions use list items as well as currency amounts to track financial activity involving money. Transactions include things like Invoices, Checks, and Bills.