How Freelancers Can Track Projects, Deadlines and Unpaid Invoices
Disclosure: Some links below are affiliate links. If you sign up through them we may earn a commission at no extra cost to you. We only recommend tools we'd genuinely suggest to a friend. See our full disclosure.
The work isn’t usually what overwhelms freelancers — it’s everything around the work. Which project is due first? Did that client ever pay the deposit? What did I promise by Friday? Miss any of these and you lose money or trust, often both. The fix isn’t fancy software; it’s a simple, consistent tracking system you actually check. Here’s one that works.
The three things every freelancer must track
- Projects — the big picture: what you’re doing, for whom, by when, for how much.
- Tasks — the steps inside each project, with their own deadlines.
- Money — which fees are booked, and which are still unpaid.
Most freelancers track one of these (usually the work) and let the other two live in their head. That’s exactly where deadlines and invoices fall through the cracks.
Track your projects in one list
Keep a single master list with one row per project and these columns:
- Project name
- Client
- Status — Not started, In progress, On hold, Done
- Start date and due date
- Fee
- Paid? (yes/no)
- Notes
This one view answers “what’s on my plate and what’s it worth?” in seconds. Using a fixed set of status values (rather than free text) lets you filter to just the active work or just what’s overdue.
Be strict about what moves a project to Done, too. “Delivered” is not the same as done — a project stays on your list, and in your head, until it has actually been closed out: handover complete, access transferred, final invoice sent, support boundary stated. A list full of delivered-but-unclosed work is one of the main reasons freelancers feel busier than their calendar says they are.
Two columns worth adding once the list has a few finished rows in it: what the enquiry looked like and what it actually cost (real hours against quoted hours, plus the chasing and rework nobody billed). After a year that turns your tracker into a red-flag list built from your own projects, which is far more accurate than any generic one because it reflects your work, your market and what you personally find hard to tolerate.
A third column earns its place once you have been going a year: share of the month’s income. A tracker naturally shows you what is busy, never what you are dependent on, and two different problems hide in that blind spot — concentration, and the slower one where a single long-running client’s work stops having project rows at all because it has become a standing arrangement rather than a series of jobs. A client who no longer generates rows is not a quiet client; they are one your tracker has stopped being able to see.
One status worth adding explicitly: Waiting on client, with the date it started. Otherwise a project that’s stalled on their side looks identical to one you’re actively working, and the only place it’s tracked is your head at 11pm. Dating it also tells you when to stop waiting — see what to do when a client goes quiet.
Break projects into tasks with their own deadlines
A project due in three weeks isn’t one deadline — it’s a series of smaller ones. Track tasks separately:
- Task and which project it belongs to
- Priority — high / medium / low
- Due date
- % complete and a done? flag
The trick that keeps you on schedule: work from your task due dates, not the final project deadline. Sort by due date and priority each morning and you’ll always be doing the most urgent next thing, instead of discovering on the last day how much was left.
This list has a second job people miss: it makes a slip visible early. Re-check the remaining tasks at the halfway point of the calendar time, and if they no longer fit the days left, the deadline has already moved — which is exactly when telling the client is cheap rather than damaging. It also gives you real numbers for the next quote, so the same job doesn’t get underestimated twice.
Never lose track of unpaid invoices
Unpaid work is the most expensive thing freelancers forget. With a fee and a paid? flag on every project, you can total what you’re owed in one formula and chase it while it’s recent. A few habits make this reliable:
- Invoice promptly — the day a milestone or project completes, not “later”.
- Review your unpaid total weekly and follow up on anything overdue.
- Set clear terms (deposit upfront, due date, late fee) so chasing is a polite reminder, not an awkward negotiation.
One upgrade turns this list from a chase-list into something that can warn you in advance: put an expected payment date next to each unpaid amount, rather than only a paid/unpaid flag. A flag tells you what is outstanding; a date tells you what your account will look like in three weeks, which is the only version that catches a squeeze before it happens. Freelance cash flow walks through building that forward view.
Bring it together in a dashboard
The payoff of structured tracking is a dashboard that summarises everything automatically: active vs completed projects, open tasks, average progress, and — most importantly — unpaid fees versus total booked. A spreadsheet does this with simple count and sum formulas, so the numbers update themselves as you work. (Our done-for-you templates include a Project & Client Tracker with exactly this dashboard built in, including the unpaid-fees total — though you can recreate it in any spreadsheet you like.)
Make it a weekly habit
A tracker only works if you look at it. Build a five-minute Monday review into your week:
- Update each project’s status.
- Scan tasks due in the next seven days and plan around them.
- Check the unpaid total and send any follow-ups.
That short, regular pass is what turns the system from a nice idea into the thing that quietly keeps your freelance business on the rails.
Once a quarter, add a fourth line to the same review: what share of the last six months of income came from your largest single client. It takes a minute if the money column is already there, and it is the one number a weekly tracker will never surface on its own — every individual invoice looks like a success, and only the composition of the total tells you anything. Client concentration risk covers what to do with the answer.
The bottom line
You don’t need expensive software to run a tidy freelance operation — you need three connected lists (projects, tasks, money), a dashboard that totals them for you, and a weekly habit of checking it. Keep those current and you’ll hit deadlines, stop chasing forgotten invoices, and always know exactly where every client and every pound stands.
Related guides
- How to Find Freelance Clients
- How to Price Your Freelance Services
- How to Write a Freelance Proposal That Wins
- Freelancer Bookkeeping: Track Income, Expenses and Tax
Frequently asked questions
How should a freelancer track projects?
Keep one list of projects with each project's client, status, start and due dates, and fee, plus a separate task list that breaks each project into steps with owners, priorities and due dates. A simple dashboard that rolls these up shows active vs finished projects and what's overdue at a glance — enough structure for most solo freelancers without project-management software.
How do I keep track of who owes me money?
Add a 'paid?' flag to each project or invoice and a fee amount, then filter or total the unpaid ones. Reviewing your unpaid total weekly means overdue invoices get chased while they're still fresh, instead of being discovered months later.
What's the best way to manage freelance deadlines?
Break each project into tasks with individual due dates rather than tracking only the final deadline, and sort your task list by due date and priority. Working from the next few due tasks — not the distant final date — is what keeps projects on schedule.
Do I need project management software as a freelancer?
Usually not at the start. A well-structured spreadsheet handles projects, tasks, deadlines and unpaid fees for most solo freelancers, costs nothing, and works offline. Dedicated software becomes worth it mainly when you're collaborating with a team or juggling a high volume of concurrent projects.
How often should I review my project tracker?
A short weekly review works well: update statuses, check what's due in the coming week, and chase anything unpaid. A five-minute Monday pass prevents the dropped balls and forgotten invoices that quietly cost freelancers time and money.