Number every receipt, enter each one as a row with the same seven columns, subtotal by category, then compare the grand total with your card statement. Forty receipts feel like a project, but they become a short job once each one is a row in the same layout. The figures below are invented, from an imaginary three-city sales trip.
Sort the pile before you open a sheet
- Lay the receipts out by date and write a number from 1 to 40 on the corner of each.
- Photograph anything printed on thermal paper, since it fades.
- Set cash receipts in a separate small pile.
- Note any purchase you remember that has no receipt, so you can look for it on the statement later.
Doing this on a table, not on the sofa with the laptop, is what makes the rest quick: you only ever handle each receipt once.
Which columns does the sheet need?
- Number: matches the corner of the paper receipt.
- Date and vendor, as printed.
- Category: air or rail, lodging, meals, ground transport, other.
- Amount in dollars.
- Paid by: card or cash.
- Purpose: who you met and why, in a few words.
The purpose column is the one people skip and later regret. A row that says Dinner, two buyers from the Dayton account answers a question before anyone asks it.
What does the finished summary look like?
Here is the trip grouped by category, with the number of receipts in each.
| Category | Receipts | Total |
|---|---|---|
| Air and rail | 3 | $712.40 |
| Lodging | 3 | $567.00 |
| Meals | 18 | $842.35 |
| Ground transport | 11 | $226.80 |
| Other | 5 | $93.45 |
The counts add up to 3 + 3 + 18 + 11 + 5 = 40, and the totals add up to $712.40 + $567.00 + $842.35 + $226.80 + $93.45 = $2,442.00. If your count of rows does not match the number of paper receipts, stop and find the difference before you go on.
How do you check the total against the card?
Say six of the receipts, worth $73.20 together, were paid in cash. Then the card statement should show charges for the other thirty-four receipts of $2,442.00 - $73.20 = $2,368.80. If the statement shows more, a charge has no receipt in your pile. If it shows less, a receipt may be a duplicate or a pre-authorisation that has not posted.
What if a receipt is missing?
Write a short substitute note with the date, vendor, amount and what it was for, and take the details from the card statement. Whether your employer accepts such a note is their policy, so ask them rather than assume. Do not recreate a receipt as if it were the original.
Where software can help
A spreadsheet handles one trip well. If you track receipts all year, SpendixAI keeps a receipt together with its transaction, though it is built around India and INR, so check whether it suits dollar accounts before you rely on it. Whatever you use, the rule stays: one receipt, one row, one purpose.
What if the report form uses different categories?
Employers often have their own list. Keep your own categories in the sheet and add a second column for the employer's heading, so the mapping is done once per receipt. Say your 18 meal receipts need splitting into breakfast, lunch and dinner on the form:
| Meal | Receipts | Total |
|---|---|---|
| Breakfast | 6 | $74.10 |
| Lunch | 5 | $215.25 |
| Dinner | 7 | $553.00 |
Check: 6 + 5 + 7 = 18 receipts and $74.10 + $215.25 + $553.00 = $842.35, the same meals figure as before. If a regrouped total differs from the original, you moved a receipt and lost it on the way.
Submit-ready checklist
- Forty rows, forty paper or photographed receipts.
- Category subtotals add up to the grand total.
- Card plus cash equals the grand total.
- Every row has a purpose.
- Missing receipts listed with a note, not hidden.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

