A project profit sheet for a freelancer has one row per project: the fee, direct costs such as a subcontractor, stock assets and travel, the hours you spent, and two results: profit and profit per hour. Add a rule for sharing common costs, like a design software subscription, and you can see which clients are actually worth your time.
What does each project row record?
| Column | Heading | Notes |
|---|---|---|
| A | Client | Who the project was for |
| B | Project | Short name |
| C | Fee (₹) | Amount invoiced, excluding any GST charged |
| D | Subcontractor (₹) | Paid to others for this project |
| E | Assets (₹) | Stock photos, fonts, templates |
| F | Travel (₹) | Cabs, fuel, tickets |
| G | Direct costs | =SUM(D2:F2) |
| H | Hours | Time actually spent |
| I | Share of subscriptions | Formula below |
| J | Profit (₹) | =C2-G2-I2 |
| K | Profit per hour | =IF(H2=0,0,J2/H2) |
Log hours as you work, even roughly, with a phone timer or a simple notes list. Hours reconstructed at month end tend to be too low, which flatters every project.
How do I share a software subscription across projects?
Say your design software costs ₹2,700 in a month. You cannot attribute it to one project, so share it by hours. In a cell like N1, enter the month's shared costs. Then in I2:
- =$N$1*H2/SUM($H$2:$H$50)
Each project takes a share equal to its slice of the month's hours. You can use fees as the base instead (=$N$1*C2/SUM($C$2:$C$50)) if hours are not tracked well. The method matters less than writing it down and using it every month.
What does an example with three projects show?
These numbers are invented. Total hours across the three are 40 + 30 + 20 = 90, so the ₹2,700 subscription works out to ₹30 an hour.
| Project | Fee | Direct costs | Hours | Subscription share | Profit | Per hour |
|---|---|---|---|---|---|---|
| A, brand identity | ₹60,000 | ₹15,000 | 40 | ₹1,200 | ₹43,800 | ₹1,095 |
| B, event shoot edit | ₹35,000 | ₹4,500 | 30 | ₹900 | ₹29,600 | ₹986.67 |
| C, website copy | ₹25,000 | ₹0 | 20 | ₹600 | ₹24,400 | ₹1,220 |
Project A: 60,000 - 15,000 - 1,200 = ₹43,800, and 43,800 / 40 = ₹1,095. Project B: 35,000 - 4,500 - 900 = ₹29,600, and 29,600 / 30 = ₹986.67. Project C: 25,000 - 0 - 600 = ₹24,400, and 24,400 / 20 = ₹1,220. The biggest fee, project A, is not the best per hour, and the smallest, project C, is. This is why per-hour figures change how you quote.
What should I do with the results?
- Sort by profit per hour to see which kinds of work pay better for your time.
Add a column for revision rounds and note which clients cause extra work. If a client's profit per hour is consistently lower, you can quote higher, set limits on revisions, or choose not to take repeat work. Those are your choices; the sheet only shows evidence.
Which costs belong in which bucket?
- Direct cost: money you would not have spent without the project, such as a freelance illustrator or purchased assets.
Shared cost: subscriptions, internet, a co-working desk, equipment wear. Allocate these with the hours method. Personal spending never belongs here; keep it out so the profit figure is honest.
Where can an app help?
Software subscriptions, assets and travel often come through your card or bank account. SpendixAI can import those statements, categorise them with custom categories, and let you download a report as CSV, which you can paste next to this sheet when you total your shared costs.
What if hours are hard to track?
Start with a rough count for one month: note the hours at the end of each working day, even to the nearest half hour. After a month you will know how far off your guesses were, and can correct them for older projects. A profit-per-hour figure built on honest rough hours is more useful than a blank column.
End-of-project routine
- Final hours entered
- Subcontractor and asset bills added
- Subscription share calculated for the month
- Profit per hour noted in the client record
Useful ideas start with a clearer picture of your own spending.
Explore your reports


