Adjust account values - One-off adjustments

Note: This article explains how to perform a one-off adjustment. If you are working in a forecast, and need to make a dynamic adjustment which changes when other account values change in future, please refer to Dynamic rules.

With Spotlight Forecasting you can do a one-off adjustment for a single account, or for multiple accounts in the account category.  

  1. From the Customise Data tab, open the required section within the Profit and Loss tab. For example, Profit and Loss > Revenue.
  2. To adjust amounts for multiple accounts by account category, click the Adjust Accounts button at the top right-hand corner of the section, for example Adjust Revenue Account. Continue to step 3.
  3. To adjust amounts for a single account, click a cell on the account row and then click the adjust button to the right of the data cell. Continue from step 4.
  4. From the Apply Rule To drop-down list, select the accounts you want to adjust. By default, all accounts in the section are adjusted.
  5. From the Apply Adjustment To section, select you want to apply the adjustment:

    • All Months in Forecast - Adjust all of the months in the forecast date range. This is the default option.
    • Choose Dates - Adjust only the months in the date range you select.
    • By Month - Adjust each month’s value individually. When you choose this option, a box appears to adjust each month in the Amount to Adjust section.
  6. From the Amount to Adjust section, select one of the following adjustment options:

    Note: If you selected the By Month option in step 4, you must enter a value in each monthly box.


    • Apply fixed amount each month - Use the exact value you enter for all months and accounts selected in the previous steps.
    • Adjust by amount each month - Previous month plus adjustment - Apply your adjustment using the previous month’s amount as the starting point.
    • Adjust by amount each month - Previous year plus adjustment - Apply your adjustment using the equivalent month in the previous financial year as the starting point.
    • Adjust by amount each month - Existing month plus adjustment - Apply your adjustment using the existing month’s amount as the starting point.
    • Adjust by percentage each month - Previous month plus adjustment - Apply your adjustment using the previous month’s amount as the starting point.
    • Adjust by percentage each month - Previous year plus adjustment - Apply your adjustment using the equivalent month in the previous financial year as the starting point.
    • Adjust by percentage each month - Existing month plus adjustment - Apply your adjustment using the existing month’s amount as the starting point.
    • Adjust as a percentage of trading revenue each month - Adjust the selected accounts by a percentage of trading revenue each month.

      Note: Trading revenue accounts use the report code REV.TRA in the Customise Data tab. If required, you can change the report code of an account. To do this, click the existing report code, browse to the new code and then click Save.

  7. If required, enter any comments. These will appear under the History section on the Customise Data tab.
  8. To apply your adjustments, click Apply.

    Note: Applying the adjustment will overwrite any existing data, including data that has been updated as a result of other adjustments you’ve added.

Release Notes - Terms of Use - Privacy Policy - Launch Application - Copyright Spotlight Reporting 2018