Anyone who has ever tried to manage a drinks fund long-term with a spreadsheet knows the feeling: it starts well. Neat columns, color-coded rows, maybe even a formula for automation. And then – somewhere between the third billing cycle and the moment the tally sheet becomes unreadable – the system starts to crumble.
This article explains why that's not a failure of the person who set up the spreadsheet. It's the tool's fault.
What the Excel Drinks Fund Typically Looks Like
In most collectives, offices, and clubs, it goes like this: one person takes responsibility for the drinks fund. Let's call them the treasurer. The treasurer sets up an Excel spreadsheet – rows for members, columns for products or time periods, a sum formula somewhere.
The members themselves don't work in the spreadsheet at all. Instead, there's a tally sheet next to the fridge. Whoever takes something makes a mark. At the end of the month, the treasurer sits down, counts the marks, and enters the numbers into Excel.
For a few months, this works reasonably well. Then the problems creep in – not all at once, but gradually, mark by mark.
The Real Problems – and Why They Show Up Late
The insidious thing about this system is that it works just well enough to keep going. But not well enough to actually work.
The Tally Sheet Is the Weakest Link
The entire chain depends on the tally sheet. And paper tally sheets have a well-known problem: they're unreliable.
Someone forgets a mark. Someone else puts it in the wrong column. After three weeks the sheet looks like a hieroglyph collection, and no one can say with confidence whether that's four or five marks. The treasurer counts, estimates, and enters the numbers – with the quiet hope that it's roughly right.
It's rarely roughly right. Usually a few euros are missing at the end, and no one knows why.
Transcription Takes Time Nobody Wants to Spend
Once a month the treasurer sits down and transfers the tally sheet into Excel. That sounds like ten minutes. In practice it's often an hour – because the sheet is barely legible, because amounts need to be calculated, because you count again, because something doesn't add up.
This is volunteer work that accumulates over months. Eventually the treasurer gets frustrated. Eventually the billing gets postponed. And eventually someone wonders if it's really worth it.
Nobody Knows How Much They Currently Owe
Between billing cycles, everyone's in the dark. How much have I consumed this week? Am I already in the red? The only way to find out: ask the treasurer. And hardly anyone does that.
The result is surprises at billing time. And surprises involving money are rarely pleasant – neither for the member nor for the treasurer who has to deliver the bad news.
The Spreadsheet Lives Only in the Treasurer's Head
The treasurer knows how the spreadsheet is structured, what each formula means, and where the special cases are hidden. Everyone else doesn't. If the treasurer gets sick, goes on vacation, or leaves the club, someone else starts from scratch.
This is no criticism of the treasurer – it's a structural problem. Knowledge that exists in only one person is fragile.
Losses Stay Invisible
If products go missing without anyone having logged them – whether through forgetfulness or damage – they simply don't appear on the tally sheet. The treasurer records what they see. What they don't see doesn't exist in the spreadsheet.
Over months, these invisible losses add up. Eventually the cash balance no longer matches the actual funds on hand – and no one can explain when that started.
When Do You Realize It's Time for Something Better?
There are a few reliable warning signs:
Billing keeps getting postponed. Not because no one has time, but because it feels like more effort than it should be every time.
Disputes over amounts. "I only took two" – "The sheet says three." When the tally sheet isn't a reliable source, it becomes a point of contention.
The treasurer is exhausted. The combination of counting, transferring, chasing payments, and explaining eats up time and motivation. Eventually someone doesn't enjoy doing it anymore – or stops doing it at all.
The gap between cash balance and spreadsheet grows. Eventually nothing adds up anymore, and no one knows since when that's been the case.
If any of these apply: that's not a coincidence, that's a system failure.
What a Good Alternative Needs to Do
A system that genuinely fixes these weaknesses needs to accomplish one thing above all: make the moment between "taking something" and "recording it" so short and simple that forgetting becomes the exception – not the rule.
In concrete terms, that means:
Entries happen right at the point of action. Not sometime later, not through the treasurer, but in the moment someone takes something. A tablet next to the fridge makes this possible.
No more transcription. What gets recorded directly doesn't need to be transferred. The treasurer saves themselves the monthly counting and typing work entirely.
Account balances are visible at any time. Each member sees directly when booking how much credit they have left. No more surprises at billing time.
Losses are documented. If products are missing during an inventory check, it can be recorded as a separate entry – with a description and date. Nothing gets silently lost anymore.
The knowledge is in the system, not in one person. Whoever takes on the admin role sees everything immediately – without needing to learn a custom-built spreadsheet.
What This Looks Like in Practice
Tapper is built exactly for this scenario. A tablet next to the fridge, open permanently. A member taps their name, selects the product, done. The amount is automatically deducted. The account balance is immediately up to date.
For the treasurer, one thing changes above all: they no longer have to do the billing. The entries come in clean. The dashboard shows at a glance who consumed what, whose account is running low, and what the fund balance looks like. No tally sheet, no transcription, no spreadsheet.
And when someone deposits money, a quick top-up request in the system is enough. The admin confirms, the credit is there immediately. Everything documented, everything traceable.
Tapper runs as a web app directly in the browser, on any tablet or smartphone. No installation, no IT overhead, no password required for members.
Switching Is Easier Than It Sounds
Anyone currently keeping a tally sheet and manually transferring data into Excel might think: "Switching over is also effort." That's true – once. Enter products, add members, set up the tablet. Half an hour, maybe an hour.
After that, the monthly transcription is gone. Billing happens automatically. And the treasurer has Saturday afternoons free for other things again.
Tapper is free to try – just start at tapper.team, no credit card required.
And the spreadsheet? It can stay right where it is. You won't need it anymore.
Tapper is a web app for shared drinks and snack funds in offices, clubs, coworking spaces, and other teams. Right in the browser, no installation needed.