Appendix 6 - Green Purchasing Report Template (Sample).xlsx

XLSX spreadsheet 5 MB Posted

Attached to
Disposable & Compostable Food Service Products
Solicitation number
BPM055456
Issued by
Maryland

About this file

This file is a Green Purchasing Report Template sample spreadsheet designed for use by Maryland state agencies and vendors to document and track sustainable commodity and service purchases. The template facilitates quarterly reporting of expenditures across multiple product and service categories, including construction and maintenance, electronic and IT products, food service, janitorial supplies, lighting products, office supplies, paints and coatings, and landscaping supplies. Vendors and agencies are required to complete mandatory fields marked with asterisks, including invoice date, vendor name, purchasing agency, product category, manufacturer name, product number, product description, material type, product weight, unit price, quantity, unit of measurement, and extended price. The reporting period is divided into four quarters (Q1: July-September, Q2: October-December, Q3: January-March, Q4: April-June), with submission required on a quarterly basis.

The template requires comprehensive documentation of environmental attributes and third-party certifications to verify sustainable product and service claims. Vendors must provide links to certification documentation, registry references, or product catalogs to substantiate environmental claims, and must report post-consumer recycled content percentages and total recycled content information. The template includes an extensive ecolabel reference guide containing over 50 recognized environmental certifications applicable to different product categories, including ENERGY STAR, EPEAT, Green Seal, UL GREENGUARD, WaterSense, USDA BioPreferred, and Forest Stewardship Council certifications, along with hyperlinks to verification databases and registries for each certification. This reporting structure supports Maryland's green purchasing initiatives and enables agencies to track progress toward sustainability goals across their procurement activities.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

SUMMARY SHEET

Summary of Commodity Spend
Construction /MaintenanceElectronic & IT ProductsFood ServiceJanitorial SuppliesLighting ProductsOffice SuppliesPaints and CoatingsLandscaping SuppliesSUM
Vendor/Agency Total Spend ($)$ - 0
Summary of Services Spend
Construction ServicesJanitorial ServicesLandscaping ServicesIPM ServicesSUM
Vendor/Agency Total Spend ($)$ - 0
TOTALS:Reporting Period
TOTAL Spend ($) for that period

INSTRUCTIONS FOR USER

Appendix 6 - Green Purchasing Report Template (Sample)
Reporting Instructions
1. Using the Commodities and/or Services tab of this spreadsheet, enter the quarterly data by line item. Vendors/Agencies must fill the required columns marked with a * in order to be accepted as a completed report.

2. Include the relevant Ecolabels and environmental attributes with documentation to verify the sustainable product/service.

3. At the top of the Commodities/Services tab, enter the quarterly reporting period of submission: Q1: (July - September) Q2: (October - December) Q3: (January - March) Q4: (April - June)

4. Please use the reference key as guidance for filling out each column of the Commodities tab

Column NameDescription
A. Invoice Date*The date on the invoice for the purchase

B. Vendor* The company providing the product/service

C. State Agency or Entity* The agency purchasing the product/service

D. Product Category* Ex. Janitorial supplies, office supplies, lighting, electronics & IT, construction & maintenance, paints & coatings, food serviceware, landscaping supplies.

E. Name of Manufacturer* The name of the company who made the product

F. Product Number* The unique ID number found on the product/service catalog

G. Product Description* The name of the product (Ex. DELL 27 4K Monitor)

H. Material Type*The material used to manufacture the product (Ex. paper, plastic, metal, mixed materials)
I. Product Weight*The weight of the product rounded to the nearst whole number
J. Environmental CertificationsThird - party certifications that verify the environmental attributes of the product/service (See Ecolabels Tab)
K. Other Env. CertificationsOther third - party vertifications not found in the dropdown menu
L. Link to DocumentationReferences to the certifier's registry, the company's product catalog, or other forms of verified documentation
M. Post Consumer Recycled ContentThe percentage of materials recovered from the waste stream during production or after consumer use
N. Total Recycled ContentPre-consumer recycled content + post- consumer recycled content
O. Other Environmental AttributesOther attributes that provide sustainable benefits throughout the product lifecycle ( Ex. High yield/remanufactured toner cartridges)
P. Cost to State*The unit price of the product/service
Q. Number of Units*The quantity of each product by line item
R. Unit of Measurement*The basis by which the product was counted, measured, or weighed (Ex. LB, CASE, BOX)
S. Extended Price*Cost to State x Number of Units

COMMODITIES

Invoice DATE*VENDOR*State AGENCY or Entity*Product CATEGORY *Name of MANUFACTURER*Product NUMBER *Product DESCRIPTION*Material Type*Product Weight*Enviromental Certifications (Ecolabels)Other Environmental CertificationsLink to DocumentationPost - Consumer Recycled Content (%)Total Recycled Content (%)Other Environmental AttributesCost to State PRICE/ UNIT ($)*Number of UNITS (Whole #s Only)*Unit of MeasurementExtended PRICE ($)*
The date listed on the invoice for the purchaseThe company providing the product/serviceThe agency purchasing the product/serviceEx. Janitorial supplies, office supplies, lighting, electronics & IT, construction & maintenance, paints & coatings, food serviceware, landscaping supplies.The name of the company who made the productThe unique ID number found on the product/service catalogThe name of the product (Ex. DELL 27 4K Monitor)The material used to manufacture the product (Ex. paper, plastic, metal, mixed materials)The weight of the product rounded to the nearst whole numberThird - party certifications that verify the environmental attributes of the product/serviceOther third - party vertifications not found in the dropdown menuReferences to the certifier's registry, the company's product catalog, or other forms of verified documentationThe percentage of materials recovered from the waste stream during production or after consumer usePre-consumer recycled content + post- consumer recycled contentOther attributes that provide sustainable benefits throughout the product lifecycle ( Ex. High yield/remanufactured toner cartridges)The unit price of the product/serviceThe quantity of each product by line itemThe basis by which the product was counted, measured, or weighed (Ex. LB, CASE, BOX)Cost to State x Number of Units

SERVICES

Invoice DATE* VENDOR* State AGENCY or Entity* Service CATEGORY Description of Service Cost to State ($)* Enviromental Certifications (Ecolabels) Link to Documentation Other Environmental Attributes

ECOLABELS (COMMODITIES)

Construction & MaintenanceElectronics & IT ProductsFood Service WareJanitorial Services & SuppliesLandscaping Supplies & ServicesLighting ProductsOffice SupliesPaints & Coatings
Biodegradable Products InstituteERROR:#VALUE!ERROR:#VALUE!
Business and Industry Furniture Manufacturers Association LevelERROR:#VALUE!
Carpet and Rug Institute (CRI) Green Label PlusERROR:#VALUE!ERROR:#VALUE!
Cleaning Industry Management Standards (CIMS)ERROR:#VALUE!
Clear Roads Qualified Product ListERROR:#VALUE!
Compost Manufacturers AllianceERROR:#VALUE!ERROR:#VALUE!
Cradle to Cradle (Silver or Higher)ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
DesignLights ConsortiumERROR:#VALUE!
DIN CERTCOERROR:#VALUE!ERROR:#VALUE!
e-StewardsERROR:#VALUE!ERROR:#VALUE!
ENERGY STARERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
EPEAT (Silver and Gold)ERROR:#VALUE!ERROR:#VALUE!
EPA CPGERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
EPAs Design for the Environment (DfE)ERROR:#VALUE!
Fair Trade CertifiedERROR:#VALUE!ERROR:#VALUE!
Forest Stewardship CouncilERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Good Environmental Choice Australia (GECA)ERROR:#VALUE!
GreenCircleERROR:#VALUE!
GreenPro CertifiedERROR:#VALUE!
Green SealERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Green Shield CertifiedERROR:#VALUE!
Green SquaredERROR:#VALUE!
Green Wise or Green Wise GoldERROR:#VALUE!
International Dark Sky AssociationERROR:#VALUE!
International Living Future InstituteERROR:#VALUE!ERROR:#VALUE!
MAS Certified GreenERROR:#VALUE!ERROR:#VALUE!
MPI Green Performance Standard (e.g., Extreme Green, GPS-1, GPS-2)ERROR:#VALUE!
National Organic ProgramERROR:#VALUE!
NSF/ANSI 332ERROR:#VALUE!
Organics Material Review Institute (OMRI)ERROR:#VALUE!
R2ERROR:#VALUE!ERROR:#VALUE!
Rainforest AllianceERROR:#VALUE!ERROR:#VALUE!
Responsible Appliance Disposal (RAD)ERROR:#VALUE!
Safer ChoiceERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Scientific Certification Systems Indoor (SCS) Advantage Gold or FloorScoreERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
SmartWayERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
TCOERROR:#VALUE!
UL ECOLOGOERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
UL GREENGUARDERROR:#VALUE!
UL GREENGUARD GoldERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
US Composting Counsil's Seal of Testing Assurance (USCC STA)ERROR:#VALUE!
USDA BioPreferredERROR:#VALUE!
USDA PY210S Grading CertificateERROR:#VALUE!
Vincotte OK CompostERROR:#VALUE!ERROR:#VALUE!
WaterSense CertifiedERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

https://bpiworld.org/https://e-stewards.org/https://www.energystar.gov/productfinder/https://www.epeat.net/https://www.epa.gov/smm/comprehensive-procurement-guideline-cpg-programhttps://www.epa.gov/pesticide-labels/dfe-certified-disinfectantshttps://www.fairtradecertified.org/our-community/shop-fair-trade/https://connect.fsc.org/fsc-public-certificate-searchhttps://geca.eco/product-finder/https://db.greencirclecertified.com/certificatehttps://certified.greenseal.org/directoryhttps://level.bifma.org/https://greensquaredcertified.ecomedes.com/https://www.greenwisepaint.com/products/https://darksky.org/what-we-do/darksky-approved/products-companies/https://living-future.org/lbc/https://mascertifiedgreen.com/certified-products/https://www.mpi.net/APL/index.asphttps://www.nsf.org/certified-products-systemshttps://sustainableelectronics.org/find-an-r2-certified-facility/https://www.rainforest-alliance.org/find-certified/https://www.epa.gov/rad/find-rad-partner-programshttps://carpet-rug.org/testing/green-label-plus/https://www.epa.gov/saferchoice/productshttps://www.scsglobalservices.com/certified-green-products-guidehttps://www.epa.gov/smartway/smartway-partner-listhttps://tcocertified.com/product-finder/https://spot.ul.com/https://spot.ul.com/https://spot.ul.com/https://www.biopreferred.gov/BioPreferred/faces/catalog/Catalog.xhtmlhttps://www.tuv-at.be/okcert/certified-products/https://lookforwatersense.epa.gov/products/https://cims.issa.com/cims-directory/https://www.omri.org/omri-searchhttps://www.compostingcouncil.org/page/participantshttps://greenshieldcertified.org/find-a-provider/https://www.qualitypro.org/find-a-pro/https://www.ams.usda.gov/about-ams/programs-offices/national-organic-programhttps://www.clearroads.org/qualified-product-list/https://compostmanufacturingalliance.com/https://c2ccertified.org/certified-productshttps://www.designlights.org/qpl/https://www.dincertco.de/din-certco/en/main-navigation/certificates-and-registrations/the-din-certco-database/

ECOLABELS (SERVICES)

Construction & MaintenanceElectronics & IT ProductsFood Service WareJanitorial Services & SuppliesLandscaping Supplies & ServicesLighting ProductsOffice SupliesPaints & Coatings
Certified Professional HorticulturistERROR:#VALUE!
Chesapeake Bay Landscape ProfessionalERROR:#VALUE!
Cleaning Industry Management Standards (CIMS)ERROR:#VALUE!
e-StewardsERROR:#VALUE!ERROR:#VALUE!
GreenPro CertifiedERROR:#VALUE!
Green Shield CertifiedERROR:#VALUE!
ISA Certified ArboristERROR:#VALUE!
Landscape Industry Certified TechnicianERROR:#VALUE!
Maryland Department of Agriculture Pesticide Applicator CertificationERROR:#VALUE!
Maryland Licensed Tree ExpertsERROR:#VALUE!
Pesticide ApplicatorERROR:#VALUE!
Professional Fertilizer ApplicatorERROR:#VALUE!
R2ERROR:#VALUE!ERROR:#VALUE!
Responsible Appliance Disposal (RAD)ERROR:#VALUE!
SmartWayERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
WaterSense Professional CertificationERROR:#VALUE!

https://cims.issa.com/cims-directory/https://mda.maryland.gov/Pages/fertilizer.aspxhttps://greenshieldcertified.org/find-a-provider/https://www.qualitypro.org/find-a-pro/https://www.epa.gov/watersense/professional-certificationhttps://mda.maryland.gov/Pages/fertilizer.aspxhttps://mda.maryland.gov/plants-pests/Pages/licensing_and_certification.aspxhttps://www.isa-arbor.com/Credentials/Types-of-Credentials/ISA-Certified-Arboristhttps://e-stewards.org/https://sustainableelectronics.org/find-an-r2-certified-facility/https://www.epa.gov/rad/find-rad-partner-programshttps://www.epa.gov/smartway/smartway-partner-listhttps://certified.cblpro.org/https://dnrweb.dnr.state.md.us/forests/tree_expert_search.asphttps://ashs.org/page/ASHS_CPHhttps://www.landscapeprofessionals.org/LP/Membership/LP/About/Directory/Directory.aspx

File details come from the government source that posted it. Updated .