Accounting firm CRM: the fields accounting firm CRM software has to hold before it earns its keep

Updated

The question behind an accounting firm CRM is usually not which product to buy but what the record should contain, because a firm that knows the fields can keep them in almost anything and a firm that does not will lose them in the best software made. This page is the list. It is written from the way a small firm actually runs a client, which is as a set of recurring obligations with a fee attached, rather than from the way a sales tool imagines a customer. Each field below is there because its absence has a specific cost, and the order is the order in which that cost usually arrives.

The fee, the date and what it covers

The first field is the fee agreed with the client, the date it was agreed and the services it covers, because that is the firm's revenue and the basis of every future fee review. A fee without a date cannot be reviewed on time; a fee without a scope cannot be defended when the client asks why the year end cost extra. The record should also hold the hours the work actually took and the realization achieved against standard rates, since a fee that looks healthy at standard and realizes at sixty percent is a client the firm is quietly subsidising.

The calendar: runs, filings, year end

For a payroll client the record has to hold the pay frequency and the next run; for every client, the filings the firm has undertaken to make and the year end. Each date needs an owner, a person in the firm rather than a team, and a state that says whether it was done. This is the field that turns a CRM into an operating record, because the firm's week is organised around what is due, not around who last called whom. A view of everything due across all clients, sorted by date, is the screen a practice manager opens first.

The history, so the record outlives the person who made it

Every change to a fee, an owner or a date should keep the previous value, the person who changed it and when. Without that, a firm cannot tell whether a fee was reviewed last year or merely retyped, cannot reconstruct who owned a filing when it was missed, and cannot hand a client to a new manager with any confidence about what was promised. History is also what makes the client book a saleable asset rather than a spreadsheet of names.

What to leave out

Leave out anything the firm will not maintain. Lead scoring, activity logging of every email, and pipeline stages for a client who has already signed are fields that a sales CRM insists on and an accounting firm abandons within a month, after which the record is half-filled and trusted by nobody. The record described here is small on purpose. It can be kept up to date by the person who does the work, at the moment the work is done, which is the only condition under which any client record stays true.

Questions people ask about accounting firm crm

Does accounting firm CRM software need to integrate with the ledger?

It helps to push what was billed into the firm's own books without rekeying, and the paid plan here does that. It does not need to read the client's ledger; the client's accounting stays in the client's accounting software.

Where does the fee on the record come from?

From the firm's own arithmetic: hours at standard rates blended across partner, manager and staff, realized at what the firm actually bills. The free blended rate worksheet on this site works it for any engagement.

Can the record leave with the firm?

It must. Every client and its calendar should export as a CSV at any time, because a client book that cannot leave the software is the software's, not the firm's.

Sources

Related answers

Start Yearendo ProKeep the client book, not the spreadsheet