Freelancer Profit Tracker: How to See Which Project Actually Makes Money
I built my first freelance spreadsheet in 2019. It had one tab, twelve rows (one per month), and three columns: revenue, expenses, profit. For a year it told me I was making money. The year I added a second income stream — a small newsletter alongside client work — the spreadsheet broke in a way I didn't notice for three months. On paper, both businesses were healthy. In reality, the newsletter was losing me $1,400/mo once you counted the research hours it ate from billable client work.
That experience is how Hustlay started. And it's why I wrote this post: because every multi-stream freelancer I've talked to since has the same blind spot. Not because they're careless — because the tools they're using were designed for single-stream businesses, and multi-stream finance needs a different lens.
What "profit tracker" actually means
The word gets overloaded. When someone Googles "freelancer profit tracker" they might be looking for any of these three things:
- An expense tracker with a receipts feature. Most "freelancer apps" are this. They help you not lose receipts at tax time. They don't tell you what's profitable.
- A bookkeeping tool. QuickBooks Self-Employed, FreshBooks, Wave. These can generate a P&L but treat your freelance work as a single business. If you run three income streams, they roll them all together.
- A profit tracker. A tool that shows revenue, expenses, and net profit — per project and per hour — so you can tell which income stream is actually funding your life.
Only the third answers the question you really wanted to ask. And that's what Hustlay is.
Why single-stream bookkeeping fails the moment you have two streams
Imagine two freelancers in identical tax situations. Both earn $60k in gross revenue. Both have $15k of business expenses.
| Freelancer A (single stream) | Freelancer B (three streams) | |
|---|---|---|
| Gross revenue | $60,000 | $60,000 |
| Expenses | $15,000 | $15,000 |
| Net profit | $45,000 | $45,000 |
| Tax owed (approx.) | ~$11,250 | ~$11,250 |
Identical P&Ls. Identical tax returns. But if you asked each of them "which part of your business makes you the most money?":
- Freelancer A can answer by reading her one number off the spreadsheet.
- Freelancer B — unless she's broken out revenue and expenses by project — has no idea. She has three unknowns hiding behind one total. Maybe one stream is +$50k and two are net negative. She can't tell.
Two freelancers with identical bank balances can have completely different businesses. The difference is whether they know which project pays for the others.
The minimum viable system
You don't need enterprise job-costing. You need three things:
- A project tag on every transaction. Every dollar of revenue, every expense, every tracked hour gets labeled with which project it belongs to. "Shared" is a valid project for costs that legitimately cross streams.
- A rule for shared costs. Decide in advance how you'll split shared expenses (time-based, revenue-based, or a simple 50/50). Apply it consistently. We go deep on the methods in our shared expenses post.
- A monthly 20-minute review. Revenue by project, expenses by project, hours by project. That's it.
Three data points × N projects. At the end of the month you can answer: What was my profit margin per project last month? My profit per hour? Without those two numbers, you're flying blind no matter how many receipts you've digitized.
The Etsy shop that was losing money
Back to my original blind spot. When I broke out the newsletter properly — not just "hobby spend" but every minute of research and writing at its hourly cost — the numbers looked like this:
| Client work | Newsletter | |
|---|---|---|
| Revenue / month | $8,200 | $340 |
| Direct costs | $120 | $80 |
| Time (hours) | 80 | 22 |
| Net profit | $8,080 | $260 |
| Profit / hour | $101 | $12 |
The newsletter wasn't losing money on a cash basis. But those 22 hours could have been 22 more hours of client work at $101/hr — $2,222 of unrealized client revenue every month. The opportunity cost was the real story, and a single-column spreadsheet couldn't show it.
I didn't kill the newsletter (it eventually became big enough to carry itself). But for six months I capped it at ten hours/week so the client work could breathe. That decision was only possible because the profit-per-hour view made the trade-off visible.
Why I ship this as software, not a spreadsheet
You can build a profit-per-project tracker in a spreadsheet. I've done it. It breaks at four places:
- Receipt entry. Typing every expense from a receipt into a spreadsheet is a 15-minute/week tax you'll skip by week three. Hustlay auto-imports from email + camera scan.
- Shared cost allocation. Recalculating allocation percentages every time you add a new project means manually updating a dozen formulas. Hustlay does this live.
- Hour tracking. Spreadsheets don't have timers. Toggl doesn't talk to your P&L. Hustlay's time tracker writes directly to the project's profit line.
- Currency. A freelancer with US + EU clients needs auto-FX. Nothing spreadsheet-based handles this cleanly.
The short version
Total revenue is a vanity metric once you have more than one income stream. Per-project profit is the actionable one. Track it monthly, allocate shared costs consistently, and use profit-per-hour to make go/no-go decisions on where to spend your time next week.
If you want the software version that does the math for you, Hustlay's 7-day Pro trial is the fastest way to see your numbers in this form. If you want to stay DIY, the free spreadsheet template post walks through the structure cell by cell.