The schedule, the punch, and the invoice are not the same record
A security company can schedule eight hours, work eight hours, export six hours, pay eight hours, and invoice six. Every number can be “correct” inside the system that produced it while the company still leaves two hours unbilled.
The mistake is treating the schedule, the punch report, and the invoice as versions of one document. They answer different questions. Reconciliation is the work of explaining the difference.
The schedule records intent
The schedule says who was expected, where they were expected, and for how long. It is the company’s coverage plan. It does not prove that the officer arrived on time, remained for the entire shift, or followed the required check-in procedure.
Keep the schedule anyway. When a punch is missing, the original assignment provides the first piece of context. Replacing it with the final attendance record destroys evidence of what changed.
The punch records what the timekeeping system observed
A punch report records successful events and calculations. If an officer misses a clock-out, uses the wrong site credential, arrives through a replacement process, or completes a required step outside the expected system, the export may not contain the full working history.
A complete-looking export is therefore not the same as a complete week. Zero hours may mean no work occurred. It may also mean the system could not calculate a duration. The row needs evidence, not an automatic assumption in either direction.
The invoice records an approved financial claim
The invoice should contain the hours and rates the company can support under the client or vendor agreement. It should not blindly copy the schedule, because planned hours may not have been worked. It should not blindly copy the export, because worked time may be missing or shortened.
This is why the invoice is the end of a review process. It is not just a prettier punch report.
Reconcile by exception
Most shifts do not require investigation. Compare the records and pull forward only the differences that can change coverage, payroll, or billing:
- scheduled shift with no matching punch;
- punch with no matching assignment;
- late start, early departure, or missing clock-out;
- replacement officer not reflected in the schedule;
- zero hours or zero dollars;
- rate, site, or billing-group mismatch; and
- overlapping records or a break in continuous coverage.
For every exception, decide whether to accept the export, correct it with evidence, or hold it for someone with authority to resolve it. Routine rows continue; uncertain money stops.
Evidence should travel with the correction
Useful evidence may include a timestamped arrival, the next officer’s relief time, a daily activity report, a supervisor confirmation, a dispatch message, or an approved adjustment in the vendor system. The strength of the correction comes from the evidence, not from how reasonable the scheduled shift looks.
Preserve the original value, the corrected value, the reason, the supporting record, and the approver. That creates a record another operator can understand weeks later without reconstructing the whole shift from email.
Timekeeping is also a payroll obligation
This discipline is not only about recovering revenue. The Department of Labor’s security guard fact sheet requires accurate daily and weekly records and explains that hours across multiple posts must be combined. California rules likewise require employers to record when work periods begin and end and the total daily hours worked.
A clean reconciliation process protects both sides: officers are paid from accurate working records, and clients receive invoices supported by the work delivered.
Nothing should change silently
Automation can match sites, calculate differences, gather evidence, and prepare final files. It should not erase the distinction between the vendor’s export and the company’s correction. Every consequential change should remain visible and reviewable.
The financial truth is not whichever file arrived last. It is the approved connection between the coverage planned, the work supported by evidence, the wages owed, and the amount billed.
See the operational side in the first 15 minutes after a guard call-off.