You can import data about the activities you time with the Timer to QuickBooks. The keyword for activity data is TIMEACT. Timer activity data must begin with the Timer header block (TIMERHDR).
The following table shows the column headings for activity data:
DATE |
The date the activity was performed. Enter the date in a MM/DD/YY format. For example, you would enter June 21, 1997 as 06/21/97. |
|
JOB |
The name of the customer (or job) for whom the activity was performed. If you're entering the name of a job, enter the customer's name followed by a colon followed by the name of the job. Both the customer and the job names must also be on your Customers & Jobs list (CUST). |
|
EMP |
The name of the employee who performed the activity. The employee's name must also be on your Employee list (EMP). |
|
ITEM |
The name of the service item assigned to the activity (a service item indicates the type of work performed). The service item must also be on your Item list (INVITEM). |
|
PITEM |
Leave blank. This field is not used in QuickBooks. |
|
DURATION |
The duration of the activity in hours and minutes. Enter the duration in an HH:MM format. For example, if the activity lasted 4 hours and 15 minutes, you would enter 4:15. The duration cannot be greater than 23:59. |
|
PROJ |
The QuickBooks class assigned to the activity (classes give you a way to group activities in meaningful ways in time reports). The Class must also be on your Class list (CLASS). |
|
NOTE |
Your notes about the activity. You may enter up to 1000 characters, but the characters must be on a single line within the field. To indicate a line break in the note, type /n. |
|
BILLINGSTATUS |
Indicates the billing status of the activity. Enter one of these values: |
|
|
0 |
The activity is not billable to the customer or job specified in the Job field. Enter this value if the activity is part of your company overhead. |
|
1 |
The activity is billable but has not yet been billed to the customer or job specified in the Job field. |
|
2 |
The activity has already been billed to the customer or job specified in the Job field. |