All templates

CRM Excel Template for Practice Clients

Build a local client register with linked engagements and an editable Excel dashboard.

Client records

Paste CSV with the supplied headings. Up to 500 client rows.

Link each engagement to a client ID. Use ISO dates and up to 500 rows.

Records stay in this tab. Download before leaving. Keep TFNs, identity documents and passwords outside the register.

CRM workbook

Blank template

Download an empty workbook or load the fictional example.

Download preview

Clients, Engagements, Dashboard, Follow-ups and Instructions.

Review date: . Workbook capacity: 500 clients and 500 engagements.

Set Up Clients and Engagements

This CRM Excel template keeps one client contact record and links separate engagements to it. Enter your records locally, inspect the download preview and export the editable workbook.

Keep the supplied CSV headings. Add one client per row with a unique client ID and name. IDs accept up to 40 letters, digits, hyphens or underscores.

Contact and email are optional. Use the client ID on every engagement for the same client. Review and due dates run from 1900 to 9999, excluding the first two months of 1900.

Each engagement needs its own ID, work description, stage and responsible staff member. For a next action, enter its due date in ISO format and use Yes or No under Action done.

Load example uses fictional records. Use local reference IDs and keep unnecessary sensitive information out of the register. The browser clears these entries when you leave or reload.

Use the Dashboard and Follow-Ups

The dashboard counts open engagements by stage. Completed and Closed engagements are excluded. An action is overdue when its due date precedes the review date and Action done is No.

The fictional example has two clients and three engagements. Two engagements remain open, with one overdue action. Each follow-up retains its engagement ID, client ID and responsible staff member.

To progress engagement E001, change Enquiry to Accepted, then In progress as work begins. Keep its action and due date until the action is completed. Mark Action done Yes and enter the next action when needed.

When work finishes, change the engagement to Completed. Client C001 stays in the client table for later work. Add the next engagement with a new engagement ID and reuse C001.

Export the Working Template

Download Excel produces an editable .xlsx workbook with five sheets. The blank template keeps headings and working formulas. The fictional example includes populated source rows. Both downloads work without an account.

Clients and Engagements hold source records. The Dashboard counts stages and overdue actions. Follow-ups links the source engagement rows; filter its Overdue column to see late actions. Change the Dashboard review date as you review the register.

The workbook supports 500 clients and 500 engagements. Its lists check client IDs, stages and action completion. Extend formulas and validation before exceeding those rows. Keep calculated columns I and J intact.

Download the two CSV files for portable source rows. CSV excludes workbook formulas, validation, sheet links and dashboard views. Formula-like text receives a protective leading apostrophe. Microsoft explains these limits in its CSV import and export guidance.

Google Sheets can import an Excel workbook. After conversion, compare stage totals, overdue actions and dropdowns with the download preview. CSV import carries source fields only. Google documents the Excel-to-Sheets import options.

Control and Correct the Register

Keep the workbook in a restricted practice folder and give access only to staff who need it. Use controlled document links for supporting records. Store identity documents and credentials in the practice’s approved systems.

Before correcting the register, save a recoverable copy. To merge duplicate clients, change affected engagement client IDs to the retained client ID first. Confirm the engagements still show the correct client, then remove the duplicate contact.

Correct a mistaken stage in the original engagement row. Mark a completed action Yes so it leaves the follow-up view. Recalculate and compare the dashboard with the source rows after corrections or imports.

This local workbook relies on your staff updating records. It has no automatic reminders or hosted audit history. Tax Genie checks client information, follows up missing answers and prepares the engagement handover into your tax software.