English
German
Help & Support
What's New
What's New in Lucanet?
New on the Lucanet CFO Solution Platform
New in Consolidation & Financial Planning
New in Lucanet xP&A
New in ESG Reporting
New in Disclosure Management
New in XBRL Tagger
New in Lease Accounting
New in Banking & Cash Management
New in Tax Compliance & Reporting
New in Data Collection
Documentation
Getting Started
Opening CFO Solution Platform
User Interface
Basic Configuration
Global Functions
Notifications
Task Center
Lucanet Copilot
Administration
User Management
Managing the CFO Solution Platform
Extended Planning & Analysis (xP&A)
All Steps at a Glance
Creating a Model
Modeling Your Data
Consolidation & Financial Planning
Dashboards
Reporting & Analyzing
Import and Journals
ESG Reporting
Creating Report
Collecting Data for ESG Report
Checking Data
Disclosure Management
All Steps at a Glance
Basic Configuration
Cockpit
XBRL Tagger
All Steps at a Glance
Basic Configuration
Dashboard
Lease Accounting
All Steps at a Glance
Basic Configuration for Lease Accounting
Selecting a Lessee
Tax Compliance & Reporting
Income Taxes
Tax Administration
Pillar 2
Tax Balance
Banking & Cash Management
Data Collection
All Steps at a Glance
Basic Configuration
Collecting Data
Glossary
FAQs
Lucanet Learning Space
Table of Contents
Related Articles
Getting Started
Basic Configuration
User Interface
Opening CFO Solution Platform
Differences Between Lucanet.Financial Client and CFO Solution Platform
Non-Production Environments
Global Functions
Notifications
Task Center
Lucanet Copilot
Administration
User Management
Defining User Permissions for Data Model Roles
Change Log
User Roles
Managing the CFO Solution Platform
Managing Lucanet Licenses
Configuring External Authentication
Configuring Lucanet OIDC Authentication with Microsoft Entra ID/Azure
Configuring Lucanet SAML Single Sign-On with Microsoft Entra ID/Azure
Configuring Customizations
Generating and Downloading SEA Certificates
Extended Planning & Analysis (xP&A)
xP&A Video Tutorials
User Roles in Lucanet xP&A
Lucanet xP&A User Interface
Using Keyboard Shortcuts
All Steps at a Glance
Basic Concepts and Elements
Creating a Model
Integrating Data
Connecting to a Data Source
Connecting to a Spreadsheet
Connecting to an Accounting System
Connecting to a BI/Database System
Defining Database Queries
Connecting to BigQuery
Connecting to Postgres
Connecting to Databricks
Connecting to Microsoft SQL Server
Connecting to MySQL
Connecting to Redshift
Connecting to Snowflake
Connecting to Looker
Connecting to a CRM System
Connecting to an HRIS/Payroll System
Connecting to a Lucanet CFP Data Source
Connecting to a Source System Using a Webhook
Sharing Data Connections
Working With Integrated Data
Linking Variables to Integrated Data
Linking Dimensions from a Data Source
Using the 'Import Data Until' Function
Refreshing a Data Source
Drilling Down on Integrated Data
Guideline for Exchanging Data Between xP&A and CFP
Connecting to a Lucanet CFP Data Source
Initial Data Import from xP&A to CFP
Creating a Data Export in xP&A for CFP
Creating and Configuring the Script Lucanet xP&A #3700-xP&A.SQL.FOS
Creating and Configuring the Data Source
Creating an Assignment Table
Creating and Executing the Data Import into CFP
Updating the Data Import from xP&A to CFP
Modeling Your Data
Creating and Editing Variables
Using Sections
Using Groups
Moving Variables
Referencing Variables From Linked Models
Aggregation Functions
Relative Time for Variables
Creating Variables Using AI
Creating and Editing Formulas
Helper Variables
Variable Modifiers
IF Statements in Formulas
Functions for Formulas
Common Formulas
Troubleshooting
Values with Uncertainty
Working with Time
Different Time Granularities
Last Actual Date
Using Dimensions
Creating and Editing Dimensions
Dimensions, Variables, and Formulas
Aggregating Dimensions
Using Currency and Currency Translation
Viewing and Visualizing Data
Using Dashboards
Using Scenarios
Using Charts
Importing or Exporting Charts
Using Tables
Using Views
Sharing Views
Comparing Versions or Scenarios in Charts and Tables
Using Time Aggregation and Relative Comparisons
Working with Models
Editing the Model Settings
Organizing Models
Linking Models
Cloning a Model
Sharing a Model or Folder
Sharing a Model
Sharing a Folder
Exporting a Model
Versioning a Model
Viewing the Audit Logs of a Model
Troubleshooting for Slow or Large Models
Cells and Limits
Multi-Player Modeling
Proposing Changes to a Model
Handling Errors in a Model Using AI
Using Comments and Descriptions
Comparison: xP&A vs. Excel Performance
Consolidation & Financial Planning
User Interface of Lucanet Consolidation & Financial Planning
General Functions
Using Keyboard Shortcuts
Functions Used to Change the Display
Functions in the Tree View
Functions in the Detail View
Executing Multiple Elements Using Workflows
Basic Configuration
Changing the Data Model Language of Consolidation & Financial Planning
Installing and Updating Lucanet.Script Execution Application
Configuring Attributes
Dashboards
Displaying and Configuring Dashboards
Editing Dashboards
Reporting & Analyzing
Elements in Ledgers and Schedules
Creating and Configuring Items
Creating and Configuring Accounts
Creating and Configuring Formulas
Creating and Configuring Total Lines
Creating and Configuring References
Show Postings
Functions in Ledgers and Schedules
Creating Postings in Ledgers and Schedules
Displaying and Configuring Charts
Drill Down in Ledgers and Schedules
Exporting values to MS Excel or as a PDF
Display in Ledgers and Schedules
Changing the Display
Configuring Display Settings
Formatting Numbers and Dates
Configuring the Dimension Bar
Views in Ledgers and Schedules
Creating and Configuring Views
Elements in Directory Structures
Reclassification of Profit or Loss from Previous Periods in Reporting Entities
Adjust and Reclassify Values in Reporting Entities
Creating a Postings Report
Import and Journals
Journals
Using Journals
Postings in Journals
Creating and Configuring Postings in Journals
Translation with Historical Exchange Rates
Importing Data into Reporting Entities
All Steps at a Glance
Defining a Data Source
MS Excel file (.xls, .xlsx) (#1000)
Provision via script (#2075)
Lucanet.Financial Warehouse (#2068)
Creating Assignment Tables
Creating and Executing the Data Import
Assigning Data
Finalizing Data Import
Updating Data Imports
Importing data into Lucanet.Financial Warehouse
All Steps at a Glance
Defining a Data Source
Configuring Database Connections
Creating and Configuring Data Transformations
Creating and Configuring Execution Settings
Executing the Data Import
Configuring Period Locks
Creating and Executing Scripts
Planning
All Steps at a Glance - Planning
Accounting Rules
Configuring Payments
Configuring Investments
Configuring Accruals and Deferrals
Configuring Contra Entries
VAT/Input Tax Administration
Additional Accounting Rule Options
Planning Using Sheets
Dependent Business Transactions
Planning Using Planning Wizards
Creating and Configuring Current Account Interest Wizards
Creating and Configuring Loan Wizards
Creating and Configuring Transfer Actual Balance to Plan Wizards
Planning Using CFP Add-in for Excel 365
Consolidation
Consolidation 1
All Steps at a Glance
Creating and Configuring Consolidation Areas
Creating and Editing Configurations
Creating and Configuring Consolidation Wizards
Automatic Cancellation in the First Planning Month
Consolidation 2
All Steps at a Glance
Basic Elements
Defining the Group Structure
Consolidation Dimensions and Consolidation Dimension Elements
Consolidation Areas and Units
Administrating Master Data
Creating Consolidated Financial Statements
Creating and Configuring Data Transfer and Proportioning
Creating and Configuring Consolidation Apps
Debit/Credit Shifts in Consolidation Areas
Elimination of Income from Investments
Elimination of Intercompany Income and Expense
Elimination of Intercompany Debt
Equity Elimination
Reclassification of profit or loss from previous year in consolidation areas
Elimination of Intercompany Profit or Loss in Current Assets
Notes on Migration from Lucanet.Financial Client
Adjust and Reclassify Values in Consolidation Areas
Executing the Consolidation
Dimensions
Organization Elements
Creating and Configuring a Structure
Creating and Configuring Organization Groups
Creating and Configuring References
Creating and Configuring Total Lines
Configuring Residual Amounts
Currency Translation
Creating and Configuring Currencies
Creating and Configuring Exchange Rate Tables
Importing Exchange Rates
Exporting Exchange Rates
Partner
Creating and Configuring Partners
Creating and Configuring Partner Groups
Data Levels
Creating and Configuring Planning Data Levels
Synchronizing Planning Data Levels
Adjustment Levels
Creating and Configuring Adjustment Levels
Creating and Configuring Adjustment Levels for Consolidation Postings
Creating and Configuring Adjustment Level Groups
Transaction Types
Creating and Configuring Transaction Type Categories
Creating and Configuring Transaction Types
Fiscal Years
Creating and Configuring Fiscal Years
Reporting Entities
Creating and Configuring Reporting Entities
Creating and Configuring Consolidation Reporting Entities
Creating and Configuring Cost Centers and Cost Center Groups
Creating and Configuring Total Lines
Configuring Values of Attributes
Excel-Integration
Lucanet.Excel-Reporting
Configuring Workspaces
Creating Reporting Templates
Working with Tilde Formulas
Placeholder
Functions
Statements
Defining Properties of Return Values
Generating Excel Reports
CFP Add-in for Excel 365
Installing the CFP Add-In for Excel 365
Querying Data from Lucanet
LUCANET Formulas
Querying Values
Querying Exchange Rates
Querying Comments
Querying Attributes
Transferring Data from MS Excel to Lucanet
Required Keywords
Optional Keywords
Troubleshooting Guide
Migrating From Integrated Excel.Add.-in to CFP Add-in for Excel 365
Workspace Configuration
Editing the Properties of the General Ledger
Creating and Configuring Statistical Ledgers
Creating and Configuring Subledgers
Creating and Configuring Schedules
Creating and Configuring Directory Structures
ESG Reporting
User Roles and User Interface in ESG Reporting
General Functions in ESG Reporting
All Steps at a Glance – ESG Reporting
Creating Report
Working with Duplicated ESG Reports
Mapping Double Materiality Assessment Results
Configuring the Report Questionnaire
Structure of the Report Questionnaire
Using the Questionnaire Builder
Starting Data Collection
Collecting Data for ESG Report
Collecting and Reviewing ESG Data
Assigning Users as Editors or Reviewers
Displaying Aggregated Responses During Data Collection
Filling Out Report Questionnaire
Reviewing Data
Filling Out the Emissions Module
AI-Supported Import: End-to-End Process Overview
Collecting EU Taxonomy Data
Status Update per Reporting Entity
Assessing Minimum Safeguards
Creating a Business Activity and Performing the Eligibility Assessment
Covering SCC and DNSH Questionnaires
Collecting Financial Data
Checking Data
Generating ESG Report
Exporting Data
Creating Custom Emission Factors
Reopening an ESG Report
Canceling an ESG Report
Disclosure Management
The Lucanet Disclosure Management User Interface
Notifications
All Steps at a Glance
Basic Configuration
Installing and Updating the Dispatcher and Ribbons
Creating and Editing User Roles for Disclosure Management
Disclosure Management Settings
Dashboard
Configuring a Document
Cockpit
Detail View of a Chapter
Attachments
Creating and Editing Chapters
Creating and Editing Periods
Importing Data
Defining Connection to a Data Source
Defining a Data Source
Configuring and Executing a Data Import
Working with MS Office Files
Ribbons for Disclosure Management
Creating and Editing Excel Files
Mode of Excel Files
Configuring an Excel File
Names and Name Extensions in MS Excel
Creating and Editing Columns
Inserting Report Values in MS Excel
Defining Outareas
Programming References
Using Layouts in MS Excel
Inserting Tables From ESG Reports
Creating and Editing Word Files
Inserting Outareas into a Word Document
Using Text Values in MS Word
Using Layout Actions in MS Word
Inserting XBRL Tags
Inserting Texts From ESG Reports
Using Copilot for Disclosure Management
Working with Word References
Versioning and Recovery of MS Office Files
Creating and Inserting Document Variables
Creating and Editing Validations
Using the Data View
Configuring the Data View
Editing Values
Using the XBRL Tagger
Creating Result Document
Displaying History of a Result Document
Rolling Forward or Copying a Document
Editing Documents in the XBRL Tagger
XBRL Tagger
Introduction to iXBRL
User Interface of the Lucanet XBRL Tagger
All Steps at a Glance
Basic Configuration
Configuring Document Settings
Preparing a Word File
Dashboard
XBRL Document
Tagging a Document
Working with Layers
Displaying and Editing the Status of Tags
Displaying and Editing Properties of Tags
Validations in XBRL Documents
Creating a Taxonomy Extension
Calculation View
Custom Hierarchies
Using Hidden Elements
Managing Continuation Chains
Working with Footnotes
Generating an iXBRL Report
Displaying Result Documents
Displaying the Preview
Analyzing XBRL Data with Lucanet XBRL Vision
Lease Accounting
General Functions in Lease Accounting
User Roles in Lease Accounting
All Steps at a Glance
Basic Configuration for Lease Accounting
Importing and Configuring Reporting Entities
Creating and Configuring Asset Classes
Creating and Configuring Interest Rates
Creating or Importing Cost Centers
General Configurations
Selecting a Lessee
Collecting Data
Creating and Configuring Lessors
Creating and Configuring Contracts
Creating and Configuring Contract Components
Importing Data Automatically
Viewing Import History
Reversing Components
Categorizing Components
Calculating Data
Creating Postings
Reversing Postings
Exporting Reports and Postings
Importing Postings into Consolidation & Financial Planning
Banking & Cash Management
Data Collection
All Steps at a Glance
User interface of Data Collection
User Roles in Data Collection
Basic Configuration
Creating and Configuring Form Templates
Creating and Configuring Validation Rules
Importing Reporting Entities from Consolidation & Financial Planning
Creating and Configuring Reporting Packages
Collecting Data
Starting Data Collection Processes
Entering, Validating, and Approving Data
Importing Data
Importing Data from Excel
Importing Data from Consolidation & Financial Planning
Importing Data from Lucanet.Financial Warehouse
Tax Compliance & Reporting
Tax Administration
Users
Roles
Role Allocation
Certificates
E-Mail Templates
E-mail Configuration
Notes
Settings
Income Taxes
User Interface of Income Taxes
General Functions
Modules and Additional Functions in Income Taxes
Income Tax Forms
Income Tax Forms – Assessment Period 2024
Income Tax Forms – Assessment Period 2023
Income Tax Forms – Assessment Period 2022
Income Tax Forms – Assessment Period 2021
Income Tax Forms – Assessment Period 2020
Income Tax Forms – Assessment Period 2019
Master Data
Periods
Creating and Configuring Periods
Updating Calculation Bases and Patches
Exporting Periods
Importing Periods
Countries
Creating and Configuring the Element Type Country
Importing Exchange Rates
Reporting Dimensions
Companies
Foreign Branches / Fonds
CoA Group
CoA Company
Toolbox
Interfaces
Configuration
Structure
Position Mapping
Import Mapping
Administration
Company
Status
Resetting Milestones
Workflow Bot
Basic Data
Notification of Tax Arrangements
Ausländische Zwischengesellschaften (Foreign Intermediate Companies)
Foreign Branches / Fonds
Aufteilungsquoten (Allocation Quotas)
Import
Import Suite
Interface to Lucanet Consolidation and Financial Planning (CFP)
Deferred Taxes
B/S Comparison
Loss Carried Forward
Other Deferred Taxes - Company
Summary
TRR - Company
Reports in the 'Company' Area
OBD
Current Taxes
TB Transfer
§ 8b KStG
Zuwendungen (Grants)
Rollforward LCF
Corporate Income Tax
Local Tax
Decomposition
Transfer zum OT (Transfer to Tax Group Parent)
Current Taxes
Displaying an Einheits-GmbH & Co. KG
Current Taxes in Switzerland
Capital Gains Tax on Dividends
Report Tax Balance Based Profit
(Special) Investment Income
Interest Capping Rule
Transfer zum Anteilseigner (Transfer to Shareholder/Partner)
Einkünfte (Revenue)
§ 15a EStG
Angaben für MU (Information for Partners)
Feststellung (Determination)
Anlage Bekanntgabe (Notification Attachment)
Tax Liabilities
KapEStA
Electronic Transmission
Data Transmission
Fast Entry
Validation
Data Transfer
Data Export
Validation
Comments
Snapshots
True-Up
(Sub-) Group
Status (Sub-)Group
Deferred Taxes of (Sub-)Group
TRR (Sub-)Group
Validation (Sub-)Group
Reports in the '(Sub-)group' Area
Report DT
Report DT Pos
Report VV
Report TRR
Import, Batch Import, and Automation
Reporting
Tax Reports
Reporting Engine
Report Repository
Differences
Pillar 2
Cockpit
Status Monitoring
Import
Group Data Collection
Jurisdictional Data Collection
Jurisdictional Elections
Entity Data Collection
Home
OECD-Standard
Tax Allocations
FTE & PE Allocations
Cross-border Adjustments
Calculation
Snapshots
Overview Results
Group Data
Detail Results
C0 – Safe Harbour Check
C1 – NMCE Safe Harbour
C2 – CE Calculations
C3 – De Minimis Check
C4 – Jurisdictional Blending
C5 – Top-up Tax Allocation
Country-by-Country Reporting
Cockpit
Status Monitoring
Import
Group Data Collection
Entity Data Collection
Home
Financial Data
Business Activities
CE Information
Calculation
Snapshots
Group Data
CbC Report in XML format
Tables 1, 2, and 3
Tax Balance
User Interface and General Functions
Administrating Master Data
Creating a Company
Creating Tax Balance Sheets
Notes on Taxonomies
Creating an Adjustment Level
Creating and Configuring an Interface
Importing Master Data from Income Taxes
Performing a Mass Import
Creating Reorganizations
Importing Balance Sheet Structure from Income Taxes
Importing E-Balance Data into Tax Balance
Creating a Tax Balance Sheet for an Individual Company
Opening a Tax Balance Sheet
Managing GCD Master Data
Configuring Tax Balance Sheet Settings
Importing Data
Maintaining GAAP Reports
Creating and Configuring Adjustments
Configuring Functions
Configuring Reorganizations
Creating Reports
Transmitting an E-Balance Sheet
Exporting Data
Glossary
Documentation
Getting Started
WhatsNew PDFs
Last updated on 2025-09-24
Overview
Page with links to WhatsNew PDFs
What's New PDFs
What's New in Lucanet 25.1
Verwandte Artikel / Related articles
Back to Top
Contact Us