How to Track Client Projects as a Freelancer: One List, Six Columns, a Weekly Check

Short answer: keep every client project in one list, with one row per project. For each project, write the client, the scope, the due date, the current stage and the next step. Then add the money: the price, the deposit, the balance and when each payment arrived. Check the list once a week, sorted by due date. Tell each client when their project moves to a new stage. Keep the invoices and payment records after the project ends, because you need them for tax.

Freelance work is a run of small projects. A logo, a product shoot, a set of edits, a website refresh. Each one has its own brief, its own deadline and its own deposit. When you have two projects, you can hold them in your head. When you have six, one of them slips. Usually it is the one where the client paid half and you forgot to ask for the rest.

Most guides on this topic are written by project management software companies. They talk about task boards, team members and time budgets. This guide is for a freelancer who works alone. It covers the six columns that matter, the scope and your stages. Then it covers money, client updates and the records to keep. It ends with when a spreadsheet stops being enough.

What your tracker needs

You do not need a special tool to start. A spreadsheet, a notebook or an app all work, as long as every project is in the same place. A tracker split between your email, your chat app and a sticky note is not a tracker.

Give each project one row with these six things:

1. Client. Name, company and how they like to be contacted.
2. Scope. One or two lines on what you will deliver. “Logo, 3 concepts, 2 rounds of changes, final files in SVG and PNG.”
3. Due date. The date the client expects the final work. Add the dates for any drafts too.
4. Stage. Where the project is now, using the same stage names every time.
5. Next step. What happens next, and who has to do it. “Waiting for client feedback on draft 1.”
6. Money. The price, the deposit, the balance and the date each payment arrived.

If you bill by the hour, add a column for hours. If you work with clients abroad, add the currency. Do not add more columns than you will update. A tracker with 20 columns gets left behind after two weeks.

Here is what a week can look like for a freelance designer. It is an illustrative example, not a real business.

Look at the dental project. The work was delivered on October 24, but $200 is still unpaid. In a tracker like this, that row stands out. In a chat history, it is easy to miss.

1. Write the scope down before you start

Most freelance projects that go wrong started with a scope nobody wrote down. The client remembers “a logo and some social posts”. You remember “a logo”. Both of you are sure you are right.

Before you start work, send the client a short written summary. It can be an email or a message. It should say:

• What you will deliver, and in which format.
• How many rounds of changes are included.
• The due date for each draft and for the final work.
• The price, the deposit and when the balance is due.
• What happens if the client wants more than this.

Ask the client to reply “yes” to confirm it. Then copy the scope line into your tracker.

In some places, this is the law, not only good practice. New York City’s Freelance Isn’t Free Act says a contract worth $800 or more must be in writing. It also counts several jobs for the same client that add up to $800 within 120 days. The contract must say what work you will do, what you will be paid and the date you get paid. If it gives no payment date, the client must pay within 30 days after you finish the work. Check the rules where you and your clients are. This guide is general information, not legal advice.

For a longer template, our guide to custom order terms and conditions lists the clauses to include.

2. Give every project a due date and a next step

A project with no due date never feels urgent until the client asks for it. Put a date on every project, even when the client says “no rush”. Agree on it with the client, and write it in your scope summary.

Add the dates in between as well. Say a website is due on November 20. Write down when the first draft is due and when you need the client’s feedback. Count back from the final date, and leave space for the client to be late with their feedback. They often are.

The next step is the column most freelancers skip, and it is the most useful one. “Revisions” tells you where a project is. “Waiting for client to send photos” tells you why it has not moved and whose turn it is. When the next step is the client’s, send a reminder. When it is yours, it goes on your to-do list.

In WISMO’s own order data, the median order is due 7 days after it is created. One order in ten runs 22 days or longer.

7 days

That data covers all kinds of small sellers, not only freelancers. But it shows the point. For a week or more, the details of each job have to live somewhere other than your memory.

3. Name your stages, and use the same ones every time

A stage is a short name for where a project is. Pick 5 to 7 stages that match how you really work, and use the same ones for every client. Here is one set for creative work:

1. Brief agreed. The client confirmed the scope.
2. Deposit paid. You can start.
3. First draft. The first version is with the client.
4. Revisions. You are making the agreed changes.
5. Final files sent. The client has the finished work.
6. Paid. The balance has arrived.

A photographer might use “Shoot booked”, “Shot”, “Editing”, “Gallery sent” and “Paid”. A writer might use “Outline”, “Draft”, “Edits” and “Published”. The words matter less than using the same ones every time. Then you can count your projects by stage. You see at once that four of them are waiting on a client.

Keep “Final files sent” and “Paid” as separate stages. A project is not finished until the money arrives.

4. Track the money for each project

Tracking income by month tells you how much you earned. Tracking money by project tells you who still owes you. You need both, but the second one is where freelancers lose money.

For each project, write down:

• The price you agreed.
• The deposit, and the date it arrived.
• The balance, and the date it is due.
• The invoice date, if you sent one.
• Each payment, with the date and how it was paid.

Late payment is common for freelancers. The Freelancers Union and other groups ran a survey of New York freelancers in 2022. In it, 91% said they had been paid late at least once in their career. The survey covered one state, so it is not a national figure. But it shows why the balance column matters.

WISMO’s order data shows the same gap. Sellers recorded a deposit but not the full price on 67 orders. Of those, 48 were past their due date with a balance still owed. Again, that data covers all kinds of small sellers.

48 of 67

How much deposit to ask for is up to you. Across 91 deposits in the same data, the median was 50% of the price. But sellers’ own medians ranged from 8% to 97.4%. Our guide to deposit percentages shows how to choose. Is a client late with the balance? Our guide on what to do when a customer won’t pay has the messages to send.

In the UK, the law sets a default. GOV.UK says that a business payment with no agreed date is late after 30 days. The 30 days start when the client gets the invoice or you deliver the work, whichever is later. You can then charge interest of 8% plus the Bank of England base rate. This does not apply if your contract sets a different rate.

Your tracker is also your tax record

In the US, a business that pays you for services may send you a Form 1099-NEC. The IRS says the business must report payments to you that total $2,000 or more in a calendar year. This applies to payments made after December 31, 2025. Before that, the amount was $600. Payments by card or through a payment app are reported on Form 1099-K instead.

So many clients will never send you a form. That does not change what you owe. The IRS says you must report all income on your tax return, even if you do not receive Forms 1099. Your own list of payments, by client and date, is how you know the total.

Do you expect to owe $1,000 or more in tax for the year? Then you generally have to pay estimated tax during the year. The IRS Taxpayer Advocate Service gives four due dates for 2026: April 15, June 15, September 15 and January 15, 2027. A tracker that shows what came in each quarter makes those payments easier to work out.

5. Tell clients where their project is

A client who does not know where their project is will ask. They ask by email, then by message, then by phone. Each question pulls you out of the work.

The fix is to tell them first. Send a short update each time a project moves to a new stage. On a project that runs for weeks, also send one on a regular day, such as Friday. Send it even when there is little news. Each update needs three things: the stage, what happens next and the date.

Some freelancers share a link the client can open at any time, instead of sending each update by hand. WISMO’s data shows how often customers check when they have one. Across 262 orders whose tracking page was opened at least once, customers opened it a median of 5 times.

Median 5 opens

Each open is a status check the client made without sending the seller a message. Our guide to order tracking links explains what such a page should show and what to leave off.

6. Check the whole list once a week

A tracker only helps if it is up to date. Pick one time each week, such as Monday morning, and spend 15 minutes on it:

1. Sort by due date. Look at everything due in the next two weeks.
2. Check each next step. Send a reminder for every project that is waiting on a client.
3. List what is owed. Send a polite reminder for every balance that is past due.
4. Check your space. Count the projects due in the same week before you say yes to a new one.
5. Close what is done. Move paid projects to a “done” tab, so the list shows only live work.

Update the stage and the money on the day they change, not only in the weekly check. The weekly check is for catching what you missed.

If a project is going to be late, tell the client as soon as you know. Our guide on what to tell a customer when an order is late has messages you can adapt.

7. Keep the records when the project ends

When a project is paid, do not delete it. Move it to your “done” list. Keep the scope, the invoice and the record of each payment with it.

The IRS says to keep records that show how much income you got and where it came from. Its examples include invoices, deposit information and Forms 1099-MISC. In most cases, it says to keep records for 3 years. Some cases need longer. For example, it is 6 years if you left out income worth more than 25% of the gross income on your return.

In the UK, sole traders must keep records for at least 5 years after the 31 January deadline for that tax year. This is the rule on GOV.UK.

A done list has one more use. It shows you which clients have hired you before. When a quiet month comes, those are the first people to write to. Our guide on how to follow up with past customers shows how to do it without sounding like an ad.

When a spreadsheet is enough, and when it is not

A spreadsheet is a good tracker for many freelancers. It is free, you can add any column you like, and you can sort it in a second. Our free order tracker template has the main columns ready, and you can rename them for projects.

A spreadsheet starts to fail in a few ways:

• You forget to update it. It does not remind you that a draft is due tomorrow.
• You work from your phone. Spreadsheets are hard to edit on a small screen, so updates wait until you are at a desk.
• Clients still ask for updates. A spreadsheet is for you. You still have to send every update by hand.
• You need an invoice. You copy the same details into a separate invoice file.

If none of these is a problem, keep the spreadsheet. If two or three are, an app built for this can help. Most freelancers who work alone do not need full project management software. You need a list of projects, due dates and payments, not task boards and team members.

How WISMO does this

WISMO is an order tracking app for small businesses, and many freelancers use it to track client projects. Each project is an order. It keeps the client, the items you will deliver, the due date and the price. It also has a description where you can write the scope. Our page for freelancers shows how it looks for client work.

You can name your own stages, up to 12, such as Brief agreed, First draft and Final files sent. Each project gets a link the client can open in any browser, with no login. It shows the stage, your notes and what they have paid. You record the deposit and each payment, and WISMO shows the balance. The calendar shows every due date, and a push notification reminds you the day before a project is due. You can make an invoice for any project. When a regular client books the same job again, Duplicate Order copies the project.

WISMO is not project management software. It has no time tracking, no task boards, no client approvals and no file delivery. It does not take payments for you. Send your files and take payments the way you do now. Use WISMO to keep track of where each project is.

Your first 30 orders are free, and the calendar, payments, invoices and client link are included. WISMO Pro is $9.99 a month or $99.99 a year. It adds unlimited orders, photo updates and automatic emails to clients when a stage changes. You can try Pro free for 7 days.