Retail Template
- Overview
- Non-financial data required
- Assign specific report codes to key accounts
- Retail Financial Metrics Page
- Retail Sales Metrics Page
Overview
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:
- Source non-financial data
- Assign specific report codes to key accounts
- 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
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
Formula: Direct wages / trading revenue * 100
Report codes used: EXP.COS.WAG, REV.TRA
Top Three Cost of Sales - This Year
Formula: Cost of sales [YTD]
Report codes used: EXP.COS
Stock Turn - Last 12 Months
Formula: Purchases / average closing inventory
Report codes used: EXP.COS.PUR, ASS.CUR.INY
Retail Sales Metrics Page
Sales Transactions
Formula: Sales transactions
Report codes used: SAL.TRA
Average Revenue per Transaction
Formula: Trading revenue / sales transactions
Report codes used: REV.TRA, SAL.TRA
Units Per Transaction
Formula: Items sold / sales transactions
Report codes used: SAL.ITE, SAL.TRA
Sales Per Square Metre
Formula: Trading revenue / operation size
Report codes used: REV.TRA, OPR.SIZ
Sales Type
Formula: In-store sales against online sales
Report codes used: SAL.STO, SAL.ONL
Â