Microsoft Word Template - Subcontract Invoice - Fixed Lump Sum - Details Listed By Item Type

Default Templates

Default Word Document:SubInvoice-FLS-ItemDetails.dot
Default Word Document - Tax Broken Out:SubInvoice-FLS-ItemDetails.dot

Upload Feature Category:Subcontract Invoice - Fixed Lump Sum - Item Details

About bookmarks and mail merge fields

All bookmarks and mail merge fields are optional.
There's no limit on the number of times that bookmarks can be repeated. For example:
- 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 - Specific Address

PrimeContractAddress1
PrimeContractAddress2
PrimeContractCity
PrimeContractState
PrimeContractZipCode
PrimeContractCountry
PrimeContractPhone
PrimeContractFax

Bookmarks - Prime Contract - Referenced Owner or Client

OwnerPrefix
OwnerFirstName
OwnerMiddleName
OwnerLastName
OwnerSuffix
OwnerContact
OwnerTitle
OwnerMobilePhone
OwnerEmail
OwnerCompanyCode
OwnerCompany
OwnerAddress1
OwnerAddress2
OwnerCity
OwnerState
OwnerZipCode
OwnerCountry
OwnerPhone
OwnerPhone2
OwnerFax
OwnerWebsite
OwnerGovTaxID

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 module templates only):

The following bookmarks must use a white font so the e-Sign tag is clearly visible and not obstructed.

ArchitectE_Signature
ArchitectE_SignatureDate
ArchitectE_Initial

Bookmarks - Subcontract - Number, Type, Subject, and Scope

SubcontractNumber
SubcontractType
SubcontractWorkSubject
SubcontractWorkScope
SubcontractInclusions
SubcontractExclusions
SubcontractClarifications

Bookmarks - Subcontract - Status and Dates

SubcontractIssueDate
SubcontractIssueDateSpelled
SubcontractStatus
SubcontractSignedDate
SubcontractSignedDateSpelled
SubcontractNTPDate
SubcontractEstStartDate
SubcontractEstSubstantialCompletion
SubcontractEstFinishDate

Bookmarks - Subcontract - Retainage Percentages, Original Contract Amounts, Damages|Incentives Per Day

SubcontractWorkRetainagePercent
SubcontractMaterialRetainagePercent
SubcontractSubtotal
SubcontractSubtotalSpelled
SubcontractTaxTotal
SubcontractTaxTotalSpelled
SubcontractTotal
SubcontractTotalSpelled
SubcontractGMP
SubcontractLiquidDamagesPerDay
SubcontractIncentivePerDay

Bookmarks - Sub Invoice - From Company/Contact (Subcontractor)

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 - Sub Invoice - To Company/Contact (Prime Contractor)

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 - Sub Invoice - Number, Dates, Terms, Comments

SubInvNumber
SubInvOrderNumber
SubInvDate
SubInvDateSpelled
SubInvPaymentDueDate
SubInvPaymentDueDateSpelled
SubInvTerms
SubInvPrintComments
SubInvInternalComments

Bookmarks - Sub Invoice - Previous and Current Change Orders

SubInvPreviousSCOSubtotal
SubInvPreviousSCOTaxTotal
SubInvPreviousSCOTotal
SubInvCurrentSCOSubtotal
SubInvCurrentSCOTaxTotal
SubInvCurrentSCOTotal

Bookmarks - Sub Invoice - Revised Contract Totals

SubInvOriginalContractSubtotal
SubInvOriginalContractTaxTotal
SubInvOriginalContractTotal
SubInvNetChangesSubtotal (SubInvPreviousCOSubtotal + SubInvCurrentCOSubtotal)
SubInvNetChangesTaxTotal (SubInvPreviousCOTaxTotal + SubInvCurrentCOTaxTotal)
SubInvNetChangesTotal (SubInvPreviousCOTotal + SubInvCurrentCOTotal)
SubInvRevisedContractSubtotal
SubInvRevisedContractTaxTotal
SubInvRevisedContractTotal

Bookmarks - Sub Invoice - Gross Values - Previous Work Completed and Stored Materials

Bookmarks listed below do not include Retainage and Taxation.

SubInvPreviousWorkTotal
SubInvPreviousStoredTotal
SubInvPreviousTotal
SubInvPreviousBilledScheduleOfValues
SubInvPreviousBilledSCOs

Bookmarks - Sub Invoice - Gross Values - Current Work Completed and Stored Materials

Bookmarks listed below do not include Retainage and Taxation.

SubInvCurrentWorkTotal
SubInvCurrentStoredTotal
SubInvCurrentTotal
SubInvCurrentTotalSpelled
SubInvCurrentBilledScheduleOfValues
SubInvCurrentBilledSCOs

Bookmarks - Sub Invoice - Gross Values - Total Work Completed and Stored Materials

Bookmarks listed below do not include Retainage and Taxation.

SubInvWorkTotal
SubInvStoredTotal
SubInvTotal (SubInvWorkTotal + SubInvStoredTotal)
SubInvTotalBilledScheduleOfValues
SubInvTotalBilledSCOs

Bookmarks - Sub Invoice - Retainage Percentages

SubInvWorkRetainagePercent
SubInvMaterialRetainagePercent (Only applicable for Fixed Lump Sum Invoices)

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

Stored refers to Stored Materials.

SubInvPreviousRetainWorkTotal
SubInvPreviousRetainStoredTotal
SubInvPreviousRetainTotal
SubInvCurrentRetainWorkTotal
SubInvCurrentRetainStoredTotal
SubInvCurrentRetainTotal
SubInvRetainWorkTotal (Includes Billed Retainage)
SubInvRetainStoredTotal (Includes Billed Retainage)
SubInvRetainTotal (Includes Billed Retainage)

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

SubInvPreviousBilledRetainWorkTotal
SubInvPreviousBilledRetainStoredTotal
SubInvPreviousBilledRetainTotal
SubInvCurrentBilledRetainWorkTotal
SubInvCurrentBilledRetainStoredTotal
SubInvCurrentBilledRetainTotal
SubInvBilledRetainWorkTotal
SubInvBilledRetainStoredTotal
SubInvBilledRetainTotal

Bookmarks - Sub Invoice - Previous Net Values and Balance To Complete

SubInvPreviousLessRetainSubtotal
SubInvPreviousLessRetainTaxTotal
SubInvPreviousLessRetainTotal
SubInvPreviousBalanceToFinishSubtotal (includes Retainage)
SubInvPreviousBalanceToFinishTaxTotal
SubInvPreviousBalanceToFinishTotal

Bookmarks - Sub Invoice - Current Net Values and Balance To Complete

SubInvCurrentLessRetainSubtotal
SubInvCurrentLessRetainSubtotalSpelled
SubInvCurrentLessRetainTaxTotal
SubInvCurrentLessRetainTaxTotalSpelled
SubInvCurrentLessRetainTotal
SubInvCurrentLessRetainTotalSpelled

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

SubInvPercentComplete
SubInvBalanceToFinishSOVGrossSubtotal
SubInvBalanceToFinishSCOsGrossSubtotal
SubInvBalanceToFinishGrossSubtotal (SubInvRevisedContractSubtotal - SubInvTotal)
SubInvBalanceToFinishSubtotal (SubInvRevisedContractSubtotal - (SubInvTotal - SubInvRetainTotal))
SubInvBalanceToFinishTaxTotal
SubInvBalanceToFinishTotal
SubInvLessRetainSubtotal (SubInvPreviousLessRetainSubtotal + SubInvCurrentLessRetainSubtotal)
SubInvLessRetainTaxTotal
SubInvLessRetainTotal

Bookmarks - Breakdown of SubInvCurrentLessRetainTaxTotal Per Tax Code

Click here for details.

Mail Merge Table - Linked Documents and Images

The report includes only linked files and images that have the grant access option selected.

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

Microsoft Word template example including both mail merge table options.

Default Mail Merge Tables

Mail Merge Table Fields - Original Contract Items

Merge Table Start and End Tags: SubInvOriginalItems

Fields listed below do not include Taxation.

ItemNumber
ItemCode
ItemDescription
ItemUnit
ItemQuantity
ItemValue
ItemCostCode
ItemCostCodeDescription
PreviousWork
PreviousStored
PreviousTotal
CurrentWork
CurrentStored
CurrentTotal
CurrentRetainWork
CurrentRetainStored
CurrentRetainTotal
CurrentLessRetainageSubtotal
TotalCompleted
PercentComplete
BalanceToFinish

Mail Merge Table Fields - SCO Summary

Merge Table Start and End Tags: SubInvSCO

Fields listed below do not include Taxation.

SCONumber
ItemDescription
ItemValue
PreviousWork
PreviousStored
PreviousTotal
CurrentWork
CurrentStored
CurrentTotal
CurrentRetainWork
CurrentRetainStored
CurrentRetainTotal
CurrentLessRetainageSubtotal
TotalCompleted
PercentComplete
BalanceToFinish

Mail Merge Table Fields - Billed Retainage By Job Cost Code

Merge Table Start and End Tags: SubInvBilledRetainage

Fields listed below do not include Taxation.

ItemNumber
JCCCode
JCCDescription
JCCPreviousRetainWorkTotal
JCCPreviousRetainStoredTotal
JCCPreviousRetainTotal (JCCPreviousRetainWorkTotal + JCCPreviousRetainStoredTotal)
JCCCurrentRetainWorkTotal (Excludes Current Billed Work Retainage)
JCCCurrentRetainStoredTotal (Excludes Current Billed Stored Retainage)
JCCCurrentRetainTotal (JCCCurrentRetainWorkTotal + JCCCurrentRetainStoredTotal)
JCCCurrentBilledRetainWork
JCCCurrentBilledRetainStored
JCCCurrentBilledRetainTotal (JCCCurrentBilledRetainWork + JCCCurrentBilledRetainStored)
JCCRetainWorkTotal (JCCPreviousRetainWorkTotal + JCCCurrentRetainWorkTotal - JCCCurrentBilledRetainWork)
JCCRetainStoredTotal (JCCPreviousRetainStoredTotal + JCCCurrentRetainStoredTotal - JCCCurrentBilledRetainStored)
JCCRetainTotal (JCCPreviousRetainTotal + JCCCurrentRetainTotal - JCCCurrentBilledRetainTotal)

Optional Mail Merge Tables

Mail Merge Table Fields - SCO Line Items

Merge Table Start and End Tags: SubInvSCOItems

Fields listed below do not include Taxation.

SCONumber
ItemNumber
ItemDescription
ItemQuantity
ItemUnit
ItemUnitPrice
ItemValue
ItemCostCode
ItemCostCodeDescription
PreviousWork
PreviousStored
PreviousTotal
CurrentWork
CurrentStored
CurrentTotal
CurrentRetainWork
CurrentRetainStored
CurrentRetainTotal
CurrentTotalLessRetain
TotalCompleted
BalanceToFinish
PercentComplete

Mail Merge Table Fields - Job Cost Codes

Merge Table Start and End Tags: SubInvItemsSummary

Merge fields listed below do not include Taxation.

JCCOrderNumber
JCCCode
JCCDescription
JCCOriginalValue (Sum of Original Contract Items By Job Cost Code)
JCCNetChangeValue (Sum of Approved SCO Items By Job Cost Code)
JCCRevisedContractTotal (JCCOriginalValue + JCCNetChangeValue)
JCCPreviousWorkTotal (Excludes Retainage)
JCCPreviousStoredTotal (Excludes Retainage)
JCCPreviousTotal (JCCPreviousWorkTotal + JCCPreviousStoredTotal)
JCCPreviousRetainWorkTotal
JCCPreviousRetainStoredTotal
JCCPreviousRetainTotal (JCCPreviousRetainWorkTotal + JCCPreviousRetainStoredTotal)
JCCPreviousTotalLessRetain (JCCPreviousTotal - JCCPreviousRetainTotal)
JCCCurrentWorkTotal (Excludes Retainage)
JCCCurrentStoredTotal (Excludes Retainage)
JCCCurrentTotal (JCCCurrentWorkTotal + JCCCurrentStoredTotal)
JCCCurrentRetainWorkTotal (Current Work Retainage Total Excluding Current Billed Work Retainage)
JCCCurrentRetainStoredTotal (Current Stored Material Retainage Total Excluding Current Billed Stored Retainage)
JCCCurrentRetainTotal (JCCCurrentRetainWorkTotal + JCCCurrentRetainStoredTotal)
JCCCurrentBilledRetainWork
JCCCurrentBilledRetainStored
JCCCurrentBilledRetainTotal (JCCCurrentBilledRetainWork + JCCCurrentBilledRetainStored)
JCCCurrentTotalLessRetain (JCCCurrentTotal + JCCCurrentBilledRetainTotal - JCCCurrentRetainTotal)
JCCWorkTotal (JCCPreviousWorkTotal + JCCCurrentWorkTotal)
JCCStoredTotal (JCCPreviousStoredTotal + JCCCurrentStoredTotal)
JCCTotal (JCCPreviousTotal + JCCCurrentTotal)
JCCRetainWorkTotal (JCCPreviousRetainWorkTotal + JCCCurrentRetainWorkTotal - JCCCurrentBilledRetainWork)
JCCRetainStoredTotal (JCCPreviousRetainStoredTotal + JCCCurrentRetainStoredTotal - JCCCurrentBilledRetainStored)
JCCRetainTotal (JCCPreviousRetainTotal + JCCCurrentRetainTotal - JCCCurrentBilledRetainTotal)
JCCTotalLessRetain (JCCTotal - JCCRetainTotal)
JCCBalanceToFinish (JCCRevisedContractTotal - JCCTotal)
JCCPercentComplete ((JCCTotal / JCCRevisedContractTotal) * 100)