Microsoft Word Template - Prime Contract Invoice - Unit Price - Items Grouped By Job Cost Code

Default Templates:

Standard Template: PrimeInvoice-UnitPrice-ItemsGroupedByCostCode.dot

Upload Feature Category: Prime Invoice - Unit Price - Items Grouped By Job Cost Code

Important Things To Know Regarding Bookmarks and Mail Merge Fields

All Bookmarks and Mail Merge Fields are optional.
Bookmarks can be repeated with no limit on the number of times. Examples:
- CompanyName, CompanyName2, CompanyName3, .., CompanyName10, .., CompanyName20, .., CompanyNameX
- ProjectNumber, ProjectNumber2, ProjectNumber3, .., ProjectNumber10, .., ProjectNumber20, .., ProjectNumberX

Bookmarks - General Project Information

ProjectNumber
ProjectTitle
ProjectDescription
ProjectAddress1
ProjectAddress2
ProjectCity
ProjectState
ProjectZipCode
ProjectCountry
ProjectPhone
ProjectFax

Bookmarks - Project Bid Date, Plan Room Info, Estimated Dates, and Stakeholders

ProjectOwnerBidDate
ProjectOwnerBidTime
ProjectPlanRoomInfo
ProjectStartDate
ProjectFinishDate
ProjectSalesPerson
ProjectSalesPersonMobilePhone
ProjectSalesPersonEmailAddress
ProjectBidContact
ProjectBidContactMobilePhone
ProjectBidContactEmailAddress
ProjectManager
ProjectManagerMobilePhone
ProjectManagerEmailAddress

Bookmarks and Mail Merge Table Options - Project Classifications

Click here for options.

Bookmarks - Prime Contract - Number, Type, Subject, and Scope

PrimeContractNumber
PrimeContractType
PrimeContractWorkSubject
PrimeContractWorkScope
PrimeContractInclusions
PrimeContractExclusions
PrimeContractClarifications
PrimeContractOwnerPORef

Bookmarks - Prime Contract - Status and Dates

PrimeContractIssueDate
PrimeContractIssueDateSpelled
PrimeContractStatus
PrimeContractSignedDate
PrimeContractSignedDateSpelled
PrimeContractNTPDate
PrimeContractEstStartDate
PrimeContractEstSubstantialCompletion
PrimeContractEstFinishDate

Bookmarks - Prime Contract - Specific Address

PrimeContractAddress1
PrimeContractAddress2
PrimeContractCity
PrimeContractState
PrimeContractZipCode
PrimeContractCountry
PrimeContractPhone
PrimeContractFax

Bookmarks - Prime Contract - Referenced Architect

ArchitectPrefix
ArchitectFirstName
ArchitectMiddleName
ArchitectLastName
ArchitectSuffix
ArchitectContact
ArchitectTitle
ArchitectMobilePhone
ArchitectEmail
ArchitectCompanyCode
ArchitectCompany
ArchitectAddress1
ArchitectAddress2
ArchitectCity
ArchitectState
ArchitectZipCode
ArchitectCountry
ArchitectPhone
ArchitectPhone2
ArchitectFax
ArchitectWebsite
ArchitectGovTaxID

Special e-Sign Bookmark (Contract Admin and Procurement Templates Only):

Bookmarks listed below must use a white font so the e-Sign Tag is clearly visible and not obstructed.

ArchitectE_Signature
ArchitectE_SignatureDate
ArchitectE_Initial

Bookmarks - Prime Invoice - From Company/Contact (Prime Company | Contractor)

FromPrefix
FromFirstName
FromMiddleName
FromLastName
FromSuffix
FromContact
FromTitle
FromMobilePhone
FromEmail
FromCompanyCode
FromCompany
FromAddress1
FromAddress2
FromCity
FromState
FromZipCode
FromCountry
FromPhone
FromPhone2
FromFax
FromWebsite
FromGovTaxID

Special e-Sign Bookmark (Contract Admin and Procurement Templates Only):

Bookmarks listed below must use a white font so the e-Sign Tag is clearly visible and not obstructed.

FromE_Signature
FromE_SignatureDate
FromE_Initial

Bookmarks - Prime Invoice - To Company/Contact (Owner | Client)

ToPrefix
ToFirstName
ToMiddleName
ToLastName
ToSuffix
ToContact
ToTitle
ToMobilePhone
ToEmail
ToCompanyCode
ToCompany
ToAddress1
ToAddress2
ToCity
ToState
ToZipCode
ToCountry
ToPhone
ToPhone2
ToFax
ToWebsite
ToGovTaxID

Special e-Sign Bookmark (Contract Admin and Procurement Templates Only):

Bookmarks listed below must use a white font so the e-Sign Tag is clearly visible and not obstructed.

ToE_Signature
ToE_SignatureDate
ToE_Initial

Bookmarks - Prime Invoice - Number, Dates, Terms, Comments

PrimeInvNumber
PrimeInvOrderNumber
PrimeInvDate
PrimeInvDateSpelled
PrimeInvPaymentDueDate
PrimeInvPaymentDueDateSpelled
PrimeInvTerms
PrimeInvPrintComments
PrimeInvInternalComments

Bookmarks - Prime Invoice - Previous and Current Change Orders

PrimeInvPreviousCOSubtotal
PrimeInvPreviousCOTaxTotal
PrimeInvPreviousCOTotal
PrimeInvCurrentCOSubtotal
PrimeInvCurrentCOTaxTotal
PrimeInvCurrentCOTotal

Bookmarks - Prime Invoice - Revised Contract Totals

PrimeInvOriginalContractSubtotal
PrimeInvOriginalContractTaxTotal
PrimeInvOriginalContractTotal
PrimeInvNetChangesSubtotal (PrimeInvPreviousCOSubtotal + PrimeInvCurrentCOSubtotal)
PrimeInvNetChangesTaxTotal (PrimeInvPreviousCOTaxTotal + PrimeInvCurrentCOTaxTotal)
PrimeInvNetChangesTotal (PrimeInvPreviousCOTotal + PrimeInvCurrentCOTotal)
PrimeInvRevisedContractSubtotal
PrimeInvRevisedContractTaxTotal
PrimeInvRevisedContractTotal

Bookmarks - Prime Invoice - Gross Values - Current Work Completed

Bookmarks listed below do not include Retainage and Taxation.

PrimeInvCurrentTotal
PrimeInvCurrentTotalSpelled

Bookmarks - Prime Invoice - Retainage Percentages

PrimeInvWorkRetainagePercent
PrimeInvMaterialRetainagePercent (Only applicable for Fixed Lump Sum Invoices)

Bookmarks - Prime Invoice - Retainage - Previous, Current, and Total

PrimeInvPreviousRetainTotal
PrimeInvCurrentRetainTotal
PrimeInvRetainTotal (Includes Billed Retainage)

Bookmarks - Prime Invoice - Billed Retainage - Previous, Current, and Total

PrimeInvPreviousBilledRetainTotal
PrimeInvCurrentBilledRetainTotal
PrimeInvBilledRetainTotal

Bookmarks - Prime Invoice - Current Net Values

PrimeInvCurrentLessRetainSubtotal
PrimeInvCurrentLessRetainSubtotalSpelled
PrimeInvCurrentLessRetainTaxTotal
PrimeInvCurrentLessRetainTaxTotalSpelled
PrimeInvCurrentLessRetainTotal
PrimeInvCurrentLessRetainTotalSpelled

Applicable to Fixed Lump Sum and Cost Plus With GMP invoices only.

PrimeInvPercentComplete
PrimeInvBalanceToFinishSOVGrossSubtotal
PrimeInvBalanceToFinishCOsGrossSubtotal
PrimeInvBalanceToFinishGrossSubtotal (PrimeInvRevisedContractSubtotal - PrimeInvTotal)
PrimeInvBalanceToFinishSubtotal (PrimeInvRevisedContractSubtotal - (PrimeInvTotal - PrimeInvRetainTotal))
PrimeInvBalanceToFinishTaxTotal
PrimeInvBalanceToFinishTotal
PrimeInvLessRetainSubtotal (PrimeInvPreviousLessRetainSubtotal + PrimeInvCurrentLessRetainSubtotal)
PrimeInvLessRetainTaxTotal
PrimeInvLessRetainTotal

Bookmarks - Breakdown of PrimeInvCurrentLessRetainTaxTotal Per Tax Code

Click here for details.

Mail Merge Table - Linked Documents and Images

Only linked files and images that have grant access checked will be shown in the report.

Linked Documents Listing

Merge Table Start and End Tags: LinkedDocuments

Merge Fields:

DocumentName
DocumentDescription
DocumentUploadedBy
DocumentUploadDate

Linked Images Listing

Merge Table Start and End Tags: LinkedImages

Merge Fields:

DocumentName
DocumentDescription
DocumentUploadedBy
DocumentUploadDate
DocumentImage

Example Microsoft Word Template Showing Both Mail Merge Table Options

Mail Merge Table Fields - Job Cost Codes and Item Details

Merge Table Start and End Tags: PrimeInvItemsGrouped

Merge fields listed below do not include Taxation.

JCCOrderNumber
JCCCode
JCCDescription
JCCQuantity (Quantity listed on Job Cost Code table)
JCCUnit (Unit of Measure listed on Job Cost Code table)
RevisedContractItemUnitPrice
RevisedContractItemEstimatedQuantity
RevisedContractItemEstimatedValue (See note below)
RevisedContractItemPreviousBilledQuantity
RevisedContractItemCurrentBilledQuantity
RevisedContractItemTotalBilledQuantity (RevisedContractItemPreviousBilledQuantity + RevisedContractItemCurrentBilledQuantity)
RevisedContractItemPreviousTotal
RevisedContractItemCurrentTotal
RevisedContractItemTotal (RevisedContractItemPreviousTotal + RevisedContractItemCurrentTotal)
RevisedContractItemPreviousTotalRetainage
RevisedContractItemPreviousBilledRetainage
RevisedContractItemCurrentTotalRetainage
RevisedContractItemCurrentBilledRetainage (Billed retainage entered in the Prime Invoice JCC Summary table.)
RevisedContractItemTotalRetainage ((RevisedContractItemPreviousTotalRetainage - RevisedContractItemPreviousBilledRetainage) + (RevisedContractItemCurrentTotalRetainage - RevisedContractItemCurrentBilledRetainage))
RevisedContractItemCurrentTotalLessRetain
RevisedContractItemCurrentTotalLessRetainTax
RevisedContractItemCurrentTotalLessRetainTotal
RevisedContractItemPercentComplete
RevisedContractItemBalance (RevisedContractItemEstimatedValue - RevisedContractItemTotal)
RevisedContractItemBalanceQuantity (RevisedContractItemEstimatedQuantity - RevisedContractItemTotalBilledQuantity)
Original Contract Item Details:
- Mail Merge Sub-Table Start and End Tags: PrimeInvItems
- Mail Merge Sub-Table Fields:
  - ItemNumber
  - ItemCode
  - ItemDescription
  - ItemUnit
  - ItemUnitPrice
  - ItemEstimatedQuantity
  - ItemEstimatedTotal
  - ItemPreviousQuantity
  - ItemPreviousTotal
  - ItemQuantity
  - ItemTotal
  - ItemPercentComplete
  - ItemRetainage
  - ItemLessRetainageSubtotal
  - ItemLessRetainageTaxTotal
  - ItemLessRetainageTotal
  - ItemTotalQuantity (ItemPreviousQuantity + ItemQuantity)
  - ItemTotalTotal (ItemPreviousTotal + ItemTotal)
  - ItemRemainingQuantity (ItemEstimatedQuantity - ItemTotalQuantity)
  - ItemRemainingTotal (ItemEstimatedTotal - ItemTotalTotal)
  - ItemTaxCode
  - ItemOwnerCostCode
Approved CO Item Details:
- Mail Merge Sub-Table Start and End Tags: PrimeInvItemsCO
- Mail Merge Sub-Table Fields:
  - CONumber
  - ItemNumber
  - ItemCode
  - ItemDescription
  - ItemUnit
  - ItemUnitPrice
  - ItemEstimatedQuantity
  - ItemEstimatedTotal
  - ItemPreviousQuantity
  - ItemPreviousTotal
  - ItemQuantity
  - ItemTotal
  - ItemPercentComplete
  - ItemRetainage
  - ItemLessRetainageSubtotal
  - ItemLessRetainageTaxTotal
  - ItemLessRetainageTotal
  - ItemTotalQuantity (ItemPreviousQuantity + ItemQuantity)
  - ItemTotalTotal (ItemPreviousTotal + ItemTotal)
  - ItemRemainingQuantity (ItemEstimatedQuantity - ItemTotalQuantity)
  - ItemRemainingTotal (ItemEstimatedTotal - ItemTotalTotal)
  - ItemTaxCode
  - ItemOwnerCostCode

RevisedContractItemEstimatedValue is the unit price documented in the Prime Contract or CO Item's table depending on where it was initially created.