Use the following instructions to set up your
Peachtree export template.
The file format for Peachtree is Comma Delimited,
and is defined by a modified Time Ticket Register
import.
Field Name |
Import |
Required |
Description |
Limit |
Employee/Vendor |
Y |
Y |
0=Employee
1=Vendor |
(N/A) |
Recorded by ID |
Y |
Y |
Must
be valid employee or vendor ID (see above) |
Up
to 20 Characters |
Ticket Number |
Y |
Y |
Cannot
be blank, must be unique |
1
to 20 Characters |
Ticket Date |
Y |
Y |
Date
of the transaction in MM/DD/YYYY format |
(N/A) |
Has been used in Sales/Invoicing |
Y |
Y |
TRUE
or FALSE |
(N/A) |
Invoice Number Used |
Y |
N |
Required
if setting above=TRUE |
1
to 20 Characters |
Activity Item ID |
Y |
Y |
Must
be valid inventory item set up with Item
Class=6 |
Up
to 20 Characters |
Customer/Job/Adm |
Y |
Y |
1=Customer
2=Job
3=Administrative |
(N/A) |
Completed for ID |
Y |
Y |
Must
be valid customer or job ID. Adm is ignored
(see above) |
Up
to 20 Characters |
Pay Level |
Y |
N |
Required
if Employee/Vendor=0 Must be blank if
Employee/Vendor=1 |
Numerals
1 - 10 |
Has been used in Payroll |
Y |
Y |
TRUE
or FALSE |
(N/A) |
Manual/Timed Option |
Y |
Y |
0=Manual
Timed Entry
1=Timed Duration |
(N/A) |
Start Time |
Y |
N |
Starting
Manual Time in HH:MM AM/PM format |
Cannot
exceed 12:59 |
End Time |
Y |
N |
Ending
Manual Time in HH:MM AM/PM format |
Cannot
exceed 23:59 |
Break |
Y |
N |
Break
during Manual Time Duration in HH:MM format |
Cannot
exceed difference between Start and End
time |
Duration |
Y |
N |
Duration
Time in HH:MM format |
Cannot
exceed 23:59 |
Ticket Description for
Invoicing |
Y |
N |
Time
Ticket description used in sales invoice |
Up
to 160 Characters |
Internal Memo |
Y |
N |
Internal
note for time ticket |
Up
to 2000 Characters |
Billing Type |
Y |
Y |
1=Employee
Rate
2=Activity Rate
3=Override Rate
4=Flat Rate |
(N/A) |
Billing Rate |
Y |
Y |
Rate
used to calculate billing amount based
on duration if Billing Type=1,2 or 3. |
(N/A) |
Billing Status |
Y |
Y |
1=Billable
2=Non-billable
3=No Charge
4=Hold |
(N/A) |
Unit Duration |
N |
N |
Calculated
by Peachtree as duration converted to
decimal format |
(N/A) |
Billing Amount |
Y |
Y |
Required
if Billing Type=4 |
(N/A) |