Prepare contract labor and staffing data for audit

Executive Summary

Contract labor spend is hard to audit because the source data sits in three disconnected systems: the staffing agency's invoice, the timesheet or VMS approval, and the master service agreement's rate card. None of the three is built to reconcile against the others automatically, so drift accumulates quietly between rate updates, role reclassifications and off-contract placements.

Preparing for an audit means assembling those three sources into one file per vendor per period, before anyone starts testing exceptions. That means pulling every active MSA and its rate exhibits, exporting timesheet or VMS data at the individual and role level, and normalizing vendor invoice line items into the same job title and rate fields the contract uses.

What changes the outcome is sequencing: build the rate card reference first, then bring in timesheets, then bring in invoices last. Reviewers who load invoices first end up auditing against the invoice's own labels instead of the contract's, which finds nothing because it never leaves the invoice's frame of reference.

1. What documents do you need before you start?

You need four things for every vendor in scope: the current master service agreement and any amendments, the rate card exhibit showing bill rates by role and location, a full export of approved timesheets or VMS records for the audit period, and every vendor invoice for that period with line-item detail rather than summary totals.

Start with the contract file. Pull the base MSA, every amendment, and the current rate exhibit for each vendor. If the rate card has been updated more than once, keep each version and its effective date, not just the latest one.

Next, pull timesheet or VMS data at the individual level: worker name or ID, role, location, hours by week, and the approving manager. Summary reports that only show total hours by vendor are not enough; you need the detail to match against invoice lines.

Finally, pull invoices in line-item form. A PDF invoice with one total per week is far harder to test than a CSV export with a row per worker per week. If your vendor only sends PDFs, request a data export before the audit starts. Vendors that bill through a VMS can produce this without difficulty.

2. How do you organize rate cards across multiple vendors?

Build one master rate reference with a row per role, location and vendor, showing the contracted bill rate, its effective date and its expiration or renewal date. Keep superseded rates in the same file rather than deleting them, because invoices from before a rate change still need to test against the old rate.

A single spreadsheet tab per vendor is the simplest working structure. Columns should include role title as named in the contract, location or site, bill rate, overtime multiplier if one applies, effective date, and end date.

Role titles are where this breaks down. A contract may say "CNC Machinist II" while the vendor's invoice says "Machinist - Skilled." Build a mapping column that links each invoice title variant to its contract role, so the reconciliation does not silently skip lines it cannot match by name.

This reference is also the foundation for the checks that follow.

• Rate accuracy testing: Comparing every invoiced rate against the version of the rate card that was in effect on the date worked, not the date invoiced.
• Role reclassification checks: Flagging workers billed under a higher-rate title than their approved role.
• Location premium checks: Confirming a site premium was contracted before it appears on an invoice.

3. Which fields matter most when exporting timesheet data?

Export worker name or ID, role, location, week ending date, regular hours, overtime hours, and the approving manager for every timesheet in the audit period. Without the approver field you cannot confirm the hours were authorized by someone with signing authority, which is the check that catches phantom or inflated hours.

Hours alone tell you what was billed, not what was worked and approved. The approver field lets you test whether the person who signed off had authority for that cost center, and whether the same manager is approving hours for workers outside their own team, which is one way an off-contract placement gets billed without a fresh approval.

Keep the week-ending date in a consistent format across vendors. Staffing agencies use different week-start conventions, and reconciling a Sunday-start week against a Monday-start invoice period produces false variances that have nothing to do with actual drift.

If your VMS captures a requisition or job order number, include it. That field ties a worker back to the specific role, rate and end date that were approved when the placement was opened, which helps catch a worker still being billed after their assignment should have ended.

4. How do you match invoice lines to timesheets and contract rates?

Match on worker ID and week-ending date first, since names vary in formatting across staffing systems and a name-only match drops legitimate rows. Once invoice, timesheet and contract rate are joined on those two fields, three checks fall out immediately: hours invoiced against hours approved, rate invoiced against the contracted rate for that date, and role invoiced against the role that was approved for that worker.

Worker ID is more reliable than name for this join. Staffing agencies frequently invoice under a legal name while the VMS timesheet uses a preferred name, and a name-based match will silently drop legitimate rows.

Once the three-way join is built, sort by variance rather than by vendor or worker. A variance sort surfaces the handful of lines that actually need review instead of forcing a line-by-line read of every invoice.

This manual, three-source join is what a full audit engagement automates and extends, matching every line across the full contract term rather than a sample period.

5. How do you handle workers who fall outside the standard rate card?

Flag them separately rather than forcing them into the standard reconciliation. Specialized roles, one-off project placements and emergency coverage often carry a negotiated rate that never made it into the master rate exhibit, and treating that gap as an error rather than as missing documentation wastes review time on a false positive.

Build a short exception list during data preparation: every worker whose invoiced role or rate does not appear anywhere in the rate card reference. Before the audit proper begins, this list should go back to the AP or procurement contact who manages the vendor relationship, with a simple question: is there a rate approval for this worker that has not been filed?

Some of these will turn out to be legitimate, documented exceptions with an email approval or a statement of work addendum that was never added to the formal rate exhibit. Others will turn out to be exactly the kind of undocumented rate that a rate card control is meant to prevent going forward.

Either way, resolving the exception list before testing begins keeps the main reconciliation clean, so the variances that remain in it are the ones worth investigating.

6. What should you do once the data is assembled?

Run the three core checks before anything else: rate accuracy against the dated rate card, hours invoiced against hours approved, and role billed against role approved. Only after those three pass should you move to secondary checks like volume rebate triggers or markup percentage validation, because those depend on the base data already being clean.

Sequencing matters here for the same reason it mattered in data collection. A markup percentage check run against unreconciled hours will produce a wrong markup on top of a wrong hours figure, compounding two errors into one number that looks like one.

Document every finding with its source: which invoice line, which timesheet record, which rate card version. An unsupported finding does not survive a vendor conversation, and the point of this preparation work is to make every finding defensible on the first challenge.

According to the US Bureau of Labor Statistics Producer Price Index for employment services (not seasonally adjusted, series PCU5613--5613--, read September 5, 2026), the July 2026 index value stood at 175.559, up 5.3% year over year. A rate increase that tracks that industry movement is a legitimate cost pass-through worth distinguishing from one that does not.

For the wider pattern this sits inside, start with the margin drift guide, and check exception handling against your volume rebate triggers before closing the file.

For the wider pattern this sits inside, start with the margin drift guide.

7. Frequently Asked Questions (People Also Ask)

How far back should the timesheet and invoice data go?

Pull data for the full period you intend to test, matching your contract's active term where records are still available. Consistency matters more than length: partial-period data on one side of the reconciliation and full-period data on the other produces variances that reflect the gap in records, not actual drift.

What if the staffing vendor won't provide a line-item export?

Ask for it in writing before the audit period starts, citing the invoice detail clause in the MSA if one exists. If the vendor still only sends summary PDFs, you can rebuild line-item detail from the VMS timesheet export alone, since it carries worker, role, hours and dates independently of how the vendor formats its invoice.

Do overtime rules need their own reconciliation step?

Yes. Overtime multipliers are set in the contract, not the timesheet, so a timesheet showing overtime hours tells you nothing about whether the correct multiplier was applied. Add a separate check that multiplies approved overtime hours by the contracted multiplier and compares that figure to what the invoice actually billed.

Should temp-to-hire conversions be treated differently in the data?

Yes. Once a worker converts to direct employment, their hours should stop appearing on the staffing invoice entirely. Flag conversion dates during data preparation so you can confirm billing actually stopped on that date rather than continuing under the old placement.

What's the fastest way to spot a stale rate card?

Compare the effective date on your rate card reference against the MSA's renewal or escalation clause date. If an invoice date falls after a scheduled rate change but still bills the old rate, or vice versa, that is a stale reference worth resolving before testing begins.

Can this preparation work be done in Excel, or do you need a database?

Excel works for a handful of vendors with a few hundred rows per period. Once you are joining multiple vendors across multiple periods, a spreadsheet's manual VLOOKUP joins get slow and error-prone, and a simple database or query tool becomes worth the setup time.

How do you handle a vendor that changed its invoice format mid-period?

Normalize both formats into the same column structure before joining anything, and keep a note of which invoices used which format. Skipping this step means the reconciliation silently fails on half the invoices instead of flagging them as a formatting issue.

What counts as a red flag serious enough to raise before the full audit finishes?

A worker billed with no matching timesheet approval at all, or a rate that exceeds the contracted maximum for that role by a wide margin, are worth raising immediately rather than waiting for the full reconciliation to close, since they may indicate a control failure still in progress.