Finance AI Skill

Payroll Accounting

Process payroll accounting entries, tax calculations, benefit deductions, compliance reporting, and payroll reconciliation. Use when processing payroll journal entries, calculating payroll taxes, managing payroll liabilities, reconciling payroll to GL, prep...

Payroll Accounting

Accurate accounting for payroll transactions including gross-to-net calculations, tax withholdings, benefit deductions, accruals, and regulatory compliance.

Workflow

Payroll Accounting Cycle

Trigger: Bi-weekly/monthly payroll run; month-end accrual; quarterly tax filing; year-end close:

  1. Payroll data validation: Import HRIS data (hires, terminations, changes); validate hours; confirm benefit elections; verify W-4; reconcile headcount (HRIS vs. payroll vs. GL).
  2. Gross-to-net review: Base pay, overtime, bonuses, commissions; statutory deductions; benefit deductions; garnishments; cross-check calculation engine.
  3. Journal entry preparation: Labor expenses by cost center; wages payable, tax liabilities, benefit liabilities, net pay; allocate to GL; separate executive comp; SBC component.
  4. Payroll tax accounting: Employer matching (FICA, SUTA/FUTA); workers' comp; liability tracking; deposit schedule; Form 941 preparation.
  5. Benefit-related accounting: Employer contributions; pre-tax accounts (FSA/HSA); COBRA; FSA forfeiture; vendor reconciliation.
  6. Reconciliation: Payroll report to GL; tax liability to deposits; benefit contributions to vendor statements; headcount to HRIS.
  7. Compliance reporting: W-2/W-3, Form 941, state filings, ACA reporting (1094-C/1095-C), unemployment reports.
  8. Month-end close: Payroll accruals through last day; liability reconciliation; variance analysis vs. budget.

Payroll Processing Calendar

PAYROLL PROCESSING CALENDAR — Bi-Weekly Cycle
================================================

Payroll Period: 14 days (e.g., Jan 1 – Jan 14)

Day 1–2 (Data Collection):
  ├─ HRIS sync: New hires, terminations, salary changes, benefit enrollments
  ├─ Timesheet collection: Hourly employees submit hours; approvals completed
  ├─ Overtime validation: OT > 40 hrs/week flagged for manager approval
  ├─ Bonus/commission data: Sales team submits closed deal data
  ├─ Garnishment updates: Court orders, child support, student loans
  └─ Validation: Headcount report generated; compare to prior period

Day 3 (Payroll Calculation):
  ├─ Gross pay calculation: Base + OT + bonuses + commissions + deductions
  ├─ Tax withholding: Federal, state, local (based on W-4 elections)
  ├─ FICA withholding: 6.2% Social Security (up to $168,600, 2024 limit)
  │                  + 1.45% Medicare (no limit) + 0.9% Additional Medicare (> $200K)
  ├─ Benefit deductions: Health insurance (employee share), 401(k), FSA, HSA
  ├─ Garnishments: Court-ordered amounts (priority over other deductions)
  └─ Net pay calculation: Gross − all deductions = net pay

Day 4 (Review and Approval):
  ├─ Payroll register review: Controller reviews summary report
  ├─ Variance check: Compare to prior period and budget (flag > 10% variance)
  ├─ New hire verification: First paycheck amounts validated
  ├─ Termination verification: Final paycheck processed (state timing rules)
  ├─ Exception review: Missing timesheets, unusual deductions, negative balances
  └─ CFO sign-off: For periods with material variances or unusual items

Day 5 (Payment and Posting):
  ├─ Direct deposit file generated: ACH file sent to bank (by 2 PM cutoff)
  ├─ Check printing: For employees without direct deposit (if applicable)
  ├─ Journal entries posted to GL:
  │   Dr Salaries and Wages              $XXX,XXX
  │   Dr Payroll Taxes (employer)        $XX,XXX
  │   Dr Benefits (employer)             $XX,XXX
  │   Cr Wages Payable                   $XX,XXX
  │   Cr Federal Income Tax Payable      $XX,XXX
  │   Cr State Income Tax Payable        $XX,XXX
  │   Cr FICA Payable                    $XX,XXX
  │   Cr Benefits Payable                $XX,XXX
  │   Cr 401(k) Payable                  $X,XXX
  │   Cr Garnishments Payable            $X,XXX
  │   Cr Cash (net pay)                  $XXX,XXX
  ├─ Sub-ledger updated: Employee balances, year-to-date totals
  └─ Pay stubs distributed: Electronic delivery within 24 hours

Day 6–7 (Reconciliation and Filing):
  ├─ GL reconciliation: Payroll entries match payroll register
  ├─ Tax liability reconciliation: Withholdings match deposit schedule
  ├─ Benefit vendor reconciliation: Contributions match vendor statements
  ├─ Deposit filings: Electronic deposits via EFTPS (by deposit deadline)
  ├─ Documentation archived: Payroll register, JE support, approval records
  └─ Close payroll period: Lock period; prevent retroactive changes

Payroll Tax Framework

Tax Calculations and Filings

PAYROLL TAX CALCULATION REFERENCE
===================================

Employee Withholdings (deducted from employee paycheck):
  Federal Income Tax: Progressive rates 10%–37% (based on W-4 and income)
    2024 brackets (single):
      10%: $0 – $11,600
      12%: $11,601 – $47,150
      22%: $47,151 – $100,525
      24%: $100,526 – $191,950
      32%: $191,951 – $243,725
      35%: $243,726 – $609,350
      37%: $609,351+

  Social Security (FICA): 6.2% on wages up to $168,600 (2024 wage base)
    Employee: 6.2% | Employer: 6.2% | Total: 12.4%
    Max employee: $168,600 × 6.2% = $10,453.20 annually

  Medicare (FICA): 1.45% on all wages (no cap)
    Employee: 1.45% | Employer: 1.45% | Total: 2.9%
    Additional Medicare: 0.9% on wages > $200,000 (employee only)

  State Income Tax: Varies by state (0% in TX, FL, WA, NV, SD, WY, TN, ID)
    California: 1%–13.3% (progressive)
    New York: 4%–10.9% (progressive)
    Texas: 0% (no state income tax)
    Colorado: 4.4% (flat rate)

  Local Income Tax: Varies by city/county
    Example: NYC 2.375% on wages > $4,850/quarter
    Example: Cincinnati 1% (with reciprocity agreements)

Employer Payroll Taxes (employer expense, not withheld):
  Social Security: 6.2% matching (up to wage base)
  Medicare: 1.45% matching (no cap)
  FUTA (Federal Unemployment): 6% on first $7,000 per employee
    Effective rate: 0.6% after state credit (if state timely filed)
    Annual max per employee: $42.00
  SUTA (State Unemployment): Varies by state and experience rate
    New employer rate: 2.7–5.4% (varies by state)
    Experience-rated: 0.5–5.4% based on separation history
    Wage base: $7,000–$15,000 (varies by state)
  Workers' Compensation: Experience-rated by industry classification
    Office workers: $0.25–$1.50 per $100 payroll
    Construction: $2.00–$15.00 per $100 payroll
    Annual premium: 0.25–15% of payroll (varies by classification)

Total Employer Payroll Tax Cost:
  Typical: 15–25% of gross payroll
  Components: FICA match (7.65%) + SUTA/FUTA (0.5–3%) + Workers' comp (0.5–5%)
  Example: $100,000 salary → employer pays ~$15,000–$25,000 in taxes

Payroll Tax Deposit Schedule:
  Monthly depositers (liability < $50,000 in look-back year):
    Deposit by 15th of following month
    File Form 941 quarterly (Apr 30, Jul 31, Oct 31, Jan 31)

  Quarterly depositers (liability ≥ $50,000 in look-back year):
    Deposit within 3–7 business days of payroll (based on payday)
    File Form 941 quarterly

  Same-day deposit (liability ≥ $100,000 in any single day):
    Deposit same day; cannot offset against future payments
    Automatic same-day depositor for following year

Quarterly Filing Calendar

PAYROLL TAX FILING CALENDAR
=============================

Form 941 (Quarterly Federal):
  Q1 (Jan–Mar):  File by April 30
  Q2 (Apr–Jun):  File by July 31
  Q3 (Jul–Sep):  File by October 31
  Q4 (Oct–Dec):  File by January 31
  Extension: 60-day extension available (file by June 28, Sep 30, Dec 31, Mar 31)
  Deposit: Via EFTPS (Electronic Federal Tax Payment System)
  Penalty: Late deposit = 2–15% of unpaid amount (based on days late)

Form 940 (Annual Federal Unemployment):
  File by January 31 (following year)
  Covers: FUTA tax on first $7,000 per employee
  Credit: Up to 5.4% for state unemployment taxes paid

State Quarterly Returns:
  California: DE 9/9C by last day of month following quarter-end
  New York: IT-2104 by last day of month following quarter-end
  Texas: No state income tax (no quarterly filing)

Annual Filings:
  W-2: Furnish to employees by January 31; file with SSA by January 31
  W-3: Transmittal form filed with SSA alongside W-2s
  State W-2: File with state by January 31 (varies by state)
  Form 941 annual reconciliation: Depositions vs. liability
  ACA 1094-C/1095-C: File by March 2 (paper) / March 31 (electronic)

Payroll Reconciliation

Monthly Reconciliation Process

PAYROLL RECONCILIATION CHECKLIST
==================================

1. Payroll Register to GL:
   - Total gross pay: Payroll register = GL Salaries and Wages
   - Total net pay: Payroll register = GL Cash (disbursement)
   - Total deductions: Payroll register = GL Payable accounts
   - Variance tolerance: $0 (exact match required)
   - Frequency: Every payroll period
   - Sign-off: Payroll manager

2. Tax Liability to Deposits:
   - Withholding liability: YTD withholdings = deposits + outstanding liability
   - FICA liability: YTD FICA = deposits + outstanding liability
   - SUTA/FUTA: YTD tax = deposits + outstanding liability
   - Variance tolerance: $0 (exact match required)
   - Frequency: Monthly (at minimum)
   - Sign-off: Controller

3. Benefit Contributions to Vendor:
   - Health insurance: Employer contribution = vendor invoice amount
   - 401(k): Employer match = vendor statement contribution
   - FSA/HSA: Employee + employer = vendor custodial account
   - Variance tolerance: $0 (exact match)
   - Frequency: Monthly (with vendor statement)
   - Sign-off: Benefits administrator

4. Headcount Reconciliation:
   - HRIS active employees = Payroll system active employees
   - GL headcount accrual = Payroll headcount × loaded rate
   - Variance investigation: Terminations, new hires, part-time conversions
   - Frequency: Monthly
   - Sign-off: HR director + Controller

5. Year-to-Date Reconciliation:
   - YTD payroll expense = Budget variance analysis
   - YTD tax deposits = Tax return liability
   - YTD benefit costs = Vendor annual statement
   - Frequency: Quarterly
   - Sign-off: CFO

Edge Cases

Integration Points