Tracking What You Lose While Writing
Most writing advice focuses on output. Word count goals, daily targets, finishing drafts. Nobody really talks about tracking your losses unless you stumble into it accidentally. A loss journal for writers is just that - a spreadsheet where you record everything that goes wrong during your writing process. Words deleted. Scenes cut. Entire chapters killed. Hours spent on drafts that ended up in the trash bin. I started building one for myself about four years ago because I was finishing books at the same rate as always but feeling like I was producing less. The numbers didn't lie. I was spending roughly twice as many words as I needed to get to the final draft of whatever project I was on. Most of those words existed only in discarded versions.
How I Structure My Loss Journal Spreads For Writers
My spreadsheet has five columns. Date, Project Name, Type of Loss, Word Count or Time Lost, and Reason. That's it. No fancy formatting. No conditional coloring. Just raw data I can sort and filter when I need to see patterns. Type of Loss is where most people stop and that's a mistake. I break it down into categories: Scene Cut (a complete scene that didn't make the cut), Character Delete (a character arc trimmed entirely), Dialogue Trim (conversation passages shortened or removed), POV Switch (reworking a chapter from a different perspective), Worldbuilding Downshift (explanatory passages reduced for pacing), and First Draft Excess (material from the initial draft that never survived revision). The Reason column is the most important part. Without it you're just counting casualties. With it you start seeing which mistakes repeat. I've seen writers log hundreds of rows without ever looking back at the Reason column. That's like doing bloodwork and never reading the results.
One specific problem I ran into: early on I was recording losses per scene but my projects had scenes ranging from three pages to twenty-five. Comparing raw word counts across projects was meaningless. A 800-word cut in a short literary piece tells you something totally different than an 800-word cut in an epic fantasy chapter. I switched to recording loss percentage instead of absolute numbers - what portion of each scene or chapter ended up deleted. That made cross-project comparison actually useful. It took me about ten minutes to change the formula and another twenty to convert my existing entries.
Get the Full Details
What This Actually Teaches You
After about six months of consistent logging you start noticing patterns that are not obvious from the inside of a single draft. For me, the data showed that 62 percent of my losses came from two sources: scenes I wrote to explore a character who ended up irrelevant, and opening chapters where I over-explained the world before the plot had a reason to exist. Both are classic beginner moves. The spreadsheet made them visible in a way that self-reflection never did. Another thing nobody mentions - tracking losses reveals your actual output velocity. You might think you're writing two thousand words a day. Your loss journal will tell you you're writing eight thousand and cutting six thousand. Knowing that number changes how you approach a project. You stop treating the first draft like a artifact you have to protect and start treating it like a raw material you're going to work with. There are limitations to this system. If you're writing speculative fiction with extensive worldbuilding notes separate from the manuscript, those losses won't show up in your writing column. I keep a parallel spreadsheet for research and worldbuilding detours that don't make it into the text. Two sheets instead of one is still better than zero sheets.
The system also breaks down if you work entirely in prose software that doesn't export clean word counts per section. Scrivener handles this fine since it tracks per-project statistics. Google Docs requires manual entry. Word documents are a headache. I've seen people give up on this method because the tracking friction became higher than the value of the data. If that happens to you, switch to a simpler version - just track one metric per session, like total words written versus total words kept. You can download a template I use if you want to skip the setup. It's a basic Google Sheet with the five-column structure and some sample data to show how the loss percentage calculation works. I'm not going to pretend this alone will improve your writing. It won't. But it will show you where your actual problems are instead of guessing. And in my experience that's worth more than another article about morning routines.
