Freelancer Clients & Projects
Organize clients, projects, receivables and workload.
Receivables: agreed value minus money actually received.
Who it is for
For freelancers managing several clients.
Your outcome
Project register, outstanding payments and capacity.
What is inside
- Project calculator: amount left to collect, profit and available work capacity.
- An in-kit project register that transfers totals to the calculator.
- Analysis of your real hourly rate after all hours (worked, remaining with revisions and unpriced requests) and overheads, the value needed for your target, spare hours after admin time, overdue and one-client dependence, with six stress tests and three charts.
- Bilingual Excel file: a project register with actual hourly rate, a daily time log, client follow-up, a priced scope change log, a controls sheet, an hours ladder, stress tests and a decision dashboard with three charts and recommendations.
Before you begin
Your figures and results inside the kit are in US dollars, and you can switch currency to match your country.
Supporting your chances of success
This kit combines precise calculations with guidance and organisation to help you work towards your goal. We help you organise inputs, understand options and assess strengths and risks, then suggest practical steps suited to its subject — such as pricing, cash flow or marketing.
Guidance supports decisions, not guaranteed success; estimates depend on the accuracy of your inputs.
Understand the kit step by step
This kit combines project value, collections and remaining workload. It helps you distinguish agreed work from money received and check whether existing commitments fit available time before accepting more. The register organizes commitments while indicators summarize the period; they do not automatically approve a new contract.
What to prepare before starting
For each project prepare a name, agreed value, receipts, delivery costs and remaining hours. Define available hours for the same period and record actual status.
From information to a decision
- Organize projects and separate agreed values from receipts.
- Compare total remaining delivery hours with available capacity.
- Review receivables and spare time, then plan collection or revise delivery dates.
- Add the hourly rate you want, hours already worked, revision buffer, unpriced requests, overheads, admin time, overdue amounts and your largest client’s share, then read your real hourly rate, the value needed for your target, the hours ladder and the stress tests.
A simple example to explain the idea
Agreements of 15,000 less 5,000 collected leave 10,000 to collect. If delivery needs 100 hours and capacity is 120 hours, only 20 remain before revisions or administration. In the full calculator example: two projects worth 10,000 with 4,000 received, 2,000 delivery costs and 500 overheads leave 7,500 for your time. But the real hours are 40 worked + 60 remaining with a 15% revision buffer (69) + 8 unpriced request hours = 117 hours, so 64 per hour instead of your 100 target. Hitting the target needed a value of 14,200, 4,200 more, and the extra requests alone are worth 800. Your 80 hours become 64 after 20% admin, leaving you 13 hours short (a load of 19.25 hours a week against 16 of capacity). The 2,500 overdue is 42% of outstanding, and your largest client is 60% of income. In the combined worst case your rate falls to 44.
These figures are illustrative, not approved prices or guaranteed forecasts; they may differ from the worked example below.
How to interpret and use the result
Receivables are not spendable cash. Negative capacity means commitments exceed allocated time; renegotiate dates or scope before accepting more.
A common mistake to avoid
Not all contract value is due immediately. Allow for revisions. Optional device-local register saving does not automatically synchronize across devices.
The included Excel file and how to use it
The Excel file has a project register that pulls actual hours from the time log, calculates your real hourly rate per project and highlights it when it falls below your target, a daily time log, a client follow-up sheet with last contact and next action, and a scope change log that prices every extra request at your hourly rate before you do it., with linked examples and a fixed review date. It adds a controls sheet with fourteen validated inputs, an hours ladder showing your rate as hours grow, six stress tests, and a decision dashboard with your real hourly rate, the value needed for your target, spare hours after admin, weekly load, overdue share, three charts and recommendations. The example matches the calculator.
First-week actions after calculating
- Enter all current projects with estimated hours and your target hourly rate.
- Log your time every day this week, including small tasks.
- Send every client who asked for unpriced extra work a message with the price of the change before continuing.

