An expense claim with ten lines and four loose receipts is a claim that comes back for questions. The simplest cure is to give each line an identifier and give each receipt the same identifier, so that line 6 has receipt 6 and nobody has to guess. Here is a method that works whether you send a PDF bundle or a spreadsheet with attachments.
Number the lines before you touch the receipts
Create a claim sheet with these columns: line number, date, description, amount in dollars, and receipt file name. Fill in the first four from your records, and number the lines in date order, starting at 1. Only then do you gather the receipts.
Name every receipt after its line
- Rename each receipt file with the line number first, then the date, then the supplier, for example 03 2026-04-08 Hotel.
- Put all the receipts in one folder named for the claim, such as Claim April trip.
- Type the file name into the last column of the claim sheet.
- Open every file once to confirm it shows the amount that the line says.
- Check that no line is without a file, and no file is without a line.
A worked example with dollars
Say a sales representative's two-day trip has these lines.
| Line | Description | Amount | Receipt file |
|---|---|---|---|
| 1 | Train ticket out | $64.00 | 01 train out |
| 2 | Hotel, one night | $142.50 | 02 hotel |
| 3 | Dinner | $38.20 | 03 dinner |
| 4 | Taxi to client | $22.80 | 04 taxi |
| 5 | Train ticket back | $64.00 | 05 train back |
The claim total is 64.00 plus 142.50 plus 38.20 plus 22.80 plus 64.00, which is $331.50. Lines 1 and 5 have the same amount on different dates, which can look like a duplicate to a reviewer. Because each has its own receipt with its own date, the question answers itself.
What if a receipt is missing?
Do not leave the cell blank, and do not make a receipt up. Write a missing-receipt note: the date, the supplier, the amount, what the payment was for, and why you cannot produce the receipt. Attach your card or bank statement line as supporting evidence if you can. Whether your employer or client accepts that is their policy, so ask them how they handle missing receipts and follow their answer.
What does the reviewer want to see?
Reviewers vary, but most look for the same things: the total on the receipt equals the amount on the line, the date falls inside the trip, the description makes business sense, and the receipt is legible. Check these four yourself before sending the claim. Do not assume a policy exists on limits or categories; ask for the written policy and keep to it.
Keeping claims clean month after month
- Make the claim sheet at the start of the trip, not the end.
- Photograph every receipt the same day.
- Name files with the line number from the start.
- Send the claim within a few days of getting back, while you still remember the details.
Receipts in different forms
Not every receipt is a paper slip. Some arrive as emails, some as app screens, and some as a PDF from a supplier. Convert each into an image or PDF and name it with the line number. For an app screen, take a screenshot that shows the amount, date and supplier together. If a supplier's receipt shows only a total with no date, add the date to the claim line yourself from your own records.
A closing check before you submit
- Every line has a receipt file, or a missing-receipt note.
- Every receipt is legible and shows the total.
- The line total equals the sum of the lines.
- The file names match the sheet.
- You kept a copy of the entire bundle.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


