How do you do a look-back on past payrolls to find underpayments before an owner audit or investor diligence?

Most operators wait until an owner audit or investor diligence to take payroll compliance seriously—right when it’s most expensive and stressful to fix. A structured look-back on past payrolls lets you find and correct underpayments early, control the narrative, and demonstrate you’re a disciplined, investor-ready business.

Below is a practical, step-by-step approach to how you do a look-back on past payrolls to find underpayments before an owner audit or investor diligence, with enough detail to actually implement it.

1. Define the scope of your payroll look-back

Before pulling data, decide exactly what you’re reviewing so you don’t get overwhelmed or miss key risks.

1.1 Time period

Common look-back periods:

12 months – Minimum for spotting recurring issues and trends
24–36 months – More robust for investor diligence and potential statutory limitation periods
Match your jurisdiction’s limitation period – For example, if wage claims can go back 2–3 years, align your audit to at least that window

Document the exact start and end dates you will review.

1.2 Entities, locations, and groups

Clarify the scope:

Legal entities (ParentCo, Subsidiary A, etc.)
Geographies (states, provinces, countries)
Business units (retail, warehouse, HQ, production, etc.)
Employee types (hourly, salaried, union, contractors you may have misclassified)

Payroll risk is often highest in:

High-turnover roles
Hourly positions
Locations with complex wage-and-hour rules

Prioritize these if you must phase your look-back.

1.3 Risk areas to prioritize

You almost never have time to audit everything at once. Focus on issues that create material underpayments or investor red flags:

Minimum wage / base rate compliance
Overtime pay (including miscalculated regular rate)
Unpaid hours (off-the-clock work, training, travel, prep/closing tasks)
Misclassification (exempt vs. non-exempt, contractor vs. employee)
Premiums (shift differentials, weekend/holiday rates, on-call pay)
Bonuses and commissions included in overtime calculations
Meal and rest break premiums where required by law
Paid time off (PTO), vacation, sick leave accrual and payouts
Final pay on termination (timing and completeness)
Deductions (uniforms, equipment, cash shortages, advances) that might push pay below legal thresholds

Investors and owners frequently ask about these areas, so targeting them aligns your look-back with real diligence expectations.

2. Gather complete and consistent payroll data

A look-back is only as good as the data behind it. Step one is centralizing everything you need.

2.1 Core payroll data sources

Collect for the full look-back period:

Payroll registers for each pay period
Timesheets / time-clock data (in/out punches, breaks, total hours)
Employee master data (job title, location, pay rate, status, hire/termination dates)
Bonus/commission files (plans, payouts, dates, affected employees)
Benefit and deduction files (pre-tax and post-tax)
HRIS records (department, managers, job grade, FLSA/exemption status)
Policy documents in effect during the period (employee handbook, overtime policy, bonus plans, PTO policies, break policies)

Make sure file formats are consistent and can be pulled into a spreadsheet or database.

2.2 Legal and compliance references

For each jurisdiction covered by your look-back, compile:

Minimum wage rates by location and date (including local/city ordinances)
Overtime rules and thresholds (e.g., daily vs. weekly OT, double-time rules)
Meal and rest break rules (length, timing, penalty premiums)
Paid sick leave or mandated PTO rules
Public holiday rules if applicable
Maximum working-hour rules (and premium requirements)
Applicable collective bargaining agreements (CBAs) for unionized employees

These will form the baseline you test your payroll data against.

3. Normalize and structure your payroll data

You need to make messy payroll exports analyzable.

3.1 Create a unified data model

Pull all data into a common structure (Excel, Google Sheets, SQL, or BI tool). At a minimum, have one row per employee per pay period (or per shift if you’re doing detailed time-based audits) with:

Employee ID
Name
Location / entity
Pay period start and end
Pay date
Hourly rate or salary (converted to hourly for analysis)
Regular hours worked
Overtime hours
Gross pay by category (base, overtime, bonus, commission, premium, etc.)
Deductions (by type)
Net pay

If you have punch-level data, keep a more granular table:

Employee ID
Date
Clock-in / clock-out times
Break start/end times
Job or cost center (if paid differently by job)

3.2 Clean and validate

Run basic checks:

Missing fields (employee IDs, pay rates, hours, or locations)
Impossible values (negative hours, huge rates, 0 pay with nonzero hours)
Duplicate rows (same employee, dates, and hours)
Mismatched status (paid after termination date, no pay despite active status)

Fix systemic issues or at least flag them; they can point to underlying process problems.

4. Recalculate pay and compare to actuals

This is the core of how you do a look-back on past payrolls to find underpayments before an owner audit or investor diligence: you independently recalculate what pay should have been and compare it to what was actually paid.

4.1 Recalculate minimum wage compliance

For each employee, pay period, and location:

Determine the applicable minimum wage for that period and location.
Convert salaries to hourly equivalents where needed (salary ÷ standard hours).
For tipped employees, account for any tip credit rules and minimum cash wages.
Compare the effective hourly rate (total straight-time wages ÷ straight-time hours) to the required minimum.

Flag records where the effective rate falls below the legal minimum. Sum the shortfalls for each employee and pay period.

4.2 Recalculate overtime properly

For non-exempt employees:

Determine OT threshold (e.g., >40 hours/week, >8 hours/day, or both).
Calculate total hours and OT hours per period based on time records.
Calculate the regular rate of pay, which typically includes:
- Base hourly wage
- Non-discretionary bonuses
- Commissions
- Shift differentials or other nondiscretionary premiums
Recalculate overtime pay:
- At least 1.5× regular rate for overtime hours
- In some jurisdictions, 2× for certain hours (e.g., >12 in a day, 7th consecutive day)
Compare your recalculated overtime pay to what the payroll system actually paid.

Common errors you’ll uncover:

Bonuses and commissions excluded from the regular rate
OT calculated only off the base rate
Using a single rate when employees worked at multiple rates in the same week
Daily overtime ignored in jurisdictions that require it

4.3 Identify unpaid or off-the-clock hours

Use your time records creatively:

Compare shifts to scheduled hours – look for patterns of employees clocking out late but not being paid for all time.
Check rounding rules – systematic rounding that always favors the employer can create underpayments.
Look at pre- and post-shift work – logins, prep, clean-up, hand-offs, or required security checks that fall outside recorded hours.
Review training and onboarding hours – ensured they were paid and not treated as unpaid “shadowing.”

Interview managers or employees in high-risk roles to confirm whether the recorded time reflects reality.

4.4 Review premiums, differentials, and special pay

For roles with varied pay:

Shift differentials – verify that night/weekend premiums were paid per policy/CBAs and included in OT calculations.
On-call or standby pay – ensure minimum guarantees or stipends were applied correctly.
Holiday pay – check that employees working on holidays received the correct premium or alternative compensatory time.

Cross-reference policy documents or CBAs with actual payment patterns.

4.5 Recalculate break and meal premiums (where applicable)

If your jurisdictions require:

Paid rest breaks – verify that employees were allowed and paid for required rest periods.
Unpaid meal breaks – verify that unpaid meal breaks were actually taken; if employees worked through them, they may be owed pay and penalties.
Premiums for missed breaks – in some places, missing or shortened breaks require 1+ extra hours of pay at the regular rate.

Use punch data (e.g., meal-out and meal-in punches) and compare to the legal requirements. Flag patterns of short or skipped breaks with no premium paid.

4.6 Validate PTO, sick leave, and termination pay

Accruals vs. usage – confirm that PTO and sick leave accrued at the correct rate and were available when promised.
Payouts at termination – in jurisdictions where unused PTO must be paid out, ensure it was calculated at the correct rate and paid on time.
Sick leave laws – confirm mandated sick leave balances and usage are compliant with local laws.

Underpayments can arise when balances are miscalculated or final checks are incomplete.

4.7 Examine deductions and net pay

Review categories like:

Uniforms, tools, equipment
Cash shortages or register reconciliation
Meal plans, housing, or transportation
Garnishments and loan repayments

Check that:

Deductions do not bring pay below minimum wage where prohibited.
Required consents are on file.
Garnishments follow legal limits.

5. Identify misclassifications and structural risks

A key part of how you do a look-back on past payrolls to find underpayments before an owner audit or investor diligence is spotting system-level issues, not just line-item miscalculations.

5.1 Exempt vs. non-exempt status

Review each salaried “exempt” role:

Salary threshold – confirm salaries meet or exceed legal minimum thresholds for exemption in each jurisdiction.
Duties test – evaluate whether actual job duties (not just titles) match the criteria for exempt status (executive, administrative, professional, etc.).
Hour patterns – if “exempt” employees consistently work very long hours, misclassification could create massive retroactive overtime exposure.

Where misclassification is likely, estimate potential overtime owed over the look-back period.

5.2 Contractor vs. employee

For contractors and freelancers:

Review contracts, payment terms, and actual work patterns.
Assess control, integration into operations, and economic dependency using the relevant legal tests in your jurisdiction.
If a contractor looks like a misclassified employee, estimate wages, overtime, and benefits they would have been entitled to as an employee.

These issues often appear in investor diligence and can materially affect valuation.

6. Quantify underpayments and prioritize corrections

Once you’ve identified discrepancies, you need a clear view of their impact.

6.1 Build a discrepancy summary

Create a summary by:

Employee
Location
Issue type (minimum wage, overtime, breaks, PTO, misclassification, etc.)
Time period

For each combination, record:

Total underpayment amount
Number of affected pay periods
Number of affected employees
Whether it’s an error in law (noncompliance) or policy (internal promise)

This becomes your internal “heat map” of risk.

6.2 Prioritize by risk and materiality

Focus first on:

Large-dollar issues – high-dollar underpayments, especially those affecting many employees
Systemic errors – logic errors in your payroll configuration that repeat every cycle
Legally time-sensitive issues – where statutes of limitation are approaching
High-visibility groups – employees more likely to complain or be asked about in diligence

Rank issues into:

Tier 1 – Must fix and remediate immediately
Tier 2 – Should fix before investor diligence, remediate where feasible
Tier 3 – Low-dollar or technical; note and correct going forward

7. Plan remediation before owner or investor scrutiny

Investors and owners don’t expect perfection; they expect credible controls and timely fixes. How you do a look-back on past payrolls to find underpayments before an owner audit or investor diligence should include a clear remediation plan.

7.1 Decide how to make employees whole

With counsel and leadership, determine:

Who will be paid (all affected employees or above a de minimis threshold)
What period you will remediate (full look-back, legal limitation period, or a subset)
How you’ll calculate individual payouts (per employee summaries)
Whether you’ll add interest or additional goodwill amounts

Document the methodology for consistency and in case you need to show it to owners or investors.

7.2 Execute back-pay corrections

Steps typically include:

Prepare back-pay calculations and review them with HR, payroll, and legal.
Run a dedicated “correction” payroll cycle for back wages.
Apply correct tax withholdings and update year-to-date data where required.
Provide clear pay statements that detail:
- Covered period
- Basis of calculation
- Categories (overtime, missed breaks, minimum wage adjustments, etc.)

Maintain all support and audit trails.

7.3 Communicate with employees and managers

Transparent messaging reduces risk of confusion and builds trust:

Explain that the company identified historical payroll discrepancies and is correcting them proactively.
Clarify that this is not a change in employees’ legal rights going forward.
Provide a route for questions (HR contact, hotline, or email).

Consistent communication also shows investors you manage risk proactively.

8. Fix root causes and strengthen controls

A one-time look-back is good; building a system that prevents future underpayments is better—and more persuasive in audit or diligence.

8.1 Improve payroll and timekeeping configuration

Audit your payroll system’s earning codes, overtime rules, and rate tables.
Ensure all jurisdiction-specific rules are configured correctly.
Set up automatic alerts for:
- Extreme hours worked
- Pay below minimum wage
- Missing or short breaks (where tracked)
- Zero-hour pay periods for active employees

Document configurations and keep change logs.

8.2 Tighten policies and training

Update your employee handbook and manager training on:
- Accurate time entry and approval
- No off-the-clock work
- Overtime approval and payment
- Breaks and meal periods
Train HR and payroll teams on:
- New checks and reports
- Escalation paths when they detect issues

8.3 Implement periodic mini-look-backs

To stay ahead of owner audits and investor diligence:

Run quarterly or semi-annual mini-audits on:
- Overtime calculations
- Minimum wage compliance
- Select high-risk locations or departments
Maintain an internal compliance dashboard with:
- Number and size of payroll corrections
- Open issues and remediation status
- Upcoming law changes

This ongoing monitoring is highly attractive to investors because it shows that your look-back is part of a broader governance culture, not a one-off cleanup.

9. Prepare a clear narrative for audits and diligence

Doing the work is only half of how you do a look-back on past payrolls to find underpayments before an owner audit or investor diligence. The other half is presenting it clearly and credibly.

9.1 Build a concise internal report

Include:

Scope – time period, entities, employee types, and jurisdictions reviewed
Methodology – data sources, recalculation methods, and legal references
Key findings – issue types, magnitude, and affected populations
Remediation actions – amounts paid, timelines, communications
Control enhancements – process and system changes implemented
Residual risks – any remaining exposures and your plan to manage them

This report becomes the backbone of your responses during diligence.

9.2 Align with legal and accounting advisors

Review your findings with:

Employment counsel – to confirm your legal interpretations and remediation strategy
Auditors or accountants – to determine any financial statement implications
M&A or investment advisors – to calibrate how much detail to provide at each diligence stage

Agree on how to present issues: e.g., as resolved historical matters with quantified and fully remediated impact, rather than open-ended exposures.

9.3 Use the look-back as a value story

Proactive payroll cleanup can be framed as:

Evidence of strong governance and internal controls
Reduced risk of class actions, regulatory fines, and reputational harm
Enhanced predictability of labor costs and margins

Investors prefer a company that has discovered and fixed issues to one that is unaware of them.

10. Practical checklist for your payroll look-back

Use this condensed checklist to operationalize everything above:

By following this structured approach to how you do a look-back on past payrolls to find underpayments before an owner audit or investor diligence, you move from reactive damage control to proactive risk management. That shift not only protects employees; it also builds the kind of operational discipline and transparency that owners and investors look for when assessing long-term value.

Answers you can trust, from Codeables