Revenue & Expense Planning
      Back to home
      1. Help Center
      2. Plan
      3. Revenue & Expense Planning

      Product Revenue Planning using Custom Tables

      Custom Tables enable the use of non-financial data to plan Income Statement items like Revenue and to utilize multiple-step calculations in forecasting.

      This article presents 7 steps for planning Product Revenue by employing the Driver formula, calculated as Units # multiplied by Price $ Assumption, within a Custom Table.

      Step 1: Create a Custom Table

      1. Navigate to the Custom Tables section.

      2. Click Create New Table and name it "Revenue" (or another relevant name).

      Additional Resources:

      Step 2: Set Up Product Units

      1. Open your newly created Revenue table.

      2. Click Edit to customize the table.

      3. Create a new section labeled Units.

      4. For each product you want to track, add a line item. For example, name the first one Product 1 Unit.

      5. Input your expected unit values for each month in the table.

      Step 3: Link the Custom Table to the GL Account

      1. Return to your plan and open the Revenue GL account.

      2. Ensure Auto Forecast is turned off for this Account (it may be on for others by default) from Settings⚙️> Forecast > Auto-Forecast > Individual Account Settings:

      Additional Resources:


      Step 4: Define the Revenue Driver Calculation

      1. Click the three-dot menu in the Revenue account.

      2. Scroll down and select Percent of Another Account (this option can also handle percentages, money, or numbers).

      3. Choose the appropriate department (e.g., Sales and Marketing).

      4. Label this input Product Sales.

      Additional Resources:

      Step 5: Connect the Units from the Custom Table

      1. Under Input 1, scroll to Custom Tables and select the Revenue table.

      2. Choose Product 1 Unit to reference the units sold for the corresponding month.

      Step 6: Add and Save the Sales Price Assumption

      1. In the dropdown, create a new assumption labeled Product 1 Sales Price.

      2. Set the assumption type to Money.

      3. Click Save to confirm your changes.

      Step 7: Manage and Edit Assumptions

      1. Navigate to the Assumptions button to view and modify your assumptions at any time.

      2. The system highlights cells in yellow where assumptions are actively used for easier tracking.

      Additional Resources: