Template · Finance close · Opening soon
Financial consolidation template
Bring every entity's balances into one table in your group currency, account by account, refreshed whenever an entity's books update.
You bring
Entity balances15 rows
EntityAccountAmount
Mammoth does the work
You get
One table15 rows
Every entity's balances in one currency, by account.
AccountEntityCurrencyLocal amountRateGroup amount
- Not a spreadsheet to fill inIt is a ready-made workflow in Mammoth. You bring the files, and it does the work.
- Your files, as they areUpload a file or connect a source. Your column names do not have to match.
- Runs again by itselfWhen new data arrives, every step runs again and the result updates.
What you get back
The real result of this template, run on sample data.
Multi-entity consolidation: the resultSample data15 rows
| Account | Entity | Currency | Local amount | Rate | Group amount |
|---|---|---|---|---|---|
| 1000 Cash | France SAS | EUR | 239,694.81 | 0.9 | 206,137.54 |
| 1000 Cash | UK Ltd | GBP | 161,111.08 | 1 | 161,111.08 |
| 1000 Cash | US Inc | USD | 37,704.16 | 0.8 | 29,786.29 |
| 1200 Receivables | France SAS | EUR | -39,905.15 | 0.9 | -34,318.43 |
| 1200 Receivables | UK Ltd | GBP | 132,690.73 | 1 | 132,690.73 |
| 1200 Receivables | US Inc | USD | -32,309.43 | 0.8 | -25,524.45 |
| 2100 Payables | France SAS | EUR | 103,838.15 | 0.9 | 89,300.81 |
| 2100 Payables | UK Ltd | GBP | 134,713.14 | 1 | 134,713.14 |
What is financial consolidation?
Financial consolidation combines the accounts of a parent and its subsidiaries into one set of group figures, converting currencies and lining up the chart of accounts.
How it works
How to use the multi-entity consolidation template
- 1Bring your dataConnect a source, or upload a file.
- 2Check the columnsMammoth matches each column the template needs and asks only when it is unsure.
- 3Choose where it goesA table, a sheet, or a dashboard. It rebuilds on every refresh.
See the exact columns and steps ›
What it needs
Balances from several entities: entity, account, amount (and currency)
Entity balances
- Entity
- Account
- Amount
- Currency(optional)
The steps it runs
- 1Match columns
- 2Convert to the group currency
Every step is an ordinary Mammoth step you can open and change.
Multi-entity consolidation: questions
Does it update by itself?
Yes. The template becomes an ordinary workflow in Mammoth. When your data refreshes, from a connector, a scheduled pull or a new file, every step runs again and the result table updates.
Can I change the steps?
Every step is an ordinary Mammoth step you can open and edit. Mammoth remembers which steps came from the template, so an update never overwrites your changes.
Do my column names have to match?
No. You point the template at your columns once. Mammoth suggests a match for each one and asks only when it is unsure.
Get early access to this template
Bring your data, check the columns, and the result rebuilds on every refresh.
More finance close templates
Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.
- Vendor spend analysisEach supplier's spend over the last 12 months, its share, and the change on the 12 beforeSee the template
- Flux analysisEvery account's last month against the month before, with moves over your limits flaggedSee the template
- Budget vs actualBudget, actual and variance for every account and monthSee the template
- Price-volume-mix analysisThe change in revenue for each product, split into price, volume and mixSee the template
- Trial balanceEvery account's debit or credit balance at the period endSee the template
- Sales commissionEach rep's sales and commission by month, with an accelerator above quotaSee the template