Monthly variance analysis
FY 2024
Jan–Jun ▾
Input 01
Budget.csv
6 cost centres · 6 months
Loaded — 24 rows
Input 02
Actuals.csv
6 cost centres · 6 months
Loaded — 24 rows
Context (optional)
Business notes
Total budget YTD
£1.42m
Jan–Jun 2024
Total actuals YTD
£1.49m
↑ +£68,500 vs budget
Overall variance
+4.8%
Favourable
Material exceptions
5
Items flagged
Variance summary by cost centre
Generate AI commentary
Cost centreCategoryBudget YTDActual YTDVariance £Variance %Status
SalesRevenue£980,000£1,057,000+£77,000+7.9%▲ Material
SalesSalaries£273,000£251,160+£21,840+8.0%▲ Material
MarketingAdvertising£57,500£71,200−£13,700−23.8%▼ Material
OperationsOverhead£75,000£79,500−£4,500−6.0%▼ Material
HRRecruitment£24,000£18,400+£5,600+23.3%▲ Material
FinanceSoftware£12,000£11,640+£360+3.0%On budget
ITInfrastructure£36,000£34,200+£1,800+5.0%On budget
Management commentary
GPT-4o
Auto-generated board pack narrative
Click "Generate AI commentary" above to produce a professional variance narrative.
AI trend insight
Sales Revenue has shown consistent positive variance for 5 of 6 months, accelerating from +2.1% in January to +12.4% in June — indicating a structural outperformance, not a one-off. Marketing Advertising overspend peaked in April (−38%) at campaign launch and is recovering, suggesting H2 normalisation is likely. Operations Overhead has trended adversely for 3 consecutive months — flag for August reforecast.
Monthly variance % — rolling 6 months
Positive = favourable · Negative = adverse
Budget vs actuals — absolute values
Grouped by month for selected cost centre
Select a month to analyse