I export my bank transactions to an *iif file. If I import everything I have
duplicate checks and other information such as "Imported Income" that I have
to change within quickbooks. I'd rather edit the *.iif file and imported a
correct one. I cannot seem to import the corrected file. *iif is not one of
my "save as" options. txt files won't import. Does anyone have a work
around?

Do you have the All files (*.*) option? then you can specify your full
filename xData.iif

PS what is iif?


- -Mark



"pobruce" wrote:

I export my bank transactions to an *iif file. If I import everything I have
duplicate checks and other information such as "Imported Income" that I have
to change within quickbooks. I'd rather edit the *.iif file and imported a
correct one. I cannot seem to import the corrected file. *iif is not one of
my "save as" options. txt files won't import. Does anyone have a work
around?

Actually, my only options seem to be .xls or .txt
IIF stands for Intuit Interchange Format. My bank converts data into that
format for import into Quickbooks, but Excel wants to save any changes as one
of the above. There seem to be utilities that convert xls to iif but I hate
having to go through all those steps.

Thanks for the response.

"exceluserforeman" wrote:

Do you have the All files (*.*) option? then you can specify your full
filename xData.iif

PS what is iif?


- -Mark



"pobruce" wrote:

I export my bank transactions to an *iif file. If I import everything I have
duplicate checks and other information such as "Imported Income" that I have
to change within quickbooks. I'd rather edit the *.iif file and imported a
correct one. I cannot seem to import the corrected file. *iif is not one of
my "save as" options. txt files won't import. Does anyone have a work
around?

Hi,

Option 1: Tell tyour bank to make the file an .xls file

Option 2: Just use Quickbooks and not Excel

Option 3: Send the file to me and I will write a Program to facilitate. You
will have to tell me what you specifically want. Any information received is
not shared with any persons, living or presumed dead. See my Excel Stuff at:

http://www.geocities.com/excelmarksway

email:

- - Mark




"pobruce" wrote:

Actually, my only options seem to be .xls or .txt
IIF stands for Intuit Interchange Format. My bank converts data into that
format for import into Quickbooks, but Excel wants to save any changes as one
of the above. There seem to be utilities that convert xls to iif but I hate
having to go through all those steps.

Thanks for the response.

"exceluserforeman" wrote:

Do you have the All files (*.*) option? then you can specify your full
filename xData.iif

PS what is iif?


- -Mark



"pobruce" wrote:

I export my bank transactions to an *iif file. If I import everything I have
duplicate checks and other information such as "Imported Income" that I have
to change within quickbooks. I'd rather edit the *.iif file and imported a
correct one. I cannot seem to import the corrected file. *iif is not one of
my "save as" options. txt files won't import. Does anyone have a work
around?