Schedule of Values Template, Pay Application G702 G703 Style, Progress Billing, Retainage, Excel Google Sheets

Schedule of values & pay application for Excel & Google Sheets: G702/G703-style progress billing with retainage, stored materials and change orders.

Progress billing GCs and lenders accept – G702 / G703 style

A schedule of values with retainage, change orders that flow in, and a printable application and certificate for payment.

WHO IT'S FOR
Subs and GCs billing against a schedule of values

SOUNDS FAMILIAR?
✕ Your invoice gets rejected because it isn't a pay app
✕ Retainage and previous applications are recomputed every month
✕ Change orders never make it onto the schedule

WHAT THIS PACK FIXES
✓ Continuation sheet with previous, this period, stored, % complete, balance
✓ Retainage and current payment due calculated
✓ Change orders listed automatically

SCHEDULE OF VALUES + PAY APPLICATION – WHAT YOU GET
• Schedule of Values + Pay Application.xlsx: Settings (company, project, owner, contract sum, retainage on work and on stored materials, this application's number, period and previous certificates) → Change Orders (approved COs: additions, deductions, net, split into previous periods and this period) → Schedule of Values (40 lines + change-order lines: scheduled value, previous applications, this period, stored materials, total completed and stored, % complete, balance to finish, retainage; a check row against contract sum + COs; over-billed lines turn red; a roll-forward column for the next application) → Pay Application (print) (the G702-style page: contract sum to date, completed and stored, retainage, earned less retainage, previous certificates, current payment due, balance to finish; change order summary; contractor certification, notary block, owner / architect certificate).
• EXAMPLE - Pay Application 2 (Rasmussen kitchen).xlsx: Application #2 on a kitchen remodel: four SOV lines plus two change orders, 10% retainage, the deposit as the previous certificate – $4,456.69 due, matching the Contractor Invoice example (sold separately in our shop).
• START HERE PDF: what's in the download, how to open it in Excel / Google Sheets or Word / Google Docs, a quick start and tips

HOW TO ACCESS
Instant digital download – nothing ships. After checkout Etsy shows a Download button, and the files stay under Purchases & Reviews on etsy.com (downloads don't work in the Etsy app – use a browser). The download is a ZIP: extract it first (Windows: right-click → Extract All; Mac: double-click), then open the files in Excel or Google Sheets and Word or Google Docs. Set it up once on a laptop, then use it anywhere. Because it's a digital file, returns aren't possible – but if something doesn't open or you're stuck, message us and we'll sort it out.

GET THE WHOLE SET
This pack is part of the Everything Bundle – all 42 Trade Templates Co. packs for $199 – and the Contractor Office Bundle ($109) and the Pricing & Profit Bundle ($39). Search our shop for "bundle".

Questions before you buy? Message us – we answer within a day.

AI disclosure: these templates were built with the assistance of AI tools and reviewed, tested and edited by the seller.