Project Profitability Tracking for Agencies: A Checklist

Many agency and studio founders only discover a project was unprofitable after it's delivered, when the invoice is paid and the bank balance doesn't reflect the effort. The problem hits Indian SMBs and mid-market B2B firms where project work drives revenue, but time and costs live in scattered spreadsheets, WhatsApp messages, and memory. Without a simple tracking system, you're guessing at margins and risking cash flow.

Start with one place to capture time and direct costs

If you can't see hours and expenses per project, you can't calculate profitability. Pick a single tool and enforce it. Toggl, Harvest, or Clockify work well for time; a shared Google Sheet can handle direct costs if you're just starting.

• Every team member logs time daily, in 15-minute increments. No exceptions. Separate billable from non-billable work.
• Tag every expense to a project: freelance payments, stock assets, software subscriptions, travel. If you pay via UPI, note it against the project immediately.
• Use a consistent cost rate per role (e.g., ₹1,200/hour for a developer, ₹800/hour for a designer). Include overhead in that rate.
• Allocate non-billable time (internal meetings, admin) proportionally to projects so you see true overhead.

This sounds basic, but in our experience, most agencies that struggle with profitability skip this step entirely. For Indian teams, WhatsApp is often where scope changes happen—log those conversations as change requests in your tracking tool.

Define a project budget before work starts

Before you send the quote, write down the numbers. For each project, estimate:

• Total quoted price (excluding GST).
• Hours by role, with a blended hourly cost.
• Direct costs: freelancers, licenses, stock, hardware.
• A revision buffer—typically 15-20% extra hours.

For retainers, divide the monthly fee by expected hours to get an effective hourly rate, then track against that. If you have a client who insists on a fixed price, double the revision buffer.

Worked example: A Gurgaon client approves a website project for ₹4,50,000 (excl. GST). You estimate 200 hours at a blended cost of ₹1,500/hour = ₹3,00,000 labour. Direct costs: ₹30,000 for stock photos, ₹15,000 for a freelance developer, ₹10,000 for tools. Total estimated cost: ₹3,55,000. Target margin: ₹95,000 (21%).

Then reality hits. The client asks for extra pages, revisions pile up, and the team logs 280 hours. Labour cost becomes ₹4,20,000. Direct costs rise to ₹60,000 because you bought more assets and the freelancer did extra work. Total cost: ₹4,80,000. You've lost ₹30,000 on a project you thought was profitable. The only way to catch this early is to compare actuals to budget weekly.

Track actuals weekly and compare to budget

Set a recurring 30-minute meeting every Friday. Pull the numbers from your time tracker and expense sheet. Calculate margin-to-date:

Margin = (Quoted price – (Actual hours × Cost rate) – Actual direct costs) / Quoted price

If margin drops below your threshold—say 15%—flag it. Then decide: absorb the hit, issue a change request, or renegotiate scope.

• Update the budget with any approved change requests.
• Review the top three projects by hours logged.
• Check for unbilled work: hours logged but not covered by the quote.

If you use Harvest, set budget alerts. On spreadsheets, conditional formatting can turn a cell red when hours exceed 80% of estimate. Keep cash flow separate. Clients deduct TDS (typically 2% for companies, 10% for individuals), so you receive less cash than the invoice value. That's a timing difference, not a profitability issue. For profitability, use the invoice value. For multi-currency projects, convert all costs to INR at the time of the expense to avoid surprises.

Fix the leaks and adjust future quotes

Once you have three to six months of actuals, patterns emerge. Common leaks:

• Scope creep that never gets billed.
• Underestimating revision cycles (especially with WhatsApp-first clients who send feedback in fragments).
• Forgetting tool subscriptions and project management overhead.
• Using a single cost rate for all roles, which hides expensive bottlenecks.

Adjust your quoting process. Add a project management line item (10-15% of labour). Include a change request template with clear pricing. Set a minimum margin: 25% for new clients, 20% for repeat work. Review your top five projects by revenue each quarter—if any are below 15% margin, ask why. For export projects, add a 3-5% buffer for forex and wire charges. Also, review your cost rates every six months—salary hikes and tool price changes creep up.

Where to start

Pick one live project this week. Track time and direct costs for 30 days, then calculate the true margin. You'll likely find at least one leak worth fixing. If you need a single dashboard that pulls time, cost, and invoice data together, Maysan Labs builds those for agencies and studios—but you can start with a spreadsheet and a weekly review today.