← Back home

Cash flow

How to build a monthly cash-flow forecast from your payout calendar

Your bank balance tells you what happened yesterday. A forecast tells you whether next Tuesday's bills are covered. Here is how to build one from the payout dates you already have — in six steps, and fifteen minutes a week to keep it honest.

A small-business owner reviewing a monthly cash-flow forecast with a payout calendar

Why a forecast beats a bank balance

Marketplace money arrives on the platform's schedule, not yours — weekly, twice a month, or a few days after each sale, then another day or two to reach your bank. A healthy bank balance on Monday can still leave rent uncovered on Wednesday if the next payout lands on Friday. A forecast shows you that gap a month in advance, when you can still do something about it.

Step 1: Write down every payout date you actually have

A cash-flow forecast starts with the one thing you can look up instead of guess: when each platform releases your money. Open every marketplace and payment platform you sell on and write down its payout schedule in one place — the day of the week or the date of the month, the release delay after a sale, and the bank transfer time after release. A platform that pays every Friday is a different business from one that pays on the 1st and the 15th, and a platform that holds new-seller funds for a few days after each sale behaves differently again.

Be precise about what each date means. The day a platform marks a payout as sent is not the day it reaches your bank. Most US bank transfers take one to three business days, and a Friday release can easily land on a Tuesday. Record the date the money is usable in your account, not the date the platform says it sent it. If a platform gives a range rather than a date, plan on the last day of the range. Planning on the earliest possible day is how a forecast turns into an overdraft.

Include every income stream, even the small ones. A second marketplace that pays a modest amount every two weeks still matters, because it may be the payout that covers a subscription renewal or a software bill. Leave a stream out and your forecast will quietly understate your income in the weeks that stream pays — and you will make spending decisions on a number that is wrong.

Step 2: List every fixed cost with its real due date

Next, list the costs that arrive whether you sell anything or not: rent, software subscriptions, marketplace seller fees, phone and internet, insurance, loan payments, and any regular payment to a supplier or contractor. Write each one with its due date and its usual amount. The due date matters as much as the amount, because a bill due on the 3rd has to be covered by money that arrived before the 3rd — not by a payout landing on the 5th.

Go through a full month of bank and card statements to build this list, not your memory. Memory drops the small subscriptions and the quarterly bills that land once every three months. A quarterly software renewal that you forgot about is exactly the kind of cost that breaks a forecast. When you find a cost that is not monthly, divide it by the number of months between payments and set that amount aside each month, so the money is there when the bill arrives.

Separate business costs from personal costs if the same account pays both. A forecast that mixes the two will always be wrong in both directions: it will overstate what the business can spend and understate what the household needs. Even a simple split — two columns, business and personal — keeps the forecast honest and makes tax time far easier.

Step 3: Estimate variable costs honestly, not optimistically

Variable costs are the ones that change with how much you sell: packaging, shipping labels, marketplace transaction fees, advertising spend, and restocking. For each one, look at the last three months and take the average — not the best month, and not the month you hope next month will be. If your advertising spend was higher in two of the last three months, use the higher figure. A forecast built on your best month is a wish, not a plan.

Tie variable costs to sales in your forecast rather than fixing them as a flat number. If packaging costs roughly follow order volume, estimate them as a share of expected sales for that month. When a busy week is coming, the forecast should show costs rising with it, so you can see whether the extra sales actually leave extra cash after the extra costs — or whether the busy week just moves money around.

Add a line for the costs you cannot predict exactly but know will appear: a returned item, a damaged shipment, a refund. You do not need to guess the amount precisely. Setting aside a small, fixed amount each month for these surprises turns a sudden refund from a crisis into a line item you already planned for.

Step 4: Lay money in and money out side by side, week by week

Now put the two lists together on a simple weekly grid: four or five rows, one per week of the month, with money expected in on one side and money due out on the other. The weekly view is the whole point of a forecast. A monthly total can look healthy while a single week is underwater — for example, when rent and a supplier payment fall in the same week and the next payout does not land until the week after.

For each week, subtract the money going out from the money coming in plus whatever you carried over from the week before. That running balance is the number that matters. If any week goes negative, you have found the problem before it finds you — and you can fix it now, while you still have options: move a discretionary payment, delay a restock, or ask a supplier for a few extra days.

Keep the grid simple enough to update by hand in a few minutes. A spreadsheet works well, and so does a sheet of paper. The tool does not matter; the habit does. The moment a forecast needs an hour of setup, it will not get updated — and a forecast that is not updated is worse than no forecast, because it gives you confidence in numbers that are no longer true.

Step 5: Build in a buffer for holds, delays and short payouts

Every marketplace seller has met a payout that arrived late, arrived short, or was held for a review. Your forecast should assume this will happen, because over a long enough run it will. Add a buffer to the money-out side of each week: a modest amount set aside for the week a payout slips by a few days or a fee change takes a larger cut than you expected.

The size of the buffer is a judgment call, but a useful starting point is enough to cover one week of your fixed costs. If that feels large, start smaller and grow it in calm months — the buffer is built in the good weeks so it is there in the bad ones. Keep the buffer in a separate account or a clearly labelled sub-balance if your bank allows it, so it is not accidentally spent on a restock.

A buffer also changes how you react to a hold. Without one, a delayed payout means urgent calls and rushed decisions. With one, the same delay is an inconvenience you already planned for: you pay the bills from the buffer, note the delay in your forecast, and refill the buffer when the payout lands. That calm is worth more than the money itself.

Step 6: Update the forecast every week, in fifteen minutes

A forecast is a living document, not a one-time exercise. Pick one day a week — the same day, every week — and spend fifteen minutes on it. Replace each estimated payout with the actual amount that arrived, move any payment that slipped to the week it will actually land, and adjust next month's estimates with what you just learned. Fifteen minutes a week keeps the forecast accurate; an hour once a quarter does not.

Pay special attention to the differences between what you expected and what actually happened. If payouts keep arriving two days later than the platform's stated schedule, change the schedule in your forecast to match reality. If a particular cost keeps coming in higher than you estimated, raise the estimate. The forecast gets better the more honest you are about its misses.

Once a month, step back and look at the whole picture: did the month end where the forecast said it would? If it did, your estimates are sound. If it did not, find the biggest single difference and fix that one thing first. A forecast improves one correction at a time, and after two or three months of weekly updates it becomes the most reliable financial tool a small seller has.

Seven mistakes that break a forecast

  • Counting a payout on the day the platform sends it, not the day it clears in your bank.
  • Forgetting quarterly and annual bills — software renewals, insurance, domain fees.
  • Forecasting sales from your best month instead of your average month.
  • Leaving out refunds, returns and damaged shipments entirely.
  • Mixing personal spending into the business forecast, so neither side is accurate.
  • Building the forecast once and never updating it when reality changes.
  • Treating a marketplace payout as guaranteed income before it is released.

Every one of these mistakes has the same root cause: planning on the money you hope will arrive, on the day you hope it will arrive, instead of the money you can count on. A forecast built on cautious numbers is useful even when it is wrong in your favour — it leaves you with more cash than you expected, which is a pleasant surprise. A forecast built on optimistic numbers is wrong in the other direction, and that surprise is never pleasant.

Payout calendar first

Every forecast starts with real payout dates from each platform — not guesses about when money might arrive.

A buffer you can rely on

A small reserve for holds and delays turns a late payout from a crisis into a line item you planned for.

Fifteen minutes a week

Weekly updates keep the forecast honest. A forecast that is not updated is worse than no forecast at all.

Want your payouts to run on a schedule you can plan around?

A verified account with a steady payout history makes every forecast easier to trust. Browse the catalog or ask us anything before you order.