A cash flow forecast projects the cash you expect to come in and out of your business over a set time period. It can help you manage cash fluctuations and stay on budget.
Wave has a free template, or ask your accountant to help create a format that works for your business.
To create a cash flow forecast with Wave’s template:
- Download the template at the bottom of this article. The template can open in Google Sheets or Excel.
- Enter your figures into the relevant cells on the template. The green cells will auto-calculate based on your entries.
You will now see a 12-month forecast.
Your forecast should match your chart of accounts, so Wave recommends that the cell names match.
The template lists a range of common options. If they are not applicable to your business, add or remove items as needed.
If any of the numbers entered result in a negative balance, the negative balance will be displayed in red.
Once you have set up the forecast template, update it regularly. Make sure to take into account your actuals, which is cash that has moved or will move from an invoice or bill.
Learn more about Wave’s reporting features in Video: Wave’s Reports Tour