Freelance Graphic Designer Income and Expense Spreadsheet
A designer's income arrives in stages tied to a project: deposit, milestone, final balance. Meanwhile fonts, stock assets and app subscriptions repeat on their own schedule, so the sheet has to hold both rhythms.
How a graphic designer gets paid, and what that means for the sheet
Most design work is quoted per project and paid in stages: a deposit to start, a payment at a review milestone, and a balance when final files go out. Retainers for ongoing social or packaging work arrive monthly. Each stage is its own payment, often from the same client, so one project can produce three separate lines over several weeks.
Log each payment as Income on the day it arrives, with the project and stage in the Description so a deposit and its balance are easy to match. Give retainer months one Income line each, with the month they cover in the Description. If a marketplace pays you, log the gross amount as Income and the platform's cut as an Other expense row.
One example month, logged
Invented numbers, to show the shape. Each row below is one line on the Transactions tab.
| Client | What it was | Income |
|---|---|---|
| Northwind Cafe | Brand identity, 50% deposit | $1,200 |
| Juniper Dental | Website UI design, milestone 2 | $2,400 |
| Alder & Finch Books | Packaging label redesign, final balance | $1,800 |
| Pinecrest Brewing | Monthly social templates retainer | $650 |
| Income total | $6,050 | |
| Category | What it was | Expense |
|---|---|---|
| Software & subscriptions | Figma and Adobe seats, monthly | $95 |
| Software & subscriptions | Font license for a client brand | $149 |
| Equipment | Second monitor | $240 |
| Equipment | Drawing tablet | $380 |
| Contractors | Illustrator for icon set | $600 |
| Marketing | Printed sample booklets for prospects | $85 |
| Home office | Desk lamp and monitor arm | $70 |
| Professional fees | Contract template from a lawyer | $300 |
| Other expense | Stock photo credit pack | $49 |
| Expense total | $1,968 | |
In this example the month ends with $6,050 in, $1,968 out and $4,082 left before you set anything aside for tax.
The P&L tab sorts the same rows by category:
| Expense category | Month total |
|---|---|
| Software & subscriptions | $244 |
| Equipment | $620 |
| Contractors | $600 |
| Marketing | $85 |
| Home office | $70 |
| Professional fees | $300 |
| Other expense | $49 |
| Expense total | $1,968 |
Where a graphic designer's purchases go
- Software & subscriptions: Adobe and Figma seats, font licenses, plugin packs and cloud storage all land here. A font licensed for one client's brand still goes in this category: put the client in the Description so you can find which license covers which job.
- Contractors: Illustrators, copywriters and developers you bring in for one project go in Contractors. Record the payment on the day you send it, with the client's project in the Description, so the deposit that funds their work can be matched to it.
- Equipment: A tablet, a second monitor or a calibration tool is Equipment. A desk lamp or monitor arm is Home office instead. When one receipt mixes both, enter two rows so the larger purchase is not hidden inside a small one.
- Marketing: Printed sample booklets, award entry fees and paid portfolio ads belong in Marketing. Portfolio hosting billed as a monthly plan fits Software & subscriptions better. If a print run covers both your samples and a client's job, split the receipt.
Four tracking tips for a graphic designer
- Put the project name and stage in the Description of every deposit, milestone and balance, such as 'Juniper Dental, UI design, milestone 2'. When a client asks what has been paid, filter the Transactions tab by that name.
- Note the client's name on every font and stock asset license the day you license it. When a client later asks for the files again, or wants to extend usage, you can see exactly which license covered which project.
- Log extra revision rounds as their own Income lines, with a Description like 'Round 3 revisions'. Over a year those lines show which kinds of clients keep expanding scope, and whether your quotes leave room for it.
- Fill in the Date paid on a retainer invoice in the Invoices tab only when the money lands, and log the Income row the same day. The two tabs are not linked, so each needs its own entry.
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 $620 on the example month. - Income from one client:
=SUMIFS(Transactions!F:F,Transactions!B:B,"Income",Transactions!E:E,"Northwind Cafe")returns $1,200 on the example month.
Questions
Do I log a design deposit when I send the invoice or when it is paid?
When it is paid. Until then the invoice sits in the Invoices tab with no Date paid. When the money lands, fill in the Date paid there and add the Income row in the Transactions tab with the project and stage in the Description, since the tabs are not linked.
What if a client cancels after paying a deposit?
Leave the deposit as Income, and add a kill fee as its own Income line if your contract has one. If you return money, record it as a separate Expense row in Other expense that names the original payment, so the history stays readable.
Already built
The Freelancer Finance Spreadsheet Kit has the Transactions, Invoices, P&L, Cash Flow and Tax Set-Aside tabs wired together, with this kind of example data on every tab. One Excel file, $29.
Free: the Tax Set-Aside tab as a standalone Excel file
One working tab: type your quarterly income, expenses and the rate you choose, and it shows what is still to put aside. Confirm your email and the file arrives right away, plus an occasional note (at most one a week) on tracking freelance money. Unsubscribe in one click. Privacy.
The same sheet for other freelancers
- All freelancer spreadsheet guides by profession
- Freelance Consultant Income and Expense Spreadsheet Template
- 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
- Freelance Writer Income and Expense Spreadsheet for Articles
- 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.