If you're looking for an easy and free way to schedule your editing and proofreading projects – clients, income, payment-due dates – this free Excel template is for you.
Keeping track of editing and proofreading projects is essential for every professional editor.
Download this free Excel template to get you started. The figures are completely made up but show the basic structure. If you're a newbie, you can use this as an interim way of managing your accounts and your schedule; one less thing to worry about for now!
This template includes a number of columns with formulae that I find useful.
I like to differentiate between different stages of the process:
It helps me to see, at a glance, what's going on in my schedule, especially when a client asks about availability.
I also track how the job will be returned to a client: via email, the post office or courier (at the client's expense). The UK's HMRC allows the freelancer to offset a percentage of mileage costs against their tax liabilities.
There's a summary box at the bottom of the spreadsheet. This shows me my average earnings, my average hourly rate and my average rate per 1,000 words.
These figures are really only for curiosity, since each job varies quite considerably in size, type, budget, difficulty and speed. If I was doing any serious analysis I'd look more deeply into the data to assess whether there are patterns in terms of, say, client type, service offered and subject matter. Still, it's useful for grabbing quick-and-dirty data for annual comparisons.
Feel free to copy, amend or ignore as you see fit. You can add your own formulae to particular columns if the way in which you charge for your work differs.
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 Society for Editors and Proofreaders (SfEP), a member of ACES, a Partner Member of The Alliance of Independent Authors (ALLi), and an Associate Member of the Crime Writers’ Association (CWA).
Visit her business website at Louise Harnby | Proofreader & Copyeditor, say hello on Twitter at @LouiseHarnby, or connect via Facebook and LinkedIn.
'Louise uses her expertise to hone a story until it's razor sharp, while still allowing the author’s voice to remain dominant.'
'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.'
'What makes her stand out and shine is her ability to immerse herself in your story.'
'A million thanks – your mark-up is perfect, as always.'
All text on The Editing Blog and on the other pages of this website (unless indicated otherwise) is in copyright © 2011–20 Louise Harnby.
© Louise Harnby 2011/20
Want to thank someone special with the gift of editorial training? Find out more about my training gift vouchers.