Rate comparison sheet word

Everhour tracks billable and non-billable time, while a Word sheet helps present hourly-rate assumptions clearly.

What should you charge per hour?

Find the right rate based on your annual expenses, desired profit margin, and available billable hours. Stop guessing.

$

Rent, software, gear, salary

30%
20%

Time lost to admin, marketing, etc.

Ideal hourly rate
Minimum viable rate$65/hr
Effective hours/year960h
Projected annual revenue$91,200

Everhour does it all — track, budget, report & invoice

The calculator gives you the number — Everhour takes it from there.

Go ahead — start tracking!

One click and you're timing. Start a timer, add an entry, edit the details. This is exactly how it feels in Everhour.

  • One-click timer — browser, desktop & mobile
  • Works inside Asana, ClickUp, Linear, GitHub & more
  • Simple setup, no learning curve
Works with your favorite tool:
Everhour — Time Tracking
Time Entries
01:24:00
00:31:00
01:07:00

No more budget surprises

Set a budget, assign rates, and get alerted before you're over.

  • Real-time cost tracking
  • Set different rates per person or project
  • Alerts before you hit the budget limit
Everhour — Budgeting
Acme Web Project
1
50% of budget used
$2,500.00of $5,000.00
$2,500.00 remaining
75%
Actual costRemaining cost

Measurement

Track your budget through time or costs

Simple, customizable reports

Every report you need — configured your way, always up to date.

  • See who does what in real time
  • Configure any report
  • Scheduled email reports
Everhour — Reports

Your invoice is ready!

Tracked hours flow straight into a polished invoice — no copy-paste, no manual math.

  • Billable hours straight into the invoice
  • Configure invoice templates
  • Copy invoices to QuickBooks or Xero
  • Invoicing dashboard with status
Everhour — Invoices
Your Company LLChello@yourcompany.com
INVOICE
Invoice #1042
Group by:
DescriptionHoursRateAmount
Website Redesign14h$150/h$2,100.00
Brand Guidelines7h$150/h$1,050.00
Marketing Strategy3.5h$150/h$525.00
Total Due$3,675.00
Try Everhour for real yourself

Hourly-rate math for a client-ready sheet

What this calculation answers

A Word rate comparison sheet answers a presentation question: which hourly rate, project rate, or blended option supports the income target after business costs and taxes? The document should show the reader the rate, the assumptions behind it, and the difference between bill rate, effective rate, and net take-home. A clean table works for client review, internal approval, or your own pricing notes.

The sheet should not treat a Word table as the source of truth for formulas. Use it to present calculated rates, not to run changing math across dozens of scenarios. Put target income, overhead, benefits substitute, tax reserve, and billable hours in visible rows. Then show the resulting rate in USD with enough context for a decision.

Build the rate from costs

For U.S. self-employed pricing, use this formula: `(target income + overhead + benefits substitute + tax reserve) / billable hours`. The numerator covers desired income, ordinary and necessary business expenses, self-funded benefits, and federal self-employment and income-tax reserves. The denominator should be realistic billable hours, not every hour you spend working.

For example, set target income at $88,000, overhead at $19,000, self-funded benefits at $14,000, and tax reserve at $23,000. The total annual requirement is $144,000. If 1,600 hours are realistically billable during the year, the required rate is $90.00 per billable hour. That rate is a bill rate, not guaranteed take-home for every hour worked.

Make the Word sheet useful

A Word sheet works best when the reader needs a stable comparison, not a live model. Use one row per rate option, such as base hourly, premium hourly, project equivalent, and retainer equivalent. Add columns for annual requirement, billable hours, hourly rate, expected billed amount, and short notes. Keep assumptions visible so the table does not become a list of unexplained prices.

A common mistake is comparing quoted rates without separating billable and non-billable time. A freelancer who charges $90 per billable hour earns less per total working hour after admin, sales, revisions, and unpaid project time. U.S. freelancers also use mixed pricing. A 2023 Fiverr survey found project-based pricing was more common than hourly pricing among U.S. freelancers, so the sheet should support hourly and project comparisons.

Use a calculator or workflow

A one-off calculation is enough when you need a static Word sheet for a proposal, contract appendix, or pricing review. Calculate the rate, paste the clean result into the document, and keep the assumptions beside it. That approach works when the rate does not need ongoing updates from logged time, project budgets, or invoicing data.

A managed workflow becomes necessary when actual work changes the numbers. Everhour supports billable and non-billable time with project billing status, task-level non-billable controls, custom task rates, member-rate exceptions, and admin reports. Those controls connect the rate sheet to real tracked hours, so quoted rates can be checked against billable amount, non-billable time, and cost.

This content is for general information only, may not be fully up to date, and is provided without any warranty or liability.

High Performer

G2

Summer 2026

Best Ease Of Use

Capterra

Summer 2026

Loved by teams. Proven everywhere.

Rated in the top time trackers across G2, Capterra, and TrustRadius — with consistent praise for ease of use, integrations, and support.

10K+Teams worldwide
90K+Installs Everhour extension
196M+Tasks completed
4M+Projects tracked

Frequently Asked Questions

What belongs in a Word rate comparison sheet?

A Word rate comparison sheet should include the rate option, target income, overhead, benefits substitute, tax reserve, billable-hour assumption, calculated hourly rate, and notes. Keep the inputs visible beside the result. A reader should see why one rate is higher than another without opening a spreadsheet or asking for the formula.

Can a Word document calculate hourly rates by itself?

Word can hold simple tables, but it is not the right place for pricing logic that changes often. Run the calculation in a calculator or spreadsheet, then paste the reviewed results into Word. This keeps the document clean for presentation and reduces the risk of hidden formula errors.

Why should the sheet show billable hours separately?

Billable hours drive the denominator in the hourly-rate formula. A rate based on 2,080 paid hours assumes an employee calendar, not a solo freelancer calendar with admin, sales, and unpaid time. Showing the billable-hour base lets the reader see whether the rate rests on a realistic workload.

Which tax assumptions should a U.S. freelancer note?

A U.S. sole proprietor or independent contractor generally reports business profit or loss on Schedule C and uses Schedule SE for Social Security and Medicare taxes on self-employment income. For 2026 estimated tax, self-employment tax is 15.3% on 92.35% of net self-employment earnings, with Social Security limited by the $184,500 wage base.

Should a Word sheet include public marketplace benchmarks?

Public marketplace benchmarks can sit in a notes column as directional context, not as the calculation itself. Upwork's 2026 guide lists broad profile-rate bands, from $10-$25 for entry or admin work to $75-$150+ for specialized work. Those bands do not replace your cost-plus rate based on income target, costs, taxes, and billable hours.

How does Everhour keep rate comparisons tied to billable work?

Everhour supports billable and non-billable time through project billing status, task-level non-billable controls, custom task rates, member-rate exceptions, and admin reports. Admins can review billable time, non-billable time, billable amount, and cost, then compare real work against the rates shown in a Word sheet.

Turn rate sheets into billing clarity

Track approved billable and non-billable hours before refreshing your next rate comparison. Everhour connects project billing rules, task rates, and admin reports to cleaner pricing decisions.

14-day free trial  ·  No credit card  ·  Cancel anytime

Or