🎉 Free 14-day trial — No credit card required.   Start your free trial →
🧾
Free Resource Download Updated: October 2026 (UK Rates & Regulations)

Client Invoicing & Billing Rate Sheet Template

Professional care agency billing spreadsheet with VAT calculations and mileage tracking.

Read Guide

What’s Included in This Resource

  • ✓ Supports council contracted vs private client split rates
  • ✓ Calculates mileage reimbursement and travel time
  • ✓ Includes invoice payment terms agreement clauses

What’s Inside the Care Agency Invoicing Template

Designed specifically for UK care agencies and supported living providers. It connects verified timesheet hours directly into client billing schedules, automates council framework rate cards, and handles split-funding between local authorities and private top-ups.

  1. 1

    Configure Client Contract Rate Cards

    Enter base day rates, waking night premiums, weekend multipliers, and sleep-in stipends per client contract.

  2. 2

    Log Timesheets with Midnight Splitting

    Enter shift start and finish times. For shifts crossing midnight, the sheet dynamically separates hours before and after 00:00 into distinct rate bands.

  3. 3

    Apply Local Authority Split Billing

    Divide care packages between council framework hours (e.g. 20 hrs at £22.50) and private family top-ups (e.g. £5.00/hr) automatically.

  4. 4

    Generate VAT-Compliant Invoices

    Produces sequential invoice numbers (INV-YYYYMMDD-XXXX), calculates VAT status (welfare service exempt vs taxable recruitment), and attaches GPS timesheet proofs.

Typical UK shift rate structures (built into the sheet)

Shift Type Rate Structure Typical UK Rate
Local Authority Domiciliary Framework hourly rate £21.50 – £25.50 / hr
Private Home Care Standard hourly rate £28.00 – £36.00 / hr
Care Home Waking Night Enhanced hourly rate £22.00 – £28.00 / hr
Sleep-In Allowance Flat night stipend £75.00 – £110.00 / shift

Split-Billing Worked Example (Council + Family Top-Up)

Weekly 25-Hour Package (20 hrs Council Framework + 5 hrs Family Extension + £4.50 Top-Up):

Council Framework (20h × £22.50) £450.00
Family Top-Up (20h × £4.50) £90.00
Family Private Extension (5h × £29.00) £145.00
Total Invoice Value £685.00

Generates two distinct PDF invoices with attached timesheets.

Need automated workforce management?

AsanWork automates everything in this resource directly inside our cloud platform.

Start Free Trial →

Get Instant Access

Enter your details to download Client Invoicing & Billing Rate Sheet Template instantly.

We respect your privacy. No spam guaranteed.

Frequently Asked Questions

Direct personal care provided to individuals by CQC-registered providers is generally exempt under HMRC welfare services exemptions. Introductory staffing recruitment services are standard-rated at 20% VAT.
The template includes an integrated Credit Note tab (CN-YYYYMMDD-XXXX) that links directly to parent invoice numbers, satisfying HMRC auditing rules.