hayman.dev LTD logo
Case Study • BidPiston Carbon Reporting

Carbon reporting without the spreadsheets

A custom CRM, client portal and campaign engine that turns scattered data into buyer-ready, PPN 06/20 compliant carbon reduction reports - on autopilot.

  • Partner Project
  • Custom CRM
  • Client portal
  • 10k+ email campaigns
  • PPN 06/20 compliant

0k+

Emails per campaign

0s

Of carbon offset calculations

0

Spreadsheets left behind

0+ yr

Ongoing partner project

The Challenge

Spreadsheets don't scale. Compliance does.

Paul Smith's team was running carbon reduction reporting across multiple spreadsheets: hard to track changes, hard to guarantee accuracy, and nearly impossible to generate consistent, buyer-ready reports.

The bigger ask was the data collection itself. Clients bidding for public sector work need to submit carbon data - and that data had to flow straight into the system, validated and stored securely, with zero manual handling.

Our partner Mohunky managed the client relationship and design. We engineered everything that makes it work - the CRM, the portals, the campaign engine and the compliance calculations.

Before

description Scattered spreadsheets

  • closeManual data handling
  • closeHuman error risk
  • closeInconsistent reports
After

cloud_done One secure platform

  • checkGuided client data entry
  • checkAutomatic validation & audit history
  • checkBuyer-ready carbon reduction plans
What we engineered

A platform that runs itself, mostly

From twin admin dashboards to a scheduled email engine that pushes 10,000+ messages per campaign - here's the engineering behind the carbon reports.

dashboard

Twin dashboards

A Product Owner dashboard for clients and survey content, plus a Client Owner dashboard for employee data and survey results.

campaign

Campaign engine

GDPR-compliant list management and mass email campaigns with custom content - 10k+ mails per campaign, tracked in the moment.

schedule

Scheduled automation

Azure Functions run campaigns on timers, with SendGrid feeding back live delivery status - bounced, blocked, delivered.

fact_check

Survey template engine

Version-controlled data-set templates drive every survey, with multiple survey types and repeat call-ups for late entries.

payments

Payments built in

A custom Stripe integration manages products and orders end to end, with scope to extend as the business grows.

description

Compliance-grade reporting

Hundreds of carbon offset calculations power final report data, aligned with the UK Government's Social Value Model (PPN 06/20).

The partnership

Two teams, one platform

Mohunky owns the client relationship and the business side; we engineer everything underneath the reports.

M

Mohunky

UI, UX, Client liaison, project management and ongoing support.

H

Hayman.dev

The build - web platform, twin dashboards, email engine, payments and data.

How it works

From campaign to compliant report

Seven steps, no manual handling in between.

  1. 01

    Campaign out

    The product owner emails customer lists via the campaign manager.

  2. 02

    Account set up

    Customers get in touch and are set up with an account in the portal.

  3. 03

    Surveys sent

    The customer builds an employee list and sends the survey link to their users.

  4. 04

    Data captured

    Employees complete surveys; responses are stored securely, automatically.

  5. 05

    Live oversight

    Customers watch completion in real time and nudge non-responders with one click.

  6. 06

    Report generated

    The final report is ready once surveys complete - or the window closes.

  7. 07

    Compliant & filed

    The customer gets a polished final report - ready to paste straight into the UK Government's website.

  8. No manual handling. No missing deadlines. No spreadsheet archaeology.

The Platform

The dashboards your ops team will thank you for

A look at the admin side - campaigns, surveys and email tools that keep the whole reporting machine moving.

The BidPiston email campaigns list.
Email campaigns
The BidPiston campaign status view.
Campaign status
The BidPiston surveys list.
Surveys
A BidPiston survey form.
Survey form
The BidPiston email properties editor.
Email properties
The BidPiston email content editor.
Email content
The Reports

From raw data to buyer-ready numbers

The engine's real output - hundreds of carbon offset calculations distilled into clear, compliant totals the team can file with confidence.

The BidPiston carbon totals report.
Carbon totals

Whole-organisation footprint

The BidPiston carbon statistics report.
Carbon statistics

Breakdowns that survive scrutiny

The BidPiston work and travel carbon totals report.
Work & travel totals

Scope-specific line items

The Outcome

Faster, more consistent, far more reliable

The finished system brings the entire carbon reporting process into one secure, connected platform - from guided client data entry to buyer-ready reports. Data is validated automatically, audited for history, and exportable as CRPs aligned with government standards.

And it's an ongoing partnership - over a year in, with Mohunky managing the client and us keeping the platform current.

format_quote
“I can't express how impressed I am with the level of service and support. The team are knowledgeable and skilled at what they do - I very much see them as an extension of our own IT Department.”
PS Paul Smith Founder, BidPiston
Your data deserves better than spreadsheets

Let's build your reporting engine

A custom CRM, a client portal, automated campaigns - whatever your data problem looks like, we'll engineer the platform that solves it.

No hard sell • A real engineer on the first call