If you collected ₹1,20,000 from 12 households and spent ₹1,04,500, the surplus is ₹15,500. When everyone paid the same, each household gets back the same amount. When shares differed, return the surplus in proportion to what each household paid, which is called pro-rata. Agree the rule before collecting, work out the figures once, and return the money by UPI with a note.
First, how large is the surplus?
Surplus equals collected minus spent: 1,20,000 minus 1,04,500 equals ₹15,500. Check this against your bills and your account before you split it. If you still expect a late payment, such as a final bill from the caterer, hold some back and say so.
Equal shares: the simple refund
If all 12 households paid ₹10,000, divide the surplus by 12. 15,500 divided by 12 is ₹1,291.67, so round down to ₹1,291. Twelve refunds of ₹1,291 come to ₹15,492, leaving ₹8, which you can note as a rounding remainder, add to the sweets for helpers, or keep in the closing record with a note.
Pro-rata shares: when contributions differed
Say six households paid ₹12,000 and six paid ₹8,000. That is 72,000 plus 48,000, which is ₹1,20,000. Each household gets back its share of the surplus: the amount it paid divided by 1,20,000, multiplied by ₹15,500.
| Group | Households | Paid each | Refund each | Group total |
|---|---|---|---|---|
| Larger share | 6 | ₹12,000 | ₹1,550 | ₹9,300 |
| Smaller share | 6 | ₹8,000 | ₹1,033 | ₹6,198 |
| All | 12 | - | - | ₹15,498 |
For ₹12,000: 12,000 divided by 1,20,000 is one tenth, and a tenth of 15,500 is ₹1,550. For ₹8,000: 8,000 divided by 1,20,000 is one fifteenth, and a fifteenth of 15,500 is ₹1,033.33, rounded down to ₹1,033. Refunds total ₹15,498, leaving ₹2.
Which method is fairer?
Pro-rata follows the money: whoever paid more gets more back. Equal refunds can feel odd when contributions differed, since a household that paid less gets a larger fraction of its own money back. The fairest approach is the one the group agreed to when the collection started. If nobody said, choose pro-rata and explain it in one line.
What is the formula for a sheet?
Put each household's payment in C2 to C13 and the surplus in F1. In Excel or Google Sheets, a rounded-down refund for the first row is =ROUNDDOWN(C2/SUM($C$2:$C$13)*$F$1,0). Fill it down the column, then use =SUM(D2:D13) to total the refunds and =$F$1-SUM(D2:D13) to see the leftover rupees.
If a household paid in two instalments, use the total it paid, not the last payment alone. If one household paid ₹12,000 but later told you that ₹2,000 of it was for something it asked you to buy separately, take that ₹2,000 out of its contribution before working out the share. The pro-rata base should always be the money that actually went into the common pot.
How do I record the returns?
- Pay each refund by UPI with the remark Surplus refund and the function name.
- Mark Refunded and the date next to each name in your list.
- Record each refund in the function's account so the balance falls to the rounding remainder only.
- Add a closing note stating what was done with the remainder.
- If you track the money in SpendixAI, keep the refunds in the same function category as the collection, so its total nets out.
What if a household wants to donate its refund?
Some households will say to keep their share for the next family event or for the priest's dakshina. That is their choice, but write it down: Refund of ₹1,550 left with the pot by the Sharma household, with the date. Then the next treasurer knows that the opening balance is not a mystery and that the money has a named source. Never assume that silence means a household is donating; ask once, and note the answer.
A short checklist
- Surplus confirmed against bills and statement.
- Method agreed: equal or pro-rata.
- Refunds rounded down, remainder noted.
- Every refund marked with date.
- Account closed.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


