When Every Accountant Uses a Different Workpaper Template

Most accounting firms have at least a few spreadsheets that have been passed around, modified and gradually improved over the years. Some accountants have been using the same templates for so long that they know them inside out. They know which figures need checking, where to find supporting calculations and which cells shouldn't be touched.

There's nothing particularly wrong with that. In fact, some of these spreadsheets are probably very good. The problem is that what works perfectly well for one accountant might be unnecessarily confusing for everyone else.

When it comes to working papers accounting, consistency becomes particularly important when files need to be reviewed, handed over or picked up by someone who wasn't involved in preparing them.

The Problems Usually Appear When Someone Else Opens the File

Imagine an accountant has been preparing the same client's accounts for five years. They've developed their own spreadsheet, complete with colour-coded cells, additional schedules and a few formulas that save them time.

Then they go on leave, and another member of the team needs to finish the job.

Suddenly, something that normally takes twenty minutes becomes an hour of figuring out how the spreadsheet works. Are the yellow cells outstanding items or completed checks? Why does one figure link to another worksheet while a similar figure has been entered manually? And where are the notes explaining last year's adjustments?

None of these issues necessarily mean the original accountant has done anything incorrectly. Their system might be perfectly logical once you understand it. But a workpaper shouldn't require a personal introduction from its creator every time somebody else needs to use it.

This becomes particularly frustrating during busy reporting periods, when senior accountants and managers may be reviewing files prepared by several different team members.

Different Templates Can Create Different Standards

The layout isn't always the biggest concern. Different spreadsheets can also lead to differences in how work is documented and checked.

One accountant might include a reconciliation showing exactly how they arrived at a balance. Another might simply reference the supporting document. Someone else may have built an additional check into their spreadsheet after discovering an error on a previous job.

These differences can make reviews unnecessarily complicated. A manager who regularly checks files from several accountants shouldn't have to remember a different set of conventions for each person.

Version control creates another headache. If everyone maintains their own copy of a template, improvements and corrections aren't necessarily shared. One employee could be using an updated formula while another is still working with the original calculation.

Even worse, mistakes in an older template might continue to be repeated simply because nobody has realised that other versions exist.

Standardisation Doesn't Mean Every Job Has to Look Identical

There's a reasonable objection to introducing a single template across an accounting firm. Not every client is the same, and accountants need enough flexibility to deal with different circumstances.

A small business with straightforward transactions won't necessarily need the same supporting schedules as a company with several entities, complicated adjustments or unusual reporting requirements.

Trying to force both jobs into an identical set of worksheets can waste time and encourage staff to create their own workarounds.

A better approach is to standardise the things that genuinely need to be consistent. Accountants should be able to recognise where supporting evidence belongs, how adjustments are explained, which checks have been completed and who reviewed the work.

Beyond that, there should still be room to add schedules, remove irrelevant sections and document anything unusual about the client.

The intention is to make the work understandable to the next person, not dictate every detail of how an accountant does their job.

Make Use of the Templates People Already Have

Before introducing a new firm-wide template, it's worth looking at what the team is currently using.

An accountant who's spent years refining a spreadsheet may have developed some genuinely useful features. Perhaps they've added a reconciliation that catches common mistakes, organised supporting documents particularly well or found a clearer way to explain adjustments.

Those improvements shouldn't be discarded simply because the firm wants everyone working from the same starting point.

Getting experienced accountants involved in developing shared templates also makes the change easier to introduce. They're much more likely to use something they've helped improve than a replacement that's been handed down without any discussion.

It's also worth asking newer employees to test the templates. They tend to notice unclear labels, missing instructions and confusing layouts that experienced staff have learned to work around.

Ultimately, the test is fairly straightforward. If an accountant can open a colleague's workpaper, understand what's been done and continue the job without needing a lengthy explanation, the template is doing what it should.

‍