Excel workbook
IFRS Toolbox
The Excel tool for group consolidation under IFRS for professionals: a fully calculated teaching and control model of a fictitious model group (MK01_R3). It complements the IFRS books from Serious Numbers.
Excel workbook · single-user licence · price · €29.00 (final price)
Version 3.2 (as at 19 November 2026) · 19 sheets, English, no macros. For professionals who want to recalculate, review and adapt consolidation steps themselves.
Excel for Windows
One-off payment, not a subscription. Available for download immediately after payment.
Sold worldwide, except to the United Kingdom and to the Isle of Man, Guernsey and Jersey.
Stripe will send the payment receipt; it is not an invoice. You will receive your invoice separately by email.
The download link is valid for 30 days and is limited to 30 retrievals; in the case of the bundle this applies to both files together.
This English version is for information only; the German version is legally binding.
What you get
Year 01 of the model group MK01_R3 fully calculated: 28 posting references, 87 journal lines, consolidation, consolidated financial statements (statement of financial position, statement of profit or loss, statement of cash flows) and controls.
Year 02 only as selected subsequent effects: twelve current-period references with 24 journal lines. This is not a complete set of financial statements for Year 02.
Supplementary cases, a subgroup example and an IAS 36 impairment loss as a marked teaching variant (first against goodwill).
A guide and a licence sheet in the file (the sheet names “Anleitung” and “Lizenz” remain in German). All data are fictitious; they do not come from a real company.
What is not included
No complete two-year set of financial statements and no opening carry-forward after Year 02.
No complete impairment test (further residual IAS 36 impairment losses are not included).
No general consolidation software, no data import from accounting systems and no complete set of IFRS notes.
The earlier single-module files are not part of the purchase.
Licence
Single-user licence: a simple, non-exclusive, non-transferable right of use, unlimited in time, for one person. Professional use is permitted. The licence applies to the language version purchased. Passing on, sale and use by additional persons, for example in a team, in training courses or in an association, are not permitted without a separate agreement. I will offer licences for training courses and associations separately in future; please feel free to enquire by email. Further details are set out in the GTC.
Support and notes
The Toolbox is an Excel tool for professionals and a teaching and control model. It is not a substitute for an audit of financial statements, nor for tax or legal advice. Please check the results yourself before any use.
You need Microsoft Excel for Windows (Desktop). The file is an .xlsx file with no macros and no external links. All sheets are protected against accidental changes without a password; you can edit the input cells. I do not warrant usability for Excel for Mac, Excel in the browser, Excel 2010 or other spreadsheet programmes.
Please send questions and error reports to seriousnumbers1971@gmail.com. I will correct errors in the file free of charge for 12 months from purchase. This is a voluntary commitment; your statutory warranty rights remain unaffected.
Consumers have a 14-day right of withdrawal. It expires prematurely if, during the payment process, you expressly agree that provision may begin immediately and you confirm that you are aware you will lose your right of withdrawal. Details are set out in the instructions on withdrawal.
The Toolbox is also available together with a PDF book in the bundle. Go to the bundle
The legal texts apply in the German version.