Per diem is pay — until the layover eats it. Crew meals, coffee, transport and “just one nice dinner” come straight out of the money the trip was supposed to add. This Budget Tracker logs every pairing, calculates the per diem it earned, subtracts what the layover actually cost, and shows the number that matters: net per diem kept.
What it does for you:
– Start Here — 5-minute setup: enter your hourly flight pay rate, your monthly guarantee hours and your per diem rate per hour.
– Trip & Layover Log — every pairing with route, trip days, block hours and per diem hours. Per Diem Pay calculates itself; log the layover spend and Net Kept is done for you.
– Monthly Pay Planner — per diem pulls itself from the Trip Log by month and joins guarantee pay + extra flight pay, so each month’s real take-home is one number.
– Per diem honesty — the Dashboard shows per diem earned vs layover spend, the % of per diem you actually keep, and your average layover spend per trip day.
– Expense Log — log everyday spending once; the budget reads it automatically.
– Monthly Budget — zero-based monthly budget where every dollar gets a job; Actual pulls from the Expense Log by itself.
– Monthly Summary — 12 months of per diem pay in one view, so you see which months’ flying actually paid.
– Sample rows pre-filled so every formula works the moment you open it; formula cells are locked (password disclosed in Start Here) and every formula is error-wrapped. Pay figures are estimates before tax — a tracking tool, not payroll or financial advice.
What’s inside (.xlsx, works in Excel AND Google Sheets): Start Here · Trip & Layover Log (per diem in, spend out) · Monthly Pay Planner (guarantee + flying + per diem) · Expense Log · Monthly Budget (zero-based) · Dashboard · Monthly Summary (12 months).
Instant download. No shipping, no waiting. Message us if you need help setting it up — we answer fast.



Reviews
There are no reviews yet.