Project profit sheet
List what a freelance project or small job brought in and what it cost, then download a sheet with the gross profit, margin and net per hour.
Your entries stay in this tab. No upload, account, tracking of entries or saved data. Reloading clears your edits.
Worked example
One fee of 1500 against two costs, with 12.5 hours of work. All amounts use the same currency and include tax.
| Type | Item | Amount |
|---|---|---|
| Income | Item 1 | 1500.00 |
| Expense | Item 2 | 320.40 |
| Expense | Item 3 | 79.99 |
| Income total | 1500.00 | |
| Expense total | 400.39 | |
| Profit | 1099.61 | |
| Margin | 73.3% | |
| Net per hour | 87.97 |
Formula and limits
Profit = income total − expense total. Margin = profit ÷ income total. Net per hour = profit ÷ hours spent. Amounts are added in whole cents, so totals never drift.
Income total = 1500.00 Expense total = 400.39 Profit = 1500.00 − 400.39 = 1099.61 Margin = 1099.61 ÷ 1500.00 = 73.3% Net per hour = 1099.61 ÷ 12.5 = 87.97
Amounts from 0 to 100,000,000 with at most two decimals, up to 20 income and 20 expense rows, hours from 0.25 to 2000 in quarter-hour steps. Same currency, no exchange rates, no tax or accounting advice.
- Amount: 0 ≤ x ≤ 100,000,000
- Hours spent: 0.25 ≤ h ≤ 2000
- Income / Expense: 1 ≤ n ≤ 20
Optional apps
No app is required for this free worksheet. Check each App Store listing for current features and prices.