Skip to content
Insights
Finance5 min read

How to build a 13-week cash flow forecast for a wine estate

Wine ties up cash for years and sells in seasons. A rolling 13-week forecast, built from real orders and accounting data, shows which entity gets tight before it happens.

A wine estate can be profitable and still run out of cash in June. Stock ages for years, bottling and dry goods are paid up front, and sales arrive in seasons. A rolling 13-week cash flow forecast is the simplest tool that sees a squeeze coming.

Cash by week
Threshold
W1 – W13 · Illustrative diagram

Why 13 weeks

Thirteen weeks is one quarter, short enough to plan week by week and long enough to act: delay a dry-goods order, pull forward an invoice run, or talk to the bank before it is urgent. Annual budgets are too coarse for that, and daily bank balances are too late.

What goes in

A useful forecast starts from data you already have, not from a blank spreadsheet:

  • Opening cash per company, from the bank lines in your accounting file.
  • Receivables by due date, from open invoices in your commercial tool.
  • Confirmed orders and allocations not yet invoiced, including en primeur and export orders.
  • Payables by due date: dry goods, bottling, cooperage, wages, rent and loan repayments.
  • Seasonal sales assumptions by channel, based on the same weeks last year.
  • Excise, VAT and social charges on their real payment dates.

The wine-specific traps

Bottling runs create large, lumpy outflows weeks before the wine can be sold. Harvest costs land in September and October with no matching income. Christmas trade orders are invoiced in October but often paid in January. A forecast that spreads these evenly will look fine and be wrong.

Estates with several entities have a second trap: intercompany flows. Rent paid by the operating company to a land-owning GFA, or wine sold from production to négoce, moves cash between your own companies. The group total does not change, but one entity can be short while another sits on cash. Forecast per entity first, then consolidate.

Keep it rolling and keep it honest

Each week, replace forecast figures with actuals and add a new week at the end. Compare what you expected with what happened, and adjust the assumptions that missed. After a season, the forecast reflects how your customers actually pay.

This is the routine Vinfra Connect automates: it pulls invoices, orders and bank lines every night, builds the 13-week view per company, and Vinfra AI flags the weeks where cash drops below your threshold. See how one estate set this up in our multi-entity case study.

FAQ

What is a 13-week cash flow forecast?
A week-by-week projection of cash in and cash out over the next quarter, updated every week with actual figures.
Should a wine group forecast per company or consolidated?
Per company first. Intercompany flows can hide a shortfall in one entity behind cash sitting in another.

Continue reading

Infrastructure5 min read

Wine business intelligence without replacing your ERP

Read
AI4 min read

Why does AI struggle with wine data specifically, compared to other product categories?

Read
AI4 min read

How is AI for wine catalogs and pricing different from AI in winemaking or the vineyard?

Read

See what this looks like against your catalogue.

Talk to our team about what Vinfra could run for you.