If you're the treasurer of a club, team or community group, receipts are probably the most tedious part of the job. After every event they end up scattered across several wallets, and by the end of the month a few have disappeared. This guide walks through a routine that keeps things under control: collect, convert, reconcile, report.
1. Collect receipts as photos, on the spot
Chasing paper receipts weeks later never works. Agree on a simple rule instead.
- Whoever pays takes a photo of the receipt right away and posts it to the group chat or a shared album.
- They add one line saying what it was for, such as "September meetup snacks".
- Decide as a group whether paper originals need to be handed to the treasurer, or whether a clear photo is enough.
Make sure the whole receipt is in the frame and the store name, date and total are sharp. See How to photograph receipts for better recognition for tips.
2. Turn a month of photos into a table at once
When the month's photos are in, add them all to the receipt tool. The date, store and total are filled in automatically, and anything the reader wasn't sure about is highlighted in yellow.
- Download the photos from the shared album and drop them onto the tool, up to 30 at a time.
- Click a thumbnail to see the photo larger while you fix the yellow cells.
- Use "Add row" for cash spending that has no receipt, like a parking meter.
- Download the Excel file.
3. Add a few treasurer columns
The downloaded file has No., Date, Store and Total. For club accounts, add these columns next to them:
| Column | Example | Why |
|---|---|---|
| Category | Food, Venue, Equipment, Gifts | Totals per category |
| Event | September meetup | Cost per event |
| Paid by | Alex | Reimbursing people who paid with their own card |
| Reimbursed | Yes / No | Seeing what's still owed |
| Notes | 12 members attended | Answering questions later |
Category totals are one formula away. If the category is in column E and the amount in column D, use =SUMIF(E:E, "Food", D:D).
4. Reconcile the balance
Expenses are only half the picture. Add an Income sheet to the same file for membership fees and other money coming in.
- Income sheet: date, member, amount, note
- Summary sheet:
opening balance + total income − total expenses = current balance
At the end of each month, check that this matches the actual bank balance. When it doesn't, the usual culprits are a missing receipt or someone who paid out of pocket and hasn't been reimbursed yet.
5. Report to members
Members mostly want to know how much came in, where it went and what's left. Keep the report short.
- Total income, total expenses and current balance for the month
- One table of spending by category
- A one-line note on any large expense
Sharing the spreadsheet itself builds trust, because anyone curious can check the details. Receipt photos can show partial card numbers or names, though, so agree on whether photos are shared too.
Summary
Most of the work is in the routine: photo at the counter, one batch conversion a month, and a balance check against the bank. Stick to those three and month-end becomes a much lighter job.