# Create a budget workbook {% hint style="info" %} * 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](/budgets-and-forecasts/contributor/use-workflows.md). {% endhint %} 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. {% embed url="" %} Create a budget workbook {% endembed %} {% hint style="success" %} Watch these other videos: * Phocas demo: [Create a P\&L budget in no time](https://www.phocassoftware.com/watch-demo/create-a-profit-and-loss-budget-in-no-time?autoplay=true) (brief overview) * PUG Training: [Budgets & Forecasts 101 – revenue](https://www.phocassoftware.com/customer/training-series/budgets-forecasts#sessions), [Sales budgeting](https://www.phocassoftware.com/customer/training-series/budgets-forecasts#session4), and [Demand planning](https://www.phocassoftware.com/customer/training-series/budgets-forecasts#session6) {% endhint %} ## 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](/budgets-and-forecasts/owner-and-administrator/create-a-budget/best-practices-for-efficient-budgeting.md) 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](/budgets-and-forecasts/getting-started/overview-of-key-terms-and-concepts/relationship-with-the-financial-statements-module.md), and consider creating a [custom statement](/budgets-and-forecasts/getting-started/overview-of-key-terms-and-concepts/relationship-with-the-financial-statements-module.md#custom-statements) 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](/budgets-and-forecasts/getting-started/overview-of-key-terms-and-concepts/overview-of-users-and-data-access.md) within the workbook. ## Getting started {% hint style="success" %} * Rather than create a new budget workbook from scratch, you can [clone an existing workbook](/budgets-and-forecasts/owner-and-administrator/clone-a-workbook.md) and use it as the foundation for a new workbook. * If you plan to have both operational and financial budgets, it's better to keep them in [separate workbooks](https://docs.phocassoftware.com/budgets-and-forecasts/owner-and-administrator/pages/DzJtZwhIlA8godVUocNp#id-3.-budget-creation-separate-operational-and-financial-budget-workbooks). Not only will this help improve performance, it'll prevent interdependencies and improve access control. {% endhint %} {% hint style="warning" %} Read the [Best practices for efficient budgeting](/budgets-and-forecasts/owner-and-administrator/create-a-budget/best-practices-for-efficient-budgeting.md) page before you start creating workbooks. {% endhint %} You can create both financial and operational budgets from two locations in Phocas:
Where you startBudget typeWhat 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. Set up the Profit and Loss statement for use with Budgets & Forecasts.
  2. 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**](/budgets-and-forecasts/getting-started/overview-of-key-terms-and-concepts/relationship-with-the-financial-statements-module.md#nested-calculation-rows) 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](https://docs.phocassoftware.com/budgets-and-forecasts/owner-and-administrator/pages/DzJtZwhIlA8godVUocNp#id-4.-budget-setup-general-tips). 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](/budgets-and-forecasts/getting-started/overview-of-key-terms-and-concepts/overview-of-users-and-data-access.md). 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**. {% columns %} {% column %}

Financial budget setup

{% endcolumn %} {% column %}
image-20240122-031905.png

Operational budget setup

{% endcolumn %} {% endcolumns %} ### Period and data tab {% hint style="warning" %} Note on 8 September: The **Period** tab in the workbook setup is currently being updated. The steps on this page reflect the new design, which you will see in your Phocas site tomorrow. The updates simplify setup by organizing the settings in a logical, step-by-step order. You'll notice renamed and repositioned settings, along with other improvements. See the [release note](/other-information/release-notes.md) for a comparison of before and after the changes. {% endhint %} These settings determine the structure of the budget and the data it contains. When you've selected the required period and data settings, click **Next**. #### 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**](/budgets-and-forecasts/owner-and-administrator/create-a-budget/period-types-in-budgets.md): **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 and row structure Choose the starting values and [dimension entity](/budgets-and-forecasts/getting-started/overview-of-key-terms-and-concepts/dimensions.md) rows. This can be data from a stream, or you can start with zeros. **Stream** Fill the budget with values from an existing stream of data in the database. * Choose the streams and periods that most closely match the budget period. The available options correspond to the streams that have been added to the database. * Click **Add baseline** to add up to three separate stream and period combinations. For example, you might want to use the Actual stream for the current year up until the most recent completed period, then use a Forecast stream or prior year actuals for the remaining. The diagram on the right of the date selector shows the period population. * The date range can be shorter than the budget period defined in 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. * You can [fix these baseline values](/budgets-and-forecasts/owner-and-administrator/fix-the-baseline-in-a-budget.md) later to stop them from automatically updating. A fixed baseline can also help with [performance issues](https://docs.phocassoftware.com/budgets-and-forecasts/owner-and-administrator/pages/DzJtZwhIlA8godVUocNp#id-4.-budget-setup-general-tips). **Zeros** Fill the budget with zeros ($0.00), so you can start with a clean slate. The streams and periods you choose determine the dimension entity rows that are included. Click **Add rows** to add up to three separate stream and period combinations. #### Additional row structure Choose streams and periods to add dimension entity rows that have no activity in the baseline value stream(s). For example, you might want to include: * Accounts that are only used at year-end and therefore, have no activity in the year-to-date actuals. * New customers or product lines that have been manually uploaded into a stream. #### 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](/budgets-and-forecasts/owner-and-administrator/customize-the-format-of-measures.md) to learn more about custom formatting. ### 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](/budgets-and-forecasts/getting-started/overview-of-key-terms-and-concepts/dimensions.md) 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](/budgets-and-forecasts/owner-and-administrator/manage-the-workflow.md) 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](/budgets-and-forecasts/owner-and-administrator/manage-the-workflow.md) 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. {% hint style="success" %} * Read the [Best practices for efficient budgeting](/budgets-and-forecasts/owner-and-administrator/create-a-budget/best-practices-for-efficient-budgeting.md) page to see how levels can impact performance. * If you add levels that don't exist in the baseline stream, the rows will contain [unclassified data](/budgets-and-forecasts/owner-and-administrator/create-a-budget/unclassified-data.md) (###” or suspense). * You can[ add more levels ](/budgets-and-forecasts/owner-and-administrator/add-more-detail-to-the-budget-or-forecast.md#add-a-level)directly into the budget later. {% endhint %} 2. Reorder the levels, if required: 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. 3. (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](https://docs.phocassoftware.com/budgets-and-forecasts/owner-and-administrator/pages/DzJtZwhIlA8godVUocNp#id-5.-budget-setup-workflow-at-a-higher-level). 4. Apply a filter, if required. Please see the [Filtered budget or forecast](/budgets-and-forecasts/owner-and-administrator/create-a-budget/filtered-budget.md) page for important information and detailed steps. There are two filtering options: * **Level filter** using the **Filter dimensions** button next to the level. * **Budget filter** using the **Filter data by a single entity within a dimension** checkbox. 5. (Operational budgets only) Exclude **### suspense items** in the budget. By default, this setting is selected, which means [unclassified items](/budgets-and-forecasts/owner-and-administrator/create-a-budget/unclassified-data.md) are included in the workbook. If you do not want to include them, clear the checkbox. {% columns %} {% column %}

Financial budget setup

{% endcolumn %} {% column %}

Operational budget setup

{% endcolumn %} {% endcolumns %} 6. 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](/budgets-and-forecasts/owner-and-administrator/create-a-budget/additional-measures-for-driver-based-budgeting.md) 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](/budgets-and-forecasts/getting-started/take-a-tour-of-budgets-and-forecasts/explore-the-budget-workbook.md) 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)](/financial-statements/managing-statements/create-a-budget.md) to see how the financial statement layout matches the financial budget setup.
2. [Edit the budget setup](/budgets-and-forecasts/owner-and-administrator/edit-a-budget-or-forecast-workbook-setup.md), 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. 3. [Fix the baseline values](/budgets-and-forecasts/owner-and-administrator/fix-the-baseline-in-a-budget.md), if required. 4. Proceed to add further detail to the budget workbook as required. For example, you might want to [add worksheet tabs](/budgets-and-forecasts/owner-and-administrator/add-worksheet-tabs.md) for your Balance Sheet and Cash Flow budgets. 5. Start the budget [workflow](/budgets-and-forecasts/owner-and-administrator/manage-the-workflow.md). --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.phocassoftware.com/budgets-and-forecasts/owner-and-administrator/create-a-budget.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.