Four Week Comparison reports allow users to compare sales data for a selected week with sales data from four prior weeks. The current year’s activity may also be compared with the previous year’s data.
Reports are available in summary and detailed format for both parent and child profit centers.
Note: Since the report lists "reported" lottery sales and not what was entered at the register, the sales may not agree with your general ledger.
When you select Four Week Comparison reports, the system displays the following report criteria screen:
The following selection criteria allow you to specify the week you want to compare on the report and the way the report is viewed.
Enter the ending date for the week you wish to compare. You must make an entry in this field and it must be in mm/dd/yy format. For example:
01/10/99
You do not need to know the exact Week End Date. The system will find the actual End date for any date you enter.
You may specify how you want to view and/or print the report by choosing from the following selections:
· View Report Directly
· Condense Print
· Print Directly to LPN
· Display/Print Selection Page
The following information is listed on Four Week Comparison Summary reports:
Profit Center
Current Year
Last Year
Week Ending Dates
Merch $
Fuel Gallons
Lottery Sales
Money Order Sales
Misc. Revenue
Note: Tables MR_SALES and GL_JRNL_RS are used to retrieve sales data. Tables MOSALES and LOTTMISC are used to retrieve sales data for StoreTrak users only. The GL_RPT_PORT_GL table is used to define any additional GL accounts that represent sales to be listed on the report.
The report displays the name and number of the profit center represented by the corresponding report data.
If a profit center has a child profit center, it appears as a hyperlink. Clicking on the hyperlink allows you to view summary report information for each child profit center.
The column headings for the report are as follows:
Current Year
The date columns beneath the Current Year heading refer to dates pertaining to the current year.
Last Year
The date columns beneath the Last Year heading refer to dates pertaining to the prior year.
The report columns are as follows:
Week Ending Dates
The Week Ending Date columns contain sales data pertaining to each week during the specified period.
Note: Ten weeks are shown on Four Week Comparison reports. The first week in both the Current and Last Year sections is the week chosen as report criteria. Prior weeks are then chosen by subtracting one week from the selected current and prior year Week End dates and then subtracting one week from each subsequent Week End date.
The report sections are as follows:
Merchandise $
The Merch $ section reports merchandise sales values for each Week Ending Date column. Column values are rounded to the nearest whole dollar.
Fuel Gallons
The Fuel Gallons section reports fuel gallon values for each Week Ending Date column. Column values are rounded to the nearest whole gallon.
Lottery Sales
The Lottery Sales section is only available to StoreTrak users. This section reports Lottery ticket sales. Values are rounded to the nearest whole dollar. If there are no values to report, the section label will not print on the report.
Money Order Sales
The Money Order Sales section is only available to StoreTrak users. This section reports money order sales. Values are rounded to the nearest whole dollar. If there are no values to report, the section label will not print on the report.
Miscellaneous Revenue
The Misc. Revenue section reports miscellaneous revenue. Values are rounded to the nearest whole dollar. If there are no miscellaneous revenue values to report, the section label will not print on the report.
The following formula is used to calculate the Misc. Revenue column values:
(Y – X)
X = the sum of debit values retrieved from the GL_JRNL_RS table for each week. Note: Debit values are retrieved and calculated by the system. They are not displayed on Four Week Comparison reports.
Y = the sum of credit values retrieved from the GL_JRNL_RS table for each week. Note: Credit values are retrieved and calculated by the system. They are not displayed on Four Week Comparison reports.
The Four Week Comparison Detail report displays more detailed information for each section listed on the Four Week Comparison Summary report.
Values on the detail report are rounded to the nearest whole number. Because each value is rounded, Total values may differ from the Summary report. The Summary report should be considered more accurate.
The following information is listed on Four Week Comparison Detail reports:
Profit Center
Current Year
Last Year
Week Ending Dates
Merch Categories
Fuel Products
Lottery Sales
Money Order Sales
Misc Revenue
Total Values
The report displays the name and number of the profit center represented by the corresponding report data.
If a profit center has a child profit center, it appears as a hyperlink. Clicking on the hyperlink allows you to view summary report information for each child profit center.
The column headings for the report are as follows:
Current Year
The date columns beneath the Current Year heading refer to dates pertaining to the current year.
Last Year
The date columns beneath the Last Year heading refer to dates pertaining to the prior year.
The report columns are as follows:
Week Ending Dates
The Week Ending Date columns contain sales data pertaining to each week during the specified period.
The report sections are as follows:
Merchandise Category
The Merch Category section details the Merchandise $ section displayed on the Summary report. Underneath this heading, a listing for each individual category pertaining to merchandise sales is displayed.
Fuel Products
The Fuel Products section details the Fuel Gallons section of the Summary report. Underneath this heading, a listing for each individual category pertaining to Fuel Gallons is displayed.
Lottery Sales
The Lottery Sales section is only available to StoreTrak users. This section details the Lottery Sales section of the Summary report. Underneath this heading are two sub-categories: Online Sales and Ticket Sales. If there are no values to report, the Lottery Sales section label will not print on the report.
Money Order Sales
The Money Order Sales section is only available to StoreTrak users. This section details the Money Order Sales section of the Summary report. If there are no values to report, the Money Order Sales label will not print on the report.
Miscellaneous Revenue
The Misc. Revenue section details the Misc. Revenue section of the Summary report. Underneath this heading, a listing for each individual category pertaining to miscellaneous revenue is displayed. If there are no miscellaneous revenue values to report, the section label will not print on the report.
The following formula is used to calculate the Misc. Revenue column values:
(Y – X)
X = the sum of debit values retrieved from the GL_JRNL_RS table for each week. Note: Debit values are retrieved and calculated by the system. They are not displayed on Four Week Comparison reports.
Y = the sum of credit values retrieved from the GL_JRNL_RS table for each week. Note: Credit values are retrieved and calculated by the system. They are not displayed on Four Week Comparison reports.
Total values are figured by summing the values of the individual category rows for each period.
If a profit center has child profit centers, you may click on the parent profit center’s hyperlink to view summary report information for its child profit centers.
Child Four Week Comparison Summary reports are based on the same selection criteria you entered for the parent profit center.
Summary information for child profit centers is calculated in the same manner as it is for parent profit centers. See the Four Week Comparison Summary report section for more information.
Click on the child profit center’s hyperlink to view a Four Week Comparison Child Detail report.
Detail information for child profit centers is calculated in the same manner as it is for parent profit centers. See the Four Week Comparison Detail report section for more information.
You may notice a slight rounding difference between totals on detail and summary reports. Click here to see why.