Reporting templates
Reports must be submitted using one or other of the standard templates available below. Please download the correct version according to your organisation's annual reporting period.
- Financial (April - March) and Calendar (January - December): Download the FY Template
- For the attention of local authorities: if you wish to include the UK Local Authority GHG Emissions dataset, 2005 - 2022 data published 27 June, as part of the Recommended section please download Table 1a which is pre-populated. Please note: the Recommended tab does not form part of mandatory reporting requirements.
- Academic (August - July or September - August): Download the AY Template
Important updates for 2024
Medical gas emission factors - We have become aware of a coding error in the reporting templates that prevents medical gas emission factors being pulled through in Table 3b. Please apply the following simple workaround:
- Select “Process” in column C, then enter the relevant medical gas, consumption and units – column H will remain blank.
- Deselect Process in column C and the corresponding EF should appear in column H.
- Amending target deadline: An updated 2024 Financial year template was posted on 1 July 2024. This update includes target completion year options out to 2044/45 (Q3d column K). If you have already started completing your report and do not wish to re-enter data in the amended version please forward the template to ccreporting@ed.ac.uk stating "Amend target deadline" in the subject line. We will aim to return asap but if submitted after mid day on a Wednesday it may not be returned until the following week. Apologies for any inconvenience.
- Pre-2010 Microsoft Excel: If you still have a pre-2010 version of Microsoft Excel installed we recommend you contact your IT department to update to a more recent version to avoid functionality issues running macros etc. If you cannot access Microsoft Excel V10 or later please contact ccreporting@ed.ac.uk.
- Boundary_info tab: Please note and complete the new Boundary_info tab. This is to enable better assessment of data coverage to help inform analysis.
- EF-List tab: As there are separate templates you no longer need to select the reporting year type in the Profile tab. We have tried to limit the list of factors to those used previously to minimise the amount of scrolling needed within the Emission Source dropdown list. The list can be viewed on the EF_List tab. Please do not edit/amend this list. If you need to add an unlisted EF please select "Other" and add relevant information across the row.
- Modifying protected cells: Please do not unlock any tabs to modify protected cells or delete table rows as this corrupts the consolidation of reports required for analysis. If you need any modifications send the template to ccreporting@ed.ac.uk.
Reporting guidance
Download the latest SSN Guidance on completing the template. Please note additional information on using the templates, including completing the new Boundary Info tab and other updates and changes are detailed in the Info box on the front page of the guidance.
Please send all reporting queries to ccreporting@ed.ac.uk. (Please attach the template if your query concerns a data entry issue/error or if you require extra rows to be added.)
Additional reporting resources are available here.