Cash flow is related to budgeting, but answers a different question. A budget tells you how much you planned to spend in each category versus how much you actually spent. Cash flow tells you when money is coming in and going out — and whether you’ll have enough at any given time to cover what’s due.
If you have predictable income and bills, you may not think about them much, if at all. But if you have variable income, periodic expenses (annual insurance premiums, quarterly taxes), irregular pay cycles, or multiple income streams, cash flow tracking becomes essential. Running short in week two of the month, even though the monthly budget looks fine, is a cash flow problem, not a budgeting problem.
The templates in this guide range from simple monthly trackers to forward-looking projection models. The right choice depends on how predictable your income is, how often you check your finances, and whether you want to see what’s already happened or model what’s coming next.
Cash flow vs. budgeting — what’s the difference?
Understanding the distinction helps you decide which type of template you need.
A budget answers the question: “How much did I spend on Groceries in March compared to my $400 limit?”
Cash flow answers: “On March 14th, after my car insurance payment clears but before my paycheck arrives, what’s my checking account balance?”
The difference is timing and granularity. Budgeting works in monthly totals by category. Cash flow works in daily or weekly movement of actual money through specific accounts.
Most people need both. A monthly budget gives you a clear picture of where your money is going. A cash flow view gives you the timing picture — whether you’ll have enough at every point in the cycle to cover your obligations without overdrafts or stress.
Cash flow tracking is especially important if:
- You’re paid irregularly or on a project basis.
- You have large periodic expenses (annual subscriptions, quarterly tax payments, semi-annual insurance premiums).
- You regularly feel cash-poor mid-month, even when your monthly budget looks balanced.
- You manage multiple income streams with different payment schedules.
- You’re trying to coordinate bill due dates with paycheck timing.
Monthly cash flow templates
A monthly cash flow template shows all money in and all money out for a calendar month, with a running balance that reflects your checking account position throughout.
The basic monthly cash flow structure looks like this:
| Date | Description | In | Out | Running Balance |
| 1/1 | Starting balance | $1,847 | ||
| 1/3 | Electric bill | $127 | $1,720 | |
| 1/5 | Paycheck | $2,800 | $4,520 | |
| 1/8 | Rent | $1,400 | $3,120 |
The running balance column is the most valuable part — it shows you the lowest point your balance will reach during the month and flags potential shortfalls before they happen.
Some of the best free monthly cash flow templates are:
- Google Sheets’ and Excel’s built-in budget templates include basic income/expense tracking.
- Vertex42 offers a personal monthly cash flow statement template.
- Tiller’s Foundation Template generates a cash flow view automatically from daily transaction data — no manual entry required.
Weekly cash flow templates
Weekly cash flow tracking works well if you’re paid weekly or bi-weekly and want tighter visibility than a monthly view provides. The structure is similar to monthly but compressed into seven-day windows.
A weekly cash flow template typically shows:
- Opening balance for the week.
- Income expected this week (paycheck, freelance payments, other).
- Bills and payments due this week.
- Discretionary spending estimate for the week.
- Projected closing balance.
Weekly templates are particularly useful for people who’ve had overdraft issues or consistently feel cash-tight at certain points in their pay cycle. Seeing a week-by-week projection makes timing mismatches visible before they become problems.
Cash flow projection templates
A cash flow projection looks forward rather than backward — it models the next 4–12 weeks based on expected income and known upcoming expenses.
Projections are useful because you can:
- See potential cash shortfalls 2–4 weeks before they happen.
- Plan the timing of large discretionary purchases.
- Model the impact of an irregular payment (annual insurance, quarterly taxes).
- Understand which months will be tight vs. flush based on known income patterns.
To build a projection in Google Sheets, set up a table with dates across the top (one column per week or month) and income/expense rows down the side. Pre-populate known recurring amounts — regular paycheck, rent, subscriptions, regular bills. Leave rows for variable income and discretionary spending as estimates.
| Transactions | Week of May 1 | Week of May 8 | Week of May 15 | Week of May 22 | Week of May 29 |
| Paycheck | $2,500 | $2,500 | |||
| Rent | $3,300 | ||||
| Netflix | $25 | ||||
| Electricity | $200 | ||||
| Misc. Spending | $100 | $100 | $100 | $100 | $100 |
| Misc. Income | $500 | $1,000 | |||
| Running Balance (Beginning balance: $1,000) | $3,700 | $300 | $2,700 | $3,575 | $3,475 |
The bottom row — running balance — shows your projected account position at each future point. Format cells red when the balance drops below a safety threshold (say, $500) to flag at-risk periods immediately.
A projection differs from a budget in one major way: a projection uses expected future amounts, not past actuals. It’s a planning tool, not a reporting tool.
Cash flow templates for variable income
Standard budget templates assume a predictable monthly income. For freelancers, contractors, gig workers, and anyone with irregular income, a different approach is needed.
The core challenge: Your expenses are fixed and regular. Your income is neither.
A variable income cash flow template should include:
- Conservative income baseline — what you can count on in a slow month.
- Income buffer tracking — how much above baseline you’ve earned recently.
- Expense coverage weeks — how many weeks your current balance covers at the typical spending.
- Upcoming large expenses — a forward view of known irregular costs.
| Month | Income | Fixed Expenses | Variable Expenses | Net Cash Flow |
| January | $4,000 | $3,500 | $200 | $300 |
| February | $7,500 | $3,500 | $400 | $3,600 |
| March | $4,000 | $3,500 | $100 | $400 |
| April | $6,000 | $3,500 | $500 | $2,000 |
The “floor and buffer” approach works well in spreadsheets. You set a baseline income amount that models a slow month. Then, you budget for that floor. When income exceeds the floor, you track the excess as a buffer that smooths future slow months. The cash flow template shows the buffer growing and shrinking rather than directly budgeting variable income.
Automated cash flow tracking with Tiller
Manual cash flow templates require you to enter every transaction and update the running balance yourself. For a simple projection, this is manageable. For ongoing daily tracking across multiple accounts, manual entry creates enough friction that most people stop tracking.
Tiller’s automated bank feed delivers daily transactions from all connected accounts to your Google Sheets or Excel spreadsheet. Your actual cash position across checking, savings, and credit cards is always up to date, with no manual entry required.
Combined with Tiller’s transaction data, you can build a cash flow view that:
- Pulls actual daily account balances from the Balance History sheet.
- Shows real money movement from the Transactions sheet.
- Distinguishes income vs. expense flows automatically using AutoCat categories.
- Updates every morning so the picture always reflects yesterday’s activity.
The Tiller Community has built two templates specifically for cash flow and weekly spending tracking:
The Weekly Spending by Category Report shows how much you’ve spent in each category over a customizable number of weeks, compared to your weekly average — with color-coded indicators for weeks you came in over or under. It’s best for Tiller users who want a quick weekly spending check-in by category.
The Cash Flow Forecast Template builds a forward-looking cash flow projection from your automated transaction data. It’s best for Tiller users who want to model their upcoming cash position without having to build the projection table from scratch.
Both are free for Tiller subscribers and can be installed through the Community Solutions add-on.
Frequently asked questions
Q: What is a cash flow spreadsheet template?
A cash flow spreadsheet template tracks the timing of money moving in and out of your accounts. This includes when income arrives, when bills are due, and what your balance looks like at any given point in time. Unlike a budget template (which compares planned vs. actual spending by category), a cash flow template focuses on timing: will you have enough money on the 15th to cover rent when it’s actually due?
Q: How is cash flow different from a budget?
A budget tracks spending by category over a set time period. Cash flow tracks money in vs. money out at specific points during the month. A budget answers “Where did my money go?” Cash flow answers “Will I have enough money on Thursday to cover this bill?” Most people who track their money use both because they each answer useful questions.
Q: What should a personal cash flow template include?
At a minimum, cash flow templates should include a date column, a description, money in (income), money out (expenses), and a running balance showing your account position after each transaction. Other useful additions include a starting balance for the period, a forward-looking projection section for known upcoming expenses, color-coding when the balance drops below a safety threshold, and a summary showing net cash flow for the period (total in minus total out).
Q: How do I track cash flow in Google Sheets or Excel automatically?
Connect your bank accounts to Google Sheets or Excel using Tiller. Tiller automatically delivers daily transaction data and account balances from all connected accounts — your cash position is always up to date without manual entry. You can then build a cash flow view using the transaction data and Balance History sheet that Tiller maintains. Community templates for cash flow tracking are available through Tiller’s Community Solutions library.
Q: How should I handle variable income in a cash flow spreadsheet?
Use a conservative income baseline — what you earn in a slow month — as your planning number. Track income above that baseline as a buffer. Your cash flow template shows the buffer growing in good months and being drawn down in slow ones. This approach avoids the planning errors that come from budgeting to your best month’s income and then running short when reality falls short of optimism.
Q: What’s the difference between a cash flow projection and a cash flow tracker?
A cash flow tracker records what actually happened with your transactions and balances in the past. A cash flow projection looks ahead, modeling expected future income and known expenses to show your projected balance on future dates. Trackers help you understand your financial history. Projections help you anticipate problems before they happen. The most useful cash flow templates include both a backward-looking tracker and a forward-looking projection.
