Excel to IIF Conversion
How do I convert bank transactions in CSV/Excell to IIF without having to buy the software. I only have 300 transactions to convert in order to capture transactions that weren't accounted for this year.
70
294
aDVapMiLer4kAbacfA8pyY
01/17/11 7:48am PST
Viewed by asker 01/18/11 5:09am PST
Viewed by asker 01/18/11 5:09am PST
3 Replies
BRConsulting
Questions asked: 45
Questions answered: 15612
Points earned: 27495
Questions answered: 15612
Points earned: 27495
Allstar
Advisory council of community power users.
01/17/11 8:34am PST
You'd have to learn the IIF file format and save the worksheet as an IIF file in that format.
If this answers your question, please click the "This Solved My Question" button to let others know!
01/17/11 3:40pm PST
How can I do that? Everything I've seen shows date, name, amount, and memo.
01/17/11 5:39pm PST
Latest post
There's an IIF toolkit on the Quickbooks support site, though I don't have the link. That's probably a good place to start.
You could also download our IIF Transaction Creator in trial mode and review the IIF files it creates from your data and copy those files.
