Skip to main content

 

Knowledge Base

Attach Report as Spreadsheet

Reports can be uploaded via spreadsheet. Select the ‘Attach Report as Spreadsheet’ tile on the home page to begin.

clipboard_e5238bfd8ed1b7f49bee8c136bf7ae7e2.png

Please note that your system contract will only reflect report types included in your legal agreement.

Contract Summary

WeRecycle Contract Type Report Type Notes
AUDIT Composition Audits Only applicable to certain PCF contracts
EOLRECD Material received by an end market Only applicable to certain PCF contracts
EOLSENT Material shipped to an end market All PCF partners must complete these reports
PROCESS Receipt of Circular Materials Ontario's proportionate share scaled-in at the Pre-conditioning Facility All PCF partners must complete these reports
PROPICKUP Pick up of Circular Materials Ontario's proportionate share by a Pre-Conditioning Facility Only applicable to certain PCF contracts
REJECTED Full or partial load that is rejected at the Pre-conditioning Facility (after it’s been scaled in due to contamination) All PCF partners must complete these reports if a load is rejected
TRANSPORTATION FEE Flat fee to be applied to a PROCESS contract Only applicable to certain PCF contracts


Select the contract you’ll be working with from the list presented. If there is only one active contract, it will automatically select that contract.

clipboard_eebc8abde664e3cc47b865c571aa1da84.png


It is recommended to download the spreadsheet each time to ensure you are using the most recent version available.

clipboard_e8ac71e4ddca4d0483958fd3b271c1d5f.png
 

The template is a macro-enabled Excel file which will open automatically.

Excel Template Maintenance

Download the template, which is an Excel macro-enabled file.

Select ‘Enable Content’ if a yellow security warning dialogue bar appears.

If you see the red security risk warning below, please follow these steps to enable the Excel workbook Macro.

clipboard_e342a9218d500a58ee583a55d0aac0eac.png

Enable Macro

Please follow these steps to enable the Excel workbook Macro.

Close the open Excel file. Locate where the file downloaded. Right click on the downloaded file and select 'Properties'.

clipboard_e6cb98353fb81d68d6e85b30f73c9f57c.png

Unblock the file by checking the 'Unblock' box and click 'Apply' and then 'OK'.

clipboard_e7be09dd62479a5fd270d19b6645c3be3.png

Re-open the unblocked file and the red warning box will no longer appear. Select the “Enable Content” ribbon at the top to proceed.

Fill in Template

Navigate to the ‘Sample Data’ tab, which contains customized data for your account. You can then copy the data and paste into the ‘Transporter_BOL_Data’ tab. The Service and Delivery dates will default to the date the template was downloaded. You will need to adjust those fields to reflect your specific report details and fill out the additional blank fields as they pertain to your reporting data.

Originating Site and Destination Name are customized for your account. Review these fields after each copy from the sample tab.

clipboard_eca595405413923ba779dd2f8ce9386d0.png
 

Field Descriptors

Mandatory Fields:

  • Contract Number: 10 Digit (470XXXXXXX) number associated with the collection type you are reporting. Will be automatically populated when the spreadsheet is downloaded from the portal.
  • Document Number: Key in your scale ticket, or bill of lading (BOL) number here. Please note that the document number is unique for each contract. You cannot submit the same document number on the same contract.
  • Service Type: The service that has been performed on the materials or report type you are submitting i.e. PROCESS, EOLSENT
  • Service Date: The date of the collection service, which must be before the delivery date. Field will be automatically populated with the date the spreadsheet was downloaded from the portal, update as needed.
  • Delivery Date: Input the date the material was dropped off at the Processing Facility/Receiving Facility Address. Must be equal to or later than the service date and cannot be a future date.
    • Field will be automatically populated with the date the spreadsheet was downloaded from the portal, update as needed.
  • Originating Site Name: The Originating Site of the reported data.
  • Originating Site Postal Code: Provide the postal code formatted as X1X 1X1
  • Destination Site: Destination Site of the reported data.
  • Destination Postal Code: Provide the postal code formatted as X1X 1X1
  • Material Description Value Added Services: Enter the type of material you are reporting, as per the material list in your contract.
  • Reporting Type: The unit of measure i.e., KGs, Compacted or Bale
  • Reporting Qty: Enter the data/weight being reported here.
  • Weight (Kg): Enter the same as Reporting Quantity for materials measured in kg. For compacted or baled materials, please manually enter their total weight in kg.

Optional Fields:

  • Reference: Optional field for any reference information.
  • Supplemental Text: Optional field for supporting information.
  • Container ID: Please leave blank.

If there are extra rows that do not contain any reporting data, please delete them.

Once your report is complete, click ‘Save Spreadsheet as .txt file’.

clipboard_e722903f6aa69861bd806f79437865d06.png

Load .txt file into Portal

Under the Report Template breadcrumb, there is a section to upload the report template. See screenshot below.

  1. Select the document to be uploaded by clicking the plus button on the right-hand side or dragging and dropping the file into the attachment section. Be sure to select the .txt version of the file.
  2. Use the ‘x’ icon to delete any unwanted documents.
  3. Click ‘Continue’ once finished.

clipboard_e7b2b8587663008cad5a235182c8f01cc.png

 

Report Submission Validation

The next screen will provide an overview of the document contents and will identify any issues with formatting.

Click on the blue hyperlink text under ‘Issues’ or click ‘Show All Messages’ to identify areas that require editing before submission. Re-open the Excel file and fix applicable fields, re-save the document in .txt format and re-upload the document.

Line items without issue that are ready for submission will have a green checkmark.

clipboard_eb021977444ce27681d58c99fd0d69c6a.png


After corrections have been made and the corrected document has been attached:

clipboard_e0b0dba82d43d1b4e5f99187205cc9ec4.png

Submit Report

Click ‘Submit Report Now’ button to submit the report. A percentage-processing bar will show the progress on submission status.

clipboard_eced9c099a8de611d25ea64e1322ba72a.png

Like manually keying in a report, a summary of the submission will be shown.

Submission Summary

  1. Report submission overview providing a report number and details of the submitted report.
  2. You can review your submission by either downloading an Excel or viewing online as a PDF.
    • The Excel file will download automatically. The PDF will open in another window and can be downloaded by clicking the ‘Download’ icon in the top right of the black bar beside the print icon.
    • Please note that the Excel summary is only available on this screen and cannot be downloaded later via the ‘View Submitted Reports’ tile.
  3. Action buttons to return to the home page or submit an alternate contract.

clipboard_e38610862b075603f79f008e9bd366dfb.png

 

 

  • Was this article helpful?