To share the cost of a Lohri bonfire among neighbours, list every expense with who paid, add the total, divide by the number of households, and then work out what each household paid against its share. The difference is what each household owes or is owed. One person can then send a single message with exact UPI amounts to settle it.
What does the sheet look like?
Here is a hypothetical Lohri for five households. Firewood costs ₹1,500, snacks ₹3,000, music and speaker hire ₹1,000 and sweets, revri, gajak, peanuts and popcorn ₹1,500. The total is 1,500 + 3,000 + 1,000 + 1,500 = ₹7,000, and each household's share is 7,000 / 5 = ₹1,400.
| Household | Paid for | Amount paid (₹) | Share (₹) | Gets back or owes (₹) |
|---|---|---|---|---|
| A | Firewood and sweets | 3,000 | 1,400 | Gets back 1,600 |
| B | Snacks | 3,000 | 1,400 | Gets back 1,600 |
| C | Music | 1,000 | 1,400 | Owes 400 |
| D | Nothing | 0 | 1,400 | Owes 1,400 |
| E | Nothing | 0 | 1,400 | Owes 1,400 |
Check that it balances: A and B are owed 3,200 in all, and C, D and E owe 400 + 1,400 + 1,400 = ₹3,200.
How do I do the arithmetic in a sheet?
Put the amounts each household paid in column C, the number of households in F1 and the total in F2 with =SUM($C$2:$C$20). The share is =F2/F1. For each household, =C2-$F$3 gives the net amount, where F3 holds the share. A positive result means that household gets money back, and a negative one means it owes.
How do we settle through UPI?
Match those who owe with those who are owed, and pay in as few transfers as you can. D pays A ₹1,400. E pays B ₹1,400. C pays A ₹200 and B ₹200. Now A has received 1,400 + 200 = ₹1,600, B has received ₹1,600 and C has paid ₹400. Everyone is square, in four transfers.
What should the neighbours agree in advance?
- Who will buy what, and a spending limit for each line
- Whether households with more members pay more or whether the share is equal
- Whether guests invited by one household count in the share
- Where the leftover firewood, sweets and speaker go afterwards
- A date by which everyone settles
A short message in the society group before the evening saves arguments afterwards. Whether the share is equal or by headcount is for you to decide; write it down either way.
Does an expense tracker help here?
Only for your own share. SpendixAI is not a bill-splitting app, so use the table above for the split and record only your own household's share as your expense. In the example, household B paid ₹3,000 for snacks and later received ₹1,600 back, so its own cost once settled is 3,000 - 1,600 = ₹1,400, which is exactly its share.
What if some households pay more than their share?
Sometimes one family brings a large pot of food or extra firewood. Decide before the evening whether such contributions count towards the share. If they do, enter them as a payment with a rupee value agreed by everyone, and the sheet balances as before. If they are gifts to the group, keep them out of the sheet and say so in the message. Either way, silence is what causes resentment, not the amount.
Check with your society office or local authority before buying firewood. Bonfire rules, timings and places differ, and an evening that is stopped halfway costs more than one that was planned with permission. If a permission or a deposit is needed, add it to the sheet as the first line.
A quick list for the organiser
- Make a list of items and who is buying them
- Collect the bills or a photo of each one
- Total the amounts and work out the equal share
- Send one message with each household's net amount
- Mark each household as settled when the UPI arrives
Useful ideas start with a clearer picture of your own spending.
Explore your reports


