When you collect money for a group gift, keep three things: a contribution list showing who has paid, a spend list for the gift and extras, and a rule for any leftover. Fix the leftover rule before you collect a rupee. That is what stops awkward questions and saves you from being out of pocket.
How do I set it up before collecting?
- Fix the amount per person, or a suggested range if contributions are voluntary.
- Name one collector. Everyone pays that one person, so the money is not scattered.
- Share the collector's UPI ID in the group once. Anyone paying should check that the name shown matches before confirming.
- Set a deadline, say two days before the birthday.
- Say upfront what happens to extra money.
What does the contribution list look like?
| Name | Promised | Paid | Date | Mode |
|---|---|---|---|---|
| Asha | ₹500 | ₹500 | 4 Nov | UPI |
| Bala | ₹500 | ₹500 | 4 Nov | UPI |
| Chitra | ₹500 | ₹500 | 5 Nov | Cash |
| Dev | ₹500 | ₹300 | 5 Nov | UPI |
Extend this to all nine contributors. The sheet total comes from =SUM(C2:C10), which adds the Paid column. The outstanding amount is =SUM(B2:B10)-SUM(C2:C10), promised minus paid.
What does a worked example look like?
Say nine colleagues promise ₹500 each, so ₹4,500 is expected, and all pay in full. The spend list is a gift of ₹3,800, a card at ₹120 and a cake at ₹450, which is ₹4,370 in total. The balance is ₹4,500 − ₹4,370 = ₹130. Divided among nine people, ₹130 comes to about ₹14.44 each, which nobody wants to transfer. This is why a leftover rule matters.
What are my options for the leftover?
- Carry forward: keep it as the seed for the next gift in the group, and say so openly.
- Refund: only sensible when the leftover per person is worth transferring, say ₹50 or more.
- Round up the gift: spend it on a better card or a small add-on.
- Give to a cause the group agrees on.
For small leftovers like ₹130, carry-forward is usually the cleanest. Write the balance at the top of the next collection sheet.
What if the gift costs more than the pot?
Do not quietly cover the difference yourself. If a gift of ₹5,500 is chosen but only ₹4,500 has come in, there is a shortfall of ₹1,000, which is about ₹111 per person across nine people. Either ask for a small top-up from those willing, or choose a cheaper gift. Say which in the group, so nobody feels surprised by a second request.
What if someone pays less or more?
Record exactly what they paid, even if it differs from the promise. A lower amount is fine if the group agreed that giving is voluntary. If a colleague gives extra, treat it as a gift to the pot, and do not expect the others to match it.
How do I record my own part?
As the collector, your bank statement will show the credits from everyone and the debit for the gift. Your own spending is only your share, ₹500 in this example, not the whole ₹4,500. In SpendixAI you can add your share by hand as a gift expense, and keep the shop receipt attached to it, so your birthday and gifts category shows what you gave and not what you passed through.
After the party
- Send the final numbers to the group: collected, spent, leftover and what happens to it.
- Keep the receipt for a month in case anyone asks.
- Save the sheet as a template for the next occasion.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


