Create a budget workbook

Start the budgeting process by creating a budget workbook.

  • User permissions: Budgets & Forecasts and Manage Budgets & Forecasts

  • The budget creation process is also referred to as the budget setup or budget configuration. The physical budgeting occurs after the workbook is created, using the workflow.

Each budget workbook is based on a Phocas database. There are two types of databases, and therefore two types of workbooks:

  • Financial workbooks connect to a financial database and are structured in the form of a Profit & Loss statement.

  • Operational workbooks connect to a database containing operational data such as sales, purchases, and inventory. They're used for planning activities outside of financial reporting and can have a flexible structure, for example, 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.

Create a budget workbook

Prerequisites

Before you create your first budget workbook, make sure you:

  • Plan the budget structure: Ensure you understand how your organization currently budgets and at what level of detail. Decide whether to keep the current approach or introduce changes. It's best to define the structure before you create the workbook. After you create the workbook, you can adjust the setup. However, once you edit any budget values, most setup changes will cause data loss. See the Best practices for efficient budgeting page for guidance.

  • (Financial workbooks only) Complete Profit and Loss categorization:

    • Make sure your Profit and Loss statement is fully categorized.

    • Learn about how the Financial Statements and Budgets & Forecasts modules interact, and consider creating a custom statement for budgeting and forecasting.

  • Identify access needs: Users who need access to a budget workbook must also have access to the Financial Statements module and permission to access the underlying database. You can then assign the appropriate level of access within the workbook.

Getting started

You can create both financial and operational budgets from two locations in Phocas:

Where you start
Budget type
What happens next

Budgets & Forecasts Either: • On the Budgets & Forecasts homepage, click Create budget in the top-right corner. • Within an existing budget, click Budget > Create budget in the top-left corner.

image-20240404-020132.png

Financial and operational

Depends on your database access:

  • If you have access to one type only, you skip the Create budget screen and go straight to the setup screen for that type.

  • If you have access to both types of databases, the Create budget screen displays, where you choose the budget type.

image-20240122-031813.png

Financial Statements

  1. Click Budgets > Create budget to automatically create the budget*.

*This is often referred to as the one-click budgeting method. See Create a budget (Financial Statements) for more information. See the Budget by region and branch page for a use case.

Financial

This method skips the manual setup outlined below, so you can jump straight to the Next steps section.


Budget setup

The setup process is the same for both financial and operational budgets, with only a few differences noted in the steps below. The settings are grouped into tabs, with many options automatically selected for you to save time.

Workbook configuration tab

  1. Enter a name for the budget workbook. For example, Financial Budget 2026 or Sales Budget 2026.

  2. 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 others to choose from.

  3. (Financial budgets only) Select the Profit and Loss statement. This setting determines the layout of the budget. A default statement is selected for you, but you might have others to choose from if your organization has created them in the Financial Statements module.

  4. (Financial budgets only) Show or hide nested calculations as required. This setting determines whether nested calculation rows are shown in the budget or not. These calculation rows come from the selected statement. By default, Hide is selected, which means you'll only see the top-level calculation values in the budget. If you want the calculation rows to be expandable, so you can see the nested derived rows underneath, select Show. However, bear in mind that this introduces more data into the budget workbook, which might have a negative impact on performance.

  5. 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 & Forecasts.

  6. 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.

  7. Click Next.

Financial budget setup

image-20240122-031905.png
Operational budget setup

Period and data tab

These settings determine the structure of the budget and the data it contains.

Budget period

Choose how the budget is split over time. Each time unit in the budget period is represented by a column in the grid.

  1. Select the Period type: Year, Month or Custom (such as Quarterly).

  2. Select the Start and End dates. For example, from April 2025 to March 2026. You can create a budget up to -3 years from the current date.

Baseline values

Choose the starting values for your budget rows. This can be data from a stream, or zeros.

  • Stream: Fill the budget with values from an existing stream of data in the database, as a starting point that you can later adjust.

    • By default, the Stream and Start and End dates match the stream and date range used in the Budget period above. You can change them to bring in different values if required. For example, you might want your budget to look like it did last year (same row structure), but have baseline values from a different period.

    • The date range can be shorter than the budget period defined the Period setup above. For example, if the budget period is 12 months but the baseline values only cover 4 months, zeros are inserted for the remaining 8 months.

    • Cell values will remain linked to the selected stream(s) until they are overwritten during the budgeting process.

  • Zeros: Fill the budget with zeros ($0.00), so you can start with a clean slate.

The ability to use multiple streams and date ranges is coming soon. For example, if you're budgeting by month in one year, but you only have Actuals data for 10 months, you can add another stream (or period in the same stream) to bring in the other two months of data instead of having zero values in the budget.

Row structure

Choose how the budget is structured. Each stream defines the rows in the budget.

  1. Select the Stream.

    • By default, the stream matches the stream and date range used in the Baseline values above, bout you can change it. The available options correspond to the streams that have been added to the database. For example, you could use your current year's actuals or the previous year’s budget values. If you imported a budget file, it will display in this list.

    • You can fix these baseline values later to stop them from automatically updating. A fixed baseline can also help with performance issues.

  2. Select the Start and End dates.

    • By default, these settings match the Budget period above, but are offset by one budget cycle (for example, 12 months in a yearly budget). Example: If your budget period is April 2025 to March 2026, the actuals will cover April 2024 to March 2025. The April 2025 budget values will include April 2024 actuals. If you want to build a budget based on a different stream (for example, an earlier budget), you can adjust the start date.

    • If you're partway through the year, the actuals might not yet include a full year of data. In this case, a warning appears to let you know the actuals are slightly out of range. Any incomplete months populate with zeros in the workbook. Example: If today is November 2025, the December 2026 budget period populates with zeros because no activity exists yet.

    • You don't need to take any action here. In the workbook, you can enter data manually in the zero cells, copy forward data from the other months as a starting point, or use a comparison row to reference another stream.

The ability to use multiple streams and date ranges is coming soon.

Measure settings

Choose how to format the numerical values in the budget grid. You can use the default formatting for the selected measure or apply a custom format by setting a prefix, number of decimal places, and suffix.

The available options match the measures in the database, such as Local Value or Reporting Value.

See the Customize the format of measures to learn more about custom formatting.

When you've selected the required period and data settings, click Next.

Hierarchy and filters tab

These 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. You can leave the default hierarchy as it is or customize it to suit your needs. For example, you can add more levels of detail or apply filters. Many of these settings are optional:

  1. Add levels:

    • In a financial budget, the highest level is always the Profit and Loss Category dimension, which includes items such as Revenue and Expenses. The workflow sits at the lowest level, which is typically the Account dimension. You don't need to do anything here, but 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.

    • In an operational budget, you must select the dimension you want to add, such as Region, Branch, or Sale Rep. By default, the workflow sits at this level, unless you add other levels. You can add up to five additional levels to sit under the highest level. The maximum number of levels any budget can have is six.

  1. Reorder the levels: If you add multiple levels, the order in which they display here determines the order they display in the budget, from highest to lowest level. Click the Move button on a dimension level, then drag it above or below the other level(s) to the new position as required. Remember, in a financial budget, the workflow sits on the lowest level.

  2. (Operational budgets only) Select where the workflow sits: Select the Workflow button on the applicable level. Often, it's better to set the workflow at a higher level in the hierarchy.

  3. Apply a filter:

    1. 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.

    2. Budget filter: Select the Filter the tab by a single entity within a dimension checkbox, then select the dimension that you want to filter (you can't select one that’s been added as a level) and select the entity you want to use as the filter.

  4. (Operational budgets only) Exclude ### suspense items in the budget. By default, this setting is selected, which means unclassified items are included in the workbook. If you do not want to include them, clear the checkbox.

Financial budget setup
Operational budget setup
  1. Proceed as applicable:

    • For a financial budget, the setup is now complete. Click Save and finish.

    • For an operational budget, click Next to proceed to the Additional measures tab where you can define additional measures to drive the budget data, if required. There are several options available, and this part of the setup can be a complex task, so read the Include additional measures in the workbook page for detailed information. Click Save and finish when you're ready.


Next steps

After you complete the budget setup, or automatically create and set up a budget via Financial Statements, you should consider taking the following actions:

  1. Explore your new budget workbook to become familiar with its key elements and features. Expand the tip below to see how the budget setup corresponds to the output.

Tip: Learn how the workbook setup impacts the workbook layout and contents...

After you create a budget workbook, it opens on the Main worksheet tab. The layout and contents of the budget are determined by your setup. In the case of a financial budget, the budget is displayed in the Profit and Loss template that you selected, as illustrated in the image below, where the colors match the setup settings with the corresponding workbook elements.

See Create a budget from within a financial statement (one-click budgeting) to see how the financial statement layout matches the financial budget setup.

  1. Edit the budget setup, if required, before you edit any of the budget values. For example, you might want to add or remove a level. Also, if you automatically created the financial budget, you’ll probably want to change the following items at least:

    • Name: This automatically generated name is Profit and Loss created [date], where the data is the date and time the budget was created. You might want to replace this with something more descriptive, such as Budget by Region and Branch 2025.

    • Period: The date range comes from the current period of the financial statement. Typically a budget looks at the time ahead, so you’ll probably want to change this current period to a future one and use the offset option. For example, enter an offset of -12 to use the previous year's actuals (January to December 2024) as the baseline.

  2. Proceed to add further detail to the budget workbook as required. For example, you might want to add worksheet tabs for your Balance Sheet and Cash Flow budgets.

  3. Start the budget workflow.

Last updated

Was this helpful?