Skip to main content
WeRecycle Resources

Submit a GHG Report via Spreadsheet (MMSW)

GHG Reporting Frequency

Collectors are required to report on GHG emissions associated with their operations for the prior full calendar year. For example, GHG reporting due by January 31 will include emissions data from January 1 to December 31 of the previous year. 

There are two ways you can choose to submit a GHG report on the Portal.

  1. Key in your report
  2. Upload report as an Excel spreadsheet

Please navigate to 'Submit a GHG Report via Key Entry (MMSW)' article if you are not submitting your report via spreadsheet.

Attach Report as Spreadsheet 

Select the ‘Attach Report as Spreadsheet’ tile on the home page and then select the contract type applicable to the GHG emissions you are reporting.

clipboard_e08ace541ec42c0d631bdd091d515682e.png

clipboard_ec8cd0e2fb92781cd20d4ecf5b9c3a2e1.png

 

Select ‘Download’ and save the template to your PC. The template must be downloaded separately for each contract type since they will display different originating sites and materials.

It’s best practice to download the template each time you report to ensure that you have the most up to date version.

 

clipboard_e1359856020ee5e9581a57733abc0edc8.png

 

Open Excel Spreadsheet 

The file may have opened automatically, if not, open the downloaded file. Please note:

  • The Excel file includes a simple macro
  • Clicking ‘Save Spreadsheet as TXT file’ will run the macro, creating a .txt file with your report information. This is the format you’ll upload into the portal.
  • If the ‘Enable Content’ appears, click to accept until there is no yellow bar remaining.

 

clipboard_e7d6c3c81269cc62824e559ba0b8515b1.png

 

Using the Template 

There are various sheets available in the Excel workbook:

  • Transporter_BOL_Data
    • This is where you’ll enter the data you are submitting.
  • Sample Data
    • Shows the format that the data needs to be entered in. The line items needed can be copy/pasted into the Transporter_BOL_Data tab.
  • Instructions
    • Provides an easily accessible overview of the template fields.
  • Originating Sites
    • Full list of all contract specific Originating Sites, easily transferable onto Transporter_BOL_Data tab

 

Transporter_BOL_Data Tab Field Overview:
  1. *Contract Number is the number associated with your collection type (Curbside, Multi-Family, Depot, Post-Collection, etc.).
  2. *Document Number: Each report submitted must be given a unique identifier, up to 12 characters, which can include letters and numbers. This field is for your reference only.
  3. *Service Type will always be GHG.
  4. Reference & Comments (optional): Consider providing a document reference up to 12 characters. Consider providing a note for your report, up to 30 characters long.
  5. *Reporting Period Start & End: Indicate the start and end dates for report being submitted.
  6. *Originating Site Name is the name of the site you’re reporting for. Reference the sheet Originating Sites for exact formatting.
  7. Columns J, K & N (Not Applicable) are not required for GHG purposes.
  8. *Emission Type is a descriptor of what you are reporting. Please copy/paste from the Sample Data tab to ensure formatting accuracy.
  9. *Type of measurement will always be Percentage.
  10. *Percent attributed to MMSW should have all values as whole numbers.
  11. *Quantity - Quantity of emissions (calculated % for that unit of measure) for the applicable material.
    e.g. Total fuel usage is 1000 L. 80% of which is attributed to MMSW operations.
    % Attributed to MMSW = 80                 Quantity = 800

Only include the material lines you need to report and remove any additional lines.

The information in the Sample Data tab is for format reference only (reporting period start/end, originating site name, originating site postal code). Please see example below, the red arrows denote modified fields.

 

clipboard_e07aa396caf36c5212ee6962f17df53df.png

clipboard_e0ad65ffe337ea6dab51783196366d9a7.png

 

Once data entry is complete, click “Save Spreadsheet as TXT file” and change the name if desired.

Upload .txt File 

You can drag and drop the .txt file into the ‘No files found’ area or click the ‘+’ sign to search for the file and attach it.

clipboard_e8be9a7967217129ac24e83a35ca4d384.png

Once file is uploaded, click ‘Continue’. If the file needs to be removed and re-added, select the ‘x’ icon.

clipboard_e31551f5afa9db35b5f42a4c2db0b4688.png

File Upload Review

When a file is uploaded, a summary of information will be presented.

An ‘x’ indicates an issue with the applicable for within the .txt file. You can click on ‘Show All Messages’ to review all issues on all rows, or you can click on the blue hyperlink issue under ‘Issues’ to go line by line.

Review the issues outlined and correct the Excel file where necessary, saving a new .txt file version afterwards. Please contact MMSW if you require assistance.

clipboard_ec080eae6715057fb8cf63f6cdc72eb56.png

clipboard_efdde11b42cda2df5e0840fd6b41a67bd.png

Green check marks indicate an error free submission. Review information for completeness and click ‘Submit Report Now’.

clipboard_ee533da28e51af52e5800a7096d3efee4.png

You’ll see a Processing Submission dialogue box. Processing time will depend on the number of line items included in the report.

clipboard_e117bef8f768d198cf39dc24f5a12ff40.png

Confirm and Download PDF/Excel Summaries 

Your GHG report has been successfully uploaded! A summary of the report will appear on the screen, along with a unique 1800- Report Number. If you have any questions or concerns regarding your submitted report, this is the reference you’ll provide.

You can download the report in PDF or Excel form for your records.

clipboard_eff012f4d60ff0549153d044e829fd49b.png

  • Was this article helpful?