Skip to main content
Budgets

How to create and customize a budget on Syft

Nikhita avatar
Written by Nikhita
Updated over a week ago

Who can use this feature

Roles: Owner, Admin, Staff and optional on custom roles

Plans: Available on Standard, Plus, Advanced and Scale (with more advanced features only on Plus, Advanced and Scale)

About budgets

A budget is a tool to track when and how you earn or spend money. Creating a budget is an important part of your overall success and security as it allows you to oversee and better understand whether your business has enough revenue to pay its expenses. Using a budget can help you make more informed financial decisions.

Budgeting is an ongoing process rather than a one-time exercise because your business revenue and expenses could change at any time. It may be worth revisiting and reworking your budget monthly, quarterly, or after changes to your business, such as big expenses, occur. This will help you stay on track to achieve your goals.

When to use a budget

A budget sets the expectations within which a business will operate – it creates financial stability since it sets a plan for the future. Business typically set expectations for revenue and expenses, i.e. what you expect to earn and what you expect to spend. If a business tracks against its budget, it will be expected to make a profit. Typically businesses create a budget for a planning period such as a financial year.

Syft's budgeting feature allows you to create an integrated budget across the profit and loss statement, balance sheet, and KPIs as well as non-financial data from Connections. Building a budget in Syft ensures that all financial statements are linked; any impact to your profit and loss statement will carry through to the balance sheet and KPIs (and vice versa).

A budget sets expectations for a business's operation, creating financial stability and a performance benchmark. Businesses usually set revenue and expense expectations for a planning period, like a financial year. Tracking against the budget helps ensure profitability and allows for adjustments when necessary to stay on target.

How to create a budget

Let's get started with your first Budget. Navigate to "Forecast" on the left-menu bar and then select "Budget". You'll land on the Budget dashboard. Now click "Add Budget" and you'll be prompted to setup your first Budget.

  1. Select a name and description. It's useful to give your budget a description so that you can create multiple budgeting scenarios for the same period.

  2. Select a start and end date. Budgets can be from 1 month to 10 years (but are typically 1 year).

  3. Select a budgeting interval. Interval options are either monthly, quarterly, or yearly. If you create a monthly or yearly budget, you'll still be able to download it in a condensed, annual view.

  4. Select the data for your budget under budget using. There are five methods to create a starting point for your budget. "Last period" and "Last value" use historical data while "Seasonality" and "Trend" apply a budgeting approach. You can also start with "Zeros". All methods serve as a starting point for your budget and are fully editable.

There are a few advanced options that you can either leave as default or ignore on setup.

  • Choose data to populate your budget with. The ability to choose data means you can choose both what data to include and what data to exclude. In other words, you can exclude any data that you don't think will be useful in your budget. For example, the pandemic led to unprecedented figures. Whether your business struggled to stay afloat or suddenly took flight, the numbers from 2020 or even 2021 may not be the most useful in the case of budgets looking into a post-COVID world. If you'd like to use 2019's actuals instead of figures from the last two years, you can do so.

  • You can create a budget at the divisional level (tracking category, class, or analysis code) and then compare actuals to budgeted data for each division.

Choosing a starting point

There are five methods to create a starting point for your budget:

  • Last period: Populates the budget with historical data from the last period repeatedly. For example, "Sales" for Oct 2021, Oct 2022, etc. would use actuals from Oct 2020. Similarly, "Sales" for Q3 2021, Q3 2022, etc. would use Q3 2020.

  • Last value: Populates the budget with historical data using the last value where data exists. For example, if the entity has data up until Jan 2020 then the budget will populate all accounts using Jan 2020 values.

  • Seasonality: Populates the budget using the median year versus year growth rate over the past two years. For example, "Sales" for Oct 2021 would be equal to actual "Sales" from Oct 2020 multiplied by the median annual growth rate for "Sales".

  • Trend: Populates the budget using the median month versus month growth rate over the past two years. For example, "Sales" for Oct 2021 would be equal to actual "Sales" from Sep 2021 multiplied by the median monthly growth rate for "Sales".

  • Zeros: This means that you can build your budget with a profit and loss statement that starts from scratch. The balance sheet will remain the same, but your P&L will essentially be a clean slate.

If you want your budget to start with historical data or "flat" data, we suggest using the last period or last value methods. Budgeting adjustments (which are discussed in the next section) will be more apparent under these methods. Seasonality and trend methods are useful if you want a quick budget or don't have many adjustments to make to your budget.

If Trend or Seasonality options are used to create the budget, the calculation is only applied to the Sales account whilst all other line items are then kept in proportion to the Sales account.

📓 Note

Seasonality is the preferred method for stable entities with more than 2 years of data while trend is preferable for newer or high-growth entities.

In "Analyze" you can compare actual figures to your budget, either against the total budget or specific periods within it.

💡 Pro tip

We recommend using the monthly budget interval. You can always roll this into quarters at a later stage.

Budget layout

Budgets have total columns that can be optionally added on creation or edit. This mimics the behaviour when you download a budget to Excel. Please note that only monthly budgets can add these total columns since they appear every 12 months.

Budgets have their own saved layout configuration for hiding or showing line items. This is shared across the P&L and BS in the item and is initially set to the default layout's configuration. Changing the layout that is applied thus only effects the structure of the rows. Click on "Layout options" within your budget's P&L or Balance Sheet to change the layout or the layout view, as shown in the image below.

📓 Note

Changing the P&L or Balance Sheet layout within a budget will not change the layout within your reports (that are not budget reports) or the "Financials" tab.

Adding adjustments

When you create a budget, you have the option to make adjustments. To add an adjustment, click on either "Add adjustment" or navigate to the Adjustments tab within your budget.

You can then fill in all the relevant details for your budget and click "Save". The adjustment will be added to the budget. To view the impact of this adjustment, click "Highlight changes". A red highlight signifies a negative change, while a green highlight signifies a positive change. There will be a set of up and down arrows next to any account that you have adjusted.

To gain even more detail, click on the account you have adjusted. This will open up a line graph which visualizes the impact of the adjustment to your budget. You can then click on any point on the graph to highlight that value. You will see this value light up in the table too.

💡Pro tip

While you are able to edit your budget on the P&L and Balance Sheet, you cannot edit the KPIs.

To gain even more detail, click on the account you have adjusted. This will open up a line graph which visualizes the impact of the adjustment to your budget. You can then click on any point on the graph to highlight that value. You will see this value light up in the table too.

💡Pro tip

Click "Highlight changes" to see the impact of your adjustments across all financial statements. Any positive impact will be highlighted in green while any negative impact is highlighted in red.

Once you create an adjustment, it will be added to the budgeting adjustment table below the financial statements. Remember to provide a description for each adjustment so that you can determine the impact of each individual adjustment. Adjustments are also useful if you choose to export the budget to PDF; they serve as a trail of budget changes that your team or clients can read through.

💡Pro tip

Click "Include" next to each budgeting adjustment to see the real-time impact on the financial statements.

What's adjustable

  • Profit and loss: You can apply a budgeting adjustment to all accounts. For grouped accounts, you need to apply budgeting adjustments to the underlying accounts that create the group. You can't apply budgeting adjustments on totals since these are automatically calculated.

  • Balance sheet: You can apply a budgeting adjustment to individual accounts except for the cash and cash equivalents balancing account.

  • Direct and indirect cash flow statements: Budgeting adjustments can't be applied to the direct and indirect cash flow statements.

  • KPIs: All KPIs are calculated based on the profit and loss statement and balance sheet accounts.

If the red banner error message is shown when editing a Forecast or Budget, please edit the budget or forecast and set the layouts to “No Layout”. Click "Save" and then complete your edit.

Options for budget adjustments

There are several options for once-off and recurring adjustments. Although the options are self-explanatory, let's unpack each in a little more detail below:

  • Increase: Apply an increase to the current value(s), this can be a nominal amount or percentage based.

  • Decrease: Apply a decrease to the current value(s), this can be a nominal amount or percentage based.

  • Formula: Build a formula using any combination of accounts (current or prior period values) and arithmetic operators (that's +, -, × and ÷).

  • New Value: Apply a new value that overrides the previous value.

Connection-based budgeting

Connections pull in data from the primary inputs and activities that drive the operational and financial results of a business. With Syft's Connection-based budgeting, you can use operational data specific to your business to create meaningful adjustments to your budget.

First off, you'll have to upload data into Syft via the Connections tab. The non-financial data allows you to work with Connections in a budget and can include anything from website visits through to units sold. Once you have Connection data in Syft, you can use any variable to drive any profit and loss or balance sheet account.

To apply a Connection to an account, create a budgeting adjustment by clicking an account name (remember, a budgeting adjustment is something that you expect to happen in the future which will impact your financial position). On the budgeting adjustment, select "Formula" under "Impact" type. You'll notice a "Connections" button under the create an equation input box. You'll have the option to select any variable as a driver from your non-financial data (along with the period; either current, prior or prior year).

Exporting your budget

Once you've created a complete budget with all the budgeting adjustments you desire, you can see all your saved budgets on your dashboard. You can either edit a budget (which will take you to the financial statements for that budget), download a budget, or delete a budget.

If you choose to download a budget, you'll be given the following options:

  • Financial statements: Select the financial statements to include in the download. Even though your budget has all the financial statements, you may only want to export, for example, the profit and loss statement.

  • Adjustments: Include or exclude the budgeting adjustments using the adjustment toggle.

  • Report interval: Recall that you had the option to create your budget either on a monthly, quarterly, or yearly basis. You can export your budget using the interval you created it with or combine the budget into a different time interval.

  • Layout: Select a detailed or summary layout. The detailed layout is the standard layout that includes all your accounts while the summary layout only shows the totals in each financial statement.

  • Start and end date: Select which period you want to export from your budget. You may want to extract a certain period of time from a 10 year budget, for example, the next financial year, while leaving the rest of the budget hidden.

  • Format: Select either PDF or Excel format.

Consolidated budgets

You are able to add a budget column to your Build P&Ls or Build Balance Sheets which will sum multiple budgets from different entities within a consolidation into one budget column. The underlying budget columns will automatically be hidden.

The impact of changing an entity's currency on your budget

If you change the currency of the entity you are budgeting for, you need to do so before creating your budget as we do not convert it from one currency into another using exchange rates. All that happens is that the sign will change from, say, dollars to pounds. The reason for this is that we aren't able to accurately account for adjustments with an exchange rate.

So, just remember to change your entity's currency in Entity Settings before you build your budget.

Who can view and edit the budget

Syft has options for you to assign certain permissions to different users. To do this, follow these steps:

  1. Go to Settings

  2. Click on Users

  3. Click on "Manage entity access" next to the user in question

  4. Assign the correct role to the user

📓 Note

You may need to create a custom role for the purpose of the budget, in which case you need to click on Internal Roles. When you create a custom role, you have the option to grant access to Budgets as "view only" or "view and edit".

Did this answer your question?