IAS 29 hyperinflation restatement template
An Excel template that restates the financial statements of an entity in a hyperinflationary economy into the measuring unit current at the reporting date, then translates them into a stable presentation currency. It restates non-monetary items by their dates of origin, income and expenses by index, derives the gain or loss on the net monetary position and checks it against an independent month-by-month estimate. It comes with a fully worked example for a fictitious Argentine subsidiary of an Irish group.
What it does
Takes the month-end general price index for 24 months and works out the conversion factors, the average factor for the year, inflation for the current and previous year and cumulative three-year inflation, alongside the IAS 29.3 indicators.
Restates property, plant and equipment by acquisition (or revaluation) date, closing inventories by month of purchase, and other non-monetary items and share capital by date of origin (IAS 29.15–25), capping restated amounts at recoverable amount and net realisable value (29.19).
Builds the restated statement of financial position, with monetary items unchanged (29.12), deferred tax on the restatement (29.32, IFRIC 7) and retained earnings as the balancing figure.
Restates profit or loss – revenue and expenses by the average index, cost of sales from the restated inventories and depreciation from the restated assets – and derives the gain or loss on the net monetary position from the change in restated retained earnings (29.26–28).
Checks the monetary gain or loss against an independent estimate from the month-end net monetary position, within a tolerance you set.
Translates all amounts at the closing rate (IAS 21.42), reconciles net assets in the presentation currency, splitting the restatement and translation effects (IFRIC agenda decision, March 2020), and drafts the note (29.39) with a 14-point checklist and 19 automatic checks.
What it does not do
It does not restate opening balances in the first year of application (IAS 29.4) or cover the current cost approach, interim periods or the cessation of hyperinflation (29.38).
Disposals of property, plant and equipment in the year are not modelled.
What you get
One Excel workbook (.xlsx) with Instructions, the blank template and a worked example: Pampa Herramientas S.A., with a factory, machinery and vehicles acquired across seven years, an addition in the year, inventory layers, borrowings, dividends and translation into euro. The price index in the example is fictitious.
Clearly marked input cells, protected formulas and built-in checks, with a status line on every tab.
Works in Microsoft Excel 2010 or later (Windows or Mac). No macros.
Scope
IAS 29 Financial Reporting in Hyperinflationary Economies, IFRIC 7 and IAS 21.42–43 as issued by the IASB at October 2026, historical cost approach, for one entity translated into one non-hyperinflationary presentation currency. The full scope and limitations are set out in the Instructions tab.
Translating other foreign operations? Use the IAS 21 foreign exchange template. Bringing the subsidiary into the group? See the free Consolidation template.
Designed for finance teams, auditors and advisers preparing or reviewing IFRS financial statements. It is a working aid: it does not replace the Standards or professional judgement, and its scope and limitations are set out in the Instructions tab. The worked example is fictitious.



