Sales Tax Report

From FloristWiki

Contents 1 Generating the U.S. Sales Tax Report 2 Generating the Canadian Sales Tax Report 3 Sales Tax Report Window 4 Canadian Sales Tax Window

If you are using Mercury Connect with FTD Mercury X3 Fall or later, reports are handled through Report Center.

The Sales Tax report is used to provide information to assist in completing the monthly sales tax report that you are required to file with your state or province. Although this report is beneficial in many states, each state is required to file different reports.

The Sales Tax report is sorted by Taxable Sales and Non Taxable Sales, and the sales tax paid for each tax code. Tax figures can be based on either delivery or sale dates. The sales tax is calculated according to the rate that you define in Mercury Administration.

You can select whether you want to print by Accrual or Cash Basis. Accrual includes dollar amounts for house account charges that have not yet been paid. Cash Basis only includes actual cash that you have received.

If your system is set up as Canadian, the Sales Tax report will contain a section called Additional Tax Items. In it, taxes on commissions earned and taxes on orders received will be broken out based on information entered in the Canadian Sales Tax window. Additionally, there will be a section for Input Tax Credits, based on Point of Sale paid out transactions, taxes paid to the filling florists, taxes paid on commissions, taxes paid on fees and services, and taxes paid on Accounts Payable invoices.

Generating the U.S. Sales Tax Report

To generate the Sales Tax report if you are a U.S. shop:

1. On the FTD Mercury Main Menu, click Business Reports.
2. Double-click on the Sales Tax Report icon to open the template.
3. If a window opens asking whether you wish you enable or disable macros, click Enable Macros.
4. When the Sales Tax Report window opens:
   1. From the Select Store list, select the store for which you are generating the report. You can also select All Stores if you are configured as a multiple store shop.
   2. In the Month and Year area, select the starting and ending dates for the report. Data included in the report will start on the date you specify in the Start field and will include data up to and including data for the date you select in the End field.
   3. In the Type area, select whether you want the data to be included based on Accrual or Cash Basis.
   4. If you selected Accrual as the Type, in the Date Types area, select whether you want the dates to be based on delivery date or sales date.
   5. Select Delivery Date or Sale Date to determine the date on which tax figures will be based.
   6. Click Finish. The report generates and opens in Excel.
5. To print your report from Excel, on the File menu, click Print.
6. If you want to save the report from Excel, on the File menu, click Save.

Generating the Canadian Sales Tax Report

To generate the Sales Tax report if you are a Canadian shop:

1. On the FTD Mercury Main Menu, click Business Reports.
2. Double-click on the Sales Tax Report icon to open the template.
3. If a window opens asking whether you wish you enable or disable macros, click Enable Macros.
4. When the Sales Tax Report window opens:
   1. From the Select Store list, select the store for which you are generating the report. You can also select All Stores if you are configured as a multiple store shop.
   2. In the Month and Year area, select the starting and ending dates for the report. Data included in the report will start on the date you specify in the Start field and will include data up to and including data for the date you select in the End field.
   3. In the Type area, select whether you want the data to be included based on Accrual or Cash Basis.
   4. If you selected Accrual as the Type, in the Date Types area, select whether you want the dates to be based on delivery date or sales date.
   5. Select Delivery Date or Sale Date to determine the date on which tax figures will be based.
   6. Click Next.
5. When the Canadian Sales Tax window opens, enter additional tax entries and/or input tax credits for wire service statements or accounts payable. Additional taxes entered in this window appear in the first column of the Sales Tax report, under the label defined as Federal Tax in Mercury Administration.
6. Click Finish. The report generates and opens in Excel.
7. To print your report from Excel, on the File menu, click Print.
8. If you want to save the report from Excel, on the File menu, click Save.

Sales Tax Report Window

Regardless of whether FTD Mercury is configured as a Canadian system or as a U.S. system, this window opens when you open the Sales Tax Report template. The settings you select determine the content of the Sales Tax report. For U.S. shops, when you click Finish, the report generates.

For Canadian shops, clicking the Next button opens the Canadian Sales Tax window.

The Sales Tax Report window contains the following settings:

Setting	Description
Select Store	Select the store for which you want to generate the report. If you have multiple stores, you can select All Stores to generate a Sales Tax Report that includes data from all of your stores.
Start	Select the starting date for the report.
End	Select the ending date for the report.
Type	Select whether you want your report to include data based on one of the following types: Accrual—includes dollar amounts for house account charges that have not yet been paid. If you select this option, you need to specify the Date Types you want to include. Cash Basis—only includes actual cash you have received. Date Types If you selected Accrual as the Type, you need to specify the date types you want to include in the report. You can select one of the following: Delivery Date—when this is selected, orders completed with a delivery date within the months selected for the report will be included. Sale Date—when this is selected, orders completed with an entry date within the months selected for the report will be included.

Canadian Sales Tax Window

When you are generating a Sales Tax report, and you are a Canadian shop, when you click Next on the Sales Tax Report window, the Canadian Sales Tax window opens. This window enables you to enter additional tax entries and/or input tax credits for wire service statements or accounts payable. Additional taxes entered in this window appear in the first column of the Sales Tax report, under the label defined as Federal Tax in Mercury Administration.

Tax amounts entered in this window are included in the totals generated on the Sales Tax report regardless of whether you selected Accrual or Cash Basis as the report type in the Sales Tax Report window.

The Canadian Sales Tax window contains the following settings:

Setting	Description
Store	Displays the name of your store. You cannot change this setting from this window.
Tax Paid to Filling Florist Canadian Outgoing Orders	Enter the taxes paid to filling florists on outgoing orders within Canada. This value can be found on your FTD Clearinghouse Statement.
Tax on Commissions Earned Canadian Outgoing Orders	Enter the taxes on commissions earned on outgoing orders within Canada. This value can be found on your FTD Clearinghouse Statement.
Tax on Orders Received Canadian Incoming Orders	Enter the taxes on orders received for incoming orders within Canada. This value can be found on your FTD Clearinghouse Statement.
Tax Paid on Commissions Canadian Incoming Orders	Enter the taxes paid on commissions for incoming orders within Canada. This value can be found on your FTD Clearinghouse Statement.
Misc. GST/HST Taxes Paid on Fees or Services	Enter the miscellaneous GST or HST taxes paid on services and fees. This value can be found on your FTD Clearinghouse Statement.
GST/HST Tax Paid on Business Related AP Invoices	Enter the amount of GST or HST taxes paid on business-related accounts payable invoices. Usually, this value is calculated in stored in your accounting software. Consult your accountant for details on the value to enter.

---

Back to Business Reports