Build from the bank balance
Start with the money available today. List expected receipts against likely payment dates, then add payroll, rent, suppliers, loan repayments and planned tax payments. Keep customer deposits and the balance due on completion on separate lines.
Test the decision before you commit
If you are buying stock for a Christmas order, run one version with the deposit paid on time and another with it two weeks late. Look at the lowest weekly balance. The same sale can have a very different effect depending on when you have to pay the supplier.
Updating your forecast each week
At each update, replace last week’s estimates with the actual movements and explain the bigger differences. To ask about a forecast, tell us the decision you are planning for, the time period and where your sales and bills are recorded.
Related reading
How can a profitable business run short of cash? · Management accounts