Field Mapping

The following table show table mapping between Easy Tracker and QuickBooks.

Table Mapping

The following tables show field mapping between Easy Tracker and QuickBooks.

Field Mapping between Easy Tracker Lites and QuickBooks Customers

Easy Tracker Lites	QuickBooks Customers	Memo
Name	Full Name	The full name of the customer.
Mailing Contact	Contact	The name of a contact person for a customer or vendor.
Billing Contact	Contact	The name of a contact person for a customer or vendor.

��

Field Mapping between Easy Tracker Project Categories and QuickBooks Job Types

Easy Tracker Project Categories	QuickBooks Job Types	Memo
Name	Full Name	The full name of the job type.

��

Field Mapping between Easy Tracker Projects and QuickBooks Jobs

Easy Tracker Projects	QuickBooks Jobs	Memo
Name	Name	The name of the job.
Start Date	Job Start Date	The date on which work for a job was started.
End Date	Job Projected End Date	The date on which work for a job is expected to be complete.
Status	Job Status	Status information about a job.
Description	Job Description	A short job description.
Client	Customer	The name of the customer.
Project Category	Job Type	Job type can be used to separate jobs into any categories that are meaningful to the business

Field Mapping between Easy Tracker Users and QuickBooks Employees

Easy Tracker Users	QuickBooks Employees	Memo
First Name	First Name	The employee's first name.
Last Name	Last Name	The employee's last name.
Start Time	Hired Date	An employee��s date of hire.
End Time	Released Date	The date on which this person's employment with the company ended.
Email	Email	E-mail address.

��

Field Mapping between Easy Tracker Tasks and QuickBooks Item Services

Easy Tracker Tasks	QuickBooks Item Services	Memo
Name	Name	The name of item service
Details	Description	A short item service description.

��

Field Mapping between Easy Tracker Time Log and QuickBooks Timesheet

Easy Tracker Time Log	QuickBooks Timesheet	Memo
User Name	Employee Name
Duration	Duration	Time spent doing the work.
Date	TxnDate
Client Name	Customer Names
Task Name	Item Service Name	The type of work.
Summary	Notes	Additional information.
IsBillable	IsBillable	If IsBillable is true, the tracked time is billable.

Field Mapping between Easy Tracker Expense Categories and QuickBooks Classes

Easy Tracker Expense Categories	QuickBooks Classes	Memo
Name	Name	The name of class

Field Mapping between Easy Tracker Expenses and QuickBooks Check/General Journal

Easy Tracker Expenses	QuickBooks Check/General Journal	Memo
Expense Type	Trans Type	the type of transaction: 1. CHECK means Checks. 2. GENERAL JOURNAL means General journal transactions
Start Date	Date	The date of the transaction.
Specified Account	Account Name	The name of the account assigned to the transaction.
Project Name	Name	The name of the job, customer, vendor, payee, or employee.
Client Cost	Amount	The amount of the transaction
Batch Number	DOCNUM	The number of the transaction. For checks, the number is the check number; for invoices, the number is the invoice number; etc.
Description	MEMO	The memo text associated with the transaction.