About a year ago, at the dinner after one of our hiking club's monthly hikes, I became the treasurer. "Volunteered" is a generous word for it. The previous treasurer said work had got busy and added, "If you can use a spreadsheet, you'll be fine. It's not hard." Everyone clapped, and I remember thinking, 'Saying no now would kill the mood,' so I nodded.

What I didn't know then: half of the job is receipts.

The first three months: the envelope era

I thought I was being organized. I picked one large envelope and dropped every receipt into it after each meetup: the restaurant after the hike, sandwiches, the coach hire, club T-shirts, the occasional flowers for a member's family event. The envelope got fat fast, and I kept telling myself, 'I'll sort it all at the end of the month.'

In month three, a member posted in the group chat:

"Hey, roughly how much is left in the club fund? I'm looking at cabins for the autumn overnight trip."

The bank balance was easy. The follow-up wasn't. "What did the coach cost for the Snowdon trip? We could budget from that." I tipped the envelope out and found close to fifty receipts, a few of them almost blank. I'd left the envelope in the car, and thermal paper doesn't like heat. Obvious in hindsight. That night it just felt like, 'Why am I only learning this now?'

So I spent the evening on the living room floor typing receipts into a spreadsheet one by one: date, store, amount. It took about two hours. When I compared the total with the bank withdrawals, I was 30 off. The culprit, after a long search, was one cell where I'd typed 68.00 instead of 38.00. One digit kept me up until one in the morning.

"Do you have the receipt for this?"

The moment I really started sweating was the half-year report. I shared the summary, and a member sent me a quiet private message.

"The June dinner looks a bit higher than I expected. Could I see the receipt?"

I knew it wasn't an accusation. Anyone paying dues has every right to ask. But I had no idea where that receipt was in the envelope, so I put off replying for a day, and spent that day thinking, 'Do they think I'm pocketing money?' When I finally found it and sent a photo, the reply was, "Oh, that included the second bar too. Thanks!" Relief, and at the same time a clear thought: 'I can't keep doing it this way.'

That's when I realized a treasurer doesn't need accounting skills so much as being able to show anything the moment someone asks.

The four habits I changed

1. Photograph the receipt the moment you pay

Before a receipt goes into my wallet, it goes into my phone. Restaurant lighting can be dim, so I only bother with two things: somewhere bright, and the receipt filling the frame. At first people teased me ("the treasurer's doing a photo shoot again"). A few months later they were handing me receipts with "Here, snap it." I still keep the paper in the envelope, but now the envelope is just a backup.

2. Sort it out the same night

Instead of typing fifty receipts at the end of the month, I sort only that day's photos on the night of each meetup. Five or six at most. Upload the photos, pull out date, store and total into a table, paste the downloaded spreadsheet into the running file: about ten minutes. Because the evening is still fresh, I can add notes right away, like "second bar" or "Sam paid first, reimbursed later." I added an Event column and a Note column for exactly that.

3. Check the flagged cells against the photo

Automatic reading is handy, but I don't take it on faith. Any cell highlighted yellow for checking, I open the photo full size and look. Once a sandwich shop's name came out as nonsense. The photo showed the name was a hand-stamped logo. 'Fair enough, no machine is reading that,' I thought, and typed it in myself. I'm extra careful with numbers. Ever since the one-in-the-morning 38.00 incident, I check every total with my own eyes.

4. Post the numbers before anyone asks

The easiest question to answer is the one nobody has to ask. In the last week of every month I post that month's expense spreadsheet and the current balance in the group chat. The first time, the previous treasurer replied, "Wow, we never had anything like this," which felt pretty good. Since then, private messages asking for receipts have almost stopped. People who are curious check the table themselves.

What changed after a year

In numbers: in the first three months, a month's bookkeeping took two or three hours, and every time something didn't add up I had to dig through the pile again. After changing my habits, it's about ten minutes per meetup, and under an hour a month including the monthly post. The year-end report was one evening: join twelve monthly files, total by event, done.

The bigger change was how it felt. My stomach used to drop whenever "treasurer" showed up in the group chat. 'What now?' These days, when someone asks, "How much should we budget for the autumn trip?", I look up last year's total for the same trip and answer on the spot. It's easier for them and easier for me.

Next month I hand the job to someone else. I already know what I'll say on handover day.

"If you can use a spreadsheet, you'll be fine. Just photograph every receipt the moment you get it."

Turns out the previous treasurer was half right.

If you've just become treasurer

  • Photograph receipts right away and keep the paper in a separate envelope. Thermal paper fades faster than you'd think (how to store thermal receipts).
  • Don't save it all for month-end. Sort each meetup the same night.
  • Automatic results save time, but check flagged cells and every total against the photo.
  • Share before anyone asks. Doubts disappear before they start.

For the step-by-step method, see how to track club expenses with receipts, and for handing over the role, the treasurer handover checklist.