Forecast 5 Sample Data

Forecast 5 Sample Data

Downloaded and installed Forecast 5 and you aren't sure where to start?


We have provided a sample data that will help you see most of the features and benefits that Forecast 5 has to offer.

Import the Sales Demo data found in the program installer files - Head to this path and look for the XML file called Sale Demo - C:\Program Files\Forecast 5 Ltd\Forecast5 3.0


 

Here is a quick explanation of the data you will see:


Sales: A section - being a group of records, in this case; sales records.

Forecast 5 Sales: Uses Calculate from units; for example in the Forecast 5 sales record

Annual Subscription: Uses percentage of sales

Other Sales: Uses a formula referenced to memo records (found at the bottom of the list being KPI Sales From Memo Calculations).

Direct Costs: A costs sections.

Stock and Stock on Hand: Showing manufacturing, wages, overheads and a stock component

Overheads: Section

Rates & Water: An accrual/prepaid record - note the options.

Labour Costs: A wages record which uses an employee record to set up individuals and groups, calculate PAYE, bonus and pensions.

Bank accounts: There are three bank accounts including a USD bank account. Note the transfers and currency options.

Fixed Assets: Add new assets, purchase, depreciate, dispose and finance and more.

Loans: Set up loans and repayments.

Other Assets: For everything else. We have already done the bank, debtors, GST, stock, accruals, fixed assets and loan so this allows for many other assets and liabilities.

Capital: Enter reserves and changes – share capital is entered in the opening balance sheet screen.

Forecast Records: These records are the system records, the calculated balances and tax etc.

 

You can add records, sections and folders, extend years, save a copy, start actuals, do rolling projections, What-if and much more.

Many features are there to be discovered. Select the report tab for the integrated Profit & Loss, Cashflow and Balance sheet with Funds flow report and supporting schedules e.g. fixed assets.

See also the budget, actuals and rolling reports.


Good luck with your trial and feel free to contact us at support@forecast5.com or sales@forecast5.com


    • Related Articles

    • Forecast 5 Support Policy

      The annual subscription includes the provision of support to an end user, access to the online training videos, continued use of the product and access to updates and releases.  You have access to the Forecast 5 Knowledge Base, available ...
    • Forecast 5 Quick Start Guide

      Contents Introduction to Forecast 5 ..................................................................................................................... 3 Creating a new Forecast ...
    • AUD forecast defaulting with NZD details

      Issue/Error: When creating a forecast, and selecting AUD, the forecast still populates with NZD defaults. Solution: Below is an SQL database that will generate AUD template. To restore this, follow the steps below for your license: A – Single ...
    • Convert from your spreadsheet to Forecast 5

      To simplify your transition to Forecast 5, we have provided an easy step-by-step guide on converting your spreadsheet to Forecast 5. Open the excel budget. Save as a new spreadsheet. In the saved spreadsheet remove all totals and subtotals. Open ...
    • Xero Integration to Forecast 5 Guide

      From Xero to Budgeting Hero! ​ The integration* process will effectively create a budget from your Xero companies historical data, enabling you to prepare next year’s budgets, import Opening Balances and Actuals with a click of a button and extract ...