See it Tuesday, not at month-end

Business intelligence changes what happens next month while you still can. A forward-looking report tells you margin is about to miss, names the cause and gives you time to act. Here's what that looks like (an illustrative example on sample data) and what it takes to get there.

The Tuesday it flagged, nineteen days early

On a Tuesday morning, three weeks before month-end, the forecast quietly crossed a line. Projected Q3 gross margin dipped below the 24% target, not in the actuals, which still looked fine, but in the projection. The report didn't wait to be asked. It flagged it, named the driver, and put a number on it: freight was running about £11k over plan, driven by one lane, and if it held, the quarter would close roughly 2.2 points light.

Crucially, that message arrived on the 4th, not the 31st. It was specific enough to act on (a named cause, a size, and a deadline) rather than a vague sense that "margins feel tight."

What the nineteen days bought

Because the miss was visible while it was still a forecast, it was still a decision, not a post-mortem. In this scenario the finance director had time to renegotiate the carrier rate and consolidate two smaller shipments into one before the window closed. Those options disappear once month-end has landed and the cost is booked. By close, the gap was roughly half what the early forecast had projected.

The difference wasn't a faster analyst or a longer month-end. It was the report looking forward instead of back, and speaking up on its own.

Why most reports can't do this

Most reporting is a rear-view mirror. It reconciles last month accurately but weeks after it matters, and it waits to be opened. Three things have to be true for a report to warn you in time:

• Numbers you trust. A forecast is only as good as the data beneath it. Reconciled figures are what make the forecast safe to use.
• A forecast, not just a total. The report has to project forward from your current run-rate and known commitments, so "on track" and "about to miss" look different well before month-end.
• An alert that finds you. The warning has to reach you (a flag, a note, a line in the morning summary), not sit inside a dashboard you have to remember to check.

Get those three right and the report stops being a record of what went wrong and becomes an early warning you can act on.

See it Tuesday

"See it on Tuesday, not at month-end" isn't a slogan about speed: it's about when the information is still useful. A number that arrives after the decision is history; the same number, days earlier, is leverage. That's the whole reason to build any of this: not to describe the past more precisely, but to give you back the time to change the outcome.