Weekly Variance

Weekly Variance Report

When to Use

When you have expense, revenue, or budget data and need to identify what's on track, what's over, and what needs attention.

Instructions

1. Read all files in the working folder relevant to variance analysis (look for files named with: budget, actual, expense, revenue, Q1/Q2/Q3/Q4)
2. Identify all line items and their budget vs. actual figures
3. Calculate variance (Actual - Budget) and variance % ((Actual - Budget) / Budget × 100)
4. Flag any item where variance % exceeds ±10%
5. Sort flagged items by absolute variance descending
6. Produce the output table below

Output Format

Weekly Variance Report — [Period]

Generated: [date]

Summary