Reporting Metric Glossary
Danielle Ewert avatar
Written by Danielle Ewert
Updated over a week ago

Metric Glossary

SOURCE SALES

Source Sales are where the item sale’s value will be attributed to. It may not always be the same as the location the item was purchased from.

Location sales are where the item physically gets fulfilled from.

Source Sales » Net Sales

  • Net sales are defined as gross sales minus both net markdowns and gross returns.

  • Net sales are total revenue, minus the cost of sales returns, allowances, and discounts.

  • This is the primary sales figure reviewed by analysts when they examine the income statement of a business.

  • Sales at gross invoice amount minus any adjustments for returns, allowances, or discounts taken.

Reporting Tips:

Source Sales » Net Returns

  • Investment’s gross income minus expenses.

Source Sales » Net Qty Sold

  • Net Quantity Sold equals the Gross Quantity Sold minus Gross Quantity Returned

Source Sales » Net Item Sold Cost

  • This is the Cost of Goods Sold (COGS). It is the average cost your business paid for the items at the time of sale, not including other costs such as freight.

Source Sales » Net Markdowns

  • Total discounts on items sold, calculated as the difference between the item's Original Price and the selling price.

  • If the item did not have an Original Price, it’s calculated as the difference between the item's Current Price and it’s sold price.

Source Sales » Net Markdowns excluding Price Adjustments

  • Coupon and Promotion discounts, minus manual price adjustments

Source Sales » Gross Margin

  • Net Sales minus Net Item Sold Cost

  • The difference between Net Sales and Net Item Sold Cost.

Source Sales » Gross Margin %

  • To calculate, first find your gross profit: Net sales - Net Item Sold Cost = Gross Margin

  • Gross Margin divided by net sales = Gross Margin percentage

  • Gross margin % = percentage of Net Sales sold

Source Sales » Sold Margin

  • Gross Sales minus the Net Item Sold Cost, excluding Returns.

Source Sales » Sold Margin %

  • Sold Margin divided by Gross Sales

Source Sales » Gross Sales

  • Gross Sales are sales at full retail price

  • Gross sales are a grand total of all sales transactions reported in a period, without any deductions included within the figure.

Source Sales » Gross Qty Sold

  • Gross Quantity Sold is the total number of items sold.

Source Sales » Gross Returns

  • Total Original Price of retail dollars returned by a customer.

  • Gross Returns do not include markdowns. Return markdowns are included in Net Markdowns.

  • As an example, if a customer purchases an $100 item for $80 and then returns that item, the Gross Return would be $100 and the $20 markdown would be included in Net Markdowns.

Source Sales » Gross Qty Returned

  • Gross Quantity Returned is the total number of items returned.

Source Sales » # of Items

  • Total number of unique items sold in a period

Source Sales » # of Customers

  • (Customer Count): Number of unique customers entered on transactions.

  • Leaving the customer field blank will count as only one customer no matter how many transactions are rung.

Source Sales » # of Tickets

  • The total number of tickets

Source Sales » Average Transaction Value

  • Net Sales divided by # of Transactions.

  • (Transaction Count): Total number of transactions processed, including tickets and sales orders.

Source Sales » Average Unit Sold Price

  • Net Sales divided by Net Qty Sold.

Source Sales » Units Per Transaction

  • Net Qty Sold divided by # of Transactions.

Source Sales » First Purchase Date

  • The first date the item was purchased in the store

Source Sales » Last Purchase Date

  • The last date the item was purchased in the store

Source Sales » Gift Cards Issued

  • Purchased here but physically provided from another location (location sales)

LOCATION SALES

Location sales are where the item physically gets fulfilled from.

Location Sales » Sell-through

  • Sell-through refers to the percentage of a product that is sold by a retailer after being shipped by its supplier, typically expressed as a percentage.

  • Net sales essentially refer to the same thing, in absolute numbers.

  • Sell-through is calculated during a period (usually 1 month).

Location Sales » Net Sales

  • Net sales are defined as gross sales minus both net markdowns and gross returns.

  • In bookkeeping, accounting, and finance, Net sales are operating revenues earned by a company for selling its products or rendering its services.

  • Also referred to as revenue, they are reported directly on the income statement as Sales or Net sales.

Location Sales » Inventory Turn

  • A measure of the number of times inventory is sold or used in a time period such as a year.

Location Sales » Net Returns

  • Investment’s gross income minus expenses.

Location Sales » Net Qty Sold

  • Net Quantity Sold = Gross Quantity Sold less Gross Quantity Returned

Location Sales » Net Item Sold Cost

  • This is Cost of Goods Sold ( COGS ). It is the average cost your business paid for the items sold at the time of sale, not including other costs like freight.

Location Sales » Net Markdowns

  • Total discounts on items sold, calculated as the difference between the item's Original Price and the selling price.

  • If the item did not have an Original Price, it is calculated as the difference between the item's Current Price and the selling price.

  • If you have returns, the markdown from that return, will be included in this Net Markdown number.

Location Sales » Net Markdowns excluding Price Adjustments

  • Coupon and Promotion discounts, no manual price adjustments

Location Sales » Gross Margin

  • Net Sales less Net Item Sold Cost

  • The difference between NET SALES and COST OF GOODS SOLD.

Location Sales » Gross Margin %

  • Divide gross profit by the revenue. To make the margin a percentage, multiply the result by 100

Location Sales » Sold Margin %

  • Sold Margin divided by Gross Sales

Location Sales » Sold Margin

  • Gross Sales less Net Item Sold Cost, excluding Returns.

Location Sales » Gross Sales

  • Total of all sales transactions by location

  • Gross sales are a grand total of all sales transactions reported in a period, without any deductions included within the figure.

Location Sales » Gross Qty Sold

  • Gross Quantity Sold is the total number of items sold.

Location Sales » Gross Returns

  • Total original retail dollars returned by a customer.

  • This is gross, it does not include markdowns. Return markdowns are included in Net Markdowns.

  • As an example, if a customer purchases an $100 item for $80 and then returns that item, the Gross Return would be $100 and the $20 markdown would be included in Net Markdowns.

Location Sales » Gross Qty Returned

  • Gross Quantity Returned is the total number of items returned.

Location Sales » # of Items

  • Total number of unique items sold in a period

Location Sales » # of Customers

  • Customer Count: Number of unique customers entered on transactions.

  • Leaving the customer field blank will count as only one customer no matter how many transactions are rung.

Location Sales » # of Tickets

  • Transaction Count: Total number of transactions processed, including tickets and sales orders.

Location Sales » Average Transaction Value

  • Net Sales divided by # of Transactions.

Location Sales » Average Unit Sold Price

-Net Sales divided by Net Qty Sold.

Location Sales » Units Per Transaction

  • Net Qty Sold divided by # of Transactions.

Location Sales » First Purchase Date

  • First purchase date of an item at that location

Location Sales » Last Purchase Date

  • Last purchase date of an item at that location

Location Sales » Gift Cards Issued

  • Purchased here but physically provided from another location (location sales)

Item: Price Adjustment » Net Amount

  • Reports the total $ amount of price adjustments that were made to the 'current price' on the items.

  • In the report above items were marked down (the current price on item recorded was changed) by $300. Some will refer to this as Permanent Markdowns.

Item: Price Adjustment » Net Quantity

  • Reports how many items were on hand when the 'current price' was changed on the item record.

Beginning Inventory » Qty Owned

  • Total quantity of stock that is owned

Beginning Inventory » Cost Owned

  • How much the items cost your business to acquire

Beginning Inventory » Price Owned

  • Price owned of inventory

Beginning Inventory » Qty Committed

  • Items owned but committed for sale, either on a sales order or layaway.

Beginning Inventory » Cost Committed

  • Investment on inventory already made and cannot recover

Beginning Inventory » Price Committed

  • The retail price of units committed inventory.

  • EXAMPLE: Open sales order or Layaway

Beginning Inventory » Qty In Transit

  • Total number of SKUs that are currently being shipped from one location to another

Beginning Inventory » Cost In Transit

  • Cost of inventory that has been shipped by the seller, but has not yet been received by the purchaser

Beginning Inventory » Price In Transit

  • Price of inventory that has been shipped by the seller, but has not yet been received by the purchaser

Beginning Inventory » Qty On Hand

The total you have physically available (minus any items that have been “picked” in a sales order

Beginning Inventory » Cost On Hand

  • Cost on hand refers to the stock of on-hand supplies of consumable items that is typically maintained by a business to support its operations.

  • Beginning Inventory » Price On Hand
    Price on hand of beginning inventory(inventory that is physically in-store)

Beginning Inventory » Qty Available

  • How many items you have left if you fulfill all open sales orders and is therefore equal to Qty on Hand (what is left after you have shipped all of your current orders

Beginning Inventory » Cost Available

  • Cost of what is on hand

Beginning Inventory » Price Available

  • The retail price of the inventory

Beginning Inventory » Original Price On Hand

  • Original Price of the item MSRP (Manufacturer's Suggested Retail Price) for Beginning InventoryMetric as of 11:59 pm on the last day of your metric.

  • If your time period includes today, the Current inventory and Ending inventory will match.

Ending inventory

  • The value of goods available for sale at the end of (the date metrics you set), plays an important role in reporting the financial status of a company and can best be figured out using the equation, Beginning Inventory + Net Purchases - Cost of Goods Sold (or COGS) = Ending Inventory.

Ending Inventory » Qty Owned

  • Total quantity of stock that is owned

Ending Inventory » Cost Owned

  • How much the items cost your business to acquire

Ending Inventory » Price Owned

How much you price your items based on the cost to your business to acquire(retail price)

Ending Inventory » Qty Committed

  • Ending inventory items owned but committed for sale, either on a sales order or layaway.

Ending Inventory » Cost Committed

  • Cost of inventory committed (cannot recover)

Ending Inventory » Price Committed

Retail price of inventory committed (cannot recover)

Ending Inventory » Qty In Transit

Quantity of inventory while in transit ( not yet received at a location)

Ending Inventory » Cost In Transit

Cost of inventory while in transit ( not yet received at a location)

Ending Inventory » Price In Transit

Price of inventory while in transit ( not yet received at a location)

Ending Inventory » Qty On Hand

  • Total you have physically available (minus any items that have been “picked” in a sales order

Ending Inventory » Cost On Hand

  • Cost on-hand refers to the stock of on-hand supplies of consumable items that are typically maintained by a business to support its operations.

Ending Inventory » Price On Hand

  • Price on hand for current inventory physically in your store

Ending Inventory » Qty Available

  • Inventory qty available ( will match current)

Ending Inventory » Cost Available

  • Cost of what is on hand

Ending Inventory » Price Available

The retail price of the inventory

Ending Inventory » Original Price On Hand

  • Original Price of the item MSRP (Manufacturer's Suggested Retail Price) for Ending InventoryCurrent: Metric as of right now.

  • This is not useful for most time period comparisons because it always shows the metric's current value regardless of the time period selected.

Current Inventory » Qty On Hand

  • Quantity of current inventory physically in the store

Current Inventory » Cost On Hand

  • Cost on hand refers to the stock of on-hand supplies of consumable items that is typically maintained by a business to support its operations.

Current Inventory » Price On Hand

  • Current Price on hand

Current Inventory » Days Since First Received

  • How many days has it been since your inventory was first received?

  • EXAMPLE: If you received your inventory( shipment 1 of 2) on Monday, and today is Friday (same week) then it would be 4 days.

Current Inventory » Days Since Last Received

  • How many days has it been since you received the same inventory (shipment 2 of 2) in different shipments

Current Inventory » First Received Date

  • What date your current inventory was received on EXAMPLE: 6/15/19 (shipment 1 of 2)

Current Inventory » Last Received Date

  • What date your current inventory was received (shipment 2 of 2)

  • EXAMPLE 6-16-19

Current Inventory » Days Since Last Sold

  • Number of days that have gone by since there was a sale on current item inventory

Current Inventory » Last Sold Date

  • Last sold date of current item inventory

Current Inventory » Original Price On Hand

  • Original Price of the item MSRP (Manufacturer's Suggested Retail Price) for current Inventory

Inventory Adjustments » Net Adjusted Cost

  • Cost after adjustments are made

Inventory Adjustments » Net Adjusted Qty

  • Quantity after adjustments are made

Inventory Adjustments » Net Adjusted Price

  • Price after adjustments are made

Sales Tax » Net Amount Collected (By Location)

  • Amount of Sales Tax Collection by location

Sales Tax » Net Amount Collected (By Source)

  • Amount of Sales Tax Collected by Source

Shipping » Net Shipping Income

  • Shipping Income is the amount you charge a customer for shipping in order to ship that item to your customer.

Payments » Gross Payments

  • Number of payments before any deductions are made

  • Gross Payments are total payments collected and include product sales, gift card sales, shipping income, and sales tax collected.

Payments » Refunds

  • A repayment of a sum of money

Payments » Net Payments

  • Number of payments after deductions are made

  • Net Payments are total payments collected and include product sales, gift card sales, shipping income, and sales tax collected, less return payments.

Payments » #

  • Transactions Number of transactions made

Payments » # Credit Card Transactions

  • Number of payments that were credit card transactions

Payments » Deposits Relieved

  • The location from which the item is being shipped out will receive an alert to fulfill and invoice this sales order.

  • Upon completion, the amount prepaid for the sales order will show up as Deposits Relieved in that store location as well as be added to your Net Location Sales for the day.


Payments » Net Deposits

  • The difference between the Total Deposits and Total Withdrawals you've made for a particular payment method.

  • The Net Deposit figure is worked out simply by taking the Total Withdrawals amount from the Total Deposits amount.

Gift Cards » Beginning Balance

  • Beginning balance of a gift card that has been issued

Gift Cards » Ending Balance

  • Ending balance of a gift card that has been issued

Gift Cards » Gift Cards Expired

  • Issued Gift cards that have met or passed their expiration date

Gift Cards » Net Adjusted Amount

  • Amount remaining after adjustments have been made

Transfers Shipped » Net Price

  • Net Price of inventory included in transfers from one location to the other

  • Net price is the value at which a product or service is sold after all taxes and other costs are added and all discounts subtracted. Net price is what the seller's customers pay.

Transfers Shipped » Net Cost

  • Net cost of the transfers shipped at one location

  • Net cost is the gross cost of an object, reduced by any benefits gained from owning the object.

  • Examples of net cost: The gross cost of a machine, minus the margin on all goods produced with that machine.

Transfers Shipped » Net Qty

  • Quantity of Transfers that were shipped from one location to another

Transfers Received » Net Cost

  • Net cost of the transfers received at one location

Transfers Received » Net Qty

  • Quantity of Transfers that were received from one location to another

Transfers Received » Net Price

  • Net price of the transfers received at one location

Purchasing (as a whole)

  • Purchasing > ___ Month Open Cost (or QTY or Price) on PO: This tells you the open cost, QTY, or Price on PO as of the PO end ship month date.

Traffic » Store Entrance Count

  • Number of customers that have walked through the entrance

Traffic » Zone Count

  • Number of customers that have walked in a specific zone in the store

Traffic » Conversion Rate

  • Sales divided by how many people have walked through your door.

Traffic » Sales per Capita

  • Sales per person

Sales Plans » Amount

  • Amount of your sales plan for the day

Did this answer your question?