Cash Flow Calendar

A design firm expects a large customer payment on the 15th but must pay staff on the 10th. A monthly cash total may look healthy while the bank balance is too low on payroll day, and a dated calendar shows the gap.

Start with the reconciled opening cash available in the relevant bank accounts, keeping restricted cash separate from money that can actually be used for payroll. AFP describes short-term forecasting through separate schedules of receipts and disbursements on a cash basis, and notes that payment-clearing dates may differ from the day a payment is issued.

A cash calendar applies that logic to the dates that matter operationally. Enter known outflows such as payroll, rent, loan instalments, taxes, utilities and approved supplier bills, checking the exact due date and bank processing pattern, since a payment due on a weekend may need action on an earlier banking day.

Add receipts based on evidence. A customer invoice with net-30 terms is not the same as a firm promise to pay in 30 days, so use past payment behaviour and any current confirmation to estimate the arrival date.

For uncertain amounts, use a range or scenario, and do not use an unsigned order as certain cash simply to make the minimum balance look comfortable. The running calculation is opening cash plus receipts less payments.

With $200,000 at the start, $50,000 received and $180,000 paid, closing cash is $70,000, and the next day opens with that amount unless the bank records show otherwise. A minimum cash balance can flag risk: if the business needs $100,000 of operating buffer, the $70,000 example is $30,000 below target, although the buffer is a management choice or covenant requirement, not a universal rule.

Use a daily view for a tight week and weekly totals further ahead, with a horizon of four, eight or 13 weeks depending on payment cycles and decision lead time. Update the calendar after bank reconciliation by replacing forecast receipts and payments with actual transactions and rolling the balance forward.

Watch for VAT and other tax deadlines by reserving an estimate when the exact amount is still being calculated, and give large one-off events such as an annual insurance premium, equipment deposit or debt repayment explicit lines on the day cash is expected to move. Supplier timing should be managed honestly: if the calendar shows a shortfall, a business can negotiate terms in advance rather than quietly paying late, since delaying a payment without agreement can damage relationships and create penalties.

Compare forecast with actual by date and amount, and treat repeated late customer receipts as a reason to change assumptions, not just shift each line one week. For owners, the calendar gives time to act before a cash crunch, so keep dates grounded, show uncertainty and make the next funding or collection decision while there is still room to change it.