Build a 13-Week Cash Forecast for an Apparel Factory

Start with the dates on which money can move

A factory has finished a profitable order, but its buyer expects to pay next month while wages and a fabric invoice fall due next week. The profit report may be sound, yet it cannot answer whether those payments can clear on time.

A 13-week cash forecast answers that question by listing expected receipts and payments by week, then carrying each closing balance into the next week. The useful output is a dated cash position, supported by the orders, invoices and other events that can change it.

Thirteen weeks provides a practical planning window of 91 days, although this does not exactly match every calendar quarter or cover every apparel order's cash cycle. A business with long material lead times or long buyer credit terms also needs a longer view. BDC's cash-planning guide describes a 13-week rolling forecast updated at the start of each week. That regular refresh matters as much as the chosen horizon.

The method below follows one fictional factory. All amounts are invented currency units, shown as CU. The figures teach the cash logic; they are not industry benchmarks, loan terms or recommended spending levels.

Give the forecast a clear boundary

Choose the business, accounts and currencies included before collecting numbers. A schedule for one legal entity should not count another entity's cash without an agreed transfer, while transfers between accounts inside a group forecast need to cancel. Otherwise, moving money from one factory account to another looks like new cash from a customer.

Give each column a start date and an end date using one agreed week boundary, with consistent treatment of holidays and bank cutoffs. A payment instructed on Friday but expected to clear on Monday belongs in the cash period that reflects that timing. The evidence should explain any difference between the payment instruction and the bank movement.

The first few weeks can draw on named invoices and payment files, whereas later weeks may need more estimates based on planned output and accepted orders. Mark that difference in the supporting data. A detailed number can still be uncertain, and an exact-looking receipt date does not make a buyer's promise firm.

A cash forecast is also different from a historical statement of cash flows. IAS 7 describes reporting changes in cash and cash equivalents during a period. The forecast here is a management tool for future payments. Its categories should help users trace those payments; it is not a claim to present a complete set of financial statements.

Keep a monthly view beyond week 13 where major commitments continue, so a machine instalment in week 14 remains visible even while it sits outside the weekly sheet.

Establish usable opening cash

Reconcile a dated bank position to the accounting records, investigating uncleared items, bank charges and transfers in transit before using it as the opening figure. There should be one clear cutoff, so a receipt already in opening cash cannot also appear as a future inflow.

Then separate cash that can fund the forecast's payments from balances with limits on use. A deposit pledged to support a facility may exist on the balance sheet without being available for next Friday's payroll. Explain the exclusion in a reconciliation that distinguishes the forecast's liquidity boundary from the deposit's accounting classification, which this management adjustment does not change.

Undrawn borrowing may support a later funding plan, but it cannot be treated as opening cash because it has its own limits, dates and conditions. Adding a loan limit to the bank balance at the start hides the point at which a draw is needed.

For the worked case, the factory begins week 1 with CU30,000 of reconciled cash available for the listed payments. There are no cash transfers between included accounts and no currency conversions. A separate CU5,000 minimum balance is a management choice for this example. It is not a legal minimum or a reserve rule for all factories.

That distinction matters because a balance above zero can still fall below the chosen floor, leaving less protection against an unexpected payment. Report both conditions so managers know whether the problem is a reduced buffer or an inability to meet the modelled payments without funding.

Build receipts from the buyer's payment path

The sales plan helps identify future business, but it is not a collection schedule. ACCA's cash-budget example explains how revenue, receipt timing and material payments can fall in different periods. Its example is from another industry; use the timing principle, not its assumed margins or payment patterns.

For each material receipt, retain the buyer, invoice or order reference, currency, expected amount and expected cash date. Support that date with an accepted invoice, a payment advice or a documented estimate based on the buyer's past behaviour, so reviewers can distinguish evidence from judgement.

An invoice date alone may not settle the issue when the agreed terms depend on delivery, document acceptance or another event. When a missing document moves the expected receipt despite production finishing on schedule, the collections team should identify that obstacle and the action needed to resolve it.

Treat deductions with equal care. If CU40,000 is expected net of a known charge, do not forecast CU40,000 and then subtract that same charge again. If the amount is disputed, preserve the gross claim and show the cash assumption separately. The forecast should not conceal a dispute by presenting a hopeful date as a confirmed collection.

Separate existing receivables from collections on future sales. When a forecast order becomes an invoice, move its identity through the supporting schedule rather than leaving both entries active. The same sale cannot provide cash twice.

In this case, week 5 receipts include one CU40,000 buyer payment and CU12,000 from other buyers. That single large receipt deserves its own line in the detail even though the summary shows CU52,000. Later, the timing of this payment will explain the largest change in the cash position.

Keep enough detail to trace a changed receipt

Give each expected receipt a stable reference so that, when a buyer settles an invoice in two parts, both amounts remain linked to it with their separate dates. The remaining amount should fall when either part clears. A payment advice can cover several invoices, so matching only on the bank amount may leave some invoices open or mark the wrong ones as paid.

The supporting file also needs an owner and a last-review date, because a week 5 receipt that nobody has reviewed for a month deserves attention even if its invoice is valid. The cash team should be able to ask what changed since the last issue and find the answer without rebuilding the whole schedule.

Do not turn a receipt's uncertain timing into a false partial payment. A judgement that there is a 60% chance of collecting CU40,000 this week does not mean CU24,000 will reach the bank. An expected-value estimate may serve an analysis of many outcomes, but a payment plan still needs scenarios for the actual amounts and dates that could occur. Keep the evidence and the judgement visible.

Put payments on their real schedule

The payment side needs the same care, since the date fabric enters production may differ from the date on which the supplier receives money. A deposit, shipment balance and later credit settlement can each fall in a different week. The purchase order and payment terms provide a starting point; the invoice and approval status refine it.

Payroll follows its actual payment calendar, with related amounts paid to other parties included where applicable. Reconcile net pay and deductions so that no amount appears twice in the cash schedule. Tax and statutory payment dates must come from the factory's own jurisdiction and verified records. No general article can supply one calendar for every reader.

Equipment deposits, debt principal and interest require cash, whereas depreciation does not create a new bank payment when the charge enters the accounts. ACCA's guide makes this distinction: the equipment payment belongs on its cash date, while the depreciation charge is excluded from the cash budget.

For the fictional 13 weeks, the scheduled payments total CU301,000:

Payroll is CU7,000 each week. Equipment payments are CU6,000 in week 2 and CU8,000 in week 4; the tax payment is also in week 4. These are stated case inputs, not tax rules or typical factory costs. All other scheduled cash payments are included in the weekly totals below.

Calculate the unfinanced weekly position

To make the timing gap visible, the summary first shows the position before any new borrowing, repayments of that borrowing or its fees and interest. It is a diagnostic view, not a completed funding plan.

For each week:

Net cash movement = receipts − scheduled payments

Closing cash before new funding = opening cash + net cash movement

Next week's opening cash = this week's closing cash

The factory's base case is:

With total receipts of CU290,000, the final balance reconciles as CU30,000 + CU290,000 − CU301,000 = CU19,000. This independent whole-period calculation agrees with the balances carried forward through the weekly schedule.

Although the closing balance stays positive in every week, week 4 closes at CU3,000, which is CU2,000 below the chosen CU5,000 floor. A report showing only the final CU19,000 would miss this early pressure point.

For a given week, the gap to the floor is the larger of zero and the floor less the unfinanced balance. In week 4 it is CU5,000 − CU3,000 = CU2,000. Keep that gap visible alongside the balance; do not change a payment date just to make the warning disappear.

Move one receipt and follow the effect

Now suppose the CU40,000 buyer payment expected in week 5 arrives in week 7, while the other receipts and all scheduled payments stay unchanged. This is a timing scenario, with no assumed loss of the amount owed.

Week 5 now moves down by CU10,000, from CU3,000 to negative CU7,000, before week 6 loses a further CU10,000. The delayed receipt then restores week 7 to the original CU19,000.

The negative numbers represent an unfunded requirement rather than an overdraft that the bank has agreed to permit. The factory needs a valid funding or operating response before those payments can occur as modelled.

Although the full receipt remains inside the horizon and leaves total receipts and the week 13 closing balance unchanged, the largest week-end gap to the floor rises from CU2,000 to CU22,000. A total-period cash measure cannot explain that change.

This is also why a generic percentage reduction in all receipts can be less useful than a named event. A single major buyer can move the cash trough by much more than a small change spread across many invoices. The scenario should identify who owns the collection follow-up and what new evidence would change its date.

Test the days inside a tight week

Weekly totals can hide the order of payments. Consider the base case's week 4. It starts with CU11,000 and ends with CU3,000, but suppose the cash movements occur in this order:

The table still reconciles to CU22,000 received and CU30,000 paid, but the timing of these movements leaves Tuesday's balance at negative CU5,000. Meeting the CU5,000 floor at that point requires CU10,000, not the CU2,000 suggested by the weekly closing balance alone.

Expand the tight weeks into dated movements wherever a large receipt and a critical payment sit close together, so their sequence enters the funding decision. The delayed-buyer case's CU22,000 week-end gap is therefore a lower bound for funding to maintain the floor; a full daily check could reveal a larger need.

The Association of Corporate Treasurers' forecasting guide describes receipts-and-payments schedules for different time intervals and stresses regular comparison with actual results. The appropriate detail depends on the decision. A weekly management report can coexist with a daily payment view.

Compare the gap with funds that can actually be drawn

Suppose the case factory has confirmed CU15,000 of unused borrowing capacity for the relevant dates. This is an explicit case assumption: the agreed limits and draw conditions have been checked, and the amount is separate from the opening CU30,000 cash.

At the delayed case's week 6 close, the CU22,000 requirement exceeds available capacity of CU15,000, leaving a CU7,000 shortfall against the minimum balance. If the full CU15,000 were drawn and no other response occurred, the modelled cash balance would still be negative CU2,000 before any new financing charges.

This facility cannot solve the stated case on its own, and the CU7,000 is not a final all-in funding quote. Any new fees, interest, repayment dates or stricter daily need must enter a funded version of the forecast.

For a real facility, confirm the amount that can be used on the day required. A headline limit may differ from usable capacity because of current drawings, security terms, eligible invoices, conditions or expiry dates. An unapproved application is an action under discussion, not a confirmed receipt.

A forecast loan receipt cannot be added to the full undrawn facility as another independent source of cash, because drawing the funds raises cash while reducing unused capacity. Keep that bridge explicit so the same capacity is not counted twice.

The British Business Bank's forecast guidance links the forecast period to the cash cycle and includes items such as equipment and loan payments. The practical question is whether the complete dated payment plan is funded, rather than whether one summary balance looks comfortable.

Keep currencies and scenarios consistent

The worked table uses one currency to isolate timing. A factory that collects export receipts in one currency and pays wages in another needs a further step. Retain each amount in its original currency, along with the conversion date, assumed exchange rate and relevant charges. A reporting-currency total alone does not show whether the required currency is available at the bank that makes the payment.

Use the actual agreed terms for a contracted conversion, and state a planning rate for an uncontracted amount so that alternative exchange-rate scenarios can be assessed. Neither an old accounting rate nor a current market quote guarantees the future cash proceeds. PwC's forecasting guide includes exchange-rate sensitivity among the assumptions that need explicit treatment.

Scenario changes must also agree with the operating story. The delayed-buyer case holds every payment fixed to reveal one timing effect, whereas a cancelled order would require a different model of both receipts and commitments. Some material commitments might remain payable; some future purchases might be avoidable. Payroll and freight would not necessarily fall in the same week as sales.

Document those relationships before combining risks, since a downside case can overstate the problem by counting the same lost receipt twice or understate it by reducing commitments that remain payable. Separate scenarios make the reasoning easier to challenge.

Refresh the forecast without erasing its mistakes

Save the issued forecast before replacing a completed week with actual cash movements. Otherwise, every update removes the evidence needed to learn which estimates were poor.

For week 1 in this case, forecast receipts were CU12,000 and payments CU18,000. Suppose actual receipts are CU10,000 and actual payments CU17,500. Starting cash remains CU30,000, so actual closing cash is CU22,500.

Define the closing-cash variance as actual less forecast. Lower receipts contribute negative CU2,000; lower payments contribute positive CU500. The net variance is negative CU1,500, which agrees with CU22,500 − CU24,000.

The payment difference looks favourable, but its explanation matters: suppose the CU500 supplier payment was entered in week 1 by mistake and is contractually due in week 2. It has not become a cost saving. The buyer also confirms that the missing CU2,000 receipt will clear in week 2.

Starting from actual cash of CU22,500, the revised week 2 receives CU20,000 and pays CU25,500, so it closes at CU17,000. Both timing changes have now cleared and the balance returns to the original forecast path, provided neither amount remains counted in both weeks.

For each variance, distinguish changed timing, changed amount and a missing or duplicate item, retaining the previous expected date, revised date, supporting evidence and responsible owner. Then add a new week at the far end so the forecast still covers 13 future weeks.

Assess receipts and payments separately when reviewing accuracy, because equal timing errors can cancel across two weeks while still creating an unfunded requirement in the first. ApparelDiary's guide to MAE, WAPE and signed bias explains why absolute error and direction answer different questions. Choose a sensible cash-flow denominator before applying a percentage metric.

Turn the cash gap into a documented decision

A useful weekly meeting ends with specific actions and dates. The delayed buyer receipt needs an owner for the missing evidence or collection contact, while a funding gap needs a decision date that allows time for approval and clearing. A promise to “watch cash closely” does not change either schedule.

Possible responses also have operating effects. Moving an equipment payment may require supplier agreement and may delay capacity. Changing a material order could affect delivery or minimum-order terms. An urgent freight payment might protect a larger buyer receipt, but that relationship needs evidence. The site's expediting cost-benefit guide can help assess that separate trade-off.

Until proposed actions are confirmed, show their expected cash effect in a separate scenario that includes associated costs, rather than treating them as completed changes to the base case. Do not assume late payment of wages, taxes or supplier bills is an approved funding source. The applicable obligations and agreed terms still govern those payments.

PwC's 2020 crisis cash-management guide sets out a direct 13-week approach with scenarios, named assumptions and supporting payment detail. Its historical crisis context does not supply current legal rules or assistance programmes. The lasting practical point is to connect the forecast to the people who know when the cash can move.

For this factory, the key findings are specific: week 4 needs a daily view, the buyer delay creates a CU22,000 week-end gap to the chosen floor, and CU15,000 of capacity does not cover that case. Those facts give the team a decision to resolve before the difficult dates arrive.

References

• BDC: Plan your cash flow in the coming year.

• ACCA: Cash budgets.

• British Business Bank: Create a cash-flow forecast.

• Association of Corporate Treasurers: Cash-flow forecasting.

• IFRS Foundation: IAS 7 overview.

• PwC: Crisis cash-flow management, April 2020.