Cash Flow Forecasting for Small Business, Through a Harvest Season

Profit Is an Opinion, Cash Is a Fact

The starting point is understanding why a profitable business can go broke. Profit and cash are not the same:

• Profit is recorded when you earn revenue and incur expenses, whenever the money moves. You raise a ₹5 lakh invoice today, and your profit-and-loss statement counts it today, even if the customer pays in 75 days.
• Cash flow is the actual movement of money through your bank account. That ₹5 lakh is not cash until it lands.

The gap between the two is timing, and timing is what kills businesses. Your profit-and-loss statement can look great while your bank account is empty, because:

• Customers pay slowly (you have billed the revenue but not collected it).
• Stock and work-in-progress tie up cash you have already spent.
• A big payment (GST, advance tax, a loan EMI, an annual insurance premium) falls due in a lean week.
• You are growing, which sounds good but consumes cash, because you fund more inventory and receivables before the sales turn into cash.

A forecast makes this timing visible in advance, so a shortfall becomes a problem you see coming rather than a crisis on the 1st of the month.

The 13-Week Rolling Forecast

The practical standard for small businesses is a rolling 13-week cash flow forecast: roughly one quarter, week by week. Thirteen weeks is the sweet spot, short enough that your estimates are believable and long enough to give you weeks of warning to do something about a shortfall.

The structure is deliberately simple:

1. Opening cash balance for week 1 (your actual current bank balance).
2. Cash inflows for each week: money you really expect to receive that week.
3. Cash outflows for each week: money you really expect to pay that week.
4. Net cash flow = inflows − outflows for the week.
5. Closing balance = opening balance + net cash flow. This becomes the next week's opening balance.

Run that across 13 columns and you have a week-by-week view of where your bank balance is heading. The week any closing balance dips dangerously low or goes negative is your early warning.

A ready-made business cash flow template gives you this structure without building it from scratch, and a working capital view helps you size the buffer the forecast tells you to keep.

The Golden Rule: Forecast on Cash Dates, Not Invoice Dates

This is where most forecasts go wrong. Time every line to when the money actually moves, not when it is invoiced or accounted for.

• A ₹3 lakh invoice raised on the 5th with 30-day terms, to a customer who realistically pays in 45 days, goes in the forecast at around week 7, not the week you raised it.
• Your GST payment for the month goes in the week it is due (around the 20th of the following month), as a real outflow.
• Salaries go in the week you actually pay them; rent on its due date; the loan EMI on its auto-debit date.

Forecasting on invoice or accrual dates produces a forecast that looks fine and then lets you down, because the cash arrives later and leaves earlier than the paperwork suggests. Be ruthlessly realistic about customer payment behaviour: use what customers actually do, not your payment terms. If a customer always pays 20 days late, build in 20 days late.

Four Weeks at a Furniture Workshop

Take a small furniture workshop in Kashipur, a business with a simpler cycle than a mill. Its bank balance today (start of week 1) is ₹2,00,000. Here is a simplified four-week slice of its rolling forecast (a real one runs 13 weeks):

Look at week 3: the closing balance goes negative (−₹20,000). On paper the workshop is profitable, since Order B alone is ₹2,80,000 of revenue, but the cash from Order B does not arrive until week 4, while salaries, material and GST all fall due before that. Without the forecast, the owner would discover the shortfall on the day a payment bounced.

Because the owner built the forecast at the start of week 1, there are two weeks of warning and several options:

• Chase Order B's customer to pay even a part early.
• Defer the week-3 timber purchase by a week, if production allows.
• Reduce or skip the owner drawings until the cash position recovers.
• Arrange a short top-up on a working-capital facility to bridge the gap.

Any of these turns a potential crisis into a managed decision. That is what a forecast buys: not certainty, but time and choices. If bridging finance is one of the options, a business loan EMI calculator shows the repayment cost before anyone commits.

Building Your Own: A Step-by-Step

Step 1: Set your opening balance. Use your actual current bank balance, not a rounded guess.

Step 2: List your recurring outflows and their real due dates. Salaries, rent, EMIs, GST (around the 20th), advance tax in its quarterly months, insurance, subscriptions, owner pay. These are the most predictable lines, so get them in first.

Step 3: Lay in expected inflows by realistic payment week. Go through your outstanding invoices and pipeline. For each, ask: when will this money actually hit the bank? Place it in that week, allowing for each customer's real payment behaviour. An invoice tracker makes this far easier because you can see what is outstanding and how each customer pays.

Step 4: Compute net and closing balances across all 13 weeks. Watch for any week where the closing balance drops below your comfort threshold (keep a buffer, not zero).

Step 5: Stress-test it. What if your biggest customer pays two weeks later than expected? Re-run with that assumption. A forecast that only works if everyone pays on time is fragile.

Step 6: Update weekly. This is non-negotiable. Each week, replace the estimate with what actually happened, roll the 13-week window forward by one week, and re-estimate ahead with the latest information. A forecast you build once and abandon is nearly useless within days.

Making It a Living Habit

The difference between a forecast that saves a business and a spreadsheet that gathers dust is the weekly review. Block 30 minutes every Monday:

• Update last week's actuals.
• Roll the window forward.
• Re-time any inflows that slipped (a customer who said "next week" again).
• Look 4–6 weeks out for the next tight spot and decide now what you will do about it.

Keep a minimum cash buffer as a rule: enough to cover a fixed number of weeks of outflows even if a big receipt is delayed. The forecast tells you whether you are above or below that buffer at every point in the next quarter. Pair it with a wider view of your working capital and you have both the short-term radar and the structural picture.

Direct vs Indirect Forecasting (and Why Small Businesses Use Direct)

There are two broad ways to forecast cash. The direct method, which this guide describes, lists actual expected receipts and payments week by week. It is concrete and intuitive, and it suits short horizons and small businesses, because you are literally listing the money you expect to move. The indirect method starts from projected profit and adjusts for non-cash items and changes in working capital to arrive at cash flow; it is more common in longer-range financial modelling and larger companies.

For a small business managing the next quarter, the direct method wins on every practical count: it is easier to build, easier to update and easier to act on, because each line maps to a real payment you can chase, delay or plan for. Keep the direct 13-week forecast as your operating tool. If you ever need a 12-month view for a bank or investor, that is where an indirect, profit-based projection has its place.

Forecasting Through a Seasonal or Lumpy Year

Many Indian small businesses are seasonal (a festival rush, a wedding season, a harvest cycle, an exam season) or have lumpy revenue from a few large projects. Forecasting matters most for them, because the gap between the busy months and the lean months, when fixed costs continue, is exactly where firms get caught.

A harvest-linked business shows why the shape matters. At a rice mill the season's largest payments come first, when paddy is bought from farmers, and the cash comes back over the months that follow as the rice is milled, sold and paid for. A farmer's year runs the other way: costs through the growing season, cash at harvest. Either way, the businesses that get through the lean stretch comfortably are the ones that treat the flush weeks as funding for the quiet ones, not as a reason to spend freely.

The practical adjustments:

• Build the seasonal shape into the forecast. Do not spread annual revenue evenly across weeks; place it where it actually lands, and show the lean stretches honestly as the negative-cash periods they are. In our year, cash is tightest in September. Last season's stock has been sold by then, money has gone out to farmers as advances, and the limit is stretched; the new paddy reaches the mill only at the end of the month or in the first week of October, and none of it turns into cash until it has been hulled and the products start selling.
• Pre-fund the lean season from the peak. When cash comes in during the busy weeks, resist the urge to draw it all. The forecast shows how much you must hold back to get through the trough.
• Time discretionary outflows to the peak. Large purchases, equipment and bigger owner drawings belong in the high-cash weeks, not the lean ones.
• Watch the fixed costs in the trough. Rent, salaries, EMIs, and minimum GST obligations do not take a holiday in your off-season. The forecast makes the size of that fixed burden visible against near-zero inflows.

A seasonal business that forecasts is calm in its off-season because it pre-funded it. One that does not forecast spends every lean season in a panic, often borrowing expensively at the worst possible moment. The Agribusiness Cash Flow Template is laid out month by month for exactly this kind of year.

What a Mill's Forecast Has to Carry

A forecast for a business like ours needs three lines that a service business can leave out.

Drawing power, next to the bank balance. The mill works on a bank cash credit, and what it can draw is set by drawing power, recalculated each month from the stock statement: highest after procurement, lower as the stock is milled and sold. A forecast that shows only the bank balance and the sanctioned limit will look covered in weeks when the stock no longer supports the draw. How the stock statement sets drawing power shows the arithmetic.

Weekly draws, not monthly ones. In a forecast for a business on a cash credit, the week's outflows, mostly supplier payments and wages, are also the week's draw; drawing a month's needs on the first day pays interest on money that then sits idle for weeks. Collections go against the balance as they come in, and the forecast should show them landing there.

The renewal date. It comes once a year or thereabouts, and our preparation starts 60 to 90 days before it. That belongs in the forecast as surely as the GST dates do, because the numbers the bank reads at renewal are the ones the forecast has been tracking all year. Preparing for renewal covers what the bank looks at.

A forecast cannot make a thin season profitable, and no amount of borrowing fixes weak margins, slow collections or loose habits. What a forecast does is show you, weeks ahead, which of those three is about to be tested. The longer version is the mill's own cash credit, season by season.

Where Forecasts Go Wrong

• Confusing profit with cash. A healthy P&L is not a healthy bank balance. The forecast is about cash, full stop.
• Forecasting on invoice dates, not payment dates. Money arrives when customers pay, not when you bill. Be realistic, even pessimistic, about timing.
• Being optimistic about collections. Use customers' actual payment behaviour, not your stated terms.
• Forgetting lumpy outflows. GST, advance tax, annual insurance and EMIs are easy to leave out and painful when they land.
• Building it once and never updating. A stale forecast drifts from reality within a week or two. Update weekly or do not bother.
• Not keeping a buffer. Aiming for a zero closing balance leaves no room for a single late payment. Hold a cushion.
• Ignoring owner drawings. Your own pay is a real outflow: include it, and be willing to flex it when cash is tight.

Getting Your First Forecast Running

A checklist to get a working forecast running this week:

• Note your actual current bank balance as the opening figure.
• Download a business cash flow template or set up 13 weekly columns.
• Enter all recurring outflows on their real due dates: salaries, rent, GST, EMIs, taxes, drawings.
• Place each outstanding invoice and expected sale in the week you will truly be paid, using each customer's real behaviour (an invoice tracker or a receivables tracker helps).
• Compute closing balances across all 13 weeks and flag any week below your buffer.
• Stress-test: re-run assuming your biggest customer pays two weeks late.
• Decide, in advance, your levers for a tight week: chasing receivables, deferring purchases and flexing drawings are the common ones; short-term finance is another route, and a business loan EMI calculator shows its repayment cost before you weigh it.
• If the business borrows against stock, add a drawing power line beside the bank balance.
• Block 30 minutes every week to update actuals and roll the forecast forward.

Forecasting will never be the most exciting part of running a business, but it may be the part that keeps it breathing. Build the 13-week view, time everything to real cash dates, keep a buffer, and update it every week; a shortfall then shows up weeks away, with time to do something calm and sensible about it. For decisions involving finance, tax or legal obligations, consult a qualified professional about your specific situation.