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. Also sold on Flevy ($39, single user, same file). Also on Eloquens (ELQ-17182-1, same file).
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.
Who you are buying from
Bindler is the trading name of Neil Sangwaiya, one person in Dubai. There is no company behind that name, no sales team and no reviews, and this page is not going to pretend otherwise. What there is instead is a record. Gumroad takes the payment and is the merchant of record, so your card details never reach Bindler. Where a figure could not be verified the cell is left blank rather than filled. When something was found wrong it was written down and dated in the change log with the old figure named. And there is a 30-day money back guarantee, no reason needed, handled by Gumroad.
What you actually download
One spreadsheet file. No macros and no VBA, because the .xlsx format cannot carry them. No locked cells and no hidden sheets. If your IT will not let you open a spreadsheet from outside, upload it to Google Sheets and it opens there. And yes, an AI built it: that is exactly why every figure is recalculated against a replica worked out by hand first, rather than trusted.
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.
Advisers and accountants who recommend these workbooks to clients can earn 30% of each sale as a Gumroad affiliate: sign up on the store, no approval wait.
Search terms this page answers: green bond impact report template icma harmonised framework excel.