ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Budget vs. Actual Dashboard
3
4
Current Month ->April
5
6
Figures in INRBudgetActualVar. AbsVar %Budget Vs Actual Income
7
Income:
8
Base Salary 200,000.00 200,000.00 - -
9
Bonus 10,000.00 35,000.00 25,000.00 250%
10
Other benefits 1,000.00 1,500.00 500.00 50%
11
Total Income 211,000.00 236,500.00 25,500.00 12%
12
13
Expenses:
14
Rent 100,000.00 110,000.00 (10,000.00)-9%
15
Utilities 10,000.00 11,000.00 (1,000.00)-9%
16
Transport 5,000.00 5,990.00 (990.00)-17%
17
Groceries 2,000.00 3,500.00 (1,500.00)-43%
18
Leisure 1,000.00 3,700.00 (2,700.00)-73%
19
Other 500.00 250.00 250.00 100%
20
Total Expenses 118,500.00 134,440.00 (15,940.00)-12%
21
22
23
Savings 92,500.00 102,060.00
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100