For an office lunch group, keep a running tab: each day, log who paid the bill and what each person's own order came to. On Friday, add up what each person paid and what they ate; the difference is the balance, and a few payments settle everything. This beats splitting every lunch equally, because orders are never equal.
Why not split every bill equally?
Equal splits feel simple but they annoy someone every time, usually the person who ordered a light meal. Logging each person's own order costs a few seconds and removes the grumbling. It also removes the daily scramble for change, since only one person pays at the counter or on the app.
What does one week look like?
Four colleagues, five days, hypothetical numbers. In each row the first figure is the day's total and the other four are each person's own order.
| Day | Paid by | Asha ate | Bala ate | Chitra ate | Dev ate | Day total |
|---|---|---|---|---|---|---|
| Mon | Asha | ₹150 | ₹180 | ₹160 | ₹150 | ₹640 |
| Tue | Bala | ₹200 | ₹160 | ₹190 | ₹170 | ₹720 |
| Wed | Chitra | ₹140 | ₹150 | ₹130 | ₹140 | ₹560 |
| Thu | Dev | ₹160 | ₹150 | ₹150 | ₹150 | ₹610 |
| Fri | Asha | ₹150 | ₹140 | ₹150 | ₹140 | ₹580 |
The week's bills add up to ₹640 + ₹720 + ₹560 + ₹610 + ₹580 = ₹3,110. Now total what each person paid and what each person ate.
| Person | Paid | Ate | Balance (paid minus ate) |
|---|---|---|---|
| Asha | ₹1,220 | ₹800 | +₹420 |
| Bala | ₹720 | ₹780 | -₹60 |
| Chitra | ₹560 | ₹780 | -₹220 |
| Dev | ₹610 | ₹750 | -₹140 |
The balances must add up to zero: 420 − 60 − 220 − 140 = 0. If they do not, a row was mistyped. A positive balance means the group owes you. So Bala sends Asha ₹60, Chitra sends Asha ₹220 and Dev sends Asha ₹140, three payments in total, and the week is closed.
How do I set this up in a sheet?
Use a simple log, one row per person per day. Column A is the date, column B the person's name, column C the amount that person paid at the counter (zero if they did not pay), and column D the value of that person's own order. Put names in F2:F5. Then use these formulas.
- Paid: =SUMIFS($C$2:$C$200,$B$2:$B$200,F2)
- Ate: =SUMIFS($D$2:$D$200,$B$2:$B$200,F2)
- Balance: =G2-H2, with Paid in column G and Ate in column H
- Check: =SUM(I2:I5), which should show zero
What about delivery fees, taxes and tips?
Share them in proportion to each person's order, or equally if the amount is small. Pick one rule and keep it all week. If a restaurant bill shows a service charge, treat it as part of the day total and divide by orders, not by head count.
What if someone is absent or eats separately?
Simply leave their row out for that day. Their balance stays unaffected. If a new person joins mid-week, add a name and start their rows from the day they begin.
How does it show in my own spending?
Your lunch cost is what you ate, ₹800 for Asha above, not the ₹1,220 paid. SpendixAI is meant for your own spending and is not a splitting tool, but you can add your own meal share by hand in a Lunch category, and upload your statement when you want to see everything together.
Starting the tab
- Agree the settle-up day and the rounding rule, for example to the nearest ₹5.
- Choose one person to keep the sheet for the month, and rotate after that.
- Keep the sheet where everyone can look at it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

