• Home  / 

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)
  1. TATEMS All Parts Inventory No Grouping (Now Includes Bin Location and Bin)
  2. TATEMS All Periodic Inspections Done.xls
  3. TATEMS Parts Category Types Equipment Costs.xls
  4. TATEMS Personnel Report.xls
  5. TATEMS Parts For This Equipment.xls
  6. TATEMS Work Orders With Make Model Year Of Equipment
  7. TATEMS Dept or Area + Equip Num Work Order Totals
  8. TATEMS Tires Installed Entire Fleet (Blog & how to video Video Link)
  9. TATEMS Equipment State or Province Registration Renewals And Costs
  10. TATEMS Report Parts Inventory On Hand No Prices
  11. TATEMS Report All Parts Inventory List Including OutOfStock NoPrices
  12. TATEMS Report All Parts Inventory List Including Parts OnRE-Order
  13. TATEMS Report Needed Main And Repairs Sort By SortOrder
  14. TATEMS Report Parts Inventory Types Installed Quantites And Costs
  15. TATEMS Report Yearly Fuel Log Totals For Each Equip
  16. TATEMSReportYearlyFuelLogTotalsIncludingOverallMilesPerGallonForEachEquip
  17. TATEMS Report-PartsInventory Parts Last Used And Never Used
  18. TATEMS Driver Licence Renewals Grouped By Months
  19. TATEMSDeptORAreaEquipWorkOrderTotalsReportGroupedByYear
  20. TATEMS Report Fuel Log State Prov Totals
  21. TATEMS Lube Service Report With Notes Report
  22. TATEMS Equipment List With Current Odometer And Hours
  23. TATEMS Equipment Filters List Sorted By SortOrder Then EquipNum
  24. TATEMS Cost Per Mile For Work Orders For 2008 Report
  25. TATEMSReportFuelLogTotalsIncludingMilesPerGallonForEachEquipByMonth
  26. TATEMS Report Equipment Tires With Current Odometer (Updated Dec 8, 2016) (Blog & how to video Video Link)
  27. TATEMSEquipmentListSortbyLocationWithCurrentOdometerAndHours
  28. TATEMSLastAndNextLubeServiceAllEquipment
  29. TATEMSPartsUsedCountTotalsPast12Months
  30. TATEMSFiltersListWithCountsNeededForStockingQuantity
  31. TATEMSLastAndNextLubeServiceAllEquipmentWithMileageKmHours
  32. TATEMS Equipment Parts And LaborTotals With Location And Current ODO (Updated Jan 2019 to improve Tax & Misc accuracy & added Outside Vendor Column)
  33. TATEMS Repairs Done With Certain Drivers On Equipment
  34. TATEMS Report Historical Parts Prices
  35. TATEMS Report All Repairs Completed
  36. TATEMSRepairsCompletedTotalsWithMakeModelYearTypeAndCurrentOdometer
  37. TATEMSWorkOrdersTotalsWithMakeModelYearTypeAndCurrentOdometer
  38. TATEMS Equipment List With GVWR Axles And Tires
  39. TATEMSAllOdometerAndHoursReadingsSortedByEquipThenDate
  40. TATEMSAllOdometerReadingsEachDateHasOwnColumnForAllof2010
  41. TATEMSWorkOrdersLabor-Parts-Misc-SalesTaxTotals  (link to TATEMS data videos Video Link)
  42. TATEMSPartsForThisEquipTotalForEachYear
  43. TATEMSWorkOrderPartsTotalsForEachEquipForEachYear
  44. TATEMSPartsForThisEquipNumberOfTimesPartNumberUsedAndCost
  45. TATEMSWorkOrdersDateRequestedDateCompletedShortAndDetailedDescriptions
    ->If you have TATEMS Vesion 4.6.28.00 Or Later Use This Link Instead
  46. TATEMSEquipmentFiltersListSortedByLocationThenSortOrderThenEquipNum
  47. TATEMSEquipmentListVehicleWeightsFuelTypeGasCardPOEngine
  48. TATEMSRepairsCompletedTotalsWithCustomerMakeModelYearTypeAndCurrentOdometer
  49. TATEMS-LubeLubeServices-LastDone-NextDue-MileageKmHoursDaysRemainingTillDue(Excel 2007 or newer only)
  50. TATEMS-PartsVendorHistoryOfInstalledPartsCosts (Blog & how to video Video Link)
  51. TATEMS-WorkOrderTotalsByReferenceNumber
  52. TATEMS-LubeServiceRemindersWithRemainingTimeLeft (Excel 2007 or newer only Blog & How To Video )
  53. TATEMS-QuantityOfDifferentFiltersInstalledFromWorkOrders (Blog & how to video Video Link)
  54. TATEMS-PartsReplacedUnderWarranty (Blog & how to video Video Link)
  55. TATEMS PeriodicInspspectionsDueOrPastDueWithLocationDeptAndCustomer (Blog & how to video Video Link)
  56. TATEMS-DriverFuelEfficiencyReport( Blog & how to video Video Link)
  57. TATEMS-GrandTotalsForWorkOrderDiscountsAndMisc (Blog & How to blog post)
  58. TATEMS-Equipment-Work Order-TotalsForLaborPartsMiscAndDiscounts ( Blog & How to blog post )
  59. TATEMSEquipmentListWithAllLubeServicesCompletedDetails (Blog & how to video Video Link)
  60. TATEMS-LaborOnWorkOrders-PendingAndCompleted (Blog & how to videoVideo Link)
  61. TATEMS-EquipmentFilters-WithCustomer-Location-DeptOrArea-Fields (Blog & how to video Video Link)
  62. TATEMS-InspectionsAndPermitsLastAndNext (Blog & how to video Video Link)
  63. TATEMS-Equipment-List-With-Out-Of-Service-Column (Blog & how to video Video Link Also quick overview how to link to TATEMS )
  64. TATEMSEquipPartsAndLaborTotalsWithCustomerAreaDeptLocationMakeModelYearAndCurrentODO  (Blog & how to video Video Link)
  65. TATEMSReportDriverTotalMiles-KmTraveledPerEquipment
  66. TATEMS-OpenWorkOrdersServicedByShortAndDetailedDescriptions
    ->>If you have TATEMS Vesion 4.6.28.00 Or Later Use This Link Instead
  67. TATEMS-WorkOrdersTotalsByMonthPerEquipment
  68. TATEMSEquipmentListWithEquipmentTypeAndCurrentOdometerAndHours
  69. TATEMS-WorkOrdersTotalsWithDtRequestedAndCompletedRefSrvBy
  70. TATEMSEquipLifetimeMontlyFuelLogMilesTraveledGallonsMpgFuelCost
  71. TATEMS-WorkOrdersTotalsWithDtRequestedCompleteByCompleted-1stShortDescr
    ->If you have TATEMS Vesion 4.6.28.00 Or Later Use This Link Instead
  72. TATEMS-PuchaseDate-CurrentOdometer-LastDOTInsp-LastMaintenanceOdometerAndDate-NextMaintOdometerAndDateAndInsuranceExpiration
  73. TATEMS-WorkOrdersServicebyVendorTotalsAllTime
  74. TATEMS-AllOpenWorkOrdersSortedByEquipNumWithServicebyAndShortDesc
    ->>If you have TATEMS Vesion 4.6.28.00 Or Later Use This Link Instead
  75. TATEMS-WorkOrdersShortDescriptionsList
  76. TATEMS-AllOpenWorkOrdersSortedByEquipNumWithServicebyAndShortDesc1Through5
    ->>If you have TATEMS Vesion 4.6.28.00 Or Later Use This Link Instead
  77. TATEMS Report-Repairs-Completed-WithEquipDesc-Location-Dept-Customer
  78. TATEMSEquipmentAttachmentsList (Blog & how to video Video Link)
  79. TATEMSEquipmentListWithCustomerEquipTypeOdometerAndHoursMeter-InServiceOnly (Blog & how to video Video Link)
  80. TATEMSEquipmentListWithCurrentOdometerHoursFiltersLastLubeService (Blog & how to video Video Link)
  81. TATEMSInventoryValueForActivePartsAndWorkOrderPartsInstalledTotalsByCompletedDate
  82. TATEMSPartsInventoryNeverUsedAndNotUsedInLast18MonthsWithCurrentOnHand
  83. TATEMSRepairCodeTotalsGroupedByYear (Blog & how to video Video Link
  84. TATEMSRepairCodeTotalsGroupedByEquipmentAndByYear (Blog & how to video Video Link)
  85. TATEMS-AllWorkOrdersWithServicebyAndShortDesc1Through5
    ->>If you have TATEMS Vesion 4.6.28.00 Or Later Use This Link Instead
  86. TATEMS-MilesKmTraveledHoursRunAllEquipmentGroupedByYear
  87. TATEMSNeededMaintenance-RepairsWithCustomer-Location-DeptOrArea
  88. TATEMS-AllWorkOrdersWithServicebyAndShortDesc1Through5-EquipDetail-LaborEmployee-MeterReadings
    ->>If you have TATEMS Vesion 4.6.28.00 Or Later Use This Link Instead
  89. TATEMSAllPartsInventoryItemsTypesQuantiesInstalledCostsRepairCodesEmployeeIDMechanicNameOnAllEquipment
  90. TATEMS-InsuranceRenewalWithExtraFieldsAddedOwnedLeasedAndOdometer
  91. 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)
  92. TATEMSReport-EqNum-Customer-TotalRepairCost-MTD-RepairCost-PMType-PMInterval-NextPM-PurchasePrice-Condition
  93. TATEMS-WorkOrdersAndRepairsCompletedCombined
    ->>If you have TATEMS Vesion 4.6.28.00 Or Later Use This Link Instead
  94. TATEMSEquipmentListWithCustomerEquipTypeOdometerAndHoursMeterOutOfServiceYesOrNo  (Blog & how to video Video Link)
  95. TATEMS-AllEquipmentSummaryReportSameDataAsTATEMSWithEquipTypeAdded
  96. TATEMSReport-PartsInventoryTypesList
  97. TATEMSReport-MonthlyPartsLaborTiresAndEmplyeeHoursOn3Sheets
  98. TATEMSReport-WorkLaborHoursByEmployeeGroupedByMonthAndYearAndWeekOfYear
  99. TATEMSReport-WorkOrderActualTiresCostsGroupedByMonthAndYear
  100. TATEMSReport-WorkOrderActualPartsCostsAndLaborHoursByGroupedByMonthAndYear
  101. TATEMS-WorkOdersAndRepairsCompletedCombined
  102. TATEMSReportEqNum-Customer-TotalRepairCost-MTDRepairCostNextPMPurchasePriceReplaceCostCondition
  103. TATEMSReport-EqNum-Customer-RepairDesc-RepairDate-RepairCost-NextPM-PurchasePrice-ReplaceCost-Condition
  104. TATEMS-EquipLifetimeMontlyFuelLogMilesTraveledGallonsMPGFuelCostFuelTypeEquipWeights
  105. TATEMS-EquipLifetimeDailyFuelLogMilesTraveledGallonsMPGFuelCostFuelTypeEquipWeights
  106. TATEMS-EquipmentListWithMostEquipmentSummaryFieldsIncludingOdometerAndHours
  107. TATEMS-90DayInspectionsAndDOTInspectionsComingtDueAndPastDue45DaysOut   (Video  Video Link)
  108. TATEMS-EquipmentSummaryWithExtraInsuranceDataFieldsAndMore
  109. TATEMS-CustomerAverageMonthlyNumberAndOverallNumberOfWorkOrdersCompletedAllTime
  110. TATEMS-CustomerMonthlyWorkOrdersCompletedPerMonth
  111. TATEMS-EquipNumDescYearVinLastLubeNotLastAirFilterLastLubeOrInspAsPMIorWETLastDOT
  112. TATEMS-Last90DayInspectionCompletedWithEquipNumDescLicVin
  113. TATEMS-PartsInventoryOnlyQtyOnHandWithCostWithEmptyActualColumnForTakingInventory (Includes Bin/Location )
  114. TATEMS-LaborOnWorkOrders-PendingAndCompletedWithCustomer
  115. TATEMS-WorkOrderTemplatesList
  116. TATEMS-MontlyFuelLogStateMileageSums
  117. TATEMS-QuantityOfWorkOrderPartsInstalledOverATImePeriod (Blog & how to video TATEMS Fleet Maintenance Software Blog Video Link)
  118. TATEMSReportTotalGallonsUsedPerFuelTypePerDay (Blog & how to video TATEMS Fleet Maintenance Software Blog Video Link)
  119. TATEMSReport-WorkOrderPartsForEachEquipmentTypeAndQtyOnHand
  120. TATEMSWorkOrdersShortDescPartsAndLaborDescriptionInSingleColumnForQuickbooksImport
    ->  If you have TATEMS Version 4.6.28.000 Or Later Use This Link Instead (Blog & how to video TATEMS Fleet Maintenance Software Blog Video Link for Quickbooks Import into TATEMS)
    -> TATEMSWorkOrdersShortDescPartsNumAndDescAndLaborDescriptionInSingleColumnForQuickbooksImportOpenAndClosedWO-For Use After TATEMS Version-4.6.28
    -> TATEMSWorkOrdersShortDescPartsAndLaborDescriptionInSingleColumnForQuickbooksImportOpenWorkOrders-For Use After TATEMS Version-4.6.28
  121. TATEMS-MilesKmTraveledHoursRunAllEquipmentGroupedByMonth (Blog & how to video TATEMS Fleet Maintenance Software Blog Video Link)
  122. TATEMS-EquipmentNotes.xlsx
  123. TATEMS-PartsUsedCountTotalsCustomDateRange
  124. TATEMSNeededMaintenanceWithCurrentODOAndHoursMeter
  125. TATEMS-MontlyWorkOrderPartsCostsAndLaborHoursPerEquipment
  126. TATEMSFuelLogGallonsPerHourForADateRange
  127. TATEMSEquipmentInspectionsDueDatesAndDaysTillDueOrPastDueWithEquipTypeAndGlobalInspInterval
  128. TATEMS-PartsInventoryAllActiveWithCostWithEmptyActualColumnForTakingInventory (Blog & how to videoTATEMS Fleet Maintenance Software Blog Video Link)
  129. TATEMS-WorkOrderPartsInventoryInstalledByCustomerbyYearAndInventoryType (Blog & how to videoTATEMS Fleet Maintenance Software Blog Video Link)
  130. TATEMS-WorkOrdersTotalsByYearPerEquipment (Blog & How To Video for Excel 2007 Though 2019 TATEMS Fleet Maintenance Software Blog Video Link)
  131. TATEMS-FuelTypeGallonsOrLitersPerDayEntireFleet
  132. TATEMS-PartsForThisEquipWithAllColumns (This is NOT related to Parts Inventory. It’s only data from the “Parts For This Equip” Tab)
  133. TATEMS-AllPartsInstalledViaWorkOrdersFormattedLikePartsForThisEquipment  (Blog & how to video)
  134. TATEMS-WorkOrdersPartsAndLaborCostsByEquipmentPerYear
  135. TATEMS-WorkOrdersServicebyVendorTotalsPerEquipmentAllTimeOrDateRange
  136. TATEMS-LubeServiceRemindersWithRemainingTimeLeftAndExtraEquipFields (Works in Excel 2007 and later Blog & How To Video )
  137. TATEMS-LubeLubeServices-LastDone-NextDue-MileageKmHoursDaysToGoTillDue (Shows how long to go for all lube services Excel 2007 and later Blog & How To Video)
  138. TATEMSOdometerAndHoursWithCustomerLocationDeptAreaOutOutService   Requires Excel 2007 or later Blog & How To Video
  139. TATEMSEquipmentListWithCapitalEquipNumbersTypeOutofServiceColumns
  140. TATEMS-DOT-ComingDueByEquipmentTypeEachMonthReport
  141. TATEMSLastAndNext90DayOrUserDefinedDaysInspection
  142. TATEMSPartsInventoryListWithAllFields
  143. TATEMS-PartsNotDeductedFromInventory
  144. TATEMS-LubeServiceTypesAndIntervalsForEachEquipmentAndEquipmentType
  145. TATEMSWorkOrdersEachPartsCostsAndSellingPrice
  146. TATEMSEquipmentListVinLicensePlateRegDateDueCostsAndWeights
  147. TATEMS-WorkOrdersLineItemsCustomerEquipNumWONumDateCompleteShortDescPartsLaborQtyRateTotals
  148. TATEMSTiresAndWheelsInstallEntireFleet
  149. TATEMSWorkOrdersWithEquipNumVinYeaMakeModelWONumDateRequestDateCompleteMilesHoursPartsLaborMiscTaxesTotals
  150. TATEMS-InspectionsAndPermitsLastAndNext-With-Make-Model-Year
  151. TATEMSNeededMaintenance-RepairsWithCustomer-Location-DeptOrAreaMake-Model-Year
  152. TATEMSWorkOrdersWithCustomerEquipNumVinYeaMakeModelWONumDateRequestDateCompleteMilesHoursPartsLaborMiscTaxesTotals
  153. PendingWorkOrdersEquioNumDescWOShortDesc1-5DtRequestDtCompleteByLocationCustomerYearMakeModelVinLicPlate
  154. TATEMS-NeededMaintenanceRepairsWithEquipNumDescRepairDescLocationCustomerEqipTypeYearMakeModelVinLicPlate
  155. TATEMS-FuelVendorList
  156. TATEMS-PartsVendorsList
  157. TATEMS-ServicedByVendorsList