/periodandyear/help/group-consolidation/get-started/periodic-consolidation section 2026-05-06T10:20:04+02:00 # Periodic consolidation ## Creating a client with periodic consolidation Periodic consolidation is only available if you register the add-on module **Periodic group consolidation**, and this must be done before the relevant fiscal year is started. Once the client is created and periodic consolidation has been added to the client, click on the client to access the **Home page**. Select **Create fiscal year** and enter the fiscal year along with the desired period length, as shown in the example below:  The following period lengths are available: - Monthly - 2-monthly - Quarterly - 4-monthly / tertial - Half-yearly - Yearly (year-end period only) >[!IMPORTANT] >It is not possible to change the period length for a fiscal year that has already been started. The entire fiscal year must have the same period length. If the period length is set incorrectly, the fiscal year must be reset (deleted) and recreated. Select **Start period** to open the relevant period. The procedure for creating the group structure follows the same process as for clients with a standard fiscal year. Annual accounts with notes are available in the year-end period. ## Balance figures for periodic consolidation Balance figures for the current period function in the same way as in the year-end period. Reporting with report columns for the parent company is only available in the year-end period. Balance figures for previous periods in the fiscal year and balance figures for previous fiscal years are available for consolidated figures. The balance figures stored for previous periods and the current period are always **accumulated year-to-date** figures, so that period figures in the income statement are calculated as the difference between the balance figures in the current period and the balance figures at the end of the preceding period in the fiscal year. Under **Trial Balance**, you can import balance figures for previous periods in the current fiscal year and for previous fiscal years. Prior-year figures in a fiscal year will have the same periods as the periods in the current fiscal year. If periods are added between fiscal years, those periods will have zero values in the prior-year period. Please be aware of this when generating reports. When importing, the import occurs as accumulated year-to-date figures for each group account in the group chart of accounts. Accounts in the import file that do not already exist in the group chart of accounts will be created automatically. If the period length changes from one year to the next, comparative figures will only be shown for the periods that also existed in the preceding fiscal year. When changing from monthly to 2-monthly, all periods in the year will have comparative figures. When changing from 2-monthly to monthly reporting, comparative figures will only be available for periods 2, 4, 6, etc. from the preceding year. When selecting import of previous periods, an import template will be displayed that can be used for import or as guidance on how an import file must be structured. Pay close attention to the column headers. The date for the last day of an accounting period in the column header, e.g. *30.09.2027*, identifies the figures as year-to-date on that date, in this example as year-to-date as of 30.09.2027. This also applies to short-period accounts with deviating fiscal years. ## Eliminations Eliminations are carried forward between periods. **Manual eliminations** have the following options for carry-forward: - Not carried forward to the next period - Carried forward to the next period without amounts - Carried forward to the next period with amounts **Automatic eliminations** have the following options for carry-forward: - Not carried forward to the next period - Carried forward to the next period **Eliminations for acquisitions and excess values** are always carried forward to the new period. When carrying forward from one period to the next within the same fiscal year, the elimination is carried forward as-is, with the exception that depreciation is calculated in twelfths based on the acquisition date of the purchase (before or within the fiscal year) and the number of months in the accounting period. When carrying forward to a new year, accumulated values at the start of the fiscal year will be updated. If an elimination for acquisitions and excess values expires, the elimination must be deleted in the first period in which it expires. **Elimination of income statement effects** is performed in the same way as for the year-end accounts so that the balance sheet balances and the appropriation of profit agrees with the net income after tax. It is possible to hide appropriations in the income statement by going to the **Report Lines** menu and selecting this under settings for the accounts. ## Closing and reopening periods When a period is opened for the first time, data such as group structure, eliminations, balance figures, and prior-year balance figures will be carried forward to the new period. If you choose to pause an opened period and go back to make changes in a previous period, data from the previous period will not be updated in a later period, and changes that you wish to carry forward to later periods must therefore be made in the period(s) that have been paused. The same applies if you make changes in previous fiscal years. ## Group overview, periodic with export to Excel This function provides access to consolidated figures for all periods in the fiscal year as well as the two preceding fiscal years. It is possible to export the overview to Excel. The function can be expanded to show figures at the group account level. It is also possible to select account-specific export to Excel. ## Financial statement structure The financial statement structure is available and can be edited under the Report Lines menu item. This editing also affects the annual accounts. Editing the financial statement structure has the same functions as the financial statement structure in the annual accounts. If it is desirable to have a different financial statement structure in the annual accounts and in the periodic accounts, it is recommended to have two separate clients available for this purpose. To distinguish clients from each other when they have the same name and the same client type, it is recommended to have a group for periodic accounts in which you place the periodic client so that the client overview shows the difference between the clients. ## Reports for periodic reporting The following reports can be generated for periodically consolidated figures (YTD is an abbreviation for "year-to-date", and PYTD is an abbreviation for "prior year-to-date"): - Income statement period / YTD - Income statement YTD / PYTD - Income statement YTD / full prior year - Income statement YTD / YTD previous period - Balance sheet this period / same period prior year - Balance sheet this period / prior year-end - Balance sheet this period / previous period The reports have the following default properties: - Figures are per report line - Two periods are displayed - A percentage column is displayed - Percentage figures in the income statement are relative to total operating revenue The reports have the following options: - Account-specific report - Three periods - With or without percentage column - Percentage figures in the income statement relative to total sales revenue /periodandyear/help/group-consolidation/get-started/periodic-consolidation/import-finale-consolidation page 2026-05-06T10:20:04+02:00 # Exporting data from Finale konsolidering If you have previously consolidated figures in Finale Konsolidering, these can be exported and imported into Period & Year group consolidation. The export creates an Excel file with accumulated year-to-date figures for each group account, broken down by months in the fiscal year. The import file has the following structure: **Rows:** - Row 1 with period information - Then one row for each account in the group chart of accounts that has a balance in one of the columns **Columns:** - Column 1 with account number - Column 2 with account name - Then one column for each month in the fiscal year ## Exporting from Finale Konsolidering Open the desired client in Finale Konsolidering and follow the steps below. ### Step 1: Select custom columns Select the menu ***Account - View custom columns***.  ### Step 2: Select column layout Select the column layout ***YTD 12 periods per year*** in the column layout dropdown. The figures will then show consolidated balances for each month in the fiscal year.  ### Step 3: Verify fiscal year Verify that the correct fiscal year is displayed in the column headers.  If the column header shows the wrong fiscal year, click on the period selector to change it:  ### Step 4: Export the file Click the export toolbar button and select as shown below:  ### Step 5: Save in new Excel format The file is saved in the legacy Excel format (*.XLS). Open the file in Excel and save it in the new format (*.XLSX). >[!NOTE] >If the file opens in "Protected View", click the warning and then click **File Block Settings**. Change the settings for legacy file types to allow editing. > > > > > > ## Importing into Period & Year Import of trial balance figures is done under ***Trial Balance*** where you select the correct fiscal year. The export file contains year-to-date data and works regardless of period length, both in Period & Year and in Finale Konsolidering. If you have quarterly period length, the file will contain figures for months 3, 6, 9, and 12. ## Adapting the import file for deviating fiscal years The column headers in the import file identify each period. For example, **U 01:05 2025** means the column contains year-to-date figures from month 1 through month 5 in fiscal year 2025. If you have a deviating fiscal year, you need to replace the column headers with the last day of each period. For a fiscal year starting 01.07.: - **U 01:01 2025** is replaced with **01.07.2024** - **U 01:12 2025** is replaced with **30.06.2025** When the last day of a period is specified in the header, it is interpreted as year-to-date on that date.