Is there anyway for me to enter orders into an excel spreadsheet and then import those orders into Quickbooks from the excel sheet?
This would allow mutiple sales reps to send in their excel sheets of the sales they made, which would then be imported into quickbooks, invoices printed and orders shipped.
Thx,
AYou talk about importing orders, but since the Excel spreadsheets submitted by your reps detail the sales they already made, I would create invoices in QuickBooks instead of orders.
You can make a few modifications to the submitted Excel file and save it as a delimited text file (Intuit refers to these import files as ".iif" files). Then you can import the information directly into your QuickBooks company file.
You need to search Intuit's web site for ".iif" (without the quotes) and get an example of an invoice .iif file. It is simply a delimited text file (delimited with a "tab" if memory serves) with a certain layout with additional header lines defining the layout and a footer line defining the end of the file.
Or, if you would prefer to go the easier route, we could create an affordable utility for you that automatically reads the Excel spreadsheets and creates the invoices in your QuickBooks file. If you are interested, contact us for a free, no obligation quote. I think you will be pleasantly surprised at our prices.
Larry Stinson Stinson Solutions Inc.
See
If needed, you could put a copy of QB on the salesmens computers and then transfer from QB to QB using the Data Transfer Utility at
"Karl Irvin" wrote in news:5LCdnUtBs8IhAibZnZ2dnUVZ snipped-for-privacy@comcast.com:
thanks for the suggestions Karl and Larry.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.