Bring revenue and effort together
Record project revenue and estimated or actual hours using your internal hourly cost assumption.
05 / UNDERSTAND THE MARGIN
Project Profit Tracker
A project can bring in revenue and still leave too little for the work involved. Track the fee, hours and direct costs together to see project profit and margin, then compare where your time is paying off.
See the current price and purchase on Etsy. Digital files; software is not included.
The tracker connects project revenue, hours and direct costs with profit and margin views.
WHAT IT HELPS YOU DO
See what remains after time and direct costs
Keep direct spending attached to the job
Use the Cost Log to record project expenses alongside the work they belong to.
Compare projects on margin
Review the Dashboard to compare profitability and spot margin pressure before using the same assumptions for your next quote.
The dashboard summarizes revenue, total cost, profit, margin and effective hourly rate. A project snapshot compares profit and margin across individual jobs, including loss-making work.
Open image to view the workbook details. On a phone, zoom after opening.
INSIDE THE FILES
Five sheets for project costs and profitability
Start Here, Dashboard, Project Profit, Cost Log and Setup in an Excel workbook, with supporting PDF and text guidance.
Who it is for
Freelancers and service-business owners who want to review project economics using their own revenue, time and cost records.
Files & compatibility
An .xlsx workbook with PDF and text guidance. Designed for desktop Microsoft Excel. Importing into Google Sheets may change styling, validation, formulas or charts. Software is not included; replace the fictional sample records.
This is a management tracker. Its internal time-cost assumptions support project decisions and may differ from costs recognized in formal accounts. It does not replace accounting, tax or financial advice.
A SIMPLE WORKING ROUTINE
Review the fee against the work actually delivered
- Set your internal hourly cost and workbook settings.
- Add project revenue and estimated or actual hours, then log direct costs.
- Review profit and margin on the Dashboard and revisit the assumptions behind weaker projects.
RELATED SYSTEMS
Use profit lessons in pricing and scope decisions
Freelance Pricing Calculator
Calculate sustainable rates and project quotes without guessing what to charge.
Explore the system View on Etsy ↗See included files
- 4-sheet Excel workbook: START HERE, RATE CALCULATOR, PROJECT QUOTE and SCENARIO PLANNER
- Rate model based on income goal, expenses, capacity and working assumptions
- Project quote builder for estimated hours and direct costs
- Scenario comparison for testing different pricing positions
Digital files. Software is not included.
Scope Control System
Control extra work before scope creep silently reduces your margin.
Explore the system View on Etsy ↗See included files
- 9-sheet Excel system with Control Center and Instructions
- Scope Register and Change Requests
- Impact Assessment plus Approval & Variations
- Scope Creep Log and Commercial Impact tracking
Digital files. Software is not included.