Club expense receipts to Excel

Month-end without the shoebox

Treasurers of clubs, sports teams, parent groups and hobby circles end up collecting receipts from whoever paid at each event. Opening every photo in the group chat and typing the date and amount into a sheet is slow, and it's easy to enter one twice or miss one completely.

Drop those photos into the tool above and the date, store and total are filled in for you. The file downloads as club-expenses_date_time.xlsx with a sheet called Club expenses, so a new file each month stacks neatly in one folder.

Columns worth adding

Paste these columns to the right of the four you download (No., Date, Store, Total) and the sheet doubles as your report.

With the event name in column E, =SUMIF(E:E, "Fall picnic", D:D) gives the cost of that event. If members often pay with their own cards, the Paid by and Reimbursed on columns matter most. Filter for blank Reimbursed on cells and you can see at a glance who is still waiting for money.

Ground rules that make collecting easier

• Whoever pays photographs the whole receipt right away and posts it to the group chat or a shared album.
• Add one line with the event name when posting, so the Event column is easy to fill in later.
• Cash spending without a receipt, like parking or snacks, goes in with "Add row".
• Log each event's receipts within a week, while people still remember who paid for what.

Before you report to members

Compare the spreadsheet total with withdrawals from the group's bank account. When they don't match, it's usually a missing receipt or one that was posted twice. Rows with the same date and amount are worth a second look, and any yellow cells are the quickest place to start checking against the photos.

Receipt photos can show partial card numbers or members' names. Sharing the spreadsheet is usually enough; agree as a group whether the photos themselves get shared.

Frequently asked questions

Can I add receipts photographed by different people?

Yes. Photos from different phones can go in together, up to 30 at a time. Receipts rarely show who paid, so fill in the Paid by column yourself.

Can I track dues and other income in the same file?

The tool only captures spending from receipts. Download your bank transactions and paste them into an Income sheet in the same workbook to work out the balance in one place.

Are members' receipt photos stored on a server?

No. ReceiptMoa reads photos only in the treasurer's browser. Photos posted to a group chat or shared album stay in that service, though, so agree on whether to delete them once they're logged.