Project Tracker for Agencies: Every Deliverable, One Board

Monday morning at an agency starts with the same question in eleven Slack threads: "Where's the [thing] for [client]?" The landing page for the SaaS account is in internal review. The Q3 email sequence went to the client for approval nine days ago and vanished into someone's inbox. Two designers are drowning while a third is quietly between briefs. And the account manager finds all of this out live, on the client call.

The deliverables spreadsheet was supposed to prevent this, and to be fair, it half does. Every agency has one — rows of deliverables, a stage column, a due date, an owner. It's accurate whenever someone remembers to update it, which is to say it's accurate on Mondays. The real killers are the things a flat sheet can't show: which approvals have been sitting with clients long enough to blow the timeline, and whose plate is actually full versus who just sounds busy.

Agency project management platforms solve this for roughly $10 per person per month, which for a fifteen-person shop is $1,800 a year of margin — plus the onboarding project nobody bills for. The alternative: keep the deliverables sheet and let AI build the agency views on top of it.

Step 1: Start With Your Deliverables Sheet

One row per deliverable, columns like:

Keep whatever extra columns you've accumulated — retainer bucket, channel, revision notes. Nothing gets restructured; the sheet becomes the tracker's database and stays a working spreadsheet throughout.

Step 2: Create a Free Account

Sign up free at lovespreadsheets.com. The free tier builds and runs the tracker; team logins and a custom domain (nice when clients might glimpse a screen share) are the paid upgrades.

Step 3: Describe How Work Ships

Pick the Project Tracker template and lay out your pipeline the way you would for a new PM:

• "Everything moves Brief, then In production, then Internal review, then Client approval, then Live."
• "The Waiting-on column says whose court the ball is in — us, the client, or a vendor."
• "Hours budgeted comes from the retainer. When actuals blow past it, we need to know before the month closes, not after."

Then ask for the views that make it an agency tool rather than a task list:

• A board per client, stages as columns — so prep for any client call is thirty seconds of scrolling one board
• Approval-aging flags: anything sitting in Client approval past three business days gets highlighted and triggers an email nudge to the owner
• A workload-by-owner view that counts open deliverables and budgeted hours per person, so rebalancing happens from data instead of vibes

Use AI Optimize to tighten the description, field a clarifying question or two from the AI, and the build takes around 15–20 minutes.

Step 4: The Monday Question Answers Itself

You get a URL that becomes the agency's front page for work. Account managers open a client's board before every call and see exactly what's live, what's in production, and what's stalled in approval — with the stalls flagged in advance instead of discovered on the call. Creatives update their own rows as work moves, and each update lands in the sheet in real time; each sheet edit flows back the other way.

Ops still runs formulas, pivot tables, and month-end retainer math in the spreadsheet, because the spreadsheet never went anywhere.

Why Agencies Keep the Sheet

Headcount churn is expensive in per-seat tools. Agencies flex with contractors and freelancers constantly; every temporary hand is a new paid seat somewhere. A tracker that lives on your own sheet doesn't care how many hands touch it this month.

Reporting already lives there. Your retainer burn formulas, your utilization pivot, your month-end client summary — all of it keeps working, now fed by data the whole team actually updates.

Client history survives. Two years of shipped deliverables don't get abandoned in an old tool or shoveled through a CSV import. They're in the tracker from minute one because the tracker is the sheet.

Common Questions from Agencies

Can clients see their own board? If you want. Per-person views and permissions can scope a login to a single client's deliverables — a lightweight client portal without buying one.

How do we track hours against the budget? Add an hours-logged column, or keep your existing one, and ask for a view comparing it to hours budgeted. Overruns become visible mid-month.

What if different clients have different stages? Describe that in Step 3. One retainer client can run a five-stage flow while a project client runs three; the AI builds around your columns, not a fixed pipeline.

Build Yours

Open the deliverables sheet, go to lovespreadsheets.com, and describe how work moves from brief to live. In about twenty minutes the whole agency sees the same board — and the nine-day approval black hole finally has a flashing light on it.