Client Revenue Tracker Calculator

Track revenue from projects, retainers, hours, and extras. Forecast cash flow with risk-aware client metrics. Make steadier pricing decisions using cleaner monthly revenue insights.

Enter Client Revenue Inputs

Use the fields below to estimate billed revenue, net revenue, expected collections, client concentration, and effective hourly performance.

Reset

Plotly Revenue Graph

This chart compares the main stages from billed revenue to expected realized revenue.

Example Data Table

Client Billable Hours Gross Revenue Net Revenue Expected Realized Client Share
Northwind Studio 28 $4,100.00 $3,147.00 $2,792.30 34.17%
Beacon Media 18 $2,550.00 $2,040.00 $1,938.00 21.25%
Vertex Launch 35 $5,600.00 $4,458.00 $4,190.52 46.67%

Formula Used

Hourly Revenue = Hourly Rate × Billable Hours
Gross Billed Revenue = Hourly Revenue + Retainer Fee + Project Fee + Recurring Services Revenue + Reimbursable Expenses + One-Time Adjustment
Discount Amount = Gross Billed Revenue × Discount Percent
Revenue After Discount = Gross Billed Revenue − Discount Amount
Net Revenue = Revenue After Discount − Platform Fee − Tax Reserve − Direct Costs
Overdue Risk = Overdue Invoices × (1 − Collection Probability)
Expected Realized Revenue = (Net Revenue × Collection Probability) − Overdue Risk
Effective Hourly Rate = Net Revenue ÷ (Billable Hours + Admin Hours)
Recurring Share = (Retainer Fee + Recurring Services Revenue) ÷ Gross Billed Revenue × 100
Client Share = Gross Billed Revenue ÷ Total Portfolio Revenue × 100

How to Use This Calculator

  1. Enter the client name for your current tracking cycle.
  2. Add hourly rate and billable hours if the client includes hourly work.
  3. Enter retainer, project fees, and recurring services revenue.
  4. Include reimbursable expenses and any one-time positive or negative adjustment.
  5. Set discount, platform fee, tax reserve, and direct costs.
  6. Add collection probability and overdue invoices to model payment risk.
  7. Enter admin hours to measure true effective hourly return.
  8. Provide total portfolio revenue and monthly goal for concentration and progress metrics.
  9. Press Calculate Revenue to show results above the form.
  10. Download the calculated summary as CSV or PDF when needed.

FAQs

1. What does gross billed revenue include?

It combines hourly work, retainers, project fees, recurring services, reimbursable expenses, and one-time adjustments before discounts, platform deductions, taxes, and internal costs.

2. Why should freelancers track collection probability?

It helps estimate how much revenue is likely to become real cash. This is useful when late payments, partial payments, or disputed invoices affect planning.

3. Are reimbursable expenses treated as profit?

Not necessarily. They increase billed revenue, but they may only pass through your books. That is why direct costs and net revenue are shown separately.

4. What does client share of portfolio mean?

It measures how much of your total revenue comes from one client. A high percentage may signal dependency risk if that client pauses or ends work.

5. Why is tax reserve included?

Tax reserve estimates the portion of revenue that should be set aside for tax obligations. This gives a more realistic view of spendable cash.

6. How is effective hourly rate different from hourly rate?

Hourly rate reflects billed work only. Effective hourly rate includes the impact of fees, taxes, costs, and admin time, so it shows actual earning efficiency.

7. Can I use this for project-only clients?

Yes. Leave hourly, retainer, or recurring fields at zero when they do not apply. The calculator still works for project-only or mixed billing models.

8. What does expected realized revenue show?

It estimates revenue after deductions and payment risk. This value is useful for cash planning, budget decisions, and safer monthly forecasting.

Related Calculators

passive income calculatorfinancial independence calculator

Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.