If you bill clients by the hour, you already know the hardest part of the job is rarely the work itself. It is getting paid accurately, on time, and without an awkward back-and-forth about what those hours actually covered. A clear, professional hourly invoice solves most of that before it starts. It shows the client exactly what you did, when you did it, how long it took, and what they owe — with no room for confusion.
That is what this free hourly invoice template is built for. It is a simple Excel workbook that calculates your line totals, subtotal, tax, and total due automatically, so you spend your time on billable work instead of arithmetic. It works in Excel or Google Sheets, and you can reuse it for every client and every billing period.
Why Hourly Billing Needs a Proper Invoice
Hourly billing is different from charging a flat project fee. With a fixed price, the client agrees to one number up front and the invoice mostly confirms it. With hourly billing, the final number is built from many small pieces: a meeting here, two hours of revisions there, a full day of development later in the week. If those pieces are not documented, the client has to take your total on trust — and trust is a fragile basis for getting paid.
A proper hourly invoice turns that trust into evidence. Each row is a small, checkable fact: a description of the task, the date it happened, the hours spent, and the rate applied. When a client can follow the invoice line by line and reach the same total you did, questions disappear and payment usually follows faster.
There is a second reason, too. Your invoice is often the only record of the work that both you and the client keep. Months later, if either of you needs to check what was delivered in a particular week, the invoice is the document you will both reach for. A vague invoice helps no one at that point. A detailed one answers the question in seconds.
What a Good Hourly Invoice Must Include
Not every invoice template is built for hourly work. A generic invoice with a quantity column and a price column forces you to squeeze hours into a box that was never designed for them. Before you use any template, check that it covers these essentials.
Your business details. Your business name and contact information go at the top, so the client knows exactly who is billing them and how to reach you with questions. If you have a business address, include it as well.
The client’s details. The client’s name, and their address if you have it. This matters more than it seems: invoices sent to a company should be addressed to the company, not just to the person you worked with, or accounts departments may send them back.
Invoice number, invoice date, and due date. A unique invoice number for every invoice keeps your records clean and gives both sides a reference for payment and follow-up. The invoice date marks when the bill was issued, and the due date sets a clear deadline. Without a due date, “pay soon” means something different to everyone.
Payment terms. State how long the client has to pay — Net 14 and Net 30 are the most common — and note any late fee policy. Terms written on the invoice are far easier to enforce than terms mentioned only in an email thread.
Line items with dates, hours, and rates. This is the heart of an hourly invoice. Every row should carry a task description, the date the work was done, the hours spent, and the hourly rate. The amount for each row is simply hours multiplied by rate, and the template calculates it for you.
Subtotal, tax, and total due. The subtotal adds up all line amounts. Tax is applied as a percentage you set, and the total due is the final number the client pays. Keeping these three lines separate means the client can see exactly how the total was reached, and you can adjust the tax rate without touching any line item.
Payment notes. A short note at the bottom covers how the client can pay and what happens if payment is late. Keep it brief and professional — it is there to prevent problems, not to threaten.
This template includes all of these sections, laid out in the order a client naturally reads an invoice: who it is from, who it is for, what was done, and what is owed.
Template Walkthrough: How This Hourly Invoice Works
The workbook has two sheets. The first is the invoice itself, and the second is a short set of instructions you can keep or delete before sending.
The header block
At the top of the invoice sheet you will find fields for your business name and contact details, the client’s name and address, the invoice number, the invoice date, the due date, and the payment terms. The example values are placeholders — replace them with your own details on every invoice. Keeping the same invoice numbering sequence (INV-001, INV-002, and so on) makes your records easy to search later.
The line-items table
Below the header is the table where the actual billing happens. It has five columns: Description, Date, Hours, Rate, and Amount.
The template comes with five realistic example rows already filled in, covering consulting, design revisions, development, meeting time, and final review work. These are there to show you the format — delete them and enter your own tasks. Write descriptions the client will recognise. “Website design revisions” is good. “Work” is not. If the client cannot tell what a row refers to, expect an email about it.
Enter the date each task was performed, the hours spent, and your hourly rate. The Amount column is a formula, not a number you type: it multiplies hours by rate for that row. That means if you correct a row’s hours later, the amount, subtotal, tax, and total all update on their own.
Subtotal, tax, and total due
Under the line items, the template totals everything for you. The Subtotal adds up all five amount rows. The Tax Rate cell holds a percentage — it is set to 8% in the example, but you should change it to your own local rate, or set it to 0 if no tax applies to your work. The Tax Amount is calculated from the subtotal and that rate, and the Total Due is the subtotal plus the tax. That final number is what the client pays.
One practical tip: if your rate or your tax situation changes between clients, do not overwrite your master copy. Save a blank version of this template, and make a fresh copy for each invoice. That way your formulas stay intact and you never have to rebuild the sheet.
Payment notes
At the bottom of the invoice, a short payment note covers the due date, a late fee policy, and accepted payment methods. Edit this section to match how you actually get paid — bank transfer, check, or online payment — and add your payment details before sending. An invoice that tells the client exactly how to pay gets paid faster than one that leaves them guessing.
Hourly vs Fixed-Price Invoicing
Hourly billing is not always the right choice, and it helps to know when it fits and when a fixed price would serve you better. The table below sums up the practical differences.
| Hourly invoicing | Fixed-price invoicing | |
|---|---|---|
| Best for | Ongoing work, support, consulting, or projects where the scope is unclear | Well-defined projects with a clear deliverable |
| Client risk | Client pays for time actually spent | Client knows the total up front |
| Your risk | Income varies with hours worked | Scope creep can eat your margin |
| Invoice detail needed | High — every hour must be documented | Low — one total covers the project |
| Scope changes | Easy to accommodate — new hours are new rows | Needs a change order or revised quote |
If you do a mix of both, this hourly template pairs well with a project-based invoice for your fixed-price work. For construction and trade work, our Contractor Invoice Template covers job-based billing, and for international sales our Commercial Invoice Template handles the extra fields cross-border shipments need. You can find every free template in one place on our Free Templates page.
Common Hourly Invoicing Mistakes
Most hourly invoicing problems are small habits, not big errors. Watch out for these five.
Rounding hours carelessly. Rounding every task up to the nearest hour feels harmless, but over a month it inflates the bill noticeably, and clients notice. Record hours honestly — halves and quarters are fine, and the template handles decimals without any trouble.
Leaving dates off line items. A row without a date cannot be checked against the client’s own records. If the client keeps a calendar of your meetings and calls, a dateless invoice looks unverifiable. Always include the date the work was done, not just the billing period.
Writing vague descriptions. “Consulting” on its own tells the client nothing. “Consulting — project strategy session” tells them exactly what they paid for. A few extra words per row prevent most payment questions.
Forgetting payment terms. An invoice with no due date and no late fee note is a request, not a deadline. State your terms on every invoice, even for long-standing clients — especially for long-standing clients, because familiarity is where terms quietly slip.
Sending invoices late. Hours billed three months after the work feel like a surprise, however accurate they are. Invoice on a regular rhythm — weekly, biweekly, or monthly — and keep the same rhythm so clients can plan for it.
Download the Free Hourly Invoice Template
This template is free to download and free to use for your own business. Open it in Excel or Google Sheets, replace the example rows with your own work, set your tax rate, add your business details, and send it. There is nothing to install and no sign-up required.
If you bill by the hour, the single most valuable habit you can build is invoicing that documents itself: dates, tasks, hours, and rates, all visible on one page. This template does the formatting and the arithmetic. You just bring the hours.
Frequently Asked Questions
What is an hourly invoice template?
An hourly invoice template is a ready-made invoice designed for billing by the hour. Instead of a single project price, it lists each task with the date it was done, the hours spent, and the hourly rate, then calculates each line amount and the total due. This template does all of that automatically in Excel or Google Sheets.
How do I calculate the amount for each line?
Multiply the hours worked by your hourly rate. For example, 5.5 hours at $60 per hour is $330. In this template you only enter the hours and the rate — the Amount column calculates the result for you, and the subtotal, tax, and total due update automatically.
Should I charge tax on hourly invoices?
It depends on where you work and what kind of services you provide. Some regions require sales tax on certain services, while others do not. Set the template’s Tax Rate cell to your applicable rate, or to 0 if no tax applies. If you are unsure, check with a local accountant before sending your first invoice.
What payment terms should I put on an hourly invoice?
Net 14 or Net 30 are the most common — meaning payment is due within 14 or 30 days of the invoice date. Shorter terms suit small, frequent invoices; longer terms suit larger clients with formal accounts processes. Whatever you choose, write it on the invoice itself so there is no ambiguity.
Can I use this template in Google Sheets?
Yes. Open the file in Google Sheets and the formulas work the same way: amounts calculate from hours and rate, and the totals update automatically. You can also download it as a PDF from either program when you are ready to send it to a client.
How many line items can I add?
As many as you need. Insert extra rows above the subtotal line and copy the Amount formula into the new rows, then extend the subtotal range to include them. For very long invoices, consider grouping work by week or by project phase so the client can follow it easily.