1 / 19

about | navigator  xlforecast

about | navigator  xlforecast. info@ncg-sweden.se +46 8 611 76 20 www.ncg-group.com. about | traditional budgeting 1(3). reporting templates creates in microsoft excel by the financial department xls-files are distributed via e-mail from the financial department to budget responsible

cree
Download Presentation

about | navigator  xlforecast

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. about | navigatorxlforecast info@ncg-sweden.se +46 8 611 76 20 www.ncg-group.com

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

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

  4. about | traditional budgeting 3(3) • budget fixed! • budget files from microsoft excel templates are updated in the financial system • 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) • order of budget reports from the financial system (check against ”excel budgets”) • 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. templates analysis navigator | xlforecast navigator | xlforecast navigator | xlreport strategicinformation indicatorsratios transactions basic dataand templates updatedbudget/forecast enteredbudget/forecast ifs baan sap navision axapta formula jeeves navision attain navision xal about | our solution financial department budget/forecast responsible

  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

More Related