# Lucanet Support Documentation > Official product documentation for the Lucanet CFO Solution Platform — > Administration, Consolidation & Financial Planning, Disclosure Management, > ESG Reporting, Lease Accounting, xP&A and more. Maintained by the Lucanet > knowledge management team. Source of truth: https://support.lucanet.cloud. > > This file is the entry point for LLMs. Every link below points to a Markdown > version of a page (URL + `.md`). Strip `.md` to read the same page in a > browser. A full-corpus single file is available at /llms-full.txt. ## Getting Started Enjoy a seamless user experience and effortless financial management. The new Lucanet Cloud Platform provides a smooth, standardized UX with uniform functions for all the solutions you run on it. - [Basic Configuration](https://support.lucanet.cloud/en/documentation/getting-started/basic-configuration.md): On this page, you will find an overview of basic settings and key system information in the Lucanet CFO Solution Platform. You can change the language of the user interface, configure date and number formats, change your password, view your user profile, manage consents you have granted for external services, see the current Lucanet version, and, as an administrator, download SBOM files in JSON format. - [Differences Between Lucanet.Financial Client and CFO Solution Platform](https://support.lucanet.cloud/en/documentation/getting-started/differences-lnfc-platform.md): This article addresses users migrating from Lucanet.Financial Client to the CFO Solution Platform. It provides an overview of the key differences, such as access and login, administration, renaming, and functional differences. - [Getting Started](https://support.lucanet.cloud/en/documentation/getting-started.md): Enjoy a seamless user experience and effortless financial management. The new Lucanet Cloud Platform provides a smooth, standardized UX with uniform functions for all the solutions you run on it. - [Non-Production Environments](https://support.lucanet.cloud/en/documentation/getting-started/non-production-environments.md): Lucanet offers non-production environments for customers with an existing production license. These environments are isolated copies of your production system and allow you to test safely without affecting your live data or configuration. Two types of non-production environments are available for limited solutions: Test Update Environment and Sandbox Environment. - [Opening CFO Solution Platform](https://support.lucanet.cloud/en/documentation/getting-started/opening-cfo-solution-platform.md): The Lucanet CFO Solution Platform is displayed in your browser. You can open it by entering the corresponding URL. There are several different ways of opening the Lucanet CFO Solution Platform. - [User Interface](https://support.lucanet.cloud/en/documentation/getting-started/user-interface.md): The Lucanet CFO Solution Platform is the user interface for end users and Lucanet administrators in the web view. This page contains information about the structure of the user interface and the most important elements. ## Global Functions Global functions in the Lucanet CFO Solution Platform can be used independently of individual solutions. These functions are available in the main menu and support you with cross-platform tasks. - [Global Functions](https://support.lucanet.cloud/en/documentation/global-functions.md): Global functions in the Lucanet CFO Solution Platform can be used independently of individual solutions. These functions are available in the main menu and support you with cross-platform tasks. - [Lucanet Copilot](https://support.lucanet.cloud/en/documentation/global-functions/copilot.md): Lucanet Copilot is an AI-based chat functionality designed to provide quick answers and insights within the CFO Solution Platform. It leverages the Lucanet Knowledge Base to respond to general questions about Lucanet and also offers insights into consolidation- and financial planning-related data. - [Notifications](https://support.lucanet.cloud/en/documentation/global-functions/notifications.md): The Notifications section provides a centralized interface for managing notifications from your licensed solutions as well as global and administrative functions, i.e., Task Center and Administration. You can view and manage all your notifications in one convenient location, ensuring you never miss important updates about your work. - [Task Center](https://support.lucanet.cloud/en/documentation/global-functions/task-center.md): The Task Center provides a unified interface for managing tasks across the Lucanet CFO Solution Platform and is accessible directly from the main menu. Each task is assigned a unique task identifier (for example, T1234) for easy reference and tracking. ## Administration The Administration area of the Lucanet CFO Solution Platform acts as a central hub for user management and the administration of the Lucanet CFO Solution Platform. - [Administration](https://support.lucanet.cloud/en/documentation/administration.md): The Administration area of the Lucanet CFO Solution Platform acts as a central hub for user management and the administration of the Lucanet CFO Solution Platform. - [Change Log](https://support.lucanet.cloud/en/documentation/administration/user-management/change-log.md): As an administrator, you can use the change log to efficiently monitor and manage all changes to user management. You can view a user's change log or an overview of all user changes. - [Configuring Customizations](https://support.lucanet.cloud/en/documentation/administration/platform-management/customization.md): In the Customization workspace, you as an administrator can customize certain elements of the Lucanet CFO Solution Platform to match your corporate design. Currently, you can upload your company logo and configure it for use on the start page, in the top bar and in email templates. - [Configuring External Authentication](https://support.lucanet.cloud/en/documentation/administration/platform-management/configure-ext-authentication.md): In the External authentication workspace of the Lucanet CFO Solution Platform, you can configure that a user is authenticated via a central instance in the network. The separate maintenance of the password for access to the CFO Solution Platform can then be omitted. - [Configuring Lucanet OIDC Authentication with Microsoft Entra ID/Azure](https://support.lucanet.cloud/en/documentation/administration/platform-management/configure-ext-authentication/entra-id-registration-OIDC.md) - [Configuring Lucanet SAML Single Sign-On with Microsoft Entra ID/Azure](https://support.lucanet.cloud/en/documentation/administration/platform-management/configure-ext-authentication/entra-id-registration-saml.md) - [Defining User Permissions for Data Model Roles](https://support.lucanet.cloud/en/documentation/administration/user-management/defining-user-permissions.md): In the User management workspace of the CFO Solution Platform, you can define read and/or write permissions for data model roles when editing Consolidation & Financial Planning users. - [Generating and Downloading SEA Certificates](https://support.lucanet.cloud/en/documentation/administration/platform-management/certificates.md): The Certificates workspace allows administrators to generate and download certificates for Lucanet.Script Execution Application (SEA). These certificates are used to install SEA in Lucanet.Software Manager and to configure SEA applications in Consolidation & Financial Planning within Lucanet CFO Solution Platform. - [Managing Lucanet Licenses](https://support.lucanet.cloud/en/documentation/administration/platform-management/licenses.md): Overview of licensed solutions, license packages, and license slots in the Lucanet CFO Solution Platform, and self-service license upgrades by License Managers. - [Managing the CFO Solution Platform](https://support.lucanet.cloud/en/documentation/administration/platform-management.md): The ‘Platform management’ functional area of the Administration area in the Lucanet CFO Solution Platform allows you to view your license information and manage your external authentication. - [User Management](https://support.lucanet.cloud/en/documentation/administration/user-management.md): The user management in Administration allows you to create, manage and delete users for the Lucanet CFO Solution Platform. - [User Roles](https://support.lucanet.cloud/en/documentation/administration/user-management/user-roles.md): Overview of all user roles in the Lucanet CFO Solution Platform: roles for Administration (Administrator, License Manager) and solution-specific roles. ## Extended Planning & Analysis (xP&A) Modeling, forecasting, planning - Lucanet xP&A enables your business with a 360° view of planning and analysis data from a single source of truth. - [Aggregating Dimensions](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/using-dimensions/aggregating-dimensions.md): The dimension aggregation function determines how the values of different dimension items are combined into one value. This affects the summary value when a variable is collapsed, aggregating the variable in formulas and grouping by other dimensions (see Dimension modifiers). - [Aggregation Functions](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-edit-variables/aggregation-functions.md): Lucanet xP&A has three types of Aggregation Functions that determine how a variable 'rolls up' Categories, Time, and Data respectively. - [All Steps at a Glance](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/process-description-xpa.md): In this chapter, you will find the individual steps required to create and use models for the planning and analysis of your data. The step descriptions also contain links to more detailed descriptions. - [Basic Concepts and Elements](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/basic-concepts-and-Elements.md): The following section describes the most important concepts and elements in Lucanet xP&A. Further details can be found under the links provided. - [Cells and Limits](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/cells-and-limits.md) - [Cloning a Model](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/cloning-a-model.md): By cloning a model, you can create an identical copy of the model. - [Common Formulas](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-andedit-formulas/common-formulas-.md): The following topic give you a taste of common formulas used in Lucanet xP&A, across different themes/use cases. - [Comparing Versions or Scenarios in Charts and Tables](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/viewing-and-visualizing-data/comparing-versions-or-scenarios-in-charts-and-tables.md): In xP&A, you can easily compare versions or scenarios of your model on charts and tables. - [Comparison: xP&A vs. Excel Performance](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/xpa-vs-excel.md) - [Connecting to a BI/Database System](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system.md): You can establish a direct data connection to different BI/Database systems to pull in data into xP&A. The following applies: In order to set up the integration, you must follow individual authentication procedures to link to your system account with xP&A. Detailed set-up instructions are provided for each supported system. All fields (variables and dimensions) that are pulled in need to be defined individually for each BI/Database system using custom queries. For instructions on how to define such queries, see Defining Database Queries. For some systems a connection using an SSH tunnel can be configured. - [Connecting to a CRM System](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-crm.md) - [Connecting to a Data Source](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source.md): In order to integrate data from a source system into Lucanet xP&A, you need to establish a connection to the respective data source. There are two ways of connecting to data sources: Via the Data workspace From within a model You can create various data sources for the same source system integration (e.g. to connect to multiple Google accounts). - [Connecting to a Lucanet CFP Data Source](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-lucanet-cfp-data-source.md) - [Connecting to a Lucanet CFP Data Source](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP/connecting-to-cfp-copy.md): You can connect to a Lucanet CFP Data Source to pull in data from Lucanet Consolidation & Financial Planning into xP&A. - [Connecting to a Source System Using a Webhook](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-using-webhook.md) - [Connecting to a Spreadsheet](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-spreadsheet.md): In xP&A, you can connect to the following spreadsheet file formats: Google Sheets, Excel Online, Excel Upload, CSV Upload The following three data formats for spreadsheet files are supported: Tables, Transactions, Time-series Each connected file needs to be formatted in a certain way so that the data can be imported into xP&A. - [Connecting to an Accounting System](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-accounting-erp.md) - [Connecting to an HRIS/Payroll System](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-payroll-provider.md): You can establish a direct data connection to various HRIS/Payroll systems to pull in payroll data into xP&A. - [Connecting to BigQuery](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-bigquery.md): In xP&A, you can connect to the following spreadsheet file formats: Google Sheets, Excel Online, Excel Upload, CSV Upload The following three data formats for spreadsheet files are supported: Tables, Transactions, Time-series Each connected file needs to be formatted in a certain way so that the data can be imported into xP&A. - [Connecting to Databricks](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-databricks.md): In xP&A, you can connect to the following spreadsheet file formats: Google Sheets, Excel Online, Excel Upload, CSV Upload The following three data formats for spreadsheet files are supported: Tables, Transactions, Time-series Each connected file needs to be formatted in a certain way so that the data can be imported into xP&A. - [Connecting to Looker](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-looker.md): You can establish a connection to Looker to pull in data into xP&A. To set up the connection, a Webhook data source is required. The following steps are necessary, which are explained in this article: - Create a Look containing the data you want to have in your xP&A data source. - Create a Webhook data source in xP&A. - Set up the scheduled export in Looker. - [Connecting to Microsoft SQL Server](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-mssqlserver.md): You can establish a direct connection to Microsoft SQL Server to pull in data into xP&A. It is possible to use an SSH tunnel for the connection. - [Connecting to MySQL](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-mysql.md): You can establish a direct connection to MySQL to pull in data into xP&A. It is possible to use an SSH tunnel for the connection. - [Connecting to Postgres](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-Postgres.md): You can establish a direct connection to Postgres to pull in data into xP&A. It is possible to use an SSH tunnel for the connection. - [Connecting to Redshift](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-redshift.md): You can establish a direct connection to Redshift to pull in data into xP&A. It is possible to use an SSH tunnel for the connection. - [Connecting to Snowflake](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/connecting-to-snowflake.md): In xP&A, you can connect to the following spreadsheet file formats: Google Sheets, Excel Online, Excel Upload, CSV Upload The following three data formats for spreadsheet files are supported: Tables, Transactions, Time-series Each connected file needs to be formatted in a certain way so that the data can be imported into xP&A. - [Creating a Data Export in xP&A for CFP](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP/importing-data-from-xpa-to-cfp/creating-data-export-in-xPA-for-CFP.md): Before data from xP&A can be transferred to Consolidation & Financial Planning, an export containing the desired data needs to be created in xP&A for each model. - [Creating a Model](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/creating-model.md): A model in Lucanet xP&A refers to a structured representation of data and calculations, similar to a tab in a spreadsheet. You can define a model as your "base" model representing the default scenario. To compare different scenarios, you can create variants of your "base" model in which some variables (or cells of a variable) have different values or formulas. - [Creating an Assignment Table](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP/importing-data-from-xpa-to-cfp/creating-an-assignment-table-for-import-of-xPA-data.md): An assignment table is used to save all elements imported from xP&A (e.g. accounts, reporting entities/cost centers, transaction currency, etc.) and their assignment to elements in CFP. Assignments are defined during the data import and can then be changed or deleted at any time. - [Creating and Configuring the Data Source](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP/importing-data-from-xpa-to-cfp/creating-and-cconfiguring-the-data-source-for_xPA-import.md): Once you have configured the data transfer script xP&A #3700-xP&A.SQL.FOS, you can create and configure the data source for the import that uses the script and its parameters. - [Creating and Configuring the Script Lucanet xP&A #3700-xP&A.SQL.FOS](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP/importing-data-from-xpa-to-cfp/creating-and-configuring-the-script-used-for-xPA-import.md): In order to import an xP&A data export into CFP, you must first create and configure the data transfer script Lucanet xP&A #3700-xP&A.SQL.FOS. - [Creating and Editing Dimensions](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/using-dimensions/create-edit-dimensions.md): Dimensions are xP&A’s most powerful concept. Dimensions allow you to build your business’ structure directly into your financial models, removing the need for formula duplication and lookups. - [Creating and Editing Formulas](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-andedit-formulas.md): Formulas are one of the most important concepts in Lucanet xP&A. Formulas let you work with numbers, ranges, and other variables. - [Creating and Editing Variables](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-edit-variables.md): Variables are the building blocks of your models. If you're a spreadsheet user, you can think of them a bit like spreadsheet cells. If you're a programmer, you can think of them as, well, variables. You can define a variable using a formula. Formulas let you work with numbers, ranges, and other variables. - [Creating and Executing the Data Import into CFP](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP/importing-data-from-xpa-to-cfp/creating-and-executing-the-data-import-into-CFP.md): Once the script, the data source, and the assigment table to be used for the import have been created, you can create and execute the actual import and assignment of data in CFP. - [Creating Variables Using AI](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-edit-variables/creating-variables-using-AI.md) - [Defining Database Queries](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/connecting-to-a-data-source/connecting-to-a-bi-data-warehouse-system/defining-database-queries.md) - [Different Time Granularities](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/working-with-time/time-granularities.md): xP&A allows you to have different time granularities in your models and visuals. Granularity refers to the level of detail in which data of a model are organized. Adjusting granularity affects how detailed the data representation is, with finer granularity providing more detailed information and coarser granularity offering a broader overview. - [Dimensions, Variables, and Formulas](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/using-dimensions/dimensions-variables-and-formulas.md): This article provides step-by-step instructions on how to add, modify, and remove dimension breakdowns from variables in a data model. It further explores the application of formulas across dimensions, offering the ability to override and manage formulas for specific dimension items. Additionally, it covers techniques for sorting and filtering dimension data to enhance the organization and presentation - [Drilling Down on Integrated Data](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/working-with-integrated-data/drill-down-on-integrated-data.md): If you have data sources that contain underlying data (e.g. transactions from a source connected source system like Xero, QuickBooks Online, NetSuite, Google Sheets or a CSV import in transaction format), xP&A allows you to drill-down into the underlying detail, from any variables connected directly to that data. Drill-downs are possible from the dashboard or from the spreadsheet of a model. - [Editing the Model Settings](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/editing-model-settings.md): For every model, you can define certain time settings, which include the granularity, the date range, and the last actual date for your model. In addition, you can specify the use of relative dates and fiscal years and how you want to highlight certain time spans in your views. - [Exporting a Model](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/exporting-a-model.md): You can export your model(s) out of Lucanet xP&A into a variety of formats and file types. - [Extended Planning & Analysis (xP&A)](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis.md): Modeling, forecasting, planning - Lucanet xP&A enables your business with a 360° view of planning and analysis data from a single source of truth. - [Functions for Formulas](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-andedit-formulas/functions.md): In the following tables you will find functions that you can use in Lucanet xP&A formulas. - [Guideline for Exchanging Data Between xP&A and CFP](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP.md): Data can be exchanged in both directions between Lucanet Consolidation & Financial Planning (CFP) and Lucanet xP&A (Extended Planning and Analysis). CFP provides actual data for planning in xP&A; modelled planning data can be transferred back from xP&A into CFP. This guideline describes the end-to-end process and points to the detailed instructions for each step. - [Handling Errors in a Model Using AI](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/handling-errors-in-a-model.md) - [Helper Variables](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-andedit-formulas/helper-variables.md): In this article you will find the available helper variables for formulas in Lucanet xP&A. - [IF Statements in Formulas](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-andedit-formulas/if-statements-in-formulas.md): When you want a variable to have different values or formulas based on a condition, you can use if-statements. They always have to follow the structure if condition then X else Y. - [Importing or Exporting Charts](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/viewing-and-visualizing-data/using-tables-charts/importing-exporting-charts.md): This article describes how to import or export charts, e.g. to use a chart as an image outside of Lucanet xP&A. - [Initial Data Import from xP&A to CFP](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP/importing-data-from-xpa-to-cfp.md): Once the planning data is modeled in xP&A, you can then transfer this data into Consolidation & Financial Planning. CFP uses an import script (Lucanet xP&A #3700-xP&A.SQL.FOS) to read in xP&A exports. - [Integrating Data](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data.md): Data integrations let you connect the variables in your model to different data sources. In most cases, this is used to pull in actual data and to perform forecasts based on historicals. - [Last Actual Date](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/working-with-time/last-actual-date.md): The Last actual date is a model-level setting that represents your latest month (or week if in a weekly model) of "actual" historic data. It determines the cut-off date for importing data into your model (unless you have the option 'Import data until' set for a data source). - [Linking Dimensions from a Data Source](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/working-with-integrated-data/linking-dimensions-to-data-source.md): Often, you will import data broken down into dimensions — for example, employee data from your Payroll/HRIS system, or department expenses in Accounting/ERP systems. When you link a data item that has dimensions to a variable, xP&A will not breakdown the variable until you link an xP&A dimension to the dimension in the data source explicitly. You can link a dimension either from a model or from a data source. - [Linking Models](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/linking-models.md): Instead of a single model with all of your variables and formulas, you can structure your work into separate, smaller models, and import variables between them. - [Linking Variables to Integrated Data](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/working-with-integrated-data/linking-variables-to-integrated-data.md): To use the data you integrated via a connection to a source system in your variables in Lucanet xP&A , you can link the variables to the integrated data. You can use this function to perform forecasts based on historicals, for example. When a variable is linked to integarted data, it will take its value from the data if data exists, and will fall back to its formula if data does not exist (usually only beyond the Last actual date). You have different options to link variables to integrated data: You can link a new variable while creating it. You can link existing variables. You can link a variable from the data preview. You can create a model from a data source in one click. You can see which data items (from which data sources) are being used at a glance in the Data column: - [Lucanet xP&A User Interface](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/user-interface-xPA.md): This page contains information about the structure of the user interface and the most important elements in Lucanet xP&A. From this page, you can jump easily to the detailed descriptions of the individual areas and functions. - [Modeling Your Data](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data.md): Lucanet xP&A offers various elements to model your data so it can be used in your model. - [Moving Variables](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-edit-variables/moving-variables.md): You can move variables within a model, as well as between models. - [Multi-Player Modeling](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/multi-player-modeling.md): xP&A allows multiple users to work in the spreadsheet of a model at the same time. In this chapter we will explain what needs to be considered for multi-player modeling. - [Organizing Models](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/organizing-models.md): For a better overview, models can be organized in folders and sub-folders. In addition, you can assign a specific icon to identify a model easier, and you can set up favorites for your models. - [Proposing Changes to a Model](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/propose-changes-to-model.md): The **Propose Changes** feature allows both Editors and Data Collectors to collaborate on model updates without directly modifying live data. Editors can now review, approve, or reject suggested updates before they’re applied — ensuring control, traceability, and teamwork. - [Referencing Variables From Linked Models](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-edit-variables/referencing-variables-from-linked-models.md): Instead of a single model with all of your variables and formulas, you can structure your work into separate, smaller models. Once linked, you can reference variables between them as described in this chapter. - [Refreshing a Data Source](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/working-with-integrated-data/refreshing-a-data-source.md): In order to keep your integrated up to date and to reflect the current status of your historical data, your data sources needs to be refreshed. You can refresh your data source manually or using an automatic refresh function, and you can view the history of each data refresh at any time. - [Relative Time for Variables](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-edit-variables/relative-time-for-variables.md): Sometimes variables don't refer to specific calendar time steps of your model (Jan 2022, Feb 2022) but refer to relative time (Month 1, Month 2). In this chapter, you get to know how to format a variable as a relative time. - [Sharing a Folder](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/sharing-a-model-folder/sharing-folder.md): As well as sharing models, you can also share entire folders. This is useful when you have various models that you want to organise in a folder structure, and share with a common set of people (similar to Google Drive). - [Sharing a Model](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/sharing-a-model-folder/sharing-model.md): Once you have built a model, you will probably want to share it with others. By default, only you have access to your model, so you'll need to specify how you want to share it with others. - [Sharing a Model or Folder](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/sharing-a-model-folder.md): After building a model, you have the option to share this model with other users. You can also organize your model into folders and share folders if you want to grant access to multiple models at once. - [Sharing Data Connections](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/sharing-data-connections.md): By default, data connections and the data sources created from the connections are private to the user who created them. In order to be used by other users, you can share the connection to a data source with them. There are two ways to do this: If a data source in Lucanet xP&A is used in a model, then anyone with edit or higher access rights to that model can access that data source implicitly. The second way is to share the data connection directly with others from the Data workspace. A description of this option can be found in this article. - [Sharing Views](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/viewing-and-visualizing-data/using-views/sharing-views.md): Users with full or admin access to a model can share a view with other collaborators to give them only this specifically filtered view on this model. - [Troubleshooting](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-andedit-formulas/troubleshooting.md): This topic describes errors that can occur when working with formulas in Lucanet xP&A. A possible solution is described for all errors. - [Troubleshooting for Slow or Large Models](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/troubleshooting-slow-large-models.md) - [Updating the Data Import from xP&A to CFP](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP/updating-the-data-import-from-xPA-to-CFP.md): After the initial import into Consolidation & Financial Planning has been configured and executed for the first time, you then only need to update the CFP import every time you want to transfer updated xP&A data to CFP. The steps of this recurring update process are described in this Quick Reference Guide. - [User Roles in Lucanet xP&A](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/user-roles-xPA.md): There are three distinct types of permissioning in xP&A. Each type defines which what a user can see and do in Lucanet xP&A. - [Using Charts](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/viewing-and-visualizing-data/using-tables-charts.md): Charts can be used to visualize your data, either within the Spreadsheet workspace or the Dashboard workspace. - [Using Comments and Descriptions](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/using-comments-and-descriptions.md): There are two main areas for commenting in Lucanet xP&A: In the spreadsheet, to collaborate with fellow model builders and editors. On the dashboard, to collaborate with your end-users, e.g. your business partners, investors etc - [Using Currency and Currency Translation](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/currency---fx-conversion.md): Variables, if set to Currency format, have a Currency drop-down where you can explicitly choose the Currency (e.g. USD, JPY, GBP), which will set the currency prefix symbol (e.g. $ ¥ £) or wording (e.g. AUD). - [Using Dashboards](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/viewing-and-visualizing-data/using-dashboards.md): Dashboards are a nice way for others to view and interact with your model. It shows your model's input variables at the top, with its charts underneath. You also have the option to show them a read-only spreadsheet view, too. - [Using Dimensions](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/using-dimensions.md): Dimensions are Lucanet xP&A’s most powerful concept. This topic conceptually explains dimensions so that you can use them in your models. - [Using Groups](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-edit-variables/using-groups.md): Groups are sets of variables within sections. You can also create nested groups simply by creating a group under an existing group. - [Using Keyboard Shortcuts](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/user-interface-xPA/keyboard-shortcuts.md) - [Using Scenarios](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/viewing-and-visualizing-data/using-scenarios.md): A scenario is a live variant of your model in which some variables (or cells of a variable) have different values or formulas. The structure of the model — the variables, groups, and sections — doesn't change across scenarios. - [Using Sections](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-edit-variables/using-sections.md): Variables can be organized into several Sections in the spreadsheet view. - [Using Tables](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/viewing-and-visualizing-data/using-tables.md): Tables can be used to visualize your data, either within the Spreadsheet workspace or the Dashboard workspace. - [Using the 'Import Data Until' Function](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/working-with-integrated-data/import-data-until-function.md) - [Using Time Aggregation and Relative Comparisons](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/viewing-and-visualizing-data/time-aggregation-and-relative-comparisons.md): xP&A offers different functionalities to compare or aggregate your data in order to gain deeper insights, identify trends, and support strategic decision-making across planning and analysis workflows. - [Using Views](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/viewing-and-visualizing-data/using-views.md): Views let you create saved filters on your model, to show only specific variables, category items, scenarios, time periods, and charts. This can be useful if you as the model builder want to filter the model for a specific subset of things, or if you want to share only a View of your model with your collaborators, as opposed to the whole thing. - [Values with Uncertainty](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-andedit-formulas/values-with-uncertainty.md): This article explains how ranges and Monte Carlo simulations as well as different distribution shapes are used in xP&A to model uncertainty in formulas, enabling more realistic and probabilistic forecasting. - [Variable Modifiers](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/create-andedit-formulas/variable-modifiers.md): When you reference a variable in a formula, there are two key ways to modify it - using Categories (if applicable), and Time. - [Versioning a Model](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/versioning-a-model.md): Lucanet xP&A automatically takes snapshots of your model (or set of linked models) at regular intervals, and you can also manually save a named version of a model. - [Viewing and Visualizing Data](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/viewing-and-visualizing-data.md): Once you have set up your spreadsheets, you have multiple options to create certain views of your data or visualize your data, e.g. for presentation purposes or if you want to share your data with other users. - [Viewing the Audit Logs of a Model](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models/viewing-the-audit-logs.md): Audit logs are a model-by-model running history of who has made what edits (and when) to a model's variables, categories, visuals, or data. - [Working With Integrated Data](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/working-with-integrated-data.md): Once a connection to a source system is established and data is integrated from a data source, you can start working with the data in Lucanet xP&A. In this section, you will find out how you can: Use integrated data in variables Link dimensions from the data source to dimensions in xP&A Refresh data sources Use the function 'Import data until' Manage your data sources - [Working with Models](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/working-with-models.md) - [Working with Time](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/modeling-your-data/working-with-time.md): The key concept to understand about working with time in Lucanet xP&A is the timestep index system that can be applied in variables in formulas. - [xP&A Video Tutorials](https://support.lucanet.cloud/en/documentation/xp-a---extended-planning-and-analysis/x-pa-video-tutorials.md) ## Consolidation & Financial Planning Visualize data on the go, present analyses and reports simply at the touch of a button, put business decisions on a valid basis: With Lucanet Consolidation & Financial Planning, you have exactly the right tool for this. Display the most important key figures and comparison views in a dashboard. Access your reporting data in the shortest possible time - with maximum data security. - [Accounting Rules](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/planning/accounting-rules.md): The Accounting rules workspace is used for configuring rules for automatic contra entries. For each combination of data level and reporting entity, a journal exists in this workspace which contains all of the accounting rules for the respective combination pair. - [Adding Additional Information to an Element](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/general-functions/add-further-information-to-elements.md): Finanzdaten, Planungsannahmen und Konsolidierungsbuchungen sind oft komplex. Mithilfe des Reiters Weitere Informationen können Sie Elemente in Consolidation & Financial Planning direkt mit Notizen und Dateianlagen versehen – ohne das System zu wechseln. So können Sie z. B. nachvollziehbar dokumentieren, warum Sie bestimmte Anpassungen vorgenommen haben, welche Annahmen einer Planung zugrunde liegen oder welche Belege relevant sind. Ihre Teammitglieder können diese Informationen jederzeit einsehen und darauf aufbauen. Im integrierten Texteditor können Sie Notizen mit einfachen Formatierungsoptionen erfassen. Außerdem können Sie Dateianlagen hochladen, in einer Vorschau anzeigen, herunterladen und löschen. - [Additional Accounting Rule Options](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/planning/accounting-rules/accounting-rules-other-journals.md): The additional accounting rule options allow you to streamline your accounting configurations by using rules from superordinate elements, applying rules across different journals without recreating them, and efficiently organizing or removing rules within a journal. These features help save time, reduce duplication of work, and ensure consistency across your financial data. - [Adjust and Reclassify Values in Consolidation Areas](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/configuring-consolidation-apps/adjust-and-reclassify-values-in-consolidation-areas.md): Using the Adjust and Reclassify Values in Consolidation Areas app, account values can be adjusted and reclassified for each consolidation area. For example, you can: Correct erroneous values at the partner, cost center, and transaction type levels Reclassify account values from the general ledger or subledger to a statistical ledger Distribute values across multiple accounts - [Adjust and Reclassify Values in Reporting Entities](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/elements-in-directory-structures/adjust-and-reclassify-values-in-reporting-entities.md): You can use the Adjust and reclassify values in reporting entities app to adjust and reclassify account values per reporting entity. For example, it is possible to: - Correct incorrect values at partner, cost center, and transaction type level - Reclassify account values from the general ledger or a subledger to a statistical ledger - Distribute values to several accounts You can model the adjustments and reclassifications in freely definable scenarios with separate dimensions for the base values and the target postings. - [Adjustment Levels](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/adjustment-levels.md) - [Administrating Master Data](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/master-data-administration.md): To create consolidated financial statements, you first have to define the master data that form the basis for consolidation of a company within a group. - [All Steps at a Glance](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-1/all-steps-consolidation-1.md): Before the import into reporting entities is performed, the objects required for this must be created and configured based on their data source(s). The required objects can be created in any order. However, because the objects are built upon each other and interconnected, we recommend following the sequence of steps outlined. - [All Steps at a Glance](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/all-steps-consolidation-2.md): Before you can perform consolidation using Lucanet Consolidation 2, you must first create and configure the necessary elements and apps. Which elements you need to create depends on the organization and the structure of your company and on the chosen consolidation method. - [All Steps at a Glance](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-lnfwh/all-steps-data-import-lnfwh-entities.md): Before the import into reporting entities is performed, the objects required for this must be created and configured based on their data source(s). The required objects can be created in any order. However, because the objects are built upon each other and interconnected, we recommend following the sequence of steps outlined. - [All Steps at a Glance](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-reporting-entities/all-steps-data-import-reporting-entities.md): Before the import into reporting entities is performed, the objects required for this must be created and configured based on their data source(s). The required objects can be created in any order. However, because the objects are built upon each other and interconnected, we recommend following the sequence of steps outlined. - [All Steps at a Glance - Planning](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/planning/all-steps-planning1.md): Before you can perform your planning in Lucanet Consolidation & Financial Planning, the required objects must be created and configured in Lucanet. The required objects can be created in any order. However, because the objects are built upon each other and interconnected, we recommend following the sequence of steps outlined on this page. - [Assigning Data](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-reporting-entities/assign-data.md): If, during a data import, new elements have been read in for the first time from the dimensions Accounts, Reporting entities and cost centers, Partner, Transaction currency, Data levels, Adjustment levels, or Transaction types, these must be assigned (only once). - [Automatic Cancellation in the First Planning Month](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-1/cancellation-inthefirst-planning-month.md) - [Basic Configuration](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/basic-configuration-cfp.md): This page provides an overview of the basic configurations for Consolidation & Financial Planning, enabling you to adapt the solution to your needs. - [Basic Elements](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/basic-elements-conso-2.md): This page describes the most important elements in Consolidation 2. - [CFP Add-in for Excel 365](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in.md): Lucanet CFP Add-in for Excel 365 is an add-in that makes it possible to access data in the Lucanet.Financial OLAP Server from MS Excel. - [Changing the Data Model Language of Consolidation & Financial Planning](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/basic-configuration-cfp/configure-webclient0.md): In the overview of Consolidation & Financial Planning, you can set the language of the data model. The language of the data model includes all language-dependent elements created by the user, e. g. items and accounts. - [Changing the Display](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/display-ledgers-schedules/change-view.md): On the toolbar of a ledger or schedule, special display modes are available in the dimension bar, which you can use to adjust the display as required. - [Configuring Accruals and Deferrals](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/planning/accounting-rules/configure-accruals-deferrals.md): The Accruals and deferrals accounting rule type is used to enter business transactions for the appropriate period in Lucanet. Using this accounting rule type, for example, it is possible to plan business transactions in which the services are purchased or sold in advance whereas the payment is made as a one-off payment in advance. - [Configuring Attributes](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/basic-configuration-cfp/configuring-attributes.md): Attributes are used to define multilingual descriptions or customer-specific information for Lucanet elements. For example, you can use attributes to define the names of your accounts in multiple languages. - [Configuring Contra Entries](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/planning/accounting-rules/configure-contra-entry.md): The Contra entry accounting rule type is used for recording postings within or between P&L and balance sheet. This type of contra entry is used with depreciation in the fixed assets, for example. - [Configuring Database Connections](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-lnfwh/defining-data-source-lnfwh/datenbankverbindungen-konfigurieren.md) - [Configuring Display Settings](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/display-ledgers-schedules/configure-display-settings.md): General display settings, which you only have to configure once, can be defined for ledgers and schedules. The display settings automatically apply to all ledgers and schedules in the Reporting and analyzing workspace. - [Configuring Investments](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/planning/accounting-rules/configure-investment.md): The Investment accounting rule type can be used to plan new investments and their depreciation/amortization. The configuration specifies the bank account, value-added tax and cash flow impact. Furthermore, the rule including the useful life and the accounts for the accumulated depreciation/amortization in the balance sheet and the expense in the P&L are determined. - [Configuring Payments](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/planning/accounting-rules/configure-payment.md): The Payment accounting rule type is used for all accounts and items relating to business transactions with a cash flow impact. The Payment type is the most frequently occurring rule in the P&L. - [Configuring Period Locks](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/configure-period-locks.md): Period locks are used to lock and unlock all postings in Lucanet. All data imports, postings, data transfers from MS Excel, and entries in exchange rate tables must be permitted for the combination of data level, adjustment level, time and consolidation unit. - [Configuring Residual Amounts](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/organization-elements/configure-residual-value.md): Residual amounts are created automatically in the Organization elements workspace when displaying a group by levels using nested consolidation areas. - [Configuring the Dimension Bar](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/display-ledgers-schedules/configure-dimension-bar.md): The dimension bar can be used to configure the display as required. The settings made and the chosen dimensions determine the display in the tree view. - [Configuring Values of Attributes](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/configure-attribute-values.md): Attributes are used to define multilingual descriptions or customer-specific information for Lucanet elements. The configuration of attributes is generally possible for all dimensions, except for fiscal years. However, only the attributes that were defined in Lucanet.Financial Client in the Attributes workspace and have been activated for a dimension are displayed and can be edited. - [Configuring Workspaces](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/lucanet-excel-reporting/configure-workspace-excel-reporting.md): To enable the creation of Excel reporting templates in a workspace, a directory structure must exist in this workspace and that directory structure must contain object type Lucanet.Excel-Reporting. - [Consolidation](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation.md): The Lucanet.Financial Consolidation allows you to consolidate your enterprise. The Consolidation 1 enables wizard-based elimination of intercompany debt and elimination of intercompany income and expense. Consolidation 2 is an enhancement of Consolidation 1 that offers new functions as well as comprehensive automatic consolidation. - [Consolidation & Financial Planning](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning.md): Visualize data on the go, present analyses and reports simply at the touch of a button, put business decisions on a valid basis: With Lucanet Consolidation & Financial Planning, you have exactly the right tool for this. Display the most important key figures and comparison views in a dashboard. Access your reporting data in the shortest possible time - with maximum data security. - [Consolidation 1](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-1.md) - [Consolidation 2](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2.md): Lucanet Financial Consolidation is your solution for seamless and efficient financial consolidation. Automate the entire consolidation process with Consolidation 2 using apps and benefit from maximum transparency, accuracy and user-friendliness. - [Consolidation Areas and Units](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/defining-group-structure/consolidation-areas-and-units-conso-2.md): Consolidation areas are used to summarize all consolidation units that are to be consolidated together. This could be groups or sub-groups, for example. - [Consolidation Dimensions and Consolidation Dimension Elements](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/defining-group-structure/consolidation-dimensions-and-elements-conso-2.md): The consolidation dimension acts as an important link: It connects your existing organization elements with the consolidation areas. Organization elements represent, e.g., companies, business units, segments or cost centers. - [Creating a Postings Report](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/create-postings-report.md): In Lucanet Consolidation & Financial Planning, you can create and download a Postings report to analyze, audit, and share posting data. - [Creating and Configuring a Structure](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/organization-elements/create-configure-structure.md): The structure of your enterprise is recreated in the Organization elements workspace. - [Creating and Configuring Accounts](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/elements-ledgers-schedules/create-configure-accounts.md): All postings in Lucanet are made to accounts. Accounts are only changed by postings and therefore behave the same way as accounts in conventional financial accounting systems. - [Creating and Configuring Adjustment Level Groups](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/adjustment-levels/create-configure-adjustmentlvl-groups.md): You can create and configure any number of adjustment level groups in Lucanet. To view the cumulative postings/values of the individual adjustment levels and adjustment levels for consolidation postings, you can consolidate adjustment levels and adjustment levels for consolidation postings into adjustment level groups. - [Creating and Configuring Adjustment Levels](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/adjustment-levels/manage-adjustment-levels.md): You can create and configure adjustment levels in Lucanet. Adjustment levels determine the guidelines according to which a value is posted and measured. - [Creating and Configuring Adjustment Levels for Consolidation Postings](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/adjustment-levels/create-configure-adjustmentlvl-consolidation-postings.md): Adjustment levels for consolidation postings are used to post consolidation postings if the Consolidation 2 is used for consolidation. - [Creating and Configuring Consolidation Apps](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/configuring-consolidation-apps.md): After you have defined the master data of your group and configured the app for data transfer and proportioning, you can now continue with the configuration of the consolidation apps. - [Creating and Configuring Consolidation Areas](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-1/create-and-configure-consolidation-areas.md) - [Creating and Configuring Consolidation Reporting Entities](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/reporting-entities/buchungskreise-fuer-konsolidierungsbuchungen-anlegen-und-konfigu.md): Consolidation reporting entities are used for postings during the consolidation. - [Creating and Configuring Consolidation Wizards](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-1/create-configure-consolidation-wizards.md): In Lucanet, it is possible to perform the elimination of intercompany debt, elimination of intercompany income and expense, and inventory consolidation in connection with the elimination of intercompany profit or loss by means of consolidation wizards. - [Creating and Configuring Cost Centers and Cost Center Groups](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/reporting-entities/manage-cost-centers.md): To describe in detail which costs have resulted where, it is possible to divide a reporting entity into cost centers. By using cost center groups, it is possible to group cost center sub-groups and/or cost centers together. - [Creating and Configuring Currencies](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/currency-translation/create-configure-currency.md): In Lucanet, a distinction is made between transaction currencies and display currencies. Transaction currencies are the currencies in which postings are made. - [Creating and Configuring Current Account Interest Wizards](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/planning/planning-wizards/current-account-interest.md): The wizard for the current account interest can be used in Lucanet to plan the automatic interest return of giro accounts and overdraft facilities. - [Creating and Configuring Data Transfer and Proportioning](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/data-transfer-and-proportioning.md): The first step in configuring consolidated financial statements is the provision of the data basis in the consolidation areas. - [Creating and Configuring Data Transformations](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-lnfwh/create-and-configure-data-transformation.md) - [Creating and Configuring Directory Structures](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/konfiguration-der-arbeitsbereiche/create-configure-directory-structures.md): Directory structures are workspaces that are used for creating and editing elements such as apps, scripts, or Lucanet.Excel-Reporting files. In the Workspace configuration, you can create any directory structures and individually configure which elements can be created within a directory structure. In the Overview, each directory structure is displayed in the folder as a workspace in which it was created. - [Creating and Configuring Exchange Rate Tables](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/currency-translation/create-configure-exchangerate-table.md): The exchange rates between currencies are defined in exchange rate tables. Lucanet offers the option of storing year-to-date exchange rates for currency translation for all exchange rate relationships (transaction currencies and display currencies) in addition to average exchange rates, closing exchange rates, and historical exchange rates. - [Creating and Configuring Execution Settings](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-lnfwh/create-and-configure-execution-settings.md) - [Creating and Configuring Fiscal Years](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/fiscal-years/create-configure-fiscal-years.md): If one or more reporting entities of your enterprise have a different fiscal year, then you can define the different fiscal year(s) in Lucanet. - [Creating and Configuring Formulas](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/elements-ledgers-schedules/create-configure-formulas.md): Controlling indicators such as the absolute liquidity ratio, the equity ratio, and the return on sales can be created in Lucanet using formulas. Formulas can be used in all ledgers and schedules to calculate any values. - [Creating and Configuring Items](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/elements-ledgers-schedules/create-configure-items.md): In Lucanet, items are used for a better overview and better structuring of ledgers and schedules. Each account is assigned to an item in Lucanet. The value at the item level is always the total of all subordinate items and accounts. - [Creating and Configuring Loan Wizards](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/planning/planning-wizards/loan-wizard.md): The Loan planning wizard allows both received loans and issued loans to be defined for reporting entities. Lucanet regards a received loan as borrowing from outside or inside your company. An issued loan is regarded as loan issuance. Received and issued loans can be defined for different loan types. - [Creating and Configuring Organization Groups](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/organization-elements/create-configure-org-groups.md): Organization groups are used in structures to combine all of the organization elements of the entire structure or of substructures that belong together. - [Creating and Configuring Partner Groups](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/partners/partnergruppen-anlegen-und-konfigurieren.md): You can use partner groups to group partners hierarchically. In the event of a value query of a partner group, the aggregated value of all partners is displayed. - [Creating and Configuring Partners](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/partners/manage-partners.md): You can create and configure partners in Lucanet. Partners are used for the consolidation in order to add partner information to postings and data imports for the internal cost allocations. - [Creating and Configuring Planning Data Levels](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/data-levels/create-configure-planning-datalvls.md): Planning data levels are used for recreating your corporate planning. With the aid of planning data levels, you can create not only the general planning but also scenarios and forecasts. - [Creating and Configuring Postings in Journals](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/journale/create-configure-posting-reporting-entity.md): Manual postings can be created for all reporting entities or consolidation areas in the Journals workspace, for periods that are not locked for editing. - [Creating and Configuring References](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/organization-elements/create-references.md): References are links to elements that were previously defined in the Reporting entities or the Groups workspace. - [Creating and Configuring References](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/elements-ledgers-schedules/create-configure-references.md): References are links that refer to items or accounts in general ledgers, subledgers, and statistical ledgers. References can be used to create derived structures in Lucanet (e.g. a derived IFRS balance sheet). A distinction is made between direct and indirect references. - [Creating and Configuring Reporting Entities](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/reporting-entities/manage-reporting-entities.md): Reporting entities are elements to which postings can be made. Reporting entities are used as organization units when setting up group structures. - [Creating and Configuring Schedules](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/konfiguration-der-arbeitsbereiche/create-schedules.md) - [Creating and Configuring Statistical Ledgers](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/konfiguration-der-arbeitsbereiche/create-configure-statistical-ledger.md): Statistical ledgers can be used to create account hierarchies that need not be subject to the rules of double-entry accounting (e.g. derived general ledger and subledger structures, indirect cash flow statement and direct liquidity planning). In the Overview, each statistical ledger is displayed in the folder as a workspace in which it was created. - [Creating and Configuring Subledgers](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/konfiguration-der-arbeitsbereiche/create-subledger.md): Subledgers serve to supplement and explain the general ledger. A subledger is used, for example, to store the structure of the P&L based on your main structure. In subledgers, original accounts from the financial accounting source systems are created, assigned and managed, and manually created accounts and items are administrated. - [Creating and Configuring Total Lines](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/organization-elements/create-configure-total-lines.md): Total lines are used for calculating totals or subtotals in structures. - [Creating and Configuring Total Lines](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/reporting-entities/create-configure-total-lines.md): Total lines are used for calculating totals or subtotals in structures. Total lines can be created in the context of reporting entities and cost center groups. - [Creating and Configuring Total Lines](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/elements-ledgers-schedules/create-configure-total-lines.md): Total lines are items whose values are based on the total of all items of the same level above the totals item. - [Creating and Configuring Transaction Type Categories](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/transaction-types/transaction-type-categories.md): In Lucanet, the required transaction type categories can be created with the necessary transaction types and assigned to the relevant accounts/ items, depending on the schedule desired. Only the transaction types of the selected transaction type category are available for posting to these accounts. - [Creating and Configuring Transaction Types](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/transaction-types/transaction-type-types.md): Transaction types provide information on the reason for changes to an account. As a result, transaction types allow for seamless integration of schedules and cash flow statements in Lucanet on the level of the individual and consolidated financial statements, e.g. simultaneously in accordance with HGB, IFRS and US GAAP. - [Creating and Configuring Transfer Actual Balance to Plan Wizards](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/planning/planning-wizards/creating-and-configuring-transfer-actual-balance-to-plan-wizards.md): The wizard can be used to transfer existing account balances from actual to planning periods for reporting entities. - [Creating and Configuring Views](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/views-ledgers-schedules/create-configure-views.md): Choosing a view in the tree view of a ledger or schedule displays the associated dimension bar. - [Creating and Editing Configurations](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-1/create-configurations-consolidation-1.md) - [Creating and Executing Scripts](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/create-scripts.md) - [Creating and Executing the Data Import](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-reporting-entities/creating-executing-data-import.md): All data that is imported into reporting entities is transferred to the current Lucanet database using data imports. The data import object is used to determine which data source and assignment table are to be used during the import. - [Creating Assignment Tables](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-reporting-entities/creating-assignment-table.md): Assignment tables are used to save all elements imported from the source systems (accounts, reporting entities/cost centers, partners, transaction currency, transaction types, data levels, adjustment levels) and their assignment to elements in the Lucanet database. - [Creating Consolidated Financial Statements](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/creating-consolidated-financial-statements.md): After you have defined the structure and master data of your group, you can configure the app-supported consolidation of your group in the Consolidated financial statements workspace. - [Creating Postings in Ledgers and Schedules](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/functions-ledgers-schedules/creating-postings-in-ledgers-schedules.md): Manual postings can be created directly from any cell in a ledger or schedule - [Creating Reporting Templates](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/lucanet-excel-reporting/create-and-edit-reporting-templates.md): In Lucanet, Excel reports are always generated based on a reporting template. Reporting templates are Excel files that contain tilde formula(s) with functions, statements, and parameters that define the content of the Excel report queried from Lucanet. Each dimension that is queried using a tilde formula in an Excel reporting template is displayed in the detail view of the reporting template in Lucanet and can be selected there for report generation. - [Currency Translation](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/currency-translation.md): The Currency translation workspace is used to create, edit and delete transaction currencies, display currencies, and exchange rate tables in Lucanet. - [Dashboards](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/dashboard.md): In the Dashboards workspace, you can use widgets to visualize any values of accounts or items clearly and individually. - [Data Levels](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/data-levels.md): The Data levels workspace is used to create, manage, and delete data levels. - [Debit/Credit Shifts in Consolidation Areas](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/configuring-consolidation-apps/debit-credit-shifts-in-consolidation-areas.md): The aim of the app Debit/credit shifts in consolidation areas is to automatically standardize the debit/credit presentation of financial values across the consolidated group by generating the necessary shift entries to ensure each balance appears on a single side in the consolidated financial statements. The Debit/credit shifts in consolidation areas are calculated based on the values of an adjustment level group and posted to an adjustment level for consolidation postings that is included in this adjustment level group. Optionally, it is possible to define whether individual consolidation areas should be excluded from execution. - [Defining a Data Source](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-lnfwh/defining-data-source-lnfwh.md) - [Defining a Data Source](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-reporting-entities/defining-data-source.md): To import data from various sources into the current Lucanet database, a data source must first be created. - [Defining Properties of Return Values](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/lucanet-excel-reporting/work-with-tilde-formulas/define-properties-of-return-values.md): The properties of return values can be specified using texts and parameters. The return values for the Value and Rate functions can be changed with any desired formula. - [Defining the Group Structure](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/defining-group-structure.md): A group includes the totality of all units to be consolidated. The group structure is defined using consolidation dimension and consolidation dimension elements and consolidation areas. - [Dependent Business Transactions](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/planning/planning-sheets/dependent-business-transactions.md): If accounts or items are planned on the basis of additional planning dimensions, then the business transactions that are dependent on them must be recalculated when these planning dimensions are changed. - [Dimensions](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions.md) - [Display in Ledgers and Schedules](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/display-ledgers-schedules.md): The display in schedules and mirrors can be configured with various functions. - [Displaying and Configuring Charts](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/functions-ledgers-schedules/display-configure-diagrams.md): Values of items and accounts from ledgers and schedules can be visualized in Charts as column, bar, pie or line charts. To visualize comparisons, the values of multiple items or accounts can be displayed in a chart at the same time. - [Displaying and Configuring Dashboards](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/dashboard/display-configure-dashboard.md): In the Dashboards workspace, the dashboard is displayed and edited. The dimension bar can be used to configure the value display in the widgets. - [Drill Down in Ledgers and Schedules](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/functions-ledgers-schedules/drill-down.md): For items and accounts, drill down can be used to define how subordinate items or postings are displayed. - [Editing Dashboards](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/dashboard/edit-dashboard.md): In the dashboard, you can add new widgets and edit or delete existing ones. You can also lock dimensions to prevent incorrect dashboard configurations. - [Editing the Properties of the General Ledger](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/konfiguration-der-arbeitsbereiche/edit-general-ledger-details.md): The general ledger is used to keep and display accounts and items in Lucanet. The account structure of a balance sheet is stored in the general ledger. In the general ledger, the original accounts from the financial accounting source systems are recreated, assigned, and maintained, and manually created accounts and items are managed. By default, the general ledger is displayed as a workspace in the overview in the Reporting and analyzing folder. The properties of the general ledger can be edited in the Workspace Configuration as described below. - [Elements in Directory Structures](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/elements-in-directory-structures.md) - [Elements in Ledgers and Schedules](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/elements-ledgers-schedules.md): The structure of ledgers and schedules is displayed in the tree view. All structures are composed of the same elements. - [Elimination of Income from Investments](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/configuring-consolidation-apps/elimination-of-income-from-investments.md): The goal of the app for Elimination of income from investments is to automate the elimination of investment income recorded by the parent company against the subsidiary's dividend distributions or profit transfers in the same period. Elimination can be executed per period or accumulated across several periods. Non-controlling interests can be considered. They are considered based on the ownership interests stored in the master data or based on individual specifications made on the app interface. - [Elimination of Intercompany Debt](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/configuring-consolidation-apps/elimination-intercompany-debt.md): With the app for elimination of intercompany debt, the receivables and liabilities among the consolidation units of a group are eliminated for consolidated financial statements. - [Elimination of Intercompany Income and Expense](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/configuring-consolidation-apps/elimination-income-and-expense.md): Using the app for elimination of intercompany income and expense, the income and expenses that are the result of business transactions between companies in a given consolidation area are eliminated for consolidated financial statements. - [Elimination of Intercompany Profit or Loss in Current Assets](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/configuring-consolidation-apps/elimination-of-profit-or-loss-in-current-assets.md) - [Equity Elimination](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/configuring-consolidation-apps/equity-elimination.md): Using the App for the equity elimination, the cross-ownerships between group companies are eliminated for the specified period to prepare consolidated financial statements. Values resulting during this process are posted to the accounts that were selected for equity elimination. - [Excel-Integration](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration.md): Lucanet bietet die vollständige Excel-Integration für Planungs- und Reporting-Zwecke. Mit dem CFP Add-in for Excel 365 steht ein interaktiver Zugang von MS Excel zum Lucanet.Financial OLAP Server zur Verfügung, der für die Datenabfrage und Datenbearbeitung aus MS Excel heraus genutzt werden kann. Zudem verfügt Lucanet mit dem Lucanet.Excel-Reporting über eine Standardfunktionalität zum Erstellen von Standardberichten. - [Executing Multiple Elements Using Workflows](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/general-functions/executing-elements-using-workflows.md): With workflows, you can map a saved sequence in Consolidation & Financial Planning in which executable elements such as scripts, data imports, or apps, are executed one after another in a defined order. - [Executing the Consolidation](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/executing-consolidation.md): Different options are available for executing the consolidation and for creating the respective consolidation postings. You can: - Execute individual consolidation apps separately - Execute multiple consolidation apps jointly in a so-called executable folder - Execute entire consolidated financial statements including all child elements - [Executing the Data Import](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-lnfwh/execute-data-import.md) - [Exporting Exchange Rates](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/currency-translation/export-exchange-rates.md): You can export the exchange rates contained in your exchange rate tables to MS Excel at any time. - [Exporting values to MS Excel or as a PDF](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/functions-ledgers-schedules/export-values-excel-pdf.md): For further processing or publication of the data, you have the option of exporting the values displayed in the tree view of ledgers and schedules either as a PDF or as an MS Excel file. - [Finalizing Data Import](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-reporting-entities/completing-data-import.md): Every data import can be finalized in order to prevent it from being changed or deleted. - [Fiscal Years](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/fiscal-years.md) - [Formatting Numbers and Dates](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/display-ledgers-schedules/format-numbers-dates.md): Regardless of the selected language, you can configure the date and number format as well as the display of negative numbers in the Lucanet CFO Solution Platform. - [Functions](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/lucanet-excel-reporting/work-with-tilde-formulas/functions.md): With functions in tilde formulas, you can query information and data from Lucanet and output them in an Excel report. A function specifies what type of information is retrieved (e.g., numerical values, currencies, exchange rates). - [Functions in Ledgers and Schedules](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/functions-ledgers-schedules.md): In Lucanet Consolidation & Financial Planning, numerous functions are available in ledgers and schedules, which can be used to create diagrams or export data, for example. - [Functions in the Detail View](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/general-functions/functions-in-the-detail-view.md): This article gives an overview of the general functions that are available in the detail view of Consolidation & Financial Planning. - [Functions in the Tree View](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/general-functions/functions-in-the-tree-view.md): This article gives an overview of the general functions that are available in Consolidation & Financial Planning to change the tree view. - [Functions Used to Change the Display](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/general-functions/functions-used-to-change-the-display.md): This article gives an overview of the functions that are available in Consolidation & Financial Planning to change the display of elements and to show additional information. - [General Functions](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/general-functions.md): In Consolidation & Financial Planning, cross-platform functions are available to help you, for example, improve clarity, create or move elements, or navigate between them. - [Generating Excel Reports](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/lucanet-excel-reporting/generate-excel-report.md): Based on the reporting template available in Lucanet and the tilde formulas it contains, an Excel report with the current data from Lucanet can be generated. - [Import and Journals](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals.md): A journal is a combination of a data level and a reporting entity or a consolidation area. A journal contains all postings and all underlying posting documents that enable you to understand the details of all postings. - [Importing data into Lucanet.Financial Warehouse](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-lnfwh.md) - [Importing Data into Reporting Entities](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-reporting-entities.md): In the 'Importing data into reporting entities’ workspace, the import of data from Excel files into the current database on Lucanet.Financial OLAP Server can be configured and executed. - [Importing Exchange Rates](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/currency-translation/import-exchange-rates.md): Exchange rates for exchange rate tables can either be queried from the European Central Bank or imported from MS Excel. - [Installing and Updating Lucanet.Script Execution Application](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/basic-configuration-cfp/install-and-use-opsea.md): Lucanet.Script Execution Application (SEA for short) is a Lucanet application that you need if you operate ERP/financial source systems on-premises and want to import data from these systems into the Lucanet CFO Solution Platform using an ETL script. On this page, you can find out how to install and update SEA. - [Installing the CFP Add-In for Excel 365](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/installing-cfp-add-in.md): To be able to work with the CFP Add-in for Excel 365, you first need to install the add-in in MS Excel. After having successfully installed the add-in, you can connect the add-in to your Lucanet database. - [Journals](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/journale.md) - [LUCANET Formulas](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data/lucanet-formulas.md): To allow MS Excel to access Lucanet data, specific, precisely-defined formulas must be entered in the corresponding Excel cells. The formulas are similar to Excel formulas and always consist of a formula name as well as required and optional parameters. - [Lucanet.Excel-Reporting](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/lucanet-excel-reporting.md): Das Lucanet.Excel-Reporting dient zum Erstellen von Standardberichten, die beliebig verteilt und unabhängig von einem Lucanet-Zugang oder Internet-Zugang angezeigt werden sollen. Das Erstellen eines Berichts und seine Konfiguration erfolgen direkt aus Lucanet heraus. Alle Berichte werden auf Basis von Berichtsvorlagen erstellt, die in Lucanet abgespeichert werden. - [Lucanet.Financial Warehouse (#2068)](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-reporting-entities/defining-data-source/data-source-lnfwh.md): After creating a Lucanet.Financial Warehouse (#2068) data source, the settings for importing data from Lucanet.Financial Warehouse are configured in the detail view of the data source. - [Migrating From Integrated Excel.Add.-in to CFP Add-in for Excel 365](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/migrating-from-integrated-to-cfp-add-in.md): Customers who used the integrated Lucanet.Excel.Add-in (XLAM) can use a migration assistant to convert legacy formulas with the syntax LUCANET(...) to the formula syntax LN.FORMULA NAME (...) used by the Lucanet CFP Add-in for Excel 365. The assistant scans all used cells in all worksheets of the current workbook and replaces supported legacy formulas with their LN.* equivalents. - [MS Excel file (.xls, .xlsx) (#1000)](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-reporting-entities/defining-data-source/data-source-excel.md): After creating an MS Excel File (.xls, .xlsx) (#1000) data source, the settings for importing data from Excel files are configured in the detail view of the data source. - [Notes on Migration from Lucanet.Financial Client](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/configuring-consolidation-apps/migration-from-lnfc.md): This article is intended for all customers who already use Consolidation 2 in Lucanet.Financial Client. It provides information on: - Apps that are supported in the CFO Solution Platform - Apps that are not supported in the CFO Solution Platform - General notes and notes on migration of the app for equity elimination to the Lucanet CFO Solution Platform - [Optional Keywords](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/transferring-data-to-lucanet/optional-keywords.md): Optional keywords can be inserted if you need to import further information in addition to the required content. - [Organization Elements](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/organization-elements.md): The structure of your enterprise is recreated in the Organization elements workspace. The Organization elements workspace is used for the creation, modification or deletion of references to objects that were previously created in the Reporting entities workspace or in the Groups workspace. - [Partner](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/partners.md): In Lucanet, partners can be created, managed, and deleted in the dimension of the same name. Partners are used for the consolidation to add partner information to postings and data imports for the internal cost allocations. - [Placeholder](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/lucanet-excel-reporting/work-with-tilde-formulas/placeholders.md): In tilde formulas, placeholders can be used as substitutes for data levels, adjustment levels, organization elements, periods, time intervals, or as parameters of functions or statements. - [Planning](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/planning.md): The Planning functionalities of our Consolidation & Financial Planning solution can be used to plan on a monthly, quarterly or yearly basis for any planning period and display any scenario based on existing plans. - [Planning Using CFP Add-in for Excel 365](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/planning/planning-excel-add-in.md): Lucanet CFP Add-in for Excel 365 can be used to transfer plannings, posting records or statistical values, such as employee figures, from MS Excel to Lucanet. This data must be included in a certain format in the active workbook. This allows, for example, any kind of complex plannings to be created in Excel and imported into Lucanet at the press of a button. - [Planning Using Planning Wizards](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/planning/planning-wizards.md): Planning Wizards are functionalities used for more advanced business logic and complex calculations. With the help of the planning wizards, it is possible to carry out postings automatically according to the configuration of the wizard. The planning wizard is only available in planning data levels. - [Planning Using Sheets](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/planning/planning-sheets.md): Sheets offer a flexible way to perform calculations required in the financial planning process. They can be created for all reporting entities for values of ledgers and schedules in planning data levels. - [Postings in Journals](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/journale/postings-journals.md): The Journals workspace contains all postings. In addition to postings and data imports, the workspace also contains elements for (wizard-supported) planning and consolidation. - [Provision via script (#2075)](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-reporting-entities/defining-data-source/data-source-script.md): After creating a Provision via Script (#2075) data source, the settings for importing data via script are configured in the detail view of the data source. - [Querying Attributes](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data/querying-attributes.md): You can use querying of attributes from Lucanet, among other things, to export element names in Lucanet via the OID of elements. - [Querying Comments](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data/querying-comments.md): You can use LUCANET formulas to query comments in Lucanet (e.g. for values in the general ledger, in subledgers or in schedules) and read them in to MS Excel. - [Querying Data from Lucanet](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data.md): You can use CFP Add-In for Excel 365 to selectively read in data from Lucanet to MS Excel. This allows you to populate reports created in MS Excel at the push of a button. As Lucanet saves all data in a central database, all reports are available with the current values from Lucanet at all times. - [Querying Exchange Rates](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data/querying-exchange-rates.md): You can use a LUCANET formula to query exchange rates in Lucanet and read them in to MS Excel. - [Querying Values](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/querying-data/querying-values.md): You can use a LUCANET formula to query values from Lucanet and read them in to MS Excel. The formula for querying values must contain certain parameters and can be expanded with optional parameters. - [Reclassification of Profit or Loss from Previous Periods in Reporting Entities](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/elements-in-directory-structures/reclassification-of-profit-or-loss-in-reporting-entities.md): You can use the Reclassification of profit or loss from previous periods in reporting entities app to automatically reclassify the period result from the previous year to carry it forward. The following functional topics are covered: Reclassification of the period result from the previous year to carry it forward in local currency Fixation of the historical exchange rate at foreign currency companies (in different display currencies) - [Reclassification of profit or loss from previous year in consolidation areas](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/consolidation/consolidation-2/configuring-consolidation-apps/reclassification-of-profit-or-loss-in-consolidation-areas.md): You can use the Reclassification of profit or loss from previous year in consolidation areas app to automatically reclassify the period result from the previous year to carry it forward. - [Reporting & Analyzing](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze.md): The Reporting and analyzing workspace is, by default, the core workspace in Lucanet Consolidation & Financial Planning, and contains all ledgers, schedules, and directory structures created in the Lucanet database. - [Reporting Entities](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/reporting-entities.md): In the Reporting entities workspace, you can create all elements to which postings can be made in Lucanet. - [Required Keywords](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/transferring-data-to-lucanet/required-keywords.md): Required keywords are needed in order for Lucanet to recognize that it is an import. They are entered in column A or the Column definition row. - [Saving and Sharing Views as Favorites](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/views-ledgers-schedules/create-views-as-favorites-and-share.md): In the dimension bar of Consolidation & Financial Planning, you can save custom views of a ledger or schedules as favorites. This allows you to quickly access frequently used views without having to reconfigure the dimension bar. You can also share your favorite views with other users. - [Show Postings](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/elements-ledgers-schedules/postings.md): It is possible to display the underlying postings for each value that is displayed for an account in a ledger or in an schedule. The documents belonging to a posting can be opened from within the Show postings dialog. - [Statements](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/lucanet-excel-reporting/work-with-tilde-formulas/statements.md): Using statements in a tilde formula, you can dynamically insert or name rows and columns in an Excel report with Lucanet.Excel-Reporting. - [Synchronizing Planning Data Levels](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/data-levels/synchronize-planning-data-level.md): If a data level has the status 'The planning data level is not synchronized with the actual data level', then it can be synchronized with the actual data level at any time. - [Transaction Types](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/platform-dimensions/transaction-types.md): The Transaction types workspace is used to create, administrate, and delete transaction type categories and transaction types. - [Transferring Data from MS Excel to Lucanet](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/transferring-data-to-lucanet.md): CFP Add-In for Excel 365 can be used to selectively transfer Excel plannings or Excel postings to the Lucanet database. - [Translation with Historical Exchange Rates](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/journale/translation-historical-exchange.md): In the Translation with historical exchange rates posting, the translation with historical exchange rates is defined for accounts. If translation with historical exchange rates is defined for an account then the value which has been calculated originally using the current exchange rate is cleared and the value which has been calculated using the historical exchange rate is posted. - [Troubleshooting Guide](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/cfp-add-in/troubleshooting-cfp-add-in.md): This guide serves as a central resource for resolving issues you are facing with the CFP Add-in for Excel 365 efficiently. Each entry includes the problem description, root cause, and the steps taken to fix it. - [Updating Data Imports](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/importing-data-into-reporting-entities/update-data-imports.md): Data imports into reporting entities can be updated manually at any time, either individually or combined in folders. - [User Interface of Lucanet Consolidation & Financial Planning](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/user-interface-cfp.md): This page contains information about the structure of the user interface and the most important elements in Lucanet Consolidation & Financial Planning. From this page, you can jump easily to the detailed descriptions of the individual areas and functions. - [Using Journals](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/imports-journals/journale/use-journals.md): In the Journals workspace, you can choose journals and display the details of the associated postings. - [Using Keyboard Shortcuts](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/general-functions/using-keyboard-shortcuts.md): To accelerate operation and navigation, a range of shortcuts is available in ledgers and schedules. - [VAT/Input Tax Administration](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/planning/accounting-rules/vat-input-tax.md): For the purposes of planning in Lucanet, it is possible to create VAT and input VAT configurations that can be taken into account as part of the configuration of accounting rules for accounts and items in the general ledger and subledgers. - [Views in Ledgers and Schedules](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/report-analyze/views-ledgers-schedules.md): The Lucanet CFO Solution Platform enables you to use templates to simplify and speed up your reporting (e.g. to report on all planning and business development issues that are important to the company). Recurring reports can be configured as views. - [Working with Tilde Formulas](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/excel-integration/lucanet-excel-reporting/work-with-tilde-formulas.md): Tilde formulas are used to create Excel reports. A tilde formula defines which data are to be read in from Lucanet to MS Excel. Tilde formulas always start with a tilde (~) and can contain placeholders, functions and statements. - [Workspace Configuration](https://support.lucanet.cloud/en/documentation/consolidation-financial-planning/konfiguration-der-arbeitsbereiche.md): In the workspace configuration in the CFO Solution Platform, you can create and configure statistical ledgers for the functional area Reporting and Analysis. ## ESG Reporting Lucanet ESG Reporting meets all the requirements in the ESG report process, because it covers all non-financial risks and opportunities that can arise in connection with the daily activities of an enterprise. ESG Reporting complies with the ESRS provisions, the EU taxonomy, and the GHG protocol, and provides decentralized data collection with customized questionnaires. It can also be used to calculate GHG emissions. - [AI-Supported Import: End-to-End Process Overview](https://support.lucanet.cloud/en/documentation/esg-reporting/collect-data-esgrep/esg-data-collection-esgrep/ete-process-overview.md) - [All Steps at a Glance – ESG Reporting](https://support.lucanet.cloud/en/documentation/esg-reporting/process-description-esgrep.md): In this chapter, you will find the individual steps required to create an ESG report. These steps must be carried out in the order indicated by either the ESG Administrator or the ESG Data Collector. The step descriptions also contain links to more detailed descriptions. - [Assessing Minimum Safeguards](https://support.lucanet.cloud/en/documentation/esg-reporting/collect-data-esgrep/collect-eut-data/minimum-safeguards.md): In the Minimum Safeguards workspace, you can fill out a questionnaire for your reporting entity assessing whether your reporting entity meets the minimum safeguards criteria, i.e. essential international guidelines, focusing on four core standards: OECD Guidelines for Multinational Enterprises UN Guiding Principles on Business and Human Rights ILO Fundamental Conventions The International Bill of Human Rights. - [Assigning Users as Editors or Reviewers](https://support.lucanet.cloud/en/documentation/esg-reporting/collect-data-esgrep/esg-data-collection-esgrep/defining-access-esgrep.md): When configuring the ESRS or VSME questionnaire, you as an ESG Administrator can assign reporting entities along with its designated ESG Data Collectors that were defined in the master data administration to certain parts of the questionnaire. These ESG Data Collectors then are assigned as editors to the entire questionnaire or parts of it (see Using the Questionnaire Builder). - [Canceling an ESG Report](https://support.lucanet.cloud/en/documentation/esg-reporting/cancel-report-esgrep.md): As an ESG Administrator, you can cancel ESG reports. This is useful if errors are discovered, for example. You can cancel any ESG report that has not yet reached “Data aggregation” status. - [Checking Data](https://support.lucanet.cloud/en/documentation/esg-reporting/check-data-esgrep.md): Once the ESG Data Collectors have collected and submitted all the data for both the ESRS or VSME questionnaire and the Emissions Module, as an ESG Administrator, you can check the submitted data and approve them – or reject them, if necessary. - [Collecting and Reviewing ESG Data](https://support.lucanet.cloud/en/documentation/esg-reporting/collect-data-esgrep/esg-data-collection-esgrep.md): Once the ESRS, ESRS 2.0, or VSME questionnaire has been configured and the data collection process has started, the ESG data can be collected and reviewed by all users assigned as editors or reviewers. During data collection, ESG Administrators can add users and assign individual users to be editors or reviewers and display the aggregated responses that have been collected at a given time. After all data have been collected and reviewed, the questionnaire can be submitted. - [Collecting Data for ESG Report](https://support.lucanet.cloud/en/documentation/esg-reporting/collect-data-esgrep.md): Once the ESRS, ESRS 2.0, or VSME questionnaire has been configured and the data collection process has started, ESG users can start with collecting the following data: ESG data can be collected and reviewed in the ESRS, ESRS 2.0, or VSME questionnaires, and the Emissions module by all users assigned as editors or reviewers, see Collecting and Reviewing ESG Data. EU Taxonomy data can be collected in the functional area EU Taxonomy by users who were assigned for this task in the master data administration, see Collecting EU Taxonomy Data. - [Collecting EU Taxonomy Data](https://support.lucanet.cloud/en/documentation/esg-reporting/collect-data-esgrep/collect-eut-data.md): The EU Taxonomy is a classification system established by the European Union to define which economic activities can be considered environmentally sustainable. In the EU Taxonomy functional area, users can create business activities, such as using solar energy panels, and assess if these business activities are eligible for the EU Taxonomy. - [Collecting Financial Data](https://support.lucanet.cloud/en/documentation/esg-reporting/collect-data-esgrep/collect-eut-data/collect-financial-data.md): In the Financial Data workspace, users can collect and manage financial data required for EU Taxonomy reporting, i.e. baseline values and business activity values. - [Configuring the Report Questionnaire](https://support.lucanet.cloud/en/documentation/esg-reporting/questionnaire-builder-esgrep.md): Once you have created an ESG report as an ESG Administrator and entered the master data, you can continue by configuring the ESRS, ESRS 2.0, or VSME questionnaire, depending on the report guideline chosen in the master data. The ESRS questionnaire is based on the ESRS requirements, whereas the VSME questionnaire is based on EFRAG. Both questionnaire versions can be configured individually. - [Covering SCC and DNSH Questionnaires](https://support.lucanet.cloud/en/documentation/esg-reporting/collect-data-esgrep/collect-eut-data/alignment-assessment.md): If your business activity is eligible for the EU Taxonomy, you can proceed to the Alignment assessment page. In this page, you specify for each of the environmental goals associated with your business activity whether your business activity is compliant with the following criteria: Substantial Contribution Criteria (SCC) Do Not Significant Harm (DNSH) - [Creating a Business Activity and Performing the Eligibility Assessment](https://support.lucanet.cloud/en/documentation/esg-reporting/collect-data-esgrep/collect-eut-data/create-ba-perform-eligibility.md): The EU Taxonomy is a classification system established by the European Union to define which economic activities can be considered environmentally sustainable. In the EU Taxonomy functional area, users can create business activities, such as using solar energy panels, and assess if these business activities are eligible for the EU Taxonomy. - [Creating Custom Emission Factors](https://support.lucanet.cloud/en/documentation/esg-reporting/creating-custom-emission-factors.md): In addition to standard emission factors from our database, you can use custom emission factors to include missing or organization-specific data, ensuring that your results better reflect your organization's activities or specific supplier data. - [Creating Report](https://support.lucanet.cloud/en/documentation/esg-reporting/master-data-esgrep.md): As an ESG Administrator, your first responsibility within the ESG reporting process is to enter the master data for each ESG report, e.g. the period, the reporting entities to report, the users to report within these reporting entities, and the location of these reporting entities. This provides the basis for the ESG report and the subsequent steps. - [Displaying Aggregated Responses During Data Collection](https://support.lucanet.cloud/en/documentation/esg-reporting/collect-data-esgrep/esg-data-collection-esgrep/enhancements-for-aggregated-esg-reports.md): Once the data collection phase of an ESG report has started, you as an ESG Administrator are able to monitor the aggregated responses of all assigned reporting entities while the ESG report is collecting data. - [ESG Reporting](https://support.lucanet.cloud/en/documentation/esg-reporting.md): Lucanet ESG Reporting meets all the requirements in the ESG report process, because it covers all non-financial risks and opportunities that can arise in connection with the daily activities of an enterprise. ESG Reporting complies with the ESRS provisions, the EU taxonomy, and the GHG protocol, and provides decentralized data collection with customized questionnaires. It can also be used to calculate GHG emissions. - [Exporting Data](https://support.lucanet.cloud/en/documentation/esg-reporting/export-data-esgrep.md): As an ESG Administrator you can export data from your ESG reports in different formats: aggregated ESRS and VSME data as a CSV file, and EU Taxonomy data in Excel using standardized EU Annex II templates. - [Filling Out Report Questionnaire](https://support.lucanet.cloud/en/documentation/esg-reporting/collect-data-esgrep/esg-data-collection-esgrep/editing-data.md): The users that have been assigned as editors fill out the ESRS or VSME questionnaire and the Emissions Module entirely or only the parts that have been assigned to them. The data from the Emissions Module will be automatically copied into the ESRS or VSME questionnaire. - [Filling Out the Emissions Module](https://support.lucanet.cloud/en/documentation/esg-reporting/collect-data-esgrep/esg-data-collection-esgrep/fill-out-emission-module.md) - [General Functions in ESG Reporting](https://support.lucanet.cloud/en/documentation/esg-reporting/general-functions-esg.md): Depending on your user role, there are several general functions available to you in ESG Reporting, e.g. canceling ESG reports or displaying notes on a specific ESG report. This article describes the available functions depending on the user role. - [Generating ESG Report](https://support.lucanet.cloud/en/documentation/esg-reporting/aggregate-data-esgrep.md): As an ESG Administrator, once you have approved the data submitted by all your reporting entities for an ESG report, you can generate the ESG report containing the individual reporting data for the assigned reporting entities and the aggregated numerical data. The aggregated data are also prepared for the import into the Lucanet Disclosure Management solution for further processing. - [Mapping Double Materiality Assessment Results](https://support.lucanet.cloud/en/documentation/esg-reporting/perform-dma.md): Double materiality assessments (DMA) provide a foundational analysis of your organization's impact on sustainability and consist of impact materiality and financial materiality. By combining these two factors, it is possible to assess which sustainability risks and opportunities are material for your organization and, thus, should be included in your ESG report. As an ESG Data Collector, you can specify in the DMA report which sustainability topics are relevant for your reporting entity and submit the report. This information will be used to determine the part of the ESRS questionnaire that your organization has to report on. - [Reopening an ESG Report](https://support.lucanet.cloud/en/documentation/esg-reporting/reopening-aggregated-esg-reports.md): Even after the Data aggregation step has been finalized, an ESG Administrator can reopen the aggregated ESG report. This might be necessary to collect updated values from the assigned reporting entities. - [Reviewing Data](https://support.lucanet.cloud/en/documentation/esg-reporting/collect-data-esgrep/esg-data-collection-esgrep/reviewing-data.md): The users that have been assigned as reviewers to an ESG report can start reviewing data as soon as data have been collected. - [Starting Data Collection](https://support.lucanet.cloud/en/documentation/esg-reporting/questionnaire-builder-esgrep/starting-data-collection.md): Once you have configured the ESRS, ESRS 2.0, or VSME questionnaire, you can release the ESG report for data collection. - [Status Update per Reporting Entity](https://support.lucanet.cloud/en/documentation/esg-reporting/collect-data-esgrep/collect-eut-data/status-update.md): For each reporting entity, the Reports and Activities workspace provides a page with an assessment overview of: Minimum safeguards Taxonomy eligibility Taxonomy alignment Financial data status for every business activity In case the assessment of the minimum safeguard criteria is still in progress, you can directly access the corresponding questionnaire via link. - [Structure of the Report Questionnaire](https://support.lucanet.cloud/en/documentation/esg-reporting/questionnaire-builder-esgrep/structure-questionnaire.md): The ESRS, ESRS 2.0, or VSME questionnaire consists of several elements that are displayed in a tree structure and offers you various functionalities. - [User Roles and User Interface in ESG Reporting](https://support.lucanet.cloud/en/documentation/esg-reporting/user-roles-esgrep.md): There are two available user roles for Lucanet ESG Reporting: ESG Administrator and ESG Data Collector. The options available to you will differ depending on which role you have been assigned. You will also see a different ESG Reporting interface depending on your role. - [Using the Questionnaire Builder](https://support.lucanet.cloud/en/documentation/esg-reporting/questionnaire-builder-esgrep/using-questionnaire-builder.md): After having familiarized yourself with the structure and general functions of the questionnaire builder, you can start configuring the ESRS, ESRS 2.0, or VSME questionnaire, i.e., you can define the scope of the questions that you want to include in the questionnaire, and define which reporting entity has access to certain parts of the questionnaire. - [Working with Duplicated ESG Reports](https://support.lucanet.cloud/en/documentation/esg-reporting/duplicate-report.md) ## Disclosure Management The Lucanet Disclosure Management solution enables you to cover the entire process from data collection and evaluation to transmission and reporting. Its automated data flow and integrated XBRL tagging system allow you to combine your financial and ESG reporting processes. - [All Steps at a Glance](https://support.lucanet.cloud/en/documentation/disclosure-management/process-description-disclmgmt.md): In this chapter, you will find the individual steps required to generate a report using Lucanet Disclosure Management. The presented sequence of steps is our recommendation for configuring and creating a business report in the most effective way possible. - [Attachments](https://support.lucanet.cloud/en/documentation/disclosure-management/cockpit-disclmgmt/attachments.md): Additional information in the form of attachments can be added to all chapters of a Disclosure Management document. This functionality allows you to link important supplementary documents directly with your reports, thereby collecting all relevant information in one place. A document's attachments are managed centrally in a dedicated area. - [Basic Configuration](https://support.lucanet.cloud/en/documentation/disclosure-management/basic-configuration-disclmgmt.md): Before you can start creating an annual report in Lucanet Disclosure Management, you need to configure a few basic settings. - [Cockpit](https://support.lucanet.cloud/en/documentation/disclosure-management/cockpit-disclmgmt.md): This is the central work interface in Lucanet Disclosure Management, and shows the editing state of a document at a glance. - [Configuring a Document](https://support.lucanet.cloud/en/documentation/disclosure-management/configure-document-disclmgmt.md): In Lucanet Disclosure Management, you can configure individual specifications for each document in the 'Configure document' workspace. - [Configuring an Excel File](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/excel-files-disclmgmt/excel-file-settings.md): In the Advanced settings of an Excel file, you can overwrite the Output format and Number formatting settings that are valid for all documents. - [Configuring and Executing a Data Import](https://support.lucanet.cloud/en/documentation/disclosure-management/import-data-disclmgmt/configure-and-define-data-import-disclmgmt.md): When you have defined the data source(s) and the connections to these data sources as the basis for the import in the Import Management area, you can configure and execute the data import. Both are carried out in the Lucanet Import Data workspace at individual document level. - [Configuring the Data View](https://support.lucanet.cloud/en/documentation/disclosure-management/data-view/open-and-configure-data-view.md): Various display options can be configured in the data view. For example, it can be defined from which columns and for which periods values are to be displayed. Furthermore, rows can be configured in such a manner that they are hidden in the Outarea of the Word and/or Excel file. - [Creating and Editing Chapters](https://support.lucanet.cloud/en/documentation/disclosure-management/chapter-mgmt-disclmgmt.md): For a document managed by Lucanet Disclosure Management, you can create as many chapters and chapter levels as you need in the 'Cockpit' to structure the document hierarchically. - [Creating and Editing Columns](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/excel-files-disclmgmt/define-columns.md): An MS Excel file for Lucanet Disclosure Management must always contain the following three column types to ensure that values are imported in the MS Excel file or existing values are updated. - [Creating and Editing Excel Files](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/excel-files-disclmgmt.md): MS Excel files form the main basis for using report data from the source system. For report generation purposes, data from the MS Excel files can be embedded in MS Word files in such a way that the values in the report are updated automatically if the MS Excel data are updated, e.g. as a result of an additional data import. To that end, an MS Excel file can be assigned to every chapter of a Disclosure Management document in the Cockpit. - [Creating and Editing Periods](https://support.lucanet.cloud/en/documentation/disclosure-management/period-mgmt-disclmgmt.md): For a document managed by Lucanet Disclosure Management, you can create as many periods as you need, e.g. current year or previous year. A period is a time frame for which report data are imported and saved and in which data are aggregated by time. - [Creating and Editing User Roles for Disclosure Management](https://support.lucanet.cloud/en/documentation/disclosure-management/basic-configuration-disclmgmt/role-mgmt-disclmgmt.md): Different user roles can be assigned for Lucanet Disclosure Management in the Lucanet CFO Solution Platform for each user who is activated for the solution. - [Creating and Editing Validations](https://support.lucanet.cloud/en/documentation/disclosure-management/validation-mgmt-disclmgmt.md): In Lucanet Disclosure Management, validations are used to check and ensure consistency within a document and the associated calculations. Validations record deviations from the same values within a document at a glance. For this purpose, two values are compared (e.g. assets and liabilities). - [Creating and Editing Word Files](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/configure-word-file.md): Word documents play a key role in Lucanet Disclosure Management when it comes to creating a business report. The final result document is built using them. Word documents can be used to make the corporate design and texts available for the desired result document. In Word documents, the Excel tables maintained in Disclosure Management are also published. A Word file can be stored for each chapter of a Disclosure Management document. Word files contain the Word ribbon, which provides specific functions for editing files. - [Creating and Inserting Document Variables](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/use-document-variable.md): For frequently used texts or formulations in Disclosure Management documents, document variables can be used, which can be retrieved and inserted in every MS Excel or MS Word file via the MS Word or MS Excel ribbon. - [Creating Result Document](https://support.lucanet.cloud/en/documentation/disclosure-management/create-resulting-document.md): A complete or partial result document can be generated at any time in Lucanet Disclosure Management. A result document contains the current status of an annual report stored in Disclosure Management. - [Dashboard](https://support.lucanet.cloud/en/documentation/disclosure-management/dashboard-disclmgmt.md): The dashboard is the opening screen in Lucanet Disclosure Management. From the dashboard, you can create new documents and view all the documents that have been created in Disclosure Management. You can also open documents from the dashboard. - [Defining a Data Source](https://support.lucanet.cloud/en/documentation/disclosure-management/import-data-disclmgmt/define-data-srouce-disclmgmt.md): Data sources are the basis for importing data from a source system or a source file into Lucanet Disclosure Management. To import the desired data into Disclosure Management and use it in reports, the data source must be configured accordingly in the Import Management area. - [Defining Connection to a Data Source](https://support.lucanet.cloud/en/documentation/disclosure-management/import-data-disclmgmt/define-data-source-connection-disclmgmt.md): To create a data source as the basis for importing data from a source system or a source file into Lucanet Disclosure Management, a connection to the data source must first be defined in the Import Management area. - [Defining Outareas](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/excel-files-disclmgmt/define-outareas.md): Outareas provide the database for the tables in result documents and define the cell areas of an MS Excel table that can be used for exporting into an MS Word file. An MS Excel file can contain multiple Outareas. - [Detail View of a Chapter](https://support.lucanet.cloud/en/documentation/disclosure-management/cockpit-disclmgmt/chapter-detail-view.md): The detail view of a chapter in Lucanet Disclosure Management shows the most important information on the chapter and the MS Office files defined for it, and provides context-specific functions. - [Disclosure Management](https://support.lucanet.cloud/en/documentation/disclosure-management.md): The Lucanet Disclosure Management solution enables you to cover the entire process from data collection and evaluation to transmission and reporting. Its automated data flow and integrated XBRL tagging system allow you to combine your financial and ESG reporting processes. - [Disclosure Management Settings](https://support.lucanet.cloud/en/documentation/disclosure-management/basic-configuration-disclmgmt/discl-mgmt-settings-disclmgmt.md): In the Lucanet Disclosure Management settings, each user can configure their own individual preferences for how certain areas of Lucanet Disclosure Management are displayed. These will apply across all documents. - [Displaying History of a Result Document](https://support.lucanet.cloud/en/documentation/disclosure-management/create-resulting-document/document-history.md): In the history of a result document, you can quickly see when a version was created, who created it and with which options it was created. - [Editing Documents in the XBRL Tagger](https://support.lucanet.cloud/en/documentation/disclosure-management/transfer-document-to-XBRL-tagger.md) - [Editing Values](https://support.lucanet.cloud/en/documentation/disclosure-management/data-view/edit-values-in-data-view.md): The data view can be used to import values from a source system, check them, and, if necessary, manually adjust them. - [Importing Data](https://support.lucanet.cloud/en/documentation/disclosure-management/import-data-disclmgmt.md): The data import is used to load item numbers, item names and values from a source system and/or a source data file into the Lucanet Disclosure Management database and make them available for the creation of an annual report. - [Inserting Outareas into a Word Document](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/configure-word-file/insert-outarea-in-worddocument.md): MS Excel tables and the Outareas defined in them provide the data for the tables in the result documents. The Outareas created in MS Excel can be transferred to a Word document using the Word ribbon. - [Inserting Report Values in MS Excel](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/excel-files-disclmgmt/insert-values.md): Lucanet Disclosure Management provides the Programming Wizard for inserting report values in MS Excel files. This allows previously imported report values to be inserted in an MS Excel table easily and conveniently. - [Inserting Tables From ESG Reports](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/excel-files-disclmgmt/insert-data-from-esg-reports.md) - [Inserting Texts From ESG Reports](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/configure-word-file/insert-texts-from-esg-reports.md) - [Inserting XBRL Tags](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/configure-word-file/word_add_xbrltags.md): When working with Lucanet Disclosure Management, XBRL tags of a chosen taxonomy or placeholders for XBRL tags can be inserted in MS Word documents in Lucanet software using the Word ribbon. The inserted placeholders can simply be replaced with specific XBRL tags in a subsequent tagging step using the XBRL Tagger. - [Installing and Updating the Dispatcher and Ribbons](https://support.lucanet.cloud/en/documentation/disclosure-management/basic-configuration-disclmgmt/install-disp-andribbon.md): The Dispatcher is a program that must be installed on each computer on which you wish to use the Lucanet Disclosure Management solution. Special ribbons are provided to allow you to use Lucanet Disclosure Management with MS Word and MS Excel. These ribbons will provide you with effective assistance when working with Lucanet Disclosure Management. - [Mode of Excel Files](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/excel-files-disclmgmt/excel-file-mode.md): The stored MS Excel files in Lucanet Disclosure Management can generally be differentiated between in terms of whether and how they are programmed. The method for inserting and updating the values determines their mode. - [Names and Name Extensions in MS Excel](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/excel-files-disclmgmt/setup-excel-file.md): To enable automatic insertion and updating of values in MS Excel files and interaction between MS Office files, names and/or name suffixes must be assigned to certain columns, cells and cell ranges in MS Excel. Names and name suffixes are used to link MS Word with MS Excel spreadsheets. You can easily insert and edit names and name suffixes for Lucanet Disclosure Management using the Excel ribbon. - [Notifications](https://support.lucanet.cloud/en/documentation/disclosure-management/user-interface-disclmgmt/notifications.md): The notifications in the Lucanet Disclosure Management notification window ensure that you are always well informed. You receive status and result messages for the actions you perform. - [Programming References](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/excel-files-disclmgmt/prog-references.md): Some report values, for example the numbers in a key figures table, are repeated in multiple places in reports. So that these only have to be updated in one place and are rounded immediately if applicable, references can be set. If a report value is also used elsewhere, only a reference to the Source value is set for this. The target value of the reference then no longer needs to be updated separately because changes to the source value will be transferred automatically to the target value by means of the reference. - [Ribbons for Disclosure Management](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/ribbons-disclosure-mgmt.md): When working with MS Office documents, you can use functions in specific ribbons for MS Excel and MS Word. The functions provided in the ribbons are perfectly adapted for use in conjunction with Lucanet Disclosure Management. - [Rolling Forward or Copying a Document](https://support.lucanet.cloud/en/documentation/disclosure-management/perpetuate-copy-doc-disclmgmt.md): The ‘Roll forward/copy’ workspace in Lucanet Disclosure Management provides an easy way of creating a successor document. - [The Lucanet Disclosure Management User Interface](https://support.lucanet.cloud/en/documentation/disclosure-management/user-interface-disclmgmt.md): This page contains information about the structure of the user interface and the most important elements in Lucanet Disclosure Management. From this page, you can jump easily to the detailed descriptions of the individual areas and functions. - [Using Copilot for Disclosure Management](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/configure-word-file/copilot-for-disclosure-mgmt.md): All Word documents can be optimized with AI assistance using Copilot for Disclosure Management. You can adjust your texts quickly and easily or generate completely new drafts. The Writer function helps you efficiently and accurately create taxonomy-compliant reports by generating text for any disclosure label that meets IFRS or ESRS requirements. With the Enhancer function, you can optimize your texts: - [Using Layout Actions in MS Word](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/configure-word-file/word_insert_layout.md): With the help of layout actions, you can apply a layout you have defined in Lucanet Disclosure Management’s layout robot to an Excel worksheet that you want to insert in Word. - [Using Layouts in MS Excel](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/excel-files-disclmgmt/assign-layout-toexcel.md): The layouts defined in a Layout Robot in Lucanet Disclosure Management can be applied in an MS Excel table. The applied layouts will be adopted automatically when the table is inserted in a MS Word document. - [Using Text Values in MS Word](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/configure-word-file/word-use-variables.md): Lucanet Disclosure Management allows you to insert individual report values from the MS Excel files of the currently open document into the body text of MS Word files. So-called text values are inserted into the MS Word document. - [Using the Data View](https://support.lucanet.cloud/en/documentation/disclosure-management/data-view.md): In Lucanet Disclosure Management, the data view is used to review report values (including details like history, comments, and validation) that have been imported from a source system and to update and/or modify them when necessary. - [Using the XBRL Tagger](https://support.lucanet.cloud/en/documentation/disclosure-management/xbrl-window.md): Thanks to the integrated XBRL Tagger, you can easily create XBRL-based, electronic company reports using Lucanet Disclosure Management by assigning the report data to an XBRL taxonomy (XBRL tagging/XBRL mapping). A range of XBRL taxonomies are available for this purpose. - [Versioning and Recovery of MS Office Files](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/file-versioning-restore.md): In the Lucanet Disclosure Management, MS Excel and MS Word files are saved using the 'Check In' function. When a file is checked in, a new version of the file is created automatically. All versions of a file can be recovered at any time. - [Working with MS Office Files](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice.md): In Lucanet Disclosure Management, Word and Excel files play a key role, firstly for importing data and secondly for creating a business report. - [Working with Word References](https://support.lucanet.cloud/en/documentation/disclosure-management/work-with-msoffice/configure-word-file/use-word-references.md): With Word references in Disclosure Management, you can reuse the content of a chapter from one report in a chapter of another report. ## XBRL Tagger You can use the Lucanet XBRL Tagger to immediately tag your business report without an implementation project or any IT knowledge and convert it into iXBRL. The time required to create the report is reduced considerably by processing all taxonomies and creating them correctly according to the latest standard. - [All Steps at a Glance](https://support.lucanet.cloud/en/documentation/xbrl-tagger/process-xbrl-tagger.md): In this chapter, you can find the individual steps required to tag a document with the Lucanet XBRL Tagger. The presented sequence of steps is our recommendation for editing a document as effectively as possible. - [Analyzing XBRL Data with Lucanet XBRL Vision](https://support.lucanet.cloud/en/documentation/xbrl-tagger/xbrl-daten-analysieren.md): Lucanet XBRL Vision is a free, web-based tool for professional analysis of XBRL data that enables instant validation and visualization without uploading data or installing software. It is designed for finance professionals, auditors, and regulators, and ensures full data privacy by processing directly in the browser. - [Basic Configuration](https://support.lucanet.cloud/en/documentation/xbrl-tagger/basic-configuration-xbrltagger.md): To begin tagging a document, you must configure the document settings and the Word document. - [Calculation View](https://support.lucanet.cloud/en/documentation/xbrl-tagger/xbrl-document/calculation-view.md) - [Configuring Document Settings](https://support.lucanet.cloud/en/documentation/xbrl-tagger/basic-configuration-xbrltagger/configure-xbrltagger.md): Individual specifications can be configured for each document in the 'Settings' workspace - [Creating a Taxonomy Extension](https://support.lucanet.cloud/en/documentation/xbrl-tagger/xbrl-document/xbrltagger-extend-taxonomy.md): Company­specific disclosures not available in the standard taxonomy must be reported as 'taxonomy extensions'. Furthermore, what are referred to as 'anchors' must be used to specify the present taxonomy items to which the extension is semantically connected. - [Custom Hierarchies](https://support.lucanet.cloud/en/documentation/xbrl-tagger/xbrl-document/userdefined-hierarchies.md): In the XBRL Tagger, the Custom hierarchies dialog allows you to adjust the order and structure of dimension elements and abstract elements. This way, you can reflect your internal report structure and meet your auditors' requirements without editing taxonomy files manually. - [Dashboard](https://support.lucanet.cloud/en/documentation/xbrl-tagger/dashboard-xbrltagger.md): The document overview is the starting point in the Lucanet XBRL Tagger. All documents to be tagged are loaded into the document overview. - [Displaying and Editing Properties of Tags](https://support.lucanet.cloud/en/documentation/xbrl-tagger/xbrl-document/edit-tag-properties.md): The properties of an XBRL tag can be displayed and edited in the XBRL document workspace in Lucanet XBRL Tagger. - [Displaying and Editing the Status of Tags](https://support.lucanet.cloud/en/documentation/xbrl-tagger/xbrl-document/tag-status.md): To obtain a better overview of the tagging process, the status of tagged elements can be defined in Lucanet XBRL tagger. - [Displaying Result Documents](https://support.lucanet.cloud/en/documentation/xbrl-tagger/ergebnisdokumente.md): After generating an iXBRL document, the results of the generation are displayed in the document overview in the right-hand panel on the 'Result document sets' tab. - [Displaying the Preview](https://support.lucanet.cloud/en/documentation/xbrl-tagger/xbrl-viewer.md): A preview can be displayed in the 'iXBRL Viewer' workspace to visualize and manually check the InlineXBRL content and information. The saved XBRL information can be displayed and highlighted in the iXBRL viewer. - [Generating an iXBRL Report](https://support.lucanet.cloud/en/documentation/xbrl-tagger/generate-ixbrl.md): The iXBRL document, including all documents and folders prescribed by the regulatory authorities, can be generated in the 'XBRL document' workspace. - [Introduction to iXBRL](https://support.lucanet.cloud/en/documentation/xbrl-tagger/ixbrl-introduction.md): The reports created by the Lucanet XBRL Tagger are based on the standard iXBRL. You can find the corresponding basic information in this chapter. - [Managing Continuation Chains](https://support.lucanet.cloud/en/documentation/xbrl-tagger/xbrl-document/continuation-administration.md): The Continuation administration allows you to view, reorder, and manage all continuation items belonging to a selected tag in one place. - [Preparing a Word File](https://support.lucanet.cloud/en/documentation/xbrl-tagger/basic-configuration-xbrltagger/prepare-word-file.md): MS Word documents must meet specific requirements to allow then to be tagged correctly. In this chapter, you can find the most important requirements that Word documents must meet to be tagged. - [Tagging a Document](https://support.lucanet.cloud/en/documentation/xbrl-tagger/xbrl-document/xbrl-tag-document.md): Lucanet's XBRL Tagger allows individual words or sentences, values, and entire chapters and tables of a document to be tagged. - [User Interface of the Lucanet XBRL Tagger](https://support.lucanet.cloud/en/documentation/xbrl-tagger/user-interface-xbrltagger.md): On this page, you can find information on the structure of the user interface and the main elements in the Lucanet XBRL Tagger. From this page, you can jump easily to the detailed descriptions of the individual areas and functions. - [Using Hidden Elements](https://support.lucanet.cloud/en/documentation/xbrl-tagger/xbrl-document/use-hidden-facts.md): In the XBRL Tagger, you can use the Hidden elements view to manually add and tag XBRL values that do not exist as visible elements in the source document. These values are referred to as hidden elements (hidden facts). - [Validations in XBRL Documents](https://support.lucanet.cloud/en/documentation/xbrl-tagger/xbrl-document/validation_xbrltagger.md): A document can be checked for errors, validity and completeness by means of validations. Lucanet XBRL Tagger has two validation types. - [Working with Footnotes](https://support.lucanet.cloud/en/documentation/xbrl-tagger/xbrl-document/footnote-tagging.md): In the XBRL Tagger, you can use tagged text blocks as footnotes. To do so, link the tagged text block to one or more cells of a table. - [Working with Layers](https://support.lucanet.cloud/en/documentation/xbrl-tagger/xbrl-document/xbrl-tag-document/using-layer.md) - [XBRL Document](https://support.lucanet.cloud/en/documentation/xbrl-tagger/xbrl-document.md): The 'XBRL document' workspace is the main workspace in the Lucanet XBRL Tagger. The documents from the document overview are tagged in the 'XBRL document' workspace. - [XBRL Tagger](https://support.lucanet.cloud/en/documentation/xbrl-tagger.md): You can use the Lucanet XBRL Tagger to immediately tag your business report without an implementation project or any IT knowledge and convert it into iXBRL. The time required to create the report is reduced considerably by processing all taxonomies and creating them correctly according to the latest standard. ## Lease Accounting Lucanet Lease Accounting offers you a secure and efficient solution for recording, calculating and posting lease contracts in accordance with IFRS 16. - [All Steps at a Glance](https://support.lucanet.cloud/en/documentation/lease-accounting/process-description-lease-accounting.md): In this chapter, you will find the individual steps required to account for your lease relationships. The steps must be carried out in the order provided, and performed separately for each lessee (reporting entity). - [Basic Configuration for Lease Accounting](https://support.lucanet.cloud/en/documentation/lease-accounting/basic-configuration-lease-accounting.md): Before you can start accounting for your leases in Lucanet Lease Accounting, you will need to configure a few basic settings in the ‘Settings’ area. These will form the foundation for your subsequent use of the solution. - [Calculating Data](https://support.lucanet.cloud/en/documentation/lease-accounting/measurement.md): The calculation process in Lucanet Lease Accounting assesses the contract components and liabilities in accordance with IFRS 16 and calculates the values accordingly. - [Categorizing Components](https://support.lucanet.cloud/en/documentation/lease-accounting/categorization.md): The categorization process in Lucanet Lease Accounting checks all new and modified contract components and classifies them in accordance with IFRS 16. - [Collecting Data](https://support.lucanet.cloud/en/documentation/lease-accounting/data-collection.md): You can use the ‘Data collection’ area in Lucanet Lease Accounting to manually collect or import data on each of your lease relationships. These data include the names of the individual lessors, the lease contracts themselves and contract components. You can also reverse contract components whose numbers have already been added to the database. - [Creating and Configuring Asset Classes](https://support.lucanet.cloud/en/documentation/lease-accounting/basic-configuration-lease-accounting/manage-asset-classes.md): An ‘asset class’ is a group of assets that have similar characteristics and are subject to the same accounting treatment. This classification helps to make the structuring and management of lease components more efficient. - [Creating and Configuring Contract Components](https://support.lucanet.cloud/en/documentation/lease-accounting/data-collection/create-configure-contract-components.md): ‘Contract components’ are individual elements of a leasing contract. Each component enables the precise recording and management of different lease terms, conditions and properties of individual underlying assets within the same leasing contract. - [Creating and Configuring Contracts](https://support.lucanet.cloud/en/documentation/lease-accounting/data-collection/create-configure-contracts.md): A lease contract is a formal agreement between the lessor and the lessee that transfers the right to control the use of an identified asset for a defined period of time in exchange for compensation. - [Creating and Configuring Interest Rates](https://support.lucanet.cloud/en/documentation/lease-accounting/basic-configuration-lease-accounting/manage-interest-rates.md): Interest rates are used to calculate the current value of lease payments. They are key to determining lease liability and the right-of-use asset for the balance sheet. - [Creating and Configuring Lessors](https://support.lucanet.cloud/en/documentation/lease-accounting/data-collection/create-configure-lessor.md): A lessor is the party the owns the underlying asset and transfers it to another party (the lessee) for a contractually agreed lease term, under certain conditions. Lessors are the contracting parties that provide the basis for lease contracts in Lease Accounting. - [Creating or Importing Cost Centers](https://support.lucanet.cloud/en/documentation/lease-accounting/basic-configuration-lease-accounting/import-cost-center.md): Cost centers that have been created for reporting entities in Consolidation & Financial Planning can be imported directly into Lease Accounting. This feature ensures that your financial and lease data are interconnected, allowing for more comprehensive reporting and analysis. - [Creating Postings](https://support.lucanet.cloud/en/documentation/lease-accounting/create-postings.md): When you have assessed and calculated the components, you can create the postings for these components. The postings are automatically saved in the Lease Accounting database and can then be exported and imported into Lucanet.Financial OLAP server or other systems. - [Exporting Reports and Postings](https://support.lucanet.cloud/en/documentation/lease-accounting/export-data.md): In the ‘Export’ workspace in Lucanet Lease Accounting, you can export existing postings and generate reports for the data that has been recorded in Lease Accounting. This is useful for purposes such as sharing data with other parties, evaluation and comparing data. - [General Configurations](https://support.lucanet.cloud/en/documentation/lease-accounting/basic-configuration-lease-accounting/general-configurations-la.md): The General Configurations workspace provides essential system-wide settings that establish the foundational parameters for your lease accounting processes. - [General Functions in Lease Accounting](https://support.lucanet.cloud/en/documentation/lease-accounting/general-functions-lease-accounting.md): Lease Accounting provides a number of general functions for actions such as making tables easier to read and switching quickly between reporting entities for which data shall be collected as the lessee. - [Importing and Configuring Reporting Entities](https://support.lucanet.cloud/en/documentation/lease-accounting/basic-configuration-lease-accounting/manage-lessees.md): A lessee is the party who receives the right to use an asset under the conditions of a lease contract. In Lucanet Lease Accounting, leases are recorded separately for each lessee. - [Importing Data Automatically](https://support.lucanet.cloud/en/documentation/lease-accounting/data-collection/automatic-data-import.md): Automatic data imports allow you to import contracts, lessors and contract components automatically. This both simplifies the import process and saves you time. - [Importing Postings into Consolidation & Financial Planning](https://support.lucanet.cloud/en/documentation/lease-accounting/importing-postings-cfp.md) - [Lease Accounting](https://support.lucanet.cloud/en/documentation/lease-accounting.md): Lucanet Lease Accounting offers you a secure and efficient solution for recording, calculating and posting lease contracts in accordance with IFRS 16. - [Reversing Components](https://support.lucanet.cloud/en/documentation/lease-accounting/data-collection/reverse-components.md): Reversing components resets them to their “original state”, i.e. how they were before the components’ calculated values were first entered in the database. - [Reversing Postings](https://support.lucanet.cloud/en/documentation/lease-accounting/reverse-postings.md): In Lucanet Lease Accounting, you have the option of reverse postings that have already been created or exported in the 'Reverse postings' workspace. - [Selecting a Lessee](https://support.lucanet.cloud/en/documentation/lease-accounting/select-lessee.md): A lessee is the party who receives the right to use an asset under the conditions of a lease contract. In Lucanet Lease Accounting, leases are recorded separately for each lessee. - [User Roles in Lease Accounting](https://support.lucanet.cloud/en/documentation/lease-accounting/user-roles-la.md): The role-based permission system in Lease Accounting enables administrators to control access to specific functions and data within the solution with the following six predefined roles. - [Viewing Import History](https://support.lucanet.cloud/en/documentation/lease-accounting/data-collection/show-import-history.md): In Lucanet Lease Accounting, you can visit the ‘Import history’ workspace at any time to access information on all your previous imports across all reporting entities. This allows you to view the properties, status and execution errors for each individual import. ## Banking & Cash Management Simplify payment transactions and cash management with our fully automated banking and cash management solution. Our solution streamlines workflows, offers real-time insights, and ensures seamless system integration—all while delivering top-tier security and unmatched flexibility. - [Banking & Cash Management](https://support.lucanet.cloud/en/documentation/banking-and-cash-management.md): Simplify payment transactions and cash management with our fully automated banking and cash management solution. Our solution streamlines workflows, offers real-time insights, and ensures seamless system integration—all while delivering top-tier security and unmatched flexibility. ## Data Collection Streamline your data collecting process with a modern, web-based solution for gathering, validating, and enriching financial data across all your reporting entities: With Lucanet Data Collection, you can efficiently collect financial and statistical data from distributed teams, validate data quality in real time, and ensure consistency through intercompany validation. - [All Steps at a Glance](https://support.lucanet.cloud/en/documentation/data-collection/process-description-data-collection.md): In this chapter, you will find the individual steps required to set up and run a data collection process. The configuration steps should be carried out in the order provided to ensure all dependencies are met before starting data collection. - [Basic Configuration](https://support.lucanet.cloud/en/documentation/data-collection/basic-configuration-dc.md): Before starting a data collection process, administrators must set up the foundational elements that define what data to collect, how to validate it, and who will provide it. This section covers the essential configuration steps. - [Collecting Data](https://support.lucanet.cloud/en/documentation/data-collection/collecting-data-dc.md): Once the basic configuration is complete, administrators can start data collection processes. This section covers how to bundle form templates into reporting packages, initiate data collection, and how users enter, validate, and approve their data. - [Creating and Configuring Form Templates](https://support.lucanet.cloud/en/documentation/data-collection/basic-configuration-dc/creating-and-configuring-form-templates.md): Form templates are the foundation of data collection in Data Collection. A form template defines the structure and layout of the data you want to collect from reporting entities. You can configure your form templates by adding elements that are based on Consolidation & Financial Planning structures, or by creating them from scratch. - [Creating and Configuring Reporting Packages](https://support.lucanet.cloud/en/documentation/data-collection/basic-configuration-dc/create-configure-reporting-packages.md): A Reporting Package is a virtual container that bundles together the elements required for a data collection process: - Form templates with completion instructions - Reporting entities with assigned collectors and approvers - Intercompany validation rules (if enabled) - [Creating and Configuring Validation Rules](https://support.lucanet.cloud/en/documentation/data-collection/basic-configuration-dc/create-configure-validation-rules.md): Validation rules help ensure data accuracy and consistency during data collection. Two types of validation rules are available, determined by the rule scope: regular and intercompany. Regular rules refer to general validations applied to the data collected by a single reporting entity. Intercompany rules refer to validations for balances between related reporting entities, such as subsidiaries or group companies. - [Data Collection](https://support.lucanet.cloud/en/documentation/data-collection.md): Streamline your data collecting process with a modern, web-based solution for gathering, validating, and enriching financial data across all your reporting entities: With Lucanet Data Collection, you can efficiently collect financial and statistical data from distributed teams, validate data quality in real time, and ensure consistency through intercompany validation. - [Entering, Validating, and Approving Data](https://support.lucanet.cloud/en/documentation/data-collection/collecting-data-dc/entering-validating-approving-data.md): Once a data collection process has been started, assigned collectors can view, edit, validate, and submit data through forms. This chapter covers the complete workflow from entering data to final approval. - [Importing Data](https://support.lucanet.cloud/en/documentation/data-collection/collecting-data-dc/importing-data.md): Instead of entering data manually, you can import financial data directly from external sources. Data Collection supports two import types, each suited to a different source system and workflow. - [Importing Data from Consolidation & Financial Planning](https://support.lucanet.cloud/en/documentation/data-collection/collecting-data-dc/importing-data/importing-data-cfp.md): Sie können aggregierte Finanzdaten aus Consolidation & Financial Planning (CFP) direkt in Datenerfassungsformulare importieren. Anders als beim Datenimport aus MS Excel erfordert ein Datenimport aus CFP keine manuelle Zuordnung – das System ordnet Daten den Zeilen und Spalten des Formulars automatisch über OIDs zu. Ein Administrator konfiguriert den Periodenwerttyp für jede Spalte in der Formularvorlage, und Erfasser führen den Import mit einem einzigen Klick aus. - [Importing Data from Excel](https://support.lucanet.cloud/en/documentation/data-collection/collecting-data-dc/importing-data/importing-data-excel.md): You can import financial data from Excel files directly into Data Collection forms. After uploading a file, you map form rows and columns to Excel data interactively. The system saves your mappings so that recurring imports are faster — upload an updated file and your previous configuration is restored automatically. - [Importing Data from Lucanet.Financial Warehouse](https://support.lucanet.cloud/en/documentation/data-collection/collecting-data-dc/importing-data/import-warehouse.md): You can import financial and statistical data from the Lucanet.Financial Warehouse (FWH) directly into Data Collection forms. A DC Administrator configures structural mapping in the form template to define how Lucanet.Financial Warehouse dimensions and measures map to the pivot table's rows and columns. Collectors then complete element mapping — linking local dimension elements to group-level DC structures — and execute the import. - [Importing Reporting Entities from Consolidation & Financial Planning](https://support.lucanet.cloud/en/documentation/data-collection/basic-configuration-dc/import-reporting-entities.md): Reporting entities represent the organizational units (e.g., companies, subsidiaries) for which financial data is collected. In Data Collection, reporting entities are imported from Consolidation & Financial Planning (CFP) to ensure consistency across both solutions. - [Starting Data Collection Processes](https://support.lucanet.cloud/en/documentation/data-collection/collecting-data-dc/collecting-data.md): Data collection is the process of gathering financial and statistical information from multiple reporting entities within an organization. In Data Collection, an Administrator starts data collection processes to gather financial and statistical information from reporting entities. - [User interface of Data Collection](https://support.lucanet.cloud/en/documentation/data-collection/user-interface-dc.md): On this page, you will find information on the structure of the user interface and the main elements in Data Collection. From this page, you can navigate to detailed descriptions of the individual workspaces. - [User Roles in Data Collection](https://support.lucanet.cloud/en/documentation/data-collection/user-roles-in-data-collection.md): The role-based permission system in Data Collection enables administrators to control access to specific functions and data within the solution. Data Collection provides two dedicated application roles that work together to streamline the financial data collection process: Administrator Data Collector ## Tax Compliance & Reporting - [(Special) Investment Income](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/special-investment-returns.md): The ‘(Spezial-) Investmenterträge’ ((Special) Investment Income) workspace is used to enter issues pursuant to section 20 (1.3 and 1.3a) of the Income Tax Act (EStG). - [(Sub-) Group](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/sub-group.md): The data of the individual companies are aggregated in the (Sub-)Group functional area. - [§ 15a EStG](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/15A-EStG.md): You can use the §15a EStG workspace to enter or display losses with limited liability. - [§ 8b KStG](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/s-8b-kstg---beteiligungen-an-anderen-koerperschaften-und-persone.md): Both what is referred to as the net method (tax exemption of issues pursuant to section 8b of the Corporate Tax Act at the level of the receiving company) and the gross method can be applied in Income Taxes (applies to partnership companies and tax group members). The § 8b KStG workspace is available to enter these issues to enable differentiated treatment and automated calculation. - [Administrating Master Data](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/master-data-tax-balance.md): Under Master Data, you can create, import, and manage globally valid data for Tax Balance. - [Administration](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/administration.md): In the Administration workspace, you can view and maintain basic system settings of Income Taxes. - [Angaben für MU (Information for Partners)](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/information-for-mu.md): Relevant information is displayed in the Angaben für MU (Information for Partners) workspace for the following attachments: - AESt attachment - SPIF attachment - SPIFA attachment - [Anlage Bekanntgabe (Notification Attachment)](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/add-announcement.md): Consent to the electronic notification of trade tax assessment notices by the municipalities entitled to levy the tax is given in the Anlage Bekanntgabe workspace. - [Aufteilungsquoten (Allocation Quotas)](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/basic-data/allocation-quotas.md): How tax bases are allocated is shown in the Aufteilungsquoten (Allocation Quotas) workspace. The Allocation Quotas workspace is relevant whenever investment relationships change during the year, e. g. when a shareholder changes. Entries on the allocation quotas in Anlage FB are required for this purpose. - [Ausländische Zwischengesellschaften (Foreign Intermediate Companies)](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/basic-data/international-intermediate-companies.md): The ‘Ausländische Zwischengesellschaften (Foreign Intermediate Companies)’ workspace contains the investments in foreign intermediate companies in accordance with section 7 of the Foreign Tax Act. - [B/S Comparison](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/deferred-taxes/balance-sheet-comparison.md): Besides the "Loss carried forward" workspace, the "B/S Comparison" workspace is the central workspace for determining deferred taxes. - [Basic Data](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/basic-data.md): In the "Basis data" workspace, corporations can select the assessment rate used (for trade tax purposes) and assign foreign branches. For partnership companies, this workspace also allows you to manage partners. - [Business Activities](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/cbc-reporting/entity-data-collection-cbcr/business-activities-cbcr.md) - [C0 – Safe Harbour Check](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/calculation/c1.md): The Safe Harbour Check workspace includes the three transitional safe harbour tests: - Simplified ETR test - De minimis test - Routine profits tests - [C1 – NMCE Safe Harbour](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/calculation/c1-nmce-safe-harbour.md) - [C2 – CE Calculations](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/calculation/c2.md): The C2 - CE Calculations workspace contains a list of the data points used in the Pillar 2 calculations, including entity elections as well as jurisdictional elections, to the extent that they impact individual CEs. - [C3 – De Minimis Check](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/calculation/c3.md): The De Minimis Check workspace contains the permanent safe harbour test. This test is successful if the GloBE revenue and the GloBE Income are below the respective GloBE thresholds. - [C4 – Jurisdictional Blending](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/calculation/c4.md): The jurisdictional blending aggregates CE data based on the reporting dimension type selected for the top-up tax blending. - [C5 – Top-up Tax Allocation](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/calculation/c5.md): This workspace displays the top-up tax payable by low-taxed CEs and members of joint venture groups. - [Calculation](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/cbc-reporting/calculation-cbcr.md): At Country-by-Country Reporting | Calculation | Home, users can create new snapshots, manage existing snapshots, and select a snapshot that will be presented in the other workspaces under Calculation. - [Calculation](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/calculation.md): In the context of tax management and reporting, the term calculation refers to a data-driven process that produces specific results in compliances with the relevant laws and guidelines. These calculations are essential for deriving key financial indicators such as tax liabilities, income adjustments, and safe harbors. - [Capital Gains Tax on Dividends](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/current-taxes-2/tax-on-dividends.md): How to enter the entire dividend issue is described in this chapter. The entry is made in §8b KStG, including the entry of the capital gains tax and the indication of the posting method (affecting or not affecting P&L). - [CbC Report in XML format](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/cbc-reporting/calculation-cbcr/xml-report-cbcr.md) - [CE Information](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/cbc-reporting/entity-data-collection-cbcr/ce-information-cbcr.md) - [Certificates](https://support.lucanet.cloud/en/documentation/income-taxes/tax-administration/certificates.md): In the Certificates work space, you can centrally record, maintain, and assign Elster and ELMA certificates to users. - [CoA Company](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/coacompany.md) - [CoA Group](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/coagroups.md): The balance sheet structure stored in the CoA Group workspace provides the common, binding framework for all companies and serves as the basis for the B/S Comparison workspace in the Company functional area. - [Cockpit](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/cbc-reporting/cockpit-cbcr.md): The Cockpit folder offers the option to monitor and change milestones and execute imports from various sources. - [Cockpit](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/cockpit.md): The Cockpit folder offers the option to monitor and change milestones, set up the blending, and execute imports from various sources. - [Comments](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/comments.md): Comments in Income Taxes are additional explanations of individual rows, workspaces, or forms. Comments can contain text or file attachments. Furthermore, in many cases it is optionally possible to transfer data to the tax calculation using the Comments function. - [Companies](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/companies.md): In the Companies workspace, the companies created in the selected period are displayed. - [Company](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company.md): In the Company functional area, the calculation of current (actual) and deferred taxes for annual and monthly financial statements is carried out. The electronic tax return is also edited in this area and submitted to the tax authority. - [Configuration](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/interfaces/interfaces-configuration.md): In the Configuration workspace, you can choose interfaces to be used for a period-independent, automated export. - [Configuring Functions](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/create-single-entity-tax-balance/configure-functions.md): In the Functions workspace, important tax tools are provided to correctly reflect complex issues, such as tax groups, partnerships, special business assets, and reorganizations in the system, and make automatic calculations and adjustments. - [Configuring Reorganizations](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/create-single-entity-tax-balance/configure-functions/configure-transformations.md): The Reorganization function helps you make the necessary balance sheet adjustments for the entities involved in the reorganization. In this process, the assets and liabilities of the transmitting entity are automatically reflected in the balance sheet of the receiving entity. - [Configuring Tax Balance Sheet Settings](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/create-single-entity-tax-balance/configure-tax-balance-settings.md): General settings for the display and taxonomy items are configured in the Tax Balance Sheet Settings workspace. - [Corporate Income Tax](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/corporate-tax.md): The corporate income tax return is prepared in the Corporate Income Tax functional area. You can find the attachments that must be completed for electronic tax return purposes in the Corporate Income Tax functional area. The individual attachments correspond to the forms of the tax authority. - [Countries](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/countries.md): In the Countries workspace, the countries maintained in the selected period are displayed. - [Country-by-Country Reporting](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/cbc-reporting.md): The Country-by-Country Reporting (CbCR) sub-module enables the automated collection, validation, and reporting of country-specific data in accordance with OECD guidelines and local regulations. - [Creating a Company](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/master-data-tax-balance/create-company.md): In the Companies workspace, you can manage the companies for which you want to prepare tax balance sheets and transmit them to the tax office. - [Creating a Tax Balance Sheet for an Individual Company](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/create-single-entity-tax-balance.md): After you have defined the master data for Tax Balance, you can create the tax balance sheet(s) at the individual company level. - [Creating an Adjustment Level](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/master-data-tax-balance/create-adjustment-level.md): To reflect different levels of knowledge (such as tax return, annual financial statements, tax audit), tax deviations based on commercial law values can be assigned to adjustment levels. The level of transparency is increased by using adjustment levels. - [Creating and Configuring Adjustments](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/create-single-entity-tax-balance/maintain-gaap-reports/creating-and-configuring-adjustments.md): You can enter tax deviations based on commercial-law values at adjustment levels and create the company-specific adjustment levels that may be required for this purpose in the Adjustments workspace. In addition to company-specific adjustment levels, you can also use global adjustment levels that you have created in the master data. You can also update or import existing adjustments. - [Creating and Configuring an Interface](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/master-data-tax-balance/create-interface.md): To import your financial data from source systems, you must first define the interfaces used to import them from these systems. Interfaces are used to define specific settings for the import behavior and import parameters. - [Creating and Configuring Periods](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/periods/create-period.md): This article describes how to create and configure periods and provides two examples for the configuration of an annual report and a tax declaration for a True Up period. - [Creating and Configuring the Element Type Country](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/countries/create-configure-country.md): This article describes how to create and configure countries and also includes an overview of the corresponding key attributes, such as tax rates and exchange rates. - [Creating Reorganizations](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/master-data-tax-balance/create-transformations.md): In the Reorganizations workspace, you can configure tax accounting adjustments for the entities involved in reorganizations. - [Creating Reports](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/create-reports-.md): You can generate reports of the data entered in Tax Balance in the Reports workspace. In addition, you can create an instance report of the tax balance sheet, which exports the XML-based version transmitted to the tax office into a human-readable and printable format. - [Creating Tax Balance Sheets](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/master-data-tax-balance/create-tax-balance-sheet.md): In the Tax Balance Sheets workspace, you can create your tax balance sheets and assign them to the companies for which the tax balance sheet is to be used. - [Cross-border Adjustments](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/entity-data-collection/cross-border-adjustments.md): While allocations and adjustments are legally distinct concepts, from a technical perspective, cross-border adjustments work similar to tax allocations and FTE & PE allocations. - [Current Taxes](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes.md): For foreign companies, the tax is calculated in the Current Taxes workspace. Unlike German companies, the income assessment is made without using tax workspaces. The structure of the Current Taxes workspace is configured for each country within the master data (Toolbox workspace). - [Current Taxes](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/current-taxes-2.md): In the 'Current Taxes' workspace, you can enter country-specific tax data for foreign companies to calculate taxes. These data are required above all to create the tax rate reconciliation (TRR). - [Current Taxes in Switzerland](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/current-taxes-2/currency-taxes-switzerland.md): There is a three-tier taxation system of federal government, cantons, and communes in Switzerland, with each level having the right to levy its own taxes. The tax calculation differs across the 26 cantons. To apply the Swiss tax calculation specifically in Income Taxes, you can activate the Swiss Tax Law function in the country master data. Individual flags must be activated for this purpose. - [Data Export](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/data-export.md): The flexible export currently supports the creation of a CSV file with data from the trade tax allocation (GewStZ) and the generation of CSV and PDF files based on custom reports. - [Data Transfer](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/data-transfer.md): The Data Transfer workspace is used to store, display, and adjust imported values that are required for reports, posting documents, and validation, but do not flow directly into the balance sheet comparison. Typical cases of use are account information and account balances from source systems that are supplied with the import and are to be used in calculations or exports at a later point of time. - [Data Transmission](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/eric-transfer/data-transfer.md): The Data transmission workspace is used for the electronic transfer of the tax return. In this workspace, you can perform a test run including transmission before the final transmission. - [Decomposition](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/decomposition-gewst-kst.md): This section describes the trade tax allocation and corporate income tax allocation. - [Deferred Taxes](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/deferred-taxes.md): The Deferred Taxes functional area contains a number of workspaces in which deferred tax assets and liabilities are calculated. Which workspaces are displayed depends on the company currently selected and the master data configuration. - [Deferred Taxes of (Sub-)Group](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/sub-group/deferred-taxes-subgroup.md): The workspace Deferred Taxes in the (Sub-) Group area aggregates the deferred tax assets and deferred tax liabilities calculated in the Company workspace. - [Detail Results](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/calculation/allocations.md): The Allocations workspace displays a table with different information about allocations between a source CE and a target CE. It is possible to export the assignment as an Excel file or as a pdf. - [Differences](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/reporting/differences.md): In the workspace Differences, a user-configurable evaluation of deferred taxes is possible. - [Displaying an Einheits-GmbH & Co. KG](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/current-taxes-2/structure-gmbh-co-kg.md): An Einheits-GmbH & Co. KG is a special form of GmbH & Co. KG in which the limited partnership (KG) and its general partner GmbH form an economic unit. In this case, the KG is often the sole shareholder of the general partner GmbH. This means that the KG both controls its general partner and conducts the business. How to set up an Einheits-GmbH & Co. KG is described in detail in this chapter. - [E-mail Configuration](https://support.lucanet.cloud/en/documentation/income-taxes/tax-administration/e-mail-configuration.md): In the workspace E-mail configuration, you can configure e-mail servers that are used to send e-mail templates. - [E-Mail Templates](https://support.lucanet.cloud/en/documentation/income-taxes/tax-administration/email-templates.md): The E-mail templatesworkspace allows you to create templates for e-mails for specific intentions. These templates are triggered by events, expanded/enriched with appropriate content, and sent to users of Income Taxes. - [Einkünfte (Revenue)](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/income.md): The tax for partnership companies is calculated in the Revenue workspace. The workspace must always be used for partnership companies and is linked to the workspace Current Taxes Current Taxes in annual financial statement periods. - [Electronic Transmission](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/eric-transfer.md): In addition to its reporting functions, Income Taxes can also be used to submit the electronic tax return. - [Entity Data Collection](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/cbc-reporting/entity-data-collection-cbcr.md): The Entity Data Collection folder stores information on individual constituent entities (CEs). This information then forms the basis for the Country-by-Country report. - [Entity Data Collection](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/entity-data-collection.md): The Entity Data Collection folder stores information on individual constituent entities (CEs). This information then forms the basis for the Pillar 2 calculations. This article explains which data is stored in the entity data collection and how to enter that data. - [Exporting Data](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/export-data.md): Using the export function, you can export a CSV file with the balance sheet and account data of the tax balance sheet. This file can then be imported into the Income Taxes module. - [Exporting Periods](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/periods/export-periods.md): The period export function provides the option to export either all or part of a period’s data. - [Fast Entry](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/eric-transfer/fast-entry.md): Additional values for the purpose of the tax return can be entered in the Fast entry workspace, based on what are referred to as ERiC IDs. This ensures that all rows of the forms can be submitted – including those that may not yet be available in Income Taxes. - [Feststellung (Determination)](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/feststellung.md): The declaration for the separate and uniform determination of income of a partnership is performed in the functional area Feststellung (Determination). - [Financial Data](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/cbc-reporting/entity-data-collection-cbcr/financial-data.md) - [First Steps in Pillar 2 and CbCR](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/process-description-pillar2-cbcr.md): After updating to the new version of TCR, the master data must first be fully maintained before substantive work can begin in the Pillar 2 sub-module. This guide describes the required steps in the recommended order. - [Foreign Branches / Fonds](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/basic-data/foreign-businesses-funds.md): The created branches are displayed in the 'Foreign Branches / Fonds' workspace. You can create new branches and use the 'Copy from ...' function to copy existing branches into the current period. - [Foreign Branches / Fonds](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/foreign-branches-fonds.md): Branches are created in the master data workspace Foreign branches / Fonds. You can create new branches and use the function Copy from... to transfer over information from existing branches. - [FTE & PE Allocations](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/entity-data-collection/fte-pe-allocations.md): In the FTE & PE Allocations workspace, you can manage cross-border allocations of income or loss and taxes between a parent entity and its permanent establishment (PE) or a flow-through entity (FTE). - [General Functions](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/introduction-to-the-ui/general-functions-in-incometaxes.md) - [Group Data](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/cbc-reporting/calculation-cbcr/group-data.md): The Group Data workspace displays the information from the Group Data Collection workspace as it was when the snapshot was created. This information is a required part of the Country-by-Country report. - [Group Data](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/calculation/group-data.md): The Group Data workspace displays the information from the Group Data Collection workspace as it was when the snapshot was created. This information is a required part of the Pillar 2 report. - [Group Data Collection](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/cbc-reporting/group-data-collection-cbcr.md): The Group Data Collection workspace contains general information on the group at large. - [Group Data Collection](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/group-data-collection.md): The Group Data Collection workspace contains general information on the group at large. - [Home](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/cbc-reporting/entity-data-collection-cbcr/cbcr-home.md): The Home workspace of the Entity Data Collection displays the status of the selected entity’s milestone as well as of the milestones of all dependent entities and entities in the same subgroup. - [Home](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/entity-data-collection/pillar-two-home.md): The Home workspace of the Entity Data Collection displays the status of the selected entity’s milestone as well as of the milestones of all dependent entities and entities in the same subgroup. - [Import](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/cbc-reporting/cockpit-cbcr/import.md): The Country-by-Country Reporting module includes a variety of options for the import of entity data, both from internal sources, and from external sources such as SAP or Excel files. - [Import](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/import.md): The Import workspace allows transaction data to be imported from source systems (e.g. SAP systems) into Income Taxes. Data can be imported into the balance sheet comparison and the tax forms. - [Import](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/cockpit/import.md): The Pillar 2 module includes a variety of options for the import of entity data, both from internal sources, and from external sources such as SAP or Excel files. In addition, it is possible to import allocations, such as tax allocations, FTE & PE allocations, or cross-border adjustments. - [Import Mapping](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/interfaces/interfaces-import-mapping.md): In the Import Mapping workspace, you can define how source items that you import from a source system are mapped to the target fields when you use an interface structure of type Import (enhanced). - [Import Suite](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/import-suite.md): In the Import Suite workspace, you can configure and start the import of data. You can choose an interface that has already been configured and adjust the start and end date if required. The suggested end date corresponds to the last day of the selected period, while the start date is generally January 1 of the relevant calendar year. - [Import, Batch Import, and Automation](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/sub-group/bulk-import.md): In the 'Import’ workspace, data can be imported into Income Taxes. With the batch import, it is possible to trigger the import for multiple companies simultaneously. - [Importing Balance Sheet Structure from Income Taxes](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/master-data-tax-balance/import-balance-sheet-structure.md): In the Balance Sheet Structure workspace, you can import the balance sheet structure that is stored in the Income Taxes module of the Tax Compliance & Reporting solution into Tax Balance. - [Importing Data](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/create-single-entity-tax-balance/import-data.md): You can use this import process to import the following data for the tax balance sheet to the taxonomy structure you have chosen:- Accounts - Fixed asset schedule - Equity accounts - Debt capital accounts - [Importing E-Balance Data into Tax Balance](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/master-data-tax-balance/import-e-bilanz-from-other-systems.md): If you have previously used another system to create and submit your E-Balance, you can import E-Balance data from that system into Tax Balance via an XML file in the Import from E-Balance workspace. - [Importing Exchange Rates](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/countries/import-exchange-rates.md): With the help of the import function in the Countries workspace, exchange rates can be automatically imported into Income Taxes. - [Importing Master Data from Income Taxes](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/master-data-tax-balance/import-master-data-from-income-taxes.md): You can use the master data import to import GCD master data (General Common Data) from the Income Taxes module into the Tax Balance module. - [Importing Periods](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/periods/import-periods.md): Importing periods offers the possibility to import master data and transaction data from another Income Taxes period, either in part or completely. - [Income Tax Forms](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/income-tax-forms.md): The following articles contain tables listing the available income tax forms for each assessment period. - [Income Tax Forms – Assessment Period 2019](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/income-tax-forms/income-tax-form-vz-2019.md): This article contains tables providing an overview of the forms available in assessment period 2019. - [Income Tax Forms – Assessment Period 2020](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/income-tax-forms/income-tax-form-vz-2020.md): This article contains tables providing an overview of the forms available in assessment period 2020. - [Income Tax Forms – Assessment Period 2021](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/income-tax-forms/income-tax-form-vz-2021.md): This article contains tables providing an overview of the forms available in assessment period 2021. - [Income Tax Forms – Assessment Period 2022](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/income-tax-forms/income-tax-form-vz-2022.md): This article contains tables providing an overview of the forms available in assessment period 2022. - [Income Tax Forms – Assessment Period 2023](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/income-tax-forms/income-tax-form-vz-2023.md): This article contains tables providing an overview of the forms available in assessment period 2023. - [Income Tax Forms – Assessment Period 2024](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/income-tax-forms/income-tax-forms-vz-2024.md): The tables in this article provide an overview of which forms are available for the 2024 assessment period. - [Income Taxes](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes.md) - [Interest Capping Rule](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/interest-capping-rule.md): For partnerships, the Interest Capping Rule workspace is available in the Company functional area. You can enter all values required to determine the deductible interest expenses (interest capping rule pursuant to section 4h of the Income Tax Act (EStG)) centrally there. The entered data are automatically transferred to the Interest Capping Rule form (Anlage Zinsschranke) in the Feststellung (Determination) workspace. - [Interface to Lucanet Consolidation and Financial Planning (CFP)](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/import-suite/cfp-interface.md): To import balance sheet data and P&L values from Lucanet Consolidation & Financial Planning (CFP) into Income Taxes, an interface must be created and configured. The steps required to do this are described here. - [Interfaces](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/interfaces.md): Under Interfaces in the Master Data folder, you define configurations for importing and exporting data and assigning (mapping) the imported or exported source data. Here you can specify custom import routines or create what is referred to as a flexible interface. - [Jurisdictional Data Collection](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/jurisdictional-data-collection.md): In this section, you can enter information pertaining to a qualified domestic top-up tax (QDMTT). - [Jurisdictional Elections](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/jurisdictional-elections.md): The Jurisdictional Elections workspace contains elections on the level of individual jurisdictions and on the level of reporting dimensions. - [KapEStA](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/kapesta.md): The Kapitalertragsteuer-Anmeldung (KapEStA) (Capital Gains Tax Return (KapEStA)) module contains the KapEStA (Capital Gains Tax Return) workspace used to edit the return data. The structure of the workspace follows the layout of the official KapEStA (capital gains tax return) form template. - [Local Tax](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/local-business-tax.md): The trade tax return or the assessment of the tax assessment amount (or loss) is carried out in the ‘Local tax’ functional area. The forms are used uniformly by partnership companies and corporations. The forms Local tax 1 A and GewSt 1 D [Zerlegung] (Local tax 1 D [Decomposition]) are available. - [Loss Carried Forward](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/deferred-taxes/loss-carry-forward.md): The balance of tax losses carried forward and the corresponding valuation (i. e. the recoverability of deferred tax assets) are administered in the Loss carried forward workspace. Various categories of tax losses carried forward (or future tax benefits) are available for selection, depending on the tax law and legal form. - [Maintaining GAAP Reports](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/create-single-entity-tax-balance/maintain-gaap-reports.md): When transmitting the e-balance sheet, a distinction is made between two modules: - The GCD module (Global Common Data module), which specifies which master data is transmitted, such as the entity name, legal form, etc. - The GAAP module (Generally Accepted Accounting Principles module), which represents the taxonomy for the financial data, such as accounts and items of the balance sheet, income statement, etc. In Tax Balance, you can assign and adjust the data for the GAAP module that you previously imported to the taxonomy structure in the GAAP Reports workspace. - [Managing GCD Master Data](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/create-single-entity-tax-balance/gcd-master-data.md): When transmitting the e-balance sheet, a distinction is made between two areas: - GCD (Global Common Data), which specifies which master data are transmitted, such as entity name, legal form, etc. - GAAP (Generally Accepted Accounting Principles), which represents the taxonomy for the financial data, such as accounts and items of the balance sheet, income statement, etc. - [Master Data](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes.md): In the Income Taxes module, master data, transaction data, and changes to the calculation logic refer to periods (e.g. annual or quarterly closings, planning periods). All data is recorded as of a cut-off date within a defined period. - [Modules and Additional Functions in Income Taxes](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/Modules-and-additional-functions.md): In addition to the core functions provided with the base module, there are a number of optional modules and functions available in Income Taxes. The modules are an integral part of Income Taxes and open up additional areas of application. - [Notes](https://support.lucanet.cloud/en/documentation/income-taxes/tax-administration/notes.md): In the Notes workspace, you can create your own notes for all users. The created notes are displayed on the start page of Tax Administration. - [Notes on Taxonomies](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/master-data-tax-balance/create-tax-balance-sheet/notes-taxonomies.md): If the profit is determined in accordance with section 4 (1), section 5, or section 5a of the Income Tax Act, the content of the balance sheet and the profit and loss statement must be transmitted by electronic data transmission in accordance with the officially prescribed record (section 5b (1.1) of the Income Tax Act). The officially prescribed record is based on the HGB (German Commercial Code) taxonomy developed and continuously updated by XBRL Deutschland e.V. In addition to legislative changes, what are referred to as sub-legislative requirements are also taken into account in the taxonomy (e.g. the DRS - German Accounting Standards). - [Notification of Tax Arrangements](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/basic-data/Notification-of-tax-arrangements.md): In the Notifications of Tax Arrangements workspace, you can enter the reference identifiers for cross-border tax arrangements in accordance with Sections 138d and following of the German Tax Code (Abgabenordnung, AO). For this purpose, the reference identifier of the relevant arrangement must be electronically declared in the corporate income tax return, the business tax return, and the assessment return. - [OBD](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/deferred-taxes/obd.md): OBD stands for Outside Basis Differences. The OBD workspace is available in two different variants: - Simple entry of investment book values - Entry of investment book values and calculation of deferred taxes - [OECD-Standard](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/entity-data-collection/oecd-standard.md): The Pillar 2 module closely follows OECD model rules and the GloBE Information Return (GIR). Therefore, the OECD-Standard folder and its workspaces include all data points and entity-level elections required by the OECD and nothing else. - [Opening a Tax Balance Sheet](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/create-single-entity-tax-balance/open-tax-balance.md): To start entering data and configuring a tax balance sheet, you must first open the desired combination of individual company and tax balance sheet. - [Other Deferred Taxes - Company](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/deferred-taxes/other-def-taxes-ind-company.md): The Others workspace allows you to enter deferred taxes outside of the balance sheet comparison and loss carried forward. - [Overview Results](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/calculation/overview-results.md): The Overview Results workspace summarizes the results of the calculations in five tabs: Safe Harbour Applicability, Top-Up Tax Liability, GloBE Income Indicators, Adjusted Covered Taxes Indicators, and ETR Indicators. - [Performing a Mass Import](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/master-data-tax-balance/execute-mass-import.md): You can use the mass import to import accounts, grouping accounts, mappings, and adjustments for several companies and years simultaneously. - [Periods](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/periods.md): In the Income Taxes solution, master data, transaction data, and changes to the calculation logic relate to periods (annual or quarterly reports, planning periods, etc.). All data is recorded in relation to a cut-off date within a defined period. - [Pillar 2](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two.md): Pillar 2, a module from the solution Income Taxes, helps you reach global tax compliance with the GloBE rules. - [Position Mapping](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/interfaces/interfaces-mapping.md): In the Position Mapping workspace, you can define how source items you import from a source system are to be mapped to the target fields when using an interface structure of type Import. - [Report DT](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/sub-group/reports-sub-group/report-ls.md): The Report DT in the (Sub-) Group area aggregates the deferred tax balances of the subordinate or dependent companies per balance sheet position. - [Report DT Pos](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/sub-group/reports-sub-group/report-ls-pos.md): The Report DT Pos in the (Sub-) Group area aggregates the total change in deferred taxes of the subordinate or dependent companies per balance sheet position. A reconciliation of deferred taxes is performed from the prior period to the current period. - [Report Repository](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/reporting/reporting-engine/report-repository.md): To reduce the workload and keep Income Taxes accessible to users, the execution of custom reports is controlled. - [Report Tax Balance Based Profit](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/report-stb-profit.md): The development of the taxable asset differences or tax balance surplus/deficit is displayed in the Report Tax Balance Based Profit workspace. - [Report TRR](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/sub-group/reports-sub-group/report-trr.md): The report TRR in the workspace (Sub-) Group aggregates the TRR workspace at group level in the form of a summary for the company report. The report can be used as a disclosure pursuant to IAS 12.81c – the standard setter has not specified a fixed structure for the tax reconciliation. - [Report VV](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/sub-group/reports-sub-group/report-vv.md): Der Report VV im Bereich [Teil-] Konzern aggregiert die steuerlichen Verlustvorträge der untergeordneten bzw. abhängigen Einzelgesellschaften. Dabei werden die Eingaben im Arbeitsbereich Verlustvortrag auf Einzelgesellschaftsebene zugrunde gelegt. - [Reporting](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/reporting.md): In the Reporting module, evaluations can be created for the data entered and calculated in Income Taxes. - [Reporting Dimensions](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/reporting-dimensions.md): To support group reporting, reporting dimensions and associated dimension values can be created in the Reporting Dimensions workspace. - [Reporting Engine](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/reporting/reporting-engine.md): In the Reporting Engine workspace, you can compile individual reports for data analysis if you have the appropriate permissions. - [Reports in the '(Sub-)group' Area](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/sub-group/reports-sub-group.md): Four different reports are available in the (Sub-)group area: - Report DT - Report DT Pos - Report DT (LCF) - Report TRR - [Reports in the 'Company' Area](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/deferred-taxes/Reports-company-workspace.md): Four different reports are available in the Company area. This chapter describes the purpose for which the reports can be used. - [Resetting Milestones](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/status/reset-milestones.md): Milestones can be reset. It may be necessary to re-open milestones already closed if, for example, entries that have already been made need to be subsequently changed. - [Role Allocation](https://support.lucanet.cloud/en/documentation/income-taxes/tax-administration/role-allocation.md): In the workspace Role allocation, you can allocate specific, previously created roles to users in order to control their read and write access. - [Roles](https://support.lucanet.cloud/en/documentation/income-taxes/tax-administration/roles.md): The Roles workspace is used to combine permissions into a role in order to group specific permissions. - [Rollforward LCF](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/rollforward-lcf.md): The opening balances of the fiscal year are rolled forward to the closing balance for each type of loss carried forward in the Rollforward LCF workspace. - [Settings](https://support.lucanet.cloud/en/documentation/income-taxes/tax-administration/taxadmin-settings.md): In the Settings workspace, you can specify for how long data are to be stored in the change logs. - [Snapshots](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/cbc-reporting/calculation-cbcr/snapshots.md): At Country-by-Country Reporting | Calculation | Home, you can create a new snapshot, manage existing snapshots, and select a snapshot that will be presented in the other workspaces under Calculation. - [Snapshots](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/snapshots.md): Snapshots are copies of the current tax calculation, i. e. current and deferred taxes including the results. - [Snapshots](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/calculation/snapshots.md): At Pillar 2 | Calculation | Home, you can create a new snapshot, manage existing snapshots, and select a snapshot that will be presented in the other workspaces under Calculation. - [Status](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/status.md): The process in the Company area is based on a milestone concept. This systematizes the individual activities, such as determining the actual and deferred taxes. In addition, a review process and a four-eyes principle are ensured. Milestones are tracked for each company and period. - [Status (Sub-)Group](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/sub-group/milestone-status-subgroup.md): In the (Sub-)Group functional area, the data of the individual companies are aggregated. Except for the Status workspace, all other workspaces are only accessible for companies with the activated master data attribute (Sub-)Group. - [Status Monitoring](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/cbc-reporting/cockpit-cbcr/status-monitoring.md): In complex data collection processes, maintaining control over the current status is crucial for ensuring accuracy and compliance. Hence, in the CbCR module, every Constituent Entity (CE) has its own milestone to help track progress and coordinating efforts among multiple users. - [Status Monitoring](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/cockpit/status-monitoring.md): The collection of all relevant information on all constituent entities (CEs) is among the most time-consuming aspects of tax reporting and requires a high degree of coordination. However, in complex data collection processes, maintaining an overview of the current status is crucial for ensuring accuracy and compliance. Therefore, in the Pillar 2 module, every CE has its own milestone that helps tracking progress and coordinating efforts. - [Structure](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/interfaces/interfaces-structures.md): You can use interface structures to define the format of files imported into Income Taxes. This article describes how to create and configure interface structures. - [Summary](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/deferred-taxes/result-sheet.md): The summary summarizes the calculation of deferred taxes and can be used as a posting template. Both the balances and the value movements (P&L/OCI) are displayed. The current taxes are not shown in this dialog. - [Tables 1, 2, and 3](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/cbc-reporting/calculation-cbcr/tables-cbcr.md) - [Tax Administration](https://support.lucanet.cloud/en/documentation/income-taxes/tax-administration.md): The Lucanet module Tax Administration provides global master data administration for your Tax Compliance and Reporting modules. - [Tax Allocations](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/pillar-two/entity-data-collection/tax-allocations.md): The Tax Allocations workspace is used to allocate tax expenses of controlled foreign corporations (CFCs) and taxes on distributions from a source constituent entity (CE) to a target CE. - [Tax Balance](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance.md): Unser Lucanet-Modul Tax Balance bietet Ihnen die Möglichkeit, Ihre Steuerbilanz zu erstellen und fortzuschreiben sowie diese in Form der XBRL-basierten E-Bilanz gemäß § 5b EStG elektronisch an das Finanzamt zu übermitteln. - [Tax Compliance & Reporting](https://support.lucanet.cloud/en/documentation/income-taxes.md) - [Tax Liabilities](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/change-of-tax-items.md): The development of the tax items over the past years is shown in the Tax liabilities workspace. - [Tax Reports](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/reporting/tax-reports.md): In the Tax Reports workspace, numerous (predefined) evaluations can be accessed. - [TB Transfer](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/bmg-transfer.md): The "TB transfer" workspace (tax base transfer) is displayed only for intermediate tax group parents, tax group parents, and co-entrepreneurs (or shareholders of a partnership). The transferred data are disclosed separately for each company and additionally added up: - [Toolbox](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/toolbox.md): In the master data workspace Toolbox, current tax calculations can be configured for each country created in the Countries workspace. Tax calculation is carried out in the Current Taxes workspace in the Company area. - [Transfer zum Anteilseigner (Transfer to Shareholder/Partner)](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/transfer-to-shareholder.md): The user can view the aggregated data that are transferred 1:1 to the shareholders/partners in the Transfer zum Anteilseigner workspace. - [Transfer zum OT (Transfer to Tax Group Parent)](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/transfer-to-ot.md): The Transfer zum OT (Transfer to Tax Group Parent) workspace is available at the level of the tax group member. All values of the tax group member that are relevant to the taxation of the tax group parent are displayed in this workspace. - [Transmitting an E-Balance Sheet](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/transmit-the-tax-balance.md): When all required configurations and data are present, you can transmit the tax balance sheet as an e-balance sheet to the tax office. The sheet is transmitted electronically in the E-Balance workspace. - [TRR - Company](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/deferred-taxes/Tax-reconciliation-statement.md): The tax rate reconciliation (TRR) is a disclosure required under IAS 12.81 [c], which is intended to explain the relationship between the expected tax expense (EBT × statutory tax rate) and the actual tax expense as reported in the P&L. - [TRR (Sub-)Group](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/sub-group/trr.md): The TRR (Tax Rate Reconciliation) workspace at the group level is used to enter the consolidation postings. - [True-Up](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/true-up.md): In the annual financial statements, a tax calculation is made, which then serves as the starting point for preparing the tax return. In practice, the tax calculation at the time of the tax return (true-up period) will differ from the tax calculation at the time of the annual financial statements (e. g. due to better insights). - [Updating Calculation Bases and Patches](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/master-data-income-taxes/periods/update-calc-logic-patches.md): There are various use cases for updating calculation bases and patches. If you change the entries in the Calculation base or Active patches fields, the milestones for all companies in this period will be reset to in process. In addition, a data cleansing is carried out. This process can take some time. - [User Interface and General Functions](https://support.lucanet.cloud/en/documentation/income-taxes/tax-balance/user-interface-general-functions.md): Various general functions used, for example, to increase the clarity of tables or quickly switch between sections are available to you in Tax Balance. - [User Interface of Income Taxes](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/introduction-to-the-ui.md) - [Users](https://support.lucanet.cloud/en/documentation/income-taxes/tax-administration/users.md): The Users workspace allows you to grant users access to Tax Compliance & Reporting and the associated modules. - [Validation](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/eric-transfer/validation-electronic-transmission.md): In the Electronic Transmission | Validation workspace, the entries currently made in the workspaces (forms) can be validated. The entries are checked exclusively by the ERiC implemented in the Tax Transfer Hub. The original calculation data are checked. No snapshot is created. - [Validation](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/validation.md): With flexible validation, Income Taxes gives you the option to independently define and compare validation items from both Income Taxes and an external system (e. g. SAP). - [Validation (Sub-)Group](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/sub-group/validation-sub-group.md): The validation in the (sub-)group area is based on the validation of the individual company. This allows the validation process to be triggered simultaneously for multiple companies. - [Workflow Bot](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/status/workflow-bot.md): The Workflow bot is an innovative function designed to help companies improve their efficiency in financial reporting and focus on their core competencies. The Workflow bot helps you to meet compliance requirements by simplifying and automating your work steps. - [Zuwendungen (Grants)](https://support.lucanet.cloud/en/documentation/income-taxes/income-taxes/company/current-taxes/donations.md): Grants for tax-privileged purposes (e. g. donations) are entered in the Zuwendungen (Grants) workspace for the assessment of both the corporate income tax and trade tax. ## Glossary - [Glossary](https://support.lucanet.cloud/en/documentation/glossary.md) ## FAQs Frequently asked questions across Lucanet products. - [Lucanet CFO Solution Platform](https://support.lucanet.cloud/en/faqs/lucanet-cfo-solution-platform.md): Take a look at our most frequently asked questions about the Lucanet CFO Solution Platform. - [Lucanet Consolidation & Financial Planning](https://support.lucanet.cloud/en/faqs/lucanet-consolidation-financial-planning.md): Take a look at our most frequently asked questions about the Lucanet CFO Solution Platform. - [Lucanet Copilot](https://support.lucanet.cloud/en/faqs/lucanet-copilot.md): Take a look at our most frequently asked questions about the Lucanet CFO Solution Platform. - [Lucanet Disclosure Management](https://support.lucanet.cloud/en/faqs/lucanet-disclosure-management.md): Take a look at our most frequently asked questions about the Lucanet CFO Solution Platform. - [Lucanet ESG Reporting](https://support.lucanet.cloud/en/faqs/lucanet-esg-reporting.md): Take a look at our most frequently asked questions about the Lucanet CFO Solution Platform. - [Lucanet Lease Accounting](https://support.lucanet.cloud/en/faqs/lucanet-lease-accounting.md): Take a look at our most frequently asked questions about the Lucanet CFO Solution Platform. ## What's New Release notes and changelogs across Lucanet products. - [All New Features in Lucanet at a Glance](https://support.lucanet.cloud/en/whats-new/What-s-new-in-Lucanet.md) - [What's New in Consolidation & Financial Planning?](https://support.lucanet.cloud/en/whats-new/whats-new-cfp.md): Come and explore the new features and improvements of our solution Lucanet Consolidation & Financial Planning! - [What's New in Lucanet Banking and Cash Management](https://support.lucanet.cloud/en/whats-new/whats_new_bcm.md) - [What's New in Lucanet Data Collection](https://support.lucanet.cloud/en/whats-new/whats-new-data-collection.md) - [What's New in Lucanet Disclosure Management?](https://support.lucanet.cloud/en/whats-new/whats-new-discl-mgmt.md): Come and explore the new features and improvements of our solution ‘Lucanet Disclosure Management’! - [What's New in Lucanet ESG Reporting?](https://support.lucanet.cloud/en/whats-new/whats-new-esg-reporting.md): Come and explore the new features and improvements of our solution Lucanet ESG Reporting! - [What's New in Lucanet Lease Accounting](https://support.lucanet.cloud/en/whats-new/whats-new-lease-accounting.md): Come and explore the exciting features and improvements in the 'Lucanet Lease Accounting’ solution. - [What's New in Lucanet xP&A?](https://support.lucanet.cloud/en/whats-new/whats-new-xpa.md): Come and explore the new features and improvements of the 'Lucanet xP&A' solution. - [What's New in Tax Compliance & Reporting?](https://support.lucanet.cloud/en/whats-new/whats-new-tax-compliance-reporting.md) - [What's New in XBRL Tagger?](https://support.lucanet.cloud/en/whats-new/what-s-new-in-xbrl-tagger-.md): Come and explore the new features and improvements of the 'Lucanet XBRL Tagger' solution. - [What's New on the Lucanet CFO Solution Platform?](https://support.lucanet.cloud/en/whats-new/whats-new-administration.md): Come and explore the exciting features and improvements on the Lucanet CFO Solution Platform.