——— FREE EXCEL TEMPLATE · IFRS 18
Trial Balance to Financial Statements
A free Excel workbook that turns a two-year trial balance into the four primary financial statements under IFRS 18, with the new operating, investing and financing categories, a statement of cash flows from operating profit and 32 checks.
STANDARDS
IFRS 18 Presentation and Disclosure in Financial Statements, and IAS 7 as amended by IFRS 18
WHO IT IS FOR
Preparers of single-company IFRS accounts, auditors and students.
Map once, present correctly
Paste the pre-closing trial balance for both years and map each account to one of 70 IFRS 18 line items. Post audit adjustments and reclassifications on their own tab, and see every line before and after adjustments.
ACCESS
Free download. Excel 2010 or later; no macros.
Four statements, one set of numbers
The statement of financial position; profit or loss and OCI in the operating, investing, financing and income taxes categories with the required subtotals; changes in equity; and cash flows from operating profit, rounded to units or thousands.
Statements that agree with each other, and the checks that show it.
A complete worked example
Kilbrack Foods Ltd, a fictitious Irish food manufacturer in its first IFRS 18 year: audit adjustments, a revaluation, a new lease, a joint venture, a new loan and a share issue, completed tab by tab.
Free. The download link appears after a short checkout and is emailed to you.
——— SCOPE AND LIMITS
What it does
Maps a two-year pre-closing trial balance to 70 IFRS 18 line items, with adjustments and reclassifications
Presents the four primary statements, with operating profit and profit before financing and income taxes
Builds the statement of cash flows from operating profit: interest paid as financing, interest and dividends received as investing
Rounds to units or thousands, runs 32 checks and includes a full worked example
What it does not do
It does not make judgements: it presents the balances you enter and does not decide recognition, measurement or the category of judgemental items
It does not prepare the notes or the IFRS 18 transition disclosures, and it is not a substitute for a disclosure review
It does not consolidate groups, and it does not cover foreign operations, discontinued operations or entities whose main business is investing or financing
It does not connect to your general ledger; balances are pasted in
DISCLAIMER
Wide GAAP templates are provided free for general information and education. They support, but do not replace, professional judgement, and nothing they produce is accounting, auditing, tax or legal advice. The workbook presents the balances you enter, so check every output against IFRS Accounting Standards, your own policies and the facts before relying on it. IFRS® Accounting Standards are issued by the IASB; this template is independent and is not endorsed by the IASB. The worked example is fictitious. Wide GAAP accepts no liability for any loss arising from its use. Read the full disclaimer.