
Annual Report
Docs + Word6 pages
FeaturedFree
Overtime shifts a paycheck more than most people expect, and the extra hours blur together. This overtime pay estimator splits each week into regular hours and overtime hours using the threshold you set, then prices them with your hourly rate and an overtime multiplier. The Weeks tab shades any week with overtime. The Totals tab adds up total, regular and overtime pay, the overtime hours, how many weeks had overtime and the share of pay that came from it, with a doughnut chart beside the figures.
The Rules tab holds three cells: rate, hours before overtime and multiplier. The sample uses a forty-hour week and time and a half, but overtime rules differ by state, contract and type of job, so change them to fit yours and confirm them with your employer or state labor office. Fourteen sample weeks show a mix of short and long weeks. Compare the estimate with your pay stub each period.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Weeks tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
Take the hours above the weekly threshold, multiply by your hourly rate and then by the overtime multiplier. At $21.40 and time and a half, four overtime hours pay $128.40. Regular hours are paid at the plain rate.
It means each overtime hour pays 1.5 times the regular hourly rate. Set the multiplier cell to 1.5 for time and a half or 2 for double time.
Often, but not always. Rules depend on your location, job type and agreement, and some places also count daily hours. Enter the threshold that applies to you in the Rules tab.

Docs + Word6 pages
FeaturedFree
Excel
FeaturedFree
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel6 tabs
Free
Sheets + Excel6 tabs
Free
Sheets + Excel4 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
Free