import excel transactions file

Aug 18, 2005 3 Replies
D

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


Vote
Twitter Facebook LinkedIn
K

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.

Vote
Twitter Facebook LinkedIn
K

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.

Vote
Twitter Facebook LinkedIn
K

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

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required