How to Build a Fashion Cash-Flow Forecast

A profitable product plan can still run out of cash. Fashion businesses often pay deposits, production balances, freight, duty, payroll, content, and marketing before direct sales settle or wholesale customers pay. Returns and tax obligations can create later outflows after the apparent sales peak.

A cash-flow forecast translates that sequence into dates. It is not an income statement and should not be built by copying revenue and expense totals into months. It asks when unrestricted cash is expected to become available and when each obligation is expected to leave.

Define the opening balance

Begin with cash the business can actually use on the first day of the period. Reconcile the amount to authorized bank and accounting records. Separate restricted funds, customer money held for another party, unavailable reserves, undeposited receipts, uncleared transactions, and credit capacity.

Credit is not cash. A purchase order is not cash. A wholesale invoice is not cash. An ecommerce order that may be canceled, returned, disputed, or not yet settled is not identical to cleared cash.

State the time interval. Weekly forecasting is often more informative around production, launch, freight, tax, or payroll dates; a monthly view can support a longer horizon. The first month of a business plan should usually have more detail than distant years. The SBA’s business-plan guidance similarly asks for specific first-year financial projections, including cash-flow statements.

Separate inflow types

Create dated rows for cash sales settlements, wholesale collections, deposits, approved capital inflows, refunds received, and other sources. Do not use one “sales” row.

For direct-to-consumer sales, model settlement delay, processor reserves, cancellations, refunds, disputes, and tax treatment. For wholesale, use documented payment terms and customer-specific collection evidence. Put late and noncollection cases in the scenario set rather than assuming every invoice arrives on its due date.

Capital contributions or financing should appear separately from operating receipts. Identify restrictions, conditions, fees, repayment, and approval. This article does not recommend borrowing, a financing structure, or a minimum cash level.

Place outflows when cash leaves

Build a calendar for:

• development, samples, tests, and product compliance;
• material and production deposits and balances;
• inbound freight, duty, brokerage, and delivery;
• packaging, fulfillment, and outbound shipping;
• payroll, contractor, rent, software, insurance, and professional costs;
• marketing and sales commissions;
• refunds, returns, chargebacks, and customer credits;
• tax, debt service, and owner-approved capital expenditures.

Use actual contract and filing dates where authorized. Do not smooth a large production payment across months merely because that makes the chart easier to read.

IRS Publication 334 explains general distinctions among inventory, cost of goods sold, gross profit, and business expenses. A cash forecast has a different purpose: it records cash timing. An inventory purchase can reduce cash before the merchandise is sold and before its cost appears in a profit view.

Make the forecast reconcile

For each period:

closing cash = opening cash + cleared or expected inflows − expected outflows

The next period must open at the prior closing amount unless a documented adjustment explains the difference. Add source, owner, confidence, last verified date, and actual-versus-forecast variance to each row.

Use a policy buffer as a visible internal threshold. The buffer might reflect payroll, refunds, taxes, production contingencies, or another board-approved need, but it is not a universal safety ratio. If closing cash falls below it, mark the period for review rather than hiding the shortfall in a larger annual total.

A reproducible fictional six-month view

FashionMember created an invented six-month file at content/data/FM-147-cash-flow-forecast.csv. The script scripts/fm147-cash-flow-forecast.php checks that each row is fictional, reconciles the next opening balance, calculates inflows, outflows, closing cash, and distance from an invented $30,000 internal buffer, and requires a human owner.

The scenario begins with $85,000 of fictional opening cash. September closes at $46,000, October at $31,000, November at $36,000, and December at $62,000. A large invented product outflow in January reduces closing cash to $19,000—$11,000 below the fixture’s buffer—so the row is held.

February includes a separate $25,000 fictional capital inflow and closes at $48,000. That recovery is not a financing recommendation or proof that funds are available. The model deliberately keeps capital separate so a reader can see that operations alone did not create the change.

The lowest fictional month-end balance is $19,000. Month-end views can still miss an intra-month trough, so a real team would expand the critical weeks into dated transactions. The fixture excludes credit restrictions, settlement reserves, foreign exchange, tax detail, debt terms, insolvency rules, covenant tests, fraud, and correlations among delayed receipts and urgent outflows.

Stress the timing, not just the totals

Run cases that move dates as well as amounts:

1. production balance is due earlier;
2. wholesale collection arrives later or only partially;
3. launch sales settle more slowly;
4. refunds and returns peak sooner;
5. freight or duty is higher;
6. a second sample or rework cycle occurs;
7. inventory sells more slowly and the next receipt still arrives.

Combine at least two adverse movements. A delayed wholesale receipt and an early production balance may be more dangerous together than either isolated percentage change.

Do not make a financing plug automatically close every negative period. Show the unfinanced case first. Any capital assumption should have an owner, status, terms, contingency, and date by which it must become certain.

Review actuals and decisions

At least weekly during a critical period, replace estimates with actual cleared amounts and explain variances. Preserve the original forecast. Categorize whether the difference came from volume, price, return, timing, cost, scope, or data error.

Possible decisions include changing quantity, delivery, launch scope, terms, discretionary outflows, or commitments, but the model should not decide. Finance, merchandising, production, sales, and the accountable owner should review customer obligations, worker pay, taxes, legal duties, supplier relationships, and long-term consequences.

The forecast is useful when it makes a cash trough visible while there is still time to respond. Its most important output is not the final month. It is the lowest dated point, the assumptions creating it, and the owner accountable for each assumption.

Sources and verification

• SBA: Plan your business — official business-planning guidance covering historical financial statements, prospective income statements, balance sheets, cash-flow statements, and more detailed first-year projections.
• SBA: Fund your business — official overview of funding choices and their implications; not a financing recommendation.
• IRS Publication 334 — official general small-business guidance on inventory, cost of goods sold, gross profit, business income, and expenses; not company-specific tax or accounting advice.
• Census retail definitions — official definitions and survey concepts for sales and inventories, useful for understanding public benchmark scope.
• Census Monthly Retail Trade Inventories — official inventory and inventory-to-sales data with revision and reliability materials; not a company forecast input.
• FTC Mail, Internet, or Telephone Order Rule guide — official delay, cancellation, and refund guidance relevant to cash timing and customer obligations.