Retail Template


The retail template combines some of the key metrics retail businesses should focus on. These metrics are split across the Retail Financial Metrics and Retail Sales Metrics pages in Spotlight. To make the most of the retail template, you will need to:

  1. Source non-financial data
  2. Assign specific report codes to key accounts
  3. Evaluate the formulas and customise using the formula builder if necessary. (Some retail businesses may measure these metrics differently due to seasonality, setup of accounts or other factors.)

Non-financial data required

Most retail metrics require financial and non-financial data. Therefore, you will need to collate and enter the following non-financial information into Spotlight:

  • Number of sales transactions
  • Number of items sold
  • Store size
  • Number (or value) of online and store sales

You can manually enter the data into the non-financial tab under Customise Data. Alternatively, enter the data into this Excel template and import it into Spotlight using the excel import function on the Import tab.

Assign specific report codes to key accounts

Most report codes needed for the template are automatically assigned by Spotlight. However, for the metrics to calculate correctly you may need to assign some report codes manually. To do this, open Customise Data and locate the following accounts, then to assign the specified report code click the report code button:

  • Direct wages - EXP.COS.WAG (Expenses > Cost of goods sold > Direct wages)
  • Purchases - EXP.COS.PUR (Expenses > Cost of goods sold > Purchases)
  • Stock - ASS.CUR.INY (Assets > Current assets > Inventory)

Retail Financial Metrics Page

Materials Cost to Revenue

materials cost to revenue

Formula: (Cost of goods sold - direct wages) / trading revenue * 100

Report codes used: EXP.COS, EXP.COS.WAG, REV.TRA

Direct Wages Cost to Revenue

direct wages cost to revenue2

Formula: Direct wages / trading revenue * 100

Report codes used: EXP.COS.WAG, REV.TRA

Top Three Cost of Sales - This Year

top three cost of sales

Formula: Cost of sales [YTD]

Report codes used: EXP.COS

Stock Turn - Last 12 Months

stock turn

Formula: Purchases / average closing inventory

Report codes used: EXP.COS.PUR, ASS.CUR.INY

Retail Sales Metrics Page

Sales Transactions

sales transactions

Formula: Sales transactions

Report codes used: SAL.TRA

Average Revenue per Transaction

basket spend

Formula: Trading revenue / sales transactions

Report codes used: REV.TRA, SAL.TRA

Units Per Transaction

units per transaction

Formula: Items sold / sales transactions

Report codes used: SAL.ITE, SAL.TRA

Sales Per Square Metre

sales per square metre

Formula: Trading revenue / operation size

Report codes used: REV.TRA, OPR.SIZ

Sales Type

sales type

Formula: In-store sales against online sales

Report codes used: SAL.STO, SAL.ONL

Still need help?
Get in touch!