Home › Timesheet template › Weekly

Weekly Timesheet Template

A weekly timesheet is the freelancer’s unit of billing: one sheet, seven days, one row per day for each client and project — with per-client subtotals at the bottom that become the invoices. This free weekly timesheet template is the weekly layout in depth: the columns, the decimal-hours rules, the rounding policy, and the Friday routine that turns a week of work into paid invoices.

Most weekly timesheet templates are built for employees clocking in and out for payroll. This one is built for the person who bills by the hour: the client and the project come first, because those are what the invoice is organized by. Every section below ends at the same place — the invoice. Billia does not make a timesheet app, and this page does not pretend otherwise: it is the template itself, laid out so you can copy it into a spreadsheet in two minutes and print it, and the free invoice generator is where the week’s hours become the invoices. For the overview of both layouts, see the free timesheet template — weekly and biweekly side by side. For clients on a two-week cycle, the biweekly timesheet template covers the two-week layout in depth — two weeks on one sheet, each week with its own total, and the overtime trap that comes from averaging them.

The freelancer’s weekly timesheet (client/project, not punch-clock)

An employee timesheet answers one question: when were you on the clock? A freelancer timesheet answers a different one: who pays for this hour? That changes the columns, and it changes the unit. The week is the unit — Monday to Sunday, one sheet per week, invoiced on Friday — because a week is short enough that the work is still fresh when the invoice goes out, and long enough to hold a real amount of billable time.

One row per day, per client and project. That is the rule that makes a weekly sheet work: Monday for Acme is one row, Tuesday for Acme is another, and if Tuesday also had two hours for a second client, Tuesday gets a second row. A day with two clients is two rows, never one row with two clients crammed into it — the moment a row holds two clients, the per-client subtotals at the bottom stop adding up, and the invoice they feed stops being checkable.

The header names the week: your name or business, the week-ending date, and the rates in play. The week-ending date is the piece people skip, and it is the piece the client files by — “week ending Friday, November 6” is a record; “this week” is a guess. If you bill different rates to different clients, put the rate on each row, not in the header, so a rate change mid-week never rewrites the rows before it.

Weekly is the freelancer default for a reason. Invoices go out faster, disputes surface while the work is still fresh in everyone’s memory, and a weekly rhythm makes late payment visible in days instead of months. A client who pays weekly is a client you find out about quickly; a client who pays monthly is a client you find out about after a month of unpaid work.

What goes on every row

Every row on a weekly timesheet needs the same eight columns. They are the same columns as any freelancer timesheet — what changes on the weekly sheet is the footer, which carries a subtotal per client before the grand total, so each invoice is one subtotal, already computed.

ColumnWhat goes in it
DateThe calendar day the work happened
ClientWho is being billed for this row
ProjectWhich engagement the work belongs to
DescriptionWhat you did, specific enough for the client to recognize
HoursDuration as a decimal — 1.5, never 1:30
RateYour hourly rate for this client or project
BillableYes or no — the client pays for this row or not
AmountHours × rate on billable rows; $0 on the rest

The description is where most timesheets fail. “Website work, 4 hours” is not a record a client can approve — it is a dispute waiting to happen. Write the description the way the client will read it on the invoice: “Homepage layout — hero, services, testimonials” instead of “design.” Specific enough that the client recognizes the work when they see the invoice; short enough that logging it takes ten seconds.

Log daily, not on Friday. By Friday, Tuesday’s two hours have blurred into one, and the hours you cannot remember are hours you cannot bill. A notes app entry at the end of each work block beats a perfect spreadsheet you fill in once a week.

Keep the non-billable rows. A standup call, a proposal, an hour of bookkeeping — they feel like confessions, but they explain why a 40-hour week produced 25 billable hours. If you only write the billable rows, next quarter you will set a rate from a week that never happened. The non-billable rows bill $0 and still count in the total hours, so the sheet tells the truth about both numbers. And if the client requires sign-off, a signature line at the bottom turns the sheet into an approved record instead of your word against theirs.

Decimal hours and rounding (the 1:20 ≠ 1.20 trap)

Write hours as decimals, always. 1.5 means an hour and a half; 0.25 is a quarter hour. Never write 1:30 — to a spreadsheet, 1:30 is a time of day, a fraction of 24 hours, and every sum after it comes out wrong. Decimals add up; clock times do not. Converting is one division: minutes divided by 60.

MinutesDecimal hours
50.08
100.17
150.25
200.33
300.50
400.67
450.75
500.83

The classic error is typing minutes straight in as decimals: 1 hour 20 minutes is 1.33 hours, not 1.20. Writing 1.20 underbills by 0.13 hours — about eight minutes — every single time it happens, and on a week of rows it quietly eats a billable hour. Check the conversion, not the habit: 20 divided by 60 is 0.33, so 1 hour 20 minutes is 1.33.

Then pick a rounding policy and state it up front — on the sheet itself and in the contract. The common default for freelancers is 15-minute increments (0.25 hours): a 50-minute task bills as 1.00 hour if you round up, or 0.75 if you round to the nearest increment. Legal and professional services more often use 6-minute increments (0.1 hours). Either policy is defensible — but only if it was agreed before the work, stated on the invoice, and applied the same way on every row. A policy the client first meets on the invoice is not a policy; it is a surprise.

Round each row as you log it, so the week’s total is the sum of rows that are already rounded — no surprise at the bottom of the sheet. Rounding the day’s total instead is also workable, but never mix the two on one sheet: a week where Monday’s rows are rounded and Friday’s total is rounded will not add up, and the client will find the gap before you do. Write the policy in the header — “Hours billed in 15-minute increments, rounded up” — so anyone reading the sheet can check the math.

Overtime, simply

The weekly sheet is where overtime shows up, because overtime is a weekly number. Under the federal Fair Labor Standards Act, a covered employee who works more than 40 hours in a workweek must be paid at least one and a half times their regular rate for every hour past 40. A few states go further: California, Alaska, and Nevada also require overtime after 8 hours in a single day. Federal law has no daily trigger and no weekend or holiday premium — only the 40-hour week counts.

Here is the catch for freelancers: that law covers employees, not independent contractors. Nobody owes you overtime unless your contract says so. So write it into the contract before the extra hours happen, not after: hours over 40 in a week, or rush and after-hours work, bill at 1.5× your rate. Time and a half is the convention clients already understand, which is exactly why it works as a contract term — nobody has to be persuaded that 1.5 is fair.

The math, on a $80 rate and a 48-hour week: 40 regular hours at $80 is $3,200. The 8 overtime hours at $120 (1.5 × $80) add $960. The week totals $4,160, and the timesheet shows the split — 40 regular, 8 overtime — so the client can check it in one glance. Put the overtime rows on the timesheet with their own rate, not folded into the regular hours: a single blended line invites exactly the argument the split prevents.

From timesheet to invoice

The timesheet is the input; the invoice is the output. Here is what a filled-in week looks like — two clients, one sheet, and the per-client subtotals that make the invoices:

DateClientProjectDescriptionHoursRateBillableAmount
Mon Nov 2Acme CoWebsite redesignHomepage layout — hero, services, testimonials3.50$80Yes$280
Tue Nov 3Acme CoWebsite redesignClient call + revisions, round 12.25$80Yes$180
Tue Nov 3Beta LLCLogo refreshInitial concepts, three directions1.50$90Yes$135
Wed Nov 4Acme CoWebsite redesignContact + pricing pages4.00$80Yes$320
Thu Nov 5Beta LLCLogo refreshRevisions, round 12.00$90Yes$180
Fri Nov 6Acme CoWebsite redesignFinal revisions + handover notes2.75$80Yes$220
Fri Nov 6Acme CoAdminProposal for phase 2 (not billed)1.00$80No$0
Subtotal — Acme Co12.50$1,000
Subtotal — Beta LLC3.50$315
Week total17.0016.00 billable$1,315

Two invoices come off this one sheet: Acme Co for $1,000 and Beta LLC for $315. Each invoice is one subtotal, already computed, with its own lines — one line per project, showing the hours, the rate, and the amount, with the description from the timesheet becoming the invoice line description. Never mix two clients on one invoice, and never mix two weeks: a client who disputes week two should not be able to hold week one hostage.

What about a week that straddles a month boundary? Invoice by the week, not the month. The week is the billing unit — splitting a week across two monthly invoices means neither invoice matches a sheet, and the client cannot check either one. The month-end close can wait a few days; the week’s invoice cannot.

Attach the timesheet as backup. The invoice is the bill; the timesheet is the proof. Clients pay itemized invoices with the record attached, and argue with lump sums that have none. Send it the day the week closes — an invoice sent Friday gets paid noticeably faster than one batched at month-end, because the value is still fresh. For the invoice itself, read how to write an invoice — the line items, the numbering, and the payment terms that belong on every bill. The timesheet tells you what to charge; the guide tells you how to present it.

How to use it free

  1. Copy the column layout above into a spreadsheet — Excel, Google Sheets, or Numbers all work — or print the blank layout and fill it in by hand. One file per week, named so you can find it later (2026-11-02-week, for example).
  2. Fill in the header: your name or business, the week-ending date, your rates, and your rounding policy (“15-minute increments, rounded up”).
  3. Log each block of work the day you do it, in decimal hours, one row per day per client and project, with a description the client would recognize.
  4. On Friday, total the sheet: a subtotal per client, then the grand total — total hours, billable hours, and the amount. Check the non-billable rows are still there and the rounding policy was applied the same way on every row.
  5. Turn each client’s subtotal into an invoice with Billia’s free invoice generator — the billable hours become the line items, the timesheet goes along as backup, and the PDF arrives in your inbox. No account, no watermark.

That is the whole system: a sheet you own, a habit that takes ten seconds a block, and an invoice that writes itself from the Friday totals. Keep one more habit with it — save the finished timesheet with the invoices it produced, in the same folder, under the same name. Six months from now, when a client asks what that invoice was for, the answer is one search away.

Turn this week’s hours into an invoice

Your timesheet subtotals are the line items. Billia’s free invoice generator turns them into a clean PDF — no signup, no watermark.

Create my invoice — free

Frequently asked questions

What should a weekly timesheet include?

A header with your name or business, the week-ending date, and your rates; one row per day for each client and project, with the date, client, project, a specific description, the hours in decimals, the rate, and whether the row is billable; a subtotal per client; and a grand total of total hours, billable hours, and the amount. Add a signature line when the client requires sign-off, and write your rounding policy in the header so anyone reading the sheet can check the math.

How do I round hours on a timesheet?

Convert minutes to decimals by dividing by 60 — 1 hour 20 minutes is 1.33 hours, not 1.20. Then apply one rounding policy, agreed before the work: 15-minute increments (0.25 hours) is the most common freelancer default, while legal and professional services more often use 6-minute increments (0.1 hours). A 50-minute task bills as 1.00 hour if you round up, or 0.75 if you round to the nearest increment. State the policy on the sheet and on the invoice, and apply it the same way on every row.

Should I track start/end times or just hours?

Just the hours — the duration is what the invoice needs. Start and end times look precise, but they turn every row into a small calculation, and nobody invoices from clock times. Track start and end times only if a client requires them, or keep them in a notes app for your own record; the timesheet itself carries the duration in decimals, the client, and the project.

How does a timesheet become an invoice?

Total the billable hours per client for the week — each client’s subtotal is already on the sheet — then put one line per project on the invoice with the hours, the rate, and the amount. Send one invoice per client per week, attach the timesheet as backup, and send it the day the week closes. Billia’s free invoice generator turns those line items into a clean PDF — no account, no watermark.