| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | * Go to "File" then select "Make a Copy" or "Download" to personalize this template! | ||||||||
2 | *Only edit the light tan colored cells | ||||||||
3 | Tips for use: | *Enter your "Starting Amount". This will be however much is in your account before you get paid. | |||||||
4 | *Choose the relevant type of income/expense on this tab. | ||||||||
5 | *Add your purchases on the "Transaction" tab. | ||||||||
6 | *This tab will update to reflect how much you have left to spend. | ||||||||
7 | *If a category is not in the drop down menu, add what you need under the "Labels" tab | ||||||||
8 | Starting Amount: | $0.00 | Total | Spent | |||||
9 | Amount Left: | $204.60 | $3,000.00 | $2,795.40 | |||||
10 | Monthly Overview | ||||||||
11 | Category | Planned | Actual | ||||||
12 | Income | $3,000.00 | $3,000.00 | ||||||
13 | Fixed Exp. | $1,825.00 | $1,825.00 | ||||||
14 | Variable Exp. | $825.00 | $970.40 | ||||||
15 | |||||||||
16 | Income | Planned | Actual | ||||||
17 | W2 | $3,000.00 | $3,000.00 | ||||||
18 | |||||||||
19 | |||||||||
20 | |||||||||
21 | |||||||||
22 | Fixed Exp. | Planned | Actual | ||||||
23 | Rent | $1,000.00 | $1,000.00 | ||||||
24 | Insurance | $150.00 | $150.00 | ||||||
25 | Electricity | $60.00 | $60.00 | ||||||
26 | Gas (heating) | $60.00 | $60.00 | ||||||
27 | Internet | $75.00 | $75.00 | ||||||
28 | Cell Phone | $50.00 | $50.00 | ||||||
29 | TV/Cable | $50.00 | $50.00 | ||||||
30 | Water/Trash | $30.00 | $30.00 | ||||||
31 | Investing | $250.00 | $250.00 | ||||||
32 | Saving | $100.00 | $100.00 | ||||||
33 | $0.00 | ||||||||
34 | $0.00 | ||||||||
35 | Variable Exp. | Planned | Actual | ||||||
36 | Groceries | $300.00 | $292.58 | ||||||
37 | Gas (car) | $100.00 | $83.77 | ||||||
38 | Car Upkeep | $25.00 | $34.99 | ||||||
39 | Grooming | $100.00 | $175.00 | ||||||
40 | Eating Out | $300.00 | $384.06 | ||||||
41 | $0.00 | ||||||||
42 | $0.00 | ||||||||
43 | $0.00 | ||||||||
44 | $0.00 | ||||||||
45 | $0.00 | ||||||||
46 | $0.00 | ||||||||
47 | $0.00 | ||||||||