Importing actuals in the Budget Tree screen

You import P&L Actuals into the Budgeting application to compare actuals against your budget. Financial officers and administrators typically import P&L actuals once a month, after the prior month's financials have been finalized. Importing P&L Actuals allows you to generate a flex budget so that you can evaluate your budget performance based on your assumptions.

Note: Flex budgets are used to analyze and compare your actual volumes and units against your budget assumptions. After recalculating based on these assumptions and actuals, flex budgets can potentially highlight flaws in budgeting methodology and/or operations.

  1. In the upper-left corner of the screen, select Access your applications ( main menu icon ).
    The menu expands.

  2. Select Financial > Budgeting.
    The Budgeting Dashboard screen appears.

  1. Do one of the following:

    • To access a specific line from the Budgeting Dashboard:

      • In the left pane, double-click a line. 
        The Budget Tree screen opens to the selected line in the budget tree structure. The section of the budget structure appears partially expanded to display all totals at the same level in the tree menu.

    • To access the Budget Tree screen: 

      • From the Budgeting menu pane, select Budget Tree (  ).
        The Budget Tree screen appears.

  1. From the Working Dataset drop-down list, select Actuals for the year with which you are working.
    The Re-Calculate button is replaced by an Import Actuals button.

    Note: You can import P&L Actuals only if Actuals is selected as your Working Dataset.

  2. Select Import Actuals.
    The Import Actuals dialog box appears.

    Fields on the Import Actuals dialog box

    Field Description Notes

    Select Year and Period

    Select the year and period for which to import P&L actuals.

    Required.

    Type

    Select the type of dataset into which you are importing.

    Note: You should typically select actuals.

    Required.

    Default: Actuals

    Upload Files

    Add files to import.

    Either drag files into the section or select the section to open a file manager window.

    Cancel

    Closes the dialog box without applying your changes.


    OK

    Applies your changes and closes the dialog box.


  3. From the Select Year and Period drop-down list, select the year and period.

  4. From the Type drop-down list, select the type of dataset into which you are importing.

  5. To add a file, do one of the following:

    • Drag files into the Upload Files section.
      or

    • Select the Upload Files section and select files from the resulting file manager window.

  6. Select OK.
    The files are added.