How to Track Brand Deals Without Losing a Payment

Brand deals rarely go wrong in the negotiation. They go wrong afterward: a deliverable slips past its due date, a finished campaign never gets invoiced, a payment goes 45 days overdue before anyone notices. A good brand deal tracker exists to catch those three failures.

This guide covers what to record, how to structure a spreadsheet version, and where spreadsheets start to strain.

What to record for every deal

At minimum, each deal needs:

• Sponsor and contact: company, contact name, and email.
• Stage: where the conversation stands.
• Fee: the agreed amount and currency.
• Deliverables: each promised placement or post, with a due date.
• Terms: usage rights, exclusivity, and how long each lasts.
• Next action: the one thing you owe next, with a date.
• Invoice and payment: invoice number, date sent, payment terms, due date, status, and date paid.
• Proof: a link to each placement once it goes out.

The next action field does more work than it looks. Most stalled deals are not rejected. They are waiting on a reply, a draft, or an invoice that nobody scheduled.

Keep delivery and payment separate

The most common tracker mistake is a single status column that runs from "pitched" to "done". Delivery and payment are two different questions:

Delivery	Payment	What it means
Delivered	Not invoiced	You did the work and never asked for the money
Delivered	Awaiting	Invoice sent, still inside terms
Delivered	Overdue	Past the due date, needs a follow-up
In progress	Paid	Paid upfront, work still owed

With one combined column, the first row looks finished. That is how invoices get lost.

A spreadsheet brand deal tracker

If you are starting in a spreadsheet, use two tabs.

Deals tab, one row per deal, with these columns from A to M:

Sponsor | Contact | Stage | Fee | Usage rights | Exclusivity | Next action | Next action date | Invoice # | Invoice date | Payment due | Payment status | Paid date

Suggested stages: Pitching, Negotiating, Signed, Delivered, Declined. Suggested payment statuses: Not invoiced, Awaiting, Paid.

Deliverables tab, one row per promised placement:

Sponsor | Type | Platform | Due date | Status | Published link

Types to cover: newsletter placement, dedicated email, social post.

Two formulas worth adding to the Deals tab:

Days past due (row 2):      =IF(OR(L2="Paid", K2=""), 0, MAX(0, TODAY()-K2))
Delivered but unpaid total: =SUMIFS(D:D, C:C, "Delivered", L:L, "<>Paid")

Then add conditional formatting that highlights a row in red when the payment due date has passed and the status is not Paid. That single rule catches most lost revenue.

Where spreadsheets strain

A spreadsheet works well for a handful of deals. It gets harder as volume grows, because the deal, the draft, the scheduled post, and the sent edition live in different places. The published link has to be copied in by hand, due dates in the sheet drift away from your content calendar, and building a performance summary for the sponsor means pulling numbers from your newsletter platform each time.

Show the sponsor what ran

Sponsors renew when they can see what they got. After a placement goes out, share the numbers your newsletter provider reports for that edition: recipients, opens, and clicks on the sponsor's link. Say which platform reported them. Do not claim sales you cannot see, and do not present a scheduled post as delivered proof.

For pricing the next package, the sponsor rate calculator builds a rate from your delivered reach and your own assumptions.

Doing this in Distinctful

Deals keeps the tracker next to the content it promises:

• Move each deal through Pitching, Negotiating, Signed, and Paid. Payment status is separate from delivery, so delivered work that was never invoiced shows as Not invoiced, and an unpaid invoice past its due date shows as Payment overdue.
• Give each deal a next action with a date.
• Add deliverables (newsletter placement, dedicated email, or social post) with due dates. Link a social deliverable to a content card on the Calendar, and link a newsletter placement to the sent edition from Beehiiv or Kit.
• Once a linked edition has sent, create a sponsor report: a shareable summary of recipients, opens, and sponsor-link clicks that you can revoke at any time.

Distinctful does not process sponsor payments or send invoices. It keeps track of what was promised, what ran, and what is still owed.