Menu
  • Hot Topics
  • Services
  • Technology
  • About us
  • Locations
  • Press
  • Language
  • ESG Solutions
  • SAP S/4HANA
  • Artificial Intelligence (AI)
  • Modeling Solutions
  • Distressed Situations
  • Business Partnering
  • IFRS 18
  • Reporting & Regulatory
  • Digital Finance
  • Deal Advisory
  • Partner
  • Accounting & Reporting
  • Capital Markets
  • ESG Solutions
  • Carve out / PMI
  • Governance, Risk & Compliance
  • Business Partnering
  • Financial Services
  • Treasury
  • Concepts & Systems
  • SAP S/4HANA
  • Optimization
  • Advanced Analytics
  • Performance
  • Program Management
  • Finance Transformation
  • Artificial Intelligence (AI)
  • M&A Strategy
  • Due Diligence
  • Fact Book
  • Valuation
  • Restructuring
  • Debt Advisory
  • Modeling Solutions
  • IDL
  • Lucanet
  • OneStream
  • Oracle
  • CCH Tagetik
  • Accounting Advisory
  • Leasing
  • Financial Statements Support and Audit Assistance
  • Consulting for Statutory Auditor Invitations to Bid
  • Business Reporting
  • Financial Statements in Accordance with the German Commercial Code IFRS
  • ESEF Format for Financial Reporting
  • IPO Readiness
  • IFRS Conversion & Support
  • CSRD and ESRS
  • EU taxonomy
  • Non-financial Declaration for Companies
  • Carve Out Solutions
  • Post Merger Integration
  • Risk Management
  • Internal Controls & Process Assurance
  • Internal Audit
  • Compliance Management
  • IT Governance
  • Data protection & data security
  • Board Advisory
  • ESG solutions
  • IPO Readiness
  • Treasury as a resource
  • Treasury for Special Projects
  • Fully outsourced Treasury
  • Business blueprints
  • Master Data Management
  • Further ERP systems
  • Unser Beratungsansatz
  • Efficient closing
  • Modernization of the finance function
  • Harmonization of internal and external accounting
  • Target Operating Model
  • Process Mining & Optimization
  • Process automation in the financial sector
  • Working Capital Optimization
  • Management Reporting
  • Implementation of Planning Tools
  • Rolling Planning / Forecasting
  • Liquidity Management by using Liquidity Planning
  • Legal and management reporting with SAP S/4HANA
  • Corporate Performance Management
  • Sell Side Advisory
  • Buy Side Advisory
  • Capital Markets Advisory
  • Business management M&A consulting
  • Post Merger Integration
  • Fit for Sale
  • Private Equity Initiative
  • Corporate valuation
  • Purchase Price Allocation
  • Impairment Test
  • Fairness Opinion
  • Interim management
  • About us
  • Locations
  • Press
English
German
  • English
  • German
  • Hot Topics Clothing
    • ESG Solutions
    • SAP S/4HANA
    • Artificial Intelligence (AI)
    • Modeling Solutions
    • Distressed Situations
    • Business Partnering
    • IFRS 18
    CSRD und ESRS
  • Services Clothing
    • Reporting & Regulatory
      • Accounting & Reporting
        • Accounting Advisory
        • Leasing
        • Financial Statements Support and Audit Assistance
        • Consulting for Statutory Auditor Invitations to Bid
        • Business Reporting
        • Financial Statements in Accordance with the German Commercial Code IFRS
        • ESEF Format for Financial Reporting
      • Capital Markets
        • IPO Readiness
        • IFRS Conversion & Support
      • ESG Solutions
        • CSRD and ESRS
        • EU taxonomy
        • Non-financial Declaration for Companies
      • Carve out / PMI
        • Carve Out Solutions
        • Post Merger Integration
      • Governance, Risk & Compliance
        • Risk Management
        • Internal Controls & Process Assurance
        • Internal Audit
        • Compliance Management
        • IT Governance
        • Data protection & data security
        • Board Advisory
        • ESG solutions
        • IPO Readiness
      • Business Partnering
      • Financial Services
      • Treasury
        • Treasury as a resource
        • Treasury for Special Projects
        • Fully outsourced Treasury
    • Digital Finance
      • Concepts & Systems
        • Business blueprints
        • Master Data Management
        • Further ERP systems
      • SAP S/4HANA
        • Unser Beratungsansatz
      • Optimization
        • Efficient closing
        • Modernization of the finance function
        • Harmonization of internal and external accounting
        • Target Operating Model
        • Process Mining & Optimization
        • Process automation in the financial sector
      • Advanced Analytics
      • Performance
        • Working Capital Optimization
        • Management Reporting
        • Implementation of Planning Tools
        • Rolling Planning / Forecasting
        • Liquidity Management by using Liquidity Planning
        • Legal and management reporting with SAP S/4HANA
        • Corporate Performance Management
      • Program Management
      • Finance Transformation
      • Artificial Intelligence (AI)
    • Deal Advisory
      • M&A Strategy
        • Sell Side Advisory
        • Buy Side Advisory
        • Capital Markets Advisory
        • Business management M&A consulting
        • Post Merger Integration
        • Fit for Sale
        • Private Equity Initiative
      • Due Diligence
      • Fact Book
      • Valuation
        • Corporate valuation
        • Purchase Price Allocation
        • Impairment Test
        • Fairness Opinion
      • Restructuring
        • Interim management
      • Debt Advisory
      • Modeling Solutions
    Private Equity Initiative
    SAP S/4HANA Transformation
  • Technology Clothing
    • Partner
      • IDL
      • Lucanet
      • OneStream
      • Oracle
      • CCH Tagetik
    Lucanet
Efficient mass data processing in projects
Home Services Digital Finance Efficient mass data processing in projects
Contact us!

Efficient mass data processing

Projects in the financial environment involve increasingly large amounts of data that need to be processed. With our data analytics specialists, we support you in the analysis, validation and visualization of large amounts of data. Each of our experts has a sound finance background and knows the needs of financial departments in detail. From our perspective, this is important for the efficient translation of technical requirements into high-performance solutions. We can already implement most requirements by making full use of the Microsoft Office Suite. This is possible in particular by using the lesser-known Power Query and Power Pivot solutions integrated in Excel. However, we are also happy to use specialist solutions such as Alteryx if the requirements in terms of data volumes and complexity make this necessary. When solving more complex issues, we also form interdisciplinary teams of data analytics specialists and technical colleagues.

Guiding principles in our work 

Our support within projects is based on the following guiding principles:

  • The focus is on pragmatic solutions. In other words: we want to achieve the desired results with as little effort as possible.
  • We understand financial functions in detail and are able to quickly produce solutions that meet the needs of our clients.
  • We think proactively and are sparring partners in finding solutions.
  • We are empathetic, put ourselves in our client's shoes and take this into account in all aspects of our work.

 

Concrete project examples

The following are some examples of sub-projects that we have supported in this way:

  • Aggregation and visualization of IRO assessment (Impacts, Risks & Opportunities) data in the context of sustainability reporting

 

  • Extensive support for carve-outs in the Dax environment, including the following
    • Automated data quality checks to validate the business plans supplied.
    • Aggregation of business plans into an overall business plan, analyzable by division.
    • Development and delivery of "patches" that correct templates while retaining work already carried out.
    • Ad hoc analyses on specific issues (e.g. currency effects, variance analyses, top-down and bottom-up planning harmonization, etc.)

 

  • Data-driven ICS analyses, including with regard to
    • Checking BANF and order approvals (in particular validation of the approval workflow)
    • Analysis of payment proposal lists with regard to changes to master data (in particular IBANs)
    • Posting journal analyses (e.g. jumps in posting numbers, anomalies in debtor and creditor numbers)
    • Analysis of transaction data with regard to anomalies (e.g. missing approvals, subsequent changes without approvals, etc.)
    • Checking system authorizations in accordance with the established governance structure

 

  • Variance analyses between US GAAP and IFRS as part of a chart of accounts analysis
  • Analysis of inventory data in the course of fixed asset and inventory stocktaking.
  • Implementation of various mitigation and automation solutions in the financial area (e.g. Excel-based SAP account application workflow, CSV builder for semi-automated generation of mass purchase orders, accruals for outstanding invoices, semi-automated consolidation folders including data import and validation functions, etc.)

 

We will gladly look at your specific needs and discuss with you how we can best support you. Get in touch with us! 

bild faerber-nikolaus
WTS Advisory
Nikolaus Färber
Board WTS Advisory
Sustainibility Auditor (IDW)
Friedenstraße 22
81671 München
+49 (0) 89 28646-2700

Your contact to us

Do you have any questions about our services or WTS Advisory? We look forward to your message or your call!

Contact
Contact Legal notice Data Privacy Statement