The Childcare template combines some of the key metrics childcare businesses should focus on. These metrics are split across the Childcare - Financial Metrics and Childcare Metrics pages in Spotlight. To make the most of the template, you will need to:
Most childcare metrics require financial and non-financial data. Therefore, you will need to collate and enter the following non-financial information into Spotlight:
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.
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 financial 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:
Formula: Trading Revenue / Total Customers
Report codes used: REV.TRA, CUS.TOT
Formula: Direct Wages / Trading Revenue * 100
Report codes used: EXP.COS.WAG, REV.TRA
Formula: Cost of Goods Sold / Trading Revenue * 100
Report codes used: EXP.COS, REV.TRA
Formula: Cost of Sales
Report codes used: EXP.COS
Formula: Expenses - Cost of goods sold - Wages and salaries - Income tax expense
Report codes used: EXP, EXP.COS, EXP.WAG, EXP.TAX
Formula: Sales - Transactions (Actual) / Sales Transactions (Target) * 100
Report codes used: SAL.TRA
Formula: Total Customers
Report codes used: CUS.TOT
Formula: New Customers
Report codes used: CUS.NEW
Formula: Sales - Referrals
Report codes used: SAL.REF
Formula: Customer Satisfaction
Report codes used: CUS.SAT
Formula: Staff - Departures (rolling 12 months) / Staff - Total (average, rolling 12 months) * 100
Report codes used: STA.DEP, STA.TOT
