The quickest way to build an expense report from forty receipts is to avoid having forty at the end. Spend five minutes each evening entering that day's receipts into a sheet, and by Friday the report is already written. This example is a consultant on a five-day rail trip, with invented pounds.
Why does the nightly habit beat a Sunday session?
Memory fades faster than paper. By Sunday you cannot say which coffee was a client meeting and which was a delay at a station. Receipts also go missing in coat pockets and bags. Entering them the same evening means the paper only has to survive one day.
What does the routine look like?
- Empty your pockets and bag onto the hotel desk.
- Photograph each receipt, flat, in decent light.
- Add one row per receipt: date, vendor, amount, category, purpose.
- Total the day and write it at the bottom of the day's rows.
- Put the paper in one envelope marked with the week's dates.
That is five steps and about eight receipts a day. Forty receipts over five days is eight a night, so five minutes is realistic only if you keep the layout identical each evening.
A week of daily totals
| Day | Receipts | Daily total |
|---|---|---|
| Monday | 8 | £63.40 |
| Tuesday | 9 | £112.85 |
| Wednesday | 7 | £47.20 |
| Thursday | 9 | £138.60 |
| Friday | 7 | £71.95 |
Receipts: 8 + 9 + 7 + 9 + 7 = 40. Spending: £63.40 + £112.85 + £47.20 + £138.60 + £71.95 = £434.00. Thursday is high because it included the hotel balance, a reminder that one large item can hide in a week of small ones.
What do you do about a lost receipt?
Look up the charge on your card or account the next morning. Record the date, vendor and amount, and add a note that the receipt is missing and why. Some employers have a form for this and some do not, so ask which route they want instead of guessing. Never invent a replacement.
How should you handle train tickets and small purchases?
- Keep e-tickets as screenshots or PDFs and name the file with the date and route.
- Treat each ticket as one row, even for a return journey.
- Group tiny cash buys such as a £2.40 coffee as separate rows; do not round them into a lump sum.
- If a receipt covers two things, such as a meal and a gift, split the row and note why.
If you want an app to hold the receipts
SpendixAI keeps receipts attached to their transactions, which fits this nightly habit, but it is built around India and INR, so it does not suit a pounds trip. For this one, the sheet and the envelope are enough.
What if the plan changed mid-week?
Cancelled trains and rebooked hotels create pairs of receipts that belong together. Say a ticket cost £48.50, you used one leg, and £22.00 came back as a partial refund, so that journey cost £26.50. You then bought a replacement ticket for £62.00. Record all three rows, and note that the net effect on the week is £26.50 + £62.00 = £88.50. Seeing the pair in one place stops a reviewer from thinking you bought two tickets for one journey.
Items your employer paid directly, such as a hotel booked centrally, still deserve a row marked Paid by company with no cost to you. The report then shows the whole trip, and nobody wonders where the hotel went.
What to send
- The sheet with daily totals and a weekly total.
- Images or originals of the forty receipts.
- A line about any missing receipts and how you recorded them.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

