Changes for British Columbia Florists

From FloristWiki

Current revision

Creating New Tax Codes for British Columbia, Nova Scotia, and Ontario

Tax Code Screen in Mercury Administration

To create new tax codes for British Columbia, Nova Scotia, and Ontario:

1. Launch Mercury Administration by double-clicking on the Mercury Administration icon on the desktop.
2. In the System Login window, enter your login name and password and then click Login.
3. Double-click Mercury Administration in the explorer pane.
4. Double-click the Accounting folder.
5. Double-click Tax Code. The Tax Code screen opens.
6. Create the new tax code for British Columbia:
   1. In the Description column in the blank row at the bottom of the Tax Code list, enter HST-BC.
   2. In the first Sales Tax column (most likely called GST/HST or Federal Tax), enter the HST tax rate for British Columbia.
   3. In the Tax Code column, enter HST-BC.
7. Create the new tax code for Nova Scotia:
   1. In the Description column in the blank row at the bottom of the Tax Code list, enter HST-NS.
   2. In the first Sales Tax column, enter the HST tax rate for Nova Scotia.
   3. In the Tax Code column, enter HST-NS.
8. Create the new tax code for Ontario:
   1. In the Description column in the blank row at the bottom of the Tax Code list, enter HST-ON.
   2. In the first Sales Tax column, enter the HST tax rate for Ontario.
   3. In the Tax Code column, enter HST-ON.
9. Click Apply to save your changes. You will receive a message instructing you to perform an FTD Shutdown and an FTD Startup to make your changes effective.
10. Close Mercury Administration.

You now need to perform the FTD Shutdown and FTD Startup. You must close all instances of FTD Mercury prior to doing this, including any running on any client PCs.

To perform an FTD Shutdown and an FTD Startup:

1. Click the Windows Start button, point to All Programs, then to FTD Software, and click on FTDShutdown. This will begin the FTD Shutdown process.
2. Once the FTD Shutdown is complete, click the Windows Start button, point to All Programs, then to FTD Software, and click on FTDStartup.
3. Once the FTD Startup is complete, you will see the Login window. Log in using your username and password.

Taking Orders During the Transition Period for Delivery on or After 1-July-2010

Order Entry Item Window

If an order is to be delivered to an address in British Columbia, Nova Scotia, or Ontario on or after 1-July-2010 but before you have changed taxes in the next section, you need to override the taxes on a product-by-product basis in Order Entry or Point of Sale while taking the order. Essentially, you are ensuring the taxes are set up the same way they would be for an order taken on 1-July-2010.

To override taxes within an order:

1. Start by taking the order as you normally would.
2. While in Order Entry or Point of Sale, double-click the Product Code column for a product or fee in the Products area. The Order Entry Item window opens.
   • If you clicked a product, in the Tax Code field, change the tax code to the tax code you will be using on 1-July-2010. For example, if this is a local order, change the tax code to the new HST-BC tax code. Likewise, if the order is being sent to Ontario, change the tax code to HST-ON, and if it is being sent to Nova Scotia, change it to HST-NS.
   • If you clicked a fee, you need to change the tax code to the local tax code you will be using on 1-July-2010, which is the new HST-BC tax code.
3. Click Save.
4. Repeat for any additional products or fees.
5. Continue taking the order as you normally would.

Changes to Make Before the Start of Business on 1-July-2010

Changing Your Default Store Tax Code to the New British Columbia Tax Code

To change your default store tax code to the new British Columbia tax code:

1. Launch Mercury Administration by double-clicking on the Mercury Administration icon on the desktop.
2. In the System Login window, enter your login name and password and then click Login.
3. Double-click Mercury Administration in the explorer pane.
4. Double-click the Store folder.
5. Double-click Store Settings. The Store Settings screen opens.
6. In the Default Tax Code field, select the new HST-BC tax code.
7. Click Apply to save your changes. You will receive a message instructing you to perform an FTD Shutdown and an FTD Startup to make your changes effective. You will do this later.

Repeat this procedure for any other stores in FTD Mercury (select the store from the Store list).

Do not close Mercury Administration, as you will be updating your printed tax label in the next section.

Updating Your Printed Tax Labels

You should change your printed tax labels so your customers know which taxes were applied to the order.

To change your tax label used on printouts:

1. In Mercury Administration, double-click the Accounting folder.
2. Double-click Tax Code. The Tax Code screen opens.
3. Ensure the Federal Tax Label field is GST/HST.
4. Ensure the Provincial Tax Label field is PST/QST.
5. Click Apply to save your changes.

Your forms will now indicate GST/HST when a Federal tax is applied, and PST/QST when provincial taxes are applied.

Do not close Mercury Administration, as you will be updating delivery zones in the next section.

Updating Delivery Zones with Overriding Tax Codes

Delivery Zones Screen in Mercury Administration

To update delivery zones with overriding tax codes:

1. In Mercury Administration, double-click the Delivery folder.
2. Double-click Delivery Zone. The Delivery Zone screen opens.
3. Locate any local delivery zones that use an overriding tax code and change the Tax Code to HST-BC.
4. Locate the delivery zone you use for wire out orders to Nova Scotia (likely called FTD-NS or FTD-NOVA SCOTIA). Change the Tax Code to HST-NS.
5. Locate the delivery zone you use for wire out orders to Ontario (likely called FTD-ON or FTD-ONTARIO). Change the Tax Code to HST-ON.
6. Click Apply to save your changes. You will receive a message instructing you to perform an FTD Shutdown and an FTD Startup to make your changes effective. You will do this in the next section.
7. Close Mercury Administration.

Performing an FTD Shutdown and FTD Startup

You now need to perform the FTD Shutdown and FTD Startup. You must close all instances of FTD Mercury prior to doing this, including any running on any client PCs.

To perform an FTD Shutdown and an FTD Startup:

1. Click the Windows Start button, point to All Programs, then to FTD Software, and click on FTDShutdown. This will begin the FTD Shutdown process.
2. Once the FTD Shutdown is complete, click the Windows Start button, point to All Programs, then to FTD Software, and click on FTDStartup.
3. Once the FTD Startup is complete, you will see the Login window. Log in using your username and password.

Updating Products with Overriding Tax Codes

Product Entry Window

If you have any products with overriding tax codes (usually fees such as relay and delivery charges), you need to change these to reflect tax codes on these products to use your new British Columbia tax code.

To update a product with an overriding tax code:

1. On the FTD Mercury Main Menu, in the Search area, click Product. The Product Search window opens.
2. In the Product Search window, search for the product you want to update.
3. From the results list, double-click the product. The Product Entry window opens.
4. In the Tax Code field, change the tax code to your new HST-BC tax code.
5. Click Save.
6. Close the window and repeat for any additional products with overriding tax codes.

Updating Standing Orders for Ontario, British Columbia, and Nova Scotia

If you have any Standing Orders in your system, you need to update them if they are being delivered to Ontario, British Columbia, or Nova Scotia. When you complete the standing order again, taxes will automatically be updated for future orders.

Generating a Standing Orders Report

Before you update your Standing Orders, you should generate a Standing Orders report to have a checklist of which Standing Orders you have and have not changed.

To generate a Standing Orders report:

1. On the FTD Mercury Main Menu, click Business Reports.
2. Double-click Standing Order Report. The Standing Order Report window opens.
3. From the Select Store list, select the store for which you are generating the report.
4. In the Sort By area, select Customer.
5. In the Report Type area, select Summary.
6. Click Finish.

The Standing Order Report is generated and opens in Microsoft Excel. You can then print it to use as a checklist of which Standing Orders you have already modified to reflect the new taxes. When you close the report in Microsoft Excel, there is no need to save it once you have printed it.

Changing Existing Standing Order Templates

Changing a Standing Order Template

To change existing standing order templates:

1. Perform a Customer Search using the Customers with Standing Orders option to locate customers with standing orders.
2. Double-click a customer from the results list.
3. Click the Standing Order tab.
4. From the list of active standing order templates, double-click on a standing order template. The Standing Order Scheduler window opens.
5. Click Next. The Order Entry window opens.
6. If the delivery zone for the order is NOT in Ontario, British Columbia, or Nova Scotia, click Escape and proceed to step 11.
7. If the delivery zone for the order is in British Columbia, Ontario, or Nova Scotia, for ONE product on the order, re-enter or reselect the product code and then press the TAB key. (For example, if you have a product with ARR as the product code, re-enter ARR in the Product Code field and then press TAB.) When you press TAB, you will see the taxes update in the Order Totals area at the bottom right of the window. You only have to do this for one product in the standing order. FTD Mercury will automatically recalculate taxes for the entire order.
8. Click Complete to display the Payments window.
9. Click Complete to return to the Standing Orders tab of the Customer Detail Information window.
10. Repeat steps 4-9 for any additional standing orders for this customer.
11. Click Escape to exit the Customer Detail Information window and return to the Customer Search window.
12. Repeat steps 2-11 for each customer with a standing order.

Return to Canadian Tax Changes