Excel
Beginner
Per Diem Calculator
Calculate per diem allowances by destination, with company policy thresholds applied automatically.
When to use this
One sheet of destination rates, one sheet calculating the trip allowance from start/end dates and rate. Useful for finance, HR, and the executive's own forecasting.
The template
# Per Diem Calculator | Trip leg | City | Country | Rate (per day) | Days | Subtotal | Notes | |----------|------|---------|----------------|------|----------|-------|