PTO Balance Reconciliation: Checklist & Worked Example

1. Define what you are reconciling

Reconcile one employee and one leave account at a time. Vacation, sick leave and banked time may follow different rules, so combining them can hide an incorrect posting. Record the employee identifier and account name before doing the arithmetic.

Start with an opening balance that was previously reviewed. If the opening figure came from a migration, retain the approved source and conversion notes. A correct sum of this month's movements cannot prove that an unsupported opening balance was correct.

Use one unit throughout the review. If your records use hours, keep the calculation in hours. Convert days only with the applicable documented hours-per-day assumption. Write that assumption beside the conversion, especially where employees work different shift lengths.

A useful review cadence is after each payroll or at a regular monthly close, with extra checks after a migration or a policy assignment change. Choose the cadence according to transaction volume and your team's review needs, then give one person responsibility for closing unresolved items.

2. Match dates before comparing balances

A balance needs a date definition. A report of activity during a month, a balance through a cutoff date and a balance that includes future records answer different questions. Save the report name, filters and generation time with each reconciliation.

Keep future commitments separate in your worksheet until you know whether the comparison balance already includes them. Subtracting an approved future absence from a balance that already reflects it counts the same leave twice. Likewise, a pending request should not be treated as a posted withdrawal without checking its actual status and resulting records.

For a repeatable close, write a clear scope such as “transactions dated through October 31, reviewed November 2.” Then identify any later-dated records included in the screen you are comparing. The goal is an explained bridge between the two numbers, with each movement counted once.

3. Copy this PTO reconciliation template

Create one review record per employee and leave account. Store supporting exports in the team's approved location and reference them from the worksheet.

Use a consistent difference convention: recorded balance minus expected balance. A negative result means the recorded balance is lower than the worksheet expects. Keep the sign visible; an unsigned “8 hours” does not tell the reviewer which direction needs explaining.

4. Worked example: explain an eight-hour gap

Consider a fictional employee, Jordan, whose vacation account is measured in hours. The opening balance is verified at 40 hours. During the review period, Jordan earns 6 hours, takes 8 hours of leave and receives an approved 2-hour correction for an earlier under-credit.

Now suppose the comparison screen shows 32 hours. The initial difference is 32 − 40 = −8 hours. Before entering a correction, the reviewer finds an approved 8-hour absence for a date after the cutoff, already reflected in that balance.

The comparison bridge is therefore 40 cutoff hours − 8 future approved hours = 32 hours. The gap is explained by scope. No balancing adjustment is needed. Retain the future request reference and label both figures so the next reviewer can reproduce the explanation.

If there were no supporting future withdrawal, the eight-hour difference would remain open for investigation. The same arithmetic does not justify a correction by itself. Every adjustment needs a documented cause and the appropriate authorization.

5. Investigate the cause before correcting a balance

Check scope and units first

Compare the employee, leave account, cutoff and units on both sides. Look for a missing opening balance, a report limited to current-period activity or an hours-to-days conversion using a different workday length. Resolve these comparison problems before touching employee records.

Match movements to their source

For each unexplained withdrawal, locate the absence or adjustment that produced it. For each missing credit, identify the accrual transaction that should exist and why. Check for duplicate entries, a changed absence date, a correction posted to the wrong account or an import counted twice.

Review the policy that actually applied

TimeTrex's Accrual Policies documentation distinguishes calendar-based and hour-based accruals, eligibility settings, service milestones, balance caps and rollover settings. A cap or eligibility condition can explain why a simple “rate × hours” estimate differs from actual records. Check the employee's assigned policy and relevant settings rather than assuming every employee accrues identically.

If a policy appears wrong, route it to the policy owner for review. Do not change a shared rule solely to make one employee's reconciliation agree. Assess who else could be affected and retain the decision with the correction evidence.

Close with a traceable resolution

Record whether the issue was a reporting difference, a source-record error or a policy question. After an authorized correction, rerun the same report and retain both versions. If the correction affects payroll, coordinate the related review through your normal payroll cutoff process and record any remaining follow-up.

6. Review the supporting records in TimeTrex

Start with the Accrual Balance Summary report. The documentation distinguishes “Overall Balance To Date” from “Overall Balance” and notes that the latter defaults to “All Years,” including past records and a year into the future. Select the template and period that match your question, and save those settings with the review.

Then inspect individual transactions under Attendance → Accruals. TimeTrex's Accruals guide explains how positive and negative records combine into a balance and how authorized users can view individual entries. It also describes initial balances, paid-out time and other adjustment types. Follow a record back to the relevant timesheet where available, and retain its date, amount and reason.

Use these views as evidence for the reconciliation. A summary total is the starting point; the underlying movements explain it. Menu access and available actions depend on the employee's permissions and your configuration.

7. Six-point reconciliation sign-off

Use this checklist while reviewing the account. These browser checkboxes are a temporary reading aid; save the completed review in your team's recordkeeping system.

8. Common PTO reconciliation questions