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. From 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 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:
-
From the Home page, go to Financials > Balance Sheet Trending.
-
Click Balance Sheet Movement Adj.
-
In the Point of View, select a Version, Subsidiary, and Currency.
-
To apply the changes, click the Go icon
. -
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 derive 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, the changes push back to the Monthly Movement and Closing Balances on the DSO, DIO, and DPO forms respectively. Subsequent changes that you make to the DSO, DIO, and DPO forms will overwrite the Balance Sheet Movement Adjustment form.
-
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.
-
Select the trend to use based on historical data or select Manual to manually enter Forecast values.
-
(Optional) For Accounts set to a trend, enter the percentage increase or decrease as a decimal value in the Adj (%) column. For example, enter 0.01 for a 1% increase or -0.01 for a 1% decrease.
-
For Accounts set to Manual, enter the Forecast values for each Forecast period. Alternatively, enter the total Forecast value for the Forecast periods in the Total column for the relevant financial Year.
-
Make any final adjustments to the highlighted rows as necessary.
-
(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.
-
Click Save.
-
(Optional) To populate the Balance Sheet with the adjusted data, right-click the data grid and select Aggregate to Balance Sheet. The form populates with data in the input currency.
-
(Optional) To have your changes reflected in the relevant financial statements in the input and reporting currencies:
-
Go to the Home page and click the Rules card.
-
Beside the ruleset NFS_All Accts Forecast Data Refresh, click the Launch arrow.
-