Start with a 12-month grid
Create a year view with rows for income, bills, savings, and debt. Put months across the top and fill in known numbers first. Example rows: Paycheck $5,000; Rent $1,800; Savings $400; Debt $250. This shows whether your current habits support your goals across the whole year.
Add a monthly execution view
The plan works only if you can execute it monthly. Add a budget tab that rolls up into the annual plan and highlights whether you are ahead or behind.
Tie goals to dates and contributions
Goals should have target dates and monthly contributions. This turns vague savings into a concrete plan with trade-offs you can see.
How Penny keeps the template alive
Penny syncs your accounts into the sheet and updates the plan automatically, so your annual view stays accurate as real transactions come in.