Audit Realised Project Rates Against Your Floor — Free
A quoted rate is a promise; the realised rate is the receipt. Divide each finished project’s fee by the hours it actually consumed and see which engagements quietly paid below the floor.
The proof surface
Rate-floor calculators work out the hourly rate the business needs to survive. This audits finished work against that floor — the rate actually realised per project once the real hours are counted — so the next quote is priced from evidence.
Why the flat version breaks
Quoting the hours as they were estimated
The audit’s whole subject is the difference between estimated and consumed hours.
Excluding management and revision time
Unbilled oversight is real work; leaving it out flatters every rate.
Cutting quality to protect the rate
The response to a weak realised rate is pricing and scope, not quietly doing less.
How to work the realised rate triage
Rows are projects with a final fee and a final hour count — open engagements move too much to audit honestly.
Calls, revisions, project management and the scope creep absorbed for goodwill — not the hours the quote assumed.
From the rate-floor calculation your business costs support, not from the rate you wish the market paid. Fifty units an hour is a floor decision, not a boast.
The triage reports realised rate per project and holds the weakest. A nine-hundred fee over twenty-five hours realises thirty-six against a fifty floor — that gap is the next scope clause or the next polite no.
What the realised rate triage replaces
| Question | Before | Visible working |
|---|---|---|
| Quoting the hours as they were estimated | The audit’s whole subject is the difference between estimated and consumed hours. | Count the hours the project actually consumed |
| Excluding management and revision time | Unbilled oversight is real work; leaving it out flatters every rate. | Set the floor rate once |
| Cutting quality to protect the rate | The response to a weak realised rate is pricing and scope, not quietly doing less. | Reprice the weakest engagements |
A local arithmetic aid replaces hand calculation, not expert review. No paid AI service is needed.
Run it on the samples, right here
FIRST-LOAD
Input is processed locally and a draft is saved automatically in this browser profile when storage is available. Reset to sample clears that draft; Pro history has its own clear button. A state link encodes your inputs in its URL: share only non-sensitive rows. Browser history, clipboard and anyone receiving the link may retain it. Optional AI use below leaves this device; it is not required.
Rate arithmetic on the fees and hours you supply. Not pricing, tax or contracting advice; rate floors, expenses and tax treatment come from your own accounts and your accountant, and contract terms belong in writing before work starts.
Data note: Everything runs in this browser tab on the realised rate triage: your project | fee earned | hours actually worked stays on this device, nothing is uploaded, and the reading is rebuilt only when you press run.
Go deeper: the companion app files the same reading as a triage clipboard with three lanes
The article demo above runs without limits. The companion app keeps a local history, exports the rows as CSV, prints the realised rate triage reading, and holds your drafts on this device — one free run, then $ 4 one-time for the layer that keeps filing.
The realised rate triage reading is complete for free. The optional $4 layer adds print, row CSV and the last five local reading summaries; it does not add hidden answers. Checkout is not configured yet; the article demo remains unlimited.
Open the audit realised project rates against your floor companionBoundary
Rate arithmetic on the fees and hours you supply. Not pricing, tax or contracting advice; rate floors, expenses and tax treatment come from your own accounts and your accountant, and contract terms belong in writing before work starts.
What this is built on
- Method: From the rate-floor calculation your business costs support, not from the rate you wish the market paid. Fifty units an hour is a floor decision, not a boast.
- All sample records are invented examples. The app does not fetch measurements, policies, files or personal records.
- Google’s official pricing page, fetched 2026-09-29, lists free-tier access including AI Studio. Optional formatting only; limits and availability can change. Free-tier content may be used to improve products. Never paste private records there.
Before: The audit’s whole subject is the difference between estimated and consumed hours. After: the realised rate triage shows the working beside each named row so the reader can change the assumption and inspect the consequence.
Optional AI formatting, not calculation
For this realised rate triage, use the free AI Studio interface only if available to you, with no paid API key. Manual entry completes the same workflow for free. Supply only fictional or non-sensitive notes. Review its output against the source; never paste unresolved questions into the numeric rows.
Format my non-sensitive notes for a realised rate triage. Return plain rows only: project | fee earned | hours actually worked. Preserve supplied quantities exactly. Do not guess missing values; list questions separately. Do not calculate or add advice. I will check every row before pasting into the local tool.
Accepted schema: project | fee earned | hours actually worked. No AI response is executed as code.