Business Reports
From FloristWiki
(→Window Descriptions) |
(→Tips and Tricks) |
||
| Line 146: | Line 146: | ||
===Viewing Aging by Statement Date=== | ===Viewing Aging by Statement Date=== | ||
To view aging as of a statement date, use Statement Search. In the Search menu, click Statement Search. Highlight the statement run and click Print. The Statement List report that displays contains the aging for the account as of the selected statement run. | To view aging as of a statement date, use Statement Search. In the Search menu, click Statement Search. Highlight the statement run and click Print. The Statement List report that displays contains the aging for the account as of the selected statement run. | ||
| + | |||
| + | ===Balancing Sales Numbers=== | ||
| + | When comparing reports, such as the Sales Summary and Sales Tax reports, be sure that the reports were generated with the same date settings. Reports generated by sale date should only be compared with other reports generated by sale date. Similarly, if you generate a report by delivery date, you can only compare this report to another report generated by delivery date. | ||
==Frequently Asked Questions== | ==Frequently Asked Questions== | ||
Revision as of 14:19, 17 April 2008
Contents |
Description
FTD Mercury X contains enhanced versions of three of the most frequently used business reports.
Aged Analysis Report
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:
- 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.
Aged Analysis reports include only those accounts with balances for the selected store(s) and reporting period. The reports contain account balances and aging on accounts from the sale date relative to the date you generate the report. By default, the Aged Analysis reports set the Balance Forward date one month prior to the current date. By setting the Account Balance date later than the Balance Forward date, you can include future transactions in the Aged Analysis report. Aging is calculated nightly.
You will typically generate Aged Analysis reports monthly, either just before or just after you create statements.
There are three types of Aged Analysis reports:
- Detail Report
- Lists each customer that has an open balance, as well as each individual transaction for the customer that occurred after the balance forward date. The report also prints the ticket number, product code(s) for each transaction, purchase date, and customer balance. Grand totals (for current, 30, 60, 90, 120+ days, and future, if selected) for each store are printed at the bottom of the report.
- Summary Report
- Lists each customer name and phone number, and the current, 30, 60, 90, 120+, and future balances (if selected) for each customer. Individual transactions are not listed.
- Grand Total Report
- Does not list individual customers. Total amounts for all customers are listed, separated by current, 30, 60, 90, 120+, and future balances.
Business Snapshot Report
The Business Snapshot report gives 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.
Business Snapshot includes four reports:
- Sales Analysis
- Summarizes number and dollar value of sales for the reporting period by type of order, payment method, and time of day for sales entered in Order Entry and Point of Sale.
- Delivery Analysis
- Summarizes the number and dollar value of deliveries scheduled for the reporting period by their workflow status. You can use this report as an overview of your delivery schedules and delivery staffing needs.
- Product Analysis
- Summarizes the number and dollar value by product categories and individual products for deliveries scheduled for the reporting period. You can use this report as an overview of how the sales in the reporting period will affect your inventory.
- Wire Analysis
- Summarizes the number and dollar values for each wire service of incoming and outgoing wire sales attached in Order Entry and Point of Sale.
Sales Summary Report
The Sales Summary report summarizes 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).
The Sales Summary reports contain several sections:
- Order Entry/Manual
- Shows total sales, gift certificates purchased and redeemed, outgoing and incoming sales according to wire service, and payments received for Order Entry and manual tickets.
- POS
- Shows total sales, gift certificates purchased and redeemed, outgoing and incoming sales according to wire service, and payments received for Point of Sale. In order for this section of the report to appear, you must be configured to use Point of Sale.
- Total Sales
- Shows combined totals for Order Entry/manual tickets and Point of Sale.
- Other
- Shows finance charges and manual entry for POS systems that are not part of FTD Mercury.
- Store Transfers
- Lists store transfers. In order for data to appear in this section of the report, store transfer journal entries must have been created.
Report Columns
Aged Analysis Report
Aged Analysis Detail Report Columns
Business Snapshot Report
Delivery Analysis Report Fields
Product Analysis Report Fields
Sales Summary Report
How-to Procedures
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.
Steps to use business report templates
Generating Aged Analysis Reports
Use the Aged Analysis report template to generate Aged Analysis reports. The Aged Analysis report template is located in the Mercury Forms folder that you see when you click Business Reports on the FTD Mercury Main Menu.
Steps to generate Aged Analysis reports
Generating Business Snapshot Reports
Use the Business Snapshot report template to generate Business Snapshot reports. The Business Snapshot report template is located in the Mercury Forms folder that you see when you click Business Reports on the FTD Mercury Main Menu.
Steps to generate Business Snapshot reports
Generating Sales Summary Reports
Use the Sales Summary report template to generate Sales Summary reports. The Sales Summary report template is located in the Mercury Forms folder that you see when you click Business Reports on the FTD Mercury Main Menu.
Steps to generate Sales Summary reports
Window Descriptions
Aged Analysis Report Window
You use the Aged Analysis Report window to configure settings for the Aged Analysis report. When you have finished configuring the settings, click Finish to generate the report and open it in Microsoft Excel.
Business Snapshot Report Window
You use the Business Snapshot Report window to select the store(s) and the date or date range for data that will be included in the Business Snapshot report. When you have finished configuring the settings, click Finish to generate the report and open it in Microsoft Excel.
Sales Summary Report Window
You use the Sales Summary Report window to configure settings for the Sales Summary Report. When you have finished configuring settings, click Finish to generate the report and open it in Microsoft Excel.
Tips and Tricks
Collecting Overdue Balances
To assist your collection efforts, Aged Analysis detail and summary reports include customers’ phone numbers. By printing each month’s Aged Analysis report, you can review account aging for a previous month or look up a customer’s balance when access to a terminal is not possible.
Viewing Aging by Statement Date
To view aging as of a statement date, use Statement Search. In the Search menu, click Statement Search. Highlight the statement run and click Print. The Statement List report that displays contains the aging for the account as of the selected statement run.
Balancing Sales Numbers
When comparing reports, such as the Sales Summary and Sales Tax reports, be sure that the reports were generated with the same date settings. Reports generated by sale date should only be compared with other reports generated by sale date. Similarly, if you generate a report by delivery date, you can only compare this report to another report generated by delivery date.
