1. Home
  2. QuickBooks Discussions
  3. import excel transactions file

import excel transactions file

I'm trying to import transactions into Quickbooks 2005 pro using an excel .xls file created by another program.

My problem starts when Quickbooks ask me to create a mapping but only give the options of list, vendor, customer, and account. None of which work for a transactions report.

Is there a way this can be done without converting the file to a different format or purchasing additional 3rd party software?

Any samples would be appricated.

Thanks a bunch Dianne

removeqb for current email address snipped-for-privacy@pcsonline.com

Reply to
Dianne Ice
Loading thread data ...

As you noted, mapping for Excel (xls) files is only for vendor, customer, and account and maybe one more list type.

Transactions can be imported in the IIF format (see QB help). You can use Excel to format the data but you need to save the Excel workbook as a tab delimited text file before importing it into QB.

Also, transactions can be imported in the XML format. See

formatting link

There are third party products that can convert xls files to IIF or XML for you.

Reply to
Karl Irvin

According to both "The Official Guide for Premier Edition Users" (2005, lousy documentation with the package) and "Running QuickBooks 2005 Premier Editions" (by Kathy Ivens, recommended), all sorts of lists can be imported from Excel, but no transactions. Ms Ivens wrote the Intuit book for the Pro Edition. I can only hope that it is as good as the book she wrote for CPA911.

Reply to
Kent Finnell

Excel mapping import is only available for Customer, Vendor, Item and Account.

Reply to
Karl Irvin

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.