How to combine freelance timesheets and invoices to measure project profitability
Measure freelance project profitability by linking time entries and direct expenses to projects, separating billable value, invoiced revenue, earned revenue, and cash received, and allocating shared costs under a documented rule. Compare margin with scope, write-offs, revisions, and payment timing rather than hourly rate alone.
Where the difficulty begins
A fixed-fee project can appear profitable when unrecorded revisions consume time. An invoice can be sent but unpaid, and software or subcontractor costs may support several projects.
From the field · Freelance content producer
Compare profitability for three creative projects
One project is hourly, one fixed-fee, and one monthly retainer. A subcontractor supports two projects, the fixed-fee client requests extra revisions, and one invoice remains unpaid.
Columns used in the example
client_id · project_id · date · hours · activity · billable_flag · direct_expense · invoice_amount · payment_date · scope_change
Follow it with your own file
- Map every time and expense record to a project or shared-cost pool.
- Separate earned/invoiced work from received cash.
- Calculate project contribution after direct and approved time cost.
- Explain margin and cash differences through scope, utilization, expense, and payment timing.
Check: Time must reconcile to timesheets, invoices and payments to finance records, and allocated shared costs to the original pool. Publish assumptions beside margin results.
Check the source before you publish
- Project links complete
- All time states included
- Revenue states separated
- Costs reconcile
- Assumptions documented
Choose the approach that matches the evidence and repetition
| Approach | When it works | What to verify |
|---|---|---|
| Invoice total | Billing activity | Effort, costs, and collection |
| Effective hourly rate | Pricing and scope review | Shared costs and cash timing |
| Project margin plus cash | Business decisions | Allocation assumptions |
Build the result step by step
- Map project identity: Link client, project, scope, time entry, expense, invoice, credit, and payment records.
- Choose economic views: Separate booked, earned, invoiced, received, direct cost, and allocated cost.
- Calculate effort and margin: Include billable and nonbillable project time under an approved internal cost rate.
- Review scope and cash: Connect margin changes to revisions, write-offs, late payment, and future pricing decisions.
What may be distorting the answer
- Invoice value is treated as cash in the bank.
- Nonbillable revisions and sales time are excluded from effort.
- Shared tools are assigned arbitrarily to one client.
Profitability and cash answer different freelance decisions
Project margin informs pricing and scope, while cash collection informs liquidity. Keeping them separate lets a freelancer identify an underpriced project even when the client pays promptly—or a good project creating cash stress through late payment.
Where this usually goes wrong
Internal hourly cost and shared-cost allocation are management assumptions, not universal accounting rules. Seek professional advice for tax and statutory reporting.
The decisions that matter
- Link client, project, scope, time entry, expense, invoice, credit, and payment records.
- Separate booked, earned, invoiced, received, direct cost, and allocated cost.
- Include billable and nonbillable project time under an approved internal cost rate.
- Connect margin changes to revisions, write-offs, late payment, and future pricing decisions.
Doing these steps in Prepyr
Prepyr accepts CSV files only. Export the worksheet or table you need as a UTF-8 CSV first; workbook formulas, formatting, macros, charts, and other sheets will not be included. Describe the result you need: Combine freelance timesheets invoices expenses and payments for profitability analysis. Check the columns selected, preview any proposed changes, and compare the output with the source before applying or exporting it.
Prepyr steps used here: Text analysis · Charts · Reports · Sensitive Column protection
A client and project view that explains effort, margin, scope change, invoicing, and collection and supports better pricing and workflow choices.
Questions readers usually ask next
Should unpaid invoices count as freelance revenue?
Keep earned, invoiced, and cash-received views separate. Accounting treatment depends on the chosen basis and professional requirements.
Should nonbillable revisions count in project profitability?
Yes when they consume project effort. Label the activity so scope and process decisions can address it.