Peachtree Quantum Export

Use the following instructions to set up your Peachtree export template.

Custom Fields

The Custom Fields section of the export template screen requires that you specify the following information from the Peachtree program. These settings come from within the Peachtree software, and cannot be supplied by Qqest Software Systems.

  • Billing ID: This setting must be a number 1 - 4: 1=Billable, 2=Non-Billable, 3=No Charge, 4=Hold.
  • Activity ID: Peachtree uses an Activity ID to track different payroll functions. An activity ID for importing data from TimeForce II must be set up. This can be up to 20 alphanumeric characters, and must match a valid item set up with "Item Class=6" inside Peachtree.
  • Ticket Number: This setting determines the Time Ticket Number in Peachtree, and must be chosen so that it will not conflict with other Time Ticket entries that may exist. This setting is a "starting number," and will automatically increment with each record exported.

File Formats

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)

icon_previous_topic.jpg