Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account



Photo

How to import sales invoices into quickbooks

- - - - -

  • Please log in to reply
4 replies to this topic

#1
ideas

ideas

    Advanced Member

  • Member
  • PipPipPip
  • 341 posts
  • Joined 29-January 06
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 by ideas, 17 May 2009 - 12:48 AM.



How to remove advertisement from MSFN

#2
Siginet

Siginet

    Windows XP PowerPacker Creator

  • Member
  • PipPipPipPipPip
  • 739 posts
  • Joined 22-January 05
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. ;)

Posted Image
For those of you interested in my next software venture you can check it out here:
www.ITTechware.com


#3
ideas

ideas

    Advanced Member

  • Member
  • PipPipPip
  • 341 posts
  • Joined 29-January 06
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?

#4
DigeratiPrime

DigeratiPrime

    MSFN Junkie

  • Patrons
  • 3,550 posts
  • Joined 18-August 04
  • OS:Windows 7 x64
  • Country: Country Flag
Considering your example: Export CSV From Excel and Import CSV To Quickbooks?

About importing an Excel or .csv file into QuickBooks
http://support.quick...o_msimport.html

Tools for importing Excel and CSV files
http://support.quick...Article/1005472
Recommended Software: KeePass | Microsoft ICE | VisualWget | Vitamin D Video |

#5
ideas

ideas

    Advanced Member

  • Member
  • PipPipPip
  • 341 posts
  • Joined 29-January 06
thanks, but still no solution yet

Edited by ideas, 26 May 2009 - 02:37 PM.





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users