I Tracked Every Creative Dollar and Minute for 365 Days — Here's the Unflattering Spreadsheet

On January 1st of last year, I opened a fresh spreadsheet and made a deal with myself: for one full year, I would log every creative thing I made, sent, published, or got paid for. Not to become some quantified-self robot — I'm a writer, not an accountant — but because I had a suspicion that my memory of my creative year and my actual creative year were two very different documents.

I was right. Let me show you the receipts.

The Rules of the Audit

The system was deliberately dumb. Four tabs:

1. Made: Anything I created, even drafts and scraps. One row per session.
2. Sent: Pitches, applications, submissions, queries. Anything leaving my outbox hoping for a yes.
3. Seen: Anything of mine that went public — published pieces, posts, showings.
4. Earned: Every dollar tied to creative work, including the weird ones (a $75 licensing fee, a barter trade, a birthday check from my aunt earmarked "for the novel").

Five minutes a day, tops. If a system takes longer than that, I will abandon it by Valentine's Day, and I know this about myself.

The Numbers, Honestly Reported

By December 31st, the spreadsheet told me some things I did not want to know:

• I made things on 187 of 365 days. Solid, but I'd have guessed 300. My "I work constantly" narrative lost to arithmetic.
• I sent 43 pitches and applications. Nine came back with a yes — a 21% hit rate that felt terrible in the moment and honestly great in the spreadsheet.
• Of everything I made, only about a quarter ever got seen by another human. Three-quarters of my output lived and died on my hard drive.
• The money was the wildest column. My top three paying clients accounted for nearly 80% of my creative income, while roughly 60 hours of effort across the year earned less than $300 total.

That last number hurt. But it also explained why I always felt broke and busy at the same time.

Feeling Productive vs. Being Productive

Here's the real finding: the work I felt best about and the work that moved my career were almost entirely different projects. I loved noodling on my half-finished essay collection — it generated dozens of "Made" entries and zero "Sent" entries. Meanwhile, the unglamorous client work I sometimes resented was quietly funding everything and building relationships that led to my best gig of the year.

My instinct all year had been to follow energy. The data suggested something more annoying: follow energy and check the scoreboard.

Run Your Own Audit: The Five-Question Framework

You don't need a year. Do this quarterly and you'll get most of the value:

1. List what you finished. Actually finished, not "worked on." Count it.
2. List what you sent out. Submissions, pitches, applications — things that required someone else's yes.
3. List what other people saw. Published, posted, performed, shared.
4. Follow the money. Which projects, clients, or pieces actually generated income? Rank them.
5. Find the gap. Compare column one to column four. Whatever you love that earns nothing isn't a problem — but whatever earns nothing and goes unseen and never leaves your desk deserves a hard look.

That fifth question is the whole audit. Everything else is just gathering evidence for it.

What Changed This Year

I'm not abandoning the essay collection — some things you make because you'd go slightly insane if you didn't. But I gave it a deadline and a submission plan, because "someday" was turning it into a very well-fed houseplant.

And I raised my rates on the work that was quietly subsidizing everything else, because the spreadsheet made the subsidy impossible to unsee.

The audit didn't make me more productive. It made me more accurate. Turns out that's worth five minutes a day.