Cash and inventory planning

Put the next inventory order on the cash calendar

Map expected receipts and purchase commitments to their payment dates. A 13-week forecast shows the cash low point; an inventory payment schedule and 12-month budget put the next order beside the operating plan.

See the lowest balance before the next receipts arrive

An inventory decision often means a deposit now and a balance payment later. Put both dates beside expected bank receipts and operating commitments, then inspect the cash low point. Compare the order's quantities, lead times and existing stock with the consequences of changing the purchase.

Before approving the order, resolve missing obligations, receipt timing and supplier terms. Record the assumptions to test and the trigger for revisiting the plan.

Collect amounts, expected dates and the owner of each assumption

Set the opening date and available cash, including restrictions. Identify each PO, deposit and balance payment once. Convert monthly expense totals into dated payment schedules before adding them to the weekly forecast.

Scroll horizontally if needed to see all columns.

Cash, inventory and budget inputs
InputWhat must be explicit
Bank balances and outstanding transfersAvailable opening cash, currency, restrictions and the basis for reconciling it.
Expected payouts and other customer receiptsBank-receipt dates, amounts, collection assumptions and delays already known.
Purchase orders and supplier termsOrder identity, deposit and balance dates, existing scheduled payments and agreed terms.
Inventory and supply scheduleStock on hand, sales assumptions, quantities, lead times and expected availability.
Operating and other obligationsPayroll, rent, advertising, taxes due, debt or other commitments if applicable, with amounts and dates supplied by the responsible owner.
Actual reports and budget assumptionsSales, product costs, operating expenses, seasonality and the owner approving each assumption.

Use a cash schedule beside the operating budget

Read the weekly cash schedule beside the operating budget. The materials below show when commitments fall due, which assumptions drive the result and what to update as actuals arrive.

  • A weekly cash roll-forward: opening balance plus expected receipts less scheduled payments equals closing balance.
  • A supplier payment calendar mapping deposits and balances to identified purchase orders.
  • The minimum forecast balance, its week, and comparison with a cash buffer chosen and approved by the owner.
  • Base and downside views with changed assumptions, effects on receipts and any amounts outside the forecast horizon disclosed.
  • A 12-month budget and plan-vs-actual view, with variance explanations and the inputs to update.
  • An assumption and action log naming what to verify, who owns the next action and what would trigger a reforecast.

An example: ending cash hides a tighter week along the way

The forecast runs from 5 October 2026 to 3 January 2027 and ends with $91,000. In the week starting 9 November, a scheduled $67,000 inventory payment takes closing cash to $31,500. Against the scenario's $40,000 planning buffer, the shortfall is $8,500. The inventory payment is already included in the base case.

Focus on that week when comparing order size, supplier payment terms and slower receipts. Replace the affected payment assumptions in each alternative, check the effect on stock availability and record any supplier agreement. Counting the same PO again would overstate payments.

Scroll horizontally if needed to see all columns.

Example report · Demonstration data · Week 6, starting 9 November 2026 · USD
MovementAmount
Opening cash$82,000
Expected bank receipts+$58,000
Operating payments−$41,500
Inventory payments already in the base plan−$67,000
Closing cash$31,500
Planning buffer assumption$40,000
Closing cash below that buffer$8,500
AxisCFO / cash exampleExample

2026-10-05 – 2027-01-03 · USD

Plan for the lowest cash point.

Opening cash
$85,000
Lowest cash · week 6
$31,500
W6: $31,500Week 1Week 13

What to check

An inventory payment brings week 6 cash down to $31,500. Review purchase timing before committing.

Dashed line: an assumed $40,000 buffer. Forecast period shown above; separate from the monthly revenue report.

View the 13-week cash table

Scroll horizontally if needed to see all columns.

Cash forecast example · 2026-10-05 – 2027-01-03 · USD
WeekOpening cashReceiptsInventory paymentsOperating paymentsClosing cash
Week 185,00054,00012,00040,00087,000
Week 287,00058,00018,00041,00086,000
Week 386,00062,00024,00042,00082,000
Week 482,00056,00015,00039,00084,000
Week 584,00060,00020,00042,00082,000
Week 682,00058,00067,00041,50031,500
Week 731,50070,00010,00044,00047,500
Week 847,50078,0008,00047,00070,500
Week 970,50074,00022,00046,00076,500
Week 1076,50066,00016,00044,00082,500
Week 1182,50064,00012,00043,00091,500
Week 1291,50048,0008,00038,00093,500
Week 1393,50046,00010,00038,50091,000

Assign the forecast work and keep approvals with the brand

Full preparation connects the scoped books to the planning materials. A partnered arrangement uses your bookkeeper's reviewed reports and the brand's commitments. Assign the assumptions, model review and business approvals to named owners in either arrangement.

Scroll horizontally if needed to see all columns.

Preparation, assumptions, review and approvals
WorkFull preparationWith your bookkeeper
Actuals and opening cash supportAxisCFO prepares scoped records and reconciliations; brand supplies evidence.Bookkeeper supplies reviewed actuals and cash support.
Supplier terms and operating assumptionsBrand supplies commitments, terms and the approved assumptions.Brand supplies commitments and assumptions; bookkeeper supplies relevant recorded obligations.
Forecast, budget and scenario preparationAxisCFO prepares the agreed models and assumption log.AxisCFO prepares the agreed models from your team's records and assumptions.
Review and updatesNamed reviewer checks the agreed basis; update ownership and cadence are set in scope.Named reviewer checks the agreed basis; source-record corrections and updates are assigned.
Orders, negotiations and paymentsBrand approves the decision, agrees supplier changes and executes payments.Brand approves the decision, agrees supplier changes and executes payments.

Compare Core for cash, inventory and budget planning

Compare Core for the budget, plan vs actual, 13-week cash forecast and inventory payment planning. Growth adds CFO strategy and decision scenarios for pricing, marketing, hiring or funding. Choose the package by the additional decision work required, including how it uses your bookkeeper's reports.

Define the accounts, currencies, entities, forecast horizon, order detail, scenarios and update schedule. Separate setup and cleanup from recurring work. Software connections, complex supply-chain optimisation and specialist financing packages need their own scope.

  • The brand approves its planning buffer and operating assumptions.
  • Use confirmed supplier terms and identified funding sources in the plan; show alternatives as separate assumptions.
  • Business approvals and payment execution stay with the brand's authorised decision maker.
  • Tax filings, legal advice and statutory assurance require specialist arrangements.

Cash and inventory planning FAQs

Use the payment schedule and assumptions to assess each order alternative.

Scroll horizontally if needed to see all columns.

Questions to resolve before using a cash plan to approve an order
QuestionAnswer
Is cash forecasting only in Growth?No. The Core scope brings together the 13-week forecast, inventory payment planning, 12-month budget and plan vs actual. Growth adds CFO strategy and decision scenarios.
What must be checked before approving a PO?Compare expected receipts with existing commitments and the new order's deposit and balance dates. Resolve missing obligations, supplier terms and stock constraints before the owner approves it.
How is a new PO added without counting it twice?Identify its deposits and balances in the existing schedule first. Replace the affected assumptions when testing an alternative and reconcile the resulting weekly roll-forward.
What if the books are not current?List the gaps and their effect on opening cash and obligations. Label any estimates with their basis and update plan; scope historical cleanup separately.
Who places orders and makes payments?The brand's authorised owner approves purchases, agrees supplier terms and executes payments. Planning materials show the effects of those choices on the cash schedule.
How often is the forecast updated?Set input deadlines, update dates and review ownership in the engagement. Identify the events that trigger a reforecast, such as changed receipt timing or supplier payments.

Bring the next payment date and the decision it affects

Start with the free initial finance audit and the next payment decision. Describe the order, its deposit and balance dates, the current forecast and known receipt uncertainty. Identify the records needed to examine the cash timing.

Sources and calculation notes

  1. Shopify Help Center — Lower or missing payouts

    A payout sent to the bank need not appear as a bank receipt immediately.

    Accessed 2026-10-07.

Your next financial question

Put numbers behind the next move.

Start with the decision ahead and the reporting you have today.

Explore the free finance audit