Freelancer & Writer Assignment Tracker

The problem this kills

You manage a roster of freelance writers and designers, and right now your "system" is a tangle of email threads, a shared spreadsheet that's three versions out of date, and a nagging feeling that you've double-booked someone. You can't quickly answer the questions that matter: Who has room for this brief? Who's best at it? Have we already paid this invoice? How much have we committed to spend this month?

So things slip. A writer gets overloaded and misses a deadline. A brief sits unassigned because you forgot it existed. An invoice gets paid twice because it came in under two slightly different subject lines. Finance asks for a clean list of what's payable and you spend an afternoon copy-pasting from your inbox.

This kills all of that. One place to assign work by fit and capacity, approve deliverables and invoices on purpose, and hand finance a clean, deduplicated CSV.

What you'll build

A private web app that only your team can log into. You load your freelancer roster and your briefs. For each brief, the app suggests the best-fit freelancer based on specialty match and remaining capacity - and warns you loudly if assigning would push someone over their capacity or over an agreed monthly budget. You, the content manager, approve the assignment (nothing gets committed without you).

When the freelancer delivers, you review the deliverable and the invoice line, approve it, and it becomes a payable record. The app tracks total committed spend across your roster and flags duplicate invoices before they ever reach finance. When you're ready, you export an AP-ready CSV in exactly the columns your finance team expects.

What's inside the Implementation Plan

The plan is a step-by-step runbook you paste into an AI coding agent (Claude Code), which then builds the whole tool for you. It opens by interviewing you about your actual content operation - your current process, the systems and spreadsheets you use, how you name and rate freelancers, your real capacity and budget rules, and your messy edge cases (rush jobs, kill fees, multi-part briefs). It reflects a short tailored spec back to you for a thumbs-up, then builds the tool around your roster and your rules - not a generic template.

Inside you get: the discovery interview, the database design, the best-fit suggestion logic, the assignment and invoice approval gates, the over-capacity and over-budget warnings, the duplicate-invoice guard, and the AP-ready CSV export. Every build step ends with a ready-to-paste prompt.

The governance it includes (this is the point)

This isn't a toy. Governance is built in from the first step:

• Login so only your team can use the tool.
• Row-level security so each organization only ever sees its own freelancers, briefs, and invoices.
• A complete audit trail - who assigned what, who approved which invoice, and when.
• A human-in-the-loop approval gate - the app drafts the best-fit suggestion and the payable record, but nothing is committed until a person reviews and approves it.
• Duplicate guards - the same brief can't be assigned to the same writer twice, and a repeated invoice number gets flagged before it can be paid.

Who it's for

Content operations managers, marketing ops leads, and editorial coordinators who run a roster of freelance writers or designers and have outgrown the email-plus-spreadsheet approach - but don't have (or want to wait for) a developer to build them a real system.

You've got this - paste the first prompt and let the agent interview you.