Skip to main content

P×Q (Price × Quantity)

The P×Q module forecasts product sales revenue by modelling each product as a set of sales channels, each with its own price and quantity per month. It's designed for businesses where revenue is volume-driven and can be expressed as units sold at a given price.

When to use P×Q​

Use this module when:

  • You sell products or services at a per-unit price
  • Your revenue model can be decomposed into: how many units × at what price
  • You have multiple sales channels with different pricing
  • You want to feed sales volume into the COGS module for margin modelling

Creating the module​

  1. In your Scenario, click Add a budget
  2. Choose PxQ
  3. Follow the setup wizard (4 steps)

Step 1 — Introduction​

An overview screen of how the P×Q module works. Read if necessary and continue to the Model step.

Step 2 — Model​

Budget range​

Set the start and end month for your forecast. Defaults to the entity's YTD start → YTG end.

Products​

Add each product you want to forecast (e.g. "Software License", "Support Package", "Hardware Unit"). There are three ways to populate products:

  • Manually — click Add product and enter a name
  • From an existing P×Q budget version — loads all products and channel data from a previous version as a starting point
  • From an integration — imports your product catalog from a connected inventory integration. Product names imported this way are locked and cannot be edited.

Revenue channels​

Each product can have one or more revenue channels — the different routes through which it's sold. For example:

  • Product: "Software License"
    • Channel: "Direct Sales" (€800/unit)
    • Channel: "Reseller" (€600/unit)
    • Channel: "Online" (€500/unit)

Revenue channels are global — they are defined once and shared across all products. Manage them in the Channels tab in the Model step. Each channel needs a name. You cannot delete a channel if only one remains.

A product can subscribe to any number of channels. To assign the same set of channels to all products at once, use the Copy channels to other products option in the overflow menu on any product card.

Entering price and quantity​

Each product × channel combination shows a monthly grid with three rows:

  • Quantity — units sold per month (editable per cell)
  • Price — unit selling price per month (editable; editing a price fills all subsequent months with the new value)
  • Total — price × quantity, calculated automatically (read-only)

Each channel row has a settings button that opens a calculation modal where you can apply growth patterns and distribution methods (Linear, Equally spread, Seasonality) to the quantity values — the same controls available in Simple Budget.

Step 3 — Mapping​

Assign budget accounts per revenue channel. Map all channels to a single "Revenue" budget account, or assign each channel or product to a dedicated account for granular P&L reporting.

Analytical axis assignments can further break down revenue by region, team, or entity if your accounting uses dimensions.

Step 4 — Result​

Review the monthly revenue forecast per product and channel, with comparison against actuals where available.

Integration with COGS​

If you also use the COGS module, it can reference P×Q quantities to calculate variable costs automatically. When P×Q quantities change, COGS recalculates — keeping your gross margin forecast consistent without double entry.

Output in reports​

P×Q feeds your P&L revenue lines. The Revenue dashboard breaks down revenue by product and channel, with budget vs. actuals comparison.