Green Bond Allocation and Impact Report Workbook – Excel XLSX

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

1. Tracks proceeds allocation by eligible category against the ICMA Green Bond Principles.
2. Computes impact metrics in the Harmonised Framework layout.
3. Reconciles unallocated proceeds and refinancing shares for the annual report.

ESG EXCEL DESCRIPTION

Green Bond Allocation and Impact Report Workbook is an Excel template (XLSX) available for immediate download upon purchase.

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.

How to work with it. Open the workbook in Excel or Google Sheets. Yellow cells are inputs, blue cells are formulas. Start with the Guide sheet, which walks through the sheets in the order they are meant to be used, then replace the example values with your own data. Every figure traces through live formulas to the inputs and to the cited source, so an auditor, lender or client can follow the working.

Use it if: You have issued green bonds under the ICMA Green Bond Principles and owe investors the annual report.

Not suited if: You need a second party opinion or verification; the issuer's own estimates go in, the report comes out.

Contents: 1 Excel workbook (.xlsx), sheets: Allocation Report, Impact Report, Project-by-project, Bonds, Projects, Estimate helper, Guide, Sources. No macros, no locked cells, no hidden sheets. Built and verified by Bindler.

Source: Best Practices in ESG, Banking Excel: Green Bond Allocation and Impact Report Workbook Excel (XLSX) Spreadsheet, Bindler