Income records, organized by work

A structured alternative to a royalty and licensing spreadsheet

If you earn royalties or licensing fees on creative work, a spreadsheet row can capture the number but not the statement behind it. Months later you have a figure for "Q2 Spotify" with no PDF attached, a licensing payment you can't tie to a contract, and three platforms whose statements live in three different inboxes. Cash Workspace gives you an organized place to keep the same information as records: one record per work per period, with the actual payout statement attached, the paying platform or licensee named, and the amount written down. It is a free workspace for organizing income tied to your creative works — a per-work payout ledger you can actually open and verify, not a cell you have to trust. This page covers only royalty and licensing payouts tied to a specific work; it is organizational guidance, not tax or accounting advice.

The problem

Why a royalty spreadsheet stops holding up

A spreadsheet is a fine place to start, but royalty and licensing income has a shape that single rows struggle with. Payouts arrive on different cycles from different payers, each with its own statement format, and the number in the cell is only as trustworthy as your memory of where it came from. The moment you need to prove a figure — at tax time, when an accountant asks, or when a payout looks wrong — the supporting document is the thing you actually need, and a spreadsheet doesn't hold it.

  • A cell says '$412.18' for a quarter, but the statement PDF that explains the streams, units, or territories behind it lives somewhere else entirely.
  • One spreadsheet tab mixes a music distributor, a stock-photo site, and a private licensing deal — three payers with three statement formats crammed into the same columns.
  • You can't tell at a glance which periods you've actually received and filed versus which you only estimated, because a number looks the same whether it's verified or guessed.
  • When a licensee pays late or short, there's no place to keep the back-and-forth or the corrected statement next to the original record.
  • Handing the year to an accountant means re-collecting every statement from email and platform dashboards, because the spreadsheet pointed to none of them.

The workflow

Building a per-work royalty and licensing ledger

The idea is to keep the same ledger you'd build in a spreadsheet, but make each entry a record that carries its own proof. You organize by the work (a book, a track, a photo collection, an app, a patent), then keep one record per payout period under it. Here is a practical way to set it up. Cash Workspace does not sync with your bank or any platform and does not read your statements automatically — you upload each statement and enter the amount yourself, which is exactly what keeps the record verifiable.

  1. 1

    Make a folder per work or title

    Create one folder for each creative work that earns royalties or licensing income — for example 'Novel – The Salt Road', 'Track – Midnight Line', or 'App – TideClock'. This is the spine of your ledger: everything for that work lives in one place, no matter how many platforms pay you for it.

  2. 2

    Add one record per payout period

    Inside each work's folder, add a record for each payout you receive — 'Spotify – 2026 Q1', 'Getty – Mar 2026', 'Penguin – H1 2026'. Name the payer and the period in the record name so the folder reads like a chronological ledger at a glance.

  3. 3

    Attach the actual payout statement

    Attach the statement file you received — the distributor's quarterly PDF, the stock site's payout report, the licensee's remittance email saved as a document. The record now holds the proof, not just the figure. If a statement is corrected or re-sent, attach the new version alongside the original.

  4. 4

    Record the amount, payer, and period fields

    Fill in the per-record fields: gross amount, any fees or deductions shown on the statement, net received, payer, period covered, and payment method. These are the same columns you'd keep in a spreadsheet, now attached to the document that backs them.

  5. 5

    File completed years into fiscal-year folders

    As periods close, group them under a fiscal-year folder per work — 'Novel – The Salt Road / 2026' — so each year's royalty history for that title is a self-contained set you can hand off or review without scrolling a 200-row sheet.

  6. 6

    Export the records when you need them elsewhere

    When tax season or an accountant handoff comes, export the records so the per-work, per-period totals and their attached statements travel together as an accountant-ready set, instead of re-gathering everything from scratch.

Record structure

Fields to record per payout

These are the details worth capturing on each royalty or licensing payout record. They mirror the columns you'd keep in a spreadsheet, but each one now sits next to the statement that proves it. Capture what your statements actually show — not every payer reports the same breakdown.

Work / title
The specific creative work the payout belongs to — book title, track name, photo set, app, design, or patent. This is what ties the record to its folder.
Payer (platform or licensee)
Who paid you: a distributor or marketplace (e.g., Spotify, Amazon KDP, Getty Images, the App Store) or a named licensee on a private deal.
Period covered
The reporting window the payout represents — '2026 Q1', 'March 2026', or 'H1 2026' — not the date it hit your account.
Gross amount
The total before any platform fees, splits, or withholding shown on the statement.
Fees / deductions
Distribution fees, processing cuts, collaborator splits, or withholding noted on the statement, copied exactly as reported.
Net received
The amount you actually received after deductions — the figure you'd otherwise put in a single spreadsheet cell.
Payment method / reference
How it arrived (bank transfer, PayPal, platform wallet) and any payout or statement reference number for matching later.
Status note
A short flag such as 'received and filed', 'short — under query', or 'estimate, statement pending', so verified periods are obvious.

Example setup

An example royalty and licensing layout

Here is how a working creator's payout folders might look. Each work is a folder; each payout period is a record inside it with its statement attached. Note how a single work can collect payouts from several payers without them blurring together.

Novel – The Salt Road / 2026

Records: 'Penguin – H1 2026' (royalty statement PDF, gross $1,840, agent split noted, net $1,564), 'Amazon KDP – Jan 2026', 'Amazon KDP – Feb 2026', 'Audible – 2026 Q1'. Each holds the payer's statement and the net received.

Track – Midnight Line / 2026

Records: 'Spotify – 2026 Q1' (distributor report attached, streams and net), 'Apple Music – 2026 Q1', 'Sync license – Indie Film Co. (one-time)' with the signed-off remittance and the period of use noted.

Photo set – Coastal Series / 2026

Records: 'Getty – Jan 2026', 'Getty – Feb 2026', 'Shutterstock – 2026 Q1', plus 'Direct license – Regional Tourism Board' holding the licensee's payment confirmation.

App – TideClock / 2026

Records: 'App Store – Mar 2026' and 'Google Play – Mar 2026', each with the platform payout report attached, gross, platform cut, and net received recorded per month.

_Pending & queries

A holding folder for periods awaiting a statement or under dispute: 'Getty – Apr 2026 (statement not yet issued)' and 'Penguin – H1 short payment query' with the correspondence kept until resolved and refiled to its work.

Common mistakes

Common mistakes to avoid

  • Recording the net number but not attaching the statement — the figure is only useful later if the document that explains it is right there with it.
  • Filing by payer instead of by work, so a single book's earnings scatter across a 'Spotify' folder, an 'Amazon' folder, and an 'Audible' folder with no per-title total.
  • Logging the date the money landed as the 'period', which detaches the payout from the quarter or month it actually reports on.
  • Mixing royalty and licensing income with general platform sales takings or direct client invoices — keep those in their own ledgers so this one stays cleanly per-work.
  • Leaving estimated and confirmed amounts looking identical, with no status note to tell which periods you've actually received a statement for.
  • Treating a corrected or re-sent statement as a replacement — keep the original alongside it so the history of the payout stays intact.

How it helps

How Cash Workspace helps with this

A folder per work, records per period

Organize royalty and licensing income the way it's actually earned — by the creative work — with one record per payout period underneath, so each title's history reads like a clean ledger.

Statements attached to the record

Attach the distributor report, stock-site payout, or licensee remittance directly to the record it belongs to, so the proof and the amount never drift apart.

Fiscal-year folders for each title

Group closed periods into per-work fiscal-year folders, so a year of royalties for one work is a self-contained set you can review or hand off without rebuilding it.

Accountant-ready export

Export the records so per-work, per-period figures and their attached statements travel together when you send them on — no re-collecting from dashboards and email.

FAQ

Royalty and licensing record questions

Can Cash Workspace pull my royalty payouts in automatically from Spotify, Amazon, or a licensee?
No. Cash Workspace does not sync with your bank or any platform and does not read or extract figures from your statements. You upload each payout statement and enter the amount yourself. That manual step is what makes every record verifiable rather than guessed.
Should I organize by platform or by work?
By work. Keep one folder per title or creative work, and put each payout period inside it as a record — even when several platforms pay you for the same work. That way each title shows its full earning history in one place instead of scattering across payer folders.
How do I handle a payout that covers several of my works at once?
Keep the original combined statement attached wherever it's most natural for you, and create a record under each affected work for its share, with a note pointing to the source statement. The goal is that each work's folder still reflects what that work earned.
Does this replace my accountant or tax software?
No. This is an organizational workspace for keeping royalty and licensing records and their statements together. It does not give tax or accounting advice and is not certified accounting software. It helps you arrive at tax time with an organized, exportable set of records to hand off.
Is it really free?
Yes. Cash Workspace is free to use for organizing your invoices, expenses, receipts, business documents, and income records like these royalty and licensing payouts.

What this page is — and isn't

This is organizational guidance for keeping royalty and licensing payout records, not tax, legal, or accounting advice. Cash Workspace helps you store and organize statements and amounts per work and per period; it does not sync with your bank or any platform, does not read or extract figures from your statements, does not classify documents automatically, and is not certified accounting software. You enter the amounts and attach the statements yourself, and any figures or categories you record are your own. Cash Workspace is operated by HELPERG LLC; questions go to info@helperg.com.

Start a free royalty and licensing workspace

Set up a folder for your first work, add this period's payout as a record, and attach the statement that backs it. In a few minutes you'll have the start of a per-work royalty ledger you can actually open and verify — and it's free. Add the rest of your titles as the next payouts arrive.