QuickBooks Import WizardHelp Version: 2.12
Last Update: 08/04/2004
Before you can process orders into QuickBooks, you have to setup a couple of things in your QuickBooks database.
In order for QuickBooks to accept a shipping method you defined on your website, you must also have a "Shipping" item in QuickBooks. Simply add a new item in the item list as "Shipping" with a price of "0.00". The price used will come from your website when the shipping item is added to the Invoice or Sales Receipt. This item is usually setup as an "Other Income" type and uses the "Freight Income" account.
You also need to have the Shipping Methods used on your website in your "Ship Via" list in QuickBooks. However, we test for these and add them automatically if they do not already exist. So you really don't need to be concerned with this other than knowing the fact that each time an order comes in with a shipping method that is not listed in the Ship Via list, it will be added automatically. Note: QuickBooks limits this field to 15 characters so some of your Shipping Method entries from your website may be cut off when they are added to the list.
Sales Tax Items
You also need to have a "sales tax item" for the state(s) (or counties if those are used on the website) where you are collecting sales tax. So, if you collect sales tax in VA as an example, you need an item in your item list with the name "VA" and the item type should be a "Sales Tax Item". The account you use for this item depends on your setup in QuickBooks. You should also set the price for this item as the matching percentage that you have in your QuikStore qs_main.cgi file on the web server.
Discount Items (optional)
If you want to use coupons on your website and have the discounts passed through to the invoice or sales receipt, you will also need to setup items for those. The item name is the coupon name (or number) you used in your discount logic. The item type should be a "Discount". The account you use for this item depends on your setup in QuickBooks. Again, you should also set the price for this item as the matching percentage or fixed price that you have in your QuikStore qs_main.cgi file on the web server in your discount logic.
Note: This discount item MUST be set as taxable for the calculations to come out correctly.
Sales Reps (optional)
If you are using affiliates on your site, and want the affiliate name to be passed into QuickBooks, you need to add a Sales Rep for each affiliate. When the order is processed, the affiliate id will go into the "Initials" for the Sales Rep. So, when you create the Sales Rep, make sure to set the initials the same as the affiliate id you use in QuikStore or it will not save it correctly. If it does not find an exact match, it just disregards it.
Copyright © 1997-2004 iSoft-Solutions, Inc