Business Reports

From FloristWiki

(Difference between revisions)
Jump to: navigation, search
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.
-
FTD Mercury X contains enhanced versions of three of the most frequently used business reports.
+
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.
-
==Aged Analysis Reports==
+
==Using Business Report Templates==
 +
'''IMPORTANT: This section discusses templates for business reports. For information on Marketing templates (standard templates and templates used with Mercury Marketing), see [[Marketing]].'''
-
[[Aged Analysis Reports]] provide you with an analysis of your house account balances for either open item or balance forward accounts. You can use Aged Analysis reports to:
+
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.
-
*View potential future cash flow.
+
-
*See how much customers owe and decide what steps you need to take to recoup money that you are owed.
+
-
==Business Snapshot Report==
+
'''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.'''
-
 
+
-
[[Business Snapshot Reports]] give you an immediate analysis of what is going on in your business for a given day or date range. For example, you could generate the Business Snapshot report in the morning to see how heavy your delivery schedule for the day will be. You can also get an idea of your staffing needs throughout a day by tracking various types of sales by hour.
+
-
 
+
-
Since Business Snapshot reports include cancelled, pending, and incomplete sales, the information in Business Snapshot should not be used to balance completed sales. For balancing purposes, use the Sales Summary Report.
+
-
 
+
-
==Sales Summary Report==
+
-
 
+
-
[[Sales Summary Reports]] summarize total completed sales for your store for a given sale or delivery date or date range. Information in the Sales Summary is reported on an accrual basis. Because the Sales Summary reports information by statement categories, such as merchant
+
-
amount, delivery charge, or discount amounts, information in the Sales Summary is comparable to information in the Sales Tax report, if the Sales Tax report is run on an accrual basis for the same reporting period and date type (delivery date or sale date).
+
-
 
+
-
==Using Business Report Templates==
+
-
FTD Mercury includes Microsoft Excel templates for generating business reports. Templates eliminate the need for setting up the format of the reports since the templates contain all the formatting and text to generate the reports. All you need to do is click on the template and specify what type of information you want to include. 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.
+
You may use the following methods to access your FTD Mercury templates:
-
[[Steps to use business report 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 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.
-
==Tips and Tricks==
+
===From Within Microsoft Word or Microsoft Excel===
 +
'''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.
-
==Frequently Asked Questions==
+
==List of Business Reports==
 +
FTD Mercury provides the following business reports:
 +
*[[Abbreviated Customer Master List with Balance Report]]
 +
*[[Abbreviated Customer Master List with Days Late Report]]
 +
*[[Aged Analysis Reports]]
 +
*[[Business Snapshot Report]]
 +
*[[Credit Card Settlement History Report]]
 +
*[[Customer Account Payment Report]]
 +
*[[Customer Master List]]
 +
*[[Employee Analysis Report]]
 +
*[[Employee Sales Report]]
 +
*[[Message Report]]
 +
*[[Payment Type Totals Report]]
 +
*[[Product Comparison Report]]
 +
*Product Sales Reports—There are several variations on this report:
 +
**[[List of Product Codes Summary Report]]
 +
**[[List of Product Codes Detail Report]]
 +
**[[Sales by Product Code Summary Report]]
 +
**[[Sales by Product Code Detail Report]]
 +
*[[Product Sales Report by Date by Occasion by Product Summary Report]]
 +
*[[Product Sales Report by Date by Occasion by Product Detail Report]]
 +
*[[Reciprocity Report]]
 +
*[[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]]
 +
*[[Wire Reconciliation Report]]
 +
*[[Wire Service Incoming/Outgoing Report]]

Revision as of 13:07, 15 February 2011

Contents

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.

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.

Using Business Report Templates

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

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.

IMPORTANT: 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.

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:

  1. 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 or letter.

From Within Microsoft Word or Microsoft Excel

To access FTD Mercury templates from within Microsoft Word or Microsoft Excel:

  1. Either open Microsoft Word (for letters) or Microsoft Excel (for reports).
  2. On the File menu, click New.
  3. In the New Document pane (Word) or the New Workbook pane (Excel) on the right side of the screen, click On my computer.
  4. In the Templates window, click the Mercury Forms tab.
  5. Double-click the template you want to open.
  6. 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.
  7. 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).
  8. Click Finish to generate the report or letter.

List of Business Reports

FTD Mercury provides the following business reports:

Retrieved from "http://floristwiki.ftdi.com/index.php/Business_Reports"
Personal tools
Navigation