______________________

RESTAURANT PAYROLL

Synapse Soltuions / Client / Dyanamic Arrays, XLOOKUP / Dec. 2025

None of the people working at the restaurant knew anything about payroll operations. Neither the manager responsible for it each week nor the employees receiving it. The system for collecting the tip had been going on for years, and the spreadsheet that calculated the tip was made by some long-gone person. It was trusted like a car that started every day without fail, because nobody knew anything about how it worked, except that it always worked fine. This time, it didn’t.

Approach

_______

In the early stages of the project, I was not creating any thing. Rather, I asked the manager to give me a tour of her work week and explain to me how she started, what she found most troubling, and what she always checked twice. I asked the employees if they knew what their tip percentage was. None of them did. This lack of clarity was not an annoyance, but something that carried weight.

Before any design took place, I did a complete map of the process: from the POS to the printouts to the spreadsheet and then to the accountants. Five or six different steps, with only one person being accountable for all of them. She required a solution that was developed uniquely for her; not for the individual who could troubleshoot a formula. That meant any variables such as the minimum wage, staff positions, and bonuses had to be visible.

The System

_________

The $20,000 shortfall was identified, recorded, and fixed. The manager who once handled the payroll process alone has a system that can be explained to another person, a system that she can trust at 11pm on a Sunday evening when the payroll is due the next morning. It saves her over 60 hours a month. However, the real work took place prior to opening Excel not because the formulas were complicated – they were – but because no formula will save a system based on an incorrect understanding of human needs.

I also learned about invisibility. The initial spreadsheet was not obviously broken. It began each morning. The problem it was hiding had existed for years precisely because nothing about it appeared wrong. The most dangerous systems do not break in loud ways. The most dangerous systems break silently, consistently, and in ways that are plausible enough that no one investigates.

I investigate now.