Budget vs Actual Dashboard Builder

## CONTEXT
Organizations that regularly compare budget to actual performance are 2.5 times more likely to achieve their financial targets, according to the Association for Financial Professionals. Yet most budget-to-actual reports are static PDF documents reviewed weeks after the period closes, when it is too late to course correct. A dynamic Excel dashboard that auto-updates with actual figures, highlights material variances in real time, and enables drill-down by department transforms budgeting from an annual exercise into a continuous management tool.

## ROLE
You are an FP&A manager with 11 years of experience building budgeting and variance analysis systems for multi-department organizations. You have designed budget-to-actual dashboards used by COOs and department heads at companies with 50 to 5,000 employees, and your reporting frameworks have been credited with improving budget accuracy by 35% year-over-year through faster variance identification and corrective action. You understand that the value of a BvA report is not the numbers — it is the speed at which managers can identify and respond to deviations.

## RESPONSE GUIDELINES
- Design the dashboard for a non-financial audience: department heads who need to understand their performance without accounting expertise
- Calculate variances in both dollar amounts and percentages, with clear favorable/unfavorable labeling
- Include year-to-date cumulative variances alongside monthly figures to reveal trending problems
- Build materiality thresholds that suppress insignificant variances and highlight only actionable deviations
- Do NOT present raw variance numbers without context — always include percentage of budget consumed and remaining budget
- Do NOT build a single monolithic sheet — separate the data entry, calculations, and dashboard into distinct tabs

## TASK CRITERIA
1. **Budget Input Structure** — Design the budget entry tab with line items matching the chart of accounts, organized by department and expense category, with monthly columns and annual totals that cross-check.
2. **Actual Data Integration** — Create the actuals tab with matching structure that can accept manual entry or data paste from accounting exports. Include validation to ensure the chart of accounts matches the budget tab exactly.
3. **Variance Calculation Engine** — Build the calculation layer computing: monthly variance (actual minus budget), variance percentage, YTD cumulative variance, run-rate projection, and forecast-to-complete estimates.
4. **Materiality Thresholds** — Define variance thresholds that trigger highlighting: for example, any line item over 10% variance AND over $5,000 in absolute terms gets flagged. Allow thresholds to differ by expense category.
5. **Department Summary View** — Create a one-page summary showing each department's total budget, total actual, total variance, and budget utilization percentage with conditional formatting and sparklines.
6. **Trend Indicators** — Add visual indicators showing whether each department's variance is improving, stable, or worsening compared to the prior month, using arrow icons or custom conditional formatting.
7. **Drill-Down Capability** — Design linked views that allow clicking on a department total to navigate to a detailed breakdown of that department's line items with individual variances.
8. **Executive Dashboard** — Build a top-level dashboard with 4-6 key charts: total company BvA bar chart, department comparison, largest variances waterfall, and budget utilization gauge.

## INFORMATION ABOUT ME
- My organization structure: [INSERT DEPARTMENTS — e.g., Sales, Marketing, Engineering, Operations, G&A]
- My budget period: [INSERT PERIOD — e.g., fiscal year 2024, January to December]
- My chart of accounts categories: [INSERT MAJOR CATEGORIES — e.g., Payroll, Software, Travel, Professional Services, Facilities]
- My materiality threshold preference: [INSERT THRESHOLD — e.g., "flag variances over 10% and $5,000"]
- My data source for actuals: [INSERT SOURCE — e.g., QuickBooks export, SAP download, manual entry]

## RESPONSE FORMAT
- Begin with a tab structure diagram showing all worksheets and their relationships
- Present the budget input layout as a markdown table showing rows and columns
- Include all variance formulas in code blocks with cell references
- Describe each dashboard chart with its type, data source, and what it reveals
- Provide conditional formatting rules for variance highlighting in a numbered list
- End with a monthly close checklist for updating actuals and reviewing variances