Download the template that separates the buy you can still change from the buy you cannot, and dates the cash to the month it actually leaves the bank.
Each tab in the template handles one slice of the operating model — drop in your numbers and the rest updates itself.
A deposit goes out at arrival less lead time. The balance settles a month after arrival. Three different months carry a piece of one purchase order.
Any arrival whose order date has passed is a liability, not a plan. In the illustrative data 18.9% of the buy book is already committed, and all of it sits in the first four months.
October carries the biggest arrivals of the window at $879,935 and the smallest cash out at $125,784. November flips. Plan cash off arrivals and you have it backwards.
$8.7M of purchase orders, $7.7M of cash inside the window, and the $1.0M difference shown explicitly as deposits paid before it opened and balances falling after it closed.
Take a self-guided tour, or get a walkthrough tailored to your brand.
