How to import sales invoices into quickbooks

[ideas]

i have some 3000 sales invoice which i have in excel format and need to import them into quickbooks, is there a freeware or a script or any free easy way to do this?

here is how i have as the headings ( a sample of the file )

Type ~ ~ Date ~ ~ ~ ~ Num ~ Name ~ Item ~ Qty ~ U/M ~ Sales Price ~ Amount ~ Balance

Invoice ~ 01/29/2009 ~ 6997 ~ Lows ~ Egg ~ 10.00 ~ ea ~ ~ 120.00 ~ ~ ~ 1,200.00 ~ 0.00

Edited May 17, 2009 by ideas

[Siginet]

You can make a script in autoit to do this. I have done something simular in the past for importing Enterprise Quickbooks info into Quickbooks pro. It takes time to make the script but when it is done it is worth all of the effort.

[ideas]

wow, thanks for the idea but i dont know how to make a script with autoit, is it possible you can show me how or point me where i can find this?

[DigeratiPrime]

Considering your example: Export CSV From Excel and Import CSV To Quickbooks?

About importing an Excel or .csv file into QuickBooks

http://support.quickbooks.intuit.com/Suppo...o_msimport.html

Tools for importing Excel and CSV files

http://support.quickbooks.intuit.com/suppo...Article/1005472

[ideas]

thanks, but still no solution yet

Edited May 26, 2009 by ideas