How to forecast your personal cash flow 3 to 12 months ahead

What a cash flow forecast answers

A forecast answers one question: on each future day, how much money will be in the account you pay bills from? The useful number is not the month-end balance but the lowest balance in each stretch between paychecks. That low point is where overdrafts, declined autopays and expensive short-term borrowing happen.

The Consumer Financial Protection Bureau describes a cash flow budget as tracking the timing of your income and expenses to make sure you have enough from week to week. Its free worksheet has you enter a beginning balance, add income received that week, subtract expenses, and copy the ending balance to the start of the next week. This guide uses the same logic, extended to several months and to individual due dates.

This is a method guide built from official sources and an invented household. We have not tested any forecasting product hands-on.

Step 1: list every inflow and outflow with a date

Pull the last 12 months of statements from every checking account and credit card, not just the last month. Annual and semi-annual bills only show up across a full year. The CFPB worksheet asks you to track income and spending for at least one month before building a cash flow budget; for a 12-month forecast, a year of history is a better base.

Sort every item into one of four groups. Each group needs different handling in the forecast.

Step 2: project the balance month by month

Our invented household takes home $4,200 a month in two $2,100 paychecks on the 1st and 15th. Regular monthly outflows are $3,585: rent $1,650, car payment $340, phone and internet $130, subscriptions $45, and $1,420 of variable spending including utilities. That leaves $615 a month before irregular bills. The checking balance on 1 November is $1,800.

Each row below is: start balance plus $615, minus that month's irregular bills. Every month ends above $1,800, which looks comfortable. It is not the whole picture.

Step 3: zoom into the tight month and find the low point

January is the month with the smallest month-end cushion and the largest single bill, so lay it out by date. Variable spending of $1,420 is split evenly, $710 in each half of the month.

The balance bottoms out at $455 on 14 January, the day before the second paycheck, even though January ends at $1,845. If the household wants never to drop below $500, it is $45 short in the first half of January while looking $1,345 ahead at month-end.

Step 4: fix the low point before it arrives

Once you can see the low point, the fixes are mechanical. Pick the cheapest one that clears your floor.

• Pre-fund the bill: set aside $115 a month from July through December (six contributions) into a separate savings bucket so the $690 premium is already covered. Our sinking funds guide shows the arithmetic.
• Move the date: ask the insurer or lender whether the due date can sit after the 15th, and get any change confirmed in writing before relying on it.
• Split the bill: if monthly billing is offered, compare the total annual cost first, since installment plans sometimes cost more.
• Hold a buffer: decide on a floor, such as $500 or one week of spending, and treat any forecast dip below it as a problem to solve now.
• Shift discretionary spending: front-loading groceries and dining into the second half of the month moves the dip but does not remove it.

Step 5: keep the forecast alive

A forecast built once is out of date within weeks. A light routine keeps it useful: each payday, replace the forecast opening balance with the real one, mark bills as paid, and look at the next 90 days. Once a quarter, roll the window forward and add any new annual bills. Once a year, rebuild the irregular list from 12 months of statements.

In a spreadsheet, one row per dated item with a running total column is enough: the running balance in each row is the previous row's balance plus that row's change. Sort by date, and use conditional formatting to colour any balance under your floor.

Where a forecasting app saves time

The spreadsheet method breaks down when you have many accounts, irregular income or bills in several currencies. A forecasting app re-projects automatically when a transaction imports or an amount changes. PocketSmith is built around this job: its features page describes scheduling bills and budgets on a calendar, forecasting daily bank balances up to 60 years ahead, what-if scenarios for testing decisions, and automatic currency conversion at daily rates.

Projection length depends on the plan. PocketSmith's plans page, read on 29 October 2026, lists a Free tier with a 6-month projection and 2 accounts, Foundation at $9.99 a month billed annually ($14.95 monthly) with 10 years, Flourish at $16.66 billed annually ($24.95 monthly) with 30 years, and Fortune at $26.66 billed annually ($39.95 monthly) with 60 years. Prices are in USD and a 14-day money-back guarantee is stated. For a 3 to 12 month forecast, any paid tier covers the horizon; the Free tier covers six months.