convert excel file to IIF
How to convert excel file to IIF file...?!!!
Thanks,
70
214
aRSih3q_qr4izzacwZ5xHE
03/01/11 3:09am PST
Viewed by asker 03/02/11 4:43am PST
Viewed by asker 03/02/11 4:43am PST
6 Replies
pvsuppliers
Questions asked: 30
Questions answered: 14054
Points earned: 37729
Questions answered: 14054
Points earned: 37729
Allstar
Advisory council of community power users.
Intuit Moderator
Mod/Co-mod
03/01/11 4:51am PST
go to File > Utilities > Import
If this answers your question, please click on "solved."
Why carry the stick if you're not going to stir the pot?
03/01/11 5:49am PST
Thanks,
But this will not convert the excel file to IIF type...!!!!
BRConsulting
Questions asked: 45
Questions answered: 15678
Points earned: 27627
Questions answered: 15678
Points earned: 27627
Allstar
Advisory council of community power users.
03/01/11 6:54am PST
One way is to use a 3rd party addin, like our IIF Transaction Creator or List Importer, depending on the type of data you have on your Excel worksheet.
If this answers your question, please click the "This Solved My Question" button to let others know!
03/01/11 7:12am PST
Ok, the Excel worksheet is for checks details data... what do think?!! can I import excel file with checks data to QuickBooks ..?!!! or should be an IIF file..?!! and how I can convert the excel file to IIF file..?!!!
thanks.
03/01/11 10:39pm PST
You need to convert it to an IIF file and then you can import it. I recommend the IIF Transaction Creator for this purpose.
03/02/11 4:35am PST
Latest post
I use the IIF Transaction Creator from BigRed; actually I use a lot of their products and they work great. Otherwise you could get the sample IIF files from the Intuit site and try to code the Excel files using those. You cannot import transactions using Excel into QB's without converting it to IIF.
