Tag Archives: record keeping

Flying Solo: Facts for fiction editors

In this Flying Solo column, Sue Littleford looks at how the Going Solo toolkit’s work record spreadsheet can be modified for use by fiction editors, and finds out how three fiction editors keep records about their work.

Fiction editors can’t avoid diving into non-fiction when they’re running their businesses rather than editing. The Going Solo toolkit’s work record spreadsheet (available as a member benefit – you’ll need to be logged in to the CIEP website to download it) is heavily geared towards the kind of breakdown of jobs that a non-fiction editor will find useful. Those categories don’t really work for fiction editing, beyond word count, time taken and fee charged, so I’ve been talking to three fiction editors about their own record-keeping.

Why keep records about completed work?

Editors and proofreaders in all niches need to keep track of their work and the time it takes them if they’re to have a solid basis from which to calculate quotes of cost and time. In June 2021, I looked at how to use the filter with a spreadsheet of data about the work you’ve done to get the best use of it when it comes to preparing a new quote or estimate.

Another benefit of compiling records of your work (for CIEP members and prospective members) is that you can send in a spreadsheet of the relevant details with an upgrade application instead of having to type out everything again on the application form, and it’s easy to see when you’ve achieved the necessary hours of experience.

But the main and ongoing benefit is not having to snatch figures out of the air when it comes to your pricing, and knowing the answer to the eternal question ‘How long will it take?’ You can also see if you’re getting faster or slower overall, see the impact using a new tool makes on your speeds (or a change in the material you’re working with) and, especially with repeat clients, ensure consistency in your pricing approach, and see how jobs from a particular source compare.

If you provide several services – manuscript assessment, development editing, structural editing, line editing, copyediting, proofreading – you can also see which is the most rewarding in a financial sense, which gives you best return for your time, and it helps you to tailor bundles of services at a sensible price for your business.

And now, a warning! You may be tempted to keep minimal records, perhaps just your invoices, but you really should be keeping full records: anyone planning on upgrading (and all members will need to achieve PM status to remain in the Institute, which means applying for at least one upgrade: see p4 of the Member Handbook for time limits) will need a record of the work they’ve done to show that they have the requisite hours of the right type.

In addition, in the UK, you will need to be able to show HMRC evidence of the hours you work, in order to support your calculations for tax relief on the costs of working at home. If you live (or at least pay tax) elsewhere, be sure to check your own country’s requirements – but if you still have CIEP upgrades to do, you’ll need your breakdown of hours worked available and categorised.

Facts for fiction editors is definitely A Thing!

Three editors, three approaches to record-keeping

Here’s how three editors handle their records.

1. Going Solo toolkit with modifications

Now an editor of fiction and creative non-fiction, APM Jill French started her business mainly focused on non-fiction, and finds the Going Solo toolkit’s work record spreadsheet works well for her way of thinking, with the addition of ‘manuscript assessment’ as a category of work. Each round of editing the same book is logged as a separate job, which gives her enough data to analyse when it comes to pricing another job of the same stage.

2. Combining two off-the-shelf systems

IM Katherine Kirk uses both the work record from the Going Solo toolkit and Maya Berger’s TEA system (CIEP member discount available). Katherine is working towards PM status and finds the analysis and tracking offered in the jobs spreadsheet helps her to maintain a good record to support her application in due course. But she finds that TEA works better for her for financial records, and so she maintains both, having simply hidden the columns that are irrelevant to her business (columns N–S from the Going Solo spreadsheet).

Katherine uses the average words per hour for that particular kind of work to inform her estimates, but, depending on the client, may also do a sample edit to check. She records these sample edits in TEA in order to be prepared if that client comes back. If the client doesn’t return, Katherine has data ready to hand on the price she quoted, and can see what impact changing the price has on landing the client.

3. Tailored record-keeping

Nicky Taylor, an APM, has developed her own record-keeping system over the years. Like Jill, she records each type of work for the same book as separate jobs, so a development edit and a copyedit get their own rows in her spreadsheet.

Nicky said to me, ‘Looking at all my data made me realise that manuscript critiques on their own were simply not financially viable, so I stopped offering that service; if I hadn’t recorded everything, I doubt I would have known.’ Music to my ears about the real-world value of keeping business data.

For a development edit, Nicky records the onboarding time, reading time, report-writing time; for a copy- or line edit, she will record the time spent on each pass – she always does a full read-through and two passes, and has a column in her spreadsheet for each of these.

Included in her records are columns for pre-returning the job, which covers time for checking comments, checking over the style sheet and completing the handover tasks. Another column captures the time spent on post-edit revisions, post-edit discussions with the author, and emails. If a PDF conversion or layout work is required, this time also goes into that post-edit column.

Most of the time, the production of the style sheet is absorbed into the two passes, but may be recorded separately if the occasion demands. Production of a bible, perhaps for a planned series, will be logged separately.

Nicky includes an ‘Other’ column in her spreadsheet for different kinds of jobs, such as consultancy and other requests, recording the exact nature in the job description column. Like Katherine, Nicky also uses TEA for her financials.

The Going Solo toolkit: Work record spreadsheet

The CIEP has decided to follow Jill’s recommendation, and has added manuscript assessment to the dropdown list of types of work, which would include the kinds of tasks covered by Nicky’s ‘Other’ column. If you’re already using the spreadsheet and would like to add this to your own records, you can either download the new version (be sure to be logged in to the CIEP website first) and copy your records across, or extend that dropdown list yourself. It’s easy!

NB: All screenshots show Excel 365 on a PC. The instructions apply to PCs but Microsoft tells me they also work for Macs.

1. Select column ‘Type of work’ by clicking on the column header (D), which turns the column grey. A black down-arrow shows when your cursor is in the right position to select.

2. On the Data tab …

… open Data Validation in the Data Tools group by clicking the little down-arrow:

3. Select Data Validation from the dropdown menu:

4. You’ll see this:

Click Yes.

5. You’ll see this:

Now you can type a comma, a space and MA into the end of the Source box.

Check the ‘Apply these changes to all other cells with the same settings’ box if you’ve added other tabs that have this same list, otherwise you can leave it blank.

It will look like this:

Click on OK.

You’re done! You can now use the new code, and you can, if you like, add others that suit the work you do. You might want to add consultancy as a category, for instance, if that makes sense for the work you do. You don’t have to use codes – you could spell out the entire word, or use a fuller abbreviation. Once you’ve got the hang of this, you can personalise your spreadsheet exactly as you like. That said …

Four reminders

Reminder #1

The Admissions Panel explained to me, when I was developing the Going Solo toolkit, that they want to see your copyediting and proofreading hours on your upgrade application, so remember to keep recording these clearly and separately, no matter what else you decide to record.

Reminder #2

If you’re not sure how to get the best use of the data you’ve gone to the trouble of collecting, see my earlier ‘Flying solo’ post on using the filter functions.

Reminder #3

The sooner you start keeping detailed records, the sooner you’ll have compiled a useful bank of data to help with price and time estimation for new jobs.

Reminder #4

If you’re inspired by Nicky’s level of detail, don’t forget that you can continue to personalise your own copy of the Going Solo toolkit work record. Inserting additional columns is easy!

1. Click on the column letter immediately to the right of where you want to insert a new column.

Here, I’ve highlighted column I – see the colour change where the column’s label is, and the column itself has turned grey.

2. Right-click, then select Insert and a column will arrive between, in this example, Author name(s) and Total time taken (hours).

3. … and you will get this:

4. The Author name(s) column is still H, but Total time taken (hours) is now column J and we have a new, blank column I. Type in the name you want for the heading. Repeat as often as you need to add new columns, always clicking at the head of the column to the right of where you want to add a new one.

5. Columns in the wrong order? Move them with cut and paste. The column will always paste in to the left of where you click, as creating the new column did.

6. Unneeded columns? Instead of clicking on Insert, click on Delete if you’re sure you don’t want that column, or Hide, if you think you may need it at some point. (To unhide, select the columns on either side of the hidden column(s) and right-click; click on Unhide.)


Buy a print copy or download the second edition of Going Solo: Creating your freelance editorial business from here.

About Sue Littleford

Sue Littleford is the author of the CIEP guide Going Solo, now in its second edition. She went solo with her own freelance copyediting business, Apt Words, in March 2007 and specialises in scholarly humanities and social sciences.

 

About the CIEP

The Chartered Institute of Editing and Proofreading (CIEP) is a non-profit body promoting excellence in English language editing. We set and demonstrate editorial standards, and we are a community, training hub and support network for editorial professionals – the people who work to make text accurate, clear and fit for purpose.

Find out more about:

 

Photo credits: office desk by Jessica Lewis Creative, laptop by Karolina Grabowska, both on Pexels.

Posted by Harriet Power, CIEP information commissioning editor.

The views expressed here do not necessarily reflect those of the CIEP.

Wise owls: Managing money

It’s coming up to the end of the UK tax year (5 April) – the CIEP’s wise owls have turned their thoughts to keeping track of income and outgoings.

Liz Jones

Here are some things I’ve learned about managing money in 12 years of freelancing:

  • Tax is a potential killer. I’m happy and proud to pay tax, but it’s one of the things I’ve found most challenging to manage in terms of cash flow, especially in years when I’ve taken a few weeks’ ‘maternity leave’. It’s really important to set aside more than you think you’ll need: if your earnings fluctuate, so will your tax bills. I’ve found paying an accountant to be a worthwhile cost to help me get my tax calculations right and understand how I can make the most of allowances.
  • It’s essential to get into a position where you’re not depending on a particular payment being made on time in order to pay vital bills such as the rent or mortgage. Even with the best clients, timely payment is not 100% reliable.
  • I never justify charging clients a high rate by citing my circumstances. As it happens, mine is the main income for my family, but that’s irrelevant to them. They’re paying for my work, not to support my lifestyle.
  • I use FreeAgent to manage my invoicing, and my accountant takes the information directly from this to complete my tax return. It’s not free but it’s saved me a lot of time over the past few years.
  • I chase invoices as soon as they go overdue. After once losing nearly £2,000 on an unpaid invoice when a client went into administration, I also invoice regularly in smaller stage payments for large jobs, to mitigate the risk of a client going bust.

Louise BolotinLouise Bolotin*

My nickname is The Spreadsheet Queen! I use spreadsheets for everything, although I’m barely proficient in Excel. No matter, as you don’t need to be. I created a spreadsheet to track my invoicing just by setting up a few columns with headings such as date, client, what the job was, PO number (if applicable), how much I billed, when I invoiced, when the money is due, etc. I have extra columns for notes and to tick off when my client has paid. I also have a spreadsheet for tracking client hours, with my per hour rate in a column. I bill some of my clients monthly, so I can tot up jobs on the tracking spreadsheet and transfer the billable sum to my invoicing one.

My outgoings are minimal – I’m mindful that expenses are tax-deductible (mostly). My biggest expenses are my CIEP fees (and conference, if I decide to go) and my trade union subs. Then there are costs for software, and, occasionally, stationery, plus fees for my accountant and PC fixer (an essential expense!). Again, I track all these on a spreadsheet – it’s useful to see how much I’m spending per year, including versus how much I’m making. I aim to limit expenses to 5% maximum of my turnover, but it’s usually below that.

I check my business bank account on my phone daily to see what’s gone in (or out). Yes, I have a separate business account – I find it easier to track income and expenses without having to trail through my supermarket shopping, Spotify subs and utility bills. It’s not possible to separate business and personal completely, but it’s about 99% foolproof. I set aside 20% of every invoice as it’s paid – it goes into a dedicated savings account for my tax bill after my accountant has filed my tax return. Setting that aside also stops me from thinking I have more disposable income than I actually have.

Hazel Bird

Managing money is about finding a system that suits your business model. For example, if you’re raising lots of low-value invoices, it might be worth paying for a system that raises, sends and tracks invoices for you, and integrates this data into an accounting package. I’ve seen CIEP members recommend the likes of Crunch, FreshBooks and QuickBooks for this purpose. I tend to raise fewer high-value invoices, so I use an Excel template (which I complete and convert to PDF) and do my tracking in Google Sheets. This lets me geek out with functions to create my own personalised reports. It also means I have no money-management-related expenses beyond the time I take.

It’s definitely not essential to have an accountant, especially if your finances are simple. But naturally this means keeping on top of current tax and accounting requirements, particularly if you’re registered for VAT or invoicing clients in jurisdictions outside the UK. Members often raise very helpful threads on these topics on the CIEP forums.

Finally, there’s a stereotype that freelancers never complete their tax returns until the week they’re due – and then discover we owe the government far more than we expected. I’ve always consciously avoided that approach, because it’s important to me to know my exact tax liability and ensure my cash flow will cover it. To make this as painless as possible, I tend to be one of those insufferable people whose accounts are always up to date. This is inevitably a bit tedious, but it shouldn’t be too tedious. Your system should slot into your work as seamlessly as possible. Money management should serve our businesses, not the other way around.

Nik ProwseNik Prowse

A wise man – a mentor from my early days as a freelancer – once said to me: ‘Put aside your tax money before you spend it.’ He also advised separate bank accounts. So I have a bank account into which all of my business income goes, and as soon as I have a receipt I put a percentage of it into a savings account to cover tax and National Insurance. I set the percentage slightly over what my tax will be, so that I save something each year just by hiving off my tax money.

I don’t use anything other than Microsoft Excel to manage my business income. I have a spreadsheet with columns for date, project name, invoice number, ingoings and outgoings, with a reminders column for payments due for bills and the mortgage. I have separate sheets for the money put aside for tax, business expenses and income from clients. That way, when my tax return is due my business income and outgoings are all present in one handy file.

These two systems have always allowed me to know how much I have, and to be certain that I can’t dip into crucial money that will need to be paid to HMRC.

Sue BrowningSue Browning

My key advice is to do things as you go rather than leaving them to pile up and need sorting out later. Sent an invoice? File it and record it on your income sheet. Renewed your CIEP subscription? File the invoice/receipt and record it on your expenses sheet. I give each invoice and expense a unique reference. Then each month, I download my business bank statement and reconcile it with the invoices issued, marking up each item on the statement with its reference number in my accounts. This reconciliation takes me less than half an hour each month. I do everything electronically, scanning paper receipts on the rare occasions I receive them. I also use a program called Cushion for scheduling, time-tracking and invoicing so my information is all in one place, but do what works for you.

I also put about 20% of my month’s income into a savings account earmarked for tax. This means I don’t dread the total when I submit my return. My accounts spreadsheet has a totals worksheet that collects the monthly figures and gives me an annual total. Come tax return time, I have only to refer to that sheet, knowing that all my invoices and receipts are in order, so my tax return takes me about half an hour. That’s when I am grateful to past me for taking a few minutes regularly to keep on top of things.

Sue LittlefordSue Littleford

Knowledge is a wonderful thing. First, know your money style. Are you disciplined? Does it trickle through your fingers? Track your invoices, and pounce on any that become overdue the first day they’re overdue. Don’t be shy. You’re in business, not pursuing a hobby. Be polite but firm, and repetitive – it works in most cases. Don’t be afraid you’re ‘nagging’ – you’ve done the work, so your client should pay up! Budget for your business and household expenses: work out what you want to spend on training, marketing, CIEP membership and conference attendance, materials, resources and overheads – and know when those become due.

Work out what you need to live on, likewise. Use that knowledge to help you set the hourly rate you want to earn. A simple spreadsheet of your invoices with a running total can be used to forecast your tax and National Insurance bill. According to your money style, either save enough from each paid invoice to pay the tax on that invoice or do your tax return as early as you can and set up a direct debit with HMRC to pay in monthly instalments (more like a PAYE scheme, and there’s no temptation to dip into your tax pot before you pay it to HMRC). With interest rates so low, the satisfaction of knowing you’re paying down that tax bill rather than saving the money and earning on it may balance out easily. Attend HMRC webinars on business expenses and filling in your tax return.

*Louise Bolotin died in October 2022; her contributions are much missed.


If you’re starting out on your freelance journey, the CIEP’s guide Going Solo covers the finance basics, including tax and record-keeping obligations.


Photo credit: owl – Dominik VO on Unsplash

Proofread by Victoria Hunt, Intermediate Member.
Posted by Abi Saffrey, CIEP blog coordinator.

The views expressed here do not necessarily reflect those of the CIEP.