Office Lunch Splits: Stop Using That Messy Spreadsheet
Somewhere in your office, there’s a Google Sheet. It was created months ago by someone who’s probably moved to a different team by now. It has seventeen tabs, three broken formulas, a column labeled “misc” that nobody understands, and Rahul from accounting hasn’t updated his row since March.
Everyone knows it’s broken. Nobody wants to fix it. And every Monday, someone still pastes the Swiggy link into the group chat and says “same sheet, add your name.”
If this sounds familiar, there’s a better system — and it takes less effort than maintaining the spreadsheet ever did.
Why Office Expenses Are Uniquely Annoying
Group trips happen once or twice a year. Roommate expenses are monthly. But office food? That’s daily.
The amounts are small — ₹150 here, ₹250 there — which makes them easy to dismiss individually but surprisingly significant over a month. The participants rotate constantly; not everyone joins every lunch, and the Friday biryani order has a completely different headcount than the Tuesday sandwich run. And critically, nobody signed up to be the group’s expense manager. Whoever started the spreadsheet didn’t intend it as a permanent responsibility — it just became one.
This combination of high frequency, low amounts, and rotating participants is exactly where spreadsheets stop being helpful and start being a chore.
A System That Runs Itself
The approach is straightforward. Create one group on BaatLo for your office lunch crew. When someone pays for the order, they log the expense and select who was part of that particular meal. The split is calculated, balances update, and everyone can see where they stand.
No formulas. No shared edit access issues. No “who has the sheet open right now?”
A few things make this work well for office groups specifically:
Flexible splits per expense. Monday’s lunch might be four people. Wednesday’s might be seven. Friday’s chai run might include the entire floor. Each expense only splits among the people who actually participated — you’re not subsidising someone else’s paneer tikka when you brought lunch from home.
Running balances. Instead of settling after every meal, let the balances accumulate. At the end of the week — or the month, depending on your group’s preference — open the settlement screen and clear everything in one round of payments. It’s considerably less disruptive than daily Paytm requests.
Per-group notifications. This is a small feature that matters here more than anywhere else. A trip group might have five expenses total. Your office lunch group could have five expenses per week. You probably don’t need a notification every time someone logs the afternoon coffee order. BaatLo lets you toggle notifications off for specific groups, so the lunch tracker does its job without flooding your phone.
Making It Work in Practice
A few suggestions from teams that have adopted this approach:
Designate a logging rhythm, not a logger. Rather than assigning one person to track everything — which inevitably leads to resentment — agree that whoever pays, logs. It distributes the effort naturally and keeps the data accurate since the person who placed the order knows the exact amount.
Settle on a fixed cadence. Weekly works well for most office groups. Monthly is fine if the amounts are small and the group trusts each other. Avoid settling daily — it defeats the purpose of having a tracker in the first place.
Use Ghost Members for the occasional joiner. The colleague from the other department who joins Friday lunch but isn’t a regular? Add them as a Ghost Member rather than asking them to create an account for one meal. Track their share, settle with them directly, and keep the group’s numbers clean.
Keep one group per expense type. If your team does both daily lunch and occasional team outings (dinners, celebrations, farewell parties), consider separate groups. It keeps the daily small amounts from getting tangled with the occasional larger expenses, and makes settlement cleaner.
The Real Comparison
The spreadsheet requires someone to maintain it. Formulas need updating when people join or leave. Access needs managing. And at the end of the month, someone still has to manually calculate who owes what and chase payments.
A purpose-built tracker handles the calculation, the access, and the settlement logic. All anyone has to do is log what they paid when they paid it. The rest is automatic.
It’s less work for everyone — including the person who was quietly maintaining the spreadsheet and hoping someone would notice.
Ready to retire the spreadsheet? Set up your office lunch group on BaatLo — it’ll take less time than scrolling through those seventeen tabs looking for your name.
