Reporting and Analytics Glossary
Browse this list to get a deeper understanding of terminology used in business reporting. Check out the use cases to see how they work within day to day operations.
Examples: Coffee, sandwich, bracelet or notebook to be sold at the register.
ShopKeep Reporting: Asset items are included in sales calculations and reports.
See Also: Liability Item, Liabilities and Redemptions
Example: Two apples and one orange are sold, the number of items in the sale is three.
Calculation: (Total quantity of items sold) / (number of sales).
Use Case: Understand the dollar amount collected on a typical sale.
Calculation: (Total transactions amount – discounts) / (total transaction count).
Use Case: Understand how much profit a given sale will generate.
Calculation: (Line item costs * quantity of sales) – (line item costs * quantity of returns)
Example: A merchant pays $1 for an item to add to inventory, at this time.
Use Case: A customer pays $1 for an item at this time.
Use case: Adjustment pricing for special offers to encourage customer purchases or reward loyalty.
Example: An item is sold at a $10 cost. The item is sold again later at a cost of $20. The effective unit cost of the item for this date range is $15.
Calculation: (Total net cost / net quantity sold).
Example: A single unit of an inventory item is sold at a price of $10. The item is repriced at $20 and another single unit is sold. The effective unit price of the item for this date range is $15.
Calculation: (Gross sales / quantity sold).
ShopKeep Reporting: Total gratuity amount collected on credit card transactions.
Use Case: Understand the percentage of sales that are profit.
Calculation: (Net sales – costs) / (net sales).
Use Case: Understand the dollar amount a merchant gets to keep for a given selling period.
Calculation: (Net sales) – (costs).
Use Case: Use as a raw, top line sales metric.
Calculation: (Price of asset items) * (quantity sold).
Example: A merchant had a single transaction, selling a $100 gift card for cash. Net Sales: $0, New Liabilities: $100, Cash Tenders: $100. Later, a customer comes in and uses the gift card to buy a $50 shirt. Net Sales: $50, Net Liabilities: $50 ($100 minus $50 in redeemed gift card liabilities), Gift Card Tenders: $50.
Use Case: Understand how much revenue was brought in during a given period.
Calculation: (Total sales amount) – (total discounts amount) – (total returns amount).
Use Case: Understand the final amount received of each tender.
Calculation: (Sales amount tendered) – (Returns amount tendered).
Use Case: Understand item sales amounts not subject to tax, typically for tax reporting purposes.
Example: Additional cash added to the drawer to provide customers with change.
Use Case: Cash removed from drawer for gratuity of staff, inventory purchases, etc.
ShopKeep Reporting: Total quantity of returned items or sets of items.
ShopKeep Reporting: Total quantity of sold items or sets of items.
Use Case: Analyze top line sales and returns.
Calculation: (Quantity sold * price).
Use Case: Understand how many sales or returns transactions were completed.
Calculation: (Sum of taxes on sales) – (sum of taxes on returns).
Calculation: (Sum of taxable sales amount) – (sum of taxes on return amounts).
Example: A customer purchases a sandwich for $5, pays with a $20 dollar bill, and receives $15 in change. The total tendered amount of this transaction is $5.
Calculation: (Sales amount tendered) – (returns amount tendered).
Use Case: Understand how many transactions are run to adjust staffing or business hours.
Example: A merchant purchases an item to add to inventory for $100.
See also: Current Unit Cost, Effective Unit Cost
Example: The price a customer pays for an item is $100.