Strategies, outturns and monitoring reports, built to CIPFA's Codes and ready for their 2026 editions. Book your deals in our Excel deal list, or paste a few rows of figures, and a complete committee-ready draft comes back in seconds — every indicator, chart and table the Code asks for.
Saved to your PWLBtoday account as you work
The benchmark against the loans already held, and the authorised limit set from them. Shapes are illustrative; the tool draws this from your own figures.
Your Excel deal list · recommended
Your deal list is an Excel workbook that stays on your own computer: a row for every investment and loan, and your projections beside them. Point PWLBreports at it and every deal is read straight in — holdings, maturities, limits, income and charts worked out, and the report drafted round them. Book a new deal, save, re-read, and everything moves with it.
One row per deal, with drop-downs, and a mistake marked as you type. Matured deals and repaid loans stay in: they are the period’s activity.
Read in your browser and never changed. A copy of the rows it read is kept with your report, in your account.
Charts and tables in the draft, an appendix of every deal, and a deals dashboard to send on.
Every deal grouped into the rows the report needs, with weighted rates, and both maturity grids filled from the dates. Nothing typed twice.
Keep dealing in the workbook as you do now. One click reads it again, and Chrome and Edge remember where it is for next time.
Deals placed, matured, raised and repaid; investment income, the rate of return and interest payable, worked out from the dates and rates.
Every deal from start to maturity, exposure by counterparty, the maturity ladders, the year ends and the months ahead, and what each deal earns or costs.
Your loans run off loan by loan in the projections. Fill the workbook’s Projections sheet and the whole figures grid comes from it too.
An appendix of every deal held at the period end, in the draft and the Word export, and a deals dashboard as a PDF to send on.
A good tool on its own. Before the tool reads a row, the workbook gives you a dashboard of charts, what you hold on any date with its principal and rate, the liability benchmark and the Code’s charts drawn from your projections, and a check on every row as you type. It is your deal record, in Excel, kept by you.
The template comes from the tool: open a report and choose Use an Excel deal list on its first step. The walkthrough runs on an example deal list, so you can see all of this before you book a deal.
Why it exists
We read 551 treasury reports and catalogued every section heading in them: 2,779 different headings. Two in three appeared in one report and no other.
The Codes say what to cover, not how to lay it out. Every council has solved the same problem separately.
Which only works if everyone presents it the same way. Today nobody does.
How it works
Every number in it is yours. The tool translates your data as the Codes require, the same way every time, and assumes nothing.
Which authority, which report, which year. Or take the walkthrough first: a worked example, filled to the last section, with a card on every step.
Point the tool at your Excel deal list and every deal is read straight in. No deal list yet? Paste your projection straight out of Excel, a row per year, in whatever order your columns come in. The charts redraw as you type.
Every limit shown beside what published policies actually say, ready to drop into the strategy.
Every indicator, chart and table the Code asks for, wrapped in the committee papers it travels in. Export to Word.
What it is worth to an authority
Almost none of the work is writing it. It is re-keying last year's numbers, redrawing what changed, and checking every figure still agrees with every other one. That part is done before you start.
A row of figures a year goes in. Out come 25 charts, 29 tables and 8,800 words in the worked example's strategy — none typed twice.
Every figure comes from one set of inputs, checked against 20,040 assertions written from the Codes' own definitions.
65 requirements of the 2021 Codes and their guidance, tracked one by one. The tool meets 63. The other two are the council's own: its finance director's duties, and its principles for how much it can invest for longer than a year.
Every limit beside what published strategies actually do, so "is six months unusual?" has an answer.
The Code's indicators, charts and colours — not a house style, so one authority's report can be read against another's.
Your reports are saved to your PWLBtoday account as you work. Your Excel deal list stays on your own computer.
Ready to publish
Every document on a council's website has to meet the accessibility rules: the Public Sector Bodies Accessibility Regulations 2018, to WCAG 2.2 AA. Less than 25% of published treasury strategies meet them in full. A treasury report is mostly charts and tables, the hardest parts to get right by hand. One that falls short has to be listed in the council's accessibility statement, with a date for fixing it. PWLBreports builds those parts in.
Kept in your account. Your reports are saved to your PWLBtoday account as you work. Your Excel deal list stays on your own computer: the tool reads it and never changes it. The worked example is never saved. What it does not claim. It is a drafting aid, not a compliance statement. Nothing is extrapolated — every year in it is a figure you entered. Check every figure before it reaches a committee.