This forecast model is designed to help you plan and manage your revenues, cost of goods, and the resulting gross margins. Using the zero-based budgeting method, you can create separate budgets for each year, company, and revenue type.
Below is a step-by-step guide on how to use the Revenue Planner.
You will find the Revenue Planner in Essentials -> Forecast.
Click on the field behind the Run button, and select the year, company, and revenue type from the dropdown menus.
Click on the Run button to retrieve the latest version of your revenue budget.
Enter your customer, price, and units per revenue line. This will give you a clear picture of your estimated revenue for each customer, product, or service.
Use the description field to enter detailed information about each forecast line, such as your assumptions or the type of product or service estimated to be sold.
Using the More button, you can enter the estimated discount, cost of sales, and comments for each revenue line.
The VAT% and Cash delay columns are used to forecast your cashflow, based on the expected time of payment. These columns indicate the payment terms that typically are associated with this revenue line. By default, revenues are assumed to convert into cash into the same month as they were forecasted. This information is used by the Cashflow Forecast report to calculate future cash inflows.
You can set the VAT rates via Update --> Settings.
The planner column enables you to plan your revenue across all months in the year. This can help you better understand and plan the seasonal patterns in your revenue.
The planner has the following options:
You can add a new revenue line via the hamburger ☰ icon in the left column. Using that dropdown menu you can also copy, move and delete rows.
Once you have entered all the necessary information, you can view the results in the columns Net Revenue and Gross Profit, and in the charts. This will give you a clear picture of your estimated revenues and margins for each revenue line.
Below is an overview of the information provided:
Once you are finished entering all details, click the Save button. Your budget will be saved right away. Your forecast is immediately included in all reports.
We hope that this helps you to understand how to use the Revenue Planner. Keeping track of your revenues, gross profit, and assumptions has never been simpler. If you have any further questions, please don't hesitate to reach out to our support team.