← The journalFINANCE / FIELD GUIDE

Seeing cash a month before it moves

Your bank balance tells you about today. A short-range cash forecast built from your own records tells you about next month.

Pedestrians in Shibuya with directional camera-motion blur.FINANCE / SUNDIAL
Photography: Ayumi Kubo / Unsplash ↗ · Sundial motion treatment
THE PRACTICAL TAKEAWAY

A useful cash forecast is a calendar of known money in and money out, drawn from invoices, bills and orders you already have, adjusted for how people actually pay.

Cash is a calendar, not a balance

The bank balance is the least informative number in finance. It tells you what happened, not what is about to happen. A business can show a healthy profit and still run out of cash because customers pay later than suppliers must be paid, or because a large purchase lands in the same week as payroll and tax.

Seeing cash early means thinking in dates. For each week ahead, what money is expected to arrive, what money must leave, and what will the balance be at the end of the week?

Build it from records you already have

Most of a short-range forecast already exists in your system. Customer invoices have due dates. Supplier bills have due dates. Open sales orders will become invoices when they are delivered. Open purchase orders will become bills. Payroll, rent, loan repayments and subscriptions are recurring and known.

When sales, purchasing and accounts live in one system, these items do not need to be gathered by hand. The forecast becomes a view over live records rather than a spreadsheet someone rebuilds every Monday.

The discipline this requires is ordinary: bills entered when they arrive rather than when they are paid, and orders recorded when they are agreed. A forecast cannot show a liability the system has not been told about.

Adjust for how people actually pay

Due dates are promises, not facts. Some customers reliably pay on time; others pay weeks late. A forecast that assumes everyone pays on the due date will be optimistic every week. Use each customer's own payment history to shift expected receipts to the dates they usually arrive.

Do the same honestly on the outgoing side. If you routinely pay certain suppliers early to keep a discount, show that. If some payments can move without harm, mark them, because those are the levers you will pull when a week looks tight.

Separate committed from expected

Not every line in a forecast is equally certain. A payroll run is committed. An invoice already issued is likely. A sales order not yet delivered is expected. A pipeline opportunity is a hope. Keep these in separate layers so that a decision-maker can see how much of next month depends on things that have not happened yet.

Pipeline belongs in a longer-range planning view, not in the weekly cash forecast. Mixing them makes the forecast look healthier than it is.

Plan for tax and lumpy payments

Some of the largest outflows are the least visible in day-to-day records: quarterly estimated tax payments, sales tax remittances, annual insurance premiums, bonuses, and loan principal. They are known well in advance and still catch businesses out because they do not appear as supplier bills until the last moment.

Put them in the forecast as scheduled items for the whole year as soon as they are known. That means marking the four quarterly estimated tax dates and each state's sales tax filing dates alongside the monthly obligations. A week that carries payroll, rent and a tax payment together should be visible a month ahead, not discovered on the Monday.

Treat large customer receipts the same way in reverse. If one receipt makes up a big share of a month's inflow, a delay in that single payment changes the picture. Mark it, and decide in advance what you would do if it slipped.

Review weekly, act early

A cash forecast is only useful if someone looks at it on a fixed day each week and asks what has changed. A large receipt slipping by two weeks is a phone call to make now, not a surprise later. A tight week three weeks out is a conversation with a supplier or a bank while there are still options.

Keep a short note of each week's decisions alongside the forecast. Over time, you learn which assumptions were wrong and the forecast gets better.

Where Sundial fits

Sundial keeps invoices, bills, orders, payments and bank transactions in one set of records, so the inputs to a cash forecast stay current without manual collection. Asking a question like how much cash is expected in the second week of next month, in plain language, is the kind of capability Sundial is designed for and is building toward; the records that make the answer trustworthy are in the product today.