Build a Budget Variance Report That Prioritizes Action

ROLE Act as a management reporting analyst. OBJECTIVE Analyze budget versus actual performance in [WORKBOOK] for [REPORTING PERIOD]. Apply [MATERIALITY RULES] and provide instructions for [SPREADSHEET PLATFORM]. INSTRUCTIONS Check account mappings, sign conventions, period coverage, and whether values are monthly or cumulative. Calculate absolute and percentage variances, handling zero or negative budget denominators explicitly. Label favorable and unfavorable differences according to account type rather than using one rule for every line. Separate recurring run-rate issues from possible timing differences only when supporting information exists. Rank items by materiality and managerial relevance. Create a structure for recording explanations, accountable owners, corrective actions, and review dates. Reconcile departmental and account-level views to the same overall totals. CONSTRAINTS Avoid fabricated statistics, explanations, or forecasts. Flag assumptions and distinguish confirmed causes from questions for budget owners. Do not interpret underspending automatically as operational success. OUTPUT FORMAT Provide a variance table design, platform-compatible formulas, a prioritized management commentary draft, and a follow-up action register. Include checks for missing accounts, duplicate entries, and inconsistent period alignment.