Business Reports

From FloristWiki

(Difference between revisions)
Jump to: navigation, search
Current revision (14:20, 8 November 2011) (edit) (undo)
 
(13 intermediate revisions not shown.)
Line 1: Line 1:
{{TOCright}}
{{TOCright}}
-
FTD Mercury allows you to generate several different reports to assist you in the daily operations of your shop. In addition to financial reporting functionality, the reports in this section are designed as business management tools. Each report is generated using a Microsoft Excel template.
+
<table>
 +
<tr>
 +
<td>
 +
[[Image:ImportantInfoIcon.png]]
 +
</td>
 +
<td>
 +
If you are using Mercury Connect with FTD Mercury X3 Fall or later, reports are handled through [[Mercury Connect Report Center|Report Center]].
 +
</td>
 +
</tr>
 +
</table>
-
This section is designed to educate you on all of the reports that are available to generate from the program and how to customize each report for the unique needs of your store. This section helps you understand the purpose of each report, how to access and print each report, and contains an example of each report.
+
FTD Mercury allows you to generate several different reports to assist you in the daily operations of your shop. In addition to financial reporting functionality, the reports in this section are designed as business management tools. Most reports are generated and displayed in Microsoft Excel. The system retrieves information from your store’s database to generate each type of report. Once the report is displayed on your screen, you can save or print it.
-
==Using Business Report Templates==
+
<table>
-
'''IMPORTANT: This section discusses templates for business reports. For information on Marketing templates (standard templates and templates used with Mercury Marketing), see [[Marketing]].'''
+
<tr>
 +
<td>
 +
[[Image:ImportantInfoIcon.png]]
 +
</td>
 +
<td>
 +
This section discusses reports. For information on Marketing templates (standard templates and templates used with Mercury Marketing), see [[Marketing]].
 +
</td>
 +
</tr>
 +
</table>
-
FTD Mercury includes several Microsoft Excel and Microsoft Word templates that help you generate reports, letters, and mailing labels. Templates eliminate the need for setting up the format of these documents; they contain all the formatting and text that you need to generate these documents. All you need to do is click on the template, specify what type of information you want to include, and your letters, reports, and labels are generated for you automatically. The system retrieves information from your store’s database to generate each type of report. Once the report is displayed on your screen, you can save or print it.
+
==Accessing Business Reports==
 +
<table>
 +
<tr>
 +
<td>
 +
[[Image:ImportantInfoIcon.png]]
 +
</td>
 +
<td>
 +
In order to use Business Reports, you must have full access to Reports in Mercury Administration. You can [[Mercury Administration: Window Access Screen|control employee access to Business Reports]] based on employee types.
 +
</td>
 +
</tr>
 +
</table>
-
'''IMPORTANT: In order to use Business Reports, you must have full access to Reports in Mercury Administration. You can [[Mercury Administration: Window Access Screen|control employee access to Business Reports]] based on employee types.'''
+
'''To access FTD Mercury reports:'''
-
 
+
#On the FTD Mercury Main Menu, click Business Reports.
-
You may use the following methods to access your FTD Mercury templates:
+
-
 
+
-
===From Within FTD Mercury===
+
-
'''To access FTD Mercury templates from the FTD Mercury Main Menu:'''
+
-
#Click Business Reports.
+
#Double-click Mercury Forms.
#Double-click Mercury Forms.
#Double-click the name of the report you want to generate.
#Double-click the name of the report you want to generate.
-
#If you receive a security warning about the template containing macros, click Enable Macros. This is normal and the macros are required to generate the report or letter.
+
#If you receive a security warning about the template containing macros, click Enable Macros. This is normal and the macros are required to generate the report.
-
 
+
#Depending on the report, you may have to configure one or more windows to set necessary options for the report (such as a date range).
-
===From Within Microsoft Word or Microsoft Excel===
+
#Click Finish to generate the report.
-
'''To access FTD Mercury templates from within Microsoft Word or Microsoft Excel:'''
+
-
#Either open Microsoft Word (for letters) or Microsoft Excel (for reports).
+
-
#On the File menu, click New.
+
-
#In the New Document pane (Word) or the New Workbook pane (Excel) on the right side of the screen, click On my computer.
+
-
#In the Templates window, click the Mercury Forms tab.
+
-
#Double-click the template you want to open.
+
-
#If you receive a security warning about the template containing macros, click Enable Macros. This is normal and the macros are required to generate the report or letter.
+
-
#Depending on the report or letter, you may have to configure one or more windows to set necessary options for the report or letter (such as a date range).
+
-
#Click Finish to generate the report or letter.
+
==List of Business Reports==
==List of Business Reports==
FTD Mercury provides the following business reports:
FTD Mercury provides the following business reports:
-
*[[Abbreviated Customer Master List with Balance Report]]
+
*[[Abbreviated Customer Master List with Balance Report]] - use to target customers with larger balances due for collection.
-
*[[Abbreviated Customer Master List with Days Late Report]]
+
*[[Abbreviated Customer Master List with Days Late Report]] - use to target customers who are not current on payment of account balance.
-
*[[Aged Analysis Reports]]
+
*[[Aged Analysis Reports]] - an up to date list of house account balances including the length of time on each customer’s balance.
-
*[[Business Snapshot Report]]
+
*[[Business Snapshot Report]] - an excellent scheduling and purchasing tool as it shows sales, deliveries and products sold for any date range.
-
*[[Credit Card Settlement History Report]]
+
*[[Credit Card Settlement History Report]] - get detail or summary reports of your credit card deposits for any date range.
-
*[[Customer Account Payment Report]]
+
*[[Customer Account Payment Report]] - used as a cross reference to confirm payments made on accounts.
-
*[[Customer Master List]]
+
*[[Customer Master List]] - a complete list of customers on file; useful for merging duplicates, purging inactive accounts, and targeting particular groups of customers.
-
*[[Employee Analysis Report]]
+
*[[Employee Analysis Report]] - see how productive your employees are and compare them to each other for goals, raises, spiffs etc.
-
*[[Employee Sales Report]]
+
*[[Employee Sales Report]] - based off of the employee name selected in Order Entry and Point of Sale, this report is useful for determining the quantity of sales and total dollar value of sales for individual employees.
 +
*[[Life Cycle Report]] - an important audit feature that provides information on all changes and updates to either orders or customers.
*[[Message Report]]
*[[Message Report]]
*[[Payment Type Totals Report]]
*[[Payment Type Totals Report]]
-
*[[Product Comparison Report]]
+
*[[Product Comparison Report]] - compare two date ranges or two locations to assist in inventory purchase decisions.
-
*Product Sales Reports—There are several variations on this report:
+
*[[Product Sales Reports]] - full scale analysis of product sales, not only by date but by product code and occasion.
-
**[[List of Product Codes Summary Report]]
+
*[[Reciprocity Report]] - analyze your filling and sending orders with other FTD florists, by the number of orders and dollar value.
-
**[[List of Product Codes Detail Report]]
+
*[[Report of Orders Filled]] - typically used to generate a list of phoned-in orders from different wire services as a means to report and receive credit for those orders in your system.
-
**[[Sales by Product Code Summary Report]]
+
*[[Sales by Referral Code Report]] - analyze the effectiveness of marketing programs, by customers and dollar value.
-
**[[Sales by Product Code Detail Report]]
+
*[[Sales Summary Report]] - for any sale or delivery date range, a summary of completed sales, with separate subtotals including walk in, phone orders, wire orders and payment types.
-
*[[Product Sales Report by Date by Occasion by Product Summary Report]]
+
*[[Sales Tax Report]] - provides sales tax information for any date range to assist in reporting to your state or province. It is available either by sale or delivery date and either cash or accrual basis.
-
*[[Product Sales Report by Date by Occasion by Product Detail Report]]
+
*[[Standing Order Log Summary Report]] & [[Standing Order Log Detail Report]] - provide a detailed or summary of customers with standing orders.
-
*[[Reciprocity Report]]
+
*[[Tax Exempt Customer Report]] - for any date range, a list of tax exempt customers’ activity; useful for keeping tax exempt records up to date if your state requires current registration of other information.
-
*[[Report of Orders Filled]]
+
-
*[[Sales by Referral Code Report]]
+
-
*[[Sales Summary Report]]
+
-
*[[Sales Tax Report]]
+
-
*[[Standing Order Log Detail Report]]
+
-
*[[Standing Order Log Summary Report]]
+
-
*[[Tax Exempt Customer Report]]
+
*[[Ticket Report]]
*[[Ticket Report]]
*[[Wire Reconciliation Report]]
*[[Wire Reconciliation Report]]
-
*[[Wire Service Incoming/Outgoing Report]]
+
*[[Wire Service Incoming/Outgoing Report]] - a list for any date range of all incoming and outgoing orders; helpful in reconciling statements from non-FTD wire services.
 +
 
 +
 
 +
<hr>
 +
[[FTD Mercury Documentation|Back to FTD Mercury Documentation]]

Current revision

Contents

Image:ImportantInfoIcon.png

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

FTD Mercury allows you to generate several different reports to assist you in the daily operations of your shop. In addition to financial reporting functionality, the reports in this section are designed as business management tools. Most reports are generated and displayed in Microsoft Excel. The system retrieves information from your store’s database to generate each type of report. Once the report is displayed on your screen, you can save or print it.

Image:ImportantInfoIcon.png

This section discusses reports. For information on Marketing templates (standard templates and templates used with Mercury Marketing), see Marketing.

Accessing Business Reports

Image:ImportantInfoIcon.png

In order to use Business Reports, you must have full access to Reports in Mercury Administration. You can control employee access to Business Reports based on employee types.

To access FTD Mercury reports:

  1. On the FTD Mercury Main Menu, click Business Reports.
  2. Double-click Mercury Forms.
  3. Double-click the name of the report you want to generate.
  4. If you receive a security warning about the template containing macros, click Enable Macros. This is normal and the macros are required to generate the report.
  5. Depending on the report, you may have to configure one or more windows to set necessary options for the report (such as a date range).
  6. Click Finish to generate the report.

List of Business Reports

FTD Mercury provides the following business reports:



Back to FTD Mercury Documentation

Personal tools