BizWizard Back Office Logo
 

NOTE: Watch the Below Video Tutorial by clicking on the play button in the center of the screen

BizWizard Order Manager™ is extremely easy to get started using. After installing, there are a few steps that we must go through to ensure your company is setup correctly with where the BizWizard Order Manager™ database will reside on your hard drive or networked hard drive, creating sales tax tables so BizWizard Order Manager™ will know how to charge sales tax on orders, and lastly, some basic options in System Configuration to get you going on how you wish to handle certain scenarios that will come up while taking orders.

Desktop Icon Example ImageLet's delve right in and begin. After you have installed BizWizard Order Manager, double click the BizWizard Order Manager™ Icon on your desktop. the BizWizard Order Manager™ Icon is a blue circle as shown in the example to the right.

BizWizard Order Manager™ will auto-configure and setup the first time. It may take a few seconds to complete this auto-configuration. Once it has completed, you will be presented with the following screen with a blue background and two menus in the top menu bar.

Simply Click on the BizWizard Order Manager™ Menu and Select "New Database" to create a new Database. See example below:

 

Create New Database Example Screenshot

Next we will decide where we want to store our database. It is important to create your database in a folder that is accessible by all computers in your network that will be using BizWizard Order Manager. This can be on a network share location, or on your local computer so long as your computer is a network share location. We recommend you create your database in a folder named "BizWizard Database" and leave the default file name as "BizWizard-Database.accdb" - This will help our technical support representatives assist you better if you have not renamed the database file.

Create New Database Example Screenshot

Next you will see the Load Database screen as shown below. BizWizard is loading and connecting to the various data tables necessary to run BizWizard Order Manager. Simply wait the few seconds necessary for this process to complete.

Load Database Example Screenshot

After the loading of the database is completed, you will be at the login screen. The default Associate Name and Password to login for the first time are as follows:

Associate Name: System Default
Password: 1234

After we login the first time using the above criteria, we will change this user. It is important for the security of your data to change this user because the password for this user is posted in our users manual and on our forums and is widely known. After we change the User, and its associated password, then your system is secure from other employees at your company from accessing portions of BizWizard Order Manager™ that they shouldn't be accessing.

NOTE: If BizWizard detects the Associate Name of System Default is selected, it will auto-populate the password for you to the password of 1234. Once you select System Default form the pull-down list you will note the password field has four asterisks (e.g. ****) Don't be alarmed by this. This will only occur if the user selected is System Default.

Login Example Screenshot

Now Lets perform our second task of changing the System Default User. But before we do, lets talk about the System Default user. The System Default user is a super-user. It has full access and authority to make any change in BizWizard Order Manager. When we modify this user, it is imperative you do not modify the security settings. there must always be at least one user with full system authority. If you change the user to remove some authorities you may not be able to get back into setup any new users.

So all we are going to do at this point is change the System Default User to be your name, and then you will pick a password that you will remember. To accomplish this, click on the Associates Menu in the menu bar and select "All Associates" See Example below

Work with All Associates Example Screenshot

Now we will be able to maintain the associate named "System Default" Double Click the Yellow Background Text area of for System Default User to maintain the System Default Associate. See example below:

Work with Associate Example Screenshot

Now we are going to change two values on the Maintain Associate Screen. Change the Associate Name to your name. For our Example, we are changing it from "System Default" to M. David Matney. Next change the password to a password you will remember. Notice, as you type the password what you will see is asterisks, and not what you actually typed. For this reason, create your password carefully. Once you have changed the associate name to your name and set the password, click on Done to exit this screen and save your changes.

Change Associate Name and Password Example Screenshot

The next thing we must do is set the sales tax tables so BizWizard Order Manager™ will know how to charge sales tax and for what rates. Before going into details on how to do this, lets navigate to the System Setup Screen through the configuration menu. To do this, perform the following steps:

  1. Click on the "Configuration" menu in the menu bar to expand the menu
  2. Select "System Setup" from the configuration Menu

Now, we can manage various aspects the control how BizWizard functions and operates. From the General System Setup Screen, click on the "Sales Tax Setup" tab as shown in the example below:

Sales Tax Setup Tab Example Screenshot

Now there are a couple of questions you must ask yourself as follows:

  1. Does my state require we charge sales tax on shipping charges?
  2. Do I wish to report my sales tax based upon when the invoice balance is $0.00 or when the invoice is created?

BizWizard Order Manager™ will need to know if your state/province requires you to charge sales tax on the shipping charge portion of the order, and it also needs to know whether you would like to report the sales tax based upon when the invoice balance is $0.00 or when the invoices is billed. Here is the difference between the two sales tax reporting methods:

  • When Invoice is Billed
    User this reporting method to report sales tax on your sales tax summarization report, even if you have not collected payment in full.

  • When Invoice Balance is Zero
    Use this reporting method to only report sales tax once the invoice has been paid in full. If an invoice remains with an outstanding balance, then it will never appear on your sales tax reports and thus will never be reported.

Simply Select from the Pull-Down list the sales tax reporting method you wish to utilize. Also check mark the box for Shipping Subject to Sales Tax? only if your state requires you to charge sales tax on the shipping portion of the order.

Sales Tax Reporting Method and Shipping subject to Sales Tax Example Screenshot

Next, we are going to create a Sales Tax table to let BizWizard know when to charge for sales tax and what percentages. Click on Add New to create a new sales tax setup as shown in the example below:

Add New Sales Tax Table Example Screenshot

BizWizard Order Manager™ Charges sales tax based upon what is called a Sales Tax Nexus. A Sales Tax Nexus is a geographic location for which your company is required by law to collect sales tax. For instance, in the state of Nevada businesses are required to charge sales tax for all tangible products delivered to any location within the geographic boundaries of the state.

To determine geographic boundaries, we use postal codes. There are several ways you can create your sales tax tables, depending upon the reporting requirements of your state. For instance, in the state of Nevada, businesses are required to collect the sales tax rates for each county at the rate of the county based upon products delivered into that county. Even if your company is located in one county, if you ship products to another county, in the state of Nevada, you are required to collect sales tax for the county for which the product is delivered or shipped to.

So in the state of Nevada a sales tax table setup is a little bit complicated. See the following screen shot and then read further for an explanation:

Sales Tax Breakdown for Nevada Example Screenshot

As you can see in the above example, Carson City County has 4 groupings of postal codes, and sales tax rates for Carson City County is 7.125%. We must enter the Starting and Ending postal Code for each zone and the sales tax percentage. At the top under Individual Sales Tax Descriptions, you have 4 columns you can create. In our example, we only needed one column named "Sales Tax"

If your states sales tax requirements are more complicated and you must split the sales tax into State, County, City rates, then you can create the first column as "State" and the second Column as County, and third column as City. Each percentage breakdown can then be initialized. For instance, maybe the State Sales Tax is 5.125%, the County Sales Tax is 1.5%, and the City Sales Tax is 1.0%, the following example shows how we would put this in for Carson City County

Sales Tax Broken by State, County and City Example Screenshot

In the above example, the sales tax is broken down by state percentage, county percentage and city percentage. On a customers order it will only show the total sales tax percentage of state + county + city. However on your sales tax report, the amounts of what was collected for each geographic region will be broken down.

One important item to remember when creating your sales tax table is how BizWizard uses the sales tax tables to determine what sales tax to charge. If you have postal codes that cross on multiple lines. Meaning you have double entered postal codes, BizWizard will use the first matching sales tax record and stop looking.

Another important item to remember is that each sales tax setup is date/time stamped and based upon the date/time the order was entered into BizWizard Order Manager, the sales tax table that will be used is the one active at the time of first entry. The effective date at the top of the maintain sales tax rates window is compared to the date entered on the order to determine which sales tax table setup should be used.

This is beneficial as follows. Lets assume you get a notice from your state sales tax board that indicates a 1% increase in sales tax effective January 1, 2011. You can easily enter the new sales tax rates six month earlier then the rates go into effect, and simply set the effective date to be 1/1/2011 00:00:00 AM. Once that date and time rolls around, BizWizard will automatically start using the new sales tax rates.

So you can get as complicated or as simple with sales tax tables as is necessary based upon your states reporting requirements. Either Way, one thing you will need to know are the postal codes that are applicable for your sales tax nexus. You should be able to contact your state sales tax board to obtain the postal code breakdowns for the various counties and cities if applicable for your state filing requirements should you state need such a break down.

The following are the postal code ranges applicable for state/provinces:

United States
State Code Beginning Zip Code Ending Zip Code
AK 99501 99950
AL 35004 36925
AR 71601 72959
AZ 85001 86556
CA 90001 96162
CO 80001 81658
CT 06001 06928
DC 20001 56972
DE 19701 19980
FL 32003 34997
GA 30002 39901
HI 96701 96898
IA 50001 52809
ID 83201 83877
IL 60001 62999
IN 46001 47997
KS 66002 67954
KY 40003 42788
LA 70001 71497
MA 01001 05544
MD 20601 21930
ME 03901 04992
MI 48001 49971
MN 55001 56763
MO 63001 65899
MS 38601 39776
MT 59001 59937
NC 27006 28909
ND 58001 58856
NE 68001 69367
NH 03031 03897
NJ 07001 08989
NM 87001 88439
NV 88901 89883
NY 00501 14925
OH 43001 45999
OK 73001 74966
OR 97001 97920
PA 15001 19640
PR 00601 00988
RI 02801 02940
SC 29001 29945
SD 57001 57799
TN 37010 38589
TX 73301 88595
UT 84001 84791
VA 20101 24658
VI 00801 00851
VT 05001 05907
WA 98001 99403
WI 53001 54990
WV 24701 26886
Canada
Province Code Beginning Postal Code Ending Postal Code
AB T0A 0A0 T9X 2C1
BC V0A 1A0 V9Y 9G3
MB R0A 0C0 R9A 1V1
NB E1A 0A2 E9H 2C8
NL A0A 1A0 A8A 3P7
NS B0C 1C0 B9A 3V6
NT X0E 0A0 X1A 3Z6
NU X0A 0A0 X0C 0J0
ON K0A 1A0 P9N 4T1
PE C0A 1A0 C1N 6W2
QC G0A 1A0 K1A 1L4
SK J7W 0A2 S9X 2A1
YT Y0A 1B0 Y1A 7A3

Now that you have your sales tax tables setup, you are ready to begin using BizWizard.

[This Concludes The Introduction]

 
 
NetSoftStudio Logo
© Copyright 1999-2012 by NetSoft Studio. All Rights Reserved.
Unauthorized use or duplication strictly prohibited.