Subcontractor Documentation Tracker

Keep every subcontractor’s contract, insurance, licences and lien waivers on file, with expiry countdowns so nobody works uninsured.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Construction

Tables

Subcontractors, Documents

Fields

21

Views

grid, kanban, calendar, form

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Subcontractors

11 fields · 4 sample rows

  • Subcontractors (Grid)
CompanyTextTradeSingle selectContact personTextEmailEmailPhonePhoneContract valueCurrencyDocumentsLink to another tableDocuments on fileCountApproved docsRollupNext expiryRollupComplianceFormula
Volt ElectricalsElectricalSanjay Pawar[email protected]+91 98230 11111₹56,50,000Signed subcontract, CAR & WC insurance policy, Electrical contractor licence3318 May 2027Compliant
AquaFix PlumbingPlumbingRafiq Shaikh[email protected]+91 98230 22222₹37,80,000Workmen compensation policy, Site safety plan211 Dec 2026Action needed
ClearView GlazingGlazingHannah Lewis[email protected]+971 50 555 0133₹89,00,000Performance bank guarantee, Insurance certificate214 Nov 2026Action needed
CoolAir SystemsHVACPrakash Rao[email protected]₹41,00,000Signed subcontract10Action needed
Field details
Company · Text
Trade · Single select
Civil, Electrical, Plumbing, HVAC, Carpentry, Drywall & painting, Flooring & tiling, Glazing and 1 more
Contact person · Text
Email · Email
Phone · Phone
Contract value · Currency
INR
Documents · Link to another table
Links to Documents
Documents on file · Count
Approved docs · Rollup
sum of Approved flag via Documents
Next expiry · Rollup
earliest of Expiry date via Documents
Compliance · Formula
IF({Documents on file} = 0, 'Missing documents', IF({Approved docs} = {Documents on file}, 'Compliant', 'Action needed'))

Documents

10 fields · 8 sample rows

  • All documents (Grid)
  • Expiring in 60 days (Grid)
  • Status board (Kanban)
  • Expiry calendar (Calendar)
  • Upload a document (Form)
DocumentTextSubcontractorLink to another tableTypeSingle selectReceived onDateExpiry dateDateDays to expiryFormulaStatusSingle selectApproved flagFormulaFileAttachmentNotesText
Signed subcontractVolt ElectricalsSubcontract agreement21 Aug 2026Approved1
CAR & WC insurance policyVolt ElectricalsInsurance certificate21 Aug 202618 May 2027180Approved1
Electrical contractor licenceVolt ElectricalsTrade licence21 Aug 202624 Dec 2027400Approved1
Workmen compensation policyAquaFix PlumbingInsurance certificate3 May 20261 Dec 202612Approved1Renewal requested
Site safety planAquaFix PlumbingSafety plan9 Nov 2026Received0
Performance bank guaranteeClearView GlazingPerformance bond20 Oct 202620 Oct 2027335Approved1
Insurance certificateClearView GlazingInsurance certificate4 Nov 20254 Nov 2026-15Expired0
Signed subcontractCoolAir SystemsSubcontract agreementRequested0
Field details
Document · Text
Subcontractor · Link to another table
Links to Subcontractors
Type · Single select
Subcontract agreement, Insurance certificate, Trade licence, GST / PAN, Safety plan, Lien waiver, Performance bond
Received on · Date
Expiry date · Date
Days to expiry · Formula
IF({Expiry date}, DATETIME_DIFF({Expiry date}, TODAY(), 'days'), BLANK())
Status · Single select
Requested, Received, Approved, Rejected, Expired
Approved flag · Formula
IF(AND({Status} = 'Approved', OR(NOT({Expiry date}), {Days to expiry} >= 0)), 1, 0)
File · Attachment
Notes · Text

Form view “Upload compliance document” asks for: Document, Subcontractor, Type, Expiry date, File, Notes.

Subcontractor Documentation Tracker: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates