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.
Let'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:
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.
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.
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.
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
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:
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.
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:
Click on the "Configuration" menu in the menu bar to expand the menu
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:
Now there are a couple of questions you must ask yourself as follows:
Does my state require we charge sales tax on shipping charges?
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.
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:
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:
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
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.