About this ebook
Do you struggle with tracking your author income?
It ain't easy. If you publish your books wide, you might get AT LEAST a dozen sales reports every month. It makes most authors want to pull their hair out!
In this guide, prolific author M.L. Ronn walks through the process he used to tame his sales reports. He transformed a 5-hour per month process into a 30-minute effort using the power of technology and automation. This book is a blueprint to how he did it.
This book is also a blueprint for entrepreneurs and developers who want to solve this problem. It will show you why the author income problem is so complex and exactly how to solve it.
Tracking your income doesn't have to be hard. All it takes is the right approach.
Ready to solve the author income problem once and for all?
V1.0
M.L. Ronn
Science fiction and fantasy on the wild side! M.L. Ronn (Michael La Ronn) is the author of many science fiction and fantasy novels including the Modern Necromancy, The Last Dragon Lord, and Sword Bear Chronicle series. In 2012, a life-threatening illness made him realize that storytelling was his #1 passion. He’s devoted his life to writing ever since, making up whatever story makes him fall out of his chair laughing the hardest. Every day.
Read more from M.L. Ronn
Interactive Fiction Rating: 3 out of 5 stars3/5
Related to The Author Income Problem
Titles in the series (21)
Be a Writing Machine: Author Level Up, #3 Rating: 4 out of 5 stars4/5The Author Income Problem: Author Level Up, #6 Rating: 0 out of 5 stars0 ratingsThe Reader's Bill of Rights: Author Level Up, #5 Rating: 0 out of 5 stars0 ratingsHow to Write Your First Novel: The Stress-Free Guide to Writing Fiction for Beginners: Author Level Up, #2 Rating: 4 out of 5 stars4/5The Self-Publishing Advice Compendium: Author Level Up, #9 Rating: 0 out of 5 stars0 ratingsThe Indie Author Strategy Guide: Author Level Up, #12 Rating: 0 out of 5 stars0 ratingsThe Indie Author Atlas: Author Level Up, #8 Rating: 0 out of 5 stars0 ratingsThe Indie Author Bestiary: Author Level Up, #7 Rating: 0 out of 5 stars0 ratingsThe Writing App Handbook: Author Level Up, #11 Rating: 0 out of 5 stars0 ratingsThe Pocket Guide to Pantsing: Author Level Up, #13 Rating: 4 out of 5 stars4/5How to Dictate a Book: Author Level Up, #14 Rating: 4 out of 5 stars4/5Advanced Author Editing: Author Level Up, #15 Rating: 0 out of 5 stars0 ratingsThe Author Estate Handbook: Author Level Up, #17 Rating: 0 out of 5 stars0 ratingsKeep Your Books Selling: Author Level Up, #16 Rating: 0 out of 5 stars0 ratingsThe Indie Author Bestiary II: Author Level Up, #20 Rating: 0 out of 5 stars0 ratingsAuthor Marketing Magic: Author Level Up, #21 Rating: 0 out of 5 stars0 ratingsThe Author Heir Handbook: Author Level Up, #18 Rating: 0 out of 5 stars0 ratingsBe a Writing Machine 2: Author Level Up, #19 Rating: 0 out of 5 stars0 ratingsAuthors, Steal This Book: Author Level Up Rating: 5 out of 5 stars5/5
Related ebooks
The Reader's Bill of Rights: Author Level Up, #5 Rating: 0 out of 5 stars0 ratingsThe Indie Author Atlas: Author Level Up, #8 Rating: 0 out of 5 stars0 ratingsAdvanced Author Editing: Author Level Up, #15 Rating: 0 out of 5 stars0 ratingsThe Indie Author Strategy Guide: Author Level Up, #12 Rating: 0 out of 5 stars0 ratingsKeep Your Books Selling: Author Level Up, #16 Rating: 0 out of 5 stars0 ratingsThe Self-Publishing Advice Compendium: Author Level Up, #9 Rating: 0 out of 5 stars0 ratingsThe Writing App Handbook: Author Level Up, #11 Rating: 0 out of 5 stars0 ratingsThe Author Heir Handbook: Author Level Up, #18 Rating: 0 out of 5 stars0 ratingsThe Author Life: A Collection of Essays on Craft, Marketing, and Mindset: The Author Life Rating: 0 out of 5 stars0 ratings30-Day Author: Develop A Daily Writing Habit and Write Your Book In 30 Days (Or Less): Wordslinger, #1 Rating: 0 out of 5 stars0 ratingsThe No Bullsh*t Guide to Writing a Novel (or Novella) 15 Minutes at a Time: The No Bullsh*t Guide to Writing Erotica Rating: 0 out of 5 stars0 ratingsMaster Fiction Writing: Craft A Novel in 31 Days: Selling Writer Strategies, #4 Rating: 0 out of 5 stars0 ratingsWhat Writers Need to Know: Essential Topics: Red Sneaker Writers Books, #9 Rating: 5 out of 5 stars5/5The Pocket Guide to Pantsing: Author Level Up, #13 Rating: 4 out of 5 stars4/5Fast Fiction: A Guide to Outlining and Writing a First-Draft Novel in Thirty Days Rating: 4 out of 5 stars4/5Indie Author Confidential 8: Indie Author Confidential, #8 Rating: 0 out of 5 stars0 ratingsA Novel Idea: "Learn" How to Write a Novel in Under 60 Minutes Rating: 3 out of 5 stars3/5Storytelling for Pantsers: How to Write and Revise Your Novel Without an Outline Rating: 0 out of 5 stars0 ratingsHow to Plot Your Novel: Outlining for Authors Made Easy: Write Better Fiction, #2 Rating: 0 out of 5 stars0 ratingsSell More Books Today: The Simple Secret To Successful Fiction Rating: 0 out of 5 stars0 ratingsNovel Writing <I>For Wanna-Be's</I><Sup>Tm</Sup>: A Writer-Friendly Guidebook Rating: 0 out of 5 stars0 ratingsThe New Author: Writing, Self-Publishing & Author Platforms Rating: 4 out of 5 stars4/5How To Write A Book ASAP: The Step-By-Step Guide to Writing Your First Book Fast! Rating: 3 out of 5 stars3/5Chapter One: A Fast, Fun Way to Write Fiction Rating: 0 out of 5 stars0 ratingsThe Busy Author’s Guide Box Set 2: The Epic Guide to Character Creation: Protagonists, Antagonists, Sidekicks, and Mentors Rating: 0 out of 5 stars0 ratingsSelf-Editing Your Novel: an editor's tips to make your work shine Rating: 0 out of 5 stars0 ratings
Composition & Creative Writing For You
THE EMOTIONAL WOUND THESAURUS: A Writer's Guide to Psychological Trauma Rating: 5 out of 5 stars5/5Pity the Reader: On Writing with Style Rating: 4 out of 5 stars4/5Zen in the Art of Writing Rating: 4 out of 5 stars4/5The Power of Writing It Down: A Simple Habit to Unlock Your Brain and Reimagine Your Life Rating: 4 out of 5 stars4/5Letters to a Young Poet Rating: 4 out of 5 stars4/5Verbal Judo, Second Edition: The Gentle Art of Persuasion Rating: 4 out of 5 stars4/5Writing to Learn: How to Write - and Think - Clearly About Any Subject at All Rating: 4 out of 5 stars4/5The Elements of Style: The Original Edition Rating: 4 out of 5 stars4/5The Emotion Thesaurus (Second Edition): A Writer's Guide to Character Expression Rating: 4 out of 5 stars4/5The Elements of Style, Fourth Edition Rating: 5 out of 5 stars5/5Writing Fiction: A Guide to Narrative Craft Rating: 4 out of 5 stars4/5Wordslut: A Feminist Guide to Taking Back the English Language Rating: 4 out of 5 stars4/5The Mother Tongue: English and How it Got that Way Rating: 4 out of 5 stars4/5The Art of Memoir Rating: 5 out of 5 stars5/5How to write a novel using the Zettelkasten Method: How to write..., #1 Rating: 2 out of 5 stars2/5The Everything Writing Poetry Book: A Practical Guide To Style, Structure, Form, And Expression Rating: 5 out of 5 stars5/5Romancing the Beat: Story Structure for Romance Novels: How to Write Kissing Books, #1 Rating: 5 out of 5 stars5/5The Plot Whisperer Book of Writing Prompts: Easy Exercises to Get You Writing Rating: 5 out of 5 stars5/5The Copywriter's Handbook: A Step-By-Step Guide To Writing Copy That Sells (4th Edition) Rating: 4 out of 5 stars4/5How to Write a Mystery: A Handbook from Mystery Writers of America Rating: 5 out of 5 stars5/5People, Places, Things: My Human Landmarks Rating: 5 out of 5 stars5/5The Positive Trait Thesaurus: A Writer's Guide to Character Attributes Rating: 5 out of 5 stars5/5On Writing and Failure: Or, On the Peculiar Perseverance Required to Endure the Life of a Writer Rating: 5 out of 5 stars5/5A Writer's Diary Rating: 4 out of 5 stars4/5The Notebook: A History of Thinking on Paper Rating: 5 out of 5 stars5/5Legal Writing in Plain English: A Text with Exercises Rating: 3 out of 5 stars3/5
Reviews for The Author Income Problem
0 ratings0 reviews
Book preview
The Author Income Problem - M.L. Ronn
THE AUTHOR INCOME PROBLEM
TRACK YOUR SALES WITHOUT PULLING YOUR HAIR OUT
M.L. RONN
Copyright 2020 © M.L. Ronn. All rights reserved.
Published by Author Level Up LLC.
Version 3.0
Cover Design by Pixelstudio.
Covert Art © ingka.d.jiw / Depositphotos
Editing by BZ Hercules.
Warm thank you to a special group of people who helped me on my sales journey to solve this problem: Tom Donahue, Olga Kirshenbaum, Dale L. Roberts, and Oz du Soleil. This project wouldn’t have happened without their coaching and guidance.
Special thank you to the following people on Patreon who supported this book: Jon Howard, Megan Mong, and Lynda Washington.
Some links in this book contain affiliate links. If you purchase books and services through these links, I receive a small commission at no cost to you. You are under no obligation to use these links, but thank you if you do!
For more helpful writing tips and advice, subscribe to the Author Level Up YouTube channel: www.youtube.com/authorlevelup.
CONTENTS
Why I Wrote This Book
The Great Riddle
Different People, Different Problems: The Stakeholders
Existing Solutions: Pros and Cons
Microsoft Excel: The Ultimate Answer?
Give Me a Database or Give Me Death
The Data Journey
The Lofty Goal of Zero Data Entry
Data Cleansing Conundrums
Data Cleansing Tools: Power Query or Macros
Microsoft Excel vs. Access: Side Note
Do You Want Access to ALL Your Data or Only the Data You NEED?
The Amazon Exchange Rate Problem
The Little Stuff: Other Data Problems to Think About
Beam Me Up, Scotty: Your Data's Mothership
Analyzing Your Sales: Visualizing Your Data
The Test of Time
One Writer's Answer to the Riddle
The Ideal Sales Report Tool: What It Needs to Have and Why
Next Steps
Read Next: The Indie Author Bestiary
Appendix: Important Terms
Meet M.L. Ronn
More Books by M.L. Ronn
WHY I WROTE THIS BOOK
Authors have a lot of problems: we have to learn how to write better, write faster, and market our books, among many things.
But there’s another problem that stands above all the rest.
When you start selling books, how do you track your author income?
I’ve written over 50 books, and I make money every month from many different book retailers. I sell books in ebook, paperback, audio, and three languages. I make money on YouTube through advertising revenue and brand deals. I have an audience that supports me on Patreon. I promote at least 20-30 different products and services, all of whom pay me affiliate commissions every month. I also sell online courses and make direct sales with my readers. And I haven’t even gotten into consulting fees and other miscellaneous income!
Somewhere around book six, I realized that I needed to get organized because going through my income statements every month was time-consuming and difficult. My time is too important to spend hours in Microsoft Excel doing tedious data entry. I should be writing.
I tried everything to solve this problem, and I mean everything.
I found a cute little Excel spreadsheet that another author shared with the community. It was a great spreadsheet except for the fact that each tab represented one book. Imagine a spreadsheet like this for 50 books!
I hired an Excel guru to build me a better spreadsheet. He created an improved spreadsheet with a nice dashboard that did help me for a little while, but I still had to manually enter my sales data into the spreadsheet, which made me stop using it.
I even hired an assistant to calculate all of my sales each month. After the third month, he quit because he hated the job. I’ve talked to virtual assistants about this problem: it turns out that none of them enjoy doing
a client’s book sales—hence, why my assistant quit. This is one job that you truly cannot outsource without causing sheer mental and physical pain to another person.
I tried different sales tools that I found on the Internet—none which shall be named—and while they were each decent in their own right, they had significant shortcomings. One of them required all of your retailer website logins, which is a nonstarter for me. Another was Amazon-only. Yet another was Windows-only. I’m a Mac user.
With so many options that didn’t suit my situation, I simply gave up and stopped tracking my sales for several years. Sure, I had an idea of what I was making per month, but I didn’t have the full picture—certainly not what I was making per month per book.
When you have as many books as I do, this is the number one problem you must tackle in your writing business.
And yes, I’m 100 percent serious. This problem is worse than building an audience or learning how to sell books. If you learn to do those things, you’ll create a flood of money. Most people would say that a flood of money
is a nice problem to have, but if you fail to manage your money, you will drown in that flood.
If you don’t understand where your money is coming from, you can’t truly call yourself a business owner. Think about a restaurant, or a flower shop, or a convenience store. Do they ignore their income? Absolutely not. They know their income to the penny, and which products are driving it.
Authors and creative entrepreneurs are the only profession I know of that have such a lax mindset about money. We tell ourselves it’ll just work out,
when in reality, it won’t if we don’t face the problem.
If you don’t know where your money is coming from, you cannot manage your money—your money manages you.
You also