← All prebuilt solutions
Practice Tools

Client Onboarding & Year-End Checklist

A practice tool for UK accountants and bookkeepers – from engagement letter to tax paid

£20

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

Client Onboarding & Year-End Checklist

Overview

Taking on a client properly and getting their year end out on time involve dozens of small steps – engagement letters, professional clearance, identity checks, agent authorisations, Companies House codes, bank feeds, then records, reconciliations, reviews, approval, filing and payment. Miss one and you risk a regulatory breach, a penalty for the client or an unhappy partner. This workbook gives every client a checklist for both stages, greys out the steps that can't apply, works out the filing and payment deadlines, and rolls everything up into a master tracker and a dashboard that shows where work is stuck and who is carrying it.

Price
£20
Who it’s for
Practice Tools
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

Clients

One row per client – the details that decide which steps apply. What you do: enter the yellow columns.

Clients
Onboarding

Step 2

Onboarding

The 19-step onboarding grid, one row per client (same row as on Clients). What you do: type dates or pick Requested / In progress / N/A.

Step 3

Year-End Jobs

One row per client per period with 18 steps, deadlines and status. What you do: add a row for each job and date each step.

Year-End Jobs
Master Tracker

Step 4

Master Tracker

Every client on one line: onboarding %, latest year-end job, next deadline, overdue items, overall RAG and what needs doing. What you do: nothing to enter – filter and sort it.

Who it is for

Made for people like you

  • Example – text
  • Small and mid-sized accountancy practices – One place to see every client's onboarding and year-end position, with a red / amber / green status per client.
  • Bookkeeping practices – A disciplined onboarding routine – customer due diligence, authorisations, software and bank feeds – and a year-end hand-over checklist.
  • Practice managers and partners – Pipeline by stage, bottlenecks, overdue items and team workload on one dashboard.
  • Anti-money laundering compliance – Evidence that identity, beneficial ownership and the client risk assessment were done before work started – with a printable, signed checklist per client.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Type your practice name, leave the 'as at' date as =TODAY(), check the four workflow targets (onboarding days, records chase, turnaround and deadline warning) and list your team with their roles.
  2. Clients – Add one row per client: entity type, partner, manager, company number and year end for companies, the services you provide (VAT, payroll, CIS, Self Assessment, MTD for Income Tax), software, whether there's a previous accountant, the date you were engaged and the fee. Copy the anti-money laundering risk rating and date from your client risk assessment.
  3. Onboarding – For each new client, type the date each step is done – or pick Requested, In progress or N/A. Fill in the identity details (people to verify, method, document, address evidence) and the PSC check result.
  4. Year-End Jobs – Add one row per client per period: pick the client, type the period end, choose who prepares and reviews it, then date each step as it's done.
  5. Work from the Dashboard and Master Tracker – Each morning, look at the overdue and at-risk list, chase anything waiting for records, and use the bottleneck chart in your weekly workflow meeting.
  6. Print the Client Checklist – Pick a client, print the one-page checklist and get it signed for the permanent file.

Key features

  • 19-step onboarding checklist per client: engagement letter, clearance, ID & address checks, PSC register, risk assessment, agent authorisations, Companies House ID, MTD, bank feeds, software and more.
  • 18-step year-end checklist per client and period – records, preparation, review, sign-off, approval, filing and tax paid – with Companies House and HMRC deadlines worked out automatically.
  • Steps that can't apply to a client are greyed out and ignored, so % complete is always a fair measure.
  • Master tracker with a red / amber / green status per client, a printable checklist with sign-off, and a dashboard of pipeline, bottlenecks and team workload.

What’s included

  • Dashboard – Pipeline, bottlenecks and workload
  • Settings – Practice, targets and team
  • Clients – One row per client
  • Onboarding – New-client checklist grid
  • Year-End Jobs – One row per client per period
  • Master Tracker – Every client on one line
  • Client Checklist – Pick a client – print with sign-off
  • 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

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