Circulos AI

Finance AI Skill

Budget Planning

Plan and manage budgets using bottom-up, top-down, or zero-based approaches. Use when creating annual budgets, allocating department budgets, building multi-year financial plans, tracking budget variances, or conducting budget review cycles. Triggers on phrases like "create budget", "annual budget", "budget allocation", "zero-based budget", "department budget", "budget template", "budget cycle", "capital budget".

Budget Planning & Management

Orchestrate comprehensive budget planning across all departments and cost centers.

Workflow

  1. Define budget framework: planning methodology, fiscal calendar, approval hierarchy, and consolidation rules.
  2. Gather baseline data: prior year actuals, YTD vs. budget, headcount plan, strategic initiatives, inflation assumptions.
  3. Distribute department-specific budget templates pre-populated with historicals and AI-generated suggestions.
  4. Collect bottom-up department submissions with validation against spending patterns and narrative requirements.
  5. Apply top-down corporate allocation constraints: revenue targets, expense envelopes, cost ratio targets.
  6. Conduct zero-based review for applicable departments — every expense requires fresh justification.
  7. Roll up to consolidated corporate budget; reconcile to targets and resolve gaps/overages.
  8. Perform variance analysis: line-item comparison to prior year, per-head metrics, benchmark comparison.
  9. Execute approval workflow: department head → finance leadership → CFO/CEO → Board notification.
  10. Lock approved budget, deploy to departments, configure budget vs. actual monitoring.

Planning Methodologies

Methodology Selection Framework

BUDGET PLANNING METHODOLOGY COMPARISON
=======================================

Incremental Budgeting:
  Approach: Start with prior year actuals, adjust for known changes
  Best for: Stable operations, predictable cost drivers, annual adjustments < 10%
  Timeline: 4–6 weeks
  Effort: Low (finance team leads, minimal department input)
  Pros: Fast, simple, low conflict, easy to explain
  Cons: Perpetuates inefficiencies, no fresh scrutiny, "use it or lose it" culture
  Cost adjustment formula: Prior Year × (1 + Inflation Rate) + Headcount Change + Known Projects
  Typical inflation factors: Salaried 2–3%, Benefits 5–7%, Travel 3–5%, Supplies 2–4%

Zero-Based Budgeting (ZBB):
  Approach: Every expense justified from scratch each cycle
  Best for: Cost reduction needed, new management, restructuring, departments >$5M spend
  Timeline: 8–12 weeks
  Effort: Very High (every manager builds decision units)
  Pros: Eliminates waste, aligns spend to strategy, forces prioritization
  Cons: Time-intensive, demotivating, can miss long-term investments, high turnover risk
  Decision Unit structure:
    - Each unit = a distinct spending area with a cost owner
    - Ranked by strategic value and ROI
    - Base level (must-have) vs. enhancement level (nice-to-have)
    - Typical: 50–200 decision units per department
  Roll-forward rate: Only top 70–80% of decision units get funded each cycle

Top-Down (Allocative):
  Approach: Senior leadership sets targets; departments work within envelopes
  Best for: Mature organizations, clear strategic priorities, cost reduction mandates
  Timeline: 2–4 weeks
  Effort: Low–Medium
  Pros: Strategic alignment, speed, clear accountability
  Cons: Departments may feel disconnected, unrealistic targets, under-funding risk
  Allocation formula:
    - Revenue departments: Budget = Revenue Target × Target Cost Ratio
    - Support departments: Budget = Headcount × Cost per FTE + Fixed Overhead
    - Example: Engineering budget = $100M revenue × 15% target ratio = $15M

Bottom-Up (Participative):
  Approach: Each department builds its own budget independently
  Best for: Decentralized orgs, department expertise needed, collaborative culture
  Timeline: 6–8 weeks
  Effort: Medium–High
  Pros: Department ownership, realistic estimates, higher buy-in
  Cons: Budget inflation ("sandbagging"), slow, may exceed corporate targets
  Typical sandbag factor: Departments request 5–15% above actual need
  Mitigation: Finance reviews and challenges each department's assumptions

Hybrid Approach (Most Common for mid-to-large companies):
  Approach: Top-down envelope + bottom-up build + zero-based review of top categories
  Timeline: 6–10 weeks
  Effort: Medium
  Pros: Balances speed, accuracy, and strategic alignment
  Cons: More complex process, requires strong finance BP team
  Typical split: 60% incremental, 25% bottom-up, 15% zero-based

Budget Cycle Timeline

ANNUAL BUDGET CYCLE — 12-WEEK PLAYBOOK
========================================

Phase 1: Preparation (Weeks 1–2)
  Week 1:
    - CFO issues budget guidance memo: overall targets, growth assumptions, cost reduction targets
    - Finance team prepares budget templates (Excel, Adaptive Insights, Anaplan)
    - Headcount plan finalized with HR (open positions, planned hires, attrition)
    - Inflation assumptions: CPI 2–3%, healthcare 5–7%, IT services 3–5%
    - FX assumptions: locked at plan rates or scenario-based (base/upside/downside)
  Week 2:
    - Budget kickoff meeting with all department heads (virtual or in-person)
    - Training session on budget templates and submission process
    - Department heads begin data gathering
    - Finance business partners assigned to each department

Phase 2: Department Builds (Weeks 3–6)
  Week 3–4:
    - Department heads draft budgets using templates
    - Include: headcount plan, compensation changes, operating expenses, capex
    - Narrative required for: any line item >15% change YoY, new initiatives, vendor changes
    - Finance BPs review department drafts; provide feedback within 48 hours
  Week 5–6:
    - Department heads revise based on feedback
    - First-pass submissions due
    - Finance team consolidates and compares to top-down targets
    - Identify departments over or under envelope (flag for negotiation)

Phase 3: Consolidation & Challenge (Weeks 7–9)
  Week 7:
    - Finance team produces consolidated view
    - Variance report: bottom-up total vs. top-down targets by department
    - Department heads with >10% variance invited to finance review meetings
  Week 8:
    - Negotiation meetings: Finance challenges high-variance departments
    - Zero-based review of flagged categories (typically top 5 spend areas)
    - Revisions made; second-pass submissions collected
    - Finance re-consolidates and validates
  Week 9:
    - Final consolidated budget reviewed by CFO
    - Scenario analysis: base case, upside (+10% revenue), downside (-10% revenue)
    - Sensitivity: test impact of 1% revenue change on key ratios
    - CFO presents to CEO for pre-approval

Phase 4: Approval & Deployment (Weeks 10–12)
  Week 10:
    - CEO approves final budget
    - Board notification memo (summary, key changes, no detailed budget typically)
    - Budget locked in system; change process established
  Week 11:
    - Department budgets distributed with formal letters
    - Budget vs. actual dashboards configured
    - Variance reporting schedule set (monthly for all, weekly for P&L-sensitive)
    - Training for new tools or processes
  Week 12:
    - Budget cycle officially closed
    - Lessons learned documented for next cycle
    - Rolling forecast initialized from approved budget

Budget Template Structure

Standard Department Budget Template

ANNUAL DEPARTMENT BUDGET — [Department Name] — FY2025
======================================================

REVENUE SECTION (Revenue-Generating Departments Only)
  Gross Revenue:                     $XXX,XXX
  Less: Discounts/Returns:            ($XX,XXX)
  Net Revenue:                       $XXX,XXX
  Revenue growth vs. PY:             +X.X%
  Revenue per FTE:                  $XXX,XXX
  Key assumptions: [customer count, ARPU, conversion rate, etc.]

HEADCOUNT & COMPENSATION
  Current FTEs:       XX
  Planned additions:   X  (Months: M3, M6, M9)
  Planned attrition:   X  (estimated)
  End-year FTEs:      XX

  Salary Budget:                  $XXX,XXX
    Avg salary increase:           3.0%
    Merit pool:                   2.5% of total salary
    New hire cost (avg):        $XX,XXX × X hires = $XX,XXX
  Benefits Budget:                $XX,XXX  (28–35% of salary)
  Bonus/Incentive Pool:           $XX,XXX  (X% of salary)
  Payroll Taxes:                  $XX,XXX  (7.65% + state FUTA/SUTA)
  Training & Development:         $XX,XXX  (2–5% of salary)
  ───────────────────────────────────────────────
  Total People Cost:             $XXX,XXX

OPERATING EXPENSES
  Travel & Entertainment:         $XX,XXX  (X% of revenue or $X per FTE)
  Professional Services:          $XX,XXX  (consulting, legal, advisory)
  Software & Subscriptions:       $XX,XXX  (SaaS licenses, tools)
  Marketing & Events:             $XX,XXX  (campaigns, trade shows)
  Training & Education:           $XX,XXX  (courses, certifications)
  Office & Facilities:            $XX,XXX  (lease, utilities, supplies)
  Insurance:                      $XX,XXX  (D&O, cyber, professional liab.)
  Recruitment:                    $XX,XXX  (agency fees, job boards)
  Miscellaneous:                  $XX,XXX  (miscellaneous, contingency 2–3%)
  ───────────────────────────────────────────────
  Total Operating Expenses:      $XXX,XXX

CAPITAL EXPENDITURES (if applicable)
  Hardware/Equipment:             $XX,XXX
  Software Development:           $XX,XXX
  Facilities Improvement:         $XX,XXX
  ───────────────────────────────────────────────
  Total Capex:                   $XX,XXX

NARRATIVE SECTION
  Key assumptions: [growth drivers, pricing changes, new products]
  Major initiatives: [project name, cost, expected ROI]
  Risks/dependencies: [what could impact the budget]
  Variances >15% YoY justification: [explain each]

Budget Template by Company Size

BUDGET TEMPLATE COMPLEXITY BY COMPANY SIZE
===========================================

Startup (1–50 employees, <$5M revenue):
  Simplified template:
    - Revenue forecast (monthly, 12-month)
    - Headcount plan (names, not just counts)
    - Top 10 expense categories
    - Capex (if any)
    - Cash flow projection (monthly burn rate)
  Process: Single spreadsheet; founder/CFO builds; 2-week cycle
  Review: Monthly vs. actual; rolling 13-week cash forecast
  Tools: Excel, Google Sheets, Ramp, Mercury

SMB (51–250 employees, $5M–$50M revenue):
  Medium template:
    - Department-level P&L
    - Monthly revenue by product/service line
    - Headcount by department with compensation detail
    - Operating expenses by category (15–20 line items)
    - Capex plan
    - Headcount-loaded cost center view
  Process: 6-week cycle; finance team supports; department head ownership
  Review: Monthly close with variance report; quarterly forecast update
  Tools: NetSuite, QuickBooks Online Advanced, Excel, Float, Vena

Mid-Market (251–2,500 employees, $50M–$500M revenue):
  Comprehensive template:
    - Cost center-level P&L with monthly detail
    - Revenue by product, region, and customer segment
    - Headcount with salary bands, merit, bonus, benefits loading
    - Operating expenses by GL account with vendor detail
    - Capex with depreciation schedule
    - Multi-currency (if international)
    - Scenario modeling (base, upside, downside)
  Process: 8–10 week cycle; FP&A leads; Finance BPs embedded
  Review: Monthly with management reporting; quarterly board update
  Tools: Adaptive Insights (Workday), Anaplan, Oracle EPM, SAP BW

Enterprise (2,500+ employees, $500M+ revenue):
  Enterprise-grade template:
    - Entity, segment, region, product, and customer dimensions
    - Multi-GAAP reporting (US GAAP, IFRS, local GAAP)
    - FX translation and hedging budgets
    - Transfer pricing budgets for intercompany
    - Consolidated and entity-level views
    - Driver-based modeling (revenue = units × price × mix)
    - Integration with ERP and HCM systems
    - Workflow automation with approval chains
  Process: 10–14 week cycle; dedicated planning team
  Review: Monthly close within 5 business days; quarterly board package
  Tools: Oracle Hyperion, SAP Analytics Cloud, Anaplan, Workday Adaptive, Tableau

Budget Governance and Controls

Budget Change Process

BUDGET AMENDMENT PROCESS
=========================

When budget changes are needed mid-year:

  Type 1: Intra-department reallocation (within same department)
    - Threshold: Any amount within department budget
    - Approval: Department head only
    - Process: Submit form; Finance validates within 2 business days
    - Documentation: Brief narrative of reason and impact
    - Frequency: Common; typically 3–5 per department per year

  Type 2: Inter-department transfer (between departments)
    - Threshold: Up to $50K or 5% of recipient budget
    - Approval: Both department heads + Finance Director
    - Process: Transfer request form; Finance validates; 3-day turnaround
    - Documentation: Full narrative with business justification
    - Impact: Both departments' budgets adjusted; P&L reallocation
    - Frequency: Moderate; typically 1–3 per quarter

  Type 3: Budget increase (exceeds approved budget)
    - Threshold: Up to 10% of original budget
    - Approval: CFO (up to $100K) or CEO (>$100K)
    - Process: Formal budget increase request with ROI analysis
    - Required data: Prior spend, business case, expected return, funding source
    - Board notification: Any single increase >$500K or >5% of total budget
    - Frequency: Limited; should occur < 5 times per year organization-wide

  Type 4: Strategic reallocation (significant budget restructuring)
    - Trigger: Major business change, acquisition, market disruption
    - Approval: CEO + CFO + Board Finance Committee
    - Process: Full re-forecast with updated assumptions
    - Scope: May involve multiple departments; consolidated impact analysis
    - Communication: All department heads briefed on changes
    - Frequency: Rare; typically 0–2 per year

Budget change log:
  - Every change tracked with date, approver, amount, and reason
  - Monthly summary included in management reporting
  - Year-end analysis: total budget vs. original (identify planning accuracy)
  - Typical variance: 3–8% for well-run organizations; >15% indicates planning issues

Budget Accuracy Metrics

BUDGET ACCURACY TRACKING
=========================

Metric: Budget Accuracy Score
  Formula: 1 - (|Actual - Budget| / Budget) for each GL account
  Target: > 90% accuracy (|variance| < 10% of budget)
  Reporting: Monthly by department and category

  Scoring:
    Green (90–100%): Accurate; no action needed
    Yellow (80–89%): Monitor; review with department head
    Red (< 80%): Investigate; process improvement needed

  Common accuracy issues by category:
    Headcount salary:     95–98% (highly predictable)
    Travel:                75–85% (volatile; project-based)
    Professional services: 70–80% (hard to predict)
    Marketing:             80–90% (campaign timing affects timing)
    Software/subscriptions: 95–98% (contract-based)
    Recruiting:            65–80% (timing of hires unpredictable)

Rolling forecast accuracy:
  - Month 1 forecast accuracy: > 95% target
  - Month 3 forecast accuracy: > 85% target
  - Month 6 forecast accuracy: > 75% target
  - Year-end forecast accuracy: > 80% target

Planning quality metrics:
  - Budget cycle time: Target < 10 weeks
  - Department submission on-time rate: > 90%
  - Number of revision cycles: Target 2 (draft → revise → final)
  - Budget change requests mid-year: < 5% of total budget

Department-Specific Budgeting

Revenue Department Budgets

REVENUE BUDGET BUILD
=====================

Revenue = Pipeline × Conversion Rate × Average Deal Size

  Sales team budget components:
    - Headcount: AE, SDR, AM, Sales Ops (by territory/region)
    - Compensation: Base + commission (OTE = base + target commission)
    - Commission pool: Typically 15–30% of target revenue
    - Tools: CRM (Salesforce $12K/user/yr), dialer, email tools
    - Travel: Client meetings ($500–1,500 per trip, 2–4 trips/month per AE)
    - Enablement: Training, content, deal support

  Budgeting methodology:
    1. Revenue target set by leadership (top-down)
    2. Sales Ops builds capacity model: headcount × productivity × win rate
    3. Validate against historical performance and pipeline coverage
    4. Pipeline coverage target: 3–4x quarterly quota
    5. Revenue per rep: $500K–$2M (SMB), $2M–$10M (Enterprise)

  Key ratios:
    - Sales to revenue ratio: 15–30% of revenue
    - SDR to AE ratio: 2–4 SDRs per AE
    - Revenue per sales rep: benchmark by company and segment
    - Commission as % of revenue: 10–25%

G&A Budget Benchmarks

G&A SPEND BENCHMARKS BY COMPANY SIZE
======================================

General & Administrative as % of Revenue:

  Startup (<$5M revenue):         40–60% (heavy per-head fixed costs)
  SMB ($5M–$50M revenue):         20–35% (economies of scale kick in)
  Mid-Market ($50M–$500M):        12–25% (efficient operations)
  Enterprise ($500M+ revenue):     8–15% (significant economies of scale)

Per-head G&A cost:
  Startup:     $150K–$250K per FTE
  SMB:         $120K–$180K per FTE
  Mid-Market:  $100K–$150K per FTE
  Enterprise:   $80K–$120K per FTE

G&A breakdown (% of total G&A):
  Executive compensation:    20–35%
  Finance/Accounting:        15–25%
  Legal/Compliance:          10–15%
  HR/Admin:                  10–20%
  Office/Facilities:         5–10%
  Insurance:                 3–8%
  Professional services:     5–10%
  IT (if not in Opex):       5–10%

Edge Cases

Integration Points

Disclaimer: All rights reserved by Circulos AI. These skills are specifically designed for Claude Code, Claude Cowork, Codex, and OpenClaw. When using or referencing any skill, please provide proper attribution to Circulos AI.