Budget Spreadsheet Excel Template | Paycheck Planner, Bill Tracker & 12-Month Cash Flow Forecast (16 Tabs)
See your bank balance for every day of the next 12 months, and know before you buy whether you can afford it.
Money Flow Planner is an all-in-one Excel budget spreadsheet with 16 tabs. Type your pay, bills and categories once, log what you spend, and it shows where every paycheck goes, which bills are coming, how your savings goals are doing and what your balance will be on any day of your plan year. Use it on your laptop and in the free Excel app on your phone.
WHAT'S INSIDE (16 TABS)
• Start Here: setup steps, a live progress checklist and links to every tab
• Setup: pay (weekly, biweekly, 4-weekly, twice monthly or monthly), balance, categories, currency and date style
• Bills: every regular bill with its next due date
• Sinking Funds: yearly bills turned into a monthly set-aside amount
• Budget: planned vs actual for any month, with red over-budget bars
• Transactions: your spending log, with warnings for typos
• Bank Import: paste your bank export and it sorts itself into categories
• Paycheck Planner: what's left from every paycheck
• Forecast: your balance every day for 12 months, plus 'Can I afford it?'
• Dashboard: your month at a glance with charts
• Year Overview: every category, every month
• Monthly Report: one printable page for any month
• Goals and Challenges: savings goals, 52-week, no-spend and 100-envelope challenges
• Debt Payoff and Net Worth
MADE FOR REAL LIFE
• Works on laptop and phone (Microsoft Excel app, free on phones)
• Pick your currency: $, £, €, A$, C$, NZ$, ₹, R or none, and your date style, in one dropdown
• Blank copy plus a copy with example data, so you can learn first or start fresh
• Formulas are locked so nothing breaks; mistakes are flagged in pink with a plain-English fix
• One-time purchase. No subscription, no app, no bank login. Your data stays in your file.
REQUIREMENTS
Microsoft Excel 2010 or later (Windows or Mac), Microsoft 365, the free Excel for the web, or the Excel app on iPhone, iPad and Android. Not designed for Google Sheets or Apple Numbers.
YOU'LL RECEIVE
Money-Flow-Planner (example data) and Money-Flow-Planner-Blank as .xlsx files, plus the Setup Guide PDF. US and NZ versions included. Instant download.
Not sure yet? Try Money Flow Lite, the $2 budget and bill tracker: Link