Payroll in the tax firm: when the client's spreadsheet becomes a monthly problem

Every tax accounting firm that runs payroll knows the moment: the client sends their timesheet. A spreadsheet grown over years, with merged cells, colour codes instead of fields and a separate tab for every special case. The firm’s software – BMD, RZL or another – expects a clean import structure instead. In between sits a staff member who transfers, checks and corrects. Every month. For every client.

Why the problem does not go away

The obvious idea is: the client should deliver proper lists. Anyone who has tried knows how that ends. The client is a trades business, a restaurant, a retailer – their timesheet is a by-product of their daily work, not a data format. Templates get ignored, modified, or forgotten after three months.

The second reaction is software-change fantasy: a new system that does everything. But the firm sticks with its software for good reasons – history, interfaces to the tax authorities, established routines. Switching because of timesheets would be like tearing down the house because the door sticks.

Close the gap, do not replace the systems

The third way is an overlay: an intermediate layer that accepts the client’s spreadsheet, checks it and translates it into the import format of the firm’s software. The spreadsheet may stay chaotic, the firm’s software stays untouched – the automation works in between.

Concretely: the timesheet is read in and every row is checked. What is plausible is accepted. What is missing or contradictory – missing hours, duplicate entries, unclear supplements – is flagged and presented to the clerk for a decision. The result is an error-free import file in BMD or RZL format.

Professional control stays inside the firm. The overlay removes the transfer work, not the responsibility for payroll. You can try this live with the Kanzlei-Brücke (demo in German).

What this means economically

The calculation runs per client: how many minutes does transferring and checking one timesheet cost, times twelve months, times the number of payroll clients. In many firms this adds up to a workload that binds whole days per month – in precisely the area where qualified staff are scarce and errors are expensive.

The ownership question matters here: such a solution is built for the firm, tuned to its clients’ formats and handed over into the firm’s own cloud environment – including all access keys. The firm owns the workflow, just as it owns its client relationships. For adjustments and new client formats I remain available afterwards, as a plannable retainer or on demand.

The first step

It is unspectacular: put a real timesheet from a real client next to the import format of your software and name the gap. That is exactly the starting point for a tailored overlay. If you want to take that step: describe your case to me – ideally with an anonymised sample spreadsheet.