You can import data about the activities you time with the Timer to
QuickBooks. import files^IIF, . The keyword for activity data is TIMEACT. import files^IIF, . Timer activity data must
begin with the Timer header block (TIMERHDR).
Column headings
The following table shows the column headings for activity data:
DATE | The date the activity was performed. import files^IIF, . 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. import files^IIF, . 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. import files^IIF, . 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. import files^IIF, . 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). import files^IIF, . The service item must also be on your
Item list (INVITEM). |
PITEM | Leave blank. import files^IIF, . This field is not used in QuickBooks. |
DURATION | The duration of the activity in hours and minutes. import files^IIF, . Enter the duration in an
HH:MM format. import files^IIF, . For example, if the activity lasted 4 hours and 15 minutes, you
would enter 4:15. import files^IIF, . 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). import files^IIF, . The Class must also be on
your Class list (CLASS). |
NOTE | Your notes about the activity. import files^IIF, . You may enter up to 1000 characters, but the
characters must be on a single line within the field. import files^IIF, . To indicate a line break
in the note, type /n. |
BILLINGSTATUS | Indicates the billing status of the activity. import files^IIF, . Enter one of these values: |
| 0 | The activity is not billable to the customer or job specified in the Job
field. import files^IIF, . 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. |