🚛Uploading Transit Data

Enter your Transit related items in Brightest to keep track of transportation related activity and carbon emissions. Transit related items can represent: transportation (downstream & upstream), order shipment, delivery, employee business travel, employee commute, mobile combustion (direct operations).

To enter transit items, navigate to your Sustainability Module. Then click on the "Transit" tab to open your transit library.

Transit items can be entered using the Add Tool or the CSV file importer.

Table of Contents

Transit Item Fields

Add Tool - Entering Transit items

CSV Importer - Entering Transit items

Transit section editing options

Transit section viewing options

---

Transit Item Fields (add tool)

Fields for entering a transit item are:

Field	Required
Name	Yes	Enter the name of the transit item
Description	No	Describe the transit item
Transit type	Yes	Select one of the transit type options: transport (upstream & downstream), order shipment, delivery, employee business travel, employee commute, mobile combustion (direct operations), sold travel (use of sold products
Transportation type	Yes	Select one of the transportation types
Fuel type	No	Select the fuel type
Number of passengers or travelers	Yes	Enter the number of passengers or travelers
Split into separate trips (don't group passengers)	No	If you enter data for multiple passengers, you can "split" the transit item so that the carbon is calculated for each traveler. CSV importer: If you want Brightest to separate the trips, type "true" or "True". If you do not want Brightest to separate the trips, type "false" or "False". Note the importer is case sensitive.
Trip Class (for flights)	Yes (for flights)	For flight transit items, select the trip class e.g. economy, business, first or class
Auto-calculate emissions (Use api)	No / Yes	If you want Brightest to calculate the carbon emissions related to this transit item, click this feature "on". If you are using the csv file importer and want Brightest to auto-calculate CO2e, type "true" in the "Use api" column. If you do not want Brightest to auto-calculate CO2e, type "false".
MTCO2E	No	If you want to enter direct carbon data, ensure the feature "Auto-calculate emissions" is clicked "off" and enter your carbon data in mtCO2e.
Calculated MTCO2E	No - linked to "Auto-calculate emissions" feature	If you have the "Auto-calculate emissions" feature switched on, Brightest will show the calculated emissions in this field after the item has be save.
Hotel stay	No	If you want to enter hotel data, ensure this feature is switched "on".
Hotel stay days	No	Enter the amount of hotel stay days.
Hotel stay country	No	Enter the country where the hotel is located.
Asset	No	Transit items can be linked assets from your asset library.
Partner	No	Transit items can be linked to partners from your partner library.
Emission factor	No	You have the option to select a custom emissions factor from your emissions factor library or have Brightest use a default emissions factor.
Meta tags	No	Transit items can be linked to meta tags. Be sure to create the tag in your account settings first.
Date assigned	Yes / No	Enter the date the transit item took place. It is possible to leave this field blank; however, this is not recommended since the emissions will not be linked to your gross annual emissions. If this field is left blank, you will see an error message "Invalid date" in the transit item.
Scope category	Yes	Select the scope category 1, 2, or 3 and subcategory. See below for more information on formatting Scope and Scope Category.
Distance unit	Yes	Select the distance unit meter (m), kilometers (km) or miles. (This is required even if you use airport codes. Brightest will calculate the air distance and show this in the flight record)
Flight length (for flights)	No (for flights)	Select the flight length of your trip, short-, medium- or long-haul flight
Use address and distance autocomplete	No	Brightest can auto-calculate the distance of your transit item. If you want to use this feature, enter the complete address of the transit start and end locations.
Start location	Yes - if feature "Use address and distance autocomplete" is enabled "on"	Enter full start location if the "Use address and distance autocomplete" feature is enabled on.
End location	Yes - if feature "Use address and distance autocomplete" is enabled "on"	Enter full end location if the "Use address and distance autocomplete" feature is enabled on.
Start airport (for flights)	Yes (for flights, if using the autocomplete function)	Enter the ICAO or IATA airport code and select from the dropdown menu
End airport (for flights)	Yes (for flights, if using the autocomplete function)	Enter the ICAO or IATA airport code and select from the dropdown menu
Distance	Yes - if "Use address and distance autocomplete" is enabled "off" (and you are not using airport codes for flights)	Enter the distance of the transit item. If you entered direct carbon data, this field is still required. You can enter the value "1" as a place holder.
Round trip	No	Enable or switch on the option for "round trip" if you would like Brightest to calculate for a round trip transit item. CSV importer: If you have a round trip, type "true" or "True". If you do not have a round trip, type "false" or "False". Note the importer is case sensitive.

Scope and Scope Category Formatting for CSV Uploads

Scope and Scope Category are required fields for CSV uploads for Transit and Spend entries.

Scope and Scope Category should be formatted in your spreadsheet as:

Scope 1

• Company vehicles(Mobile Combustion) = scope_1,fuel

• Direct stationary combustion = scope_1,heating

• Direct fugitive emissions = scope_1,refrigeration

• Electricity generation emissions = scope_1,electricity

• Direct energy generation = scope_1,water

Scope 2

• Purchasing cooling and refrigeration emissions = scope_2,refrigeration

• Emissions from other purchased utility usage = scope_2,water

• Purchased electricity emissions = scope_2,electricity

• Purchased heating and steam emissions = scope_2,heating

Scope 3

• Refrigeration emissions = scope_3,refrigeration

• Emissions from other indirect utility usage and water consumption = scope_3,indirect_utility_usage

• Fuel and energy-related activities = scope_3,fuel_and_energy_related_activities

• Upstream transportation and distribution emissions = scope_3,fuel

• Emissions from other utility usage and water consumption = scope_3,water

• Waste generated in operations = scope_3,waste

• Purchased goods and services = scope_3,materials

• Employee commuting = scope_3,commuting_estimate

• Upstream capital goods = scope_3,upstream_capital_goods

• Business travel = scope_3,business_travel

• Leased upstream assets = scope_3,leased_upstream_assets

• Processing of sold products = scope_3,processing_of_sold_products

• Downstream transportation and distribution emissions = scope_3,downstream_fuel

• Use of sold products = scope_3,use_of_sold_products

• End-of-life treatment of products = scope_3,end_of_lifecycle_products

• Leased downstream assets = scope_3,leased_downstream_assets

• Franchises = scope_3,franchise

• Investments = scope_3,investments

Back to Table of Contents

---

Add Tool - Entering transit items

To enter Transit items using the Add Tool, navigate to the Transit tab of your Sustainability Module.

1. Click on the green "Add tool" at the top right corner of your Transit tab.

2. Fill out the Transit item form.

3. Once you click save, the transit item will be saved to your transit library.

Back to Table of Contents

---

CSV importer - Entering Transit items

To bulk enter multiple transit items at one time, use the csv importer. Navigate to your Transit tab in the Sustainability Module.

1. Click on the gray button "CSV Import". This will open the csv importer.

2. Download the csv file template.

3. Fill out the information in the csv file template.

4. Upload the csv file to the csv file template and follow the field mapping and data review steps.

5. Once you click "save", the transit items will be saved to your transit library.

Possible issues and troubleshooting

When you're importing data via .csv file, it's important to check that your data is clean and accurate before uploading. Because it's a .csv (comma separated value) file, make sure there aren't any extra commas in your fields that might be mistaken as a field divider.

Make sure that your data is formatted correctly and all required fields have been entered. If you receive an error message, be sure to double check your file. However, just because you see a red error message or don't receive the "Upload Successful" message, it doesn't always mean your upload wasn't successful.

Always be sure to first check the Transit data table to see if your data uploaded correctly even if you receive an error, or if for any reason you believe your data may not have been uploaded successfully. Double check whether data has been uploaded and saved to your account after you click "save" or "import" before you attempt saving again. There may be a slight delay in data upload due to internet speed or data volume.

Above all, please make sure you don't import the same data twice as this can cause duplicates.

Finally, take care to manage the size of your file. Always test an upload with a small file first, before attempting to import a larger file.

If you have any additional issues or questions, please contact Brightest support ([e-mail]) for assistance.

Back to Table of Contents

---

Transit section editing options

The transit section has a few different viewing and editing features that are described here.

Edit individual items: To edit an individual item, click on the item's white pencil symbol in the "Actions" column at the far right side. This will open the spend item form and allow you to edit the information. After clicking "save", the edits will be saved.

Bulk edit items: To edit multiple items at one time, check the box next to each item you want to edit.

Then click on the three black lines symbol in the top right menu bar. This will open the Bulk Edit Transit Data form. Select the field you would like to edit, then enter the new value and click "save".

To bulk delete items, check the box next to the items you want to delete. Then navigate to the three black lines symbol in the top right menu bar to open the Bulk Edit Transit Data form. Click on "Delete". This will permanently delete the selected transit items.

Back to Table of Contents

---

Transit section viewing options

You can view transit items by month and year as well as by a category such as meta tag, partner, asset, or scope.

Filter by month and year

To filter the spend items by month and year, select the month and year in the date range at the top left corner of the menu bar. Press enter and the view will adjust to the new date range.

To see the entire list of your spend items, click the "x" cancel symbol in the date range to delete it.

Filter view by category

Transit items can be filtered by different categories: tag, partner, asset, scope. You can select the category to filter your view and see only the items linked to that category.

To filter your transit library view, locate the menu bar at the top of your transit library. Click on the "Filter" button to select the category you would like to view. Once you select the category you would like to view, select the sub-category in the "Select" dropdown box. This will allow you for example, to view items linked to specific tags, assets, partners, or scope categories.

Note, it is possible to filter with multiple categories at once.

Back to Table of Contents

---