ideas Posted May 17, 2009 Share Posted May 17, 2009 (edited) 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 ~ BalanceInvoice ~ 01/29/2009 ~ 6997 ~ Lows ~ Egg ~ 10.00 ~ ea ~ ~ 120.00 ~ ~ ~ 1,200.00 ~ 0.00 Edited May 17, 2009 by ideas Link to comment Share on other sites More sharing options...
Siginet Posted May 18, 2009 Share Posted May 18, 2009 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. Link to comment Share on other sites More sharing options...
ideas Posted May 21, 2009 Author Share Posted May 21, 2009 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? Link to comment Share on other sites More sharing options...
DigeratiPrime Posted May 23, 2009 Share Posted May 23, 2009 Considering your example: Export CSV From Excel and Import CSV To Quickbooks?About importing an Excel or .csv file into QuickBookshttp://support.quickbooks.intuit.com/Suppo...o_msimport.htmlTools for importing Excel and CSV fileshttp://support.quickbooks.intuit.com/suppo...Article/1005472 Link to comment Share on other sites More sharing options...
ideas Posted May 26, 2009 Author Share Posted May 26, 2009 (edited) thanks, but still no solution yet Edited May 26, 2009 by ideas Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now