Welcome to The Ultimate Author Log! This is the place that will help you transform your writing from vague ambition into an actionable system: measurable, adaptable, scalable, and profitable.
***This is the free-preview of the Table of Contents and a partial view of a few of the sheets inside. Full version available here ***.
The Ultimate Author Log from Zen Chaos Writing is your twenty-one page system for turning mild creative chaos into a functioning, income-generating writing life. This excel-based log allows you to track what works, cut what doesn’t, and (knock on wood) build a fulfilling and rewarding side-hustle (or, dare we dream, career.) With a place for your daily tasks, content pipeline, sales data, income streams, merch ideas, marketing strategy, and long-term goals, you are no longer juggling tabs, notes, and half-formed plans
Moreover, many sheets are pre-filled with sample content, including royalty and printing rates for commonly used sites (accurate as of 2025; no guarantees made of continued validity/ please confirm with your own research as relevant.) Additionally, reference sheets offer ideas for diversified income streams, relevant platforms to add them, and additional information. You get the benefit of utilizing a pre-researched centralized knowledge base forged by an author who has already done the legwork for you.
What you'll find inside:
1. Your Command Center:
- Task Log: A personalized system to break big goals into manageable tasks.
- Revenue Brainstorm: A reference sheet mapping potential income streams to help you diversify and expand how your writing/creativity makes money.
- Work Expenses: An itemized table to record business spending.
- Ind$ Goals: A centralized place to define your overall income targets across all projects.
- Royalty Rates: A reference guide to track royalty structures across platforms to understand earnings breakdown.
2. Content & Audience Growth Tools:
- Content Brainstorm: A page to capture raw ideas for reader-centric content and themes.
- Newsletter Plans: An interactive worksheet ready for you to organize selected ideas into structured, send-ready newsletters.
- Social Media: A blueprint to structure marketing content creation and social media posting.
- Social Marketing: A place to plan outreach strategies to increase visibility and audience engagement.
- Articles: A place to track long-form content like blog posts and articles, helpful to building author voice and audience reach.
3. Sales & Performance Tracking:
- Sales: A chart offering a clear view of what’s actually selling—so you can double down on what works.
- Sales Pivot: Additional charts tracking transactions and performance to identify sale growth.
- Market Pivot: Analyze performance trends and make strategic adjustments when something isn’t landing.
- Book Goals: A table to define measurable revenue and performance targets for your books.
4. Publishing & Distribution Strategy:
- Bookstore: A table to track outreach, relationships, and placement opportunities in physical and online stores.
- Grants & Awards: A place to track opportunities, deadlines, and submissions for funding and recognition.
5. Merch & Product Ecosystem:
- Merch Brainstorm: A page to generate product ideas aligned with your brand, voice, and audience.
- Merch Plan: A map to organize offerings, launches, and overall merchandise strategy.
- Merch Cost Breakdown: A grid to manage merch sample costs for testing/gifting and prep for bulk production.
6. Idea Capture & Flex Space:
- Brainstorm Integration: A workbook designed so you can pull scattered ideas into one organized, usable system.
- Open Planning Areas: Adapt the system to your workflow as your writing career evolves.
- Track What Works: Identify patterns in sales, content, and engagement.
- Refine What Doesn’t: Use pivot tools to adjust without starting over.
