Paper Timesheets and Excel Spreadsheets: Why They Fail in a DOL Audit

Paper timesheets and Excel spreadsheets are not illegal. The FLSA does not require a specific timekeeping method, and any method is acceptable if it is complete and accurate. The problem is that paper and spreadsheets make accuracy hard to prove, and in a Department of Labor audit, being unable to prove accuracy is what costs employers money.

Below, we cover how investigators look at these records, the failures that show up most often, a dollar example of how a small spreadsheet error becomes a back wage claim, and what to put in place if you are still on paper or Excel today. For state-specific details, check with counsel or your state labor department.

What the DOL actually looks for in your records

Under 29 CFR Part 516, employers must keep for each nonexempt employee the hours worked each workday and each workweek, the regular hourly rate, straight-time earnings, overtime premium, total wages, and the pay date and period. Payroll records must be kept for 3 years and time cards and supplementary records for 2 years. Many states require more.

An investigator from the Wage and Hour Division usually starts with a sample of employees and compares time records, payroll registers and what employees say in interviews. They are looking for consistency: do punch times look real, do hours match pay, and can you explain every adjustment? For a fuller walkthrough, read our guide to a DOL wage and hour audit.

Why paper timesheets fail

Paper has real strengths: it is cheap and everyone understands it. Its weaknesses show up under audit.

- Rounded entries. Timesheets where every employee writes 8:00 to 4:30 every day look filled in from memory or by a supervisor, not recorded as the time happened.

- Missing signatures and edits. Without a trail, you cannot show who changed a number or why.

- Lost or damaged sheets. A sheet that cannot be found is a gap in a required record.

- Storage. A team of 20 produces 20 x 52 = 1,040 weekly timesheets per year, or 2,080 over the 2-year retention period for time cards.

When a court sees a record that looks reconstructed, it often gives more weight to the employee's testimony about hours, which brings us to the burden-of-proof problem.

Why Excel is not much safer

A spreadsheet looks more modern, but it carries its own risks. Anyone with access can change a cell, formulas break when someone inserts a row, and files get copied into versions like "timesheet-final-v3". Nothing proves when an entry was made, so a spreadsheet is a calculation tool, not a time clock.

The usual Excel failures are formula ranges that miss a row, hours typed as decimals incorrectly (7.30 instead of 7.50 for 7 hours and 30 minutes), workweeks that do not match the payroll week, and overtime computed on the pay period instead of the workweek. Overtime applies to hours over 40 in a fixed, recurring 168-hour workweek, so a spreadsheet that totals a two-week period without splitting it can underpay.

A dollar example: one missed row

Say an employee earns $18.00 per hour and works 42 hours in a week. A formula that skips a row shows 40 hours. The employer pays 40 x $18.00 = $720.00, but the employee should receive 40 x $18.00 = $720.00 plus 2 overtime hours at $27.00 (1.5 x $18.00), which is $54.00, for $774.00 total. The shortfall is $54.00 for the week.

Under the FLSA, the remedy is back wages plus an equal amount as liquidated damages, so that week alone becomes $54.00 + $54.00 = $108.00, plus the employee's attorney fees if there is a lawsuit. If the same formula error repeats for 52 weeks, the exposure is $108.00 x 52 = $5,616.00 for one employee. Multiply by a team and the cost of an error becomes serious. The lookback is 2 years, or 3 for willful violations. See wage and hour lawsuits and back pay for details.

The burden-of-proof problem

When an employer's records are missing or unreliable, courts generally allow employees to prove hours through reasonable estimates and their own testimony, and the employer then has to rebut them. Good records are your defense. If you cannot show a contemporaneous record, you are arguing against a story that sounds plausible.

This is also why audit trails matter. A record that shows the original punch, the correction, who approved it and when is a record you can defend. A spreadsheet cell overwritten with a new number is not.

If you stay on paper or Excel: a minimum standard

If you are not ready to change yet, tighten what you have:

1. Have employees record start and end times as they happen, not at the end of the week.

2. Require an employee signature and a supervisor approval on every timesheet.

3. Lock completed periods and keep read-only copies by workweek.

4. Never overwrite; add a correction note with date and initials.

5. Back up the files and store them for at least the retention period.

Then compare the effort to a system that does this by default. Our article on how much time tracking software costs puts numbers on that comparison.

Consider the time cost as well. If a manager spends two hours each pay period collecting sheets, deciphering handwriting and re-keying hours, and the manager earns $30.00 per hour, that is 2 x $30.00 = $60.00 per period. Over 26 biweekly periods, the cost is 26 x $60.00 = $1,560.00 per year, before counting any correction work. That money is spent on a process that still leaves you with weak evidence, so the real comparison is not software cost against nothing but software cost against the hidden cost of the manual method.

How SimpleWorkshift Helps Replace Paper and Spreadsheets

SimpleWorkshift is a cloud time clock for iOS, Android and the web. Employees clock in and out themselves, each entry carries a GPS location, and the system keeps the original entries so that corrections are visible. Managers see time entries and exceptions in real time, and automatic overtime calculations remove the formula errors that create back wage claims.

Custom reports and dashboards let you pull hours by employee, week or department when an auditor asks, and the payroll closing step gives you one approved record to send to payroll. It is built with an FLSA compliance focus for retail, services, manufacturing, healthcare, startups and remote teams. Start a 30-day free trial, no contracts and cancel anytime, at simpleworkshift.com.