Budget versus actual finance dashboard

Management reporting model (teaching data) · 2025 · Reporting build

How quickly can management see where budget variance is coming from? I roll departments, chart-of-account mappings, actuals, budget, prior period, and prior year into variance views across G&A, R&D, customer support, and sales and marketing.

	B	C	D	F	G	H	I	J	L	M	O	P	Q	R	S	U	V	W	X	Y	AA	AB	AC	AD	AE	AG	AH	AI	AJ	AK	AM	AN	AP	AQ
1
2
3
4
5
6				Section	Expenses																					Section	Expenses						Departments	All
7											Section	(Multiple Items)				Section	Expenses				Section	Expenses
8																																	P&L	Actual
9	Revenue & Gross Margin	Revenue	Gross margin		Customer Support	General & Administrative	Research & Development	Sales & Marketing	Section	Expenses	BvA: Rev, GP, EBITDA	Budget	Actual	Var to Budget Income ($)	Var to Budget Income (%)	BvA: Opex By Dept	Budget	Actual	Var to Budget Expense ($)	Var to Budget Expense (%)	BvA: Opex By Cost Type	Budget	Actual	Var to Budget Expense ($)	Var to Budget Expense (%)		Customer Support	General & Administrative	Research & Development	Sales & Marketing	Section	Expenses	Income	801,118
10	Jan-24	112,146	87.3%	Jan-24	11,405	30,762	21,048	36,672			Revenue	806,240	801,118	(5,122)	-1%	Customer Support	151,804	82,873	68,931	83.2%	Advertising	245,241	130,261	114,980	88.3%	Jan-24	11,405	30,762	21,048	36,672			Cost of Goods Sold	141,454
11	Feb-24	115,511	81.3%	Feb-24	11,747	30,146	21,358	37,610			Gross Profit	782,846	659,664	(123,182)	-19%	General & Administrative	248,465	219,330	29,134	13.3%	Other G&A	292,884	212,909	79,975	37.6%	Feb-24	11,747	30,146	21,358	37,610			Gross Profit	659,664
12	Mar-24	112,045	85.2%	Mar-24	11,778	30,579	21,710	37,645	Customer Support	82,873	EBITDA	(159,366)	(54,486)	104,879	192%	Research & Development	184,162	154,098	30,064	19.5%	Payroll	327,740	264,464	63,276	23.9%	Mar-24	11,778	30,579	21,710	37,645	Customer Support	82,873	Expenses	714,150
13	Apr-24	115,407	75.1%	Apr-24	11,835	31,095	22,361	38,118	General & Administrative	219,330	Grand Total	1,429,721	1,406,295	(23,425)	-2%	Sales & Marketing	357,781	257,849	99,933	38.8%	Professional Fees	76,346	106,516	(30,170)	-28.3%	Apr-24	11,835	31,095	22,361	38,118	General & Administrative	219,330	Advertising	130,261
14	May-24	111,944	82.0%	May-24	12,190	32,278	22,723	36,197	Research & Development	154,098						Grand Total	942,212	714,150	228,062	31.9%	Grand Total	942,212	714,150	228,062	31.9%	May-24	12,190	32,278	22,723	36,197	Research & Development	154,098	Advertising & Marketing	80,712
15	Jun-24	115,303	79.9%	Jun-24	12,024	31,632	23,128	35,274	Sales & Marketing	257,849																Jun-24	12,024	31,632	23,128	35,274	Sales & Marketing	257,849	Conferences & Events	49,549
16	Jul-24	118,762	85.8%	Jul-24	11,895	32,839	21,770	36,332	Grand Total	714,150																Jul-24	11,895	32,839	21,770	36,332	Grand Total	714,150	Other G&A	212,909
17											Section	(Multiple Items)				Section	Expenses				Section	Expenses											Payroll	264,464
18																																	Professional Fees	106,516
19											AvPP: Rev, GP, EBITDA	Prior Period	Actual	Var to Prior Period ($)	Var to Prior Period (%)	AvPP: Opex By Dept	Prior Period	Actual	Var to Prior Period ($)	Var to Prior Period (%)	AvPP: Opex By Cost Type	Prior Period	Actual	Var to Prior Period ($)	Var to Prior Period (%)								EBITDA	(54,486)
20											Revenue	747,345	801,118	53,773	7.2%	Customer Support	74,263	82,873	8,611	11.6%	Advertising	146,367	130,261	(16,106)	-11.0%								Other Income	0
21											Gross Profit	623,631	659,664	36,033	5.8%	General & Administrative	191,875	219,330	27,455	14.3%	Other G&A	184,365	212,909	28,544	15.5%								Other Expenses	2,068
22											EBITDA	(60,245)	(54,486)	5,758	9.6%	Research & Development	144,060	154,098	10,039	7.0%	Payroll	255,694	264,464	8,770	3.4%								Interest Expense	74,437
23											Grand Total	1,310,731	1,406,295	95,564	7.3%	Sales & Marketing	273,679	257,849	(15,830)	-5.8%	Professional Fees	97,450	106,516	9,066	9.3%								Net Other Income	(76,505)
24				Section	Expenses				Section	Expenses						Grand Total	683,876	714,150	30,274	4.4%	Grand Total	683,876	714,150	30,274	4.4%	Section	Expenses				Section	Expenses	Net Income	(130,991)
25																																	Grand Total	2,130,909
26
27					Advertising	Other G&A	Payroll	Professional Fees	Advertising	130,261	Section	(Multiple Items)				Section	Expenses				Section	Expenses					Advertising	Other G&A	Payroll	Professional Fees	Advertising	130,261
28				Jan-24	19,432	29,529	36,265	14,661	Other G&A	212,909																Jan-24	19,432	29,529	36,265	14,661	Other G&A	212,909
29				Feb-24	19,953	29,350	37,045	14,514	Payroll	264,464	AvPY: Rev, GP, EBITDA	Prior Year	Actual	Var to Prior Year ($)	Var to Prior Year (%)	AvPY: Opex By Dept	Prior Year	Actual	Var to Prior Year ($)	Var to Prior Year (%)	AvPY: Opex By Cost Type	Prior Year	Actual	Var to Prior Year ($)	Var to Prior Year (%)	Feb-24	19,953	29,350	37,045	14,514	Payroll	264,464
30				Mar-24	19,835	29,408	37,530	14,939	Professional Fees	106,516	Revenue	714,351	801,118	86,767	12.1%	Customer Support	73,148	82,873	9,725	13.3%	Advertising	144,549	130,261	(14,288)	-9.9%	Mar-24	19,835	29,408	37,530	14,939	Professional Fees	106,516
31				Apr-24	19,787	30,154	38,092	15,375	Grand Total	714,150	Gross Profit	558,738	659,664	100,925	18.1%	General & Administrative	179,361	219,330	39,970	22.3%	Other G&A	170,316	212,909	42,594	25.0%	Apr-24	19,787	30,154	38,092	15,375	Grand Total	714,150
32				May-24	18,029	31,228	38,614	15,516			EBITDA	(111,344)	(54,486)	56,858	51.1%	Research & Development	134,084	154,098	20,014	14.9%	Payroll	263,572	264,464	892	0.3%	May-24	18,029	31,228	38,614	15,516
33				Jun-24	16,401	31,067	39,061	15,528			Grand Total	1,161,745	1,406,295	244,550	21.1%	Sales & Marketing	283,489	257,849	(25,640)	-9.0%	Professional Fees	91,646	106,516	14,870	16.2%	Jun-24	16,401	31,067	39,061	15,528
34				Jul-24	16,823	32,173	37,857	15,983								Grand Total	670,082	714,150	44,068	6.6%	Grand Total	670,082	714,150	44,068	6.6%	Jul-24	16,823	32,173	37,857	15,983
35											Budget	Revenue	Gross Profit	EBITDA
36											A (+)			100%
37											B (+)
38											A (-)	1%	19%
39											B (-)	99%	81%
40											text	1% miss	19% miss	100% hit
41
42											Prior Period	Revenue	Gross Profit	EBITDA
43											A (+)	7%	6%	10%
44											B (+)	93%	94%	90%
45											A (-)
46											B (-)
47											text	7% hit	6% hit	10% hit
48
49											Prior Year	Revenue	Gross Profit	EBITDA
50											A (+)	12%	18%	51%
51											B (+)	88%	82%	49%
52											A (-)
53											B (-)
54											text	12% hit	18% hit	51% hit
55
56											Metric	Revenue	Gross Profit	EBITDA
57											Variance (Budget)	(5,122)	(123,182)	104,879
58											Variance (Prior Period)	53,773	36,033	5,758
59											Variance (Prior Year)	86,767	100,925	56,858
60
61											Text	Revenue	Gross Profit	EBITDA
62											Variance (Budget)	Missed Budget	Missed Budget	Exceeded Budget
63											Variance (Prior Period)	Exceeded Budget	Exceeded Budget	Exceeded Budget
64											Variance (Prior Year)	Exceeded Budget	Exceeded Budget	Exceeded Budget