GEN-Z WEALTH EDUCATION

Master The Money Game

Your blueprint to financial freedom and building real wealth starting today. Learn the strategies schools forgot to teach.

10,000+
Students Funded
Confident young student ready to master wealth building
An empty, outdated classroom representing the failure of traditional education

THE SYSTEM IS BROKEN

What Schools Forgot To Teach

You spent over 15,000 hours in a classroom, yet graduated without knowing how to manage debt, invest in assets, or build lasting wealth. The traditional education system was designed to create workers, not owners. The wealth gap isn't just about money—it's about financial literacy.

Old School: Save your way to retirement.
Wealth Prep: Invest your way to freedom.

Old School: Avoid all debt at all costs.
Wealth Prep: Leverage good debt to scale.

Old School: Rely on a single income stream.
Wealth Prep: Diversify and protect cash flow.

THE BLUEPRINT

Your Roadmap To Independence

This curriculum is engineered to take you from financial uncertainty to complete clarity. Step-by-step, we will build your wealth engine and equip you with the skills traditional schools forgot to teach.

1

Financial Foundations

Master the basics of money management, budgeting, and debt elimination to build a rock-solid base.

2

Income Acceleration

Discover high-leverage skills and strategies to increase your earning potential and create multiple revenue streams.

3

Smart Investing

Learn how to put your money to work through proven investment vehicles, compound interest, and risk management.

4

Wealth Preservation

Protect your assets, minimize taxes legally, and design a long-term plan for generational wealth.

SUCCESS STORIES

Real Students.
Real Results.

Before this course, investing felt like a language I couldn't speak. Now I've built a diversified portfolio and finally feel in control of my financial future. The step-by-step guidance was exactly what I needed.

Sarah Jenkins
Sarah Jenkins
University Student

I always thought you needed thousands of dollars to start building wealth. Learning how to leverage small consistent investments completely changed my trajectory. I'm graduating with actual assets instead of just debt.

Marcus Chen
Marcus Chen
Senior Undergrad

The modules on budgeting and compound interest opened my eyes to what's possible in my twenties. I've already automated my savings and started my first index fund. This is the financial education schools forgot.

Elena Rodriguez
Elena Rodriguez
Recent Graduate

ENROLLMENT

Invest In Your Future

The cost of financial illiteracy is steep. By joining Prep Wealth Academy, you're gaining the exact blueprints to navigate money, investments, and your career—skills that will pay dividends for the rest of your life.

Skip the years of trial-and-error. For less than the cost of a typical college textbook, you get lifetime access to the foundational strategies traditional education simply missed.

LIFETIME ENROLLMENT

$197

One-time payment. Full lifetime access.

  • Complete Wealth Blueprint Modules
  • Private Student Community Access
  • Plug-and-Play Financial Templates
  • Live Monthly Q&A Sessions

14-Day Money-Back Guarantee. Risk-free enrollment.

WE'VE GOT ANSWERS

Clear Up The Details

Making the decision to invest in your financial education is a big step. We want you to feel completely confident before you join the academy. Here is everything you need to know about how the program works, your commitment, and our support.

14-Day Risk-Free Guarantee

Test drive the entire curriculum. If it is not a perfect fit for your goals, we will refund your investment in full.

How much time do I need to commit each week?

Most students spend about 3 to 5 hours per week watching the lessons and completing the exercises. The course is entirely self-paced, so you can easily fit it around your classes and existing schedule.

Do I need prior financial knowledge?

Not at all. The academy is built from the ground up for absolute beginners. We explain every concept in simple, jargon-free language before moving on to advanced strategies.

How long do I have access to the materials?

Once you enroll, you get lifetime access to the core modules and any future updates. You can revisit the roadmap whenever you need a refresher.

What if the course isn't right for me?

We offer a 14-day, no-questions-asked refund policy. If you dive into the lessons and feel it's not a perfect fit, simply let our team know and we will return your investment.

Will I get help if I get stuck?

Absolutely. You will have access to our private community forum where you can ask questions, share wins, and get support directly from our mentors and fellow students.

NEXT COHORT STARTING SOON

Start Your Journey Today

Secure your spot now and take the final step toward financial independence.

14-Day Money-Back Guarantee • Instant Access

Prep Wealth Academy Logo

Empowering the next generation with the financial literacy traditional education systems left behind.

Join The Community

© 2026 Prep Wealth Academy. All rights reserved.
Disclaimer: The educational content provided by Prep Wealth Academy is for informational purposes only and does not constitute financial advice.

Prep Wealth Academy | Workplace Career Training
Workplace Career Training

Don't Get Stuck Because You Weren't Trained

Prep Wealth Academy was created to help the workplace employee break out of one field and grow into new roles — through trustworthy, in-depth professional training you can apply on day one.

2Courses
47+Lessons
76+Test Questions
100%Practical
Built for the Workplace Employee Ready to Level Up

Most employees hit a wall — not because they lack ambition, but because they were never trained in the skills that open new doors. Payroll compliance, timekeeping systems, HR processes: these are the skills employers pay more for, and they are rarely taught in school.

Prep Wealth Academy was founded to change that. We build comprehensive, real-world training programs that give you the exact knowledge you need to cross into new fields, earn promotions, and take control of your career trajectory.

Every course is structured like on-the-job training — detailed, practical, and tested. No fluff. No vague theory. Just the skills you need to show up and perform from day one.

🎯

Real-World Focus

Every lesson mirrors actual job responsibilities and workflows used by employers today.

📚

In-Depth Content

No surface-level overviews. We go deep into the systems, laws, reports, and processes you will actually use.

Tested Knowledge

Chapter quizzes and a final exam ensure you actually retain what you learn — not just watch it.

🚀

Career Mobility

Gain the credentials and confidence to move into new roles, departments, and opportunities.

Training That Actually Prepares You
📋

Job-Ready from Day One

Our courses mirror real employer expectations. You learn the exact reports, systems, and workflows used in today's workplaces — not hypothetical textbook scenarios.

⚖️

Compliance & Accuracy

From FLSA to FICA to state garnishment laws — our payroll and timekeeping content covers every compliance requirement you will encounter in the field.

🧠

Quiz After Every Chapter

Retention is built in. Every chapter ends with a quiz and each course concludes with a scored final exam so you leave with demonstrated knowledge, not just familiarity.

💼

Professional Skills Gap

Millions of employees are passed over for roles because they lack exposure to adjacent skills. Our courses bridge that gap — from timekeeping to payroll, HR to finance.

🖥️

System Walkthroughs

Step-by-step walkthroughs of Workday and ADP give you platform familiarity before you ever sit down at a real desk. See the screens, follow the workflows, build muscle memory.

📈

Expand Your Earning Power

Employees who cross-train into payroll, compliance, and HR analytics command higher salaries and unlock promotion paths that single-skill workers never see.

Choose Your Career Track

Two comprehensive professional training courses. Each includes detailed lessons, chapter quizzes, system walkthroughs, and a final certification exam.

Payroll Compliance

Payroll Compliance Mastery

A real-world training course covering every critical skill needed to work as a Payroll Compliance Analyst — from reports and audits to labor laws and Excel shortcuts.

📖7 Chapters 🎯35+ Lessons 📝56 Test Qs 100% Practical
  • A Day in the Life of a Payroll Compliance Analyst
  • Core Payroll Systems: Workday + ADP
  • Critical Reports: Payroll Register, Exception, Tax Liability, GL
  • Pre-Payroll, Post-Payroll & Quarterly Audits
  • Labor Laws: FLSA, FMLA, FICA, State & Garnishment
  • Compliance Risk Management & Documentation
  • Excel Shortcuts, Pivot Tables, VLOOKUP & SUMIF
  • Full System Walkthrough + Final Exam
Timekeeping

Timekeeping Mastery

A field guide to mastering Track — from the Activity Screen to allocations, equipment, and daily reporting. Includes authentic walkthroughs from the Timekeeper's Playbook.

📖4 Parts 🎯12 Lessons 📝20 Test Qs 100% Practical
  • Foundations & the Activity Screen
  • Daily Time Entry & Allocation Workflows
  • Equipment Tracking & Assignment
  • Reports: Daily, Weekly & Summary Views
  • Common Errors & How to Correct Them
  • Supervisor Review & Approval Process
  • Compliance Documentation & Audit Trails
  • Final Test with Scored Assessment
Real People. Real Growth.
★ ★ ★ ★ ★

"I had been in the same entry-level HR role for three years. After completing the Payroll Compliance Mastery course, I was able to transition into a payroll analyst position."

J
Jasmine T.
HR to Payroll Analyst
★ ★ ★ ★ ★

"The Timekeeping course was exactly what I needed before starting my new job. My supervisor was shocked that I already knew the system."

M
Marcus R.
Field Operations Coordinator
★ ★ ★ ★ ★

"I appreciated how detailed and honest the content was. This wasn't a generic overview — it was actual job training. I passed my final exam with a 92%."

D
Danielle W.
Payroll Compliance Student
© 2026 Prep Wealth Academy

Welcome back, Student

Pick up where you left off — your career growth is one lesson away.

Courses Enrolled
2
Chapters Completed
0 / 0
Quiz Average
88%
Communities Joined
3

My Courses

Payroll Compliance0%

Payroll Compliance Mastery

Continue Course →
Timekeeping0%

Timekeeping Mastery

Continue Course →
💼
Payroll Pros Network
2,847 members
Subscribed
⏱️
Timekeeping Field Crew
912 members
Subscribed
🚀
Career Growth Circle
5,103 members
Subscribed
Prep Wealth Academy

Payroll Compliance Mastery

A real-world training course covering every critical skill needed to work as a Payroll Compliance Analyst — from reports and audits to labor laws and Excel shortcuts.

7
Chapters
35+
Lessons
56
Test Qs
100%
Practical
Your Progress
Ch 1
Ch 2
Ch 3
Ch 4
Ch 5
Ch 6
Ch 7
Exam
Chapter OneA Day in the Life of a Payroll Compliance Analyst

This chapter walks you through a real payroll workday — hour by hour. By the end you'll understand the pace, the priorities, the tools, and the mindset required to thrive in this high-impact role. This is what a typical day looks like in a corporate, construction, or oil & gas environment.

💼

Your Role at a Glance

A Payroll Compliance Analyst is responsible for making sure every employee is paid correctly, on time, and in full compliance with federal, state, and local law. You are the last line of defense between the company and costly IRS penalties, DOL investigations, and employee lawsuits. You work across Workday, ADP SmartCompliance, and Excel every single day.

🌅 7:30 AM — 10:00 AM
Morning: Compliance Check + Payroll Prep
You start your day before anyone else is thinking about payroll. Log into Workday, check your dashboard for overnight alerts, review any emails from ADP SmartCompliance, and scan the exception report first thing.
🔍 10:00 AM — 12:30 PM
Mid-Morning: Audits + Issue Resolution
Shift into audit mode. You run gross-to-net checks, verify deductions, hunt down discrepancies, and communicate with HR and managers to resolve anything blocking payroll.
🍽️ 1:30 PM — 3:30 PM
Early Afternoon: Advisory + Process Improvement
You step into a strategic role — advising leadership on compliance risks, documenting processes, and helping implement policy changes driven by new laws or internal findings.
⚙️ 3:30 PM — 5:30 PM
Late Afternoon: Payroll Processing + Reporting
Execution time. Finalize batches, run reports, confirm deadlines, and submit. This window is non-negotiable — payroll must go out on time.
🌙 5:30 PM — 6:00 PM+
End of Day: Wrap-Up + Planning
Document unresolved issues, set tomorrow's priorities, and track upcoming compliance deadlines. In heavy payroll periods — expect to stay late.
Chapter OneA Day in the Life of a Payroll Compliance Analyst
🌅
Lesson 1.1
Morning Routine: Compliance Check + Payroll Prep (7:30–10:00 AM)

Your morning sets the tone for the entire payroll cycle. Before you run a single report, you need to understand the landscape — what changed overnight, what alerts are waiting, and what could stop payroll from going out on time.

Step-by-Step Morning Flow

  • Log into Workday and immediately check the Payroll Dashboard for status alerts
  • Open ADP SmartCompliance — look for any tax notices, rejected filings, or deposit alerts
  • Review your email inbox for HR communications: new hires, terminations, salary changes, LOA notices
  • Check for any new federal or state tax table updates (IRS publishes changes regularly)
  • Pull the overnight exception report and note all flagged timecards
  • Confirm pay calendar — is today a regular processing day or a deadline day?

What You're Watching For

  • Any employee whose classification changed (W-2 vs 1099) — affects tax treatment
  • New hires who need to be set up correctly before this payroll runs
  • Employees on FMLA or LOA — are their deductions suspended correctly?
  • Recent state law changes that affect withholding rates or overtime rules

Pro Tip: Create a morning checklist in Excel and check off each item before you even open the payroll register. Analysts who skip this step are the ones who catch errors after payroll has already been submitted.

⚠️ Real Talk: In oil & gas and construction environments, overnight hours are common — timecards can change up until midnight. Always pull your exception report as close to your processing window as possible.

Chapter OneA Day in the Life of a Payroll Compliance Analyst
🔍
Lesson 1.2
Mid-Morning: Audits + Issue Resolution (10:00 AM–12:30 PM)

This is the heaviest part of your day mentally. You are in problem-solving mode — finding errors, understanding their root cause, communicating with other departments, and documenting every correction you make.

Audit Workflow

  • Run Payroll Register in preview mode (do NOT finalize yet)
  • Compare gross-to-net for every employee — flag anything unusual
  • Verify deductions: health insurance, dental, 401k, HSA, garnishments, child support
  • Use ADP SmartCompliance to confirm tax amounts align with liability report
  • Review any employees with zero federal tax withholding — check W-4 setup
  • Confirm all overtime is at 1.5x rate and was properly authorized

Issue Resolution Process

  • Log every issue in a running audit tracker (date, employee, issue type, action taken)
  • For missing time: contact the supervisor or use the employee's historical average (per company policy)
  • For unapproved time: escalate to HR if manager is unresponsive — don't hold up payroll
  • For pay rate mismatches: cross-reference with the HR system of record, never guess

💡 Documentation Rule: Every correction you make must have a paper trail. If you ever face a DOL audit, your audit log is your defense. Date, time, reason, and action — every time.

Who You Work With

  • HR Team — status changes, new hires, terminations, classification questions
  • Department Managers — time approvals, overtime authorization, missing punches
  • Finance/Accounting — GL reconciliation, budget questions, expense allocations
Chapter OneA Day in the Life of a Payroll Compliance Analyst
🍽️
Lesson 1.3
Early Afternoon: Advisory + Process Improvement (1:30–3:30 PM)

This is where you transition from technician to advisor. You're not just fixing errors anymore — you're preventing them at the system level and keeping the company ahead of regulatory changes.

Advisory Responsibilities

  • Brief HR leadership on any compliance risks discovered during morning audits
  • Review and update SOPs (Standard Operating Procedures) for payroll processing
  • Monitor legislative trackers for new wage laws, overtime rule changes, or tax updates
  • Help draft policy memos when new laws require process changes
  • Prepare documentation packages for any upcoming external audits

Process Improvement Tasks

  • Analyze recurring errors — are the same types of mistakes happening every pay period?
  • Work with IT or Workday admins to fix system configurations that cause repeat issues
  • Build or update Excel dashboards that auto-flag common error patterns
  • Recommend manager training if time approval errors are systemic

Career Impact: Analysts who move into advisory roles earn significantly more. Being the person who prevents problems — not just fixes them — is what gets you promoted to Senior Payroll Analyst, Payroll Manager, or Compliance Director.

Chapter OneA Day in the Life of a Payroll Compliance Analyst
⚙️
Lesson 1.4
Late Afternoon: Payroll Processing + Reporting (3:30–5:30 PM)

This is execution time. Everything you've done all day leads to this window. Payroll goes out here — and it must be right.

Pre-Submission Final Checklist

  • All timecards approved — zero unapproved entries remaining
  • Exception report cleared — all flagged items resolved or documented
  • Payroll Register reviewed — no negative net pay, no missing taxes, no OT errors
  • Tax liability reconciled — Workday totals match ADP figures
  • GL postings reviewed — all cost centers correctly coded
  • Supervisory approvals in place — any manual overrides documented

Reports You Run at Submission

  • Final Payroll Register — your record of what was paid
  • Tax Liability Summary — what was withheld and what's owed
  • Payroll Summary by Department — for Finance and management reporting
  • Garnishment Detail Report — confirm all legal deductions were applied correctly

⚠️ Deadline Reality: In construction and oil & gas environments with weekly payroll cycles, missing the 3 PM submission window can delay pay for hundreds of workers. This creates legal liability under state wage payment laws. Deadlines are non-negotiable.

Chapter OneA Day in the Life of a Payroll Compliance Analyst
🌙
Lesson 1.5
End of Day + What This Role Really Feels Like

Before you log off, you set yourself up for success tomorrow.

  • Document all unresolved issues in your audit log with priority levels
  • Note any employee situations that need follow-up (FMLA return dates, garnishment updates, etc.)
  • Check the compliance calendar — are any quarterly deadlines approaching?
  • Set your top 3 priorities for tomorrow morning

The Real Day-to-Day Feel

  • Fast-paced but highly structured — there's a rhythm once you learn it
  • High responsibility — payroll errors affect real people's ability to pay rent and feed their families
  • Mix of data analysis, compliance enforcement, and team collaboration
  • Requires constant learning — laws change, systems update, companies grow

The Bottom Line: This isn't just a "numbers job." You protect the company from government penalties, ensure employees are paid correctly and on time, and serve as the compliance backbone of the entire organization. The pay reflects that responsibility — experienced payroll compliance analysts earn $65,000–$110,000+ depending on industry and location.

Chapter OneA Day in the Life of a Payroll Compliance Analyst
📝
Chapter 1 Quiz
1. What is the FIRST thing you should do every morning as a Payroll Compliance Analyst?
ARun the final payroll batch immediately to meet the deadline early
BLog into Workday, check dashboard alerts, and pull the exception report
CCall HR to confirm employee headcount
DSubmit quarterly tax filings in ADP
2. Which time block is dedicated to finalizing and submitting payroll?
A7:30–10:00 AM
B10:00 AM–12:30 PM
C1:30–3:30 PM
D3:30–5:30 PM
3. Who do you typically collaborate with during the mid-morning audit phase?
AFinance and Legal only
BHR and Department Managers
CIT and the Payroll vendor
DExecutives and external auditors
4. Why is the early afternoon advisory period important for career growth?
AIt lets you leave early
BIt's optional busy work
CIt positions you as a strategic compliance resource, not just a processor — leading to promotions
DIt's required only for senior analysts
Chapter TwoCore Systems You'll Use Daily

Three platforms power everything you do as a Payroll Compliance Analyst: Workday, ADP SmartCompliance, and Microsoft Excel. This chapter gives you a deep walkthrough of each — the exact navigation paths, what each tool does, and how they connect together.

🔄

How the Three Systems Work Together

Workday is your payroll processing engine — timecards, calculations, and registers all live here. ADP SmartCompliance handles the tax side — filings, deposits, and compliance. Excel is your analysis layer — where you reconcile, flag errors, and present data to leadership. Data flows from Workday → ADP → Excel for the full compliance picture.

Chapter TwoCore Systems You'll Use Daily
🖥️
Workday
Primary Payroll Engine

Workday is where payroll lives from start to finish. Every timecard, every calculation, every register runs through here.

  • Dashboard: Workday → Payroll Dashboard — Status, alerts, in-progress batches
  • Exception Report: Workday → Time Tracking → Reports → Time Entry Exceptions
  • Time Approvals: Workday → Time Tracking → Approvals
  • Calculate Payroll: Workday → Payroll → Calculate Payroll
  • Payroll Register: Workday → Payroll → Results → Payroll Register
  • GL Report: Workday → Payroll Accounting
  • Employee Setup: Workday → HR → Workers → [Employee] → Pay
  • Finalize: Workday → Payroll → Finalize Payroll
Chapter TwoCore Systems You'll Use Daily
🛡️
ADP SmartCompliance
Tax & Compliance Hub

ADP SmartCompliance handles all tax obligations — federal, state, and local. It receives payroll data from Workday and manages the filing and payment side automatically.

  • Tax Liability: ADP → Tax → Liability Reports — What's owed vs collected
  • Quarterly Filings: ADP → Tax Filing → Quarterly Filings — Form 941, state filings
  • Form 941: ADP → Tax Filing → Quarterly Filings → 941
  • Compliance Dashboard: ADP → Compliance Dashboard — Gaps, deadlines, alerts
  • Tax Deposit Schedule: ADP → Tax → Deposit Schedule
  • Year-End W2s: ADP → Year End → W-2 Processing

⚠️ ADP SmartCompliance and Workday can show different tax totals if payroll data wasn't transmitted correctly. Always reconcile both systems before the quarterly filing deadline.

Chapter TwoCore Systems You'll Use Daily
📊
Microsoft Excel
Analysis + Reconciliation Layer

Excel is where you catch what the systems miss. It's your reconciliation tool, error-flagging engine, and reporting platform for leadership. Mastering Excel in payroll context is what separates junior analysts from senior ones.

  • Reconcile Workday register data vs ADP tax reports
  • Build pivot tables to summarize payroll by department, location, or employee type
  • Flag errors automatically using IF, VLOOKUP, and conditional formatting
  • Create audit log trackers with timestamps
  • Build payroll dashboards that auto-update from raw data exports
  • Track quarterly deadlines in a master compliance calendar
Chapter TwoCore Systems You'll Use Daily
💡
Lesson 2.4
How These Systems Connect — The Full Data Flow

Understanding how Workday, ADP, and Excel connect helps you troubleshoot when something breaks — and something always breaks.

The Payroll Data Flow

  • Step 1: Employees clock in/out → time data flows into Workday Time Tracking
  • Step 2: Managers approve timecards in Workday
  • Step 3: You run payroll calculation in Workday — system applies rates, OT, deductions, taxes
  • Step 4: Finalized payroll transmits to ADP SmartCompliance for tax filing and deposit
  • Step 5: You export payroll register data to Excel for audit and reconciliation
  • Step 6: You compare Excel data to ADP liability report to confirm alignment

Where Breakdowns Happen

  • Workday → ADP transmission failures (tax data doesn't make it to ADP)
  • Employee setup errors in Workday that cascade into ADP tax calculations
  • Manual overrides in Workday that don't reflect in ADP totals
  • Data export formatting issues that corrupt Excel analysis

💡 Always run your Excel reconciliation AFTER ADP confirms receipt of the payroll transmission. If ADP didn't receive the data, your filing will be wrong.

Chapter TwoCore Systems You'll Use Daily
📝
Chapter 2 Quiz
1. Where do you navigate in Workday to view the Payroll Register?
AWorkday → Reports → Tax Summary
BWorkday → Payroll → Results → Payroll Register
CADP → Payroll → Results
DWorkday → Time Tracking → Register
2. Which system handles tax filings, Form 941, and deposit schedules?
AWorkday
BMicrosoft Excel
CADP SmartCompliance
DQuickBooks
3. In the payroll data flow, what happens AFTER you finalize payroll in Workday?
AYou immediately export to Excel
BPayroll data transmits to ADP SmartCompliance for tax filing and deposit
CYou call the IRS to confirm
DEmployees are automatically notified
Chapter ThreeCritical Reports — What, Where, How & Why

Reports are your eyes and ears. These four reports drive every decision you make in a payroll cycle. Know where to pull them, what every field means, what red flags look like, and exactly how to act on what you find.

Chapter ThreeCritical Reports — What, Where, How & Why
📋
Lesson 3.1
Payroll Register Report — The Most Critical Report

The Payroll Register is the master record of every dollar paid in a payroll cycle. It shows you gross pay, all deductions, tax withholdings, and net pay for every employee. This is your final validation before payroll submits.

Where to Find It

Key Fields to Review

FieldWhat It ShowsWhat to Check
Gross PayTotal earnings before deductionsMatches hours × rate; OT at 1.5x
Federal Income Tax (FIT)Withheld per W-4 instructionsNever $0 unless employee claimed exempt
State Income Tax (SIT)Varies by stateTexas = $0 (no SIT); all others check rate
FICA (SS + Medicare)6.2% + 1.45% employee shareStops at SS wage base; Medicare continues
Benefit DeductionsHealth, dental, 401k, HSAMatch enrollment elections on file
GarnishmentsChild support, levies, creditorApplied per legal order — exact amounts
Net PayWhat employee actually receivesMUST be positive; never $0 unless on leave

Red Flags That Require Immediate Action

  • Net pay is negative — deductions exceed gross pay
  • Federal tax shows $0 for a non-exempt employee — W-4 setup issue
  • Overtime hours paid at regular rate — FLSA violation
  • Duplicate employee entries — possible double payment
  • Benefit deduction amount changed without an HR event (open enrollment or life event)
  • Gross pay significantly higher or lower than prior period without a known reason

⚠️ This report is your LAST stop before payroll goes live. If you find an error here and submit anyway, you've just paid an employee incorrectly. Corrections require retro adjustments, additional communications, and sometimes IRS amended filings.

Chapter ThreeCritical Reports — What, Where, How & Why
Lesson 3.2
Exception Report — Your First Report Every Day

The Exception Report catches time-tracking problems before they become payroll problems. Run this every morning before you touch the Payroll Register.

Where to Find It

Exception Types and How to Handle Each

Exception TypeWhat It MeansYour Action
Missing PunchEmployee clocked in but not out (or vice versa)Contact supervisor; use prior week average if policy allows
Unapproved TimeManager hasn't signed off on hoursSend urgent reminder; escalate to HR if unresponsive
Overtime SpikeEmployee worked 50+ hoursConfirm authorization; verify 1.5x pay code is applied
Pay Rate MismatchRate in timecard ≠ rate in HR systemCross-reference HR record; never use the wrong rate
Duplicate EntrySame hours entered twiceDelete duplicate; document correction
Invalid Cost CenterHours coded to wrong departmentCorrect with manager approval; affects GL posting

💡 Workflow Tip: Sort your exception report by exception type, not by employee name. This lets you batch-resolve all "missing punch" issues together, then all "unapproved time" issues — much faster than working one employee at a time.

Chapter ThreeCritical Reports — What, Where, How & Why
💰
Lesson 3.3
Tax Liability Report — Your Compliance Shield

The Tax Liability Report tells you exactly how much tax the company owes vs how much was collected. Mismatches trigger IRS penalties — sometimes in the thousands per day.

Where to Find It

What to Reconcile Every Pay Period

  • Federal tax liability this period vs last period — variance over 10% needs investigation
  • State tax amounts by state — especially for companies with multi-state employees
  • FICA totals — confirm both employee and employer shares are correct
  • Local taxes (city, county) — often overlooked and frequently incorrect

IRS Deposit Schedule Rules

Total Tax LiabilityDeposit FrequencyDue Date
Under $2,500/quarterQuarterlyWith Form 941
$2,500–$50,000/year (lookback)Monthly15th of following month
Over $50,000/year (lookback)Semi-weeklyWednesday or Friday deposits

🚨 IRS Failure-to-Deposit Penalty: 2% if 1–5 days late. 5% if 6–15 days late. 10% if more than 15 days late. 15% if not deposited at all. These penalties apply to the TOTAL deposit — not just the late amount.

Chapter ThreeCritical Reports — What, Where, How & Why
📒
Lesson 3.4
General Ledger (GL) Report — Bridge to Finance

The GL Report is how Finance sees payroll. It breaks payroll costs into accounting entries by department, cost center, and expense type. Required for every audit.

Where to Find It

What You Reconcile

  • Total payroll expense matches the Payroll Register gross totals
  • Each department's labor cost is coded to the correct cost center
  • Tax liabilities are posted as the correct liability account codes
  • Benefit expenses match HR enrollment records

✅ Finance uses the GL Report to close the books each period. If your payroll GL entries are wrong, Finance can't close — and that creates pressure all the way up to the CFO. Being accurate here builds your credibility across the organization.

Chapter ThreeCritical Reports — What, Where, How & Why
📝
Chapter 3 Quiz
1. Which report should you run FIRST every morning before touching payroll?
AGeneral Ledger Report
BTax Liability Report
CException Report
DPayroll Register
2. An employee's Payroll Register shows negative net pay. What is the most likely cause?
AMissing timecard punches
BTotal deductions exceed gross pay
COvertime was not approved
DEmployee was classified as 1099
3. What is the IRS penalty for a tax deposit that is more than 15 days late?
A2%
B5%
C10%
D10% (more than 15 days) or up to 15% if not deposited at all
Chapter FourAudits You Must Perform

Auditing is not just something that happens to you — it's something you do proactively. Learn all four audit types, step-by-step procedures, what to look for, how to document findings, and how to present results to leadership.

🔎

The Four Audit Types

Every payroll cycle involves at least two types of audits. Pre-Payroll happens before submission. Post-Payroll happens after submission. Quarterly Audits align with IRS filing deadlines. Internal Compliance Audits are deep-dive reviews that happen periodically and during regulatory investigations.

Chapter FourAudits You Must Perform
Lesson 4.1
Pre-Payroll Audit — Your Most Important Quality Control Step

The pre-payroll audit is your final checkpoint before money moves. Run it every single pay period — no exceptions.

Complete Pre-Payroll Audit Checklist

  • Pull Exception Report — resolve all missing punches and unapproved time entries
  • Confirm 100% timecard approval — zero unapproved entries remaining
  • Run Payroll Register in preview mode — do NOT finalize
  • Check all new hires are set up correctly: W-4, pay rate, classification, deductions
  • Verify any terminations are processed: final pay calculated correctly per state law
  • Confirm retroactive pay adjustments are included where applicable
  • Validate overtime hours are at 1.5x — check pay code mapping in Workday
  • Verify benefit deduction amounts match current enrollment elections
  • Confirm garnishments are applied at the correct amount per legal order
  • Check employees on leave — are their deductions suspended or continued correctly?

🚨 Non-Negotiable Rule: Do not finalize payroll until the pre-payroll audit is 100% complete and all exceptions are resolved or formally documented. "I'll fix it next pay period" is not an option when people's rent depends on their paycheck.

Chapter FourAudits You Must Perform
🔁
Lesson 4.2
Post-Payroll Audit — Catch What Slipped Through

Even with a strong pre-payroll audit, things can slip through. The post-payroll audit is your safety net.

Post-Payroll Comparison Analysis

What to CompareWhere to Pull ItAction if Variance >5%
Total Gross PayCurrent vs prior Payroll RegisterIdentify employees driving variance
Total Tax WithheldCurrent vs prior ADP Liability ReportReconcile in Excel, investigate source
Employee HeadcountCount rows in registerResearch any missing or added employees
OT Hours TotalPivot by OT hours in ExcelConfirm all authorized; flag spikes
Deduction TotalsBenefits summary reportMatch to enrollment system

💡 Export both the current and prior period registers to Excel. Use VLOOKUP to match employee IDs and highlight rows where gross pay changed by more than 20% with no HR event. This takes 10 minutes and catches 90% of post-payroll issues.

Chapter FourAudits You Must Perform
📅
Lesson 4.3
Quarterly Audit — IRS Form 941 Reconciliation

Every quarter you must reconcile your payroll records to what ADP filed on Form 941. Discrepancies result in IRS notices, amended filings, and penalties.

Quarterly Audit Steps

  • Pull Form 941 from ADP SmartCompliance (Tax Filing → Quarterly Filings)
  • Pull Payroll Register summaries for all pay periods in the quarter
  • Compare: Line 2 (Wages) on 941 must match total gross wages in register
  • Compare: Line 5a (SS wages), 5c (Medicare wages) must match FICA-taxable wages
  • Verify all tax deposits were submitted on time (check deposit schedule)
  • Reconcile any discrepancies in Excel before the 941 due date

941 Due Dates

  • Q1 (Jan–Mar): Due April 30
  • Q2 (Apr–Jun): Due July 31
  • Q3 (Jul–Sep): Due October 31
  • Q4 (Oct–Dec): Due January 31

⚠️ If your 941 wages don't match your payroll register, the IRS will send a notice. At that point you're doing the same reconciliation work but now under IRS scrutiny with potential penalties already accruing.

Chapter FourAudits You Must Perform
🔎
Lesson 4.4
Internal Compliance Audit — The Deep Dive

The internal compliance audit is the most thorough audit you'll perform. It's triggered periodically or when there's reason to believe compliance gaps exist.

Step 1: Gather Your Data

  • Payroll Register — last 3–12 months
  • Employee master list from HR (name, classification, pay rate, hire date)
  • Tax Liability Reports from ADP
  • Benefit enrollment records
  • Garnishment orders on file

Step 2: Test Areas in Excel

  • OT Compliance: Flag all employees who worked over 40 hours — confirm 1.5x applied
  • Classification: Cross-reference W-2 vs 1099 workers with actual work arrangements
  • Tax Accuracy: Every employee should have FIT, FICA withheld (unless exempt)
  • Pay Equity: Compare pay rates across similar roles — document disparities
  • Deduction Accuracy: Compare deductions to enrollment elections

Step 3: Findings Report

IssueRisk LevelRecommended Fix
OT miscalculationHighFix pay code mapping; calculate back pay owed
Missing federal taxHighUpdate W-4 setup; file corrected 941 if needed
1099 vs W-2 misclassificationHighReclassify workers; consult legal counsel
Late time approvalsMediumImplement manager approval deadlines with HR
Benefit deduction mismatchMediumReconcile with HR benefits system
Missing garnishment updateLowProcess updated order immediately
Chapter FourAudits You Must Perform
📝
Chapter 4 Quiz
1. What is the non-negotiable rule of the pre-payroll audit?
ASubmit payroll as quickly as possible
BDo not finalize payroll until the pre-audit is 100% complete
COnly audit employees with overtime
DRun the GL report before the Exception report
2. Form 941 is due on what schedule?
AAnnually by January 31
BMonthly by the 15th
CQuarterly — last day of the month following each quarter end
DSemi-annually
3. You find that 20 workers classified as 1099 should be W-2. What risk level is this?
ALow — needs documentation
BMedium — fix at next audit
CHigh — IRS back taxes, penalties, DOL investigation risk
DNo risk if workers didn't complain
Chapter FiveLabor Laws & Compliance Risks

These are the federal and state laws that govern every decision you make in payroll. Know them deeply. A compliance analyst who doesn't understand the legal foundation behind the numbers is a liability — not an asset.

Chapter FiveLabor Laws & Compliance Risks
⚖️
Lesson 5.1
FLSA — Fair Labor Standards Act (The Foundation)

The FLSA is the most important federal employment law for payroll professionals. Every week, you are either complying with it or violating it — there's no in between.

What FLSA Governs

  • Federal minimum wage: $7.25/hr (many states are higher — always use the higher rate)
  • Overtime: Non-exempt employees must be paid 1.5x for ALL hours over 40 in a single workweek
  • Child labor restrictions (less relevant for most corporate payroll roles)
  • Recordkeeping: Employers must maintain accurate time and pay records for 3 years

Exempt vs Non-Exempt — The Critical Distinction

ClassificationOvertime Eligible?Requirements
Non-ExemptYes — 1.5x after 40 hrsMost hourly workers; some salaried under $684/week threshold
Exempt (Executive)NoManages 2+ employees; primary duty is management
Exempt (Administrative)NoOffice work; exercises independent judgment on significant matters
Exempt (Professional)NoAdvanced knowledge in field of science or learning
All Exempt EmployeesNoMust be paid at least $684/week on a salary basis

🚨 Biggest FLSA Mistake: Calling someone "salaried" does NOT automatically make them exempt from overtime. The job duties test must also be met. Misclassification = back pay for up to 2–3 years + liquidated damages equal to the back pay amount + attorney fees.

Common FLSA Violations in Payroll

  • Not counting pre-shift or post-shift time as hours worked
  • Deducting from a salaried employee's pay in ways that destroy the "salary basis" test
  • Averaging hours across a two-week period instead of calculating OT per workweek
  • Not including bonuses in the "regular rate" for OT calculation purposes
Chapter FiveLabor Laws & Compliance Risks
🏥
Lesson 5.2
FMLA — Family and Medical Leave Act

FMLA gives eligible employees up to 12 weeks of unpaid, job-protected leave per year. Your job is to make sure the payroll side is handled correctly throughout.

Payroll Requirements During FMLA

  • Unpaid FMLA: Stop regular wages during the unpaid portion — do NOT accidentally pay these weeks
  • Benefits continuation: Employee must maintain benefits during FMLA — their share of premiums still deducts
  • Track FMLA hours correctly in Workday — use the correct leave code
  • Return to work: Restore full pay on the correct return date immediately
  • Intermittent FMLA: Employee takes partial days/weeks — payroll must reflect actual hours only

⚠️ If you pay an employee during unpaid FMLA (even accidentally), that creates legal complexity around whether the leave counts. Always confirm leave status with HR before running payroll.

Chapter FiveLabor Laws & Compliance Risks
💳
Lesson 5.3
FICA — Federal Insurance Contributions Act

FICA funds Social Security and Medicare. You withhold the employee's share and the company matches it. Get this wrong and you owe both the employee's AND employer's portion.

Current FICA Rates (2024)

TaxEmployee RateEmployer RateWage Base
Social Security6.2%6.2%$168,600 (2024)
Medicare1.45%1.45%No limit
Additional Medicare0.9%NoneOver $200,000

Critical FICA Rules

  • Once an employee hits the Social Security wage base ($168,600), STOP withholding SS — Medicare continues with no cap
  • The Additional Medicare Tax (0.9%) applies to individuals over $200,000 — employer doesn't match this one
  • If you under-withhold FICA, the IRS holds the EMPLOYER liable for both shares
  • FICA applies to almost all wages — including tips, bonuses, and most fringe benefits
Chapter FiveLabor Laws & Compliance Risks
🚨
Lesson 5.4
Top 8 Compliance Risks That Get Companies Fined
RiskLaw ViolatedPotential Penalty
Misclassifying employees as 1099IRS / FLSABack taxes + penalties + liquidated damages
Not paying overtime at 1.5xFLSA2–3 years back pay + equal liquidated damages
Late federal tax depositsIRC §66562–15%+ of deposit amount per occurrence
Incorrect benefit deductionsERISAEmployee claims + DOL audit
Not paying final wages on timeState wage lawsCivil penalties + employee lawsuits
Improper garnishment processingConsumer Credit Protection ActCriminal charges for willful violations
Poor recordkeepingFLSA / IRSInability to defend + assumed liability
Retaliation against FMLA usersFMLALost wages + legal fees + reinstatement orders
Chapter FiveLabor Laws & Compliance Risks
📝
Chapter 5 Quiz
1. Under FLSA, at what point must non-exempt employees receive 1.5x overtime pay?
AAfter 45 hours per week
BAfter 40 hours in a single workweek
CAfter 80 hours in a bi-weekly pay period
DOvertime is optional per company policy
2. A salaried employee earns $500/week. Are they automatically exempt from overtime under FLSA?
AYes — all salaried employees are exempt
BNo — they must also meet the duties test AND earn at least $684/week to be exempt
CYes — any salary employee is automatically exempt
DOnly if they have the word "manager" in their title
3. What is the combined employee FICA rate (Social Security + Medicare)?
A5.0%
B6.2%
C7.65%
D12.4%
Chapter SixWorkday + ADP Payroll Simulation

You are the Payroll Analyst. It is payroll day. 250 employees. Weekly payroll. Deadline: 3:00 PM today. There are known issues. Walk through every step exactly as you would on the job.

🎯 Scenario Setup: Company: 250 employees | Payroll: Weekly (Friday pay date) | Mix: hourly + salaried + some construction OT | Known issues: timecard errors, overtime inconsistency, $7k tax liability mismatch from last period | Your deadline: 3:00 PM today

Chapter SixWorkday + ADP Payroll Simulation
🟢
Step 1 — 8:00 AM
Log In & Review Payroll Dashboard in Workday

What You See on Screen

  • Payroll Status: "In Progress — Week Ending [Date]"
  • 🔴 Alert: "Time Entry Errors: 17"
  • 🔴 Alert: "Unapproved Timecards: 9"
  • 🟡 Warning: "Pay Rate Change Pending Approval: 3 employees"

🚨 Decision Point: DO NOT run payroll. There are 17 errors and 9 unapproved timecards. Running payroll now means paying people incorrectly — and once checks go out, you're doing manual corrections, off-cycle adjustments, and possibly amended tax filings. Fix it first.

Chapter SixWorkday + ADP Payroll Simulation
🟢
Step 2 — 8:15 AM
Run the Exception Report

Exception Report Results

Issue TypeCountWhat You Do
Missing punches12Email supervisors immediately with deadline of 10 AM
Unapproved time5Ping managers on Slack; escalate to HR if no response by 9:30 AM
OT over 50 hours3 employeesPull authorization emails; confirm 1.5x pay code in Workday
Rate mismatch2 employeesCross-reference HR system; update pay rate in Workday

💡 Sort by exception type, not employee name. Batch-resolve all missing punches first (contact all 12 supervisors at once), then handle approvals, then OT.

Chapter SixWorkday + ADP Payroll Simulation
🟢
Step 3 — 9:00 AM
Resolve Time Approvals + Pending Pay Rate Changes

Issue Found

One manager (construction crew supervisor) has not approved 8 employees. He's in the field without cell service until 10 AM.

Decision Tree

  • Step 1: Send Slack + email message immediately with 10 AM deadline
  • Step 2: If no response by 10 AM → contact HR Manager to authorize manual approval
  • Step 3: If HR approves → you process on manager's behalf, document fully in audit log
  • Step 4: Notify manager after the fact; save all communications

Pay Rate Changes

  • 3 employees have pending pay rate changes in Workday awaiting approval
  • Contact HR to confirm: does this change apply to THIS pay period or next?
  • If yes → ensure effective date is correct before calculating
Chapter SixWorkday + ADP Payroll Simulation
🟢
Step 4 — 10:30 AM
Calculate Payroll + Review Register

System runs. Now immediately pull the Payroll Register and audit it.

Issues Found in Register

EmployeeIssueRoot CauseFix
John D.Net pay = -$142 ❌Health insurance deduction doubled this periodCorrect deduction to single amount; recalculate
Sarah M.Federal tax = $0 ❌W-4 marked "Exempt" incorrectlyUpdate W-4 in Workday; add withholding amount
Mike R.68 OT hours at regular rate ❌Pay code mapped to regular rate code, not OTFix pay code mapping; recalculate OT at 1.5x

🚨 Fix ALL three errors, then re-run Calculate Payroll again before proceeding. Never finalize with known errors.

Chapter SixWorkday + ADP Payroll Simulation
🟣
Step 5 — 12:00 PM
Switch to ADP: Tax Liability Review

Simulation Findings

Tax TypeThis PeriodLast PeriodVariance
Federal Income Tax$18,400$17,200+$1,200 ✅ Normal
Social Security$9,600$9,400+$200 ✅ Normal
Medicare$2,250$2,200+$50 ✅ Normal
Total Federal$30,250$23,100⚠️ +$7,150 — INVESTIGATE

Investigating the $7,150 Variance

  • Pull Workday payroll calculation report and compare to ADP total
  • Check if new employees were added this period (more FIT withheld)
  • Verify the OT fix for Mike R. added additional taxable wages
  • If variance is explained by known changes (OT, new hires) → document and proceed
  • If variance is unexplained → do not finalize until root cause is identified
Chapter SixWorkday + ADP Payroll Simulation
🟢
Step 6 — 2:00 PM
Final Checklist + Submit Payroll

Your Pre-Submission Checklist

  • All timecards approved ✅
  • Exception report cleared ✅
  • Payroll register errors fixed (John D, Sarah M, Mike R) ✅
  • Tax liability variance investigated and explained ✅
  • Pay rate changes effective date confirmed ✅
  • GL postings reviewed ✅
  • Audit log updated with all corrections ✅

🎉 Payroll submitted at 2:47 PM. 13 minutes before deadline. Now run your post-payroll reports and document everything in the audit log.

Chapter SixWorkday + ADP Payroll Simulation
📝
Chapter 6 Quiz
1. You log in and see "Unapproved Timecards: 9." What is your FIRST action?
ARun payroll immediately to meet the deadline
BContact the relevant managers to approve timecards before running payroll
CDelete the unapproved timecards
DSkip to the ADP tax review first
2. John D. shows net pay of -$142 on the register. What is the correct approach?
ASubmit payroll and fix it next period
BReview his deductions, identify and correct the over-deduction, recalculate payroll
CSet his net pay to zero manually
DContact the IRS
3. ADP shows a $7,150 higher federal tax liability vs last period. When is it safe to proceed?
AAlways — variance is normal
BOnly if the amount is under $10,000
COnly after you've identified and documented the cause of the variance
DCall ADP support and wait for them to fix it
Chapter SevenExcel Skills for Payroll Professionals

Excel is your secret weapon. The analysts who master these skills work 50% faster, catch errors that others miss, and produce leadership-ready reports in minutes. This chapter covers every formula, pivot table technique, shortcut, and dashboard skill you need.

Chapter SevenExcel Skills for Payroll Professionals
📊
Lesson 7.1
Pivot Tables — Summarize Thousands of Rows in 5 Minutes

A pivot table lets you take a raw payroll register export (potentially thousands of rows) and instantly summarize it by department, employee type, location, or any other field — without writing a single formula.

How to Build Your Payroll Pivot Table

  • Export your Payroll Register from Workday to Excel (.xlsx)
  • Click any cell in your data → Insert → PivotTable → New Sheet
  • Drag "Department" to the Rows area
  • Drag "Gross Pay" to the Values area (set to Sum)
  • Drag "OT Hours" to the Values area (set to Sum)
  • Drag "Pay Period" to the Filters area

What You Can Find Instantly

  • Which department has the highest total payroll this period
  • Which department has the most overtime hours (and thus highest labor cost risk)
  • Compare payroll by location across multi-site companies
  • Filter by W-2 vs 1099 to see classification-based costs
  • Spot any department with zero hours (possible data entry issue)

✅ Add a Slicer (PivotTable Analyze → Insert Slicer → Department) to make your pivot table interactive. Now leadership can filter it themselves without touching the raw data.

Chapter SevenExcel Skills for Payroll Professionals
Lesson 7.2
Must-Know Formulas for Payroll Compliance Work

IF Statement — Automated Error Flagging

Use IF statements to automatically flag issues in your register without manual scanning.

=IF(D2<0,"❌ NEGATIVE NET PAY","OK") =IF(F2=0,"⚠️ NO FED TAX — CHECK W-4","OK") =IF(C2>40,"🔴 OVERTIME — VERIFY RATE","Regular") =IF(G2<>VLOOKUP(A2,HRRates!A:B,2,0),"⚠️ RATE MISMATCH","OK")

XLOOKUP / VLOOKUP — Match Data Across Reports

Use XLOOKUP to pull pay rates, department codes, or classification from your HR master file into your payroll register for comparison.

=XLOOKUP(A2,HRMaster!A:A,HRMaster!C:C,"NOT FOUND") =VLOOKUP(A2,HRMaster!$A:$D,3,FALSE)

SUMIF / SUMIFS — Total by Category

=SUMIF(B:B,"Construction Dept",D:D) =SUMIFS(D:D,B:B,"Houston",C:C,"Hourly",E:E,">40")

Tax Reconciliation Formula

=GrossWages-TaxableWages [Should equal pre-tax deductions only] =SUMIF(H:H,"Federal",I:I)-ADP_FederalLiability [Should = 0]

Variance Analysis

=IF(ABS((D2-E2)/E2)>0.2,"⚠️ VARIANCE >20%","OK") [Compare current gross pay (D2) to prior period (E2)]
Chapter SevenExcel Skills for Payroll Professionals
🎨
Lesson 7.3
Conditional Formatting — See Issues Without Reading

Conditional formatting makes your spreadsheet work for you — errors jump out in color before you even read a single cell value.

Essential Payroll Formatting Rules

What to HighlightRuleColor
Negative net payCell value < 0Red fill, white text
Zero federal taxCell value = 0Yellow fill
OT hours over 40Cell value > 40Orange fill
Pay variance >20%Use formula: ABS((D2-E2)/E2)>0.2Pink fill
Missing dataCell is blankLight red fill

How to Apply

  • Select your column → Home tab → Conditional Formatting → New Rule
  • Choose "Format only cells that contain" or "Use a formula to determine which cells to format"
  • Set your condition and choose a fill color
  • Apply to entire column so new rows are automatically formatted
Chapter SevenExcel Skills for Payroll Professionals
📈
Lesson 7.4
Charts for Leadership Reporting

The 4 Charts Every Payroll Analyst Should Build

  • Line Chart — Payroll Trend Over 12 Months: Shows total payroll cost by period. Leadership immediately spots unusual spikes or the impact of headcount changes.
  • Bar Chart — OT Hours by Department: Shows which departments are consuming the most overtime budget. HR and operations use this to make staffing decisions.
  • Pie Chart — Payroll by Classification: W-2 salary vs W-2 hourly vs 1099 contractor. Shows your labor cost structure at a glance.
  • Column Chart — Tax Liability by Quarter: Quarter-over-quarter comparison of federal, state, and FICA liabilities. Use this for your 941 reconciliation presentations.

Build a 4-Tab Payroll Dashboard

  • Tab 1 — Raw Data: Paste your Workday payroll register export here. Never touch this tab.
  • Tab 2 — Analysis: All your formulas, flags, and VLOOKUP cross-references pull from Tab 1.
  • Tab 3 — Charts: All charts auto-update from Tab 2 data. Share this tab with leadership.
  • Tab 4 — Audit Log: Every correction you made, with date, reason, and action taken.
Chapter SevenExcel Skills for Payroll Professionals
⌨️
Lesson 7.5
Keyboard Shortcuts That Save Hours Every Week
ShortcutWhat It DoesWhen to Use It
Ctrl + TFormat as TableImmediately when you paste any payroll data
Ctrl + Shift + LToggle Filters On/OffFilter by department, error flag, OT status
Alt + =AutoSum selected rangeTotal any column instantly
Ctrl + 1Format Cells dialogFormat as currency, date, or percentage
F5, EnterGo To Special → BlanksSelect all blank cells in a column — find missing data
Ctrl + ;Insert today's dateTimestamp every audit log entry
Ctrl + Shift + EndSelect to last used cellQuickly select entire dataset
Alt + H + O + IAutoFit column widthMake all columns readable instantly
Ctrl + DFill DownCopy a formula down an entire column fast
Ctrl + Shift + $Format as currencyFormat pay columns to show dollar amounts
Chapter SevenExcel Skills for Payroll Professionals
📝
Chapter 7 Quiz
1. You want total OT hours by department from a 2,000-row payroll export. What's the fastest approach?
AUse VLOOKUP
BBuild a PivotTable with Department as Rows and OT Hours as Values (Sum)
CManually add up each department with a calculator
DUse conditional formatting
2. Which formula automatically flags any employee with hours over 40 as "OVERTIME"?
A=SUMIF(C2>40,"OVERTIME","Regular")
B=IF(C2>40,"OVERTIME","Regular")
C=VLOOKUP(C2,40,"OVERTIME")
D=COUNTIF(C2,">40")
3. What Excel shortcut finds all blank (missing) cells in a selected column?
ACtrl + F
BCtrl + Shift + End
CF5, Enter (Go To Special → Blanks)
DAlt + =
Final ExamPayroll Compliance Mastery — Final Exam
Final Exam
📝
Payroll Compliance Mastery — Final Exam
This exam covers all 7 chapters. You need 70% or higher to pass. These questions reflect real on-the-job scenarios — the same situations you'll face as a Payroll Compliance Analyst.
🏆
Final Exam — 14 Questions
1. What is the FIRST report you should run every morning before touching payroll?
AGeneral Ledger Report
BException Report (Time Entry Exceptions in Workday)
CPayroll Register
DTax Liability Report in ADP
2. An employee's Payroll Register shows $0 federal tax withholding. Most likely cause?
AThe employee worked overtime
BThe GL report has an error
CThe W-4 setup is incorrect — possibly marked "Exempt" incorrectly
DThe employee is automatically exempt from all taxes
3. Which federal law governs minimum wage, overtime, and employee classification?
AFLSA — Fair Labor Standards Act
BFMLA — Family and Medical Leave Act
CFICA — Federal Insurance Contributions Act
DERISA — Employee Retirement Income Security Act
4. When should you run the Pre-Payroll Audit?
AAfter payroll is submitted
BOnly during quarterly reviews
CBefore finalizing and submitting payroll — every single pay period
DOnly when employees report errors
5. Where do you navigate in ADP SmartCompliance to validate Form 941?
AADP → Reports → Payroll Summary
BADP → Tax Filing → Quarterly Filings
CWorkday → Payroll → Results
DADP → Compliance Dashboard → Annual Reports
6. What is the combined employee FICA rate (Social Security + Medicare)?
A6.2%
B5.0%
C7.65%
D10.2%
7. A salaried employee earning $600/week is in a generic "office assistant" role with no managerial duties. Are they exempt from overtime?
AYes — all salaried workers are exempt
BNo — they don't meet the $684/week salary threshold AND the duties test is unclear
CYes — office workers are always exempt
DOnly the manager decides
8. Which Excel function totals wages for only one specific department?
AVLOOKUP
BIF
CSUMIF
DCOUNTIF
9. The IRS failure-to-deposit penalty for a deposit more than 15 days late is:
A2%
B5%
C10% (more than 15 days), escalating to 15% if not deposited at all
D1% per day
10. What is the purpose of the General Ledger (GL) Report in payroll?
ATo approve employee timecards
BTo calculate overtime rates
CTo reconcile payroll expenses with Finance and support internal and external audits
DTo submit quarterly taxes to the IRS
11. During payroll simulation, Mike R.'s 68 OT hours were paid at regular rate. What do you do?
ASubmit payroll — fix it next period
BFix the pay code mapping in Workday, recalculate payroll at 1.5x, then finalize
COnly fix it if the employee complains
DReduce his hours to 40 to avoid the issue
12. What Excel feature automatically highlights negative net pay cells in red without you scanning each one?
APivotTable
BVLOOKUP
CConditional Formatting
DData Validation
13. An employee hits the Social Security wage base ($168,600) in October. What happens?
AContinue withholding SS at double rate
BStop withholding Social Security — Medicare (1.45%) continues with no wage base limit
CStop all FICA withholding
DContinue at normal rate — the system handles it automatically every time
14. Which payroll data flow step comes AFTER you finalize payroll in Workday?
AImmediately export to Excel for pivot tables
BPayroll data transmits to ADP SmartCompliance for tax deposits and filings
CContact the IRS to confirm the deposit
DRun the GL report first, then finalize
0 / 14
🏆

Course Complete!

You’ve finished all 7 chapters and the final exam. Outstanding work!

Prep Wealth Academy

Prep Wealth Academy

Track Timekeeping
Mastery Course

A 3-part field guide to mastering Track — from the Activity Screen to allocations, equipment, and daily reporting. Includes authentic screenshots from the Timekeeper's Playbook.

3Parts
12Lessons
20Test Qs
100%Practical

Your Progress

Part 1 — Foundations
Part 2 — Allocation
Part 3 — Equipment & Reports
Final Test
Part OneFoundations & the Activity Screen
🕐
Lesson 1.1
Working One Day Behind — The Golden Rule

Why It Matters

Track always opens to today's date — but you are always entering data for the previous work date. Forgetting to change the date is one of the most common (and costly) mistakes a timekeeper makes.

Track screenshot

Activity Screen — Activity > Labor Hours > Labor Activity. Note the date fields and In/Out column.

⚡ Rule #1: The very first thing you do every morning is change the date to yesterday's work date before touching anything else.

Your Daily Opening Routine

  1. Log in to Track. The system defaults to today.
  2. Change the date in the From/To date fields to the previous work date.
  3. Check the In/Out column for SCHEDULE statuses before reviewing hours.
  4. Use filters to narrow your list to the group or employees you need.

Key In/Out Statuses to Know

  • SCHEDULE — Employee has no gate activity yet. Investigate before processing time.
  • IN — Employee is currently on site (gate scan shows active entry).
  • OUT — Employee has clocked out for the day.
  • OVR / OVR(I) / OVR(O) — An override has been applied to their record.
  • EXCEPTION — Something in their record needs your attention before allocating.
📌 Note on Rehires: Rehires will NOT show a SCHEDULE status but will display their previously assigned skill and schedule. Always contact your hiring center for a schedule or skill change before processing time for rehires.
Part OneFoundations & the Activity Screen
📊
Lesson 1.2
Net Time, Calc Net & Smart Rounding

Important Items on the Activity Page

The toolbar has several key functions you'll use every day.

Track screenshot

Important Items on Activity Page — In/Out, Calc Net, Details, Show/Hide, and Labor Details functions.

What Is Net Time?

Net Time is the billable hours Track calculates for each employee based on three factors working together:

📅 Schedule

The employee's assigned shift pattern (e.g., 07:00–17:30, Mon–Fri).

💲 Pay Formula

The business rules that determine how hours are calculated and which rate applies.

🚪 On-Site Time

Actual gate scan data — the physical clock-in and clock-out captured by Lenel.

🔁 Calc Net

The button that tells Track to re-run all three factors and produce an updated Net Time.

Track screenshot

Show/Hide toggle and Labor Details screen — showing full resource details including gate activity, pay formula, schedule, skill, on-site time, and net time.

How to Run Calc Net

  1. Check the box next to the employee's name on the Labor Activity screen.
  2. Click Calc Net in the toolbar.
  3. Click Proceed. Net Time updates immediately.
  4. To calc multiple employees at once, check multiple boxes before clicking Calc Net.
  5. To calc all resources on screen, use "Calculate for All Resources Listed" — but only when Show/Hide is not active.
⚠️ Never calc net all resources while Show/Hide is open. Inactive resources will appear to have on-site time even though their net time is 0.00, which corrupts your data.

Understanding Smart Rounding

Track screenshot

Smart Rounding Example — Contract Terms & Conditions for Calculating Net Billable Hours. UP, DOWN, and SMARTLY rounding explained with the 07:02 clock-in scenario.

Track can round net billable hours in three ways. Your contract terms determine which method applies.

  • UP: Always rounds in the employee's favor. Example: 9.97 hrs → 10.00 hrs.
  • DOWN: Always rounds against the employee. Example: 9.97 hrs → 9.75 hrs.
  • SMARTLY: Splits the difference at the midpoint. 9.97 rounds UP to 10.00; if it were 9.92 or below, it would round DOWN to 9.75.
💡 Recalculate After Every Change: If you make any edit to pay formula, schedule, skill, contract, or group after hours have already been calculated, you must run Calc Net again to apply those changes to Net Time.

Check Your Understanding

🧠 Quick Check

An employee on a 07:00–17:30 schedule clocks in at 07:02 and out at 17:30. With a 15-minute rounding rule and the client using DOWN rounding, what is their net billable time?
Correct! Time on site = 9.97 hrs (10.5 scheduled − 0.5 lunch − 0.03 late). With DOWN rounding, 9.97 always rounds DOWN to 9.75 net billable hours — the client keeps the difference.
Part OneFoundations & the Activity Screen
👥
Lesson 1.3
Labor Groups & Personnel Identifiers (PID)

Setting Up Labor Groups

Labor Groups let you organize employees into categories that make review, reporting, and allocation easier.

Track screenshot

Setting Up Labor Groups — Resources > Add Resources > Labor Group. Shows the Group Listing with Not In a Group / Group Members panels.

How to Create a Labor Group

Navigate to: Resources → Add Resources → Labor Group

  1. Type a group name in the "Create New Group" field and click Add.
  2. In the left "Not In a Group" list, highlight the employees you want to include.
  3. Click Add >> to move them into the group.
  4. To remove someone, highlight them in the group list and click << Remove.

Adding a Personnel Identifier (PID)

Track screenshot

Adding a Personnel Identifier (PID) — Activity > Labor Hours > Labor Activity. Shows the Labor Information screen with the PID field highlighted.

A PID is your company's unique employee number — it links your internal HR records to Track, and it's required for the Labor Allocation Upload.

Navigate to: Activity → Labor Hours → Labor Activity

  1. Check the box next to the employee's name.
  2. Click Edit Resource in the toolbar.
  3. In the Labor Information screen, enter the number in the PID field.
  4. Click Save.
💡 Pro Tip: Enter PIDs as soon as a new employee is set up — before you need to run your first allocation import.
Part OneFoundations & the Activity Screen
Lesson 1.4
Requesting Overrides to Correct Time

What Is an Override?

An override is a formal request to adjust an employee's hourly calculation when gate scan data alone doesn't reflect actual work — for example, when someone worked a holdover, was offsite for a drug screen, or arrived early with supervisor approval.

Track screenshot

Request Override screen — showing the Override Listing with resource checkboxes, ST/OT/DT hour fields, Override Reason dropdown, and Comments field.

How to Submit an Override

  1. On the Labor Activity screen, check the box(es) next to the resource(s).
  2. Click Request Override in the toolbar.
  3. Select the most appropriate Override Reason (Holdover, Offsite, Drug Screen, Temp Schedule, etc.).
  4. In the Comments field, enter supporting details including the name of the MPC rep who approved the action.
  5. Fill in ST, OT, DT hours as applicable, then click Process Overrides.
Track screenshot

Attaching documents to overrides — shows the Add Attachment workflow for submitting signed OT Request forms with your override submission.

📎 Attach Documents: You can attach signed OT Request forms or other backup directly to an override submission. Check the employee box → click Add Attachment → select your file → click Upload.
⚠️ Never submit a negative allocation to balance hours. Negative corrections must be handled through an override only.
Part TwoLabor Allocation — The Core Skill
💼
Lesson 2.1
Manual Labor Allocation — Step by Step

Navigation Path

Allocations → Allocations → Labor Hours

Track screenshot

Allocating Labor — Allocations > Allocations > Labor Hours. Shows the Allocate Labor screen with Resources list, Available hours, PO#, WO#, and Submit button.

How to Manually Allocate One Resource

  1. Select the correct Organization and Group from the dropdowns.
  2. Set the date to the previous work date.
  3. Click on the employee's name in the Resources list to highlight them.
  4. Enter the Purchase Order (PO#) in the Purchase Order Line Item field.
  5. Enter the Work Order (WO#) in the Work Order field.
  6. Optionally fill in the Extra field (invoice number, payment app reference, etc.).
  7. Review that Area and Agreement are correct — do not change Area.
  8. Click Submit.
Track screenshot

Allocation rules — Never edit the Area field, allocations must always end in 0 or 5, and common causes of negative allocations.

⚠️ Critical Rules:
NEVER edit the Area field. It controls approval routing.
• Allocations must always end in a 0 or 5 (e.g., 9.50, 10.00, not 9.97).
• Most sites expect allocations for the previous day to be complete by 10:00 AM.
💡 Multiple WO#s: You can split one employee's hours across multiple Work Orders. After entering the first WO and hours, the remaining Available Hours reduce automatically.

Quick Check

🧠 Quick Check

An employee has 10.25 available net hours. You need to allocate them. Which amount is NOT acceptable per Track rules?
Correct. 10.13 does not end in 0 or 5. Allocations must always end in .0 or .5.
Part TwoLabor Allocation — The Core Skill
📤
Lesson 2.2
Labor Allocation Upload (Bulk Import)

When to Use the Upload

When you have a large crew, the M-Allocation Import Form (Excel) lets you allocate all employees in one import instead of one by one.

Track screenshot

Using Labor Allocation Upload — 19-step process from running the M-Allocation Import Form through verifying the Not Allocated Report.

Upload Process

  1. Run the M-Allocation Import Form (Excel) report in Track.
  2. Review all columns and fill in PO#, WO#, skill, and hour amounts.
  3. If allocating to multiple WO#s, insert rows and copy/modify data. Remove the total row before importing.
  4. Enter invoice or payment reference numbers in the Extra Field (optional).
  5. Save the file, then open Track → Settings → Utilities → Track Import.
  6. Open the Import Template, paste your data (Row 2 and down, paste special values only), and save.
  7. Set Import Type = Allocation, Delimiters = Excel, click ANALYZE first, then browse to your file and click Import.
  8. Refresh until the import shows as processed and a log file appears.
  9. Run your Not Allocated Report to confirm all hours were captured.
⚠️ If MULTIPLE allocations exist for one person, remove the TOTAL HOURS row before importing. Leaving the total in causes double-allocation errors.
💡 Import errors? Run the "Import Error Log" report using your import ID to see exactly what failed. Fix the issues, re-analyze until it shows success, then import again without checking Analyze.
Part TwoLabor Allocation — The Core Skill
🔄
Lesson 2.3
Auto-Allocations & Accepting Costs

Setting Up Auto-Allocation

For employees who always work the same PO/WO, you can set a standing auto-allocation so Track pre-fills their allocation data daily.

Navigate to: Schedule → View Schedule → Labor Schedule

Track screenshot

Auto Allocation — Schedule > View Schedule > Labor Schedule. Shows the Add Auto-Allocation panel with date range, Order Type, PO#, WO#, and Assign button.

⚡ Important: Auto-allocation only populates when you touch/highlight the resource name on the allocation screen. It won't pre-fill on its own.

Accepting Allocated Costs

Navigate to: Allocations → Acceptance → Labor

Track screenshot

Accepting Allocated Costs — Allocations > Acceptance > Labor. Shows the Accept/Unaccept Items workflow and the green accepted rows.

  1. Enter the date and click Go.
  2. Check boxes next to the employees whose allocations you're accepting (or click Check All).
  3. Click Accept/Unaccept Items. Accepted rows turn green.
  4. To unaccept, uncheck the box and click the same button — rows return to white.
📅 Expectation: GBR expects billing to be balanced and accepted within one week.

Handling Rejected Allocations

Track screenshot

Resolving Rejected Allocations — shows the Rejected Allocations report and the unaccepting workflow. Resources with rejections show an 'R' next to their name.

When an approver rejects an allocation, a message appears on your Track home screen. Run the Rejected Allocations report at least once per day.

⚠️ Rule: Regardless of the reason for rejection, the allocation MUST be unaccepted before any correction can be made.
Part TwoLabor Allocation — The Core Skill
Lesson 2.4
Avoiding & Fixing Negative Allocations

What Causes Negatives?

Negatives appear in your Not Allocated report when allocated hours exceed available net hours. Here are the four most common scenarios:

  • Wrong schedule assigned: You allocate 10 hours but the employee has 0 net time because their schedule was set up incorrectly and no override was submitted.
  • Override deleted in wrong order: Always delete the allocation before deleting the override.
  • Per Diem removed after allocation: Remove from allocation first, then remove per diem.
  • Calc Net run for the whole week at once: Cumulative hours shift and cause negatives.
✅ Best Practice: Run Calc Net daily, in sequence, after every override is finalized — never batch the whole week at once unless absolutely necessary.
Part ThreeEquipment, Material & Reporting
🔧
Lesson 3.1
Rental Equipment Records (RER) & Adding Equipment

What Is an RER?

MPC requires a Rental Equipment Record (RER) for every piece of contractor-owned equipment billed through Track's Equipment Module.

Track screenshot

Sample Rental Equipment Record (RER) — Marathon Petroleum Company LP form showing all required fields including VIN/Equipment ID, dates, rates, and authorization signatures.

Adding Equipment to Track

Navigate to: Resources → Add Resources → Add Equipment

Track screenshot

Adding Equipment into Track — Resources > Add Resources > Add Equipment. Shows the New Equipment form with Group, Type, and VIN/Unique ID fields. Equipment is NOT billable until the Equipment Coordinator turns it on.

  1. Run the Equipment Rates by Contract report first to verify Group and Type.
  2. Select the correct Group and Type.
  3. Enter the VIN / Unique ID — this must match what's on the RER exactly.
  4. Click Add. An error pop-up will appear — ignore it. Confirm the item now shows in the Equipment Listing below.
⚠️ Equipment is not billable until the Equipment Coordinator has reviewed the RER and turned it on in Track. Submit your RER early.
Part ThreeEquipment, Material & Reporting
⏱️
Lesson 3.2
Entering Equipment Hours & Allocating Equipment

Entering Hours

Navigate to: Activity → Equipment Hours

Track screenshot

Entering Equipment Activity Hours — Activity > Equipment Hours. Shows Organization, Agreement, Group, Type, Equipment list, Timesheet Date, IN Time (HHMM), and OUT Time (HHMM) fields.

⚠️ Date Sequence is Critical: Equipment must be entered and allocated in strict date order. Never skip a billable day. If you accidentally enter out of order and allocations haven't been authorized yet, delete the allocations, run Re-Calculate Day and Re-Calculate Week, then re-enter the skipped date.

Setting Up Equipment Operator

Track screenshot

Setting Equipment Up with Operator — Schedule > Assignment > Equipment Operator. Shows how to highlight the equipment ID, choose the operator name, and set a date range.

Setting Equipment to a Schedule

Track screenshot

Setting Equipment to Schedule — Schedule > Assignment > Equipment. Useful for daily-use equipment with consistent hours (8, 10, or 12 hour shifts).

Allocating Equipment Hours

Navigate to: Allocations → Allocations → Equipment Hours/Costs

Track screenshot

Allocating Equipment — Allocations > Allocations > Equipment Hours/Costs. Shows the 15-digit PO# field, 7-digit WO# field, and the required GL Account 5401040.

  • Select Agreement, Allocation Date, Group, Type, and Equipment Item.
  • Enter the 15-digit PO# in the Purchase Order Line Item field.
  • Enter the 7-digit WO# in the Work Order field.
  • Enter GL Account 5401040 — this is REQUIRED for equipment.
  • Optionally use the Extra field for payment reconciliation.
  • Click Allocate.
💡 Batch Tip: You can highlight up to 3 equipment items at once if they share the same PO and WO.

Equipment Auto-Allocation & Details

Track screenshot

Equipment Auto-Allocation — Schedule > View Schedules > Equipment Schedule. Requires GL Account 5401040 and hours (8, 10, or 12).

Track screenshot

Equipment Details — Equipment Hours screen showing Show Details button. Also shows Re-Calculate Hours and Re-Calculate Weekly functions for fixing out-of-order entries.

Part ThreeEquipment, Material & Reporting
📦
Lesson 3.3
Entering & Allocating Material

Entering Material Used

Navigate to: Activity → Material Used

Track screenshot

Entering Material — Activity > Material Used. Shows the Material Used screen with Item, Charges Description, Item Rate, Unit Price, Unit, Quantity, Tax, and Receipt Reference # fields. Wait for green dot/circle before clicking Add.

  1. Run the Material Rates by Contract report first to identify your Group and Item.
  2. Select Organization, Agreement, and Group (click to highlight).
  3. Select the Item.
  4. Enter a Charges Description.
  5. Set the Item Rate (Receipt - Purchase for Job or similar).
  6. Enter Unit Price, Unit (Each, LF, etc.), and Quantity. If the unit price is already a total cost, set Quantity to 1.
  7. Enter Tax (enter 0 if no tax applies).
  8. Enter the Receipt Reference # — must match the uploaded invoice name exactly.
  9. Wait for the green dot/circle to confirm upload before clicking Add.

Allocating Material Charges

Navigate to: Allocations → Allocations → Material Charges

Track screenshot

Allocating Material — Allocations > Allocations > Material Charges. Shows the Allocate Material Charges screen with Agreement, Group, Material Item, PO#, WO#, and Allocate button.

  • Select Agreement, Allocation Date, Group, and Material Item.
  • Enter the 15-digit PO# and 7-digit WO#.
  • Use the Extra field for payment tracking (optional).
  • Click Allocate.
Part ThreeEquipment, Material & Reporting
📋
Lesson 3.4
Key Reports & Your Daily Workflow Checklist

Not Allocated / Not Accepted Reports

Track screenshot

Not Allocated/Not Accepted Reports — Allocations > Not Allocated Reports > Labor, Equipment, or Material. Select org, group, date range, and click View.

Frequently Used Reports

Track screenshot

Frequently Used Reports — complete reference table showing all Track reports including Daily Activity, Equipment Daily Activity & Costs, M-Allocation Import Form, M-Track Reconciliation Report, Total Hours Detail Per Person, and more.

Must-Know Reports

  • Daily Activity — Personnel clock-in/out times, schedule, on-site time. Run to spot Early/Late flags.
  • Not Allocated / Not Accepted Reports — Your safety net. Run every day.
  • Rejected Allocations — Run at least once daily.
  • M-Allocation Import Form (Excel) — Pre-populated crew list for bulk allocation imports.
  • Equipment Daily Activity & Costs — Verify equipment billing and correct monthly rates.
  • Total Hours Detail Per Person — ST/OT/DT per person per day. Pull weekly to monitor 40+ hours.
  • M-Track Reconciliation Report — Vendor-facing report for reconciling payments against authorized billing.
  • Allocated and Not Authorized — Shows pending allocations awaiting approver sign-off.

Daily Workflow Checklist

Track screenshot

Contractor Timekeeper Checklist — complete daily checklist for Labor, Material, and Equipment tasks.

⚙️ Labor

✓ Check rejected allocations & overrides
✓ Identify new resources / submit PRF
✓ Review prior day labor hours
✓ Submit overrides if needed
✓ Allocate labor by 10 AM
✓ Run Not Allocated report
✓ Accept hours weekly
✓ Run daily reports

🔧 Equipment

✓ Check rejected allocations
✓ Enter new equipment VIN
✓ Submit RERs to coordinator
✓ Enter equipment hours
✓ Allocate equipment hours & costs
✓ Run Not Allocated report
✓ Accept equipment costs
✓ Run Not Accepted & daily reports

📦 Material

✓ Check rejected allocations  |  ✓ Add material for timesheet date  |  ✓ Attach receipt backup  |  ✓ Allocate material costs  |  ✓ Run Not Allocated → Accept → Not Accepted → Daily reports

Final Check

🧠 Final Quick Check

When allocating equipment in Track, what GL Account number is REQUIRED for equipment hours/costs?
Correct! GL Account 5401040 is required for all equipment hour and cost allocations.
Final AssessmentTrack Timekeeping Mastery Test

🎓 Final Test

Select the best answer for each question. Review your results when complete.

Question 1 of 20 — Part 1: Foundations
Track always defaults to today's date when you log in. What is the FIRST thing you must do every morning before entering any data?
Correct: C. Track always opens to today, but you are always working one day behind. Changing the date to the previous work date is Rule #1 — before touching anything else.
Question 2 of 20 — Part 1: Foundations
An employee shows a status of SCHEDULE in the In/Out column. What does this mean?
Correct: B. SCHEDULE means the employee has no gate scan activity for that day. You must investigate the reason before processing or allocating their time.
Question 3 of 20 — Part 1: Foundations
What three factors does Track use to calculate an employee's Net Time?
Correct: B. Net Time is the result of running the employee's Schedule, Pay Formula, and actual On-Site Time (gate scan data) through Calc Net.
Question 4 of 20 — Part 1: Foundations
Why should you NEVER click "Calculate for All Resources Listed" while the Show/Hide function is active?
Correct: B. Show/Hide displays inactive resources on the screen. Calc All while Show/Hide is open will make those inactive resources appear to have on-site time, which corrupts your net time data.
Question 5 of 20 — Part 1: Foundations
An employee clocks in at 07:02 on a 07:00–17:30 schedule with a 15-minute rounding rule. Using DOWN rounding, what is their net billable time?
Correct: A. Time on site = 9.97 hrs (10.5 scheduled − 0.5 lunch − 0.03 late). With DOWN rounding, 9.97 always rounds DOWN to 9.75 net billable hours.
Question 6 of 20 — Part 1: Foundations
What is a Personnel Identifier (PID) and why is it important?
Correct: C. A PID is your company's unique employee number. It links your internal HR records to Track and is a required field for the Labor Allocation Upload (bulk import).
Question 7 of 20 — Part 1: Foundations
When submitting an Override, what information MUST you include in the Comments field?
Correct: B. The Comments field must include supporting details substantiating the Override reason AND the name of the MPC rep who requested or approved the holdover, early in, etc.
Question 8 of 20 — Part 2: Allocation
Allocations in Track must always end in which digits?
Correct: B. Track requires all allocations to end in a 0 or 5 — for example 9.50, 10.00, 10.50. An amount like 9.97 or 10.13 is not acceptable.
Question 9 of 20 — Part 2: Allocation
You need to correct an over-allocated employee. How should you handle this correction in Track?
Correct: C. You must NEVER submit a negative allocation to correct hours. This will break your Not Allocated report. Negative corrections must always be handled through an Override.
Question 10 of 20 — Part 2: Allocation
By what time should most allocations for the previous work day be completed?
Correct: B. Most site expectations are that allocations for the previous day need to be completed by 10:00 AM.
Question 11 of 20 — Part 2: Allocation
When using the Labor Allocation Upload (bulk import) and an employee has MULTIPLE WO# allocations, what must you do before importing?
Correct: B. When multiple allocations exist for one person, you MUST remove the total hours row before importing. Leaving the total row in causes double-allocation errors.
Question 12 of 20 — Part 2: Allocation
You set up an auto-allocation for an employee. You navigate to the Allocations screen but the PO/WO fields are blank. What is the most likely cause?
Correct: C. Auto-allocation does NOT pre-fill automatically. You must click/touch/highlight the employee's name on the allocation screen for the auto-allocation to populate.
Question 13 of 20 — Part 2: Allocation
An allocation shows up as rejected. What is the FIRST step you must take before making any correction?
Correct: C. Regardless of the reason for rejection, the allocation MUST be unaccepted first. You cannot make any correction to a rejected allocation until it is unaccepted.
Question 14 of 20 — Part 2: Allocation
Which of the following is a common cause of NEGATIVE allocations in Track?
Correct: B. If you ask for an override to be deleted before removing the allocation, you can no longer access the allocation to edit or delete it, and the Not Allocated report will show a negative. Always delete the allocation first, then the override.
Question 15 of 20 — Part 3: Equipment & Reports
What is a Rental Equipment Record (RER) and when is it required?
Correct: B. MPC requires a Rental Equipment Record (RER) for all contractor-owned equipment billed through Track's Equipment Module. It must be reviewed and approved by the Equipment Coordinator before the equipment can be turned on for billing.
Question 16 of 20 — Part 3: Equipment & Reports
What GL Account number is REQUIRED when allocating equipment hours and costs in Track?
Correct: C. GL Account 5401040 is required for all equipment hour and cost allocations and equipment auto-allocations. Leaving it blank will cause allocation errors.
Question 17 of 20 — Part 3: Equipment & Reports
You accidentally skipped entering equipment hours for Tuesday and have already entered Wednesday. The Wednesday allocation has NOT yet been authorized. What is the correct fix?
Correct: B. Equipment must be entered and allocated in strict date sequence. If the out-of-order allocations haven't been authorized yet, delete them, run Re-Calculate Day and Re-Calculate Week, then go back and enter the skipped date correctly.
Question 18 of 20 — Part 3: Equipment & Reports
When entering material in Track, the Receipt Reference # must match what exactly?
Correct: C. The Receipt Reference # must match the uploaded invoice name exactly. This ensures the backup documentation links correctly to the material charge in Track.
Question 19 of 20 — Part 3: Equipment & Reports
Which report should you run daily to find allocations that are still awaiting approver sign-off, sorted with Area IDs?
Correct: D. The "Allocated and Not Authorized — with Area IDs" report shows all pending allocations awaiting approver sign-off, organized with Area IDs so you can track who needs to approve what.
Question 20 of 20 — Part 3: Equipment & Reports
GBR expects billing to be balanced and accepted within what timeframe?
Correct: C. GBR expects billing to be balanced and accepted within one week. Accept allocated hours weekly after you have balanced payroll.
🏆

Course Complete!

You’ve finished all 3 parts and the final test. Great work!

Trained by Prep Wealth Academy

Manage Subscriptions

Unsubscribe from a Community

Sorry to see you go. Your enrolled courses and account access will not be affected.

Cancel

You've been unsubscribed

You will no longer receive emails from this community. Your course access remains active.