As the budget owner, you start the budgeting process by creating the budget workbook. This step is also referred to as the budget setup or budget configuration. The physical budgeting occurs after the workbook is created, using the workflow.
You base your budget on one of your Phocas databases, of which there are two key types:
Financial database - Contains financial data that comes from your financial statements, the Profit and Loss (income statement), Balance Sheet and Cashflow.
Operational database -Contains operational data such as sales, purchases, and inventory. This data has more detail, such as the sales breakdown (by customer, product, sales rep, channel), primary and secondary class products, pricing, expenses by provider, headcount numbers, payroll expenses, and so on.
You create both types of budgets in the same basic way, however, there are a few different steps, so they are outlined in separate sections below. In both setup screens, the settings are organized into tabs, in which many options are automatically selected for you, to save you time.
(Financial budgets only) Ensure your Profit and Loss statement categorization is complete.
Get a clear understanding of how your organization currently budgets, and at what level of detail, then consider if you want to make changes to the current process. It is best to plan how you want to structure your budget before you create it. Right after you create the budget, you have the chance to change the workbook setup but when you edit any of the budget values, you will not be able to make many changes to the workbook setup.
Identify who needs to access the budget. All users who access the budget also need access to the Financial Statements module (to some degree) and permission to access the underlying database.
You can create a budget from two locations:
On the Budgets and Forecasts homepage, in the top-right corner, click Create budget.
Within a budget, in the top-left corner, click Budget > Create budget.
If you don’t see either of these options, it means you don’t have permission to manage Budgets and Forecasts.
What happens next depends on your database access. If you have access to both types of databases, the Create budget screen displays, in which you need to select which type of budget you want to create. If you only have access to one type of database, you skip the Create budget screen and go directly to the workbook setup screen for that type of database.
Financial budget
Enter a name for the budget. For example, Budget 2024.
Select the database on which to base the budget. This setting determines where the budget data and structure comes from. A default database is selected for you but you might have other financial databases to choose from.
Select the template to apply to the budget. This setting determines the layout of the budget. A default template is selected for you but you might have other options to choose from, depending on the types of Profit and Loss statements your organization has created in the Financial Statements module.
Change the budget owner, if required. By default, you are the budget owner, as you are creating the budget. Typically, you would leave this as is but you can select another user if you want to delegate the workflow management to them. Learn more about the types of users in Budgets and Forecasts.
Add other budget administrators, if required. By default, you are a budget administrator, as you are creating the budget. You can add other users as administrators to help you manage the workflow. Ensure the selected administrators have full access to the database on which the budget is based.
Click Next.
Select the period type for the budget: Year, Month or Custom (such as Quarterly).
Select the start and end dates for the budget period. For example, from April 2023 to March 2024. You can create a budget up to -3 years from the current date.
Set the measure format to determine how the measures (numerical values) display in the grid.
Select the baseline data structure for the budget:
Stream - Fill the budget with values from an existing stream of data in the database, as a starting point that you can later adjust. For example, you could use your current year's actuals or the previous year’s budget values.
Zeros - Fill the budget with zeros ($0.00), so you can start with a clean slate.
Change the default Stream settings, as required:
Baseline (stream 1) - The available options correspond to the streams that have been added to the database. You might prefer to select a different stream if its structure better matches the new budget you want to create.
Measure - The available options correspond to the measures in the database, such as Local Value or Reporting Value.
Offset (applicable to stream values only) - If you're budgeting by year, the offset defaults to -1 and if you’re budgeting by month, the offset defaults to -12 but you can change this offset as required. For example:
If you're creating a budget for the period of April 2022 to March 2023, the actuals will be for the 12 months commencing April 2021 (the budget for April 2022 will include April 2021 data). If, for example, you want to build a budget based on an existing budget stream, you could select an offset of 0.
If you’re partway through the year and therefore, your actuals don’t yet include the entire year’s data, you’ll see a warning note telling you the actuals are slightly out of range. Any months not yet completed will populate with zeros in the workbook. For example, if you are currently in November 2020, the December 2021 budget will populate as zeros because December 2020 currently has no activity. You do not need to take any action here. When you get to the workbook, you can enter data manually in the zeros cells, copy forward data from the other months as a starting point, or use a comparison row to reference another stream.
Click Next.
The hierarchy settings determine how many levels of data are in the budget and how those levels are ordered. In other words, the hierarchy determines how the various dimensions in the database are grouped in the budget. The highest level (dimension) is always the Profit and Loss Category, which includes items such as Revenue and Expenses. The lowest level, where the workflow sits, is always the General Ledger account. You can leave the default hierarchy as it is, or add levels and apply filters, as required.
You have the option to filter the levels in the budget or apply a filter to the whole hierarchy. So rather than have one large budget, you could create multiple, smaller budgets instead, then publish each one to the same stream.
(Optional) Add a level: Click Add level and select the dimension you want to add as another level in the budget hierarchy. You can add up to four additional levels to sit between the highest and lowest levels. The maximum number of levels any budget can have is six. If you do not add levels now, you can add more levels later.
(Optional) Apply a level filter: Click the Filter dimensions button next to the level and select the entities you want to include, then click out of the entity list to apply your selection.
(Optional) Apply a budget filter: Select the Filter… checkbox > select the dimension that you want to filter (you can't select one that’s been added as a level) > select the entity you want to use as the filter > click out of the window to apply your selection.
Click Save and finish.
Operational budget
Enter a name for the budget. For example, Budget 2024.
Select the database on which to base the budget. This setting determines where the budget data and structure come from. A default database is selected for you but you might have other operational databases to choose from, such as a Sales or Purchasing database.
Change the budget owner, if required. By default, you are the budget owner, as you are creating the budget. Typically, you would leave this as is but you can select another user if you want to delegate the workflow management to them. Learn more about the types of users in Budgets and Forecasts.
Add other budget administrators, if required. By default, you are a budget administrator, as you are creating the budget. You can add other users as administrators to help you manage the workflow. Ensure the selected administrators have full access to the database on which the budget is based.
