Contract Progress Tracker

Contract / client

Start date

Duration (months)

Contract amount (₱)

Cut-off date (applies to all contracts, blank = today)

Item	Contract	Project amount	Computed %	Final % (change here)	Remaining %	Done (final)	Remaining (final)

Completed

Item	Contract	Project amount	Computed %	Final % (change here)	Remaining %	Done (final)	Remaining (final)

Computed % comes from the Ongoing tab. Type the whole-number % you’ll use in the final documents. Done = project amount × final %, Remaining = project amount − Done.

Contract	Start	Duration	Actual (100%)	Months rendered	Done	Remaining

Completed

Contract	Start	Duration	Actual (100%)	Months rendered	Done	Remaining

Months rendered = full months from start date + whole weeks of leftover days × 0.25 (e.g. 15 months + 22 days = 15.75). Done = amount × months rendered ÷ duration. Capped at the duration.