Seven Facilities, Eleven-Hour Shifts, and No Idea What You Actually Made Last Month
Emergency medicine pays well on paper. In practice, the number on your tax return is the sum of shifts worked across multiple hospitals, each with a different per-shift rate, different shift lengths, and different staffing companies cutting separate paychecks on different schedules. Most EM physicians know their approximate annual gross. Almost none can tell you their blended hourly rate across all facilities for a given month without building a spreadsheet they'll abandon by March.
This template does the math in real-time with 46 fields and fourteen calculated formulas.
Per-Facility Shift Counting and Rate Logic
Each facility gets its own shift-count integer field and a calculated earnings field. The formulas reveal the rate structure: one facility pays $236 per 11-hour shift, another pays $560 per 12-hour shift, another $160 per 12-hour shift, another $250 per 12-hour shift, another $200 per 12-hour shift, another $300 per 12-hour shift. These aren't hourly rates — they're shift rates multiplied by hours, reflecting the reality that EM contracts pay per shift, not per hour.
The total earnings formula sums all facility-specific calculations plus bonus pay into a single $ field. The total hours formula accounts for the 11-hour shift length at one facility and 12-hour shifts everywhere else. The $/hr field divides total earnings by total hours to produce the blended hourly rate — the number you actually need when comparing a new contract offer against your current workload.
Deposit Reconciliation: Where the Money Actually Went
Every facility gets a "depo" field — the amount actually deposited to your account for that facility's shifts. The Dr net% field calculates the ratio of deposits to expected earnings as a percentage. When that number is 95%, the staffing company took their cut and everything reconciles. When it drops to 80%, either shifts were coded incorrectly, a penalty was applied, or the contract terms changed and nobody told you.
The Emcare detail field links to a separate library for itemized paycheck data. Emcare gross and net paycheck fields capture the specific staffing company's payment, separate from the self-generated facility calculations. The gap between what you calculated and what Emcare deposited is where billing disputes live.
Tax, Net, and the Monthly Cash Position
The template applies a flat one-third tax estimate: #{$}/3. Crude, but accurate enough for monthly planning when your marginal rate sits around 33%. The net $ field takes two-thirds of gross. Net cash and gross cash integer fields capture actual bank balances, and the balance formula reconciles calculated versus actual.
Net expense and gross expense fields close the loop. When you know your blended hourly rate, your monthly gross, your estimated tax, and your actual expenses, you know exactly how many more shifts you need to pick up — or how many you can drop — without guessing. The shift/mo and hrs/wk calculated fields tell you the current workload intensity, and work wk/mo lets you adjust for months where you took time off.