MYOB Advanced Construction Detailed Data Mapping

Overview

PROCORE	Exports data from Procore to MYOB Advanced Construction	Imports data from MYOB Advanced Construction to Procore	MYOB Advanced Construction
COMPANIES			VENDORS
PROJECTS SUB JOBS			PROJECTS PROJECT TASKS
STANDARD COST CODES			COST CODES
COST TYPES			ACCOUNT GROUPS
BUDGETS			COST BUDGETS
BUDGET MODIFICATIONS			COST BUDGET CHANGE ORDERS
PROJECT COST CODES/TYPES			BUDGET COST CODES/ACCOUNT GROUP
COMMITMENTS SUBCONTRACTS & PURCHASE ORDERS COMMITMENT CHANGE ORDERS (CCOs)			COMMITMENTS SUBCONTRACTS & PURCHASE ORDERS COMMITMENT CHANGE ORDERS (CCOs)
SUBCONTRACTOR INVOICES			PAYABLES
SUBCONTRACT PAYMENTS ISSUED FOR SYNCED SUBCONTRACTOR INVOICES			PAID INVOICES
COSTS COMMITTED COSTS JTD COST			COSTS TRANSACTIONAL COST BY INVOICE, EXPENSE, PAYROLL, AND SUBCONTRACTOR INVOICE TYPES

Vendors

PROCORE	Exports data from Procore to MYOB Advanced Construction	Imports data from MYOB Advanced Construction to Procore	MYOB Advanced Construction
ERP Vendor ID1			Vendor ID
Name			Account Name
Address City State ZIP			Address Line 1 City State Postal Code
Business Phone			Business 1 Phone
Email Address			Account Email

¹Import Note: The ERP Vendor ID is entered manually by an Accounting Approver when a company is exported from Procore to MYOB Advanced. This is stored as the ERP Vendor ID (you can view it in the company-level ERP Integration tool under Vendors or in the company-level Directory tool) and is then used on other vendor related exports (Commitments, Commitment CO's).

Projects

PROCORE	Exports data from Procore to MYOB Advanced Construction	Imports data from MYOB Advanced Construction to Procore	MYOB Advanced Construction
MYOB Advanced Job ID			Project ID1
Project Name			Description
Address City State Zip			Address Line 1 City State Postal Code
Latitude / Longitude			Latitude / Longitude
Start Date/Completion Date			Start Date / End Date

^{1 Export note: The MYOB Advanced Job ID is entered manually by an accounting approver when a project is exported from Procore to MYOB Advanced. This may, or may not, depending on what the accounting approver has entered, match the Job Number found in Procore under the project-level Admin tool. This is stored as the MYOB Advanced Job ID (you can view it in the company-level  ERP Integrations tool under the Synced section of Jobs) and is then used on other project related exports such as Budgets, commitments etc... Import note: If the job is imported from MYOB Advanced, the job ID will automatically populate in the project number field.}.

Sub Jobs

Standard Cost Codes

In Procore, the Cost Codes can be found in the Cost Codes section in the Admin Tool under MYOB Advanced Construction Standard Cost Codes.

Standard Cost Types

In Procore, the Cost Types can be found in the Cost Types section in the Admin Tool under MYOB Advanced Construction Standard Cost Types.

Budgets

All budgets totals are entered against the Project Task (In MYOB Advanced>Project>Cost Budget) or the Sub Job (In Procore>Budget Tool)

PROCORE	Exports data from Procore to MYOB Advanced Construction	Imports data from MYOB Advanced Construction to Procore	MYOB Advanced Construction
Original Budget Amount			Original Budgeted Amount
Sub Job			Project Task
Cost Code			Cost Code
Category			Account Group

Budget Modifications

Budget modifications export from Procore only. In Procore, budgets are accessed from project-level Budget tool.  

When Budget Modifications are exported from Procore, a Cost Budget Change Order is created on the Project in MYOB Advanced. It will arrive with an "On Hold" status. In Procore, budget modifications are accessed from the Budget Modifications column in the project-level Budget tool. They are used to move money from one budget line item to another, most commonly with a zero net effect.

PROCORE	Exports data from Procore to MYOB Advanced Construction	Imports data from MYOB Advanced Construction to Procore	MYOB Advanced Construction
Change Date			Change Date
Sub Job			Project Task
Cost Code			Cost Code
Cost Type			Account Group
Budget Modification Amount			Amount

Commitments

Commitments export from Procore only. When a Commitment (Subcontract or Purchase Order) is exported from Procore, a Purchase Order is automatically created in MYOB Advanced Construction.  In MYOB Advanced Construction, Purchase Orders are accessed from the Transactions Tab in the Vendor Center. In Procore, Commitments are accessed from the project-level Commitments tool.

PROCORE	Exports data from Procore to MYOB Advanced Construction	Imports data from MYOB Advanced Construction to Procore	MYOB Advanced Construction
System Date at Time of Commitment Creation			Date
Commitment #1			P.O. NO.
Contract Company			Vendor
Title (General tab)			Description column (first row of detail grid)
Cost Code (Schedule of Values tab)			Item
Description (Schedule of Values tab)			Description
Qty (Schedule of Values tab), if applicable			Qty
Unit Cost (Schedule of Values tab), if applicable			Rate
Project Name			Customer:Job
Contract Amount (Subcontract Only, Schedule of Values tab)			Amount
Subtotal (Purchase Order Only, Schedule of Values tab)			Amount
Description (General Tab)			Vendor Message

¹Commitment # can be changed before export in the ERP Integrations tool, resulting in a non-matching number between the corresponding fields.

Commitment Change Orders

Commitment Change Orders export from Procore only. When Commitment Change Orders are exported from Procore, new line items are created and added to the corresponding Purchase Order in MYOB Advanced Construction, below pre-existing line items. In MYOB Advanced Construction, Purchase Orders are accessed from the Transactions Tab in the Vendor Center. In Procore, Commitment Change Orders are accessed from the project level Commitments tool under Commitment Record. In MYOB Advanced Construction, the change(s) will appear as additional line items on the Purchase Order originally created when the Commitment was exported from Procore to QuickBooks.

PROCORE	Exports data from Procore to MYOB Advanced Construction	Imports data from MYOB Advanced Construction to Procore	MYOB Advanced Construction
System Date at Time of Commitment Creation			Date
Commitment #1			P.O. NO.
Contract Company			Vendor
Title (General tab)			Description column (first row of detail grid)
Cost Code (Schedule of Values tab)			Item
Description (Schedule of Values tab)			Description
Qty (Schedule of Values tab), if applicable			Qty
Unit Cost (Schedule of Values tab), if applicable			Rate
Project Name			Customer:Job
Contract Amount (Subcontract Only, Schedule of Values tab)			Amount
Subtotal (Purchase Order Only, Schedule of Values tab)			Amount
Description (General Tab)			Vendor Message

Job Costs

Job costs import from MYOB Advanced Construction only. Cost information is retrieved from MYOB Advanced Construction reports for each synced Cost Code for use in 2 locations in Procore, the MYOB Advanced Construction Job Costs report and the Budget tool.

PROCORE	Exports data from Procore to MYOB Advanced Construction	Imports data from MYOB Advanced Construction to Procore	MYOB Advanced Construction
Original Budget (QuickBooks Job Costs)			Original Budget amount at time of first export to MYOB Advanced Construction
Revised Budget (QuickBooks Job Costs)			Est. Cost (From Job Estimates vs Actuals Detail Report)
Job to Date Cost (QuickBooks Job Costs)			Act. Cost (From Job Estimates vs Actuals Detail Report)
Commitment Invoiced (QuickBooks Job Costs)			Amount (From Custom Transaction Detail Report)
Job to Date Cost (Budget)			Act. Cost (From Job Estimates vs Actuals Detail Report)
Direct Costs1 (Budget)

¹Direct costs is calculated from Job To Date Cost minus Commitment Invoiced.

Subcontractor Invoices

When a subcontractor invoice is exported from Procore to MYOB Advanced Construction, a Vendor Bill is automatically created in MYOB Advanced Construction. In Procore, Subcontractor Invoices are accessed from Invoices in the project Commitments tool. In MYOB Advanced Construction, Vendor Bills are accessed from the Transactions Tab in the Vendor Center.

PROCORE	Exports data from Procore to MYOB Advanced Construction	Imports data from MYOB Advanced Construction to Procore	MYOB Advanced Construction
Billing Date			Date
Contractor Company			Vendor
Invoice #			REF. NO.
Current Payment Due			Amount Due
Cost Code (Detail Tab)			Item
QTY (Detail Tab), if applicable			QTY
Unit Price (Detail Tab), if applicable			Cost
Value or This Period (Detail Tab)			Amount
Project Name			Customer:Job
Commitment #			PO. NO.
Total Retainage This Period, if applicable1			Amount (on separate line item for retainage)

If used in Procore, retainage is coded to an Item record in MYOB Advanced Construction that is determined in the integration settings. Retainage is not coded to a synced cost code Item.

Commitment Payments Issued

Commitment Payments Issued imported from MYOB Advanced Construction only. When a subcontractor invoice is exported from Procore to MYOB Advanced Construction, a Vendor Bill is automatically created in MYOB Advanced Construction. When the Vendor Bill is paid the payment information will flow back to Procore. In Procore, Subcontractor Invoices Payments are accessed from  Payments Issued in the project Commitments tool. In MYOB Advanced Construction, Vendor Bills are accessed from the Transactions Tab in the Vendor Center under Bill Pmt - Check.

PROCORE	Exports data from Procore to MYOB Advanced Construction	Imports data from MYOB Advanced Construction to Procore	MYOB Advanced Construction
Invoices			n/a
Payment Method			Bill Pmt Window Identifies Method
Date			DATE DUE
Payment #			n/a
Invoice #			REF. NO.
Check / Ref #			NO.
Notes			MEMO
Amount			AMT. PAID

See Also 

• About the MYOB Advanced Construction Connector