| A | B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||||
2 | GET STARTED | NOTE | |||||||||||
3 | Set your starting balance in cell L8, then customize your categories and planned spending amounts in the 'Income' and 'Expenses' tables below. | Only edit highlighted cells. Try not to alter cells that contain a formula. | |||||||||||
4 | |||||||||||||
5 | As you enter data in the 'Transactions' tab, this sheet will automatically update to show a summary of your spending for the month. | ||||||||||||
6 | |||||||||||||
7 | |||||||||||||
8 | Monthly Budget | Starting balance: | $8,407 | ||||||||||
9 | |||||||||||||
10 | |||||||||||||
11 | |||||||||||||
12 | |||||||||||||
13 | +18% | ||||||||||||
14 | Increase in total savings | ||||||||||||
15 | $1,500 | ||||||||||||
16 | START BALANCE | END BALANCE | Saved this month | ||||||||||
17 | $8,407 | $9,907 | |||||||||||
18 | |||||||||||||
19 | |||||||||||||
20 | Expenses | Income | |||||||||||
21 | Planned | $950 | Planned | $1,450 | |||||||||
22 | Actual | $0 | Actual | $1,500 | |||||||||
23 | |||||||||||||
24 | Expenses | Income | |||||||||||
25 | Planned | Actual | Diff. | Planned | Actual | Diff. | |||||||
26 | Totals | $950 | $0 | +$950 | Totals | $1,450 | $1,500 | +$50 | |||||
28 | Food | $0 | $0 | $0 | Savings | $0 | $0 | $0 | |||||
29 | Internet | $0 | $0 | $0 | Paycheck | $1,450 | $1,500 | +$50 | |||||
30 | Health/medical | $0 | $0 | $0 | Bonus | $0 | $0 | $0 | |||||
31 | Mortgage | $950 | $0 | +$950 | Interest | $0 | $0 | $0 | |||||
32 | Presto / TTC | $0 | $0 | $0 | Other | $0 | $0 | $0 | |||||
33 | Car Payment | $0 | $0 | $0 | Custom category | $0 | $0 | $0 | |||||
34 | Hydro | $0 | $0 | $0 | |||||||||
35 | Condo Fees | $0 | $0 | $0 | |||||||||
36 | Travel | $0 | $0 | $0 | |||||||||
37 | Taxes | $0 | $0 | $0 | |||||||||
38 | Debt | $0 | $0 | $0 | |||||||||
39 | Custom category 1 | $0 | $0 | $0 | |||||||||
40 | Custom category 2 | $0 | $0 | $0 | 647.567.2679 | CoryParsons.ca | ||||||||
41 | Custom category 3 | $0 | $0 | $0 | cparsons@mortgagegroup.com | ||||||||
42 | |||||||||||||
43 | |||||||||||||
44 | |||||||||||||