To forecast cash flow, start from your real bank balances today, list the money you already know is coming in and going out, place each item on the day it actually lands, and then read the projected low points across the coming weeks. A cash flow forecast is not a budget and it is not a profit and loss statement. It answers one blunt question: will there be enough money in the account on the day each bill is due? Here is how to build one by hand, why timing matters more than the totals, and how LedgerMCP projects your balance forward for you.
Profit is not cash, and the difference can sink you
A business can be profitable on paper and still miss payroll. Profit measures revenue minus expenses over a period, no matter when the dollars move. Cash flow is the actual timing of money hitting and leaving your bank account. The gap between the two is where small businesses get hurt: you invoice a client for a great month, the profit and loss statement looks healthy, but the payment lands in 30 days and rent is due next Tuesday.
That is why a forecast works in days and weeks, not in monthly totals. A month that nets positive can still have a Wednesday where the account goes negative because three big outflows clustered before the deposit arrived. Averages hide that. A day by day projection shows it.
How to build a cash flow projection by hand
The manual version is a running balance across a calendar. You can do it in a spreadsheet with a row per week or per day. Four steps:
- Start from today’s real balances. Open your books and note the actual current balance of every bank account you spend from. The forecast is only as honest as its starting point, so use reconciled numbers, not a rough guess.
- List known inflows and outflows. Write down the money you already know is moving: recurring inflows like paychecks and client retainers, and recurring outflows like rent, payroll, loan payments, and subscriptions.
- Place each item on its due date. Put every inflow and outflow on the calendar day it actually hits across the coming weeks. Timing is the whole point, so a bill due the 1st and one due the 28th sit in very different places.
- Read the projected low points. Run a running balance forward day by day and look for the lowest points. Those dips, not the ending number, tell you whether you can cover what is coming.
The number that matters is the smallest balance the account ever reaches, not where it lands at the end. If the low point is comfortably above zero, you are fine. If it dips near zero or below, you know the exact day, and you have weeks to do something about it: chase an invoice, delay a discretionary purchase, or move money from savings.
Where the numbers come from
A forecast built on guesses is theater. The inputs have to come from your real records. Your recurring outflows are already sitting in your transaction history: the same rent, the same software subscriptions, the same loan payment, month after month. Your inflows are the paychecks and client retainers you can reasonably count on. Pulling these from actual data, rather than from memory, is what separates a useful projection from wishful thinking. This is also why keeping a clean handle on your subscriptions pays off twice: those small recurring charges are both a spending leak to watch and a known outflow your forecast needs.
Be conservative with income and generous with expenses. If a client sometimes pays late, place the inflow on the late date. If a variable bill swings, use the high end. A forecast that is pleasantly wrong is worse than useless, because it tells you to relax right before a squeeze.
How LedgerMCP projects your balance forward
Doing this by hand every week is tedious, and it goes stale the moment a new transaction clears. LedgerMCP automates the mechanical part. Because it keeps real double-entry books, it already knows your actual balances, and its recurring and subscription detection finds the bills and paychecks that repeat in your history, along with alerts for price changes, double charges, and missed bills.
From there, LedgerMCP has a cash flow calendar that walks those detected recurring bills and paychecks forward from today’s real balances and projects your bank balance day by day through the end of next month. You are not rebuilding a spreadsheet; you are looking at a calendar that already knows what repeats and when. The low points surface on their own.
Because you can drive LedgerMCP through an AI assistant like Claude or ChatGPT over its built-in MCP server, you can also just ask: what is my lowest projected balance next month, and which bill causes it? The assistant reads the same calendar and answers in plain language. A forecast pairs naturally with a simple monthly budget: the budget sets your targets, and the forecast checks whether the timing of those targets actually works against the calendar.
Turn the forecast into a habit
A cash flow forecast is a living document, not a one-time exercise. Refresh it weekly. As real transactions clear, your starting balance updates and the projection tightens. Over a few weeks you will start to recognize your own pattern: the tight stretch right before the big client pays, the breathing room after payroll clears. That pattern is the practical value. It lets you make decisions early and calmly, instead of reacting the morning a payment bounces.
Quick answers
What is the difference between profit and cash flow?
Profit is revenue minus expenses over a period, regardless of when the money actually moves. Cash flow is the real timing of dollars in and out of your bank account. You can be profitable on paper and still run out of cash if a big bill lands before a client pays you.
How far ahead should I forecast cash flow?
For a small business, four to eight weeks is the sweet spot. That window is close enough that your recurring bills and expected income are knowable, and long enough to spot a low point before it becomes a problem. Refresh it weekly as real transactions clear.
What do I need to build a cash flow projection?
Your current bank balances and a list of the money you already know is coming and going: paychecks, client retainers, rent, payroll, loan payments, and subscriptions. You place each item on its due date across the coming weeks and add it to a running balance.
How does LedgerMCP forecast cash flow automatically?
LedgerMCP detects your recurring bills and paychecks from your real transaction history, then its cash flow calendar walks them forward from today’s actual balances and projects your bank balance day by day through the end of next month, so the low points show up without a spreadsheet.