The fee for a project lives in several places at once. It's in the signed agreement. It's in the proposal the client said yes to. It's in the accounts software that raises the invoices, and it's in whatever spreadsheet the studio uses to check things quickly.

Each one is there for a reason. The agreement records what was signed. The proposal records what was offered. Accounts needs a figure to invoice against. The spreadsheet exists because the other three are slow to answer a question.

Then a variation gets agreed. Extra scope on the second floor, settled in a meeting on site, and the fee goes up.

Somebody updates the spreadsheet, because that's what was open. Accounts updates a week later. The proposal stays as it was, because it's a historical document and should be. The agreement needs an addendum that nobody has drafted yet.

Four records of one number, and they've stopped matching.

The duplication isn't the problem, which is where this usually gets diagnosed wrongly. Typing a job number into four systems is tedious, and tedious is survivable. A thirty-five person firm absorbs a great deal of tedious.

The problem arrives later, when two of the copies disagree and somebody has to decide which one the firm believes.

It usually shows up first on an invoice. Accounts holds one figure, the tracker holds another, and both look plausible. One includes the variation and one doesn't. So somebody asks a colleague, or finds the email, or goes back through the site minutes, and ten minutes later they have the right number and carry on with their day.

That answer doesn't get written down anywhere. So the next person who needs it starts from the beginning, a few weeks later, usually somebody else.

Nobody made a mistake at any point in that. The information ended up in four places, and nothing anywhere says which of them outranks the others.

Which is worth stating plainly. A firm with the same number in four places doesn't have four records. It has none, in the sense that matters, because a record is something you can point at to end an argument. Four is four claims, and somebody has to settle between them every single time.

None of this was designed. The first project needed a folder. The thirtieth needed accounting software. The spreadsheet appeared somewhere around then, because nobody could get a quick answer out of either. Every one of those was the right call, and at no point did anybody declare which source wins when they conflict, because for years they didn't conflict often enough to matter.

The usual fix is to pick one and make it official. That holds for about a month, and the reason is structural rather than a failure of will.

The official record is almost always the slowest to update. If accounts is the authority, every variation waits for whoever runs accounts. People need the number before that, so they go back to the tracker, and the tracker becomes the real authority again whatever was announced.

So the authority has to be whatever is easiest to update, not whatever feels most official. Firms have that the wrong way round. A record somebody can change in ten seconds while the client is still in the room will beat one that needs a handover, every time, regardless of what the policy says.

There's a way to see where your own firm stands that costs nothing. Take one live project and find every place its current fee is recorded. The agreement, the proposal, accounts, any tracker the team keeps. Check whether they match, and if they don't, time how long it takes to establish which is current.

It isn't an audit and it isn't about finding an out-of-date document. Most principals put the number of places at two or three. It's usually five.

The same exercise works on agreed variations, outstanding payments and which stage a project has reached. Those are the things a team checks most often, which makes them the ones most worth having in a single place.

Projectsmate keeps the fee, the variations and the invoicing against the project itself, so there's one place the number lives and the others become copies of it rather than rivals to it.

Four careful records of one number isn't redundancy. It's four opinions, and somebody in your firm is settling them this week.