Reports - Finance

HubSpot Video

This section enables you to generate reports related to all important finance stats. From this section, following reports can be generated as discussed in below sections.

Daily Sales by Location

 

This report displays the daily sales of the selected locations for the selected date range. Following filters are available for generating the report.


· Date Range: This is the selected date range for the report.

· Locations: You can select the desired locations/countries/states/DMAs by using this filter. To switch between location, country, state and DMA selection, you can use the drop-down, after which you can select one or more items. Search is available for finding a specific location-by-location number or location name.

· Stores Open for at least months: This drop-down enables you to include only those stores in result who have been open for at least the selected number of months. Options available are 1- 96 and All.

· Stores open for at most months: This drop-down enables you to include only those stores in result who have been open for at most the selected number of months. Options available are 1- 96 and All.

 

Clicking Export to Excel downloads the report in Excel format.

 

Weekly Sales by Location

 

This report displays the daily sales of the selected locations for the selected date range. Following filters are available for generating the report.


· Date Range: This is the selected date range for the report.

· Locations: You can select the desired locations/countries/states/DMAs by using this filter. To switch between location, country, state and DMA selection, you can use the drop-down, after which you can select one or more items. Search is available for finding a specific location-by-location number or location name.

· Stores Open for at least months: This drop-down enables you to include only those stores in result who have been open for at least the selected number of months. Options available are 1- 96 and All.

· Stores open for at most months: This drop-down enables you to include only those stores in result who have been open for at most the selected number of months. Options available are 1- 96 and All.

 

Clicking Export to Excel downloads the report in Excel format.

 

Monthly Sales by Location

 

This report displays weekly sales for the selected date range for the selected locations. Following filters are available for generating the report.


· Date Range: This is the selected date range for the report.

· Locations: You can select the desired locations/countries/states/DMAs by using this filter. To switch between location, country, state and DMA selection, you can use the drop-down, after which you can select one or more items. Search is available for finding a specific location-by-location number or location name.

· Stores Open for at least months: This drop-down enables you to include only those stores in result who have been open for at least the selected number of months. Options available are 1- 96 and All.

· Stores open for at most months: This drop-down enables you to include only those stores in result who have been open for at most the selected number of months. Options available are 1- 96 and All.


Clicking Export to Excel downloads the report in Excel format.

 

Total Sales by Location

 

This report displays the total sales by the selected locations for the selected period. Following filters are available for generating the report.


· Date Range: This is the selected date range for the report.

· Locations: You can select the desired locations/countries/states/DMAs by using this filter. To switch between location, country, state and DMA selection, you can use the drop-down, after which you can select one or more items. Search is available for finding a specific location-by-location number or location name.

· Stores Open for at least months: This drop-down enables you to include only those stores in result who have been open for at least the selected number of months. Options available are 1- 96 and All.

· Stores open for at most months: This drop-down enables you to include only those stores in result who have been open for at most the selected number of months. Options available are 1- 96 and All.

Clicking Export to Excel downloads the report in Excel format.

 

Total Sales by State

 

This report displays the total sales by the selected states for the selected period. Following filters are available for generating the report.


· Date Range: This is the selected date range for the report.

· States: You can select the desired states/countries by using this filter. To switch between country and state selection, you can use the drop-down, after which you can select one or more items. Search is available for finding a specific location-by-location number or location name.

· Stores Open for at least months: This drop-down enables you to include only those stores in result who have been open for at least the selected number of months. Options available are 1- 96 and All.

· Stores open for at most months: This drop-down enables you to include only those stores in result who have been open for at most the selected number of months. Options available are 1- 96 and All.


Clicking Export to Excel downloads the report in Excel format.

 

Total Royalty by Location

 

This report displays the total Royalty charged from the selected locations for the selected period. Following filters are available for generating the report.


· Date Range: This is the selected date range for the report

· Locations: You can select the desired locations/countries/states/DMAs by using this filter. To switch between location, country, state and DMA selection, you can use the drop-down, after which you can select one or more items. Search is available for finding a specific location-by-location number or location name.

· Stores Open for at least months: This drop-down enables you to include only those stores in result who have been open for at least the selected number of months. Options available are 1- 96 and All.

· Stores open for at most months: This drop-down enables you to include only those stores in result who have been open for at most the selected number of months. Options available are 1- 96 and All.


Clicking Export to Excel downloads the report in Excel format.

 

Total Royalty by State

 

This report displays the total Royalty charged by from the selected states for the selected period. Following filters are available for generating the report.


· Date Range: This is the selected date range for the report

· States: You can select the desired states/countries by using this filter. To switch between country and state selection, you can use the drop-down, after which you can select one or more items. Search is available for finding a specific location-by-location number or location name.

· Stores Open for at least months: This drop-down enables you to include only those stores in result who have been open for at least the selected number of months. Options available are 1- 96 and All.

· Stores open for at most months: This drop-down enables you to include only those stores in result who have been open for at most the selected number of months. Options available are 1- 96 and All.


Clicking Export to Excel downloads the report in Excel format.

 

Total NAF by Location

 

This report displays the total NAF charged from the selected locations for the selected period. Following filters are available for generating the report.


· Date Range: This is the selected date range for the report

· Location: You can select the desired locations/countries/states/DMAs by using this filter. To switch between location, country, state and DMA selection, you can use the drop-down, after which you can select one or more items. Search is available for finding a specific location-by-location number or location name.

· Stores Open for at least months: This drop-down enables you to include only those stores in result who have been open for at least the selected number of months. Options available are 1- 96 and All.

· Stores open for at most months: This drop-down enables you to include only those stores in result who have been open for at most the selected number of months. Options available are 1- 96 and All.


Clicking Export to Excel downloads the report in Excel format.

 

Total NAF by State

 

This report displays the total NAF charged by from the selected states for the selected period. Following filters are available for generating the report.


· Date Range: This is the selected date range for the report

· States: You can select the desired states/countries by using this filter. To switch between country and state selection, you can use the drop-down, after which you can select one or more items. Search is available for finding a specific location-by-location number or location name.

· Stores Open for at least months: This drop-down enables you to include only those stores in result who have been open for at least the selected number of months. Options available are 1- 96 and All.

· Stores open for at most months: This drop-down enables you to include only those stores in result who have been open for at most the selected number of months. Options available are 1- 96 and All.


Clicking Export to Excel downloads the report in Excel format.

 

Total NTP by Location

 

This report displays the total NTP charged from the selected locations for the selected period. Following filters are available for generating the report.


· Date Range: This is the selected date range for the report

· Locations: You can select the desired locations/countries/states/DMAs by using this filter. To switch between location, country, state and DMA selection, you can use the drop-down, after which you can select one or more items. Search is available for finding a specific location-by-location number or location name.

· Stores Open for at least months: This drop-down enables you to include only those stores in result who have been open for at least the selected number of months. Options available are 1- 96 and All.

· Stores open for at most months: This drop-down enables you to include only those stores in result who have been open for at most the selected number of months. Options available are 1- 96 and All.


Clicking Export to Excel downloads the report in Excel format.

 

Total Royalty Comparison by State

 

This report displays the comparison of total royalty charged from each selected state during the selected period. Following filters are available for generating the report.


· Date Range: This is the date range for the report

· States: You can select the desired states/countries by using this filter. To switch between country and state selection, you can use the drop-down, after which you can select one or more items. Search is available for finding a specific location-by-location number or location name.

· Stores Open for at least months: This drop-down enables you to include only those stores in result who have been open for at least the selected number of months. Options available are 1- 96 and All.

· Stores open for at most months: This drop-down enables you to include only those stores in result who have been open for at most the selected number of months. Options available are 1- 96 and All.


Clicking Export to Excel downloads the report in Excel format.

 

Comparative Analysis

 

This report displays the comparative analysis of the sales of two selected times of the selected locations. Following filters are available for generating the report.


· Date Range 1: This is the initial date range from which comparison is intended

· Date Range 2: This is the second date range whose comparison in intended with the initial date range

· Sort By: This filter determines the sorting order in which the report should be displayed

· Locations: You can select the desired locations/countries/states/DMAs by using this filter. To switch between location, country, state and DMA selection, you can use the drop-down, after which you can select one or more items. Search is available for finding a specific location-by-location number or location name.

· Include Daily Sales: Marking off this check-box includes non-reconciled sales along with the reconciled sales in the report. By default, this checkbox is unmarked and the report generated displays only the weekly-reconciled sales.

check-box

Clicking Export to Excel downloads the report in Excel format.