Skip to main content

Forecasts

Use Syft to build formula-driven forecasts in no time!

Alex avatar
Written by Alex
Updated today

Who can use this feature

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

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

About forecasts

4-Way Forecasting is an incredibly powerful tool that allows you to create an integrated forecast across the profit and loss statement, balance sheet, cash flow statements, financial ratios, and connections where any impact to a particular statement will carry through to all other statements.

How to create a forecast

Let’s get started with your first Forecast. Navigate to "Planning" > "4-Way Forecast," where you will be able to see all created forecasts at a glance. You'll land on the Forecast dashboard. Now click on “Create new forecast.” There are three main steps to building a forecast:

  • General information: where you can name your forecast, select a period configuration (monthly - up to 10 years, weekly - up to 52 weeks, or annual - up to 10 years), a start date and end date (from one month to 10 years), and change your assigned layouts.

💡Pro Tip:

It's useful to describe your forecast so you can create multiple forecasting scenarios for the same period.

📓Note:

Weekly forecasts are only available on the Advanced plan.

  • Population options: choose which data to use to populate your forecast and add a percentage change. You can also choose to filter for divisions here. Plus, you will see some more advanced options at the bottom of the screen. If you click on these, you can choose to specify details regarding your credit/cash setup, or customize the percentage changes for specific categories.

  • Default accounts: where you can review and specify the accounts that should be used as defaults when populating this forecast and creating events, including your bank account, credit sales account, credit purchases account, and retained earnings account.

💡Pro Tip:

To change the layout you’ve assigned to the forecast, simply click on “Change assigned layouts” and choose which P&L and BS layouts to apply.

We’ll focus on the 2nd and 3rd options in a bit more detail below.

Population options

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 you don't think will be useful in your forecast. We support the following population methods:

  • Prior last year (add a percentage change): this uses the values from the same period in the prior year (so, if you are in August 2025, this will mean August 2024) as a base while increasing/decreasing them by a percentage of your choice

  • Prior (add a percentage change): this uses the values from the prior period (so, if you are in August 2025, this will mean July 2025) as a base while increasing/decreasing them by a percentage of your choice

  • Zeros: this populates the whole forecast with zero (0) values

You can create a forecast at the divisional level (tracking category, class, or analysis code, depending on your accounting provider) and then compare actuals to forecasted data for each division.

Note 📝: These population options are specific to the Profit and Loss table. For the Balance Sheet table, Syft will always use the prior period to populate values.

For populated values, you can:

  • Specify a credit/cash split for your population values:

    • This means you can indicate how populated values should be split between credit and cash. For example, you could specify that 70% of the populated sales value should be treated as credit and 30% of the populated sales value should be treated as cash. As a result of this specification, the sales in the P&L would still increase by the same amount, but the Bank and Accounts Receivable accounts in the Balance Sheet would be more accurate.

  • Customize the percentage change per category:

    • In real terms, this means that if you’ve selected Prior or Prior last year as your population method, you can customize the percentage change per category. For example, you could set your sales to increase with 5% while your expenses increase by 7%.

📓Note:

The customization is limited to only categories in your layout, and doesn't apply to only specific accounts.

And now for a closer look at your default accounts.

Specify default accounts

You need to specify the number of default accounts to be included in your forecast. The options are as follows:

  • Bank account

  • Credit sales

  • Credit purchases

  • Retained earnings

🧐Why is this step important?

Specifying the default accounts to be used in your forecast makes it quicker and easier to allocate changes to the right contra account.

NB:

Once the forecast is created, you can set specific contra accounts on an event by event basis. They are not limited to the default accounts they select during setup. We’ll take a look at events in more detail later on.

You also have the option to set up default payment schedules for Accounts Receivable and Accounts Payable by clicking on “Set up default payment schedules” at the bottom of the dialogue box. Here, you can choose the following:

  • Accounts receivable schedule: specifying how long you think it will take for your customers to pay you

  • Accounts payable schedule: specifying how long you think it will take you to pay your suppliers

If you click on either of the options, you will see that you can add a percentage amount for the initial month, one month later, two months later, and three months later. You can also insert additional periods or a bad debt row. Remember to click Save when you’re done.

📓Note:

Once the forecast is created, you can also set up custom schedules on an event by event basis.

Summary

Once you’ve finished setting up your Forecast, you will be navigated to the Summary page, where you can see a high-level overview of key metrics, trends, and insights drawn from your forecast data. You can toggle commentary on or off with the toggle next to “Show commentary” at the top right of your screen.

The Forecast summary includes two graphs, an account “watch list” and a section where you can add free text. Let’s break this down:

  • The graphs track the forecasted amounts against your actuals as the actuals for the forecasting period flow into Syft. You can change these to different accounts if you would like.

Use Case:

If there's a particular income, expense, asset, or liability you would like to keep a close eye on, you could select that as one of the accounts to be displayed in the summary section. For example, if you're worried about your electricity usage and what it’s costing you, you can select electricity as one of the accounts in the summary view. That way, you can easily ensure you don’t overspend on electricity.

  • The account watch list consists of a table with five accounts where the actuals to-date, forecasted to-date, variance, and variance percentage for these accounts are displayed. You can also change these to different accounts to suit your preferences.

  • The section to add free text. Here, you can make notes, write in observations, or anything else you want to append to your forecast. You’ll see you have the ability to style this with bold, italics, underlining, headings, and bullet points, as well as alignment changes.

💡Pro Tip:

You can hide the free text section if you’d prefer not to share it with others.

If you click on the pencil icon at the top right corner of either graph, you can edit the data source of the data to display. Remember to save any changes you make.

Profit and Loss table

The next section after the Summary is the Profit & Loss table. This table includes a number of display options, which you can find in the “Show” menu on the right-hand side of the screen. These include the following:

  • Highlight changes: which highlights any accounts within which you’ve made changes (i.e. accounts where you have added events)

  • Show only accounts with events

  • Show variance from actuals in cell: which displays an up or down arrow to indicate if the forecasted amount was higher or lower than the actual amount

  • Add actual columns

  • Add variance as columns

  • Show initial populated values for accounts with events

  • The Add event button gives you the ability to add events to accounts from a global level. You can do this either by using the pop-up menu or by directly adding events to each account.

Creating Events

When creating a budget, you might want to account for certain events that will greatly impact your account values. For example, you might be planning to hire 40 more employees in the next year. If that’s the case, the amount you spend on a recruitment campaign may increase over certain periods, and the amount you spend on salaries later in the year would increase too. How can you change the account values in your budget to reflect events that could potentially occur over the budgeting period? When creating a budget on Syft, there are three ways you can change an account value:

  1. Prebuilt events

  2. Custom events

  3. In-line editing

To add an Event, click on the "Add Event” button. Every event is the result of the input lines it contains, so it’s up to you to determine what that looks like.

Let’s explore what each of these entail.

Prebuilt events

Prebuilt events include the following options:

  • Increase by amount

  • Increase by percentage

  • Decrease by amount

  • Decrease by percentage

These events are populated directly in the table under the relevant account. They are not very flexible as the input is fixed as either an amount or percentage. In addition, you cannot change the input types or add any new input lines. If you want something more customizable, we recommend custom events.

Custom events

Custom events offer more flexibility, with the ability to:

  • Add, delete, or rename input lines

  • Change the type of input on a line by line basis – by simply clicking on the icon next to the line in question

Custom events allow you input the following input types:

  • Currency

  • Numerical value (for number of units, for example)

  • Percentage

  • Linked value

📓Note:

Linked value input lines can be linked to an account or connection (non-financial data added in the Connections section of Syft), or they can be the result of an existing event.

In-line editing

In addition to adding events to change account values, you can also change account values by manually entering new values in the table at the account level. This will result in a “new value” event populating the relevant account.

These events work slightly differently to the prebuilt and custom ones. Here’s how:

  1. The amounts in the input and result line can differ:

    1. The amount in the input line will be the value you entered at the account level, i.e. the actual value that the account should be.

    2. The amount in the result line will be the value that had to be added/subtracted from the current account value to reach the new value.

  2. The date ranges on these new value events function differently:

    1. The date range is limited to the month(s) you initially enter new values for.

    2. Going forward, you can edit the input line in the new value event, but if you add values past that initial date range, you’ll have to use the “Manage event” menu to extend the date range.

Managing Events

Once you’ve created an event, you have the ability to manage it. Rename it by clicking on the event name and typing in a new name (this can even include emojis!) For more detailed edits, navigate to the cog icon next to the event name and open the Manage menu. Within this menu, you can:

  • Change the interaction of the event with the account it’s been created on

  • Reorder the event

  • Navigate to the other accounts affected by the event within Syft to dive into the underlying details

📓Note:

Reordering events might change the value of the accounts as the calculator will take the order of events into account.

Let’s take a look at how this works according to each of the sections within the “fx” menu.

Manage event

Manage event enables you to edit the formula and date range for each event and change the contra account.

📓Note:

The date range can be edited and customized for any type of event. However, the formula can only be changed for custom events. Prebuilt events have a set formula.

The contra account option can be changed between cash (which is the default bank account), credit (which is the default Accounts Receivable/Payable account) or Other (which could be any other account).

💡Pro Tip:

If you change the contra account to the credit option, you can also customize the Accounts Receivable or Accounts Payable schedule on an event by event basis. This is helpful if you want to sell to a customer with special terms, such as an extended payment schedule.

Change interaction

You might have added an event to your forecast, assuming a 20% sales increase in the first six months. However, if an expected deal falls through, you wouldn't want to base your forecast on a false assumption. In such a scenario, you might want to disregard the results of this event in your sales account. Or perhaps you would like to replace the account values with the actual sales figures. Change interaction allows you to do just that.

Change interaction empowers you to change the interaction of the event with the account on which it was created. By default, all events will be added to the accounts they’re created under. However, you can change this interaction to either “Replace account values” or “Ignore results of this event.” What does this mean?

  • Replace account values means that the result of the particular event will override the current value of the account

  • Ignore results of this event means that the event will still exist, but the result of the event will be ignored and not added to the account it was created under.

💡Pro Tip:

You might want to ignore the result of an event in order to reference this result in another event without the result of the original event impacting your account values.

Reorder

The Reorder function allows you to move an event up or down in your forecast. The effect that the events have on their respective accounts is calculated from top to bottom. So, changing the order of the events can change the value of the account they are added to.

Use case:

If you have events that replace certain values or that increase/decrease values by a percentage, you might want to see what the effect will be when you increase by a percentage after other events vs. before other events. Alternatively, you may want to see what the effect would be if you were to replace the account values with new values first and then apply all of your other events.

Go to affected accounts

Go to affected accounts allows you to quickly and easily navigate to any other account affected by a specific event. You can also return to the source event from all the affected accounts to see what is causing the results you see in your forecast.

Balance Sheet table

📓Note:

The Balance Sheet table is only available on Plus and Advanced plans.

After the Profit & Loss table, you have the Balance Sheet table. This table functions exactly the same as the Profit and Loss table, except that it allows you to unwind an event over time. What does unwinding mean? Unwinding typically applies to deferred revenue and similar types of transactions.

For example:

If someone pays you an annual amount upfront for a service with a monthly subscription, you would receive the full amount in your bank account. However, you would only be able to recognize it as income on a month by month basis. So in this context, unwinding allows you to recognize this as income coming into your account over time.

To unwind an event over time, navigate to the “Manage event” menu and take a look at the date settings. You will see the option to unwind an asset/liability over time, and you can select:

  • How it should unwind: over a number of periods or according to a custom schedule

  • Where it should unwind to: i.e. which account

  • When it should start unwinding: specify a certain period

KPI Scorecards

📓Note:

KPI Scorecards are only available on Plus and Advanced plans.

Next up, you have a section for KPI Scorecards. You can choose to view any of the scorecards you have available for the entity in question by clicking on the drop-down at the top-left of the table. This selection will then populate the table with your KPI Scorecard, showing how KPIs have been impacted based on changes made to your Profit & Loss and Balance Sheet.

KPI Scorecards represent the result of account values calculated in the Profit & Loss and Balance Sheet. Thus, once again, you cannot add events to this table.

💡Pro Tip:

The KPI Scorecard you select must match the layouts you have selected.

Connections

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

First, you'll have to upload data into Syft via the Connections tab. The non-financial data allows you to work with Connections on a forecast and can include anything from website visits 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.

You can add any of your existing connection fields to your forecast by clicking on “Add a connection.” If you don’t have any already connected, you’ll be prompted to add a new connection.

In addition, you can add an event to your connection field by clicking “Add event,” selecting a connection field to link the event to, and choosing one of the following options:

  • Increase by amount

  • Increase by percentage

  • Decrease by amount

  • Decrease by percentage

To add an event, you will need to break the link to your connection. You can break the link between your forecast and your connections or you can add adjustments to the field to create “Forecasted connections.” You can then manually input values.

Cash Flow tables

📓Note:

Cash Flow tables are only available on Plus and Advanced plans.

The Cash Flow tables show the result of account values calculated in your Profit & Loss and Balance Sheet, indicating the impact of other accounts on your business’s cash flow. Because these tables are reliant upon the other statements, you cannot add events to Cash Flow itself.

Who can view and edit the forecast

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

  1. Click on your profile picture icon at the top left of the screen

  2. Click on Users

  3. Click on the pencil icon 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 forecast, in which case you need to click on Roles, underneath Users in the menu. From there, click on “Create custom role.” When you create a custom role, you have the option to grant access to Forecasts as "view only" or "view and edit."

Did this answer your question?