Free lien waiver tracking spreadsheet (and when to stop using one)

Here's a free lien waiver tracking spreadsheet built for general contractors. Open it in Excel, Google Sheets, or Numbers, and you've got a working tracker for conditional and unconditional waivers with a status column that updates itself across every job.

One honest note up front: a spreadsheet is the right tool for this until it isn't. It holds up beautifully at two or three active jobs. Somewhere around five, it starts to crack. This post gives you the template, shows you how to run it, and tells you the exact point where you'll outgrow it, because pretending you won't is how GCs end up with a lien on a client's property.

What's in the spreadsheet template?

Two tabs. The first, Waiver Tracker, is the grid. One row per sub per pay period, with columns for:

• Project, sub or supplier, and Tier (direct sub vs. sub-tier supplier)
• State, with a Statutory form? flag that tells you when a state requires its own prescribed language instead of a standard form
• Pay app number, through-date, amount, and a retainage percent that fills in retainage withheld for you
• The three dates that run the whole process: conditional sent, payment cleared, unconditional sent
• A Status column that fills itself in

The second tab, How to use, has the rules written out so anyone on your team can pick it up.

The status column is the useful part. It reads your dates and tells you where each waiver stands:

Status	What it means
Send conditional	Nothing sent yet for this row
Awaiting payment	Conditional sent, draw hasn't cleared
Need unconditional	Draw cleared, unconditional not sent. Act on these
Closed	Unconditional on file, done

Sort by Status and your open exposures rise to the top. The "Need unconditional" rows are the ones that turn into disputes if you forget them.

How do you run it?

The cycle is the same for every sub, every period, and it's the front half of the lien waiver process:

1. 1

   Send conditional

   Send the conditional waiver with the pay app. Log the date sent.

2. 2

   Payment clears

   Log the date the funds are verified in the bank, not when the check lands.

3. 3

   Get unconditional

   Send the unconditional waiver and log that date.

4. Repeat

   Repeat each period until the job closes out.

Two details people miss. First, add a row for every sub-tier supplier, not just your direct subs. Your sub's waiver releases their rights, not their supplier's, and an unpaid supplier can still lien the job. Second, keep retainage separate so a progress waiver doesn't release the 10% you haven't paid yet. The conditional progress waiver post covers why that carve-out matters.

The one rule that makes any tracker work

Where does the spreadsheet stop holding up?

The math is what gets you. One sub across one job is three dates to track. Ten subs across ten jobs, each with two or three suppliers, is over a thousand individual waiver states a quarter. No spreadsheet survives that without a missed cell, and a missed cell is a missed waiver.

The break points are predictable:

Why lien waiver tracking breaks at 5+ active jobs walks through the four places it cracks in detail.

The lien waiver process, step by step runs from picking the type to filing the signed waiver.

When should you stop tracking lien waivers by hand?

When you hit those break points, the fix isn't a fancier spreadsheet. It's software that does the tracking for you.

	Spreadsheet	Lien waiver software
Form selection	You look up each state's statute and form	Picks the right form for the state and payment stage
Follow-up	You email each sub	Automatic reminders to subs who haven't signed
Status	You type in every date	A live dashboard shows who has signed
PDF storage	Folders on your desktop	The signed PDF is attached to the project

LienDone's lien waiver software picks the right of the four forms for the state and payment stage, shows who has signed and who hasn't so "no waiver, no check" is a glance at the dashboard instead of a hunt, and tracks every sub and sub-tier supplier across every job in one place. No stale cells, no row someone forgot to update. And if part of what your spreadsheet tracks is lien exposure windows, the free lien deadline calculator turns each sub's last day on site into a filing deadline you can calendar.

The spreadsheet is a great place to start. When chasing waivers by email turns into a part-time job, send the link instead, watch the dashboard, and release the payment. That's the whole loop. For the GC's full playbook on collecting from subs, see lien waivers for subcontractors.