Jamie is a dental assistant paid every other Friday. Her rent is due on the 1st, a credit card on the 15th, her utilities slide around, and her car insurance auto-drafts the Monday after payday. She searched for a personal cash flow forecast template excel free because she keeps going negative mid-month, even though the monthly math looks fine.

Here's June. Her $1,100 rent leaves on Saturday 6/1, and her next paycheck doesn't land until Friday 6/7. Over the whole month, she's ahead. June works on paper, but her Friday paycheck and Monday insurance draft sit so close together that a late deposit leaves no room. In July, that's exactly where it breaks.

We're a small team that builds cash flow tools because month-based budgets failed us the same way. This is for situations like Jamie's, where timing matters more than totals.

What a cash flow spreadsheet does in plain English

So what is a cash flow spreadsheet? It's a list of money in and money out, sorted by date, that shows your bank balance on every day ahead. A monthly budget tells you whether June adds up. A forecast tells you whether Tuesday does.

You start with an opening balance, then add inflows (paychecks) and subtract outflows (rent, bills, groceries). The difference over a stretch of time is your net cash flow, and what's left at the end is your ending balance.

The cash flow spreadsheet formula is one line:

Beginning balance + cash received - cash paid = ending balance

In Excel, you run that formula on every row, so each row's ending balance becomes the next row's beginning. This isn't an accounting report. It doesn't track net worth or categories. It answers one question: will there be enough in the account on that date?

That's the hole Jamie keeps falling into. When the timing of money in and money out is off, you can run short even when your income and expenses work over a longer period, according to a 2025 guide from the Consumer Financial Protection Bureau. For Jamie, a Friday deposit and a Monday auto-draft sit three days apart, so if the deposit is late, the draft hits first.

Download the simple personal cash flow forecast template excel free

No email gate. The download has five columns. If you'd rather build it yourself, it takes about five minutes in a blank Excel workbook.

Set up row 1 as headers:

• Column A: Date
• Column B: Description
• Column C: In
• Column D: Out
• Column E: Running Balance

Row 2 holds your opening balance. Put the date in A2, "Opening balance" in B2, and the amount in E2. Then click E3, type `=E2+C3-D3`, and copy it down the column. That's the formula above, working on every row.

To group by week, add a label row like "Week of 6/3" in the Description column with nothing in In or Out. The balance carries straight through it. If you add an item later, insert a row in date order and copy the formula into it.

Set up your starting point: date, account, and opening balance

Pick one account, the one where your bills actually come out. For Jamie, that's checking, not savings. A forecast of the wrong account looks great right up until the rent payment fails.

Pick a start date. Today is fine. A Monday makes the weeks line up neatly.

Then enter what's actually available right now, after pending charges. Here's the first row of Jamie's sheet:

• Date: Monday 6/3
• Description: Opening balance, Checking
• Running Balance: 540.00

The whole sheet rests on this one number. If it's off by $40, every row below it is off by $40 too.

Add paychecks on the exact dates you're paid

Start with income, on the day it lands. Not the month. The day.

Jamie is paid every other Friday, so in June that's 6/7 and 6/21. She enters her net pay, the amount that hits checking after taxes, insurance and retirement come out. Gross pay is a nice number that never visits her account.

• 6/7, Paycheck, In 1,180
• 6/21, Paycheck, In 1,180

Irregular money gets its own row. Say Jamie covers a shift at another office and they'll pay her $220 on Wednesday 6/12. We'd write "Extra shift, expected 220" in Description and leave the In column blank until the money actually arrives. A forecast built on maybe-money is a wish with formulas.

Add recurring bills on their true due dates, not as monthly totals

Give each bill its own row, on its own date. A single "bills" line hides exactly the timing you're trying to see.

Jamie's June outflows:

• 6/1, Rent, Out 1,100 (paid before her 6/3 start, so it's already in the opening balance)
• 6/9, 6/16, 6/23, 6/30, Groceries (Sundays), Out 120 each
• Monday 6/10, Car insurance auto-draft, Out 95
• 6/15, Credit card minimum, Out 150
• 6/18, Electric (estimate), Out 85
• 6/25, Phone, Out 60

Watch the Monday auto-draft. Jamie's insurance comes out the Monday after payday, which works fine when the paycheck shows up on time. If payday slips, Monday is the first day that can go wrong.

For the credit card, enter the minimum on the due date. If you plan to pay more, add that as its own row on the day you'll actually pay it.

Utilities that move around get last month's amount as an estimate, marked "est." We can't tell you what your electric bill will be. Neither can the electric company until it reads the meter. Know when prescheduled electronic transfers, including rent and utility payments, will be paid and how much they'll be. That's the 2025 advice from the Consumer Financial Protection Bureau, and your sheet is where that knowledge lives.

See your week-by-week projected balance and find the red days

With paychecks and bills in place, the Running Balance column tells the story. Here's Jamie's first three weeks:

• 6/3, start: 540
• 6/7, paycheck +1,180: 1,720
• 6/9, groceries -120: 1,600
• 6/10, insurance -95: 1,505
• 6/15, credit card -150: 1,355
• 6/16, groceries -120: 1,235
• 6/18, electric -85: 1,150
• 6/21, paycheck +1,180: 2,330

Scan for the lowest number between paychecks. For Jamie, it's 540 from 6/3 through 6/6, before the 6/7 paycheck, and 1,150 from 6/18 through 6/20, before the 6/21 paycheck. June holds up. The extra shift isn't counted, so that $220 would be a bonus.

A "red day" is any day below a floor you pick. We'd start with $100, enough to absorb a surprise charge. To make red days jump out, select column E, then go to Home, Conditional Formatting, Highlight Cells Rules, Less Than, and enter 100.

A monthly cash flow template Excel free download would tell Jamie that June works. It wouldn't show her where the thin days are. Transaction timing can affect whether you have enough, which is why the Consumer Financial Protection Bureau said in 2025 to track your balance carefully and know when deposited money will be available. The week-by-week view is how you do that.

Adjust and prioritize: move flexible spends, split big bills, and add a buffer

When a day turns red, you have three levers.

Move flexible spending. Say you start 6/13 with $175 and plan an $80 purchase that day. That leaves $95 on 6/14, under a $100 floor. Move the purchase to 6/22, the day after payday, and 6/14 stays at $175. Nothing was cut. It just moved.

Split big bills. Pay part of a bill early, on a day when money just landed. In July, Jamie's $95 insurance draft and $150 card payment both come out on Monday 7/15. If she pays $75 toward the card on 6/21, the payday when her balance hits 2,330, then Monday 7/15 only has to carry $170, not $245. A late deposit has less to knock over. Groceries work the same way: move a Sunday trip to Tuesday.

Add a buffer. Treat your floor as zero. If $100 is your floor, a $100 balance is your empty tank.

For bills that keep landing in the wrong week, ask about the date itself. You may be able to work with landlords, utility companies or creditors to adjust due dates, the Consumer Financial Protection Bureau noted in 2025, and use weeks with more money to move extra into savings. Your sheet can't call your insurer for you, but it can show you which bill to call about.

Reconcile forecast vs. actual after each payday or bill

A forecast drifts if you don't touch it. We'd set a 10-minute check that matches Jamie's cycle: Friday evening after payday, or Saturday morning with coffee.

The routine:

• Compare the real balance in your banking app to the sheet's balance for today.
• Swap estimates for actuals. If the electric bill on 6/18 comes in at $92, not $85, change the Out cell. The 6/18 balance drops to 1,143, and 6/21 updates to 2,323 on its own.
• Mark cleared rows (gray them out) so you don't double count.
• Add anything new, like a vet bill or that $220 once it lands.

If the bank and the sheet disagree and you can't find why, add a new opening balance row with today's real number and keep going. The sheet is there to help you plan, not to grade you.

Print or export to PDF for sharing or posting on the fridge

If you want a PDF for the fridge or for a partner who won't open spreadsheets, Excel can make one:

• In Excel, switch to Page Layout view (View tab, Page Layout).
• Set Orientation to Portrait or Landscape, based on how wide your sheet is.
• Set Scale to Fit to 1 page wide by 1 page tall if needed.
• Go to File, Save As, and choose PDF. Under Options, choose "Active Sheet(s)."

Jamie prints rows 6/3 through 6/23, the next three weeks, on one page. Nobody needs October on the fridge.

Beyond Excel: keep recurring bills and paychecks on a calendar that auto-forecasts your daily balance

Can I download a free Excel cash flow forecast template and stop there? Sure. Plenty of people do. The sheet gets heavy when the same items repeat. Jamie's biweekly Fridays don't line up with months, so two months a year bring a third paycheck, and every new month means retyping every row.

That's why we built Cash Flow Calendar. You enter each recurring bill and paycheck once, with its real schedule (biweekly, semi-monthly, monthly, weekly or custom). The calendar view then shows upcoming bills and income and the projected balance for every future day. You see the exact date a balance would dip too low, on the web, iOS or Android.

For Jamie, that means she enters her paycheck once as biweekly and her insurance once on whatever schedule her insurer actually uses, monthly or custom. The projected balance then shows every future day, without retyping.

A bank connection through Plaid is optional in the US and Canada, and it pulls in actual transactions to compare with your forecast. Manual entry works fully without it. If you keep personal and business money separate, you can run more than one calendar.

Worked example: one biweekly Friday paycheck and a Monday auto-draft

Here's where Jamie's pattern bites. In July, her Monday-after-payday insurance draft lands on 7/15, the same day her credit card is due.

• Thursday 7/11, opening balance: 240
• Friday 7/12, paycheck: +1,180 (expected)
• Sunday 7/14, groceries: -120
• Monday 7/15, insurance auto-draft: -95
• Monday 7/15, credit card due: -150

If the paycheck lands Friday, all is well: 240 + 1,180 - 120 - 95 - 150 = 1,055.

Now say payroll runs late and the deposit isn't available until Tuesday 7/16. Groceries on Sunday take her to 120. Then Monday's two drafts total 245, and the projected balance drops to -125 on 7/15. That's a red day, and it's two charges deep. An overdraft happens when your account lacks the money for a transaction and the bank pays it anyway, and many institutions charge $30 or more per transaction, according to the Consumer Financial Protection Bureau in 2025.

The fix, once she sees it coming:

• Move groceries from Sunday 7/14 to Tuesday 7/16, after the deposit. Monday's balance becomes 240 - 245 = -5. Better, but still red.
• Close the last $5. She can skip a small purchase, or move a little from savings before Monday. For next time, she can ask her insurer to move the draft a few days later.

Splitting groceries ($50 on 7/13 and $70 on 7/16) doesn't help here, because the $50 still leaves before Monday's drafts. That's the honest part of forecasting. Sometimes the first fix isn't enough, and you only know because you did the math ahead of time.

Common tweaks people miss in Excel

The cash flow spreadsheet formula is simple. Most mistakes come from what goes into it.

• Use net pay, not gross. Taxes, benefits and 401(k) contributions never reach checking.
• Account for holds. Mobile check deposits and weekend deposits may not be usable right away. In 2025, the Consumer Financial Protection Bureau advised knowing when deposited funds will be available for use. We can't tell you your bank's hold rules, so ask, and enter deposits on the day the money is usable.
• Add annual and quarterly bills. Car registration and renter's insurance don't care that you forgot them. Add the next due date now and set a reminder.
• Count transfers. Money moved to savings is an Out on this sheet, even though it's still yours.
• Know your pay cycle. Biweekly is 26 paychecks a year. Semi-monthly is 24. Enter the exact dates, not "twice a month."

Wrap up: download the template, then let your calendar handle recurring bills going forward

Here's the order we'd do it in:

• Download the free Excel template.
• Set your start date and opening balance for the account your bills hit.
• Add your paychecks and bills on their real dates.
• Scan the projected balance and fix any red days.
• Then add each recurring bill and paycheck once in the calendar app, so your projected balance updates on its own.

Your next step is tonight's version: one account, the next three weeks, real dates. Once you're tired of retyping every other Friday, see plans on our pricing page.