# How should we lay out a spreadsheet for BRSR environment data?

Canonical: https://senseible.earth/answers/brsr-environment-data-spreadsheet-layout

One row per bill or record, with columns for site, month, document type and number, quantity, unit, factor, factor source, result and an evidence link. Totals then come from filters, not retyping, and every BRSR figure traces back to the rows behind it.

## Columns

1. Site
2. Month (April to March)
3. Category: electricity, fuel, water, waste, production
4. Document type and number
5. Quantity
6. Unit
7. Factor and factor source with version
8. Result in t CO2e, GJ or kL
9. Evidence file name or link
10. Prepared by and checked by

## Rules

- Never type a total by hand; sum the rows.
- Lock factors in one table and look them up, so a change applies everywhere.
- Keep a change log tab when a row is corrected.

## When it outgrows Excel

Many sites or hundreds of bills a month make manual entry the weak point. Reading quantities straight from bills cuts typing errors.

## What Senseible does here

Senseible reads kWh, litres and kg from electricity bills and fuel invoices into a dated record per site, with the factor and source on every line, and prepares BRSR drafts from that data. Reports are self-declared drafts.

- [Energy intensity in BRSR](https://senseible.earth/answers/brsr-energy-intensity-calculation)
- [Restate after finding an error](https://senseible.earth/answers/restate-emissions-after-finding-an-error)
- [Unit mistakes on carbon forms](https://senseible.earth/answers/emissions-form-unit-mistakes-kg-tonnes-co2e)

Sources: [GHG Protocol Corporate Standard](https://ghgprotocol.org/corporate-standard), [SEBI, BRSR and BRSR Core circulars (sebi.gov.in)](https://www.sebi.gov.in)

Last reviewed 2026-10-23.