Interpret GPS tracking CSV report (Quickbooks time)

Hi there, mkic.  I’m here to help you interpret the data from the CSV file related to your employees' locations.

The local_timestamp field indicates the exact date and time when a GPS point was recorded for the individual listed. This timestamp is essential for calculating how long a person was present at a scheduled location. To determine the actual time a person was present at a location, you'll need to look at time local_timestamp and accuracy_in_meters columns. A change in the accuracy_in_meters column means a change in location. Thus, the duration between subsequent timestamps represent the time spent at a location. 

For example, if an employee's first timestamp is at 11:15 at 10.9 accuracy_in_meters, and then a change in the accuracy_in_meters column is observed at the next timestamp (12:57), this would mean that the employee was at 10.9 accuracy_in_meters for 1 hour and 42 minutes.

For more detailed guidance on reading data from QuickBooks Time, refer to these articles:

• Use QuickBooks Time GPS Tracking as admin or manager
• Understand QuickBooks Time GPS

You may also use our help articles on tracking time for further help on the matter.

Understanding the local_timestamp and accuracy_in_meters fields is crucial for accurately calculating the time spent at scheduled locations. If you have any further questions or need additional assistance, please don’t hesitate to reach out, mkic. We’re here to help you make the most of QuickBooks Time.