Enter or review these records before relying on the summary.
Suggested for your taskFor workers reviewing their own shifts and pay estimates
Shift Hours & Pay Review Workbook
The shift you planned. The hours you actually worked.
Keep planned and actual shifts separate, record unpaid breaks and review one chosen overtime rule. Historical entered rates stay with the actual shift; estimates are separate from a real payslip.
No native edition compatibility verified. Spreadsheet software is separate.
- Format
- Excel · .xlsx
- Inside
- 10 worksheets
- Included
- Clean file + example + guide
Check the capacity and fitWho it is for, supplied record limits and software requirements
The everyday problem
The shift you planned. The hours you actually worked.
Keep planned and actual shifts separate, record unpaid breaks and review one chosen overtime rule. Historical entered rates stay with the actual shift; estimates are separate from a real payslip.
Optional guideNeed help getting started?Choose where to begin. All listed files are included.
Add the complete product to your cart whenever you’re ready. Use this guide only if you’d like help choosing what to open first; your choices do not change the product or its price.
Guide step 1 of 4
What would you like to do?
Pick a useful task, or build your own selection.
Which sheets would you explore first?
Choose your starting points. The workbook keeps all its connected sheets and formulas; this does not remove or rebuild worksheets.
Nothing selected yet.
Enter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskWhich file would you open first?
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Your starting plan.
Your first file or method
Both XLSX files, all 10 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the complete setup guideThe complete product. Your starting choices do not change its contents or price.
Your choices help you understand the complete product. They do not alter its contents or price.
Both XLSX files, all 10 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the tasks, contents and file choices
Useful starting tasks
Plan the time. Use the included START_HERE.pdf guide to follow one complete task in a disposable example copy.
Choose my own starting points. Explore the contents and select only the parts you would use first.
Contents to explore
- Dashboard: Enter or review these records before relying on the summary.
- Start: Enter or review these records before relying on the summary.
- Settings: Enter or review these records before relying on the summary.
- Jobs: Enter or review these records before relying on the summary.
- Planned Shifts: Enter or review these records before relying on the summary.
- Actual Shifts: Enter or review these records before relying on the summary.
- Breaks: Enter or review these records before relying on the summary.
- Leave: Enter or review these records before relying on the summary.
- Pay Periods: Enter or review these records before relying on the summary.
- Period Review: Enter or review these records before relying on the summary.
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Explore the worked example: Fictional records show how the sheets work together. Save a disposable copy before trying a change. shift-hours-example.xlsx
Start my own working copy: Open the clean workbook after reading the guide. Keep the original and save a copy for your own records. shift-hours-clean.xlsx
Follow the complete first taskUse the included guide and a disposable example copy.
Your first useful session / Start with the example
Plan the time
Follow this one complete task before entering your own records. Keep the blank original and save a working copy.
Plan the time
Create a Job ID and planned shifts using full date-times. Cancelled plans stay in the history.
Inspect Planned ShiftsRecord what happened
Actual Shifts holds actual start/end, the applicable rate and one overtime rule. Add unpaid or paid breaks using the actual Shift ID.
Inspect Actual ShiftsCheck the payslip period
Enter a non-overlapping pay period for the job. Period Review compares recorded actual gross with the gross amount on your payslip.
Inspect Period Review
EVERY WORKSHEET / ACTUAL EXAMPLE FILE
See what you enter.
Understand what updates.
Inspect all 10 sheets. These are images of the delivered example, with fictional records. Open an image to read its full detail.
Actual example worksheet · Preview range A1:E29. Image only; entries are made in your downloaded workbook.
Dashboard
Dashboard: Labelled results and source warnings.
- You enter
- Review linked input records
- Calculated or supplied reference
- Labelled results and source warnings
Actual example worksheet · Preview range A1:D40. Image only; entries are made in your downloaded workbook.
Start
Start: First useful task.
- You enter
- Read the route through the file
- Calculated or supplied reference
- First useful task
Actual example worksheet · Preview range A1:D27. Image only; entries are made in your downloaded workbook.
Settings
Settings: Chosen settings.
- You enter
- Review date, period and chosen assumptions
- Calculated or supplied reference
- Chosen settings
Actual example worksheet · Preview range A1:D14. Image only; entries are made in your downloaded workbook.
Jobs
Jobs: 10 supplied input rows.
- You enter
- Record ID, Job / employer, Rate / policy reference
- Calculated or supplied reference
- Input check
Actual example worksheet · Preview range A1:H14. Image only; entries are made in your downloaded workbook.
Planned Shifts
Planned Shifts: 400 supplied input rows.
- You enter
- Record ID, Job ID, Starts, Ends, Place / short plan, State
- Calculated or supplied reference
- Planned hours
Actual example worksheet · Preview range A1:R14. Image only; entries are made in your downloaded workbook.
Actual Shifts
Actual Shifts: 400 supplied input rows.
- You enter
- Record ID, Job ID, Started, Ended, Hourly rate, Overtime rule, Threshold hours, Overtime multiplier, Planned Shift ID (optional), Reference / short note
- Calculated or supplied reference
- Unpaid break hours, Paid hours, Regular hours, Overtime hours, Estimated gross, Start day, Week begins
Actual example worksheet · Preview range A1:H14. Image only; entries are made in your downloaded workbook.
Breaks
Breaks: 800 supplied input rows.
- You enter
- Record ID, Actual Shift ID, Starts, Ends, Paid, Reference / short note
- Calculated or supplied reference
- Hours
Actual example worksheet · Preview range A1:G14. Image only; entries are made in your downloaded workbook.
Leave
Leave: 100 supplied input rows.
- You enter
- Record ID, Job ID, Starts, Ends, State, Type / confirmation
- Calculated or supplied reference
- Input check
Actual example worksheet · Preview range A1:L14. Image only; entries are made in your downloaded workbook.
Pay Periods
Pay Periods: 80 supplied input rows.
- You enter
- Record ID, Job ID, Period begins, Period ends, Payslip gross (optional), Paid on (optional), Payslip reference
- Calculated or supplied reference
- Recorded paid hours, Recorded gross, Gross difference, Review state
Actual example worksheet · Preview range A1:G19. Image only; entries are made in your downloaded workbook.
Period Review
Period Review: Calculated review of linked records.
- You enter
- Review linked input records
- Calculated or supplied reference
- Calculated review of linked records
Follow the supplied fictional exampleRead the inputs and the result together
From the supplied fictional example
The supplied fictional example
20:00 to 06:00 is 10 elapsed hours. A 30-minute unpaid break leaves 9.5 paid hours. At $20, with 8 regular hours and a 1.5 daily multiplier, gross is $205.
- Actual shift
- 20:00–06:00
- Unpaid break
- 30 minutes
- Hourly rate
- USD 20
- Overtime rule
- 1.5× after 8 hours
- Paid hours
- 9.5
- Gross estimate
- USD 205
FOLLOW THE ACTUAL EXAMPLE FILE
The supplied fictional example
Fictional records from the supplied example XLSX. Follow the same references through the sheets, then start your own clean copy.
The records behind the result
Actual shift 20:00–06:00
Unpaid break 30 minutes
Hourly rate USD 20
Overtime rule 1.5× after 8 hours
20:00 to 06:00 is 10 elapsed hours. A 30-minute unpaid break leaves 9.5 paid hours. At $20, with 8 regular hours and a 1.5 daily multiplier, gross is $205.
- Paid hours
- 9.5
- Gross estimate
- USD 205
This is an explanation of the downloadable workbook, not an online editor. Its complete clean and worked files are included. Save a working copy. Manual entry, with no automatic sync or external connections.
Inspect the actual worksheetsFrom setup to a regular review
How you use it.
Open the 3-step setup and review routineInputs, calculations and the decision each step supports
- 01
Plan the time
You enterCreate a Job ID and planned shifts using full date-times. Cancelled plans stay in the history.
CalculatedThe linked records and input checks use the same stable IDs and your chosen dates.
Your next stepReview the labelled results and correct source warnings before acting.
- 02
Record what happened
You enterActual Shifts holds actual start/end, the applicable rate and one overtime rule. Add unpaid or paid breaks using the actual Shift ID.
CalculatedThe linked records and input checks use the same stable IDs and your chosen dates.
Your next stepReview the labelled results and correct source warnings before acting.
- 03
Check the payslip period
You enterEnter a non-overlapping pay period for the job. Period Review compares recorded actual gross with the gross amount on your payslip.
CalculatedThe linked records and input checks use the same stable IDs and your chosen dates.
Your next stepReview the labelled results and correct source warnings before acting.
10 sheets. Inspect each one.Inputs, outputs and when to use every worksheet
StartOpen sheet details
Editable inputs
- Read the route through the file
Calculated or reference
- First useful task
Enter or review these records before relying on the summary.
Inspect the actual Start sheetSettingsOpen sheet details
Editable inputs
- Review date, period and chosen assumptions
Calculated or reference
- Chosen settings
Enter or review these records before relying on the summary.
Inspect the actual Settings sheetJobsOpen sheet details
Editable inputs
- Record ID, Job / employer, Rate / policy reference
Calculated or reference
- Input check
Enter or review these records before relying on the summary.
Inspect the actual Jobs sheetPlanned ShiftsOpen sheet details
Editable inputs
- Record ID, Job ID, Starts, Ends, Place / short plan, State
Calculated or reference
- Planned hours
Enter or review these records before relying on the summary.
Inspect the actual Planned Shifts sheetActual ShiftsOpen sheet details
Editable inputs
- Record ID, Job ID, Started, Ended, Hourly rate, Overtime rule, Threshold hours, Overtime multiplier, Planned Shift ID (optional), Reference / short note
Calculated or reference
- Unpaid break hours, Paid hours, Regular hours, Overtime hours, Estimated gross, Start day, Week begins
Enter or review these records before relying on the summary.
Inspect the actual Actual Shifts sheetBreaksOpen sheet details
Editable inputs
- Record ID, Actual Shift ID, Starts, Ends, Paid, Reference / short note
Calculated or reference
- Hours
Enter or review these records before relying on the summary.
Inspect the actual Breaks sheetLeaveOpen sheet details
Editable inputs
- Record ID, Job ID, Starts, Ends, State, Type / confirmation
Calculated or reference
- Input check
Enter or review these records before relying on the summary.
Inspect the actual Leave sheetPay PeriodsOpen sheet details
Editable inputs
- Record ID, Job ID, Period begins, Period ends, Payslip gross (optional), Paid on (optional), Payslip reference
Calculated or reference
- Recorded paid hours, Recorded gross, Gross difference, Review state
Enter or review these records before relying on the summary.
Inspect the actual Pay Periods sheetPeriod ReviewOpen sheet details
Editable inputs
- Review linked input records
Calculated or reference
- Calculated review of linked records
Enter or review these records before relying on the summary.
Inspect the actual Period Review sheetDashboardOpen sheet details
Editable inputs
- Review linked input records
Calculated or reference
- Labelled results and source warnings
Enter or review these records before relying on the summary.
Inspect the actual Dashboard sheetFiles, capacities and practical limitsRead these before choosing your working copy
The download
Files with a purpose.
START_HERE.pdf
One guide: first session, file index, practical limits, recovery and license.
shift-hours-clean.xlsx
Empty workbook. Save As a working copy before entering your records.
shift-hours-example.xlsx
The same workbook with fictional records and checked results.
English instructions, sheet names and field labels.
Before you choose
Fit and practical limits.
- For workers reviewing their own shifts and pay estimates
Understand the boundaries.
- Save a working copy. Manual entry, with no automatic sync or external connections.
- Supplied tables have fixed capacities. Extend formulas, tables and validation together before using extra rows.
- Use one currency. Blank means unknown; enter 0 when the amount is known to be zero.
- Resolve the highlighted input rows before relying on the summary.
- Enter full start and end date-times. Overnight hours belong to the shift start day and its Monday-start week.
- Choose one overtime rule per job and week: None, Daily or Weekly. These rules do not stack. Enter confirmed historical rate, threshold and multiplier for each actual shift.
- Supplied rows: 10 jobs, 400 planned shifts, 400 actual shifts, 800 breaks, 100 leave records and 80 pay periods.
- Gross estimates round each shift to cents and exclude taxes, deductions, paid leave and employment-law entitlements. They support your own payslip review.
No native edition compatibility verified. Local digital-engine tests are separate from native application verification.
Shift Hours & Pay Review Workbook / Version 1.0
Your own working copy.
Clean workbook, separate example and one START_HERE.pdf guide covering setup, practical limits and the internal-use license.
$9.90USD · One-time purchaseTaxes included where applicable.
Desktop spreadsheet software required; it is not included. Native Excel compatibility is still awaiting verification.
Digital download. Review availability and the final total in your cart.
Questions about this workbook
The details that affect your choice.
Must I connect an account?
No. The files use your manual records and have no external account connection.
Can I add unlimited records?
No. Supplied capacities are listed. Extend all affected formulas, tables and validations together before using extra rows.
Why does a result ask me to review inputs?
Correct the Input check at its source. Keep a backup before changing stable IDs, dates or assumptions; do not replace the formula with a typed result.