Using the Revenue Planner

Purpose

The Revenue Planner enables you to create a zero-based budget for your revenues, Cost of Sales (COS), and gross margin. You plan by year and by company; Revenue type is now defined per individual revenue line.

Context

Use this model to forecast revenue by customer, product, or service. Revenue type determines which general ledger accounts are used (depending on your configuration in Budget Settings). Tracking 1 is optional and can be used as an additional dimension (for example, channel or region) if it is enabled. All other functionality remains the same as before.

Steps

1. Open Essentials → Forecast and select Revenue Planner.
2. In the field next to Run, select the Year and Company. (Revenue type is no longer a model selection.)
3. Click Run to load the latest version of your revenue budget.
4. Enter values in the following fields for each revenue line:
   • Customer — the customer or revenue source.
   • Description — any assumptions or details for the forecast line.
   • Revenue type — select from a dropdown list. Each Revenue type automatically links to the correct revenue and COGS accounts as defined in your Budget Settings.
   • Price and Units — define the base revenue calculation.
5. Click More on any line to enter additional details:
   • Discount % — deducted directly from Gross Revenue to calculate Net Revenue.
   • COS % and/or COS per Unit — define Gross Profit.
   • VAT% and Cash delay — control the timing of cash inflows and outflows in the Cashflow Forecast.
   • Tracking 1 (optional) — select a value if this extra dimension is available in your setup.
6. Distribute your revenue across the year using the Planner:
   • Per month – equal monthly amounts.
   • Per quarter – equal per quarter.
   • Start of year / Mid of year / End of year.
   • Incline – increasing over the year.
   • Decline – decreasing over the year.
   • Summer – higher in summer months.
7. To define a custom pattern, click Edit. You may enter absolute monthly amounts or relative weights.
8. Use the ☰ menu in the left column to add, copy, move, or delete rows.
9. Review results in Net Revenue, Gross Profit, and charts. Click Save to store your budget. It becomes immediately available in all reports.

Examples

Example: You budget 100 units at €50 per unit for a specific customer. You expect a 10% discount, 20% COS, and a 30-day Cash delay.

• Net Revenue = €50 × 100 × (1 − 10%) = €4,500.
• Gross Profit = €4,500 − 20% COS = €3,600.
• Revenue type is set per line (e.g., “Subscriptions”), determining which general ledger accounts are used in Budget Settings.
• Tracking 1 may be left empty if not relevant.

Common mistakes & tips

• Revenue type no longer a model selection: set this per line, not at the Run level.
• Check Budget Settings: confirm which ledger accounts are linked to each Revenue type.
• VAT & Cashflow: incorrect VAT% or Cash delay can distort cashflow projections.
• Double-counting COS: use either COS % or COS per Unit, unless you intentionally combine both.
• Tracking 1 optional: only use if the dimension is active and relevant.

Related articles & videos

• Company settings
• Videos: getting started