TTime-Trak/Blog
Download →
How-To·3 min read·November 19, 2026

How to Build a Per-Client Billing Rate Sheet Before You Need One

When you have different rates for different clients, keeping them straight before invoicing day saves money and awkward conversations.

Why one rate never actually means one rate

Most freelancers quote different rates to different clients. An old client gets a loyalty rate. A new enterprise client gets your full rate. A friend of a friend gets something in the middle.

That is fine. The problem is what happens when you have four clients, three different rates, and no written record of who agreed to what.

Invoice day becomes archaeology. You are digging through emails trying to remember what you promised someone in October.

A per-client billing rate sheet fixes this. It does not need to be complicated. It just needs to exist before the work starts.

What goes on the sheet

For each client, write down:

- Their standard hourly rate for your core service
- Any alternate rates for different service types (calls, strategy, production work, rush work)
- Whether any project is fixed-price, and if so, what the agreed hour budget is
- The date you agreed on these rates
- When you plan to review them next

That last item is the one most people skip. Rates agreed two years ago often do not reflect your current costs or market rate. If you never schedule a review, you never do one.

How this connects to your time tracker setup

In Time-Trak, you can assign a billing rate at the project level. That rate feeds directly into your invoice calculations when you are ready to bill.

But it only works if the rate in the app matches the rate on your sheet. If you quote a client verbally, start tracking time the next day, and forget to update the rate in the project settings, your invoice math is already wrong.

The sheet is your source of truth. The app pulls from it. Take two minutes when you set up a new project to cross-check both.

Handling multiple rates inside one project

Some projects have more than one rate. You might charge one rate for execution work and a higher rate for strategy or consultation. That is not unusual. It just requires cleaner tracking.

When you set up the project in Time-Trak, create separate tasks or categories for each rate tier. Log your execution hours under one, your strategy hours under another. When you run the invoice, the breakdown is already there.

If you log everything under one flat category and then try to split it out at invoice time, you are doing extra work you already did. The whole point of tracked time data is that it handles the math for you.

Reviewing the sheet every quarter

Set a calendar reminder. Four times a year, open the sheet and look at every client.

Ask: has the work changed? Has the volume changed? Has your cost of doing business changed?

You are not obligated to raise rates. But you should be making that choice deliberately, not by default.

Your time tracker data is useful here too. If you can see that a client who pays your lowest rate consistently runs over scope, the math of that relationship is probably not what you thought it was. The data is there. You just have to look at it.

One more thing to put on the sheet

Note whether each client has seen your rates in writing. Not just a verbal conversation. An email, a proposal, a contract, something.

If a billing dispute ever comes up, the question is not what you remember. It is what you can show. A rate sheet you keep for yourself does not help you in that conversation unless the client agreed to those numbers somewhere.

This is not about being suspicious of your clients. It is about making sure both sides are working from the same information. That protects the relationship as much as it protects your invoice.

Track your time, bill every minute.

Time-Trak is a native Mac and Windows time tracker with a floating timer, automatic screenshots, and one-click invoicing.

Free during beta.

Download Time-Trak →

macOS + Windows · Floating widget · Auto screenshots

More like this

← All articles·time-trak.com