Skip to content

Consolidation worksheet

Updated:

Interim group figures per month or quarter: each entity per account, the calculated eliminations and the consolidated total.

Open Consolidation worksheet in Fiatto
In this article

Under Accounting → General ledger → Closing → Consolidation worksheet (/dashboard/grootboek/consolidatie/staat) you see the group figures up to and including a chosen period: per account each entity in its own column, the posted group entries, the calculated eliminations and the consolidated total. That gives you monthly and quarterly group figures without posting anything. This is admin work, like the consolidation.

Steps

  1. Choose the Financial year and Up to and including period and click Show. The worksheet is divided into Assets, Liabilities and equity, Income and Expenses, with a column per entity, Group entries (posted), Eliminations (calculated) and Consolidated.
  2. Check the line Difference (should be zero) and the messages above the worksheet, for example when the intercompany positions do not match or when manual year-end entries are not included in interim figures.
  3. Click an elimination amount to see the calculated entries for that account, with their debit and credit lines. Without a selection, Elimination entries lists all entries; Show all entries takes you back to that list.
  4. Under Compare with, choose Previous period or Same period last year for a comparison column with the difference.
  5. Download the worksheet with Download as Excel (the elimination entries are on a second sheet) or Download as PDF.

Tips

  • The eliminations in the worksheet are calculated and never posted; only the year-end consolidation posts. If the consolidation for the financial year has already been posted, the eliminations are in the group entries column.
  • The calculation follows the consolidation: capital elimination, result before the acquisition, minority share on the effective group interest, amortisation of goodwill and fair value uplift, and intercompany from the matrix at the reference date.
  • A dividend or unrealised inventory profit row with From period (optional) is included from that period; without a period it only counts at year-end.
  • In the PDF the entity columns are dropped when there are too many; the breakdown per entity is then in the Excel workbook.
Was this article helpful?
View all articles in this topic

Find another answer

A task, feature or short question is enough.