Book a call

Free templates

Free Excel templates for UK small businesses and charities

Built by a chartered management accountant who has spent fifteen years producing these reports for real organisations. Each one comes with sample figures so you can see how it works, and checks that tell you when something doesn't add up.

  • Works in Excel and Google Sheets
  • Formulas locked, so nothing breaks
  • Free: just confirm your email
Bookkeeping dashboard showing money in, costs, profit by month and MTD quarter deadlines for a sample business
Shown with sample figures. Replace them with your own.
Sole traders & landlords

MTD Bookkeeping Workbook

Simple records for a self-employed business and a rental property, set out the way Making Tax Digital for Income Tax expects them. It starts from 6 April 2026 for people with qualifying income over £50,000, and from April 2027 for those over £30,000.

  • Money in, money out and mileage, with HMRC's mileage rates worked out for you
  • Quarterly totals laid out ready to submit through MTD bridging software
  • A dashboard showing profit by month, your biggest costs and the next deadline
  • A rough tax estimate, so you know what to put aside
Get it free

You'll get one email asking you to confirm your address. Click the button in it and the download starts. You don't need to tick the box to get the template. I use your details as set out in my privacy notice.

Management accounts dashboard with turnover, profit and cash charts and a budget comparison table
Shown with sample figures. Replace them with your own.
Small companies

SME Management Accounts Pack

Paste in your monthly trial balance and get a full set of management accounts: results against budget and last year, a balance sheet, cash and the ratios a lender or board will ask about.

  • Profit and loss, balance sheet and cash flow for the month and year to date
  • Budget and prior-year comparisons, with variances flagged
  • KPIs including gross margin, debtor days and months of cash in hand
  • Seven built-in checks, so you know the pack adds up before it goes out
Get it free

You'll get one email asking you to confirm your address. Click the button in it and the download starts. You don't need to tick the box to get the template. I use your details as set out in my privacy notice.

Key figures page for a sample company showing turnover, profit, net assets, ratios and comparison charts
Shown with sample figures. Replace them with your own.
Small companies

SME Financial Statements

Year-end accounts for a small UK company or micro-entity, built from your trial balance. Useful for directors who want to see the numbers properly before they sign, or to check a draft from their accountant.

  • Profit and loss account and balance sheet in the FRS 102 Section 1A format
  • A one-page micro-entity version (FRS 105)
  • Thirteen notes, including a fixed asset table
  • A corporation tax estimate with marginal relief, plus nine built-in checks
Get it free

You'll get one email asking you to confirm your address. Click the button in it and the download starts. You don't need to tick the box to get the template. I use your details as set out in my privacy notice.

Charity management accounts dashboard showing income, spending by fund and reserves for a sample trust
Shown with sample figures. Replace them with your own.
Charities

Charity Management Accounts Pack

Monthly reporting for trustees, in the shape of the SORP: income and spending by fund, restricted money kept separate, and a reserves position you can explain.

  • Income and expenditure, a SOFA by fund and a funds analysis
  • Free reserves worked out in pounds and in months of spending
  • Budget and prior-year comparisons for trustees' meetings
  • Ten built-in checks, including funds agreeing to the balance sheet
Get it free

You'll get one email asking you to confirm your address. Click the button in it and the download starts. You don't need to tick the box to get the template. I use your details as set out in my privacy notice.

SORP 2026 readiness dashboard showing the charity's tier, progress by area and upcoming actions
Shown with sample figures. Replace them with your own.
Charities

SORP 2026 Readiness Checklist

The new Charities SORP applies to accounting periods beginning on or after 1 January 2026. This checklist helps finance teams and trustees work out what changes for them and plan the work.

  • A tier finder based on your gross income
  • A 45-point checklist covering the trustees' report, income, leases, reserves and disclosures
  • A lease register to estimate the effect of bringing leases onto the balance sheet
  • An income review for sorting exchange and non-exchange income
Get it free

You'll get one email asking you to confirm your address. Click the button in it and the download starts. You don't need to tick the box to get the template. I use your details as set out in my privacy notice.

Investment summary for a sample community interest company showing the raise, five-year figures, impact targets and cash charts
Shown with sample figures. Replace them with your own.
Social enterprises & CICs

Social Enterprise Funding Kit

For a social enterprise or CIC getting ready to raise money. Build a five-year plan, see exactly how much you need to raise, and compare a grant, a loan, revenue participation and equity before you talk to investors.

  • A five-year forecast with cash flow and balance sheet, and your funding gap worked out
  • Loan, revenue participation and equity compared side by side, year by year
  • An impact page for your theory of change and targets
  • A draft term sheet with a plain-English guide, a 31-point readiness checklist and 12 built-in checks
Get it free

You'll get one email asking you to confirm your address. Click the button in it and the download starts. You don't need to tick the box to get the template. I use your details as set out in my privacy notice.

Thirteen-week cash flow dashboard for a sample charity showing weekly balances, the lowest point and the biggest one-off items
Shown with sample figures. Replace them with your own.
Small businesses & charities

13-Week Cash Flow Forecast

See your bank balance for every week of the next three months, spot the tight weeks early, and test what happens if money comes in late. Roll it forward each week and compare it with what really happened.

  • Your bank balance at the end of each of the next 13 weeks
  • Regular payments and receipts that schedule themselves, plus one-offs marked by how sure you are
  • Actuals against forecast, week by week
  • A stress test for late or lower receipts, the weeks to watch flagged, and 10 built-in checks
Get it free

You'll get one email asking you to confirm your address. Click the button in it and the download starts. You don't need to tick the box to get the template. I use your details as set out in my privacy notice.

Good to know

Before you download

These templates help you keep records and prepare reports. They aren't advice, and they don't replace an accountant or independent examiner where you need one. The figures you enter, and anything you file, are your responsibility.

Each template opens with a short "Start Here" page. You type into the shaded cells; everything else is worked out for you.

Are they really free?

Yes. You give me your email address so I can send you the file, and that's it. You'll only get marketing emails from me if you tick the box.

Do they work in Google Sheets?

Yes. Upload the file to Google Drive, open it, then choose File, then Save as Google Sheets.

Why can't I edit some cells?

The formulas are locked so they can't be typed over by accident. Everything you need to fill in is in the shaded cells. You can still filter lists and widen columns.

The email hasn't arrived

Give it a few minutes and check your spam or promotions folder. If it still isn't there, email [email protected] and I'll send the file directly.

Can you help me set one up?

Yes. If you'd like a hand getting your own figures in, or want the reporting done for you, get in touch.