How to Confirm Techs Have Entered Autotask Ticket Time Entries for the Previous Week's Service Calls (Weekly Tech Ticket Time Entry Reconciliation)

How to Confirm Techs Have Entered Autotask Ticket Time Entries for the Previous Week's Service Calls (Weekly Tech Ticket Time Entry Reconciliation)

Summary

Each tech's service call spreadsheet should be reconciled against the list of tech time entries to confirm there is a ticket time entry for each scheduled service call. The spreadsheets are found in the Weekly_Tech_Hours folder at the root of the SharePoint Documents Folder.

1.      If there are service call spreadsheets for a tech from an earlier time in the folder, please move the ones from the earlier week into the subfolder called Weekly Service Calls by Tech. Move the spreadsheet with all the time entries into the folder named after the current year in the Weekly_Tech_Hours folder. 

2.      Copy each ticket number from the Tech’s Service Calls Excel sheet.

3.      Paste the ticket number into the Find function in the "weekly_ticket time_entries" Excel sheet.

4.      If you find a time entry for the ticket number in the Weekly Tech Hours Excel sheet, then type Yes on the Tech’s Service Calls Excel sheet next to where the ticket was.

5.      If you do not find the ticket number in the Weekly Tech Hours Excel sheet, then check in AutoTask as follows: Under Contracts, go to Posted Billing Items and enter the ticket number in the ticket number field.

6.      If there’s no record of the time entry here either, go to the ticket. (Occasionally there may be a time entry that was not approved before the spreadsheet was generated). Verify that:

a)      The appointment wasn't cancelled. (Check the service call status.) If the appointment is cancelled, there's no need for a time entry); and

b)     The missing time entry is not showing in the ticket. (Sometimes a time entry may not have been added or approved before the spreadsheet was generated but may now be in the ticket.)

7.      If, through the steps above, you confirm that the time entry, was not added to the ticket, then type No on the Tech’s Service Calls Excel sheet next to where the ticket was. Otherwise, type Yes.

8.      Repeat steps 1-6 until you reach the end of the document.

9.      Prepend the previous Friday's date to the file name of each tech's Excel sheet file. (Do this in numerical form. E.g., 10-17-22.)

10.    Send an email to each tech with a list of the time entries they did not complete (the ones with NO next to them in the spread sheet). Include the scheduled date and time of each missing service call. (There can be more than one service call on a ticket, so they need to know which one is missing.) CC Roberta on each email. 



Make sure the date and time of the time entry in the weekly_ticket time_entries spreadsheet matches the date and time of the service call in the tech's service calls sheet. Otherwise you may be looking at a time entry for a different service call on the same ticket. 


    • Related Articles

    • Entering Ticket Time Entries in AutoTask

      This article is about ticket time entries. This is not about task time entries. The purpose of the time entry is to: document time spent on assignments, help us decide what to bill the customer for, justify the charges to the customer document ...
    • Payroll Time Entry How-To and Payroll Schedule

      Time Entering for Payroll We use Counter Point CHM's Isolved portal to track time for payroll purposes. You can access it via the web at https://identity.myisolved.com/ There is also a mobile app which some team members find handy for clocking in and ...
    • How to Make Payroll and Act on Time-Off Requests

      In order for checks to be direct deposited by Friday, payroll must be completed by Thursday. Normally we expect employees to enter their hours for the previous week by Tuesday noon and we try to do payroll Tuesday afternoon. Log into the isolved ...
    • Creating Recurring Tickets and Service Calls

      What are Recurring Tickets? We use recurring tickets for scheduled maintenance that must be done on a recurring basis. The recurrence instances of each master ticket have a number appended. For example, if the master ticket is T20190528.0050, then ...
    • Customer Support Request (Current customer, non-help desk)

      This is for current customers. For new customers, see “New Client Intake Instructions” Much of this info is intended for the office admin, but it is important for techs to know how to manage customers on the phone, create tickets and prioritize when ...