[NAME] Holistic Financial Plan - TEMPLATE

	A	B
1		Holistic Financial Plan Spreadsheet Learn how to use this tool by registering for the Teachable Course by Triple Creeks Consulting This spreadsheet has been adapted by permission from HMI by Triple Creeks Consulting. Holistic Management is a registered trademark of HMI. For more information, please visit their website.
2	DOCUMENT CONTAINS:
3	Instructions (First Tab)	After you get familiar with the instructions of how to update & maintain this document, you can likely delete this tab.
4	Annual Income Expense Plan Template (Second Tab)	Please DUPLICATE this template tab and rename with the calendar year you are tracking. This way, you have an original copy of this in case an error occurs in the calculation formulas, or you want to start over in following years. You can also rename this master GoogleDoc with your name or your business/organization name, for easy access and searching. BONUS TIP: Anywhere where you find brackets [] and CAPITAL LETTERS is intended to be customized for your purposes.
5	ANNUAL INCOME EXPENSE ROW & COLUMN WRITTEN DESCRIPTIONS:
6	Row 1	Enter categories for income and expenses in row 1 (Income Category Examples: Job X Income, Job Y Income, Etsy Sales, Other, etc. Expense Category Examples: Rent, Utilities, Auto Maintenance & Fees, Gas, Groceries, Restaurants, etc.) BONUS TIP: Eventually, you should add your Savings Account(s) as "Expenses" to plan to move money into those accounts. You should also add any expenses that you would like to plan for within the next 12 months, even if the 'Plan' and 'Actual' lines are $0.00, for a certain portion of the year. If you have taxble (1099) income that you will be paying out-of-pocket at the end of the year, you should always have a Savings Account for money that is earmarked for the IRS.
7	Row 2	Enter the calendar year OR tracking period (12 months) in Row 2, Column A. Enter in Expense category "descriptions" for expenses as useful. BONUS TIP FOR INCOME DESCRIPTIONS: Note in Row 2 whether or not this is 1099 or W-2 Income, to be able to easily calculate the amount you should be saving each month for your taxes. BONUS TIP FOR EXPENSE DESCRIPTIONS: You can note here whether these are actually Expenses OR Savings Accounts, and what bank account they are earmarked to come out of or be put into.
8	Insert Here Columns	If you need additional income or expense columns, select the entire "Insert New Income/Expense Columns Here" column and choose "Insert." Then, copy a complete income or expense column and paste it into the blank space, or drag and drop it, if you're using Google Sheets. This will copy over the formulas that calculate difference and cumulative difference to date.
9	Column A	Name the months of the planning year in column A. You can start in any month, but this plan will be for a full calendar year. Tip: No rows should ever be added to the spreadsheet. As opposed to 'growing' vertically, like a regular budget, this plan will grow horizontally.
10	Teal "Plan" Rows	Insert PLANNED income and expenses from your worksheet(s) on the teal "plan" rows. BONUS TIP: If you take time to enter your 'Actuals' from prior years before you 'Plan' lines, you can come up with a much more realistic plan!
11	Gold "Actual" Rows	Enter ACTUAL income and expenses into the gold "actual" rows (this is ideally done at the minimum 1x/month, ideally 1x/week). You can do this using a formula with individual transactions or by entering totals from another budget app you may use. BONUS TIP: Categorize your Income & Expenses in your bank/other budgeting app in the same way as you categorize them in your Holistic Financial Plan for easy transferring of totals at the end of the month.
12	Blue "Difference" Rows	Blue rows (Difference and Cumulative Difference to Date) will calculate automatically.
13	Summary Rows	Summary rows (Plan Total, Actual Total, Difference and Percent Different) will calculate automatically.
14	Summary Columns	Summary columns (Total Income, Total Expense, Net Surplus/Defecit) will calculate automatically.
15	Positive/Negative #'s	Negative numbers are shown in red and inside parenthesis. Postive numbers are shown in black without parenthesis.
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