--- name: payroll-finance description: 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, calculating bonus accruals, handling equity compensation accounting, ensuring payroll tax compliance, or conducting payroll audits. Triggers on phrases like "payroll accounting", "compensation budget", "bonus accrual", "equity accounting", "share-based compensation", "payroll tax", "payroll audit", "compensation planning", "401k accounting", "overtime accounting", "payroll reconciliation". --- # 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 - Payroll platforms (ADP, Gusto, Rippling): Payroll processing, tax filing - ERP/GL (NetSuite, SAP): Payroll journal entries, account reconciliation - HRIS (Workday, BambooHR): Employee data, compensation records, headcount - Time & attendance (UKG, Kronos, Deputy): Hours worked, overtime tracking - Benefits platforms (BenefitHub, Zenefits): Benefits enrollment, cost allocation - Equity platforms (Carta, Pulley): Grant management, vesting tracking, 409A - Tax systems (Gusto Tax, ADP Tax): Payroll tax calculation and filing - BI platforms: Compensation dashboards, budget tracking - Banking systems: Direct deposit, tax deposits - Audit tools: Payroll audit trail, exception reporting ## Edge Cases - **Multi-state payroll**: State tax registration; withholding rates; unemployment tax (SUTA) per state; local taxes - **International payroll**: Local employment law; currency conversion; social security; tax treaty benefits - **M&A payroll integration**: Dual payroll during transition; benefit plan coordination; compensation harmonization - **Executive compensation**: Say-on-pay; clawback provisions; change-in-control acceleration; SEC disclosure - **Seasonal/hourly workforce**: Overtime compliance (FLSA); fluctuating workweek; tip credit; predictive scheduling - **Payroll errors**: Underpayment/overpayment recovery; good faith errors; employee communication - **Union/collective bargaining**: Contract compliance; seniority calculations; grievance-related pay adjustments - **Compliance audits (DOL)**: Wage & hour compliance; misclassification; recordkeeping; penalty defense - **Payroll system migration**: Parallel run; data validation; employee communication; tax continuity - **Stock option exercises**: Withholding obligation; net exercise; ISO vs. NSO tax treatment; Section 83(b)