about | navigator? xlforecast?

1
about navigator?xlforecast?

• info_at_ncg-sweden.se
• 46 8 611 76 20
• www.ncg-group.com

2
about traditional budgeting 1(3)

1. reporting templates creates in microsoft excel by
   the financial department
2. xls-files are distributed via e-mail from the
   financial department to budget responsible
3. the budget is entered, on lowest level, in the
   microsoft excel templates by budget responsible
4. sub budgets are consolidated by budget
   responsible (link. of excel sheets/workbook)
5. xls-files are returned from budget responsible to
   the financial department

3
about traditional budgeting 2(3)

1. consolidation on company level(many xls-files
   shall be linked, checking of total budget against
   sub budgets etc. at the financial department)
2. budget analysis, internal meetings
3. budget revise (back to 3)
4. budget are presented for the board
5. ev. new budget revise (back to 3)

4
about traditional budgeting 3(3)

1. budget fixed!
2. budget files from microsoft excel templates are
   updated in the financial system
3. transfer of budget files to the financial system
   (check against correct identities, adjustment of
   errors in budget files and/or tables in the
   financial system)
4. order of budget reports from the financial system
   (check against excel budgets)
5. done!!!

5
about problem areas

• complicated to manage budgets with many
  dimensions in microsoft excel (accounts,
  departments, products, markets etc.)
• complicated to manage budget on many levels
  (structures)
• a lot of effort spent on putting together figures
  in microsoft excel (complicated links of
  workbooks, formulas gives many sources for
  errors)
• central work is often performed by one en (1)
  person critical resource in the budget process
• less time for analysis (difficult to get a clear
  overview)
• difficult to work with parallel budget versions
• no check against tables in the financial system

6
about our solution
budget/forecast responsible
financial department
7
about design of report templates

• report templates is created in microsoft excel
• flexible framework for design
• optional naming etc.
• control codes on row 1 and column a (see
  xlreport)
• free design of layout
• microsoft excel templates stored and distributed
  trough the sql-database

8
about reporting of budget values

• budget responsible collects report templates from
  the database
• reporting of budget values directly in templates
• users activates storage to database via menu
  option
• reported budget values are stored in the
  navigator? data warehouse
• when values are stored control against tables are
  performed
• authority check (for example that user x are
  allowed to store budget values for department 100)

9
about order of consolidated budget reports

• xlreport? is used to put together the budget
• easy to put together figures on different
  organizational levels (department, region,
  company total etc.)
• easy to put together budgets on different
  dimensions
• no complicated links in microsoft excel to put
  together budget since xlreport? collects values
  directly from the navigator? data warehouse to
  the budget report

10
about authority control

• xlforecast? controls authorities through user
  roles
• each user are connected to a user role where the
  authority are defined(for example which table
  values the user has authority to enter or which
  functions the user shall be allowed to access)

11
about structure management

• xlforecast? has a inbuilt table for definition of
  hierarchal structures
• integration bridges of, in the erp-system,
  already defined structures
• possible to work with parallel structure trees
  (version management, simulation possibilities)

12
about forecast management

• xlforecast? works with value types which makes it
  possible to define your own value types for
  budgets and forecasts

13
about logging functionality

• xlforecast? log all value updates
• Makes it possible to centrally follow up status
  for reported budgets and forecasts (per version)
• lock functions, centrally responsible locks the
  possibility to change budgets or forecasts (per
  version)

14
about examples of menus in xlforecast?
15
about example of reporting
16
about example of reporting
17
about example of company
18
about advantages with xlforecast?

• time saving tools for managing the budget process
  and/or running forecast reporting and follow up
• integrated solution between microsoft excel, data
  warehouse and your financial system
• all values are stored directly in the database
• inbuilt security (authority control and value
  check)
• easy consolidation of budgets/forecasts (no links
  between microsoft excel spreadsheets)
• minimized time managing figures more time for
  analysis

19
about navigator? xlforecast?