Freelance Writer Income and Expense Spreadsheet for Articles

A writer's income comes in pieces: a per-word fee here, a retainer there, a deposit on a long project. The money often arrives weeks after the work is filed, and costs like research, editing tools and conference trips are small and scattered.

How a writer gets paid, and what that means for the sheet

Writers are paid by the word, by the article, or by a monthly retainer for a set number of pieces. Most publications pay after the piece runs, not when you file it, so the invoice date and the payment date can sit weeks apart. Retainers from content agencies arrive on a steady day, while one-off features land whenever an editor approves the invoice.

Long projects such as a book proposal or a white paper are often split into a deposit and a balance. Log each as its own Income row, with the word deposit or balance in the Description. Content platforms usually pay out net of their cut, so log the amount that reached your account and name the platform as the client.

One example month, logged

Invented numbers, to show the shape. Each row below is one line on the Transactions tab.

In this example the month ends with $5,300 in, $1,097 out and $4,203 left before you set anything aside for tax.

The P&L tab sorts the same rows by category:

Where a writer's purchases go

• Software & subscriptions: Grammar checkers, transcription apps, paid research databases and cloud drafts folders go here. If one subscription serves both your writing and a day job, say so in the Description and log only the part you use for freelance work.
• Equipment: A laptop, headphones for transcribing interviews and a digital voice recorder all sit under Equipment. A receipt that bundles a case or cables can stay as one row; add a short Description so you remember what the total covered.
• Contractors: A fact-checker, a transcriber or a researcher hired for one piece goes under Contractors. Put the piece title in the Description. If the same person works on several pieces, split the payment into one row per piece.
• Travel: A reporting trip often mixes a train ticket, a hotel and meals on one pile of receipts. Log transport and lodging under Travel, and give a conference registration fee its own row under Professional fees.

Four tracking tips for a writer

1. Put the piece title and the agreed word count in the Description of every invoice. When an editor cuts the piece and pays less, the difference is visible without digging through old emails.
2. On the first of each month, open the Invoices tab and check which of your entered invoices show Overdue in the Status column. Those are your queue for polite reminder emails.
3. Log reporting costs, such as a transcription service or a library day pass, as small separate rows with the piece title in the Description. If the piece never runs, you still see what it cost.
4. Writing income arrives in lumps, so log each payment as it lands, then check the Tax Set-Aside tab for the amount to put aside and move it to a separate account. Ask your tax adviser what share suits you.

Two formulas worth a cell of their own

These use the kit's Transactions tab (Type in column B, Category in C, Client / Vendor in E, Amount in F). Excel and Google Sheets both support SUMIFS.

• Spend in your biggest category, here Equipment: =SUMIFS(Transactions!F:F,Transactions!B:B,"Expense",Transactions!C:C,"Equipment") returns $255 on the example month.
• Income from one client: =SUMIFS(Transactions!F:F,Transactions!B:B,"Income",Transactions!E:E,"Harbor Tech Blog") returns $1,100 on the example month.

Questions

How do I log a kill fee in my freelance writing income tracker?

Log it as its own Income row on the day it arrives, with the publication as the client and kill fee in the Description. Keep it apart from the full rate, which was never paid, so you can see how many assignments fell through.

Should I log an article as income when I file it or when I get paid?

Log Income in the Transactions tab when the money arrives. Enter the invoice on the Invoices tab with its issue date, so unpaid pieces stay visible, and add the Date paid there once it clears. The two tabs do not link, so a paid article goes on both.

The same sheet for other freelancers

• All freelancer spreadsheet guides by profession
• Freelance Consultant Income and Expense Spreadsheet Template
• Freelance Graphic Designer Income and Expense Spreadsheet
• Income and Expense Spreadsheet for Freelance Photographers
• Freelance Social Media Manager Income and Expense Spreadsheet
• Freelance Translator Spreadsheet for Per-Word Income and Costs
• Freelance UX Designer Income and Expense Spreadsheet
• Freelance Video Editor Spreadsheet for Income and Expenses
• Freelance Virtual Assistant Income and Expense Spreadsheet
• Freelance Voice-Over Artist Income and Expense Spreadsheet
• Income and Expense Spreadsheet for Freelance Web Developers
• Online Tutor Income and Expense Spreadsheet for Lesson Payouts

More freelancer finance guides

• Excel or Google Sheets for freelancer finances? What actually differs
• Freelance expense categories for a spreadsheet: a starter list that stays short
• How to build a freelance income and expense tracker in a spreadsheet
• A simple 12-month cash flow forecast for freelancers
• Freelancer profit and loss (P&L) in a spreadsheet: a one-page layout
• Freelancer runway: three spreadsheet formulas for how long your cash lasts
• Freelancer tax set-aside: what goes into the number, and how to track it
• Invoice tracker spreadsheet: formulas for paid, due and overdue
• Budgeting on irregular freelance income: the baseline-pay method
• How to track freelance income by client in a spreadsheet

General information about using spreadsheets, not financial, tax or accounting advice. Example numbers are invented. Categories are for tracking and do not say what is deductible.