Input data from Excel

Posted by A on July 16, 2006, 3:07 pm

Please log in for more thread options

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,

A

Posted by Larry Stinson on July 17, 2006, 10:17 am

Please log in for more thread options

You 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.
www.geocities.com/llstinson
Specializing in affordable custom applications for QuickBooks

> 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,

> A

Posted by Karl Irvin on July 17, 2006, 10:33 am

Please log in for more thread options

> 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.

See www.bigredconsulting.com for programs that convert Excel files to the
IIF format that can be imported into QB.

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 www.q2q.us

Posted by A on July 25, 2006, 1:57 am

Please log in for more thread options

>> 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.

> See www.bigredconsulting.com for programs that convert Excel files to

> the IIF format that can be imported into QB.

> 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

> www.q2q.us

thanks for the suggestions Karl and Larry.