Ever spent 10 hours on a $50 gig and felt like you made money — but actually your hourly rate was below minimum wage? That was me last year. I was hopping between freelance projects without tracking tool costs, and some "profitable" gigs were actually losing me money.
I built a simple Google Sheets template that solved this: one place to log every expense (software subscriptions, stock assets, hosting fees) per project, and it automatically calculates ROI and hourly rate.
The template has 4 tabs:
- Project Setup — Just name your gig, dates, and status (Active/Completed)
- Cost Tracker — List every tool/expense per project. Mark if it's monthly or one-time.
- ROI Summary — Enter total revenue and hours. Sheet uses SUMIF formulas to pull costs from Tab 2.
- Instructions — Green cells = input, yellow = auto-calculated. Sample data pre-filled so you can start immediately.
Real example:
- YouTube Thumbnail Design gig: $250 revenue, $22.98 in costs (Canva Pro + stock assets), 8 hours → ROI = 987%, hourly rate = $28.38
- Blog Writing gig: $180 revenue, $45 costs (Grammarly + hosting share), 6 hours → ROI = 300%, hourly rate = $22.50
Without the tracker, I would have missed the cost efficiency of the thumbnail gig vs writing gig.
If you want the exact template (with formulas already built): ROI Calculator for Side Hustles — Google Sheets — $22.
Otherwise, you can replicate the logic I described above. But the formulas and cross-tab SUMIF setup took me an hour to nail — the template saves you that time.
Happy hustling!
Top comments (0)