TATEMS Fleet Maintenance Software Custom Spreadsheets
We've created these Excel Spreadsheet Reports that you can use to link to your TATEMS data and then customize, slice and dice your data any way you want to.
This video gives you details of how to link these spreadsheets to your live TATEMS data file using Microsoft Excel 2007 through 2019
You will also find links to specific videos relating to various spreadsheets listed below.
These custom spreadsheets created by us will not alter your existing TATEMS data.
They only pull a current snapshot of your TATEMS data into the spreadsheet.
HINT: If you are looking for a spreadsheet for a specific part of TATEMS you can search this page by keyword. You should be able to press F3 on your keyboard and then you can search for every custom spreadsheet related to a particular keyword. For example, to find everything related to work orders search this page for the word: “Work” without the quotes.For any of the spreadsheets below to download them you should (Right click and choose save link/target as)
- TATEMS All Parts Inventory No Grouping (Now Includes Bin Location and Bin)
- TATEMS All Periodic Inspections Done.xls
- TATEMS Parts Category Types Equipment Costs.xls
- TATEMS Personnel Report.xls
- TATEMS Parts For This Equipment.xlsx (updated Jun 26, 2024)
- TATEMS Work Orders With Make Model Year Of Equipment
- TATEMS Dept or Area + Equip Num Work Order Totals
- TATEMS Tires Installed Entire Fleet (Blog & how to video
) - TATEMS Equipment State or Province Registration Renewals And Costs
- TATEMS Report Parts Inventory On Hand No Prices
- TATEMS Report All Parts Inventory List Including OutOfStock NoPrices
- TATEMS Report All Parts Inventory List Including Parts OnRE-Order
- TATEMS Report Needed Main And Repairs Sort By SortOrder
- TATEMS Report Parts Inventory Types Installed Quantites And Costs
- TATEMS Report Yearly Fuel Log Totals For Each Equip
- TATEMSReportYearlyFuelLogTotalsIncludingOverallMilesPerGallonForEachEquip
- TATEMS Report-PartsInventory Parts Last Used And Never Used
- TATEMS Driver Licence Renewals Grouped By Months
- TATEMSDeptORAreaEquipWorkOrderTotalsReportGroupedByYear
- TATEMS Report Fuel Log State Prov Totals
- TATEMS Lube Service Report With Notes Report
- TATEMS Equipment List With Current Odometer And Hours
- TATEMS Equipment Filters List Sorted By SortOrder Then EquipNum
- TATEMS Cost Per Mile For Work Orders For 2008 Report
- TATEMSReportFuelLogTotalsIncludingMilesPerGallonForEachEquipByMonth
- TATEMS Report Equipment Tires With Current Odometer (Updated Dec 8, 2016) (Blog & how to video )
- TATEMSEquipmentListSortbyLocationWithCurrentOdometerAndHours
- TATEMSLastAndNextLubeServiceAllEquipment
- TATEMSPartsUsedCountTotalsPast12Months
- TATEMSFiltersListWithCountsNeededForStockingQuantity
- TATEMSLastAndNextLubeServiceAllEquipmentWithMileageKmHours
- TATEMS Equipment Parts And LaborTotals With Location And Current ODO (Updated Jan 2019 to improve Tax & Misc accuracy & added Outside Vendor Column)
- TATEMS Repairs Done With Certain Drivers On Equipment
- TATEMS Report Historical Parts Prices
- TATEMS Report All Repairs Completed
- TATEMSRepairsCompletedTotalsWithMakeModelYearTypeAndCurrentOdometer
- TATEMSWorkOrdersTotalsWithMakeModelYearTypeAndCurrentOdometer
- TATEMS Equipment List With GVWR Axles And Tires
- TATEMSAllOdometerAndHoursReadingsSortedByEquipThenDate
- TATEMSAllOdometerReadingsEachDateHasOwnColumnForAllof2010
- TATEMSWorkOrdersLabor-Parts-Misc-SalesTaxTotals (link to TATEMS data videos )
- TATEMSPartsForThisEquipTotalForEachYear
- TATEMSWorkOrderPartsTotalsForEachEquipForEachYear
- TATEMSPartsForThisEquipNumberOfTimesPartNumberUsedAndCost
- TATEMSWorkOrdersDateRequestedDateCompletedShortAndDetailedDescriptions
->If you have TATEMS Vesion 4.6.28.00 Or Later Use This Link Instead - TATEMSEquipmentFiltersListSortedByLocationThenSortOrderThenEquipNum
- TATEMSEquipmentListVehicleWeightsFuelTypeGasCardPOEngine
- TATEMSRepairsCompletedTotalsWithCustomerMakeModelYearTypeAndCurrentOdometer
- TATEMS-LubeLubeServices-LastDone-NextDue-MileageKmHoursDaysRemainingTillDue(Excel 2007 or newer only)
- TATEMS-PartsVendorHistoryOfInstalledPartsCosts (Blog & how to video )
- TATEMS-WorkOrderTotalsByReferenceNumber
- TATEMS-LubeServiceRemindersWithRemainingTimeLeft (Excel 2007 or newer only Blog & How To Video )
- TATEMS-QuantityOfDifferentFiltersInstalledFromWorkOrders (Blog & how to video )
- TATEMS-PartsReplacedUnderWarranty (Blog & how to video )
- TATEMS PeriodicInspspectionsDueOrPastDueWithLocationDeptAndCustomer (Blog & how to video )
- TATEMS-DriverFuelEfficiencyReport( Blog & how to video )
- TATEMS-GrandTotalsForWorkOrderDiscountsAndMisc (Blog & How to blog post)
- TATEMS-Equipment-Work Order-TotalsForLaborPartsMiscAndDiscounts ( Blog & How to blog post )
- TATEMSEquipmentListWithAllLubeServicesCompletedDetails (Blog & how to video )
- TATEMS-LaborOnWorkOrders-PendingAndCompleted (Blog & how to video)
- TATEMS-EquipmentFilters-WithCustomer-Location-DeptOrArea-Fields (Blog & how to video )
- TATEMS-InspectionsAndPermitsLastAndNext (Blog & how to video )
- TATEMS-Equipment-List-With-Out-Of-Service-Column (Blog & how to video Also quick overview how to link to TATEMS )
- TATEMSEquipPartsAndLaborTotalsWithCustomerAreaDeptLocationMakeModelYearAndCurrentODO (Blog & how to video )
- TATEMSReportDriverTotalMiles-KmTraveledPerEquipment
- TATEMS-OpenWorkOrdersServicedByShortAndDetailedDescriptions
->>If you have TATEMS Vesion 4.6.28.00 Or Later Use This Link Instead - TATEMS-WorkOrdersTotalsByMonthPerEquipment
- TATEMSEquipmentListWithEquipmentTypeAndCurrentOdometerAndHours
- TATEMS-WorkOrdersTotalsWithDtRequestedAndCompletedRefSrvBy
- TATEMSEquipLifetimeMontlyFuelLogMilesTraveledGallonsMpgFuelCost
- TATEMS-WorkOrdersTotalsWithDtRequestedCompleteByCompleted-1stShortDescr
->If you have TATEMS Vesion 4.6.28.00 Or Later Use This Link Instead - TATEMS-PuchaseDate-CurrentOdometer-LastDOTInsp-LastMaintenanceOdometerAndDate-NextMaintOdometerAndDateAndInsuranceExpiration
- TATEMS-WorkOrdersServicebyVendorTotalsAllTime
- TATEMS-AllOpenWorkOrdersSortedByEquipNumWithServicebyAndShortDesc
->>If you have TATEMS Vesion 4.6.28.00 Or Later Use This Link Instead - TATEMS-WorkOrdersShortDescriptionsList
- TATEMS-AllOpenWorkOrdersSortedByEquipNumWithServicebyAndShortDesc1Through5
->>If you have TATEMS Vesion 4.6.28.00 Or Later Use This Link Instead - TATEMS Report-Repairs-Completed-WithEquipDesc-Location-Dept-Customer
- TATEMSEquipmentAttachmentsList (Blog & how to video )
- TATEMSEquipmentListWithCustomerEquipTypeOdometerAndHoursMeter-InServiceOnly (Blog & how to video )
- TATEMSEquipmentListWithCurrentOdometerHoursFiltersLastLubeService (Blog & how to video )
- TATEMSInventoryValueForActivePartsAndWorkOrderPartsInstalledTotalsByCompletedDate
- TATEMSPartsInventoryNeverUsedAndNotUsedInLast18MonthsWithCurrentOnHand
- TATEMSRepairCodeTotalsGroupedByYear (Blog & how to video
- TATEMSRepairCodeTotalsGroupedByEquipmentAndByYear (Blog & how to video )
- TATEMS-AllWorkOrdersWithServicebyAndShortDesc1Through5
->>If you have TATEMS Vesion 4.6.28.00 Or Later Use This Link Instead - TATEMS-MilesKmTraveledHoursRunAllEquipmentGroupedByYear
- TATEMSNeededMaintenance-RepairsWithCustomer-Location-DeptOrArea
- TATEMS-AllWorkOrdersWithServicebyAndShortDesc1Through5-EquipDetail-LaborEmployee-MeterReadings
->>If you have TATEMS Vesion 4.6.28.00 Or Later Use This Link Instead - TATEMSAllPartsInventoryItemsTypesQuantiesInstalledCostsRepairCodesEmployeeIDMechanicNameOnAllEquipment
- TATEMS-InsuranceRenewalWithExtraFieldsAddedOwnedLeasedAndOdometer
- TATEMSReport-EqNum-Customer-RepairDesc–RepairDate-RepairCost-PMType-PMInterval-NextPM-PMInterval-NextPM-PurchasePrice-OriginalEquipCost-Condition (The repairs listed on report 91 will show up as duplicates if the equipment has more than one Lube/Service Type done on it in that past. One repair for each Lube/Service Type (PM Type) the next PM will also repeat once for each repair)
- TATEMSReport-EqNum-Customer-TotalRepairCost-MTD-RepairCost-PMType-PMInterval-NextPM-PurchasePrice-Condition
- TATEMS-WorkOrdersAndRepairsCompletedCombined
->>If you have TATEMS Vesion 4.6.28.00 Or Later Use This Link Instead - TATEMSEquipmentListWithCustomerEquipTypeOdometerAndHoursMeterOutOfServiceYesOrNo (Blog & how to video )
- TATEMS-AllEquipmentSummaryReportSameDataAsTATEMSWithEquipTypeAdded
- TATEMSReport-PartsInventoryTypesList
- TATEMSReport-MonthlyPartsLaborTiresAndEmplyeeHoursOn3Sheets
- TATEMSReport-WorkLaborHoursByEmployeeGroupedByMonthAndYearAndWeekOfYear
- TATEMSReport-WorkOrderActualTiresCostsGroupedByMonthAndYear
- TATEMSReport-WorkOrderActualPartsCostsAndLaborHoursByGroupedByMonthAndYear
- TATEMS-WorkOdersAndRepairsCompletedCombined
- TATEMSReportEqNum-Customer-TotalRepairCost-MTDRepairCostNextPMPurchasePriceReplaceCostCondition
- TATEMSReport-EqNum-Customer-RepairDesc-RepairDate-RepairCost-NextPM-PurchasePrice-ReplaceCost-Condition
- TATEMS-EquipLifetimeMontlyFuelLogMilesTraveledGallonsMPGFuelCostFuelTypeEquipWeights
- TATEMS-EquipLifetimeDailyFuelLogMilesTraveledGallonsMPGFuelCostFuelTypeEquipWeights
- TATEMS-EquipmentListWithMostEquipmentSummaryFieldsIncludingOdometerAndHours
- TATEMS-90DayInspectionsAndDOTInspectionsComingtDueAndPastDue45DaysOut (Video )
- TATEMS-EquipmentSummaryWithExtraInsuranceDataFieldsAndMore
- TATEMS-CustomerAverageMonthlyNumberAndOverallNumberOfWorkOrdersCompletedAllTime
- TATEMS-CustomerMonthlyWorkOrdersCompletedPerMonth
- TATEMS-EquipNumDescYearVinLastLubeNotLastAirFilterLastLubeOrInspAsPMIorWETLastDOT
- TATEMS-Last90DayInspectionCompletedWithEquipNumDescLicVin
- TATEMS-PartsInventoryOnlyQtyOnHandWithCostWithEmptyActualColumnForTakingInventory (Includes Bin/Location )
- TATEMS-LaborOnWorkOrders-PendingAndCompletedWithCustomer
- TATEMS-WorkOrderTemplatesList
- TATEMS-MontlyFuelLogStateMileageSums
- TATEMS-QuantityOfWorkOrderPartsInstalledOverATImePeriod (Blog & how to video )
- TATEMSReportTotalGallonsUsedPerFuelTypePerDay (Blog & how to video )
- TATEMSReport-WorkOrderPartsForEachEquipmentTypeAndQtyOnHand
- TATEMSWorkOrdersShortDescPartsAndLaborDescriptionInSingleColumnForQuickbooksImport
-> If you have TATEMS Version 4.6.28.000 Or Later Use This Link Instead (Blog & how to video for Quickbooks Import into TATEMS)
-> TATEMSWorkOrdersShortDescPartsNumAndDescAndLaborDescriptionInSingleColumnForQuickbooksImportOpenAndClosedWO-For Use After TATEMS Version-4.6.28
-> TATEMSWorkOrdersShortDescPartsAndLaborDescriptionInSingleColumnForQuickbooksImportOpenWorkOrders-For Use After TATEMS Version-4.6.28 - TATEMS-MilesKmTraveledHoursRunAllEquipmentGroupedByMonth (Blog & how to video )
- TATEMS-EquipmentNotes.xlsx
- TATEMS-PartsUsedCountTotalsCustomDateRange
- TATEMSNeededMaintenanceWithCurrentODOAndHoursMeter
- TATEMS-MontlyWorkOrderPartsCostsAndLaborHoursPerEquipment
- TATEMSFuelLogGallonsPerHourForADateRange
- TATEMSEquipmentInspectionsDueDatesAndDaysTillDueOrPastDueWithEquipTypeAndGlobalInspInterval
- TATEMS-PartsInventoryAllActiveWithCostWithEmptyActualColumnForTakingInventory (Blog & how to video)
- TATEMS-WorkOrderPartsInventoryInstalledByCustomerbyYearAndInventoryType (Blog & how to video)
- TATEMS-WorkOrdersTotalsByYearPerEquipment (Blog & How To Video for Excel 2007 Though 2019 )
- TATEMS-FuelTypeGallonsOrLitersPerDayEntireFleet
- TATEMS-PartsForThisEquipWithAllColumns (This is NOT related to Parts Inventory. It's only data from the “Parts For This Equip” Tab)
- TATEMS-AllPartsInstalledViaWorkOrdersFormattedLikePartsForThisEquipment (Blog & how to video)
- TATEMS-WorkOrdersPartsAndLaborCostsByEquipmentPerYear
- TATEMS-WorkOrdersServicebyVendorTotalsPerEquipmentAllTimeOrDateRange
- TATEMS-LubeServiceRemindersWithRemainingTimeLeftAndExtraEquipFields (Works in Excel 2007 and later Blog & How To Video )
- TATEMS-LubeLubeServices-LastDone-NextDue-MileageKmHoursDaysToGoTillDue (Shows how long to go for all lube services Excel 2007 and later Blog & How To Video)
- TATEMSOdometerAndHoursWithCustomerLocationDeptAreaOutOutService Requires Excel 2007 or later Blog & How To Video
- TATEMSEquipmentListWithCapitalEquipNumbersTypeOutofServiceColumns
- TATEMS-DOT-ComingDueByEquipmentTypeEachMonthReport
- TATEMSLastAndNext90DayOrUserDefinedDaysInspection
- TATEMSPartsInventoryListWithAllFields
- TATEMS-PartsNotDeductedFromInventory
- TATEMS-LubeServiceTypesAndIntervalsForEachEquipmentAndEquipmentType
- TATEMSWorkOrdersEachPartsCostsAndSellingPrice
- TATEMSEquipmentListVinLicensePlateRegDateDueCostsAndWeights
- TATEMS-WorkOrdersLineItemsCustomerEquipNumWONumDateCompleteShortDescPartsLaborQtyRateTotals
- TATEMSTiresAndWheelsInstallEntireFleet
- TATEMSWorkOrdersWithEquipNumVinYeaMakeModelWONumDateRequestDateCompleteMilesHoursPartsLaborMiscTaxesTotals
- TATEMS-InspectionsAndPermitsLastAndNext-With-Make-Model-Year
- TATEMSNeededMaintenance-RepairsWithCustomer-Location-DeptOrAreaMake-Model-Year
- TATEMSWorkOrdersWithCustomerEquipNumVinYeaMakeModelWONumDateRequestDateCompleteMilesHoursPartsLaborMiscTaxesTotals
- PendingWorkOrdersEquioNumDescWOShortDesc1-5DtRequestDtCompleteByLocationCustomerYearMakeModelVinLicPlate
- TATEMS-NeededMaintenanceRepairsWithEquipNumDescRepairDescLocationCustomerEqipTypeYearMakeModelVinLicPlate
- TATEMS-FuelVendorList
- TATEMS-PartsVendorsList
- TATEMS-ServicedByVendorsList
- TATEMSEquipmentListWithFinancials
- TATEMSLastWorkOrderCompletedDateForEachEquip
- TATEMSLastWorkOrderDOTInspLubeServiceCompletedForEachEquip
- TATEMSLastWorkOrderDOTInspLubeService90DayInspCompletedForEachEquip
- TATEMSWorkOrdersListWithEquipNumMakeModelYearWONumDatesMetersWarrantyRecallShortDetailDescGrandTotal
- TATEMS-WorkOrder-LubeService-Inspection-CountTotalsByDateRange Click here for Help Video (Req. Excel Power Query add-in (2010-2013) and is included in later versions)