Previous Topic

Next Topic

Book Contents

Book Index

QuickBooks/BigTime Field Mappings

Project Settings (Default)

QuickBooks

BigTime

Notes

Company Name

Client Name

 

 

Name

Project Name

Note that BigTime has several options for how a job is exported. You may decide, for example, that you'd like both the project ID and the project NAME to appear in the job name field in QB.

 

FULL Name

Project "Display" Name

For multi-level QuickBooks job structures, BigTime uses the "full name" in order to make it easier for your team to reference the project. A project called "Job 123" for a company called "Allstate," can be referred to as "Allstate:Job 123."

 

Salutation

Billing Contact

 

 

FirstName

Billing Contact

 

 

SurName

Billing Contact

 

 

Billing Address

 

 

 

/Address1 - /Address4

Billing Contact

BigTime assumes that the first line of your billing address is the company name. Then, it lets you setup 4 additional lines of address data. By default, we link the QuickBooks address to your Billing Contact's address.

/City

Billing Contact

 

/State

Billing Contact

 

/Postal Code

Billing Contact

 

/Country

Billing Contact

 

 

Phone

Client (Main Ph)

Main (client) phone number

 

Contact

Billing Contact

If you don't fill in the First/Last name fields, then BigTime will attempt to pull first/last name from your Contact field.

 

Fax

Client (Main Fax)

Main fax number for the client.

 

EMail

Billing Contact...Email

 

 

Account Number

Project ID

This field must be unique, and we assign an ID (derived from the job "name") if one isn't already filled in within QuickBooks.

 

Job Status

Status

Import ONLY.

Job Start Date

Start Date

Import ONLY.

 

Customer Type

Client Type

Import ONLY. Note that in order for you to pull this value from QuickBooks, you must have "linked" your client type codes with QuickBooks.

 

Job Type

Job Type

Import ONLY. Note that in order for you to pull this value from QuickBooks, you must have "linked" your project type codes with QuickBooks.

 

Sales Tax Code

Project Sales Tax Type

Import ONLY.

Custom Fields

BigTime Custom Fields

If the BigTime field name is the same as the QuickBooks field name, then QuickBooks custom fields are copied into BigTime automatically.

 

Staff Settings

QuickBooks

BigTime

Notes

FirstName

First Name

 

 

LastName

Last Name

 

 

EmployeeAddress

 

 

/Address 1

Address

Line 1

 

/Address 2

Address

Line 2

 

/City

City

 

 

/State

State

In Canadian version of QuickBooks, this is linked to the PROVINCE field.

 

/Postal Code

Zip

 

/Country

Country

 

Phone

Work Phone

 

AltPhone

Home Phone

 

EMail

Email

MUST BE UNIQUE in BigTime

 

QuickBooks 2003

 

 

Payroll/Salary

NA

We do not import any salary data from QuickBooks into BigTime. That data stays confidential in QuickBooks unless you enter it explicitly in BigTime.

 

Payroll/UseTimeData

UseTimeData

This checkbox indicates whether an employee uses timesheet data to compute payroll (e.g. - hourly rates). Import Only.

 

SSN/SIN

SSN

Import Only.