prompt-pack-legal-budget-forecast

Category: Design Risk: Low risk ★ 3.9 · Rating 3.9/5 (8) sboghossian/mini-claude-for-legal MIT

Rating is derived from the repo's GitHub stars and shown for reference.

automation_control

name: prompt-pack-legal-budget-forecast
description: Use when a legal department or law firm needs to build a quarterly or annual legal budget forecast. Produces a template with categories for external counsel fees, litigation costs, compliance, technology, staffing, and contingency, with variance tracking and year-over-year comparison columns. Applicable to in-house legal teams managing budgets across MENA, EU, and global operations.
license: MIT
metadata:
id: prompt-pack.legal-budget-forecast
category: prompt-pack
practice_area: legal-ops-billing
priority: P2
intent: [operations, legal-budget-forecast]
related:
- prompt-pack-matter-budget-template
- prompt-pack-legal-department-kpi-dashboard
- prompt-pack-legal-department-annual-report
- prompt-pack-outside-counsel-guidelines
- prompt-pack-legal-invoice-review-checklist
source: Louis — HAQQ Legal AI (github.com/sboghossian/mini-claude-for-legal)
version: "1.0"

Legal Budget Forecast

When to use this

Use this skill when a General Counsel, Chief Legal Officer, or legal operations manager needs to build or update a budget forecast for the legal function. The output is a structured template that can be populated in Excel, Google Sheets, or a matter management system.

Triggers:

  • Annual planning cycle: "Build a legal budget for next fiscal year."
  • Quarterly reforecast: "Update the Q3 legal forecast with actuals from Q1–Q2."
  • Board/CFO reporting: "Summarize the legal department's expected spend for the year."
  • New department setup: "We're building an in-house legal team from scratch — what should we budget for?"

Required inputs

Input Why it matters Default if omitted
Department or firm name Personalizes the template "Legal Department"
Fiscal year / period covered Scopes the forecast (quarterly breakdown required for variance tracking) Current year
Forecast period Quarterly or monthly breakdown Quarterly
Prior-year actuals (if available) Enables year-over-year comparison Marked as "N/A – first year"
Headcount Drives staffing cost category Ask user
Known major matters / litigation Enables realistic litigation reserve Ask user

Optional inputs

  • Currency (USD, EUR, AED, SAR, LBP, EGP) — important for MENA multi-currency departments
  • E-billing system in use (e.g., eBillingHub, Mitratech, Legal Tracker) — affects line-item granularity
  • Whether to include a contingency / reserve line
  • Approval workflow (who approves budget reforecasts)

Budget template structure

Section 1: External Counsel Fees

Sub-category Q1 Budget Q1 Actual Q1 Variance Q2–Q4 (repeat) FY Total Prior-Year Actual YoY % Change
Transactions (M&A, JV, commercial)
Litigation and arbitration
Regulatory / compliance
Employment
IP / patents / trade marks
Real estate
Other (specify)

Section 2: Litigation Reserves and Contingencies

Matter Estimated exposure Probability Expected value Status
[Matter 1]
Unallocated reserve

Section 3: Compliance Expenditure

  • Regulatory filings and license fees
  • Compliance training programs
  • Regulatory change management (outside counsel or consultant fees)
  • Audit / inspection support
  • Matter management system (annual licence)
  • Contract lifecycle management (CLM)
  • E-billing platform
  • Legal research subscriptions (Lexis, Westlaw, regional databases)
  • Document management / e-discovery tools
  • AI legal tools
Role Headcount Salary + benefits Q1–Q4 allocation
General Counsel
Senior Counsel
Counsel
Paralegal / Legal Ops
Legal Secretary / Support

Section 6: Other Operating Costs

  • Training and professional development (CLE, bar memberships)
  • Travel and entertainment (client/court appearances)
  • Office / facilities allocation
  • Insurance (professional indemnity, D&O contribution)

Section 7: Contingency Reserve

  • Recommended: 5–15% of total external counsel budget to cover unanticipated matters
  • Document assumptions and release process

Section 8: Summary Dashboard

Category FY Budget FY Forecast FY Actual (as incurred) Variance Variance %
External Counsel
Litigation Reserve
Compliance
Technology
Staffing
Other
Contingency
Total

Operational guidance

Variance tracking: Flag any line item where actual exceeds budget by more than 10% or USD 50,000 (adjust threshold by department size) — these require a brief written explanation to the CFO.

Matter-level forecasting: For significant litigation or transactions, link each matter to a matter budget (see [[prompt-pack-matter-budget-template]]) so that the aggregate external counsel line item is built up from per-matter estimates.

Quarterly reforecasting: At the end of each quarter, update the forecast with actuals and revise forward-looking periods based on changed assumptions. Document changes to assumptions.

MENA-specific considerations:

  • Multi-currency departments (e.g., LBP-denominated costs vs USD-billed external counsel) require currency translation and FX risk disclosure.
  • KSA and UAE government-linked entities may require budget approval at board level before incurring external counsel fees above defined thresholds.
  • Lebanon-based entities should build in an escalation buffer given economic volatility.

Common mistakes

  • Not separating litigation reserves from recurring external counsel budgets: Contingent liabilities inflate the recurring forecast and make year-over-year comparison meaningless.
  • Ignoring technology costs: Legal tech spend has grown substantially; failing to budget for CLM/AI tools leads to mid-year overruns.
  • Under-budgeting compliance in regulated sectors: FinTech, banking, healthcare, and energy companies face increasing regulatory filing burdens; compliance spend should be estimated per known regulatory calendar.
  • No approval workflow: Budgets without sign-off from CFO or board create governance issues — include the approval chain in the template.
  • [[prompt-pack-matter-budget-template]]
  • [[prompt-pack-legal-department-kpi-dashboard]]
  • [[prompt-pack-legal-department-annual-report]]
  • [[prompt-pack-outside-counsel-guidelines]]
  • [[prompt-pack-legal-invoice-review-checklist]]