Contract sum
$1,200,000
Completed to date
52%
Payment due this application
$173,070
Schedule of Values & Payment Application
Bill progress against each line of the contract: work completed, stored materials, retainage and payment due.
5 free schedule schedule of values templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 5 spreadsheets from Construction Project Management, Warehouse Management and Accounting & Bookkeeping. Start with Schedule of Values & Payment Application, Cycle Count Schedule and Variance Report and Fixed Asset Register with Depreciation: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Contract sum
$1,200,000
Completed to date
52%
Payment due this application
$173,070
Bill progress against each line of the contract: work completed, stored materials, retainage and payment due.
Inventory accuracy
80%
Net variance value
-$303
Gross variance value
$303
Schedule counts by ABC class, record counted versus system quantity, and see variance in units, value and percent with inventory accuracy.
Cost of assets in use
$98,700
Net book value
$50,956
Depreciation this year
$12,417
Every asset with cost, useful life, straight-line depreciation to date and net book value.
Budget at completion
$820,000
Earned value
$409,350
Project CPI
0.9
PV, EV, AC, cost and schedule variance, CPI, SPI, EAC, ETC and VAC for every work package and the whole project.
Contracted
$19,050
Paid so far
$8,250
Still owed
$10,800
Every vendor with contacts, contract status and value, a payments log, balances and due-date alerts, and budget against spend by service.