Office - Interactive Reports - Inventory - Average Cost Reconciliation-Gross Margin

Owned by Benjamin Hacker
Last updated: Sept 12, 2023
4 min read

Table of Contents

Overview

  • In this guide we will cover the Average Cost Reconciliation, Due to Pro Reconciliation and the Gross Margin Reports. You will learn how to run each report and will see an example of the data that each report will produce.

Required Permissions

 

Accessing the Tool

Interactive Reports gives you the ability to filter, sort, and group the data using criteria. The available criteria are specific to the information the report contains. The report functions give you the ability to customize date settings, save criteria settings, delete saved reports, and schedule an email delivery. In this section you will learn how to use the criteria and report functionality.

  1. Click on the Interactive Reports Icon from the left menu bar. 

  2. On the Report Overview page, there is a list of reporting categories to choose from, or the User can search for a topic in the top search bar. It is best to keep the topic as broad as possible. If the club wants to see POS sales search for sale.

Average Cost Reconciliation

Details average cost standard deviation and error percentages on inventoried items for a specific date range. Organized alphabetically though can be sorted by Error Percentage. Can filter by Item Category. Shows initial quantity and any additional adjustments and item receipts that changed the average cost.

To run the Average Cost Reconciliation, choose the report from the Inventory Dropdown.

  1. Choose the Date Range.

  2. Select the Item Categories,

  3. Select View Report.

In this example you will see that we ran the report using Aug 2 and have chosen to include all item categories. This report does not have an option to expand all via the detail level so each category will need to be expanded as seen in this example. The report provides us the Item Name, Date, Quantity, Purchase Cost, Average Cost, Minimum, Maximum, Mean, Standard Deviation, and Error %.

Due to Pro Reconciliation

Details sales and what is due to the pro if the pro owns the retail store from those sales in a specific time range. Can filter by area if multiple pros own different retail spaces (i.e. Golf, Tennis, Fitness)..  Can also filter Item Groups and Item Categories based on what is owned by the pro. Can choose a specific settlement type (i.e. cash, credit card, credit book etc.). 

To run the Due to Pro Reconciliation, choose the report from the Inventory Dropdown,

  1. Choose the Date Range.

  2. Select the Area/s.

  3. Choose the Detail Level.

  4. Choose the Item Groups.

  5. Choose the Item Categories.

  6. Select the Settlement Types.

  7. Choose the Due to Pro Account.

  8. Select View Report.

In this example we ran the report for 2 months. You will need to select a Due to Pro account in order to run the report. The report gives us the Date, Net Sales, Tax, Pro Total, Cash, Credit Card, Credit Book, Gift Card and the Pro Balance. You can choose to show less settlement types if pro sales are only completed with one.

In this example we ran the report fully expanded and we see all the way down to the item, the member it was sold to, and the area that the item was sold in.

Gross Margin

Details gross margin based on net sales minus cost of inventoried items based on a specific time range . Can be filtered by Area group and Item Categories. Can select a Department and Vendor. Can group by Vendor or Item Category. Optional choice to exclude zero cost items. This report is great for showing items that have not been sold in a while so that the club can determine if they should no longer sell the item.

To run the Gross Margin, choose the report from the Inventory Dropdown,

  1. Select the Date Range.

  2. Choose the Departments.

  3. Select the Item Categories.

  4. Choose the Area Group.

  5. Select the Vendor.

  6. Choose the Detail Level.

  7. Determine how to Group By.

  8. Select View Report.

In this example we ran the report for the month of July and chose only to view the Golf and Tennis Area Groups and have chosen to group by vendor. The report shows us the Vendor, Units Sold, Gross Sales, Discounts, Net Sales, Cost, Average Cost, Last Cost, Gross Margin, Gross Margin %, Days Idle, Last Purchase Date.

In this example we ran the report fully expanded. Here we see the Items sold themselves.

Best Practices

FAQs