![]() If you selected the Stream option in the previous step, adjust the default Baseline, Measure and Offset settings, as required.īaseline stream - By default, Actual (Profit and Loss) is selected but you can select another stream. Zeros - Populate the budget with zeros, so you can start with a clean slate. For example, you could use your current year actuals from your Financial database or the previous year’s budget. Stream - Populate the budget with values from an existing stream of data, as a starting point that you can later adjust. Select how you want to populate the budget initially: Stream or Zeros. You only have the custom option if these custom periods exist in your Financial Statements, for example, quarterly.įor example from April 2022 to March 2023. On the next screen, select the period type for the budget: Year, Month or Custom. The maximum number of levels any workbook (or worksheet within a workbook) can have is six. ![]() See Create and publish filtered workbooks for more information on this method of budgeting.ĭepending on how many levels you add here, you might be able to add more levels when your budget workbook is created. This feature allows you to create separate budgets for a dimension. It is possible to apply a filter to a level. The last level determines where the workflow sits. You cannot change these two levels but you can select up to four additional levels from your Chart of Accounts, to sit between the category and account levels.įor a non-financial budget, such as a Sales database, the first level (dimension) can be whatever you want, such as Region, Branch, Sales Manager or Customer Group. Expand the tip above for an example.įor a financial budget, the first level (dimension) will always be the Profit and Loss category, such as Income or Revenue, and the last level will always be a General Ledger account code (this is where the workflow sits). how the various dimensions are grouped in your workbook. This setting determines how your budget levels are ordered, i.e. Select the budget hierarchy levels for the dimensions, including any filters. *Unclassified items always display workbooks based on a financial database. If you do not want to include these items, clear the checkbox. ![]() By default, this setting is selected for you, which means that unclassified items will display in the workbook. This feature was released in version 2 on 7 June 2022 and displays only if you are creating a workbook based on a non-financial database*. Leave the Include # suspense items in the budget checkbox selected, if applicable and required. If you want to use the old grid, clear the checkbox. By default, this setting is selected for you. The new grid provides optimal performance and support for the creation of very large budgets. This feature was released in version 2 on 7 June 2022. Leave the Use new grid checkbox selected, if required. It is recommended that administrators have full access to the databases that makes up the budgets. You can add users as administrators to help you manage the budget data entry and workflow. This setting defaults to you, as you are creating the budget. Typically, you would leave it as is, but you can select another user, if you want to delegate the task to them. If your organization only uses one Profit and Loss template, it will be applied by default. The options available depend on the types of Profit and Loss statements your organization has created in the Financial Statements module. This setting determines the layout of the budget. If you selected a finance database in the previous step, select the Profit and Loss (P&L) statement template to apply to the budget. However, you might also have other options, such as a Sales or Purchasing database. As the Budgets and Forecasts module is based on the Financial Statements module, there will always be a financial database option. The options available depend on whatever is in your organization's EDA database. Select the database on which to base the budget. In the Budget setup: Workbook configuration window, enter a name for the budget. If you don’t see this option, it means you don’t have permission to manage Budgets and Forecasts.Ĭlick the New drop-down button, then click Budget workbook. Click the Actions menu button, then click Budgets and Forecasts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |