← All prebuilt solutions
Tax & Company

R&D Tax Relief Estimator

The merged R&D expenditure credit and ERIS – for accounting periods beginning on or after 1 April 2024

£20
Buy nowAsk a question

Secure checkout. Your download link is sent as soon as payment clears.

R&D Tax Relief Estimator

Overview

For accounting periods beginning on or after 1 April 2024, the old SME and RDEC schemes were replaced by two reliefs: the merged R&D expenditure credit scheme (a taxable credit of 20% of qualifying spend for every company) and enhanced R&D intensive support, ERIS (an extra 86% deduction and a 14.5% payable credit for loss-making SMEs that spend at least 30% of their costs on R&D). Getting a claim right means identifying the projects that really are R&D, apportioning staff time, applying the rules for contractors, agency staff and overseas work, testing intensity, working through the payment steps and meeting strict deadlines for the claim notification and additional information form. This workbook does all of that and shows which scheme gives you more.

Price
£20
Who it’s for
Tax & Company
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

Claim Setup

The company, period, profits, SME and intensity figures, PAYE and claim dates. What you do: fill in once per period.

Claim Setup
Projects

Step 2

Projects

The project register and narratives, with qualifying costs pulled from the other sheets. What you do: add each project and its narrative.

Step 3

Staff Time

Staff costs and time on each project. What you do: add each person and their time split.

Staff Time
Other Costs

Step 4

Other Costs

Every other R&D cost with the restrictions applied. What you do: add each invoice or monthly total.

Who it is for

Made for people like you

  • Example – text
  • Technology, engineering, life-science and software companies – A clear estimate of the claim and the cash it brings in, worked out from your own projects and payroll.
  • Finance directors and founders – Merged RDEC and ERIS side by side, the deadlines that make or break a claim and the items to tidy up first.
  • Technical leads – A project register in the format HMRC's additional information form asks for – baseline, advance, uncertainty, approach and competent professional.
  • Accountants and advisers – An audit trail from each person and invoice to the qualifying total, with every restriction shown.

Quick start

Up and running in minutes

  1. Example – text
  1. Claim Setup – Enter the company name, accounting period, the adjusted trading result before R&D relief, other profits, losses brought forward, the SME and intensity figures, PAYE and NIC, and the claim administration dates.
  2. Projects – List each project with its field, dates, status and who decided to do the R&D, and write the baseline and advance, the uncertainty, how you tackled it and the competent professional.
  3. Staff Time – Add everyone who worked on R&D: salary, employer pension and (optionally) employer NIC, and up to three project IDs with the % of their time on each.
  4. Other Costs – Log externally provided workers, subcontracted R&D, consumables, software, data & cloud and clinical trial volunteers, with the project, connected status and where the work was done.
  5. Claim Calculation – Check the qualifying expenditure, the ERIS tests, both schemes and the deadlines.
  6. Review – Work through 'Items to check before you claim' on the Dashboard, then send the claim notification (if needed) and the additional information form before the return.

Key features

  • A project register for 60 projects with the baseline, advance, uncertainty and competent professional, a narrative check and which projects the additional information form must describe.
  • A staff time apportionment log for 200 people across up to three projects each, and a cost log for 400 items with the merged scheme rules for contractors, externally provided workers and overseas work.
  • The R&D intensity test (30% with the grace year), the RDEC payment steps (notional tax at 19% or 25%, the PAYE cap) and ERIS (86% extra deduction, 14.5% payable credit) side by side.
  • Claim notification, additional information form and filing deadlines, six profit-and-loss scenarios and a dashboard.

What’s included

  • Dashboard – Benefit, deadlines and items to check
  • Claim Setup – Company, period and figures
  • Projects – Project register and narratives
  • Staff Time – Staff costs and time on R&D
  • Other Costs – Workers, contractors, consumables, software, data
  • Claim Calculation – Qualifying spend, tests, RDEC and ERIS
  • Scenarios – Profit v loss comparison
  • R&D Rules – Rates and limits
  • Tax Rates – Corporation tax and NIC rates
  • Guide – How to use this workbook

How buying works

Your file is only released 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 download link arrives as soon as payment clears.

Explore the range

Trial Balance to Accounts Mapper

Trial Balance to Accounts Mapper

Turning a trial balance into statutory accounts means mapping every account to the right heading, posting year-end adjustments, and then building a profit and loss account, balance sheet and notes in the format the Companies Act requires – for this year and last year.

£20
View details →
Staff Appraisal & Performance Tracker

Staff Appraisal & Performance Tracker

Good appraisals are fair, consistent and joined up: objectives agreed at the start of the year, regular 1-to-1s, honest ratings against a clear competency framework, a calibration meeting so one manager's…

£20
View details →
Practice Timesheet & WIP

Practice Timesheet & WIP

An accountancy practice sells time, but most of its fees are fixed.

£20
View details →

Need it tailored to your business?

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

Custom spreadsheetsTalk to us

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
AccountsTax compliance and planningBookkeeping and VATPayroll and CISCloud accounting softwareBusiness growth and planning

Get In Touch

We're open Monday to Friday, 9am – 5pm. Call our Plymouth office on 01752 42 72 82 or send us a message below, whether it's about consultancy, spreadsheets or our document templates.

Services
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Quick Links

Business ConsultancyCustom SpreadsheetsPrebuilt Spreadsheet SolutionsBusiness Document TemplatesAbout UsTestimonialsInsightsFAQsContactAccountancy – AML Accountancy Solutions

Company information

Offices
Plymouth
First Floor, Unit D2, 4 Neptune Park, Plymouth, PL4 0SJ
Phone Number
01752 42 72 82
Email
info@amlconsultancysolutions.co.uk
Opening hours
Monday to Friday: 9:00 am to 5:00 pm

Legal

Privacy PolicyCookies PolicyDisclaimer PolicyTerms and ConditionsComplaints ProcedureAccessibility Statement

AML CONSULTANCY SOLUTIONS LTD
Registered Address: First Floor, Unit D2, 4 Neptune Park, Plymouth, United Kingdom, PL4 0SJ. Company Number: 12747461