Tutorials

ProForecast is the leading strategic planning and financial forecasting tool for business and accountancy practices. High-level forecasting or Drill Down allow for a greater level of granularity than any other forecasting tool in the market turning weeks of work into days and days into hours whilst seemingly integrating with Sage 200 Cloud and Professional, Xero, Quickbooks, Excel and 85 of the most widely used accountancy packages.

Product Overview

ProForecast is the leading strategic planning and financial forecasting tool for business and accountancy practices. High-level forecasting or Drill Down allow for a greater level of granularity than any other forecasting tool in the market turning weeks of work into days and days into hours whilst seemingly integrating with Sage 200 Cloud and Professional, Xero, Quickbooks, Excel and 85 of the most widely used accountancy packages.

All businesses are facing challenges at the moment, and one of the biggest challenges is uncertainty. Now more than ever, every businesses need to be budgeting and planning in a volatile business environment. This includes cash flow planning, forecasting and scenario planning so you are prepared for every possible scenario your business may be facing.

The Importance of Scenario Planning

All businesses are facing challenges at the moment, and one of the biggest challenges is uncertainty. Now more than ever, every businesses need to be budgeting and planning in a volatile business environment. This includes cash flow planning, forecasting and scenario planning so you are prepared for every possible scenario your business may be facing.

Within MyPlans, Basic Setup allows the user to rename a plan and set a description that is easily identifiable to the plan. Plan parameters such as plan start & end date, benchmarking settings, currency and tax configuration and VAT and Accounts payable settings and colour schemes are defined here. Alongside base configuration users can add Revenue Models in any combination, to reflect a business’s revenue stream.

Introduction to MyPlans

Within MyPlans, Basic Setup allows the user to rename a plan and set a description that is easily identifiable to the plan. Plan parameters such as plan start & end date, benchmarking settings, currency and tax configuration and VAT and Accounts payable settings and colour schemes are defined here. Alongside base configuration users can add Revenue Models in any combination, to reflect a business’s revenue stream.

Data driven graphs can be generated quickly and exported in a variety of different formats to be implemented in reports and shared as and when needed. Graphs are a common method to visually illustrate relationships in the data and by easily changing their format you can ensure that the graphs produce meet both your own, and your client’s unique requirements.

Data Visualisation

Data driven graphs can be generated quickly and exported in a variety of different formats to be implemented in reports and shared as and when needed. Graphs are a common method to visually illustrate relationships in the data and by easily changing their format you can ensure that the graphs produce meet both your own, and your client’s unique requirements.

The company structure menu enables the user to build departments & divisions. Default Central Departments – are Central Overheads and Central Sales, each has its own detailed Departmental Report which allows a more accurate examination of costs, these can both be found within the Data Entries screen by default.

Company Structure

The company structure menu enables the user to build departments & divisions. Default Central Departments – are Central Overheads and Central Sales, each has its own detailed Departmental Report which allows a more accurate examination of costs, these can both be found within the Data Entries screen by default.

Creating a Division creates a divisional sales department. This can be useful even if the business does not operate a divisional structure as it can be used for Project Accounting enabling the costs and revenues to be kept separate.

Adding Divisions

Creating a Division creates a divisional sales department. This can be useful even if the business does not operate a divisional structure as it can be used for Project Accounting enabling the costs and revenues to be kept separate.

This menu is used to set the basic VAT & Corporation Tax Parameters. If a country that does not operate VAT is chosen for the forecast, then all VAT selections will be hidden.

VAT, GST & Corp Tax Setup

This menu is used to set the basic VAT & Corporation Tax Parameters. If a country that does not operate VAT is chosen for the forecast, then all VAT selections will be hidden.

ProForecast is template driven, so that a complex forecast can be built rapidly and accurately without the necessity to build formulae. There are templates covering cost centres, loans, capital structures and revenue models. All templates can be used in combination with each other, so that for instance if the range of inbuilt templates does not exactly mirror the requirements of the user, by using multiple templates in combination the user can create the scenario required.

Navigation Overview

ProForecast is template driven, so that a complex forecast can be built rapidly and accurately without the necessity to build formulae. There are templates covering cost centres, loans, capital structures and revenue models. All templates can be used in combination with each other, so that for instance if the range of inbuilt templates does not exactly mirror the requirements of the user, by using multiple templates in combination the user can create the scenario required.

Connect ProForecast to Sage 50, 200, 200c and professional so that we can automatically import and map as much data as possible to your forecasts. Once your data is in ProForecast, it is accessible on any device you use to login to your ProForecast account and to other users that you collaborate with and have granted permission to share that plan with.

Importing from Sage

Connect ProForecast to Sage 50, 200, 200c and professional so that we can automatically import and map as much data as possible to your forecasts. Once your data is in ProForecast, it is accessible on any device you use to login to your ProForecast account and to other users that you collaborate with and have granted permission to share that plan with.

The ability to drill down through reports is an invaluable tool, especial given the often-complex nature of large accounts. Through working from high level categories to granular detail you can drill down within a report to visualise each subset, highlighting critical information such as long-term liabilities to stocks of finished goods.

Report Drill Down

The ability to drill down through reports is an invaluable tool, especial given the often-complex nature of large accounts. Through working from high level categories to granular detail you can drill down within a report to visualise each subset, highlighting critical information such as long-term liabilities to stocks of finished goods.

Sage 200 Professional and Sage 200 Extra Online are powerful business management solutions that enables businesses to manage complex processes across all departments. Through the Sage API we can quickly and securely integrate your data into our application to automatically map your forecasts.

SAGE 200 API

Sage 200 Professional and Sage 200 Extra Online are powerful business management solutions that enables businesses to manage complex processes across all departments. Through the Sage API we can quickly and securely integrate your data into our application to automatically map your forecasts.

Employees can be quickly added as individuals or groups, additions can be linked to changes in turnover and employee numbers, salaries, pension contributions, tax and NI contributions can also be varied mid forecast using step changes.

Adding Salaries

Employees can be quickly added as individuals or groups, additions can be linked to changes in turnover and employee numbers, salaries, pension contributions, tax and NI contributions can also be varied mid forecast using step changes.

Revenue Models can be used in any combination, to reflect businesses with multiple revenue streams or alternatively by using a combination of models creating a revenue stream. For Cost of goods sold (COGS) utilising the sale of products or services the cost of sales can either be calculated from the Top Down or Bottom Up.

Expense headings can be imported or quickly added using library or custom names, and tailored by adding inflation rates, prepayments, accruals, creditor and VAT terms and by selecting one of nine calculation methods. Cost profiles can be varied mid forecast using step changes.

Revenue Models

Revenue Models can be used in any combination, to reflect businesses with multiple revenue streams or alternatively by using a combination of models creating a revenue stream. For Cost of goods sold (COGS) utilising the sale of products or services the cost of sales can either be calculated from the Top Down or Bottom Up.

Expense headings can be imported or quickly added using library or custom names, and tailored by adding inflation rates, prepayments, accruals, creditor and VAT terms and by selecting one of nine calculation methods. Cost profiles can be varied mid forecast using step changes.

Expense headings can be imported or quickly added using library or custom names, and tailored by adding inflation rates, prepayments, accruals, creditor and VAT terms and by selecting one of nine calculation methods. Cost profiles can be varied mid forecast using step changes.

Adding Expenses

Expense headings can be imported or quickly added using library or custom names, and tailored by adding inflation rates, prepayments, accruals, creditor and VAT terms and by selecting one of nine calculation methods. Cost profiles can be varied mid forecast using step changes.

An unlimited number of Central Departments and Divisional Departments can be set up, again split into Operating Cost and Non-Operating Cost Departments. Operating Cost Departments appear in the Income Statement above the Operating Profit Line, whereas Non-Operating Cost Departments appear below the Operating Profits Line. All sales departments appear as Operating Cost Departments.

Adding Departments

An unlimited number of Central Departments and Divisional Departments can be set up, again split into Operating Cost and Non-Operating Cost Departments. Operating Cost Departments appear in the Income Statement above the Operating Profit Line, whereas Non-Operating Cost Departments appear below the Operating Profits Line. All sales departments appear as Operating Cost Departments.

Templates exist for 8 different types of loan plus Invoice Discounting and Factoring. Loans can include payment and interest holidays, bullets, fixed and variable rates, tailored interest and capital payment periods. Fx loans automatically calculate unrealised and realised Fx gains and losses.

Adding Loans

Templates exist for 8 different types of loan plus Invoice Discounting and Factoring. Loans can include payment and interest holidays, bullets, fixed and variable rates, tailored interest and capital payment periods. Fx loans automatically calculate unrealised and realised Fx gains and losses.

Our Rapier AI engine analyses your accounts and pre-populates a ProForecast Product and Services model calculating seasonality, sales volume, COGS and selling price of every product in your portfolio.

Rapier Setup

Our Rapier AI engine analyses your accounts and pre-populates a ProForecast Product and Services model calculating seasonality, sales volume, COGS and selling price of every product in your portfolio.

ProForecast Getting Started

Download

ProForecast Navigation Overview

Download

ProForecast Sage 200 Professional

Download

ProForecast Rapier Import

Download

ProForecast Creating Departments

Download

ProForecast Creating Divisions

Download

ProForecast Adding Expenses

Download

ProForecast Adding Salaries

Download

ProForecast Global What IF

Download