top of page
Government grants template (IAS 20): a grant award letter with an approval stamp

Government grants template

€50.00Price

An Excel register of a small company's government grants under IAS 20, with the release of each grant to profit or loss for the current and comparative year. It produces the deferred income roll-forward, journals, IAS 20.39 disclosure figures and draft note wording, with a worked example for a fictitious Irish manufacturer.

 

What it does

  • Recognises only the grants you mark as having reasonable assurance, and lists the grants not yet recognised for the notes

  • Releases asset-related grants in proportion to depreciation and income-related grants over the period of the related costs; grants for past costs are recognised immediately

  • Works out the benefit of a below-market government loan (proceeds less fair value – entered, or calculated for a loan with annual interest repaid at maturity) and treats it as a grant

  • Accounts for repayments under IAS 20.32, including the catch-up charge on asset-related grants

  • Gives the deferred income roll-forward, the current/non-current split and the effect of deducting grants from the asset

  • Applies your choice of presentation for asset-related and income-related grants, with balanced journals for the year

  • Gives IAS 20.39 figures, draft wording for the policy, nature and extent and conditions, and 12 automatic checks

 

What you get

  • One Excel workbook (.xlsx) with an Instructions tab, the blank template and a worked example for a fictitious Irish manufacturer with a capital grant, an employment grant, a training grant, a below-market government loan, a partial repayment and a grant not yet recognised.

  • 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

For entities applying full IFRS Accounting Standards; not for the IFRS for SMEs Standard or FRS 102. Non-monetary grants, forgivable loans, grants in business combinations, IAS 41 agricultural grants, deferred tax on grants and the later IFRS 9 interest accounting for below-market loans are outside scope. Allows one repayment per grant and assumes straight-line depreciation.

 

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.

    bottom of page