Import Fuel Data from Excel
Overview
Gearbox supports the import of fuel data manually. The preferred format for importing fuel data is an .xlsx file, commonly used with Excel. Additionally, .csv files are also supported.
Setting up Fuel Suppliers
We recommend setting up your fuel suppliers within Repairers section of Gearbox.
Importing Fuel Data
1. On the left-hand side of the screen, select Fuel (1)
2. Select the Import button (2)
If your fuel file is not in the correct format as demonstrated on the page, please download the XLSX template provided. Copy your fuel data into this template and then attempt uploading again. If the imported data does not match the template, no fuel data will be imported.
You may have multiple supplier entries that are best suited to be consolidated into a single supplier. For instance, entries such as BP Campbelltown, BP Gosford, and BP Luddenham could be better entered under 'BP' only. This is because only data with a matching supplier will be imported into Gearbox.
Importing via CSV
3. Download the XLSX Template (3) and input any required data.
Note: You can leave the supplier field blank in the Fuel Import Template and use the Nominate Supplier function if all fuel data entries are from the same supplier.
4. Click the blue Select File to Import button (4) and choose your fuel file from your local device. If required, nominate a supplier (5), then click the green Import button (6). You will receive a pop-up notification indicating that the file has been received and is being imported
Importing via Email
1. Additionally, CSV files can be imported via Email. To do this, use the Gearbox email address (7) provided for importing files. Upon completion of the import process, Gearbox will send you an email to confirm whether it was successful or not.
Related Articles
Exporting data
Overview Gearbox allows you to import and export data, this is useful when uploading bulk data such as drivers, vehicles etc. It is also used to export reports for additional columns and the ability to filter results within Microsoft Excel. (Reports ...Exporting Data from Gearbox Tables
Overview Gearbox offers the capability to export data into an Excel spreadsheet, providing additional columns and the ability to filter results. Additionally, you have the option to print your data based on the current viewable columns. In the ...Fuel Economy by Month report
Purpose The purpose of this report is to display the average fuel economy by month, based on the 'End Date' of the selected date period. This knowledge base article aims to provide clarification on the report's intricacies. Report Logic To calculate ...Importing Odometer Records to Gearbox
Overview Gearbox offers users the flexibility to import records seamlessly by utilising CSV or Excel files. This feature simplifies data management processes, allowing for efficient integration of external records into the Gearbox system. ...Fuel Credit Report
Overview Gearbox offers a Fuel Credit Report designed to track Fuel Tax Credits, covering On-Road, Off-Road, and Auxiliary Fuel Credit categories. This report is regularly updated in accordance with the ATO's Fuel Tax Credits regulations. Before ...