Home Page link  

Input data from Excel

  
Groups | Search | About
User Password
Register Now! Lost Password?

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Input data from Excel A 07-16-2006
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.

Similar ThreadsPosted
Last PST payment shows as input tax credit July 13, 2006, 6:30 am
Cost of Goods Input Accounts Payable Output July 18, 2007, 5:25 pm
Excel to QuickBook August 14, 2008, 1:59 pm
Help with P&L reporting for export to Excel November 15, 2006, 3:09 pm
Memory error - can't export to Excel July 9, 2006, 5:05 pm
Importing journal entries from Excel into QB? June 2, 2007, 12:35 am
How to import my invoices from excel into Quickbooks 2005. September 28, 2007, 1:20 am
Has anyone completely moved from QBooks to Excel for their business? February 14, 2008, 9:22 pm
uploading new data, deleting data August 14, 2006, 1:01 pm
Deleting old data August 1, 2006, 1:42 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap