The Bookkeeper's Budget Planner 2027 (Google Sheets & Excel)
Built by a working bookkeeper, for real households.
Type each purchase once on one simple log. The Dashboard, Monthly and Annual tabs fill themselves in, so you always know what came in, what went out, and what's left.
WHAT'S INSIDE (11 tabs)
- Start Here: a 10-minute setup guide plus bookkeeper's tips
- Setup: your own categories, monthly budgets and 50/30/20 targets
- Dashboard: income, spending, savings and charts, all automatic
- Transactions: one log for the whole year, with dropdown categories
- Monthly: budget vs actual for any month you pick. Over-budget lines turn red
- Annual: every category by month, with totals and averages
- Bills: due dates, autopay, and paid or not for each month
- Paycheck Split: a Profit First habit for households. Type a paycheck and see how much goes to savings, bills, spending, debt and giving
- Savings Goals: targets, dates, and what to save each month
- Debt Payoff: snowball or avalanche order, with estimated payoff dates
- Net Worth: a monthly snapshot with a growth chart
WHAT YOU GET
- The blank planner (.xlsx file)
- A filled-in example with a sample year, so you can see how everything works
Instant download right after purchase. Nothing ships.
WORKS IN
- Google Sheets (free): upload the file to Google Drive, open it, then choose File > Save as Google Sheets
- Microsoft Excel
Setup is easiest on a computer or tablet.
GOOD TO KNOW
- Set up for 2027. Change the year on the Setup tab to use it again next year.
- No subscriptions and no bank logins. Your numbers stay in your own file.
- For personal use. Please don't resell or share the file.
ABOUT THE MAKER
I'm Kevin, a bookkeeper at Scholarly Smith Bookkeeping. I designed this planner around the habits I use with clients: one clean log, categories that make sense, and savings first. It was built with help from AI tools and tested against a full sample year.