Setup Wizard - Accounting Options

This article pertains to the Store Setup Wizard introduced in the Order Manager version 5.804.

There are two pages in the Accounting Options section of the Setup Wizard:

• FIFO Cost-of-Goods Tracking

• Using the Order Manager with Quick Books

FIFO Cost-of-Goods Tracking

First In First Out (FIFO) cost tracking is used to accurately track the cost of goods sold on a first-in, first-out basis. If you use FIFO cost tracking, the program tracks all incoming and outgoing inventory and its cost.

To use the FIFO feature:

1. Check the box beside Track your Cost of Goods on a FIFO basis.

Note: Checking this box is the equivalent of setting the TrackInventoryFIFO system parameter (in the Program group) to True.

2. Click the Initialize FIFO button.

3. On the Initialize Inventory FIFO Data screen select one of two options:

   1. Click From current Quantity on Hand and Supplier Costs, and then click the Initialize Data button.

• 2. Click the From data imported from an Access database. Browse to find the database and then select the table that contains the inventory data you wish to import from the drop down list. Select the fields in the external table that correspond to the Order Manager fields from the drop down lists. Refer to the sample records in the window below if necessary. Click Begin Import.

See the article Initialize FIFO Data for more information.

Using the Order Manager with QuickBooks

If are not using QuickBooks with the Order Manager, then you can skip this page of the Setup Wizard.

If you do want to export data from the Order Manager to QuickBooks, there are a number of steps that must be completed. It is recommended that you work with your accountant to complete the setup process. Following is a general outline:

1. Click the Print a list of required QuickBooks Accounts button on the Setup Wizard. The two-page document lists all the accounts you must first setup in QuickBooks before setting up the integration with the Order Manager.

2. Next, click the QuickBooks Setup button and read the Accounting Interface Notice screen. Before you can access the Account Export setup screen, you must enter your name and email address, and send a confirmation email that you have read the Warning disclosure.

3. Read the Knowledge Base article, Accounting Export Setup, to guide you through the process of setting up the Order Manager to export data to QuickBooks.

4. Read the Knowledge Base article, QuickBooks Export, as a guide when you first export data from the Order Manager to QuickBooks.

When you are finished with this page, click the next arrow at the bottom of the screen to proceed to the next section.

Setup Wizard Articles

The following articles will help you navigate the Order Manager Setup Wizard. If you're just beginning the Setup Wizard, follow the articles in order. Otherwise, click a link below to jump to that section:

• Users & Security

• Order Processing

• Sales Tax

• Products & Inventory

• Shopping Carts

• Payment/Credit Cards

• Shipping

• Packing

• Printing & Report Options

• Email

• Manual Orders

• Multi Order Processor

• Drop Shipping

• Order Status System

• Import Products, etc.

• Accounting Options

• Miscellaneous

Created 2/17/09

Updated 6/26/09