Project Financial Analytics - APIs - V1 - Cost

API Name: CoreconAPI_Cost

Note: Job Cost Code, Internal Grouping and Owner Code fields will be blank if multi-projects are selected.

ProjectId
ProjectNumber
ProjectTitle
ProjectBidContactName
ProjectSalesContactName
ProjectPMContactName
ProjectEstStartDateUtc
ProjectEstStartDateOrgLocal
ProjectEstFinishDateUtc
ProjectEstFinishDateOrgLocal

PrimeContractId
PrimeContractNumber
PrimeContractSubject
PrimeContractIssueDateUtc
PrimeContractIssueDateOrgLocal
PrimeContractStatus
PrimeContractApprovalDateUtc
PrimeContractApprovalDateOrgLocal
PrimeContractBillingType
PrimeContractBillingTypeValue
OwnerCompanyName
OwnerContactName
ContractorCompanyName
ContractorContactName
PrimeContractEstStartDateUtc
PrimeContractEstFinishDateUtc
PrimeContractEstStartDateOrgLocal
PrimeContractEstFinishDateOrgLocal

JobCostCodeId
JobCostCodeOrderNumber
JobCostCode
JobCostCodeDescription
JobCostCodeQuantity
JobCostCodeUnit

JobCostCodeInternalDivision
JobCostCodeInternalDivisionDesc
JobCostCodeInternalMajor
JobCostCodeInternalMajorDesc
JobCostCodeInternalMinor
JobCostCodeInternalMinorDesc
JobCostCodeInternalSubMinor
JobCostCodeInternalSubMinorDesc

OwnerCostCode
OwnerCostCodeDescription

CostBudget_Prime_M
CostBudget_Prime_L
CostBudget_Prime_E
CostBudget_Prime_S
CostBudget_Prime_O
CostBudget_Prime

CostBudget_ApprovedCOs_M
CostBudget_ApprovedCOs_L
CostBudget_ApprovedCOs_E
CostBudget_ApprovedCOs_S
CostBudget_ApprovedCOs_O
CostBudget_ApprovedCOs

CostBudget_PendingCOs_M
CostBudget_PendingCOs_L
CostBudget_PendingCOs_E
CostBudget_PendingCOs_S
CostBudget_PendingCOs_O
CostBudget_PendingCOs

CostBudget_ApprovedAndPendingCOs_M
CostBudget_ApprovedAndPendingCOs_L
CostBudget_ApprovedAndPendingCOs_E
CostBudget_ApprovedAndPendingCOs_S
CostBudget_ApprovedAndPendingCOs_O
CostBudget_ApprovedAndPendingCOs

CostBudget_Revised_M = [CostBudget_Prime_M] + [CostBudget_ApprovedCOs_M]
CostBudget_Revised_L = [CostBudget_Prime_L] + [CostBudget_ApprovedCOs_L]
CostBudget_Revised_E = [CostBudget_Prime_E] + [CostBudget_ApprovedCOs_E]
CostBudget_Revised_S = [CostBudget_Prime_S] + [CostBudget_ApprovedCOs_S]
CostBudget_Revised_O = [CostBudget_Prime_O] + [CostBudget_ApprovedCOs_O]
CostBudget_Revised = [CostBudget_Prime] + [CostBudget_ApprovedCOs]

CostBudget_ApprovedCPRs_M
CostBudget_ApprovedCPRs_L
CostBudget_ApprovedCPRs_E
CostBudget_ApprovedCPRs_S
CostBudget_ApprovedCPRs_O
CostBudget_ApprovedCPRs

CostBudget_PendingCPRs_M
CostBudget_PendingCPRs_L
CostBudget_PendingCPRs_E
CostBudget_PendingCPRs_S
CostBudget_PendingCPRs_O
CostBudget_PendingCPRs

AnticipatedCost_Subtotal
AnticipatedCost_Tax
AnticipatedCost_Total

PO_Approved_Subtotal
PO_Approved_Tax
PO_Approved_Total

PO_Approved_Open_Subtotal
PO_Approved_Open_Total

PO_Pending_Subtotal
PO_Pending_Tax
PO_Pending_Total

PO_ApprovedAndPending_Subtotal
PO_ApprovedAndPending_Tax
PO_ApprovedAndPending_Total

Bill_Approved_Subtotal
Bill_Approved_Tax
Bill_Approved_Total

Bill_Pending_Subtotal
Bill_Pending_Tax
Bill_Pending_Total

Bill_ApprovedAndPending_Subtotal
Bill_ApprovedAndPending_Tax
Bill_ApprovedAndPending_Total

Bill_NoPO_Approved_Subtotal
Bill_NoPO_Approved_Tax
Bill_NoPO_Approved_Total

Bill_NoPO_Pending_Subtotal
Bill_NoPO_Pending_Tax
Bill_NoPO_Pending_Total

Bill_NoPO_ApprovedAndPending_Subtotal
Bill_NoPO_ApprovedAndPending_Tax
Bill_NoPO_ApprovedAndPending_Total

Subcontract_Approved_Subtotal
Subcontract_Approved_Tax
Subcontract_Approved_Total

Subcontract_Pending_Subtotal
Subcontract_Pending_Tax
Subcontract_Pending_Total

Subcontract_ApprovedAndPending_Subtotal
Subcontract_ApprovedAndPending_Tax
Subcontract_ApprovedAndPending_Total

SCO_Approved_Subtotal
SCO_Approved_Tax
SCO_Approved_Total

SCO_Pending_Subtotal
SCO_Pending_Tax
SCO_Pending_Total

SCO_ApprovedAndPending_Subtotal
SCO_ApprovedAndPending_Tax
SCO_ApprovedAndPending_Total

RevisedSubcontract_Approved_Subtotal
RevisedSubcontract_Approved_Tax
RevisedSubcontract_Approved_Total

RevisedSubcontract_Approved_Open_Subtotal
RevisedSubcontract_Approved_Open_Total
RevisedSubcontract_Approved_Open_GrossTotal

PORevisedSubcontract_Approved_Open_Subtotal = [PO_Approved_Open_Subtotal] + [RevisedSubcontract_Approved_Open_Subtotal]
PORevisedSubcontract_Approved_Open_Total = [PO_Approved_Open_Total] + [RevisedSubcontract_Approved_Open_Total]

SubInvoice_Approved_GrossTotal

SubInvoice_Approved_Retainage
SubInvoice_Approved_RetainageBilled
SubInvoice_Approved_NetRetainage

SubInvoice_Approved_Subtotal
SubInvoice_Approved_Tax
SubInvoice_Approved_Total

SubInvoice_Pending_GrossTotal

SubInvoice_Pending_Retainage
SubInvoice_Pending_RetainageBilled
SubInvoice_Pending_NetRetainage

SubInvoice_Pending_Subtotal
SubInvoice_Pending_Tax
SubInvoice_Pending_Total

SubInvoice_ApprovedAndPending_GrossTotal
SubInvoice_ApprovedAndPending_Retainage
SubInvoice_ApprovedAndPending_RetainageBilled
SubInvoice_ApprovedAndPending_NetRetainage
SubInvoice_ApprovedAndPending_Subtotal
SubInvoice_ApprovedAndPending_Tax
SubInvoice_ApprovedAndPending_Total

MiscExpense_Approved_Subtotal
MiscExpense_Approved_Tax
MiscExpense_Approved_Total

MiscExpense_Pending_Subtotal
MiscExpense_Pending_Tax
MiscExpense_Pending_Total

MiscExpense_ApprovedAndPending_Subtotal
MiscExpense_ApprovedAndPending_Tax
MiscExpense_ApprovedAndPending_Total

LbrTimecard_Approved_Total
LbrTimecard_Approved_Total_OnBillRates (Uses Bill Rate instead of Cost Rate)
LbrTimecard_Pending_Total
LbrTimecard_ApprovedAndPending_Total = [LbrTimecard_Approved_Total] + [LbrTimecard_Pending_Total]
LbrTimecard_Projected_Total = [LbrTimecard_Approved_Total] / [EstimatedFieldPercentComplete]
LbrTimecard_Remaining_Total = [LbrTimecard_Projected_Total] - [LbrTimecard_Approved_Total]

EqpTimecard_Total
EqpTimecard_Total_OnBillRates (Uses Bill Rate instead of Cost Rate)
EqpTimecard_Projected_Total = [EqpTimecard_Total] / [EstimatedFieldPercentComplete]

AnticipatedCostRemainingLbrEqp_Total = [AnticipatedCost_Total] + [LbrTimecard_Remaining_Total] + [EqpTimecard_Remaining_Total]

CommittedCost_Approved_Subtotal
CommittedCost_Approved_Tax
CommittedCost_Approved_Total

CommittedCost_Pending_Subtotal
CommittedCost_Pending_Tax
CommittedCost_Pending_Total

CommittedCost_ApprovedAndPending_Subtotal = [CommittedCost_Approved_Subtotal] + [CommittedCost_Pending_Subtotal]
CommittedCost_ApprovedAndPending_Total = [CommittedCost_Approved_Total] + [CommittedCost_Pending_Total]

CommittedCost_Approved_Subtotal_OnBillRates (Uses Labor and Equipment Timecard Bill Rate instead of Cost Rate)
CommittedCost_Approved_Total_OnBillRates (Uses Labor and Equipment Timecard Bill Rate instead of Cost Rate)

CostToDate_Approved_GrossTotal
CostToDate_Pending_GrossTotal

CostToDate_Approved_Subtotal
CostToDate_Approved_Tax
CostToDate_Approved_Total

CostToDate_Pending_Subtotal
CostToDate_Pending_Tax
CostToDate_Pending_Total

CostToDate_ApprovedAndPending_GrossTotal = [CostToDate_Approved_GrossTotal] + [CostToDate_Pending_GrossTotal]
CostToDate_ApprovedAndPending_Subtotal = [CostToDate_Approved_Subtotal] + [CostToDate_Pending_Subtotal]
CostToDate_ApprovedAndPending_Total = [CostToDate_Approved_Total] + [CostToDate_Pending_Total]

CostToDate_Approved_GrossTotal_OnBillRates (Uses Labor and Equipment Timecard Bill Rate instead of Cost Rate)
CostToDate_Approved_Subtotal_OnBillRates (Uses Labor and Equipment Timecard Bill Rate instead of Cost Rate)
CostToDate_Approved_Total_OnBillRates (Uses Labor and Equipment Timecard Bill Rate instead of Cost Rate)

ProjectedCostAtCompletion_Total = [CostToDate_Approved_Total] + ([PORevisedSubcontract_Approved_Open_Total]) + ([AnticipatedCostRemainingLbrEqp_Total])

ProjectedCostToComplete_Total = [PORevisedSubcontract_Approved_Open_Total] + [AnticipatedCostRemainingLbrEqp_Total]

ERP_JobToDate_Cost (Latest cost information in ERP system such as Sage Intacct. Data must be populated using AccountingLink utility.)

RevenueBudget_Revised_Subtotal
RevenueBudget_Revised_Tax
RevenueBudget_Revised_Total

RevisedCostBudget_Less_CommittedCostApprovedSubtotal = [CostBudget_Revised] - [CommittedCost_Approved_Subtotal]
RevisedCostBudget_Less_CommittedCostApprovedTotal = [CostBudget_Revised] - [CommittedCost_Approved_Total]

RevisedCostBudget_Less_CommittedCostApprovedPendingSubtotal = [CostBudget_Revised] - ([CommittedCost_Approved_Subtotal] + [CommittedCost_Pending_Subtotal])
RevisedCostBudget_Less_CommittedCostApprovedPendingTotal = [CostBudget_Revised] - ([CommittedCost_Approved_Total] + [CommittedCost_Pending_Total])

RevisedCostBudget_Less_CostToDateApprovedGrossTotal = [CostBudget_Revised] - [CostToDate_Approved_GrossTotal]
RevisedCostBudget_Less_CostToDateApprovedSubtotal = [CostBudget_Revised] - [CostToDate_Approved_Subtotal]
RevisedCostBudget_Less_CostToDateApprovedTotal = [CostBudget_Revised] - [CostToDate_Approved_Total]

RevisedCostBudget_Less_CostToDateApprovedPendingGrossTotal = [CostBudget_Revised] - ([CostToDate_Approved_GrossTotal] + [CostToDate_Pending_GrossTotal])
RevisedCostBudget_Less_CostToDateApprovedPendingSubtotal = [CostBudget_Revised] - ([CostToDate_Approved_Subtotal] + [CostToDate_Pending_Subtotal])
RevisedCostBudget_Less_CostToDateApprovedPendingTotal = [CostBudget_Revised] - ([CostToDate_Approved_Total] + [CostToDate_Pending_Total])

RevisedCostBudget_Less_ProjectedCostAtCompletion_Total = [CostBudget_Revised] - [ProjectedCostAtCompletion_Total]

CommittedCostApprovedSubtotal_Less_CostToDateApprovedGrossTotal = [CommittedCost_Approved_Subtotal] - [CostToDate_Approved_GrossTotal]
CommittedCostApprovedSubtotal_Less_CostToDateApprovedSubtotal = [CommittedCost_Approved_Subtotal] - [CostToDate_Approved_Subtotal]

CommittedCostApprovedAndPendingSubtotal_Less_CostToDateApprovedAndPendingGrossTotal = ([CommittedCost_Approved_Subtotal] + [CommittedCost_Pending_Subtotal]) - ([CostToDate_Approved_GrossTotal] + [CostToDate_Pending_GrossTotal])
CommittedCostApprovedAndPendingSubtotal_Less_CostToDateApprovedAndPendingSubtotal = ([CommittedCost_Approved_Subtotal] + [CommittedCost_Pending_Subtotal]) - ([CostToDate_Approved_Subtotal] + [CostToDate_Pending_Subtotal])

CommittedCostApprovedTotal_Less_CostToDateApprovedTotal = [CommittedCost_Approved_Total] - [CostToDate_Approved_Total]
CommittedCostApprovedAndPendingTotal_Less_CostToDateApprovedAndPendingTotal = ([CommittedCost_Approved_Total] + [CommittedCost_Pending_Total]) - ([CostToDate_Approved_Total] + [CostToDate_Pending_Total])

RevisedRevenueBudget_Less_CommittedCost_Approved_Total = [RevenueBudget_Revised_Total] - [CommittedCost_Approved_Total]
RevisedRevenueBudget_Less_CommittedCost_ApprovedPending_Total = [RevenueBudget_Revised_Total] - [CommittedCost_ApprovedAndPending_Total]

RevisedRevenueBudget_Less_CostToDate_Approved_GrossTotal = [RevenueBudget_Revised_Total] - [CostToDate_Approved_GrossTotal]
RevisedRevenueBudget_Less_CostToDate_Approved_Total = [RevenueBudget_Revised_Total] - [CostToDate_Approved_Total]

RevisedRevenueBudget_Less_CostToDate_ApprovedPending_GrossTotal = [RevenueBudget_Revised_Total] - [CostToDate_ApprovedAndPending_GrossTotal]
RevisedRevenueBudget_Less_CostToDate_ApprovedPending_Total = [RevenueBudget_Revised_Total] - [CostToDate_ApprovedAndPending_Total]

RevisedRevenueBudget_Less_ProjectedCostAtCompletion_Total = [RevenueBudget_Revised_Total] - [ProjectedCostAtCompletion_Total]

Percent_CommittedCostBudget_Subtotal = ([CommittedCost_Approved_Subtotal] / [CostBudget_Revised]) * 100

Percent_CostToDateCostBudget_Gross = ([CostToDate_Approved_GrossTotal] / [CostBudget_Revised]) * 100
Percent_CostToDateCostBudget_Subtotal = ([CostToDate_Approved_Subtotal] / [CostBudget_Revised]) * 100

Percent_CostToDateCommittedCost_Gross = ([CostToDate_Approved_GrossTotal] / [CommittedCost_Approved_Subtotal]) * 100
Percent_CostToDateCommittedCost_Subtotal = ([CostToDate_Approved_Subtotal] / [CommittedCost_Approved_Subtotal]) * 100

EstimatedFieldPercentComplete

Posted February 06, 2025 © 2025 The Sage Group plc or its affiliates ("Sage") or its licensors. All trademarks mentioned are the property of their respective owners. Use of non-Sage trademarks is not an endorsement of any person or product.