Monthly mess bill format, in English and Marathi: A free template. Print it, or fill it in Excel.
A monthly mess bill needs only this: the member’s name, the period, the monthly fee, any earlier dues, extras, deductions, what was paid and what is left. The template below is free: fill it in Excel and the totals add up by themselves, or print the PDF and fill it by hand.
No sign-up needed. The Excel file has room for 150 members. The PDF has two bills on each A4 page; cut it in half.
What goes on a mess bill
With these ten lines on every bill, the month-end “but I paid” argument has nothing to stand on.
| Line | Why it matters |
|---|---|
| Mess name, phone and UPI ID | The member knows where and how to pay. |
| Bill number and date | Easy to find later. Never two bills with the same number. |
| Member’s name and mobile | No mix-up when two members share a name. |
| Plan and period (from–to) | Ends the “I only joined on the 5th” argument. Write two meals, one meal or tiffin too. |
| Monthly fee | The agreed amount, in writing, not from memory. |
| Earlier dues | Carry last month’s balance forward, or it gets forgotten. |
| Extras | Guest meals, parcels or anything else. Write what and how much in the details. |
| Deductions | Only if your rules reduce the bill for leave or closed days. Many messes add days instead of cutting the bill; say which rule you follow before the month starts. |
| Total due, paid and balance | Write the date and the way it was paid (cash or UPI) next to the amount. |
| Due date and signature | One line such as “please pay by the 5th”, and the owner’s signature. |
A filled-in bill
The sum is simple: monthly fee + earlier dues + extras − deductions = total due. Total due − paid = balance.
- In the Excel file the sums happen by themselves; you only type in the yellow boxes.
- The Excel file has a “Members” sheet: the whole month on one page, each member’s balance, the totals at the bottom, and cash and UPI added up separately.
- It also opens in Google Sheets or the Excel app on a phone.
- To count who ate how many meals, use the free attendance register.
Sample Mess
Monthly bill · Bill no. 27 · Date 01/10/2026
- Member
- Rahul Patil
- Plan
- Two meals
- Period
- 01/10 – 31/10/2026
- Monthly fee
- ₹3,000
- Earlier dues
- ₹400
- Extras: guest meals (2 × ₹70)
- ₹140
- Deductions
- ₹0
- Total due
- ₹3,540
- Paid (01/10, cash)
- ₹2,000
- Balance
- ₹1,540
Please pay by the 5th. UPI: yourmess@bank
Five common mistakes in mess accounts
Bills without numbers
Without a number you can’t tell which bill went out and which didn’t. Number them in order, starting at 1.
Money taken, no receipt
Cash or UPI, write down every payment with its date and give the member a receipt. That ends the argument before it starts.
Dues not carried forward
If last month’s balance doesn’t appear on the new bill, it usually never gets paid.
Leave rules only spoken
Put in writing how many days of leave earn days back. Nobody should feel the rules changed at month-end.
Cash and UPI mixed up
Write them separately, and at month-end the cash in hand and the UPI money in the bank are quick to check against each other.
If you’d rather not write bills by hand every month
CloudMess, a mess management app, keeps the money and meal records for you:
- Every member’s dues on one screen; an unpaid balance from an ended plan stays on the list too
- A UPI link to anyone who owes; the money goes straight to you, no commission
- A receipt when you record a payment, and the member sees the same number on their phone, if they use the member app
- A record of who ate on which days, by QR scan
Common questions
Do I add GST to the bill?
This template doesn’t add GST. If your mess is registered for GST, ask your CA what the bill must show.
What’s the difference between a bill and a receipt?
A bill says what is owed; a receipt says what was received. Give both: the bill at the start of the month, the receipt when the money comes in.
Can I fill the Excel file on a phone?
Yes. Open the file in Google Sheets or the Microsoft Excel app; the sums work there too.
Rather skip the bills altogether?
Send “Hii” on WhatsApp. In Pune, we come to your mess and set CloudMess up with you.
First 30 days free. We come to set it up.