Louise Harnby | Fiction Editor & Proofreader
  • Home
  • Resource library
  • Services
  • Courses
  • Books
  • Podcast
  • Blog
  • Training login
  • Contact
The Editing Blog: for Editors, Proofreaders and Writers

FOR EDITORS, PROOFREADERS AND WRITERS

How to track the health of your editing business efficiently: The Editor's Affairs (TEA)

30/3/2020

2 Comments

 
Every professional editor is a business owner, and that role requires us to track the health of our businesses from one year to the next. Managing and analysing all that data can be a burden, especially if you’re more interested in words than numbers!

Fellow editor and Excel authority Maya Berger has created a tool that will make life easy. It’s called The Editor's Affairs (TEA).
Picture
Picture
All the data in one place
When it comes to keeping an eye on the health of my business, simple has always been my goal. I’m an editor, not an accountant.

Essentially, I want as much as possible in one place:

  • Project schedule
  • Project data
  • Business income
  • Business expenses

And when it’s time to submit a tax return to (in my case) HMRC and evaluate how things are going, I don’t want to be faffing around with several different apps and spreadsheets.

Instead, I want to see the core data at a glance … data that will tell me the following:

On a project basis:

  • Hourly rate
  • Start and end dates
  • Fees – quotes, paid, pending and overdue
  • Baselines data – word count, hours worked
  • Client name, project title, how they found me

On a business-health basis:

  • Which clients I earn the most money from
  • The worth of each client as a percentage of my total income
  • Which months are the most lucrative
  • Average hourly rates
  • Average speeds
  • Comparison of data with the previous year
  • Income to declare
  • Allowable expenses to offset

I don’t want to spend ages collecting and collating this data so it’s easy to access. I want summaries that give me a number – automatically generated by the data I’ve inputted throughout the financial year.

Then, when it’s time to review my business and submit my return to the tax authorities, the numbers are ready and waiting for me.

I’ve been tracking my data for years, and while I’m fairly proficient with Excel, I’ve been aware that there’s more I could do to fine-tune my process. However, like many editors, I have neither the time nor the will. So when Maya asked me to take a look at TEA, I jumped at the chance.
Picture
The Editor's Affairs (TEA)
So what is TEA? It’s a one-stop-shop Excel spreadsheet with lots of built-in jiggery-pokery that does all the tricky formula work for you. All you need to do is input the project (and expenses) data as it comes in.

Below are examples of some of the project data an editor can input, and the received data from TEA.

Examples of data the editor can input
  • Invoice number
  • Start date
  • Finish date
  • Date of completion
  • Payment due
  • Payment date
  • Client name
  • Notes about the job
  • How the client found me
  • Total word count
  • Estimated words per hour
  • Desired hourly rate
  • Actual number of hours worked
  • Amount invoiced
  • Amount received

Examples of received data from TEA
  • A status alert if the invoice is overdue
  • An estimate of actual words/hr
  • An estimate of how many hours I’d have to work to achieve my desired hourly rate
  • My actual rate per hour
  • My actual speed
  • My actual rate per 1,000 words
  • The amount I need to quote to achieve my desired hourly rate
Picture
5 reasons why TEA is worth it
So why is it worth investing in TEA? I identified 5 standout features that I believe make this a must-have tool.

NOTE: The numbers and client information below are for the purposes of illustration only. I made them up because my business affairs are of no concern to anyone but me!

1. Making informed decisions when quoting
TEA allows you to see the impact of the data you’re inputting on your business, and make informed decisions about how you should quote. Let’s take an example:

John Smith asks me to line edit a 100K-word novel. I estimate I can edit at a speed of 1,750 words per hour, so I input that information along with the word count.
  • TEA tells me I’ll need to set aside just over 57 hours for the project.

I decide I want to earn £40 per hour. I add that data to the row.
  • TEA tells me my estimated rate per 1,000 words will be £22.86.

Now I can build my quote. I type 57 into the hours-worked cell.
  • TEA tells me I need to quote £2,285.71.

For argument’s sake, let’s say I know that my client’s budget is £2,000. I can temporarily add this to the amount-received cell.
  • TEA tells me my rate per hour would be £35.09.

If I’m happy to work for £35.09 rather than £40 per hour, I’m good to go. If I don’t, I can negotiate with the client. The point is, I can play with the data I’m inputting and see the impact. And that means there are no surprises. I’m making informed decisions.

2. Collecting data for the future
Less experienced editors might not yet have enough older data to know how long a particular type of editing will take, or whether Client A’s work tends to be speedier to complete than Client B’s. TEA helps us build that knowledge via accrued data that we can use later on. Another example …

In April 2019, Jackie Jones asks me to proofread her 30,000-word novella. I have no clue how long it will take so I estimate a speed of 5,000 words an hour. I’m grateful for the opportunity because my business is new. I decide I’ll be happy earning anything over £20 per hour.

TEA tells me my rate per 1,000 words will be £4 and it’ll take 6 hours, so I bill for £120. I get the gig and do the work. In fact, it takes me 10 hours. I input the new data.
  • TEA tells me I’ve actually achieved only 3,000 words per hour and that my hourly rate was £12, not £20.

But I’ve learned something. And when Jackie comes back to me three months later with another job with the same word count, this time I can input more accurate data, meaning I’ll earn my desired rate of £20 per 1,000 words.

3. Saving time and protecting the data
At no time am I messing around with a calculator. All I do is input the raw data and review what TEA’s analysis cells tell me.

That saves me time because TEA’s doing the maths for me.

Plus, I can’t break the spreadsheet! TEA’s analysis cells are locked so I won’t inadvertently alter the complex formulae within.

4. Client analysis
Some editors work for repeat clients – an agency or publisher, for example. In those cases, we’re not always in control of the price, and yet those clients can still be valuable because of the amount of repeat work they send us and the percentage of our overall income their business accounts for.

Knowing who our most valuable clients are is essential if we’re to avoid knee-jerk reactions to rates of pay.

If Publisher A pays me an hourly rate half that of Agency A but gives me five times as much work, I’ll want to think very carefully before canning that client because I don’t like their pricing structure.

TEA’s Client Summaries Table does what is says on the tin. It’s here that we can see a list of our clients, the percentage their business contributes to our overall income, the number of hours’ work we’ve done for them and the total income received.

Time for another example …

Let’s say I’m scowling at the row on the Income sheet because I’ve yet to crack £15 per hour from Romance Fiction Press. Just above is an entry for John Smith, the indie author from whom I earned £40 per hour.

Terrible rates, I think. Exploitative, disrespectful, unfair. I’m about to head off to a Facebook group with 10,000 editor members and have a bit of a rant. Then I’m going to tell that press where to stick it.

But hang on a mo! What does TEA have to say?

I nip onto the Summaries sheet and take a look at the Client Summaries Table.
  • TEA tells me that work from Romance Fiction Press earned me £11,000, which accounts for 54% of my annual income.
  • John Smith is responsible for £2,285.71, or 11% of my annual income.

Yes, John Smith is a more valuable client on a project-by-project basis but he’s not giving me anywhere near the same volume of work as Romance Fiction Press.

Instead of ranting on Facebook, I need to use that time to plan a strategy that will bring in more John Smiths or better-paying publishers and agencies. Once done, I can phase out Romance Fiction Press. That might take a couple of years of intensive marketing. Until then, the press will stay.

Perhaps I can negotiate a raise with them. Maybe there are efficiency tools I can introduce to increase my speed when I’m editing for them. And they pay on time, are pleasant to work with, and have given me loads of fodder for my portfolio that I can leverage on my website and in future marketing.

The work is regular, too, and lands on my lap without my having to promote myself to get it. And that time saved is worth something.

5. Making tracking and tax less taxing
There are two additional and extremely useful summary tables in TEA:

  • The Monthly Summaries Table shows income, hours worked, expenses and charitable donations compiled from basic data the editor places in the onboard income and expenses sheets. You can see which months are most lucrative. TEA gives you a sense of the degree to which your work is seasonal, and that helps you to plan ahead and promote your business appropriately if you want to fill some gaps.
  • The Allowable Expenses Table has an itemized breakdown of what you can offset against your income.

The totals are the figures you’ll report to the tax office. They’re right there in front of you – no hunting around in different apps and other spreadsheets. All the data filters through from easy-to-fill-in Income and Expenses sheets accessible via TEA’s tabs.
Picture
How do I find out more about TEA?
Isn’t the name adorable? Using TEA is like having a cuppa! And it’s all about the editor’s affairs – our business affairs.

The data the editor has to input is basic stuff that all of us have access to or can estimate with every new job or expense that comes in.

The data TEA gives takes the stress out of scheduling, accounting and analysis. 

Every editor needs to understand the health of their business so that they can make informed decisions about who they work with, how much they charge and where the value lies. 

When accessing that data becomes burdensome, the temptation is to wing it. TEA means you don’t have to.

Maya will be making TEA available for purchase in May 2020. For introductory rates or to learn more about customized versions for more complex accounting and analysis, check out whatimeantosay.com/tea.

***
NOTE: I have no commercial stake in TEA, though I was given a free copy to experiment with in return for feeding back my experience of using it.
Louise Harnby is a line editor, copyeditor and proofreader who specializes in working with independent authors of commercial fiction, particularly crime, thriller and mystery writers.

She is an Advanced Professional Member of the Chartered Institute of Editing and Proofreading (CIEP), a member of ACES, a Partner Member of The Alliance of Independent Authors (ALLi), and co-hosts The Editing Podcast.

Visit her business website at Louise Harnby | Fiction Editor & Proofreader, say hello on Twitter at @LouiseHarnby, connect via Facebook and LinkedIn, and check out her books and courses.
2 Comments
Surit Das
1/4/2020 01:40:18 pm

Thank you for your review, Louise. Might you like to compare it with similar tools (by Katie Chambers and Rich Adin)?

Reply
Louise Harnby
1/4/2020 03:45:46 pm

I'm not going to venture into comparisons with tools I haven't used, and I don't have time to experiment with them. Sorry! This is different to Katie's at least. It tracks everything in one place rather than using three separate trackers. But as for other comparisons, you'd need to talk to Maya.

Reply



Leave a Reply.

    BLOG ALERTS

    If you'd like me to email you when a new blog post is available, sign up for blog alerts!
    Proofreading stamps
    ALERT ME!

    WHAT DO YOU NEED?

    • Training courses
    • ​Books and guides
    • Editor resources
    • Author resources
    • ​Monthly newsletter
    Picture
    SIGN ME UP

    PDF MARKUP

    Proofreading stamps

    AUTHOR RESOURCES

    Proofreading stamps

    EDITOR RESOURCES

    Proofreading stamps

    BOOKS FOR EDITORS AND WRITERS

    Picture
    Picture
    Picture
    Picture
    MORE BOOKS

    TRAINING COURSES FOR EDITORS

    Picture
    Picture
    Picture
    Blogging for Business Growth course
    MORE COURSES

    TESTIMONIALS


    Dare Rogers

    'Louise uses her expertise to hone a story until it's razor sharp, while still allowing the author’s voice to remain dominant.'

    Jeff Carson

    'I wholeheartedly recommend her services ... Just don’t hire her when I need her.'

    J B Turner

    'Sincere thanks for a beautiful and elegant piece of work. First class.'

    Ayshe Gemedzhy

    'What makes her stand out and shine is her ability to immerse herself in your story.'

    Salt Publishing

    'A million thanks – your mark-up is perfect, as always.'
    TESTIMONIALS

    CATEGORIES

    All
    Around The World
    Audio Books
    Author Chat
    Author Interviews
    Author Platform
    Author Resources
    Blogging
    Book Marketing
    Books
    Branding
    Business Tips
    Choosing An Editor
    Client Talk
    Conscious Language
    Core Editorial Skills
    Crime Writing
    Design And Layout
    Dialogue
    Editing
    Editorial Tips
    Editorial Tools
    Editors On The Blog
    Erotica
    Fiction
    Fiction Editing
    Freelancing
    Free Stuff
    Getting Noticed
    Getting Work
    Grammar Links
    Guest Writers
    Indexing
    Indie Authors
    Lean Writing
    Line Craft
    Link Of The Week
    Macro Chat
    Marketing Tips
    Money Talk
    Mood And Rhythm
    More Macros And Add Ins
    Networking
    Online Courses
    PDF Markup
    Podcasting
    POV
    Proofreading
    Proofreading Marks
    Publishing
    Punctuation
    Q&A With Louise
    Resources
    Roundups
    Self Editing
    Self Publishing Authors
    Sentence Editing
    Showing And Telling
    Software
    Stamps
    Starting Out
    Story Craft
    The Editing Podcast
    Training
    Types Of Editing
    Using Word
    Website Tips
    Work Choices
    Working Onscreen
    Working Smart
    Writer Resources
    Writing
    Writing Tips
    Writing Tools

    ARCHIVES

    March 2023
    January 2023
    December 2022
    November 2022
    October 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    November 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    July 2015
    June 2015
    May 2015
    March 2015
    February 2015
    January 2015
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    March 2014
    January 2014
    November 2013
    October 2013
    September 2013
    August 2013
    June 2013
    February 2013
    January 2013
    November 2012
    October 2012
    September 2012
    August 2012
    July 2012
    June 2012
    May 2012
    April 2012
    March 2012
    February 2012
    January 2012
    December 2011

    RSS Feed

Alliance of Independent Authors
Picture
Picture
CIEP Advanced Professional Member
The Publishing Training Centre
INFO ABOUT ME
Privacy policy
Terms and conditions
Contact form
Code of practice
Qualifications
​Portfolio ​ 
​Bio page
Louise's fiction
About Louise
INFO FOR INDIE AUTHORS
Editorial services
Contact form
Can you expect perfection?
Books and guides
Transform Your Fiction series
Free resources
​
Order form for books
Testimonials
Self-editing book

Want to sign up to my monthly newsletter, The Editorial Letter? 
INFO FOR EDITORS
Training courses​
Books and guides
​​Business Skills for Editors series
Transform Your Fiction series
Free resources
1:1 business consultations
Order books and courses
​The Editing Podcast
​The Editing Blog