Green Bond Allocation and Impact Report Workbook
Annual green bond allocation and impact report to the ICMA Green Bond Principles and Harmonised Framework, computed from a bond and project register.
Choose the licence on the Gumroad page. Payment and VAT are handled by Gumroad, the merchant of record.
The Green Bond Principles require an annual report on two things: where the proceeds went, and what impact is expected. Most issuers rebuild that report from scratch every year. This workbook computes both parts from a bond register and a project register.
- Allocation Report: net proceeds outstanding, total allocated, unallocated balance, share allocated, allocation by GBP project category and by financing status, new financing versus refinancing, and two integrity checks (allocations to removed projects, allocations exceeding signed amounts).
- Impact Report in the ICMA Harmonised Framework portfolio template layout: signed and allocated amounts, allocation-weighted issuer share and lifetime, and the core indicators per category (GHG reduced or avoided, RE generation and capacity, energy savings, water savings, waste diverted), each pro-rated by the issuer's share of total project financing as the Handbook prescribes. Lifetime GHG and GHG per million allocated.
- Project-by-project table on the Handbook template, showing whole-project and issuer-share bases side by side.
- Estimate helper for GHG avoided from MWh and a cited grid factor, plus a Guide and a Sources sheet that maps every column to the Handbook note (a/ to f/) or core principle it comes from.
Built from the Green Bond Principles (June 2025) and the Handbook: Harmonised Framework for Impact Reporting (June 2024). Ten GBP project categories, up to 10 bonds and 60 projects. Live formulas, no macros, no locked cells. Excel and Google Sheets. Not a second party opinion or verification; the issuer's own ex-ante estimates go in, the report comes out.
What is inside
1 Excel workbook (.xlsx), sheets: Allocation Report, Impact Report, Project-by-project, Bonds, Projects, Estimate helper, Guide, Sources
Use it if
You have issued green bonds under the ICMA Green Bond Principles and owe investors the annual report.
Not for
You need a second party opinion or verification; the issuer's own estimates go in, the report comes out.
Sheet previews
How buying works
- Choose a licenceSingle user for one person, team for up to 10, consultancy to use with clients. The buttons above go to the Gumroad page.
- Pay on GumroadCard or PayPal; Gumroad is the merchant of record and handles VAT and the receipt.
- Download the fileThe .xlsx arrives on the receipt page and by email. It opens in Excel and Google Sheets; nothing to install.
- Use itYellow cells are inputs, blue cells are formulas, every figure names its source. Questions: reply to the receipt; every reply is read and answered, usually the same day.
Search terms this page answers: green bond impact report template icma harmonised framework excel.