Does this convert hours to dollars?

This balance worksheet stays in hours unless you separately apply a pay rate.

Are company holidays included?

Only if you enter them in used or accrued hours yourself.

Can ending balance go negative?

The math can show negative if used exceeds opening plus accrued—check whether your employer allows that.

No. Confirm accrual rules with your employer.

Vacation Leave Balance Basics: Accrual Minus Usage

A vacation balance worksheet adds opening balance and accrued hours, then subtracts used hours to show an ending balance. This guide explains that ledger logic. It is educational only—not HR policy software, not a payout guarantee, and not legal advice about PTO cash-out rules.

What a Vacation balance Worksheet Actually Answers

The useful question is not "What will my employer pay?" It is "If these inputs are correct for this scenario, what result does transparent arithmetic produce?" A vacation balance worksheet makes that visible. No hardcoded accrual rates, waiting periods, or California paid-vacation caselaw outcomes. DOL and state labor agency materials provide official context only.

Educational worksheets only

Employers define accrual caps, carryover, and payout differently by plan and jurisdiction. This worksheet does not encode state PTO statutes or union contracts. Confirm policy with HR—not a calculator.

The Inputs That Drive the Math

Most educational vacation balance worksheets need opening balance hours, accrued hours, and used hours. Label each amount, keep one scenario per run, and avoid mixing pay periods or tax years without noting the blend.

Inputs and What They Do Not Prove

Input	What it does here	What it does not prove	Common confusion
Opening balance	Hours you start the window with	Automatic HRIS import	Mixing days and hours without converting
Accrued hours	Hours earned in the scenario	Employer accrual formula	Assuming biweekly accrual without checking policy
Used hours	PTO taken in the window	Manager approval workflow	Forgetting partial-day increments
Ending balance	Opening + accrued − used	Cash payout amount	Treating hours as dollars without a rate

How the Worksheet Orders the Math

Gather labeled inputs

Collect opening balance hours, accrued hours, and used hours from stubs, policies, or a scenario you define.

Apply the core formula

Ending balance = opening + accrued − used.

Read the primary output

Treat the result as scenario math—not an employer or IRS promise.

Stress-test once

Change one input at a time to see sensitivity before sharing numbers.

Confirm officially when stakes rise

Payroll, tax filing, and wage claims need HR, IRS, DOL, or qualified professionals—not a worksheet alone.

Run the Vacation Balance Worksheet

Enter opening balance, accrual, and used hours to see ending vacation hours:

Open Vacation Pay Calculator

Worked Scenario Without Claiming Legal Outcomes

Opening 40 h, accrued 8 h, used 12 h leaves 36 h ending balance. The worksheet obeys your entries; it does not invent policy or law.

What This Model Intentionally Omits

Accrual caps, use-it-or-lose-it rules, and carryover limits
Conversion from days to hours by employer schedule
Payout on termination calculations
Waiting periods and tenure tiers
Integration with payroll gross-up for PTO cash

How to Use Results Responsibly

Prefer dated snapshots and labeled inputs over round numbers shared as facts. When outcomes affect taxes, pay, or leave rights, pair worksheet math with official IRS, DOL, or CFPB educational materials and qualified advisors. No hardcoded accrual rates, waiting periods, or California paid-vacation caselaw outcomes. DOL and state labor agency materials provide official context only.

Bottom Line

Vacation balance basics are transparent arithmetic on inputs you control. Keep YMYL language cautious, cite official education where relevant, and treat every result as a worksheet—not as tax, legal, or payroll advice.