Report Center: Sales Tax Report

From FloristWiki

Jump to: navigation, search

Image:ImportantInfoIcon.png

This information applies only to Mercury Connect.

Contents

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. On the Report Center window, hover over the Sales button, and select Sales Tax. The Sales Tax Report screen opens.
  3. From the Select Store list, select the store for which you are generating the report.
  4. Select whether you are generating the report by delivery or sale date.
  5. Specify the start and end dates for the report.
  6. Select whether you want the data to be include based on Accrual or Cash Basis.
  7. Click Generate.

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. On the Report Center window, hover over the Sales button, and select Sales Tax. The Sales Tax Report screen opens.
  3. From the Select Store list, select the store for which you are generating the report.
  4. Select whether you are generating the report by delivery or sale date.
  5. Specify the start and end dates for the report.
  6. Select whether you want the data to be include based on Accrual or Cash Basis.
  7. In the Clearing House Statement area, enter additional tax entries and/or input tax credits for wire service statements or accounts payable.
  8. Click Generate.

Sales Tax Report Screen

There are two versions of this screen depending on whether Mercury Connect is configured as a U.S. system or a Canadian system.


U.S. Systems

This screen opens when you open the Sales Tax Report template. The settings you select determine the content of the Sales Tax report. When you click Generate, the report generates.

The Sales Tax Report window contains the following settings:

Setting Description
Select Store Select the store for which you want to generate the report.
Date Range Select whether you want to generate the report by delivery or sale date.
Start Date Select the starting date for the report.
End Date 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 Systems

This screen opens when you open the Sales Tax Report template. The settings you select determine the content of the Sales Tax report. When you click Generate, the report generates.

The Sales Tax Report screen for the Canadian Sales Tax report contains the following settings:

Setting Description
Select Store Select the store for which you want to generate the report.
Date Range Select whether you want to generate the report by delivery or sale date.
Start Date Select the starting date for the report.
End Date 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.
Tax Paid to Filling Florist 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 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 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 Enter the taxes paid on commissions for incoming orders within Canada. This value can be found on your FTD Clearinghouse Statement.
Taxes Paid on Fees and 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 Expenses 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 Report Center

Personal tools