Effective analysis in treasury management

Different information needs and structures in companies require both transparent and flexible reporting. Ensuring the necessary transparency in existing data can be achieved by introducing an integrated, Group-wide information and reporting platform. An ERP-independent software for the financial controlling offers companies the possibility to create a robust reporting for different requirements at any time.

Treasury departments can also be assessed on the basis of quality criteria, including the achievement of objectives in the core tasks, the quality of the planning (as- is analysis) the quality of the tools used and criteria that must be met. The fast and reliable creation of reports can make a significant contribution to the service delivery of the department.

How does Ltc|analytics work?

Litreca’s reporting software is a fully integrated and web-based solution. Based on current and highly developed treasury intelligence technology, medium-sized and large companies have high-performance access to all treasury data collected in the company. The clever system architecture allows easy integration into the existing company IT, while the BI tool is based on the operative database from various upstream-systems such as Ltc|treasury.

With the help of a time-controlled ETL process, existing raw data from the warehouse are converted into analysis-oriented data in order to store them in the “cube. ” A business intelligence server provides all users at different locations around the world with data via the intranet.

The reporting system provided is audit-proof, while maintaining the familiar working environment of employees, as the platform uses the basic features of Excel. Formatting and integration of visual design elements rely on Excel knowledge and can therefore be designed by any professional user without IT knowledge.

Key figure-based forecasts on a uniform data base

The objective of a dynamic profitability analysis is to always keep the company-wide liquidity management and the planned business volume in a balanced relationship. First and foremost, the data on key financial information to secure liquidity and to make decisions about financial risk positions in the company must be made available. (e.g. adequate collateral lines).

The data provided from the Treasury must be transparent, up-to-date and complete in order to allow individual analysis of business transactions – the provision of the figures is in the form of dashboards /Management Cockpits available. All data provided by Litreca’s reporting software can be used daily to prepare key figures for financial reporting in accordance with IFRS and HGB.

Discover Ltc|analytics
Accurate day-to-day profitability analysis
Ensuring transparent, up-to-date and complete reporting
Financial information at group level
Secure data basis for day-to-day decisions
Access at any time, worldwide, mobile
Cloud technology
Functional overview
  • Management Cockpit / Dashboard
  • Preparation of key figures
  • Financial reporting (IFRS, HGB)
  • Ad hoc reports
  • Reports & analyses on mobile devices
  • OLAP technology – “Cube”
  • Drill-down function through to multi-dimensional analyses
  • Independent modeling without IT knowledge
  • Oracle-Cloud

This is just a small sample of the features included in Ltc|analytics. Please contact us for the complete function overview.

Training offer for Ltc|analytics

We show you how you can optimally use Ltc|analytics, partly configure it yourself and thus use it sustainably. You decide whether you want to take a training course on site, on the web or with us at our branch in modernly equipped training rooms.

Course No.: 260 - Ltc|analytics Excel

  • Target group: Users
  • Course duration: 1 day

  • Prerequisite: Good Knowledge of MS Excel

Description

After attending this course, you will be able to use the Ltc|analytics program correctly and use it optimally to facilitate your daily work. Create reports securely and according to the company’s individual needs

Course content

Introduction to OLAP
  • Overview of components
  • Understanding the model (databases, dimensions, elements, cubes)
Create example cube model
  • Create Database
  • Create dimensions
  • Insert elements (manual, copy & paste, copy & paste with hierarchy format)
  • Composition of cube from different dimensions
  • Define attributes
View, analyze and report data dynamically
  • Ad hoc reports with the “Insert View” wizard
  • Write values back to the database
  • Insert elements: simple elements and buttons
  • Flexible report design with elements and subsets
  • Filter settings with subsets
  • Dynamic reports

Course No.: 263 - Ltc|analytics Web / cash Edition / treasury Edition

  • Target group: Users

  • Course duration: 2 days

  • Prerequisite: Good knowledge of MS-Excel

Description

This training course is aimed at all Ltc|cash and Ltc|treasury customers who are using a version 7. 0 or higher and who want to analyze and report faster, more precise, easier and audit-proof with Ltc|analytics in a familiar Excel environment.

Course content Day 1

General Introduction to the Ltc|analytics Web Application
  • the report and file manager
Getting started in the file manager
  • Creating folder groups, root directories, folders and workbooks
Fast and flexible report creation with the “Insert View” wizard
  • Pros & Cons
Building dynamic reports using DynaRanges
  • First Steps: What are DynaRanges, and what are they good for?
  • First Introduction to the Subset Editor in conjunction with DynaRanges
  • Insert formula integration into DynaRanges via data function
  • Dynamic Calculations from DynaRanges (Draw Sum)
Integration of charts from DynaRanges
  • Simple charts
  • Dynamic charts
  • SUCCESS charts
  • Microcharts

Course content Day 2

Dynamic form elements such as ComboBoxes and date switches in combination with DynaRanges
Working with Resources, Variables, and Designated Areas
Further form elements
  • Checkboxes
Frameset creation
  • Important steps to create a frame set
  • Dynamic linkage with other reports about hyperlink functions
Formatting rules assigned with the rule wizard
Zero suppression
Dynamic image integration
Reports
  • Publication of reports
    • in the report manager
    • Rapid publication
  • Report export and report import
  • Print reports / Export PDF file
Introduction to the Ltc|analytics standard application

Course No.: 264 - Ltc|analytics Web / Receivables Management Edition

  • Target group: users

  • Course duration: 2 days
  • Prerequisite: Previous knowledge Course No. 281

Description

This training course is aimed at all Ltc|receivables energy in SAP customers who are using a version 7. 0 or higher and who want to analyze and report faster, more precise, easier and audit-proof with Ltc|analytics in their accustomed Excel environment.

Course content Day 1

General Introduction to the Ltc|analytics Web Application
  • the report and file manager
Getting started in the file manager
  • Creating folder groups, root directories, folders and workbooks
Fast and flexible report creation with the “Insert View” wizard
  • Pros & Cons
Building dynamic reports using DynaRanges
  • First Steps: What are DynaRanges, and what are they good for?
  • First Introduction to the Subset Editor in conjunction with DynaRanges
  • Insert formula integration into DynaRanges via data function
  • Dynamic Calculations from DynaRanges (Draw Sum)
Integration of charts from DynaRanges
  • Simple charts
  • Dynamic charts
  • SUCCESS charts
  • Microcharts

Course content Day 2

Dynamic form elements such as ComboBoxes and date switches in combination with DynaRanges
Working with Resources, Variables, and Designated Areas
Further form elements
  • Checkboxes
Frameset creation
  • Important steps to create a frame set
  • Dynamic linkage with other reports about hyperlink functions
Formatting rules assigned with the rule wizard
Zero suppression
Dynamic image integration
Reports
  • Publication of reports
    • in the report manager
    • Rapid publication
  • Report export and report import
  • Print reports / Export PDF file
Introduction to the Ltc|analytics standard application
Are you interested in Ltc|analytics?

Then arrange a non-binding online presentation now, where you can take part from the comfort of your desk. Your personal contact person will present the system to you and competently answer your questions.

Arrange an online presentation now

    For which solution(s) would you like to receive a free online presentation?

    *Mandatory field

    We process the information you provide via this contact form confidentially and exclusively for processing your request. Your data will not be passed on to third parties. Our privacy policy gives you an overview of how we ensure this protection and what kind of data is collected for what purpose.

    Questions & Answers

    How long does it take to implement Ltc|analytics?

    If you want to use Ltc|analytics in conjunction with our treasury management solution Ltc|treasury, it will take about 5 days to set up.

    In combination with other basic/pre-systems, the exact requirements must be specified in advance in a workshop.

    Can users without IT knowledge customise or create dynamic reports?

    Yes, this is possible without any problems. The report design tool is based on an Excel-like interface, so that the Excel know-how acquired over the years can continue to be used.

    However, a basic training of 3 days is necessary to get to know and use the data model and the dynamic tools – which go beyond the Excel possibilities.

    Can data from pre-systems be transferred automatically?

    In combination with our treasury management solution Ltc|treasury, data can be transferred to Ltc|analytics at the touch of a button or fully automated.

    If you have other upstream systems in use, data transfers can also be automated. However, this requires a technical check/agreement.

    Do you have any further questions?

    We will be happy to answer your further questions about Ltc|analytics in person.

      *Mandatory field
      We process the information you provide via this contact form confidentially and exclusively for processing your request. Your data will not be passed on to third parties. Our privacy policy gives you an overview of how we ensure this protection and what kind of data is collected for what purpose.