Finance AI Skill

Payroll Finance

Manage payroll finance operations including payroll accounting, compensation planning, bonus calculations, equity accounting, payroll tax compliance, and payroll audit. Use when processing payroll accounting entries, managing compensation budgets, calculati...

Payroll & Compensation Finance

Manage payroll accounting, compensation planning, and related financial operations.

Payroll Accounting

Payroll Process & Journal Entries

PAYROLL ACCOUNTING PROCESS — Bi-Weekly Cycle
═════════════════════════════════════════════

PAYROLL CYCLE TIMELINE:
  Day -5: Time & attendance data collected
  Day -3: Payroll calculation (gross-to-net)
  Day -2: Manager approval (exceptions review)
  Day -1: Final payroll review (Payroll Manager)
  Day 0: Payroll run (net pay distributed)
  Day +1: Payroll journal entries posted
  Day +3: Payroll tax deposits (per schedule)
  Day +5: Payroll reconciliation completed
  Day +10: Payroll accruals updated (month-end)

PAYROLL JOURNAL ENTRIES:

1. PAYROLL RUN ENTRY (per pay period):
   ┌────────────────────────────────────┬──────────┬──────────┐
   │ Account                          │ Debit    │ Credit   │
   ├────────────────────────────────────┼──────────┼──────────┤
   │ Salaries & Wages (by department)  │ $4,200K  │          │
   │ Payroll Taxes — Employer         │ $380K    │          │
   │ Benefits — Employer              │ $320K    │          │
   │ 401(k) Employer Match            │ $84K     │          │
   │ Workers' Comp Insurance          │ $45K     │          │
   │ ───────────────────────────────── │ ──────── │ ──────── │
   │ Total debits                     │ $5,029K  │          │
   │                                  │          │          │
   │ Cash — Payroll                  │          │ $3,864K │
   │ Wages Payable                    │          │ $3,864K │
   │ Payroll Taxes Payable (withheld) │          │ $620K   │
   │ Benefits Payable (withheld)      │          │ $280K   │
   │ 401(k) Payable (employee)        │          │ $84K    │
   │ State/Local Tax Payable          │          │ $92K    │
   │ ───────────────────────────────── │ ──────── │          │
   │ Total credits                    │          │ $5,029K │
   └────────────────────────────────────┴──────────┴──────────┘

2. PAYROLL TAX EXPENSE ENTRY (monthly):
   Debit:  Payroll Tax Expense               $380,000
   Credit: Payroll Taxes Payable (employer)   $380,000
   (FICA employer, FUTA, SUTA, local taxes)

3. BENEFITS ACCRUAL ENTRY (monthly):
   Debit:  Benefits Expense                   $320,000
   Credit: Benefits Payable/Accrued Liab.     $320,000
   (Health insurance, dental, vision, life, disability)

4. PTO ACCRUAL ENTRY (monthly):
   Debit:  PTO Accrual Expense                $145,000
   Credit: Accrued PTO Liability              $145,000
   (Vacation, sick leave, holiday accrual)

5. MONTH-END PAYROLL RECONCILIATION:
   Compare:
     - Payroll register (sub-ledger) ↔ GL payroll accounts
     - Payroll tax deposits ↔ tax payable balances
     - Benefits payments ↔ benefits payable balances
     - Headcount report ↔ payroll headcount
   Tolerance: $0 (zero tolerance — every dollar accounted for)

Payroll Reconciliation

PAYROLL RECONCILIATION — January 2025
══════════════════════════════════════

PAYROLL REGISTER SUMMARY:
  Pay periods: 4 (Jan 2025)
  Total headcount: 542 (avg.)
  Gross payroll: $16,800,000
  Net payroll: $12,480,000
  Withholdings: $4,320,000
  
  Breakdown by component:
    Base salary: $14,200,000 (84.5%)
    Overtime: $420,000 (2.5%)
    Bonuses: $1,200,000 (7.1%)
    Commissions: $680,000 (4.1%)
    Other ( allowances, stipends): $300,000 (1.8%)

GL RECONCILIATION:
  ┌───────────────────────────────┬──────────────┬──────────────┬──────────┐
  │ Account                      │ Sub-Ledger   │ GL Balance   │ Variance │
  ├───────────────────────────────┼──────────────┼──────────────┼──────────┤
  │ Salaries — R&D              │ $5,460,000   │ $5,460,000   │ $0       │
  │ Salaries — Sales            │ $4,368,000   │ $4,368,000   │ $0       │
  │ Salaries — Marketing        │ $1,512,000   │ $1,512,000   │ $0       │
  │ Salaries — G&A              │ $2,856,000   │ $2,856,000   │ $0       │
  │ Salaries — CS               │ $1,176,000   │ $1,176,000   │ $0       │
  │ Payroll taxes (employer)    │ $1,512,000   │ $1,512,000   │ $0       │
  │ Benefits (employer)         │ $1,280,000   │ $1,280,000   │ $0       │
  │ ─────────────────────────── │ ────────── │ ────────── │ ─────── │
  │ TOTAL                       │ $18,154,000  │ $18,154,000  │ $0 ✓     │
  └───────────────────────────────┴──────────────┴──────────────┴──────────┘

  Status: ✓ BALANCED — All accounts reconciled

PAYROLL TAX RECONCILIATION:
  Federal income tax withheld:  $1,820,000   Deposited: $1,820,000  ✓
  FICA (employee):              $1,293,600   Deposited: $1,293,600  ✓
  FICA (employer):              $1,293,600   Accrued:   $1,293,600  ✓
  FUTA:                           $50,400    Accrued:     $50,400  ✓
  SUTA:                           $84,000    Accrued:     $84,000  ✓
  State income tax:               $378,000   Deposited: $378,000  ✓
  Local taxes:                     $56,000   Deposited: $56,000  ✓

  All deposits made on time: ✓
  Next deposit due: Feb 1, 2025
  Penalty/interest exposure: $0

HEADCOUNT RECONCILIATION:
  Payroll headcount:            542
  HRIS headcount:               542
  Budget headcount:             550
  Variance (vs budget):        (8) — 8 positions open
  Status: ✓ CONSISTENT

Compensation Planning & Budgeting

Annual Compensation Planning

ANNUAL COMPENSATION PLAN — FY2025
══════════════════════════════════

COMPENSATION BUDGET OVERVIEW:
  Total payroll (FY2024 actual): $168,000,000
  Budget increase (FY2025):      $25,200,000 (+15.0%)
  Total payroll (FY2025 budget): $193,200,000
  
  Budget increase breakdown:
    New hires:           $14,700,000 (+8.8%)    50 new positions
    Merit increases:      $5,880,000 (+3.5%)    3.5% average merit
    Promotions:            $1,680,000 (+1.0%)    40 promotions
    Market adjustments:    $1,260,000 (+0.8%)    20 roles (below market)
    Other:                   $680,000 (+0.4%)    Miscellaneous

MERIT INCREASE GUIDELINES:
  ┌─────────────────────┬──────────┬──────────┬──────────────┐
  │ Performance Rating  │ % of Pop │ Min Raise│ Max Raise    │
  ├─────────────────────┼──────────┼──────────┼──────────────┤
  │ Exceeds Expectations│ 20%      │ 4.0%     │ 6.5%         │
  │ Meets Expectations  │ 60%      │ 2.5%     │ 4.0%         │
  │ Needs Improvement   │ 15%      │ 0.0%     │ 2.5%         │
  │ Unsatisfactory      │ 5%       │ 0.0%     │ 0.0%         │
  │ ─────────────────── │ ──────── │ ──────── │ ─────────── │
  │ Company-wide avg.   │ 100%     │          │ 3.5%         │
  └─────────────────────┴──────────┴──────────┴──────────────┘

  Budget impact of merit increases: $5,880,000
  Effective date: January 1, 2025 (or hire anniversary for new hires)

BONUS PLAN OVERVIEW:
  Executive bonus plan:
    Eligible: C-suite (CEO, CFO, CTO, COO, CHRO, GC)
    Target: 50-100% of base salary
    Maximum: 200% of target
    Metrics: Revenue (30%), EBITDA (30%), strategic goals (40%)
    FY2024 payout: 85% of target (revenue slightly below, EBITDA above)
  
  Management bonus plan:
    Eligible: VP, Director, Manager
    Target: 15-30% of base salary
    Maximum: 150% of target
    Metrics: Company performance (50%), department goals (30%), individual (20%)
    FY2024 payout: 90% of target
  
  Sales commission plan:
    Structure: Base + commission (variable 40-60% of total comp)
    Accelerators: >100% attainment → 1.5x commission rate
    FY2024 commission expense: $4,800,000 (4.0% of revenue)
    FY2025 budget: $5,400,000 (4.5% of revenue)

EQUITY COMPENSATION:
  RSU grant program (annual):
    Eligible: All employees (level-based grant values)
    Vesting: 4-year (25% annually after 1-year cliff)
    FY2024 grants issued: 1,200,000 shares
    FY2025 budget: 1,500,000 shares (refresh + new hires)
  
  Stock option program (early employees):
    Remaining pool: 2,800,000 shares (5.6% of outstanding)
    Exercise price: Last 409A valuation ($42.50/share)
    Outstanding options: 4,200,000 (various vesting schedules)
  
  Total equity expense (FY2024): $32,000,000 (19.0% of revenue)
  Total equity expense (FY2025 est.): $36,000,000 (18.0% of revenue, declining %)

Bonus & Incentive Accounting

Bonus Accrual Process

ANNUAL BONUS ACCRUAL — Q4 FY2024
══════════════════════════════════

ACCURAL METHODOLOGY:
  Step 1: Determine company performance factor
  Step 2: Apply to individual target bonus amounts
  Step 3: Adjust for individual performance ratings
  Step 4: Calculate total accrual by department
  Step 5: Post accrual journal entries

PERFORMANCE FACTOR CALCULATION:
  Revenue target: $400M          Actual: $395M  (98.8% → 0.99 factor)
  EBITDA target: $42M            Actual: $45M  (107.1% → 1.07 factor)
  Strategic goals: 8/10 achieved (80% → 0.80 factor)
  
  Weighted company factor:
    Revenue (30%): 0.99 × 0.30 = 0.297
    EBITDA (30%): 1.07 × 0.30 = 0.321
    Strategic (40%): 0.80 × 0.40 = 0.320
    ══════════════════════════════════
    COMPANY FACTOR: 0.938 (93.8% of target)

ESTIMATED BONUS LIABILITY:
  ┌──────────────────────┬──────────┬──────────┬──────────────┬──────────────┐
  │ Group                │ Headcnt. │ Target/  │ Company     │ Estimated    │
  │                      │          │ person   │ Factor      │ Total        │
  ├──────────────────────┼──────────┼──────────┼──────────────┼──────────────┤
  │ Executive            │ 6        │ $250,000 │ × 0.938     │ $1,407,000   │
  │ VP/Director          │ 35       │ $80,000  │ × 0.938     │ $2,626,000   │
  │ Manager              │ 120      │ $35,000  │ × 0.938     │ $3,940,000   │
  │ Individual contrib.  │ 400      │ $15,000  │ × 0.938     │ $5,628,000   │
  │ Sales (commission)   │ 80       │ variable │ N/A         │ $1,200,000   │
  │ ─────────────────── │ ─────── │ ─────── │ ────────── │ ─────────── │
  │ TOTAL ESTIMATED     │          │          │             │ $14,801,000  │
  └──────────────────────┴──────────┴──────────┴──────────────┴──────────────┘

  Prior accrual (Q3):  $13,500,000
  Additional accrual:  $1,301,000
  New total liability: $14,801,000

JOURNAL ENTRY:
  Debit:  Bonus Expense (by department allocation)     $1,301,000
  Credit: Accrued Bonus Payable                          $1,301,000
  
  Department allocation:
    R&D:     30% → $390,300
    Sales:   25% → $325,250
    Marketing: 10% → $130,100
    G&A:    20% → $260,200
    CS:      15% → $195,150

  Actual payout: February 15, 2025
  Payment method: Direct deposit (regular payroll)
  Tax treatment: Supplemental wage (flat 22% federal withholding)

Equity Compensation Accounting

Share-Based Compensation (ASC 718)

EQUITY COMPENSATION ACCOUNTING — ASC 718
═════════════════════════════════════════

OUTSTANDING AWARDS SUMMARY:
  RSUs (Restricted Stock Units):
    Granted but unvested: 3,800,000 shares
    Weighted avg. grant date fair value: $38.50
    Total unrecognized compensation cost: $85,900,000
    Expected recognition period: 2.4 years (weighted avg.)
  
  Stock Options:
    Outstanding: 4,200,000 shares
    Exercisable: 2,100,000 shares
    Weighted avg. exercise price: $22.50
    Weighted avg. remaining term: 4.2 years
    Intrinsic value (at $54.20/market): $132,360,000
  
  Employee Stock Purchase Plan (ESPP):
    Shares authorized: 500,000
    Shares remaining: 380,000
    Outstanding offers: 45,000 shares

QUARTERLY EQUITY EXPENSE:
  ┌────────────────────────┬──────────┬──────────┬────────────────────┐
  │ Quarter               │ RSU Exp. │ Option   │ Total Equity Exp.  │
  │                       │          │ Exp.     │                    │
  ├────────────────────────┼──────────┼──────────┼────────────────────┤
  │ Q1 FY2024             │ $7,200K  │ $800K    │ $8,000K            │
  │ Q2 FY2024             │ $7,500K  │ $850K    │ $8,350K            │
  │ Q3 FY2024             │ $7,800K  │ $900K    │ $8,700K            │
  │ Q4 FY2024             │ $8,100K  │ $950K    │ $9,050K            │
  │ ───────────────────── │ ────── │ ────── │ ────────────── │
  │ FY2024 Total          │ $30,600K │ $3,500K  │ $34,100K           │
  │ FY2025 Estimate/Q     │ $8,500K  │ $1,000K  │ $9,500K/quarter   │
  └────────────────────────┴──────────┴──────────┴────────────────────┘

  Trend: Increasing (new grants + mark-to-market on RSUs)
  As % of revenue: 19.0% (FY2024) → 18.0% (FY2025 est.)

VALUATION METHODOLOGY:
  RSUs: Fair value at grant date = market price of common stock
  Options: Black-Scholes-Merton model
    Inputs:
      Stock price: $54.20
      Exercise price: $54.20 (at grant)
      Expected term: 5.5 years
      Expected volatility: 45% (peer group)
      Risk-free rate: 4.3% (5-year Treasury)
      Dividend yield: 0% (no dividend history)
    Result: Fair value per option ≈ $21.80
  
  409A Valuation (for tax purposes):
    Last valuation: $42.50/share (October 2024)
    Next valuation: April 2025 (annual requirement)
    Valuation firm: Independent 409A specialist

FORFEITURE ASSUMPTIONS:
  Historical forfeiture rate: 8% (pre-vesting)
  Accounting approach: Recognize expense assuming forfeiture
    (reduce expense as forfeitures actually occur)
  Impact: Reduces reported expense by ~8% vs. no-forfeiture assumption

COMPENSATED ABSENCE ACCOUNTING:
  PTO liability (ASC 710/720):
    Current liability (available within 12 months): $2,800,000
    Non-current liability (deferred): $600,000
    Total PTO liability: $3,400,000
    Annual expense: $580,000 (average monthly accrual)
    Utilization rate: 72% (28% carried forward)
  
  Accrual policy:
    Vacation: Accrue at rate of 10-20 days/year (tenure-based)
    Sick leave: Accrue at rate of 5-7 days/year
    Maximum carryforward: 1.5x annual accrual
    Payout on termination: Per state law (CA: yes; TX: no)

Output

Payroll Finance Dashboard

PAYROLL FINANCE DASHBOARD — Jan 27, 2025
══════════════════════════════════════════

Payroll Status:
  Current pay period: ✓ Processed (Jan 24)
  Next pay date: Feb 7
  Payroll run: On schedule
  Exceptions: 3 (1 late timesheet, 2 new hire data)

Payroll Metrics:
  MTD payroll cost: $5,600,000 (33% of monthly budget)
  YTD payroll cost: $16,800,000 (28% of annual budget)
  Headcount: 542 (budget: 550, 8 open)
  Avg. salary: $98,000 (+3.2% YoY)
  Payroll tax rate (employer): 9.5% of gross pay

Compensation:
  Merit increases: Effective Jan 1 (completed)
  Bonus accrual (Q4): $14.8M (93.8% of target)
  Equity expense (Q1 est.): $9.5M
  Total comp budget utilization: 88%

Reconciliation:
  GL vs sub-ledger: ✓ Balanced ($0 variance)
  Tax deposits: ✓ All on time
  Benefits payments: ✓ Reconciled
  Headcount: ✓ Consistent (HRIS = payroll)

Upcoming:
  Feb 1: Payroll tax deposits due
  Feb 7: Regular payroll
  Feb 15: Bonus payouts
  Mar 15: Q1 equity expense calculation
  Apr 1: 409A valuation update
  Apr 15: Q1 payroll audit

Integration Points

Edge Cases