ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
About this Template
2
3
4
Use this business expense budget workbook to track planned and
actual expenses and variances.
5
Fill in company name and add logo.
6
Enter details in tables in planned expenses
worksheet and actual expenses worksheet.
7
Tables are auto updated in expense variances worksheet and charts in
expense analysis worksheet
8
HOW TO USE THIS TEMPLATE
9
Input data in the white cells on the PLANNED EXPENSES and
ACTUAL EXPENSES worksheets, and the EXPENSE VARIANCES and
EXPENSE ANALYSIS will be calculated for you. If you add a row on
one sheet, the other sheets need to match.
10
Note
11
Additional instructions have been provided in column A in each
worksheet. To learn more about tables, press SHIFT and then F10
within a table, select the TABLE option, and then select
ALTERNATIVE TEXT.
12
13
14
15
16
17
18
19
20
21
22
23
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