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

Here's a free lien waiver tracking spreadsheet built for general contractors. No email, no signup. Download it, open it in Excel or Google Sheets, and you've got a working tracker for conditional and unconditional waivers across every job.

⬇ Download the lien waiver tracking spreadsheet (.xlsx)

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 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)
• Pay app number, through-date, amount, and retainage withheld
• 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 to run it

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

1. Send the conditional waiver with the pay app. Log the date.
2. When the draw clears, log the payment cleared date. Only when the funds are actually verified, not when the check lands.
3. Send the unconditional waiver and log that date.
4. 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

A spreadsheet doesn't fix a broken process. This rule does: no check leaves until the conditional waiver is on file, and no next pay cycle starts until the prior unconditional is back. Write it down, share it with subs at onboarding, and most waiver problems disappear inside one pay period. The tracker just shows you whether you're following it.

Where the spreadsheet stops 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:

• Past ~5 active jobs, the parallel conditional/unconditional states get too many to hold in your head.
• More than two people sending waivers, and the file goes stale between updates.
• The first time a missed waiver costs you a payment cycle or a lien on a client's property.

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

When to stop tracking by hand

When you hit those break points, the fix isn't a fancier spreadsheet. It's software that does the tracking for you. LienDone sends the right of the four forms automatically by phase and payment status, gates the payment on the signed waiver so the "no waiver, no check" rule enforces itself, and tracks every sub and sub-tier supplier across every job in one place. No stale cells, no row someone forgot to update.

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.

FAQ

Is the lien waiver tracking spreadsheet really free?

Yes. Download it, no email or signup. It's an .xlsx that opens in Excel, Google Sheets, and Numbers.

What does the spreadsheet track?

Every sub and sub-tier supplier, the pay app, through-date, amount, retainage, and the conditional-sent, payment-cleared, and unconditional-sent dates. A status column updates itself.

How many projects can I track with a spreadsheet?

Two or three comfortably. By four or five active jobs, the parallel waiver states get too many to track by hand.

Does the spreadsheet handle sub-tier suppliers?

Yes, via the Tier column. Add a row for each supplier, since an unpaid one can lien the job even after you've paid your sub.

When should I stop tracking lien waivers in a spreadsheet?

Past about five active jobs, when more than two people send waivers, or after a missed waiver has already cost you a payment cycle.