Prior-period error restatement template
An Excel template that corrects material prior-period errors retrospectively under IAS 8, from last year's published figures to the restated comparatives. It logs up to ten errors as balanced correcting entries, adds the tax effect and produces the restated statements, the IAS 8.49 note and the opening journal.
What it does
Captures the comparative statements as previously reported – the statement of financial position at both dates, profit or loss and retained earnings – with balance and roll-forward checks
Logs up to ten errors as double-entry corrections, split between earlier periods (opening balances) and the comparative year, using drop-downs keyed to a condensed chart of line items – each error takes up to two lines per period; use further error numbers for corrections with more lines
Applies the tax effect at your rate and posts it to current or deferred tax, error by error
Restates the comparative profit or loss, the year-end statement of financial position and the third statement of financial position at the start of the earliest period, with as reported / adjustment / restated columns
Reconciles restated retained earnings for the statement of changes in equity and restates basic EPS when shares are entered
Drafts the IAS 8.49 disclosure: nature of each error, line-by-line impact table, opening equity adjustment and impracticability wording
Gives the journal that corrects the opening balances in the current year's books, plus 15 checks (including that each error was found after last year's statements were authorised) and a fully worked example
What you get
One Excel workbook (.xlsx) with an Instructions tab, the blank template and a worked example for a fictitious wholesale distributor correcting an inventory overstatement, an unaccrued licence fee and missed depreciation, with the tax effects.
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
One comparative year, one tax rate and a condensed chart of line items. Changes in accounting policy, other comprehensive income, cash flow statement restatement, diluted EPS calculations and group or non-controlling interest effects are outside scope. For entities applying full IFRS Accounting Standards; not for the IFRS for SMEs Standard or FRS 102.
Designed for smaller entities applying full IFRS Accounting Standards. 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.
