1. NetSuite Enterprise Performance Management
  2. NetSuite Planning and Budgeting
  3. Planning and Budgeting Financials
  4. Planning and Budgeting Financials User Guide
  5. Operating Expense
  6. Working With OpEx Planning
  7. Entering the Operating Expense Forecast Values by Department

Entering the Operating Expense Forecast Values by Department

Use the OpEx by Dept form to enter departmental Forecasts. The OpEx by Dept form summarizes the operating expenses, in selected Currency, by Department using the NetSuite General Ledger accounts. Actuals appear next to Forecast values so that you can compare end-of-year and future-year projections side by side.

To enter the operating expense Forecast by Department at Account level:

Note:

To see the results of your changes, go to Financials > Income Statement.

  1. From the Home page, click the OpEx card.

  2. To open OpEx Planning forms, click the 1 tab on the left.

  3. Click OpEx by Dept.

  4. In the Point of View (POV), choose a Version, Subsidiary, Currency, and Department.

    Note:

    You can change the POV to review a single Department or total Department expense under child or parent subsidiaries.

  5. To update the Forecast value on an Account, click the arrow in the cell where the relevant Account row intersects the Trend OpEx column.

    Select the trend to use. Or, select Manual to manually enter Forecast values.

    Note:

    You can only enter Forecast values if you set trend to Manual or if the trend is blank. If you select a trend based on historical data, the Forecast values fill in automatically based on that selected trend.

  6. For Account members set to a trend, in the Adj (%) column, enter the percentage change as a decimal value. For example, enter 0.01 for a 1% increase or -0.01 for a 1% decrease.

    Warning:

    If you enter a percentage in the Adj (%) column for an Account set to Manual, the adjustment won't be applied.

  7. For Account members set to Manual, enter the Forecast values for each Forecast period. Or, in the Total column, enter the total Forecast value for the Forecast periods for the relevant financial Year.

    Note:

    If there are no previous values in the data grid for the Account row, the total spreads evenly over the periods. If previous values exist, the total spreads proportionally.

  8. (Optional) To see more details of a specific Account, click the Account to highlight the row. Then, right-click the Account and select Drill to Account Details.

  9. Click Save.

    Warning:

    You might encounter performance issues if the OpEx by Dept form is saved when the Department dimension is set to Total Department.

  10. To update top-level members with the adjusted data in input currency, right-click the data grid and select Aggregate to Income Statement.

  11. (Optional) To update the relevant financial statements in the input and reporting currencies:

    1. Go to the Home page and click the Rules card.

    2. Beside the ruleset NFS_All Accts Forecast Data Refresh, click the Launch arrow.

Related Topics

General Notices