Importing Your Fuel Reports

This article provides a step-by-step guide on how to import your fuel reports into BigChange. This process is crucial for maintaining accurate and up-to-date records of your fleet's fuel transactions.

Downloading Fuel Report Template

You can download a copy of the fuel import template by:

• Navigating to [Top menu] Account settings > Settings > [Side menu] FORMS > Imports.
• Scroll down to find the Fuel Trasactions template.
• Import Hub in BigChange

Preparing Your Data for Import

To import your fuel report database into BigChange, you first need to prepare your data. This involves:

• Copying your database: It's important to make a copy of your database as you may need to amend the data for a successful import into BigChange. You may also need the original data for internal usage.

• Ensuring uniform data presentation: All data should be presented uniformly. For example, Vehicle Registration Numbers should all appear in the format 'YB54 DFG' rather than 'YB54DFG'. The available headings in BigChange are:

The template will look like this:

Importing Your Data into BigChange

Once your data is prepared, you can import it into BigChange. Follow these steps:

• Navigate to Fleet & Resources → Fleet → Import fuel transactions.

• Click on the 'Import fuel transactions' icon to open the 'Import fuel transactions' popup.

• Download the relevant file and amend the headings using the BigChange categories.

• Click the 'Import' icon. An informational popup will open confirming that the import is taking place.

• You will receive an email confirming that the data has been imported successfully. If there are any errors, the email will specify the row with the error. You will then need to review and correct the data for import.

The outlined area shows that all rows have been imported without errors.  If errors are shown on one specific row it will display as, for example:

 You would then need to review Line 3 of the data and correct it for import. 

Vehicle Consumption and Emission Report

To view the Consumption and Emissions report navigate to [Top menu] Analytics & Reporting > Vehicles Section.

Conclusion

Importing your fuel report database into BigChange is a straightforward process that involves preparing your data for import and then importing it into the system. Following these steps will ensure that your fleet's fuel transactions are accurately recorded and up-to-date.