1. NetSuite Enterprise Performance Management
  2. NetSuite Planning and Budgeting
  3. Planning and Budgeting Financials
  4. Planning and Budgeting Financials User Guide
  5. Financial Statements
  6. Working With Financial Statements
  7. Working With the Balance Sheet Trending Reports
  8. Submitting Final Adjustments to the Balance Sheet

Submitting Final Adjustments to the Balance Sheet

Use the Balance Sheet Movement Adj form to submit final Forecast adjustments to the Balance sheet for open periods. In the Balance Sheet Movement Adj form, enter Forecast values for movements of additional Balance Sheet Accounts, either manually or by selecting trend-based drivers.

When you save the form, the forecasted monthly movements are balances by a "Cash – Plug" Account.

To enter the predicted monthly movements or make final adjustments to the Accounts Receivable, Payable, and Inventory monthly movements:

  1. From the Home page, go to Financials > Balance Sheet Trending.

  2. Click Balance Sheet Movement Adj.

  3. In the Point of View, choose a Version, Subsidiary, and Currency.

  4. Review and analyze the projected monthly movements for the Accounts Receivable, Inventory in Stock, and Accounts Payable – Trade Accounts.

    Note:

    The monthly movement values for these Accounts come from the Days Sales Outstanding (DSO), Days Inventory Outstanding (DIO), and Days Payable Outstanding (DPO) forms.

    If you make final changes to the monthly movements for these Accounts, those changes update the Monthly Movement and Closing Balances on the DSO, DIO, and DPO forms. Any subsequent changes that you make to the DSO, DIO, and DPO forms will overwrite the Balance Sheet Movement Adjustment form.

  5. To forecast for the Balance Sheet Movement on an Account, click the arrow in the cell that intersects the relevant Account row and the Trend Movements column.

  6. Select the trend based on historical data, or select Manual to manually enter Forecast values.

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

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

  9. Make any final adjustments to the highlighted rows as necessary.

  10. (Optional) To review monthly movements at the Account level, click an Account to highlight the row. Then, right-click the Account and select Balance Sheet Detail.

    The Balance Sheet – Account Detail form opens in a new tab and displays the Opening Balance and Monthly Movements for all Subsidiaries.

  11. Click Save.

  12. (Optional) To update the Balance Sheet with the adjusted data, right-click the data grid and select Aggregate to Balance Sheet. The form fills with data in the input currency.

  13. (Optional) To update the relevant financial statements in both 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