SPREADSHEET: Project, Profit and Efficiency Tracking (Excel)

Sophie Playle

Track the editing projects you work on, the profit you make from them, and how efficiently you work.

In this Excel spreadsheet, prewritten formulas work out how much you’ve earned per thousand words, how many words you’ve edited per hour, and how much you’ve earned per hour. (Works with all currencies.)

This data will help you assess the health of your business, price future projects, and work out ways to increase your efficiency.

It’s not a huge and complicated spreadsheet. Instead, it’s quick and easy to fill out, giving you the essential information you need.

(Note: The spreadsheet is designed for projects with a pre-determined fee. It won’t work out a project fee based on an hourly rate, for instance.)

Price: £10

BUY NOW

Sophie Playleworked as a professional editor for 15 years, specialising in developmental editing and copy-editing fiction. Her favourite part of the job was working on imaginative speculative fiction with a literary slant, and reading manuscripts in the bath. She has been teaching editorial skills online for over a decade, and offers online courses and resources to help other editors run their businesses with confidence and skill. Find out more: liminalpages.com

Liminal Letters

The newsletter that shares lessons and reflections on the art and business of editing.

Course updates, special offers and honest opinions on the editing and publishing industry – plus insights into the life of a small business owner: how I juggle a toddler (not literally), limited hours and high ambitions while trying to cultivate meaningful work.