When you are managing several freelance clients at once, important details can end up scattered across emails, notes and calendars. A simple project tracker gives you one place to see what is happening, what is due next and which clients need an update.
1. Start with one row per project
Keep each project on a separate row so you can scan your workload. If one client commissions two separate pieces of work, record them as two projects. This makes deadlines, fees and progress easier to track.
2. Add the essential project fields
- Project ID: a short reference you can use in emails and file names.
- Client and project name: enough detail to identify the work quickly.
- Start date and due date: record the agreed dates, not just your hoped-for dates.
- Status: use consistent stages such as Enquiry, Quoted, Scheduled, In progress, Waiting on client, Review, Complete and Archived.
- Next action: write the single next step, such as send a draft or request missing information.
- Fee and payment status: note the agreed amount and whether the invoice is not yet sent, due or paid.
3. Track scope and revisions
Write a short summary of what is included, the agreed deliverables and the number of revision rounds. When a client asks for extra work, record the request and agree any change to the fee or deadline before proceeding. A tracker is a reminder system, not a substitute for a written agreement.
4. Make the next action visible
A project can look active while quietly becoming stuck. Give every open project a next action and a date to review it. If you are waiting for client feedback, record when you last followed up and when you will check in again.
5. Use simple visual status indicators
Colour can help you spot overdue deadlines or projects waiting on someone else. Keep the rules simple and make sure the status is also written as text, so the meaning is clear when you print or share the sheet.
6. Review your projects once a week
Set aside 10–15 minutes to:
- Check deadlines in the next two weeks.
- Find projects with no next action.
- Follow up on client feedback or approvals.
- Check completed work that still needs invoicing.
- Update project status and move finished work to an archive.
7. Keep project tracking connected to the rest of your business
Project delivery connects to onboarding, proposals, invoices and cash flow. Use a consistent client name or project reference across your records so you can find related information without searching through everything again.
If you want a ready-made starting point, see the Solo Studio Project & Client Tracker. If you want the wider set of coordinated freelancer workbooks, explore the Solo Studio Complete Freelancer Bundle.
A tracker should make work easier, not create more admin
Start with the few fields you will actually update. Review them consistently, keep client agreements in writing and adjust the system when you notice a recurring gap. A small, reliable routine is more useful than a complicated spreadsheet nobody maintains.
Plan the next project actions
Once project dates and responsibilities are clear, give the week's next actions a home. The free Solo Studio Weekly Reset Planner helps you organise immediate tasks and available hours. For a dedicated project register, task list and dashboard, take a look at the Solo Studio Project & Client Tracker.