Budget Planner for Police Officers — Overtime Tracker

Base pay is the floor, not the paycheque. Patrol overtime, court appearances, paid details and callbacks decide what an officer actually earns — and half of it lands a pay period (or two) late. This Budget Planner tracks every overtime hour by type, calculates what it is worth, and keeps a running total of the overtime you have worked but not yet been paid — built for police work, not adapted from a generic office budget.

What it does for you:
– Start Here — 5-minute setup: enter your base take-home pay per pay period, your base hourly rate, your overtime multiplier and your annual uniform allowance.
– Overtime Log — patrol OT, court, paid details, callbacks, holiday and training OT in one log. OT Pay (hours × rate × multiplier) calculates itself per entry.
– Paid? tracking — flip each entry to Yes when the money lands; the Dashboard always shows UNPAID OT — the hours and dollars the job still owes you.
– Uniform & Gear — boots, gear and dry cleaning against your annual allowance, with Out of Pocket and Allowance Left done for you.
– 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.
– Dashboard — OT hours, OT earned, court hours, detail hours and unpaid OT at a glance.
– Monthly Summary — 12 months of overtime pay in one view, so the busy seasons are visible before they hit.
– 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 · Overtime Log (patrol, court, details) · Uniform & Gear (vs allowance) · 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.