Weekly Expense Report Templates

Six free weekly expense report templates in Word and Excel, for claiming back travel, mileage and out-of-pocket costs. Most claims are delayed or returned for the same reason, and it is never the arithmetic — it is a line that says what was spent without saying why.

The line that gets claims rejected

An expense line needs five things, and the fifth is the one people leave out.

“Lunch — $45.80” gets queried. The full line does not, and it is the difference between a claim approved in a day and one that comes back a fortnight later when you have forgotten who you ate with. Where other people are involved, name them and say what their relationship to the business is — that detail is specifically what tax authorities look for on hospitality claims.

The useful discipline is to write the purpose at the time, on the receipt, in pen. Nobody reconstructs a week of purposes accurately on a Friday afternoon, and the reconstruction is where the vagueness creeps in.

The templates

Six layouts, one week per sheet. The Excel versions total as you type, which matters because the sub-total is the figure most often got wrong by hand. Each download is a zip file — extract it before opening.

Report 1Download

Report 2Download

Report 3Download

Report 4Download

Report 5Download

Report 6Download

When is a receipt actually required?

In the United States, the IRS generally requires documentary evidence — a receipt or equivalent — for expenses of $75 or more. Employers may set a lower threshold and many do, but they cannot set a higher one and still rely on the rule. Other countries have their own thresholds, and some require a receipt for everything.

Two things follow that are worth knowing even under a generous threshold:

• Keep the small ones anyway. A threshold describes what you must produce, not what helps. A claim with every receipt attached gets approved without a conversation.
• A card statement is not a receipt. It shows an amount and a merchant but not what was bought, how many people were present, or the tax breakdown. It is a fallback for a lost receipt, not a substitute, and it should be flagged as such on the claim.

Why reimbursement can turn into taxable pay

This is the part most people never hear about, and it affects the employee rather than the employer.

In the US, expense reimbursements made under what the IRS calls an accountable plan are not treated as income. Three conditions have to hold: there is a genuine business connection for the expense, it is properly substantiated — with receipts at or above the threshold, and a business purpose recorded — and any excess advance is returned within a reasonable time.

Fail any of those and the arrangement is a non-accountable plan, which means the money is treated as wages: it goes on the employee’s pay record, and tax and withholding apply. So an employee who never gets round to filing the report for an advance they received, or files one with no business purpose and no receipts, can find a reimbursement taxed as salary.

Which reframes the whole exercise. A weekly expense report is not administrative tidiness — it is the substantiation that keeps the money from being taxed. Other countries structure it differently but nearly all of them draw the same line between a substantiated reimbursement and an unsubstantiated allowance.

Mileage, per diem and advances

Three mechanisms that work differently from a simple receipted claim.

• Mileage. Tax authorities publish a standard rate per mile or kilometre, and it is revised every year, so always take the figure from the current year’s published rate rather than from a template or an old policy document. What you need to log is the date, the start and end points, the business purpose and the distance — a round number of miles with no route is the mileage claim most likely to be questioned. If you drive regularly, keep a running record rather than reconstructing it: our driver log templates are built for exactly that.
• Per diem. A flat daily allowance instead of actual costs, which removes the receipt burden for covered categories. If your employer pays per diem, do not also claim the meals it covers — duplicate claiming across the two systems is the commonest honest mistake in expense reporting.
• Cash advances. Record the advance on the report as a deduction, not as a separate conversation. Claim total, minus advance received, equals amount due to you — or due back to the company, which is the line people forget exists. Unreturned excess is what breaks the accountable-plan conditions above.

Why weekly rather than monthly

The honest trade-off: weekly means more approvals, fifty-two rather than twelve. It is worth it when any of these apply.

• People are paying out of their own pocket. A month’s delay on several hundred in travel costs is a real hardship, and it is the single most common complaint about expense processes.
• Receipts go missing. A week of paper is manageable; four weeks of it in a bag is where claims quietly get abandoned.
• Costs need to land in the right period. Weekly submission means month-end close is not waiting on anybody’s filing habits.
• There is a lot of travel. Reconstructing three weeks of trips is both slow and inaccurate, and the inaccuracy runs in both directions.

Where travel is occasional, per-trip reporting usually beats both — submit when the trip ends, while the purposes are still obvious. If you are planning the trip as well as claiming it afterwards, our travel budget templates cover the forecasting side, and the gap between the two is a useful thing to look at once a quarter.

What gets claims sent back

1. No business purpose

   Covered above, and comfortably the largest category. “Taxi — $32” tells an approver nothing they can sign off.

2. Personal items mixed in

   A hotel bill with a film and a minibar on it, a supermarket receipt with your own shopping. Strike the personal lines and claim the difference, showing the deduction on the report rather than quietly submitting a lower figure — an unexplained total that does not match the receipt is itself a query.

3. The same cost claimed twice

   Usually innocent: once from the receipt and again from the card statement, or once on a per diem and again as a meal. Number your reports sequentially and note the report number on each receipt as you file it, and this stops happening.

4. Foreign currency with no rate

   Record the amount in the original currency, the converted amount, and the rate and date you used. Where you paid by card, the statement rate is the defensible one because it is what you were actually charged.

5. Something policy excludes

   Alcohol, upgrades, fines and penalties, and spouse or family travel are the usual exclusions. Read the policy once, properly, rather than discovering it claim by claim. If there is no written policy, that is the real problem — approvals become a matter of whoever happens to be signing.

6. Submitted too late

   Many policies have a deadline after which a claim will not be paid at all, and it is often shorter than people assume. Check yours, and treat it as a hard date rather than a guideline.

Common questions