Sage Intacct Data Setup Suggestions

Below are some general guidelines on how to set up Sage Intacct for a construction or engineering firm with the intention of integrating it with Sage Construction Management.

Important: After updating settings in Sage Intacct, you need to run the Refresh Data process in Sage Construction Management for the changes to take effect.

Contact Management - Customers, Vendors and Employees

Importing Vendors and Employees

Since AccountingLink can import Active Customers, Vendors and Employees from Sage Intacct, it is generally a good practice to review each list in regards to their status. For example, if a vendor is no longer used then it should be marked inactive in Sage Intacct before performing the import function within the AccountingLink.

Sage Construction Management and Sage Intacct Awarded Job Setup

Sage Construction Management does NOT offer a Customer | Project import option which is why existing jobs should be completed in Sage Intacct. However, newly awarded projects should be set up in Sage Construction Management and then exported to Sage Intacct as follows.

• Client referenced on Sage Construction Management Prime Contract = Sage Intacct Customer
• Sage Construction Management Project = Sage Intacct Project
• Optional: Sage Construction Management Project-Prime # = Sage Intacct Sub-Project
• Sage Construction Management Prime Contract = Sage Intacct Project Contract
• Sage Construction Management Prime Contract Cost Budgets = Sage Intacct Primary Estimate
• Sage Construction Management Prime Contract Contract Items (aka Schedule of Values) = Sage Intacct Contract Items

Job Cost Codes

The golden rule of job costing is to have a master list of cost codes for categorizing work. These standard cost codes would be used by estimating, project management and accounting staff so information can flow easily between departments. Thus, it is generally a good practice to have an identical master cost code structure in both systems. If this coding structure has already been established in Sage Intacct then these codes can be imported quickly into Sage Construction Management through AccountingLink > Master Cost Codes.

Classes

Classes are applicable to the AccountingLink for Sage Intacct and can be used for categorizing transaction details. If this feature will be implemented in Sage Intacct and used in conjunction with Sage Construction Management, then these type of records should match a particular Sage Construction Management Project Classification system. In Sage Construction Management, select the gear icon to access the settings and then select Features > Lead and Project.

Special Unclassified Item For Missing Cost Code or Owner Code in Sage Intacct

If a master cost code structure will be set up in Sage Intacct and Sage Construction Management, the AccountingLink needs to have a backup item just in case the Sage Construction Management project cost code does not exist in the ERP system.

To import cost codes from the standard cost code catalog, select Accounting Link > Master Cost Codes.

This item should be the default Owner Code Item as well.

• Item Level: Top Tier
• Item Number: 00CCUnc
• Item Description: Unclassified Item From Sage Construction Management
• Parent Id: 00 00 00
• Billable: Yes
• Cost Types: Materials (M), Labor (L), Equipment (E), Sub (S) and Other (O)

AccountingLink > Posting Preferences:

• General Preferences > Cost Code
• General Preferences > Contract Items
• General Preferences > Owner Code
• AR (Accounts Receivable) > Default Line Item ID

Purchasing Transaction Definitions

• Purchase Orders
• Vendor Invoices (used for Bills originating from POs)
• Non-commitment Invoices (used for Bills not originating from POs)
• Subcontracts
• Subcontract CO
• Subcontract Invoices

For detailed steps, see Set up a transaction definition.

Order Entry Transaction Definitions

On the Accounts Receivable tab in AccountingLink Posting preferences, use the fields in the AR general mapping section to map Construction Management transactions to Intacct transaction definitions.

If you use advanced workflows with custom transaction definitions in Intacct, the names may not match what you see in the table below.