Report Center: Tax Exempt Customer Report
From FloristWiki
(Difference between revisions)
(New page: <table> <tr> <td> Image:ImportantInfoIcon.png </td> <td> This information applies only to Mercury Connect. </td> </tr> </table>) |
|||
(One intermediate revision not shown.) | |||
Line 9: | Line 9: | ||
</tr> | </tr> | ||
</table> | </table> | ||
+ | |||
+ | {{TOCright}} | ||
+ | The Tax Exempt Customer report lists all tax exempt customers that have had sales within the specified date range. It lists the customer ID and name, phone number, tax exempt ID and the sales tax paid (if any), and the total dollar amount spent. A grand total of sales without tax is also displayed at the bottom of the report. | ||
+ | *The Detail Report lists each tax exempt customer, as well as all of the customer’s transactions within the specified date range. The report also lists the date of each transaction, and the transaction type and dollar amount. | ||
+ | *The Summary Report lists each tax exempt customer that had transactions within the specified date range, and the total dollar amount spent. | ||
+ | |||
+ | ==Generating the Tax Exempt Customer Report== | ||
+ | '''To generate the Tax Exempt Customer report:''' | ||
+ | #On the FTD Mercury Main Menu, click Business Reports. | ||
+ | #On the Report Center window, hover over Customer, and select Tax Exempt Customer. The Tax Exempt Customer Report screen opens. | ||
+ | #From the Select Store list, select the store's data that you want to use for the report. | ||
+ | #Select whether you want to generate the report by sale date or delivery date. | ||
+ | #In the Start Date field, enter the start date for the report. | ||
+ | #In the End Date field, enter the end date for the report. | ||
+ | #Select the report type, Detail or Summary. | ||
+ | #If you want to include wire service accounts in the report, select Include Wire Service Accounts so that a check mark appears. | ||
+ | #Click Generate. | ||
+ | |||
+ | ==Tax Exempt Report Screen== | ||
+ | The Tax Exempt Report screen allows you to configure settings for the Tax Exempt report. When you have finished configuring settings, click Finish to generate the report. It will open in Microsoft Excel. | ||
+ | |||
+ | The Tax Exempt Report screen contains the following settings: | ||
+ | |||
+ | <table style="width:775px; border: 1px black solid; border-collapse: collapse; border-spacing: 0px; text-align: left; "> | ||
+ | <tr style="background:#D1BC61;"> | ||
+ | <td style="padding: 3px; text-align:left; font-size: 10pt; font-weight: bold; width: 150px;">Setting</td> | ||
+ | <td style="padding: 3px; text-align left; font-size: 10pt; font-weight: bold;">Description</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Select Store</td> | ||
+ | <td style="padding: 3px; text-align:left; font-size: 9pt;">Select the store for which you want to generate the report. If you have multiple stores, you can select All Stores to generate a report that includes data from all of your stores.</td> | ||
+ | </tr> | ||
+ | <tr style="background:#f2ebd8;"> | ||
+ | <td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Date Range</td> | ||
+ | <td style="padding: 3px; text-align:left; font-size: 9pt;">Select whether you want to generate the report by delivery date or sale date.</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Start Date</td> | ||
+ | <td style="padding: 3px; text-align:left; font-size: 9pt;">Select the start date for the report.</td> | ||
+ | </tr> | ||
+ | <tr style="background:#f2ebd8;"> | ||
+ | <td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">End Date</td> | ||
+ | <td style="padding: 3px; text-align:left; font-size: 9pt;">Select the end date for the report.</td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Type</td> | ||
+ | <td style="padding: 3px; text-align:left; font-size: 9pt;">Select whether you want to generate a summary or detail report.</td> | ||
+ | </tr> | ||
+ | <tr style="background:#f2ebd8;"> | ||
+ | <td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Include Wire Service Accounts</td> | ||
+ | <td style="padding: 3px; text-align:left; font-size: 9pt;">Check the box to include wire service accounts in the report.</td> | ||
+ | </tr> | ||
+ | </table> | ||
+ | |||
+ | <hr> | ||
+ | [[Mercury Connect Report Center|Back to Report Center]] |
Current revision
This information applies only to Mercury Connect. |
|
The Tax Exempt Customer report lists all tax exempt customers that have had sales within the specified date range. It lists the customer ID and name, phone number, tax exempt ID and the sales tax paid (if any), and the total dollar amount spent. A grand total of sales without tax is also displayed at the bottom of the report.
- The Detail Report lists each tax exempt customer, as well as all of the customer’s transactions within the specified date range. The report also lists the date of each transaction, and the transaction type and dollar amount.
- The Summary Report lists each tax exempt customer that had transactions within the specified date range, and the total dollar amount spent.
Generating the Tax Exempt Customer Report
To generate the Tax Exempt Customer report:
- On the FTD Mercury Main Menu, click Business Reports.
- On the Report Center window, hover over Customer, and select Tax Exempt Customer. The Tax Exempt Customer Report screen opens.
- From the Select Store list, select the store's data that you want to use for the report.
- Select whether you want to generate the report by sale date or delivery date.
- In the Start Date field, enter the start date for the report.
- In the End Date field, enter the end date for the report.
- Select the report type, Detail or Summary.
- If you want to include wire service accounts in the report, select Include Wire Service Accounts so that a check mark appears.
- Click Generate.
Tax Exempt Report Screen
The Tax Exempt Report screen allows you to configure settings for the Tax Exempt report. When you have finished configuring settings, click Finish to generate the report. It will open in Microsoft Excel.
The Tax Exempt Report screen 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 report that includes data from all of your stores. |
Date Range | Select whether you want to generate the report by delivery date or sale date. |
Start Date | Select the start date for the report. |
End Date | Select the end date for the report. |
Type | Select whether you want to generate a summary or detail report. |
Include Wire Service Accounts | Check the box to include wire service accounts in the report. |