Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesConstruction & EngineeringConstruction Project ManagementSubcontractor Payment Tracker

SpreadsheetConstruction Project ManagementFree

Subcontractor Payment Tracker

Subcontract values with approved change orders, value earned from percent complete, retainage held, payments logged and the amount due now, with over-payment warnings.

Shown with sample data

Colour

Subcontractor Payment Tracker

Subcontract values with approved change orders, value earned from percent complete, retainage held, payments logged and the amount due now, with over-payment warnings.

Committed
$208,350
Including approved changes
Paid to date
$62,535
Retainage held
$6,276
Due now
$11,597
Paid to date by subcontractor
  • GroundTech$33,535
  • FrameRight$25,000
  • Bright Spark Ltd$4,000
Balance to complete
  • Bright Spark Ltd$45,650
  • FlowRight$36,400
  • Smooth Walls$22,800
  • FrameRight$21,000
  • TopRoof$18,200
  • GroundTech$1,765

How to use it

  1. 1List each subcontract with trade, original contract value and retainage rate.
  2. 2Log every change order with status; only Approved changes are added to the contract.
  3. 3Each month, agree percent complete on site, then check Due now against the pay application.
  4. 4Log each payment with date, application number and amount.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Control what you pay subcontractors. Each subcontract has its original value and retainage rate; approved change orders are added from the change order log to give the revised value. Update percent complete and the tracker works out value earned, retainage held, what has been paid from the payments log, and what is due now. Anyone paid ahead of their progress is flagged, and the balance to complete shows your remaining commitment.

Who it’s for

  • General contractors paying trades monthly
  • Checking pay applications before approval
  • Tracking retainage to release at completion

What’s included

  • Subcontracts sheet: Each subcontract with earned value, retainage and payments.
  • Change orders sheet: Every change order and its status.
  • Payments sheet: Every payment made to subcontractors.

How to use it

  1. 1List each subcontract with trade, original contract value and retainage rate.
  2. 2Log every change order with status; only Approved changes are added to the contract.
  3. 3Each month, agree percent complete on site, then check Due now against the pay application.
  4. 4Log each payment with date, application number and amount.

Tips

  • Never pay ahead of verified progress: Overpaid means you are carrying the subcontractor's risk.
  • Release retainage only after snagging is complete and lien waivers are received.

Questions

How is Due now worked out?

Value earned (revised value × percent complete) minus retainage held minus what has already been paid.

Are pending change orders included?

No. Only Approved change orders are added to the revised value; pending ones are shown separately.

Related searchessubcontractor paymentsretainagepay applicationconstruction accountingchange ordersprogress payments

Details

Format
Spreadsheet
Category
Construction Project Management
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetConstruction Project ManagementFree

Subcontractor Payment Tracker

Subcontract values with approved change orders, value earned from percent complete, retainage held, payments logged and the amount due now, with over-payment warnings.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Construction Project Management
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More construction project management templates

View all
Construction Project Schedule
Task
SepOctNovDecJanFebMar
Permits and mobilisation
Excavation and footings
Slab pour and cure
Framing and sheathing
Roofing
Windows and exterior doors
SpreadsheetConstruction Project Management

Construction Project Schedule

The build programme with planned and actual dates, progress weighted by duration, behind-schedule flags, a month-by-month bar chart and phase summaries.

10 min setupPreview
RFI Log2 sheets

Open RFIs

4

Overdue responses

2

Average days to answer

10.3

ABCD
1RFIRaisedSubjectCategory
2RFI-001Oct 5Slab edge detail at grid line C clashes with drainageStructural
3RFI-002Oct 9Door D14 hardware schedule missingArchitectural
4RFI-003Oct 20Ceiling void too shallow for specified ductwork, level 2Mechanical & electrical
5RFI-004Oct 28Confirm brick type for east elevation; sample rejectedArchitectural
RFIs
SpreadsheetConstruction Project Management

RFI Log

Track every request for information from question to answer, with due dates and cost and schedule impact.

10 min setupPreview
Schedule of Values & Payment Application2 sheets

Contract sum

$1,200,000

Completed to date

52%

Payment due this application

$173,070

ABCD
1ItemDescription of workCategoryScheduled value
21General conditions and supervisionGeneral conditions$85,000
32Site clearance and excavationSite work$62,000
43Foundations and slabStructure$148,000
54Structural steel frameStructure$215,000
Schedule of values
SpreadsheetConstruction Project Management

Schedule of Values & Payment Application

Bill progress against each line of the contract: work completed, stored materials, retainage and payment due.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ