CoreconLink for Intuit QuickBooks - Data Integration Points

The CoreconLink for Intuit QuickBooks is used to transfer information from Corecon 2007 to Intuit QuickBooks Pro/Premier/Enterprise/Online versions. This utility can be downloaded from within Corecon 2007 and is typically installed only in the accounting department. Whether project financial information is entered by project managers or the accounting department, these financial transactions can be sent to QuickBooks eliminating double data entry. The points of integration between Corecon and QuickBooks are listed below.

Corecon Feature	Transfer Method	QuickBooks Feature	Comments
Startup Phase
Companies	<--->	Customers Vendors	Typically, an organization will implement Corecon after they have been working with QuickBooks for a while. Given this scenario, the CoreconLink application would be used immediately to copy QuickBooks customers and vendors to Corecon.
Employees	<--->	Employees	Like Customers and Vendors, Employees are typically copied from QuickBooks to Corecon.
Payroll Items	<----	Payroll Items	Payroll Items should be identical in both systems in order to transfer Labor Timecards from Corecon to QuickBooks.
Tax Codes	<----	Tax Codes	Accounts payable and accounts receivable transactions below can reference a Tax Code. In the US, Tax Codes are setup to handle the markups for sales tax. For Canada, Tax Codes will represent Good and Service Tax (GST) as well as Provincial Sales Tax (PST). With tax codes being linked in both systems, this will alleviate the accounting administrator of having to specify the correct code when sending transactions over to QuickBooks. Note: If Tax Codes are already setup in QuickBooks, one can copy these codes to Corecon.
Project Setup Phase
Projects	---->	Jobs	A Corecon Project gets transferred to QuickBooks only if it has been awarded. Immediately following this activity, job cost codes would then be linked to chart of accounts and service items (see step below).
Job Cost Codes	Linked	Items Chart of Accounts Classes	When entering financial transactions in QuickBooks (Bills, Checks, Credit Card, Invoices, Labor Timecards), a Service Item or Chart of Account is required for each item. Classes can also be referenced depending on the company. However, in Corecon, all financial transactions require a Job Cost Code which are project specific. Since project financial transactions will be entered in Corecon and then transferred to QuickBooks, the CoreconLink has a feature to create relationships between Corecon Job Cost Codes and QuickBooks' Items, Chart of Accounts, and Classes. This will alleviate the accounting administrator of having to specify the correct item or account when sending transactions over to QuickBooks.
Project Transactions: Accounts Payable
Bills *	<--->	Bills Credit Card Check	Typically, project financial transactions are entered in Corecon and sent to QuickBooks. However, QuickBooks' Bills can be sent to Corecon. Sub Invoices and Prime Invoices (see below) can not be sent from QuickBooks to Corecon due to the added functionality (i.e. contract type, change orders, retainage) in Corecon for these feature.
Sub Invoices *	---->	Bills Credit Card Check	Sub Invoices are entered in Corecon and sent to QuickBooks. Sub Invoices are processed based on the contract type: fixed lump sum, cost plus, or unit price. In addition, Sub Invoices can have retention.
Project Transactions: Accounts Receivable
Prime Invoices *	---->	Invoices	Prime Invoices are entered in Corecon and sent to QuickBooks. Like Sub Invoices, the billing method is based on the contract type and the invoice can have retention. Corecon's Prime Invoices can be printed in AIA G702/G703 format.
Project Transactions: Labor Timecards
Labor Timecards	---->	Time Trackings	One of the benefits of Corecon in an organization is the ability of estimators and project team members to enter their own timecards. Thus, the accounting department can completely restrict access to QuickBooks since timecards can be sent from Corecon to QuickBooks.

* - If the transaction has a negative total, it will then appear as a credit in QuickBooks.

Integration Nomenclature:
<---> Bidirectional Integration
----> Corecon exports to QuickBooks
<---- QuickBooks exports to Corecon