Skip to content
Copy of Pay Tracker for Hourly Rates, Raises, and Reports
How This Works
Pay Log
Pay Rates
Pay Types
Reports
More
Share
Explore

icon picker
How This Works

Track your pay, pay rates, raises, reimbursements, and more!

This document works for...

Multiple pay rates like an Office Hourly Rate and a Field Hourly Rate
Extended pay rates like Office Hourly Overtime and Field Hourly Overtime that might be (1.5 x Regular pay)
Pay changes over time such as raises and other pay adjustments
Tracking average hours per week
Annual summaries

Pay errors happen, this document allows you to track your pay. Carry over the values from your bi-weekly paycheck to better see rates, hours, and trends.

⁠
Pay Log
⁠
⁠

The
Pay Log
⁠
is where all info is added for your paycheck. This table is the original log that all other views are created from. This table reads in values from
Pay Rates
⁠
and
Pay Types
⁠
.

⁠
Pay Rates
⁠
⁠

There are two tables for tracking different pay rates,
Office Rate
⁠
and
Field Rate
⁠
. You can change these table names but it's best to keep them paired with the names in
Pay Categories
⁠
. The equations in the pay log will lookup the Pay Category name and match that to the proper pay rate table for the correlating date.

⁠
Pay Types
⁠
⁠

This is where you edit and add your different pay categories and pay types.
Pay Categories
⁠
have 3 categories included in the Pay Log equations. If you add or remove a category, you will need to edit the Pay Log equations.
The first two categories,
@Office
⁠
and
@Field
⁠
, are hourly rates. The third category,
@BulkPay
⁠
, is for single sum payouts like reimbursements or bonuses.
The
Pay Types
⁠
table breaks down the Pay Categories into the different pay types. Within the
@Office
⁠
category, you might have a Regular Rate and an Overtime rate. This table is grouped according to pay category and all equations refer to these categories, so any number of new rates can be added or removed within these categories. The "Scaler" column is a multiplier for rates like "Overtime" where pay might be (1.5x) a Regular rate. The "Scaler" will be "1" to keep the rate the same.

⁠
Reports
⁠
⁠

Filter your pay summary by year easily! The
Choose a Year
⁠
table is a view of the full
Pay Log
⁠
. Use the "Filter by:" dropdown year and the table will update to show your pay summary by that year.

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.