Skip to main content

Import and generate new budgets

Budgets can be done manually, imported or created on previous data. One way to access this is to right-click on the Nominal Accounts icon and select Budgets.
​
This guide will cover the methods to import, create and use previous data to generate a budget. Alternatively it is possible to create budgets manually

  1. On the Nominal Ledger, select the Budgets icon.

  2. In the bottom half of the window, right-click and select Generate New Budgets.

  3. Select a Data Source, the options are:

    • Actuals

    • Budget: To increase or decrease based on a flexing percentage.

    • Spreadsheet: Please user the spreadsheet template and guidance.

    • Components: This uses the Master/Component build relationships.

    • Unused Budget: Which uses the shortfall of the actuals against the budget.

  4. Select the Year and Periods the Upload is for.

  5. If you chose Spreadsheet, target it in the Source (CSV) line.

  6. If there are any Header Lines before the values start, this can be entered.

  7. Select the value of the column Sub Analysis in Column is located.

  8. Select the column where Values Start in Column is located.

  9. If generating from a previous budget select the Budget Number.

  10. If generating based on a Budget or Actuals Data Source, type a value in Flexing Percentage.

  11. Enter the Budget Year you are wishing to Overwrite or Generate.

  12. Select the Budget Number you are wishing to Overwrite or Generate.

  13. Click Apply. A dialog appears.

  14. Select Yes to confirm the budget generation. The budget will then be, either, Overwritten, Imported or Created.

Did this answer your question?