Most freelancers can tell you their day rate off the top of their head — but couldn’t tell you, without digging, which client actually pays them the most per hour, how much they’re owed right now, or what’s realistically coming in next month. Those are the numbers that decide whether a freelance practice is merely busy or genuinely profitable, and they’re exactly what an invoice app and a good memory can’t give you.
The Freelancer Business Manager turns a scattered practice — clients in your inbox, hours in a notes file, invoices in a separate app — into one operating picture. It’s a seven-tab workbook for Excel, Google Sheets, and LibreOffice, plus five PDF guides and printable sheets, built for freelancers and consultants running the whole business by hand.
Which clients are actually worth keeping
The Client Roster is the star. Fill in each client once — the work, how you’re engaged, your rate — and live columns pull straight from your Work & Invoice Log to show, per client, the hours logged, the revenue billed, what’s collected, what’s outstanding, and — the number that changes how you run your practice — your effective hourly rate on them. In the worked example, two flat-fee clients that look fine on paper turn out to pay about $75 and $80 an hour once every real hour is counted. That’s invisible in an invoice app, and it’s the difference between a client you keep and one you raise, re-scope, or let go.
Your true rate, built up
The Rate Setup tab is the floor under every quote. Enter your overhead — software, workspace, gear, insurance, fees — the salary you want to draw, and the hours you can honestly bill in a year (far fewer than the hours you work), and it returns your true cost per billable hour and a recommended rate for an hour, a half-day, a full day, or a monthly retainer block. You quote with a reason instead of a guess, and you raise your rate on a schedule instead of an apology.
A pipeline that fills next month
Billable work fills this month; the pipeline fills next month. The Project Pipeline is a proposal-to-paid funnel that weights every lead, proposal, and negotiation by its probability, so the total you plan against is the realistic one — not the fantasy where every deal lands. When the weighted number thins out, you feel the slow quarter coming in time to do something about it.
Retainers without the drift
A retainer is often the most stable income a freelancer can have, right up until a fifteen-hour block quietly becomes twenty. The Retainer Tracker is the burn-down: enter each retainer’s fee and included hours, and it pulls the hours you actually logged that month, flagging the month Over the moment you cross the block — so you renegotiate from data instead of a bad feeling.
One dashboard for the whole practice
The Dashboard rolls it all into a few numbers: active clients, monthly recurring revenue from your retainers, your weighted pipeline, outstanding invoices to chase, and your blended effective rate against your target rate — plus a count of how many clients sit below your floor. It’s the whole business at a glance, computed for you.
Own it, don’t rent it
This is a file you own, not a monthly app you rent. Buy once, keep it forever, run your practice your way — no per-client fees, no subscription, no account. It sits right between a blank spreadsheet (free, but you build every formula and the profitability math yourself) and a rented monthly business app (powerful, but a recurring bill with your data locked inside someone else’s software): the structure you need, in a file that’s yours.
Prefer Google Sheets? Your download includes a one-click “Make a copy” link to a native Google Sheet — every dropdown, formula, and calculated cell already set up and tested. No import, no fuss. Or use the .xlsx in Excel or LibreOffice. Same workbook, your choice.
Try it free first
Want a taste before you buy? The free Project Pipeline Tracker is a single-tab starter — track each project, its client, stage, and value — a real slice of the full workbook, no signup.
When the practice outgrows a spreadsheet
A spreadsheet is a great place to learn your numbers and a hard place to run a growing operation. When you outgrow running the business from a file, Ardent Seller is our living operations app for small-business sellers — customers, work, and sales tracked in one connected place, with a free plan to start, on the same own-it ethic.
A business reference, not licensed tax, accounting, or legal advice. Every figure in the examples is illustrative — your overhead, rates, and hours are yours to enter. How much to set aside for taxes, how you register or structure your freelance business, and what your contracts and payment terms should be vary by jurisdiction; confirm your own. Created with AI assistance under Ardent Workshop’s creative direction, then reviewed and edited.
