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 in Gearbox are available in PDF and XLSX format)

Each section of Gearbox has a Reports button located at the right-hand side of the menu to access all related reports

Exporting Data - Reports

Capturing all Data

Throughout Gearbox, assets and their associated records exist with multiple statuses.

1. An asset or vehicle may be current (active) or sold.
2. Services may be open or closed.
3. Repairs may be open, deferred, monitored, closed, or cancelled.

Note: Sections of Gearbox, including Fuel and Prestarts, are limited to 1,000,000 records per XLSX export. Capturing several years' worth of data may need to be date-filtered to ensure the record limit is not exceeded.

Exporting Assets and Vehicles

To capture all assets and vehicle data from your system requires running two reports:

1. Current Asset Register
2. Sold Asset Register
   

1. In vehicles, click on Reports (1)

Exporting Assets and Vehicles - Current Assets

2. Generate the Current Asset Register and Sold Asset Register as shown below. To generate these reports, click on PDF or XLSX, depending on the type of format you are after.

Exporting Assets and Vehicles - Asset Reports

Exporting Services

When collecting all service data from your system, two reports need to be generated

1. Open Services Register
2. Closed Services Register
   

1. In services, click on Reports

Exporting Services - Open Services

2. Generate Open Services Register and Closed Services Register as shown below. To generate these reports, click on PDF or XLSX, depending on the type of format you are after.

Exporting Services - Service Report

​

Summary of required reports

Vehicle & Maintenance data

Section	Required Report	Date Filter Required
Vehicles	Current Asset Register Sold Asset Register	– Yes
Services	Open Services Register Closed Services Register	– Yes
Repairs	Open Repair Register Deferred Repair Register Monitored Repair Register Cancelled Repair Register Closed Repair Register	– – – – Yes
Tyres	Open Tyre Register Deferred Tyre Register Monitored Tyre Register Cancelled Tyre Register Closed Tyre Register	– – – – Yes
Fuel	Fuel Register	Yes
Prestarts	Prestart Register	Yes
Odometer	Not available	–
Reminders	Vehicle Reminders* (open only) (located in Vehicles)	–
Other	Other Register	Yes

Employee Data

Section	Required Report	Date Filter Required
Employees	Current Employee Register Terminated Employee Register	– Yes
Diary Pages	All Diary Pages	Yes
Medicals	Open Medicals Register Closed Medicals Register	– Yes
Training	Open Training Register Closed Training Register	– Yes
Equipment Issue	All Equipment Issue Register	Yes
Accidents/Events	All Accidents/Event Register	Yes
Fit For Duty	Fit For Duty Register	Yes
Employee Reminders	Open Employee Reminder Register (open only)	–

Compliance Data

Section	Required Report	Date Filter Required
Books	Current Book Register	–
Load Sheets	All Load Sheet Register	Yes
Inspection	Open Inspections Register Closed Inspections Register	– Yes
Mass Verifications	All Mass Verification Register	Yes
Contractors	Active Contractor Register* (active only)	–
Permits	Open Permit Register Closed Permit Register	– Yes
Risk Assessments	All Risk Assessments	–
Non Conformances	Open Non Conformances Register Closed Non Conformances Register	– Yes
Reviews	Open Review Register (open only)	–
Contractor Reminders	All Contractor Reminders	Yes

Repairer data

Section	Required Report	Date Filter Required
Repairers	All Repairers	–

Parts data

Section	Required Report	Date Filter Required
Parts	Parts Register	–
Purchase Orders	All Purchase Orders	Yes
Stock Adjustments	Not Available	–
Parts Used	Used Parts Register – Date Closed	Yes

Mechanic / Labour data

Section	Required Report	Date Filter Required
Mechanics labour	Labour Report	Yes

• Related Articles

• 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 ...

• 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 ...

• Exporting Purchase Orders & Tracking Categories in Xero

  Purpose To provide instructions on how to export Purchase Orders from Gearbox to an integrated Xero system. Xero must be integrated prior to exporting Purchase Orders. Xero has a 30 min timer on session tokens which may result in additional login ...

• Export Purchase Orders to MYOB

  Overview Gearbox allows you to export Purchase orders in MYOB CSV format. To import Purchase Orders to MYOB you must first setup a purchase account “5-XXXXX” and the Supplier must exist in MYOB (case sensitive). The Card Type must also be set to ...

• Gearbox WIISE Integration with Purchase Orders

  Overview Gearbox integrates with WIISE by pushing and updating Purchase Orders created in Gearbox to WIISE. When a Purchase order is completed in Gearbox, the user clicks on Export To WIISE button. If the purchase order is edited after the export, ...