Brand-Deal & Sponsorship Tracker

$19.00

a creator, or the manager running two or three creators, closing 15 to 60 brand deals a year in a spreadsheet nobody re-sums after a campaign wraps.

Local-firstNo telemetry — nothing phones homeNo lock-inNo migration

Point it at your deal log and it writes OUTSTANDING.md: every signed and delivered post that hasn’t been paid yet, with the overdue ones flagged against their due date.

$19 per user, per month. Covers the pipeline totals, the outstanding list, the overdue flags and the rate card. Cancel any day. The reports stay in your output folder, because that is where they were written in the first place.

The post went up in March. Did the money ever land?

You shot it, you posted it, the brand loved it. Then the campaign moved on and so did you.

Four months later somebody asks what you made last quarter and you go looking. The deal lives in a DM, the rate lives in an email thread, and the invoice, if you sent one, is a PDF in a folder named after the brand. Nothing anywhere says whether the money arrived.

Sponsorship income goes missing the same way every time. Not to a bad contract. To a delivered post nobody ever chased, because there was no list of delivered posts and no list of who still owes.

How do your deals get in?

  1. Export your deal log to CSV. Columns Brand, Stage, Value, Deliverable, Due, Paid, Date. Different headers on your sheet? Override each one with COL_BRAND, COL_STAGE, COL_VALUE and the rest, so you can leave the spreadsheet the way you like it.
  2. Set two paths. DEALS_CSV and OUTPUT_FOLDER in a .env file, then run it.
  3. Open OUTSTANDING.md. Every deal parked at signed or delivered with Paid still set to no. Anything past its Due date carries an overdue flag.

What lands in the output folder

  • PIPELINE.md totals every deal by stage: pitched, signed, delivered, paid, lost. You find out what you booked this year instead of what it felt like you booked.
  • The rate card is built from signed, delivered and paid deals only. Pitches and lost deals never touch the average, so the figure in RATE_CARD.md is what brands have paid you, not what you once hoped you were worth.
  • Averages come out per deliverable type, so a Reel and a 60-second YouTube integration stop sharing one blurry price in your head. Next negotiation, you open on a number.
  • Anything signed or delivered and unpaid lands in OUTSTANDING.md with a dollar total at the bottom. That total is usually the moment people go quiet.
  • Overdue means one thing here: the Due date is before today, checked at run time, printed with a flag.
  • deals.json carries every deal plus every computed field, so when your bookkeeper asks for one file in January, that is the file.
  • The CSV parser handles quoted fields, embedded commas and ""-escaped quotes, which matters the first time a brand name has a comma in it.

Who should skip this

Built for the creator, or a two-person management shop, closing somewhere between 15 and 60 deals a year and tracking them in Sheets. One person exports the CSV. The same person reads the reports.

Not for you if you run an agency with a signed roster of 40 talent and a full-time accounts team. No contract storage. No e-signature, no client portal, and nothing that sends an email on your behalf. It reads a CSV and writes four files. That is the whole scope.

Google Sheets, Notion, and HubSpot’s free CRM

A Sheets deal tracker costs nothing and it is yours. Notion is better looking and better at holding the brief, the moodboard and the contract in one place. HubSpot’s free CRM beats both at email history and at nudging you to follow up.

None of them will tell you, unprompted, that four delivered posts are unpaid and two are past their due date. That is an arithmetic job you have to remember to do, and remembering is the part that fails. This does the arithmetic every single run.

Where the deal data sits

On your disk. The CSV is read and never sent anywhere, and the only files written are PIPELINE.md, OUTSTANDING.md, RATE_CARD.md and deals.json, all inside the folder you named. Every write is checked against the output root with assertWithinRoot, and files land at 0600, so a brand name with a slash in it cannot write outside where you pointed it. There is no export button. The output already is the export.

$19 a month, per user

Nineteen dollars, per user, per month. Most people who buy this are the only user, which is rather the point.

You get the desktop build, the .env config with the COL_* overrides, and four reports on every run. The first run writes all of them in one pass. Finding your deal spreadsheet is usually the slow part.

Security and privacy

Handles creator financial/business data (brand deal values, payment status, due dates). Security is designed in.

Principles
Local-first. DEALS_CSV is read from disk and never transmitted anywhere; nothing in this tool touches the network. Nothing is uploaded, no telemetry, no cloud dependency.
Non-destructive. The source CSV is only read, never modified or deleted.
Least privilege. Reads DEALS_CSV, writes only under OUTPUT_FOLDER.

Protections implemented (v0.1.0)
Path-traversal defense — every output filename is sanitized (safeSegment) and every write is checked with assertWithinRoot(), so reports can’t be written outside OUTPUT_FOLDER.
Fail-fast config validation — clear errors for missing DEALS_CSV/OUTPUT_FOLDER before any file is touched.
Restrictive permissions — the generated reports (PIPELINE.md, OUTSTANDING.md, RATE_CARD.md, deals.json) are written 0600.
Defensive parsing — the CSV parser and currency parser never throw on malformed input (missing fields default to empty string, unparseable amounts default to 0, unparseable dates are never flagged overdue); a bad row degrades the report rather than crashing it.
Secrets discipline.env and generated Sponsorships/ output are git-ignored; no secrets or client data in the repo.

Distribution / AV trust

Known limitations / roadmap
Paid is treated as paid unless it’s blank or a “no”-like value (no/n/false/0) — a typo’d negative value (e.g. nope) will be counted as paid. Review OUTSTANDING.md against your own records periodically.
– Due-date parsing expects YYYY-MM-DD (falling back to JS Date parsing for other formats); a due date that doesn’t parse at all is silently never flagged overdue rather than raising an error. Reviewers should scan deals.json for daysUntilDue: null rows.
– The rate card averages raw deal value per deliverable with no outlier handling — a single unusually large or small deal can skew the average for low-volume deliverable types.

Reporting
Report suspected vulnerabilities privately to the maintainer before public disclosure.

Frequently asked questions about Brand-Deal & Sponsorship Tracker

What does the Brand-Deal & Sponsorship Tracker do?

The Brand-Deal & Sponsorship Tracker is a lightweight pipeline for creators and small agencies who juggle several brand deals at once and end up chasing payments. You log your deals and deliverables in a simple CSV, run the tool, and get back three things: a pipeline that moves each deal from pitched to signed to delivered to paid, a rate card built from your own history, and a clear view of what is outstanding and overdue. It replaces the messy spreadsheet most creators start with once the deals pile up.

The flow is deliberately plain. You keep one file with each deal, the brand, the deliverables promised, the agreed fee, and the payment status. The brand-deal & sponsorship tracker reads that file and organizes it into a working pipeline, so you can see at a glance which posts still owe a deliverable and which invoices have gone quiet. Because the rate card is drawn from what you have actually charged, it gives you a grounded number to quote the next brand instead of guessing.

Every sponsored deal also carries a disclosure obligation, and the tool is a natural place to track it as a deliverable. The Federal Trade Commission’s guidance, Disclosures 101 for Social Media Influencers, says your endorsement should make it obvious when you have a material connection to a brand. Listing the required disclosure alongside the caption or video in your deliverable checklist means it is far less likely to slip through on a busy launch day when several posts go out at once.

What the tool does not do is pretend to be a full CRM or an accounting suite. It is focused on the specific mess creators know well: too many deals, too many deliverables, and payments that arrive late or not at all. You can see how logging a CSV turns into a pipeline and a rate card on the product page, and how it fits our other tools for creators and agencies who run frequent paid campaigns.

Priced per user each month, the brand-deal & sponsorship tracker is meant to sit quietly between your inbox and your bank, turning scattered promises into a list you can act on. You always know who owes a deliverable, who owes you money, and what your work is worth based on real history. That is a modest scope on purpose. The tracker does the boring tracking so you can spend your attention on making the content and closing the next deal, rather than reconstructing where each partnership stands from memory and a tangle of email threads every single week. Because the pipeline stages are simple, onboarding is quick. You do not learn a new sales methodology or configure custom fields. You keep the same CSV habit you already have and let the tool read structure into it. As your history grows, the rate card gets sharper, since it reflects a longer record of what brands have genuinely paid you rather than a single lucky deal you happen to remember. That steady accumulation is quietly the most valuable part for a creator whose fees should be rising over time.

How does the Brand-Deal & Sponsorship Tracker help me meet FTC disclosure rules?

The tool helps by making disclosure a tracked deliverable rather than an afterthought. When you log a brand deal, you list what you owe the sponsor, and the required disclosure belongs on that list next to the post itself. The Federal Trade Commission’s guide, Disclosures 101 for Social Media Influencers, says your endorsement message should make it obvious when you have a material connection to the brand. Treating that as a checklist item is a simple way to keep it from being forgotten.

Disclosure is not a design flourish, it is a plain statement your audience can see. The FTC expects it to be hard to miss and easy to understand, placed where a viewer will actually notice it rather than buried at the end or hidden behind a more tag. The brand-deal & sponsorship tracker cannot write or place that statement for you inside a post, but it can hold the reminder so that a deal is not marked delivered until the disclosure is genuinely there. That gap between promised and delivered is exactly what the pipeline is built to surface.

Because the tool keeps every deal and its deliverables in one file, you also get a record of what each partnership required. If a brand or a platform ever questions how a sponsored post was labeled, you can point to your own log of what was agreed and marked done. That kind of contemporaneous record is useful precisely because the FTC puts responsibility on the creator to disclose, not only on the brand. Keeping your own notes means you are not relying on a sponsor’s paperwork to reconstruct what happened.

It is worth being blunt about the limits. The tracker does not review your caption, does not judge whether a hashtag is clear enough, and does not guarantee compliance. Those judgments stay with you, and when a campaign is large or the terms are unusual, reading the FTC guidance directly is the right move. What the tool offers is structure, so the disclosure step has a defined home in your workflow instead of living only in your head during a hectic posting week.

Used well, the brand-deal & sponsorship tracker turns disclosure from a thing you hope you remembered into a line you can see and check off. You can review how deliverables are logged and marked complete on the product page. The honest benefit is small but real: a consistent place to record that each sponsored post carried the clear, obvious disclosure the FTC asks for, across every deal you run, so a good month of partnerships does not quietly turn into a pile of posts that never got labeled the way the rules require. This matters more as you scale. One deal is easy to remember. Ten overlapping deals across several platforms, each with its own deliverable dates, are not, and that is exactly when a missed disclosure slips through. By tying the disclosure to the deliverable rather than to your memory, the tool keeps the obligation visible at the moment it is most likely to be dropped. It will not argue your case for you, but it gives you an organized starting point if anyone ever asks how a given sponsored post was handled and when the disclosure went live.

Where does my deal and payment data live in the tracker, and is it safe?

Your brand-deal & sponsorship tracker runs from a simple CSV you keep, so the raw record of your deals, fees, and payment status lives in a file you control. That matters because a creator’s deal list is sensitive commercial information: who is paying you, how much, and which partnerships are still under wraps. Keeping that in your own file, rather than scattered across email and screenshots, makes it both easier to work with and easier to protect.

The Federal Trade Commission offers a clear model for handling data like this. Its business guide, Protecting Personal Information, frames security as take stock, scale down, lock it, pitch it, and plan ahead. Applied to your deal file, that means knowing what you hold, keeping only the details you actually need, protecting the folder it sits in, clearing out stale records, and having a plan if a device goes missing. The tool does not scatter copies of your deal data across services you do not manage, which lines up with keeping the footprint small.

Brand deals often come with embargoes and confidentiality terms. An unreleased campaign, a rate you agreed to keep private, or a sponsor’s product under wraps are all things you do not want leaking. Because the tracker works from a file you own, there is no separate cloud copy created as a side effect of running it. Fewer copies in fewer places is the plainest way to reduce exposure, and it matches the FTC’s advice to scale down what you keep and lock down what remains.

You stay responsible for the basics on your own machine. Disk encryption, a strong login, and regular backups are still your job, the same as they would be for any file holding financial detail. The brand-deal & sponsorship tracker does not remove that responsibility, and it should not claim to. What it does is avoid adding new exposure, so protecting your deal data is mostly about protecting one file and the folder it lives in rather than auditing a chain of outside platforms.

The honest summary is that data safety here is largely in your hands, which many creators prefer when the numbers involved are their livelihood. If you apply the FTC’s take-stock and lock-it steps to your deal file, you cover the ground that matters most. You can see how the CSV-based flow is structured on the product page before deciding where to store it. The tool is built so that keeping your partnership data private means guarding your own storage, not trusting a vendor to hold the full picture of who pays you and what for. There is a business reason to care beyond privacy. Your rate history is a competitive asset. If a brand knew the floor you have accepted before, it would shape their offer, and you would rather negotiate from your own knowledge than give that advantage away. Keeping the deal file local means the numbers that inform your rate card stay with you. If you work with a manager or a small team, share the file deliberately and only with the people who need it, following the FTC’s advice to lock down access rather than open it to everyone by default. That small discipline protects both the personal details and the commercial edge inside the same file.

How is this different from Sponsorfy, a CRM, or a spreadsheet?

A spreadsheet is where most creators start, and it works until the deals multiply. Then formulas break, statuses go stale, and you lose track of which brand still owes a deliverable or a payment. General CRMs like the ones creators sometimes adapt are built for sales teams, not for a solo creator tracking sponsored posts. Dedicated tools such as Sponsorfy, SponsorKit, and CreatorsJet are closer in spirit. The Brand-Deal & Sponsorship Tracker aims squarely at the creator managing many deals who wants pipeline, rate card, and receivables without a heavy platform.

The clearest difference from a raw spreadsheet is that the tool understands your deal as a deal. It moves each one through pitched, signed, delivered, and paid, and it surfaces what is outstanding and overdue on its own instead of waiting for you to build a formula. It also generates a rate card from your history, so you are quoting the next brand from real numbers. A blank spreadsheet gives you none of that structure until you build it yourself, and rebuild it every time your process changes.

Against purpose-built sponsorship tools, the honest split is scope and price. Enterprise sponsorship-intelligence platforms target big brands and agencies at prices far out of reach for an individual creator. This is priced per user each month and stays focused on the small-creator workflow: log deals in a CSV, run the tracker, and get a pipeline plus receivables. It does not try to be a media-buying or brand-discovery engine, and it is honest about that narrower job.

Payments are where the focus shows. Because brand income often arrives through platforms and cards, some of it may reach you on a Form 1099-K, which the IRS describes as a report of payments you received for goods or services during the year. The overdue and outstanding view helps you see what has actually been paid versus what a form might later report, which is harder to reconstruct from a spreadsheet after the fact. You can compare the workflow on the product page.

What the brand-deal & sponsorship tracker does not do is replace your accountant, your contracts, or a full agency system. It is a focused pipeline for the exact mess creators know: too many deals, too many deliverables, and payments that run late. If you have outgrown the spreadsheet but do not need an enterprise suite, that focus is the point. If you need deep team collaboration or brand-side analytics, a larger tool may fit better, and you can still export your CSV and move on, because the data was always yours to begin with and never locked inside the tracker. That portability is worth weighing against the pricier alternatives. Many creator tools make their data hard to leave, which raises the real cost of switching later. Here the input and output are plain files, so trying the tool carries little risk. If it fits your workflow, you keep using it. If it does not, you have lost nothing but a CSV export. For a creator watching every subscription, that low commitment is often the deciding factor, more than any single feature on a comparison chart between the various sponsorship tools on the market today.

Does the tracker help me stay ready for taxes and a 1099-K on brand payments?

Yes, in a practical way. The Brand-Deal & Sponsorship Tracker keeps a running record of what each brand agreed to pay and whether that money has actually landed, through its outstanding and overdue view. That record is exactly what you need when tax time arrives and you are trying to reconcile the income you earned against the forms that report it. Brand payments are self-employment income, and having a clean list of them beats reconstructing the year from your inbox.

Two IRS realities make this useful. First, sponsored income is generally self-employment income. The IRS Self-Employed Individuals Tax Center explains that self-employed individuals generally must pay self-employment tax as well as income tax, which means the fees you track are subject to more than ordinary income tax. Second, when payments come through cards or third-party platforms, some may be reported on a Form 1099-K, which the IRS calls a report of payments received for goods or services during the year. The tracker’s payment view helps you match those forms to what you were actually paid.

The value is reconciliation, not tax preparation. A 1099-K reports gross payments through a platform, which will not always line up neatly with your deal fees after refunds, fees, or timing differences. Because the brand-deal & sponsorship tracker records each deal’s agreed amount and paid status, you have a source of truth to compare against a form that might otherwise puzzle you. Catching a mismatch early, while you still remember the deal, is far easier than untangling it months later.

Be clear about the boundary. The tool does not calculate your self-employment tax, does not file anything, and does not replace an accountant. What it gives your accountant, or you, is an organized list of brand income and its status, which makes their job faster and your records defensible. You can see how the outstanding and overdue view works on the product page, and how the tool sits among our resources for creators and agencies.

Used through the year, the brand-deal & sponsorship tracker turns tax season from a scramble into a review. You are not hunting for which brands paid and which still owe, because the pipeline already tracked it as the deals closed. Pair that record with the IRS guidance on self-employment tax and the 1099-K, and you walk into filing with the numbers already gathered. That readiness is the quiet payoff of logging deals as you go, rather than treating your income as a mystery to be solved once a year when the forms start to arrive in the mail. There is a further benefit for creators who owe quarterly estimated taxes. Because self-employment income is not withheld the way a paycheck is, seeing your paid deals add up through the year helps you judge whether you are setting aside enough as you go. The tracker will not size those payments for you, but a running total of income actually received is the raw input any estimate starts from. Walk into each quarter knowing what landed, and the guesswork shrinks. That is a modest habit with an outsized effect on avoiding an unpleasant surprise when the annual return is finally due.

Attributes Value
Deployment

Cloud

Platform

Web

License Type

Subscription

Billing Period

Monthly

Target Customer

Creators & Agencies

Free Trial

Yes

Reviews

Be the first to review “Brand-Deal & Sponsorship Tracker”

Your email address will not be published. Required fields are marked *