New Help Video Shows Parts Inventory Report In TATEMS Plus Inventory Spreadsheets

In this TATEMS Fleet Maintenance Software video below I show you the Parts Inventory Report and Inventory related spreadsheets

I go over:

  • Where to Find The Parts Inventory Report Inside TATEMS
  • The Exclude Parts Types popup box that displays after you click preview or print
  • What The Parts Inventory Report Actually Displays
  • Parts Inventory Related Spreadsheets you can download and link to your live TATEMS data
  • How to link those spreadsheets to TATEMS and how to filter the data for specific columns

This Video will also be added to the Help Videos page at

https://tatems.com/help

Thanks For Visiting and if you like this content please share and like it for us!

 

All The Best!

Marc

New Help Video Shows Latest Backup and Compact Data Features

In the video below I show you the latest backup features in TATEMS Fleet Maintenance Software.

I go over:

  • Compact Checkbox
  • How to Restore from a failed backup
  • How To Choose A Backup Location
  • How To Setup Preferences for Auto Backup when Closing or Ask To Backup When You Close TATEMS

This Video will also be added to the Help Videos page at

https://tatems.com/help

Thanks For Visiting and if you like this content please share and like it for us!

 

All The Best!

Marc

New Video Shows – The Monthly Miles Traveled and/or Hours Run Spreadsheet That Links to Your Live TATEMS Data

In the video below I show you the newest spreadsheet report that you can link to your live TATEMS data.

It will show you hours run and or miles/km traveled for each equipment per month.

I also show you how to link it to your live TATEMS data.

All the custom spreadsheet reports that you can link to your live TATEMS are here:

https://tatems.com/fleetmaintenancesoftware/spreadsheets.cfm

If you have any ideas for more spreadsheet reports for your TATEMS Fleet Maintenance software please let me know!

Thanks For Visiting and if you like this content please share and like it for us!

 

All The Best!

Marc

Video [16 min] How to import TATEMS Work Orders Into Quickbooks

In the video below I show you how to use the custom spreadsheet I created called:

120. TATEMSWorkOrdersShortDescPartsAndLaborDescriptionInSingleColumnForQuickbooksImport

You can find it here:

TATEMS Fleet Maintenance Software Custom Spreadsheets 

You can use it to import Work Orders you created in TATEMS into Quickbooks using a 3rd party tool called Zed Axis .   (They have a free 3o day trial and the cost is under $200 for Zed Axis)

Here are the steps to Import from TATEMS Fleet Maintenance Software To Quickbooks.

  1. Create or Edit Lists in Quickbooks so that you have these 3: Work Order, Parts and Labor (you only need to do this one time)
  2. Open the custom spreadsheet and link if to your TATEMS data file (you only need to do this one time as long as you save the spreadsheet)
  3. Filter the list of work orders in Excel using the Date Completed Field
  4. Copy and paste the invoices including the row with the header names from the list on sheet 1 to Sheet 2 in Excel
  5. Save the spreadsheet but leave it open.
  6. Make sure Quickbooks is open using the Quickbooks  Company file you want to use.
  7. Create a Custom Invoice Layout that adds the “Other” Field In Quickbooks. (This is to display the Equipment Number on the Invoice) and set it as default.  (you only do this once but may need to set it as default each time if you use a different default )
  8. Open Zed Axis and choose Quickbooks Desktop and click the Connect button to connect to the currently open Quickbooks company file
  9. Click the Import Tab in Zed Axis and link to the Excel File
  10. Choose Sheet 2
  11. Create or choose a Mapping Template of the Fields to Map from the Excel Spreadsheet to Quickbooks (You can import the template I already created into Zex Axis.  Right click and Save  http:///pchelpltd.com/tatemsdl/download/TATEMSImportMappingForZedAxis.xml  Then click on the Choose Mapping Dropdown->Import Mapping.  The template only needs to be created or imported once and then can be reused in future imports )
  12. On Import Options Choose your preference “If Already exists” you can choose for example “Skip” to skip importing invoices that have already exist with the same invoice number inside Quickbooks .
  13. If all your invoices that you want imported are selected in the list then click the import button and the process will show you the status until it’s completed.

As noted above many of these steps only have to be completed one time. 

If you are current on your TATEMS support and version upgrades and you need any further customization on this spreadsheet that pulls data from TATEMS and I can get it created for you.

 

All The Best!

Marc Ready

Video [6 min] Preview Of New Improvements coming to TATEMS Version 4.6.23

Here is a preview video of some of the improvements we are working on for TATEMS Fleet Maintenance Software Version 4.6.23

 

This video shows you.

1. New ability to filter the Lube/Service PM List of previous completions to show only the last 2 or any date range.

2. Added new date filters to Needed Maintenance Repairs and Repairs Completed

3. Added ability to change the sort order of 90 Day Bit and 365 Day DOT Inspection items using Sort Order Numbers and Up and Down Arrows.

4. Added new mark for deletion check boxes and button to Inspections Items Lists for more efficient and faster deletions.

Video Registration-Taxes Screen and Reminders,Reports and Custom Spreadsheet

In this video below I go over the TATEMS Registration/Taxes (in the Equipment Summary Tab)

It covers:

  1. Registration and Tax Details Screen
  2. Taxes/Registrations Reminders
  3. Registration Renewal on Unit Information Reports
  4. Registration Renewal All Equipment Summary
  5. Registration Renewal – All Equipment Last And Next Maintenance
  6. Registration Renewal – Equipment List
  7. Equipment State or Province Registration Renewals and Costs – Spreadsheet

 

To show you one of the tips in the TATEMS Tips..

The video below shows you how to use a Crockpot to clean old paint off door hinges.

Thanks for visiting! Please like or share this post!

Video -Total Gallons Used – Per Fuel Type – Per Day – Custom Spreadsheet

In the video below I go over the “TATEMSReportTotalGallonsUsedPerFuelTypePerDay” custom spreadsheet,  and how to link it to your live TATEMS data file.

I show you how to:

 

  • Use the filters in Excel to show all gallons used for a specific fuel type for a specific day
  • Create this spreadsheet from scratch if you have troubling linking it to your data the first way.

The spreadsheet above is number 118 on the Spreadsheets page

Over 100 TATEMS Fleet Maintenance Software Program Spreadsheets can be found at

https://tatems.com/fleetmaintenancesoftware/spreadsheets.cfm

As mentioned in TATEMS Tips: Video below shows you how to make a Mini Metal Foundry.

 

Video – Tires Installed Entire Fleet With Odometer and Amount Travelled – Custom Spreadsheet

In the video below I go over the “TATEMS Report Equipment Tires With Current Odometer” custom spreadsheet,  and how to link it to your live TATEMS  data file.

I show you how to:

 

  • Find specific spreadsheets on the spreadsheets page based on a keyword
  • Create this spreadsheet from scratch if you have troubling linking it to your data the first way.

The spreadsheet above is number 26 on the Spreadsheets page

Over 100 TATEMS Fleet Maintenance Software Program Spreadsheets can be found at

https://tatems.com/fleetmaintenancesoftware/spreadsheets.cfm

As mentioned in TATEMS Tips: Video below shows you how to hold your camera steady.

 

Please contact us if you would like a custom animated logo like the ones you see below for your videos:

Video – Driver History On Equipment

The video below shows you how to Add Drivers to Equipment and a common pitfall that people run into.

This video shows you:

  1. How to add a Driver to a piece of equipment when they have already been added to personnel.
  2. How to add a driver to a piece of equipment when they have not yet been added to personnel.
  3. Shows you the 3 reports in TATEMS that display driver history on equipment
  4. Shows you the 4 spreadsheets that you can link to your live TATEMS data to see driver history in other ways like repairs costs and miles per gallon for a driver on specific equipment.

 

Video – Tires Installed Entire Fleet Custom Spreadsheet

In the video below I go over the “Tires Installed Entire Fleet” custom spreadsheet,  and how to link it to your live TATEMS  data file.

I show you how to:

 

  • Find specific spreadsheets on the spreadsheets page based on a keyword
  • Create this spreadsheet from scratch if you have troubling linking it to your data the first way.

 

Over 100 TATEMS Fleet Maintenance Software Program Spreadsheets can be found at

https://tatems.com/fleetmaintenancesoftware/spreadsheets.cfm

As mentioned in TATEMS Tips: Video below shows you Vinegar and Backing Soda in Action to clean a drain.

 

Please contact us if you would like a custom animated logo like the ones you see below for your videos:

1 2 3 10