I created a Pay Tracker Template to log pay for hourly jobs. There are two pay rates in the example, Office and Field, and then various scalers of these rates, like Overtime at 1.5x regular pay. Bulk pay items are also included, like single sum Bonuses or Reimbursements.
You can also track raises and pay changes for both rates without overwriting data previous to these rate changes.
There is also a YTD (Year to Date) page with a dropdown to choose the year you’d like to review.
All Tables are linked or are views of the main Pay Log, so nearly all data can be edited and changes will follow through, including in formulas. You can also add or delete pay rates depending on the line items on your paycheck.
This is my first crack at Coda so don’t be shy if you see things that can be improved!
I’m sharing the document as “View Only” but I think you can still copy it that way. If not, let me know.
Thanks for checking it out!