One of the most common questions that we are asked every day is what sorts of files can be imported into QuickBooks Desktop company files (Pro, Premier and Enterprise Editions). Below is a listing of all the different file formats that will work with Transaction Pro Importer for QuickBooks:
- Excel files (all formats are supported going back to Office 1997 and including Office 2016 and Office 365)
- CSV files (also known as comma separated value)
- Txt files (comma, pipe and tab delimited files are all supported)
- Quicken Files (they have a qif file extension and are used to import bank statement activity)
- Microsoft Money Files (they have a ofx file extension and are used to import bank statement activity)
- Microsoft Access Databases
- ODBC compliant databases such as SQL
Below are some points to consider…
Does my import file require a header row?
Many files have a descriptive title at the top of each column of data which will make it easier to select the correct import file column from the Transaction Pro Importer mapping screen. However, a header row is not required in your import file. You can tell Transaction Pro Importer if your import file had a header row but selecting the checkbox next to File has field names in first row on the File Contents screen (see below).
Do I have to use a pre-defined header row in my import file?
No need to use any templates you can use whatever data in your header row and Transaction Pro Importer will only import the columns that you map to. In other words you can have an unlimited number of columns in your import file and the columns can be in any order. However, if you do decide to use our sample import files which you can find in the documents directory after installing Transaction Pro Importer, you will not do do any mapping you will just select the Field Match button at the bottom of the Transaction Pro Importer mapping screen (see below).
How do I import multi-lined transactions?
In your import file you will repeat the transaction id and customer/vendor information on each line of the order and then you will show different items or expense information on each line. An example is displayed below which shows the invoice number and customer being repeated on lines two through six in your import file. In columns D through G you will see five different line items. So Transaction Pro Importer will create one invoice for Main St Bank with five line items on it.
If you have a file that does not meet all of these requirements you have additional options below:
- e-Commerce type files: For sales transactions if your items are in columns you can enable our e-Commerce options which gives you additional fields to map to. Read more here.
- Check or Bills imports using expense accounts: If you are importing bills or checks and your expense account are in columns read more on how to add additional mapping fields here.
What if I still have questions?
- You can request a free fully functioning trial here and do an import with your own import file.
- Review this forum article.
- Send a sample import file to firstname.lastname@example.org
We hope this helps any questions please let us know.