← All prebuilt solutions
Industry

Nursery Funded Hours & Fees Calculator

Funded childcare hours, parent fees, stretched or term-time funding and what the government funding really pays you per hour

£20

Secure checkout. Your file is ready in your client portal as soon as payment clears.

Nursery Funded Hours & Fees Calculator

Overview

With more children on funded hours, most of a nursery's income now comes from local authority funding paid at a fixed rate. This workbook shows what each child brings in, and whether the funding covers what it costs you to provide each hour.

Price
£20
Who it’s for
Industry
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Children

Each child's hours, funding and fees. What you do: one row per child.

Children
Settings

Step 2

Settings

Your rates, funding rates and weeks. What you do: set up once.

Step 3

Guide

How funded hours work. What you do: read when you start.

Guide

Step 4

Who it is for

Made for people like you

  • Example – text
  • Nurseries and pre-schools – Work out each child's invoice correctly.
  • Childminders – Explain funded hours and extra charges to parents.
  • Nursery owners – See what funding pays against your fees.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Your hourly rate, the weeks you are open, your local authority's funding rates and your cost per child-hour.
  2. Children – Each child with date of birth, entitlement, term time or stretched, weeks attending, hours booked and any optional extras.
  3. Dashboard – Fees, funding, income per hour and any shortfall.

Key features

  • Works out each child's age band and funded entitlement – working-parent 30 hours from 9 months, universal 15 hours for 3 and 4 year olds, and 15 hours for eligible 2 year olds.
  • Spreads funding across term time or stretched weeks, separates funded and chargeable hours, and gives the monthly parent bill including optional extras.
  • Shows your funding income, income per hour against your cost per hour, and the profit or shortfall for each child and the setting.

What’s included

  • Dashboard – Income at a glance
  • Settings – Rates and funding
  • Children – Each child
  • Guide – How to use this workbook

How buying works

Your file is only released to your client portal once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your file is ready in your client portal as soon as payment clears, and we email you your invoice with a link to the portal.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions