Report this item to Etsy

Hitch Pay Tracker Spreadsheet, Rotating Schedule Shift Calendar 14/14 21/7, Per Diem & Overtime Tracker, Oilfield Pipeliner FIFO Sheets

Low in stock, only 1 left

Price:$14.99

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by HitchAndLedgerCo
  • Digital download
  • Digital file type(s): 2 PDF, 1 other file

Works on your phone AND your computer: edits sync automatically through Google Drive (Google Sheets) or OneDrive (Excel), so you enter it once and see it everywhere.

Built by a rotational field hand, for rotational workers.

Know every day and every dollar of your year. Set your rotation once (14/14, 21/7, 28/28 or custom) and the Hitch & Per-Diem Pay Tracker fills in your whole year automatically. Just mark the days that were different, like travel, standby, sold days or sick days, and it calculates your day pay, per diem and totals for every day, every hitch and the year to date.

WHAT'S INCLUDED
- Excel edition (.xlsx, no macros) - for Excel on Windows/Mac + the Excel phone app (sync through OneDrive)
- Google Sheets edition - a 'Make a copy' link (in the included PDF) that saves your own copy to Google Drive and the Google Sheets app
- Quick-start PDF guide (setup, phone & computer sync steps, how to use every tab)
- Use it on phone and computer - syncs automatically through Google Drive or OneDrive (step-by-step 'Phone & Computer Sync' tab included)

NEW IN VERSION 2
✔ Use it on phone and computer - syncs automatically through Google Drive or OneDrive (step-by-step 'Phone & Computer Sync' tab included)
✔ Hourly pay mode with weekly overtime (1.5x after 40 hrs) and hazard pay
✔ W-2 vs 1099 tax estimate - self-employment tax, enter your own state + federal rates (with how-to-find-them tips), quarterly payment amounts (estimates, not tax advice)
✔ Per diem by location - enter the GSA (or your employer's) M&IE rate for each job site, with the 75% travel-day rule
✔ Crew-change countdown, compare-two-jobs tab, days home vs away donut and YTD vs goal chart

FEATURES
✔ Rotation presets: 7/7, 14/7, 14/14, 20/10, 21/7, 21/14, 21/21, 28/14, 28/28 or custom
✔ Separate rates for work, travel, standby, sold days and training days, with per diem on/off per day type
✔ Day Log for every day of the year with auto pay calculation, plus bonus/OT and notes
✔ Color-coded year calendar: days on, travel, standby, sold days, home
✔ Per-hitch summaries: days worked, travel, standby, sold, home, day pay, per diem, total
✔ YTD dashboard: gross day pay, per diem, extras, total, days away vs home, % of the year at home, average per day away
✔ Simple income projection: projected year-end total, still to earn, monthly breakdown, estimated tax set-aside, income goal progress bar
✔ Mileage & expense log with reimbursement tracking (see what the company still owes you)
✔ Locked formulas (no password) and clear cream input cells
✔ Fictional example data shows how it works. No employer names or company data.

Great for oilfield, drilling, MWD/LWD, frac, pipeline, offshore, mining, FIFO, wind and other rotational jobs, and a practical gift for the hand in your life.

WORKS ON YOUR PHONE (Google Sheets / Excel app)
✔ Mobile Entry tab: mark travel, standby or sold days and bonuses from location in a few taps
✔ Mobile Dashboard tab: today's status, day X of your hitch, next crew change, YTD pay, per diem and the next 7 days, sized for a phone screen
✔ Phone entries flow straight into your Day Log, calendar and hitch summaries

PLEASE NOTE
- Digital download. No physical item will be shipped.
- Requires Excel 2016 or newer or Microsoft 365, or a free Google account. Works on phone (Google Sheets / Excel app). Do the one-time setup on a computer or tablet.
- For personal use only. Please don't resell or share.
- Personal record-keeping tool, not tax or payroll advice. Always check against your pay stubs. Not affiliated with any employer.

Questions? Message me on Etsy.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 9, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates Personal Finance Templates