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.
| Input | What must be explicit |
|---|---|
| Bank balances and outstanding transfers | Available opening cash, currency, restrictions and the basis for reconciling it. |
| Expected payouts and other customer receipts | Bank-receipt dates, amounts, collection assumptions and delays already known. |
| Purchase orders and supplier terms | Order identity, deposit and balance dates, existing scheduled payments and agreed terms. |
| Inventory and supply schedule | Stock on hand, sales assumptions, quantities, lead times and expected availability. |
| Operating and other obligations | Payroll, rent, advertising, taxes due, debt or other commitments if applicable, with amounts and dates supplied by the responsible owner. |
| Actual reports and budget assumptions | Sales, 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.
| Movement | Amount |
|---|---|
| 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 |
2026-10-05 – 2027-01-03 · USD
Plan for the lowest cash point.
- Opening cash
- $85,000
- Lowest cash · week 6
- $31,500
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.
| Week | Opening cash | Receipts | Inventory payments | Operating payments | Closing cash |
|---|---|---|---|---|---|
| Week 1 | 85,000 | 54,000 | 12,000 | 40,000 | 87,000 |
| Week 2 | 87,000 | 58,000 | 18,000 | 41,000 | 86,000 |
| Week 3 | 86,000 | 62,000 | 24,000 | 42,000 | 82,000 |
| Week 4 | 82,000 | 56,000 | 15,000 | 39,000 | 84,000 |
| Week 5 | 84,000 | 60,000 | 20,000 | 42,000 | 82,000 |
| Week 6 | 82,000 | 58,000 | 67,000 | 41,500 | 31,500 |
| Week 7 | 31,500 | 70,000 | 10,000 | 44,000 | 47,500 |
| Week 8 | 47,500 | 78,000 | 8,000 | 47,000 | 70,500 |
| Week 9 | 70,500 | 74,000 | 22,000 | 46,000 | 76,500 |
| Week 10 | 76,500 | 66,000 | 16,000 | 44,000 | 82,500 |
| Week 11 | 82,500 | 64,000 | 12,000 | 43,000 | 91,500 |
| Week 12 | 91,500 | 48,000 | 8,000 | 38,000 | 93,500 |
| Week 13 | 93,500 | 46,000 | 10,000 | 38,500 | 91,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.
| Work | Full preparation | With your bookkeeper |
|---|---|---|
| Actuals and opening cash support | AxisCFO prepares scoped records and reconciliations; brand supplies evidence. | Bookkeeper supplies reviewed actuals and cash support. |
| Supplier terms and operating assumptions | Brand supplies commitments, terms and the approved assumptions. | Brand supplies commitments and assumptions; bookkeeper supplies relevant recorded obligations. |
| Forecast, budget and scenario preparation | AxisCFO prepares the agreed models and assumption log. | AxisCFO prepares the agreed models from your team's records and assumptions. |
| Review and updates | Named 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 payments | Brand 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.
| Question | Answer |
|---|---|
| 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
- 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.