Invoice template
Hourly Invoice Template
Copy our free hourly invoice template, add your hours and rates, and automate your hourly billing straight from Google Sheets.
Trusted by teams at
Hourly Rate Invoice Template
You can create hourly invoices automatically from Google Sheets in a few easy steps. Portant works as a free hourly invoice template that contains everything an invoice for hourly work needs: your logo, a unique invoice number, the invoice date, payment terms, and an itemized list of hours worked with the hourly rate and line totals. After you've opened Portant Workflow, select your Google Sheet, connect a Google Docs invoice template, customise your blank hourly rate invoice template with column tags for hours and rates, attach it to an email, and click 'Start automation'. Your hourly invoicing now runs itself.
Billing by the hour means every invoice is different: the hours change, the totals change, and copying timesheet data into an invoice template by hand is slow and easy to get wrong. Track your hours in a spreadsheet once, and let Portant turn each row into a polished, accurate hourly invoice.
Prefer Microsoft Word? Download the free hourly invoice template as a .docx file and edit it in Word.
With Portant, you can connect a Google Sheet of tracked hours to an invoice template, click a few buttons, and invoices will be generated and sent whenever you need them. You can also customise the email and who it's sent from (e.g accounts@portant.co). It's the easiest way to put your hourly billing on autopilot.
How to automate your hourly invoices
Step 1
Open Sheet
Select the Google Sheet you want to use as the data source for your invoices. Portant connects directly to your spreadsheet to pull in the data it needs.
Step 2
Connect Template
Connect your Google Docs, Slides, or Sheets invoice template. Portant will link it to your spreadsheet data source so it knows which fields to merge.
Step 3
Customize
Customize your invoice with merge tags like {{Company Name}}, {{Amount Due}}, and {{Due Date}}. Format it with your branding, colours, and layout.
Step 4
Create
Create invoices automatically when new rows are added to your sheet, or generate them manually in batches. Send via email or save to Google Drive.
How to automate your hourly invoices with a template
How it works
Step 1
Step 1: Open a Google Sheet
Open a Google Sheet that contains the data for your invoices. This could be customer details, invoice numbers, amounts, and due dates. If you don't have one yet, create a new sheet and add your column headers.
Step 2
Step 2: Connect your invoice template
Open the Portant add-on from the Extensions menu and connect your Google Docs or Slides invoice template. Portant will scan the template for merge tags and map them to columns in your sheet.
Step 3
Step 3: Customize your output
Choose how you want your invoices to be delivered. You can email them directly to customers, save them as PDFs in Google Drive, or both. Customize the email subject and body with merge tags too.
Benefits
Eliminate unnecessary manual work
Stop spending hours copying and pasting data from spreadsheets into documents. Portant automates the entire process, pulling data directly from your source and generating completed documents in seconds. Focus on the work that matters, not repetitive formatting tasks.
Make your documents more accurate
Manual document creation leads to errors, from wrong names to outdated figures. Portant maps data fields directly to your template, eliminating typos and ensuring every document is accurate and consistent. Your team sends fewer corrections and your clients get the right information every time.
Built into Google Workspace
Portant works natively with Google Docs, Sheets, Slides, and Gmail. There is no new interface to learn, no data to export, and no switching between tools. Your team stays in the apps they already use while Portant handles the document generation in the background.
What teams say about Portant
“Portant has been a game-changer for Clipboard! It's saved our sales team countless hours every week by generating order forms, proposals and contracts with info from HubSpot automatically filled in.”
“This product is a gamechanger for all of those painful manual document merges. Love what you and the team have built!”
“This software brilliantly takes over the tedious process of creating and sending invoices. This not only saves time but massively reduces errors of data entry.”
“Love this product. Have been using it for over a year and the integration to Google Workspace is awesome. Lots of credit for listening to your users!”
“Truly a gamechanger! Portant streamlines these tasks and allows me to focus on the things that require my attention and problem-solving!”
“Portant has been a game-changer for Clipboard! It's saved our sales team countless hours every week by generating order forms, proposals and contracts with info from HubSpot automatically filled in.”
“This product is a gamechanger for all of those painful manual document merges. Love what you and the team have built!”
“This software brilliantly takes over the tedious process of creating and sending invoices. This not only saves time but massively reduces errors of data entry.”
“Love this product. Have been using it for over a year and the integration to Google Workspace is awesome. Lots of credit for listening to your users!”
“Truly a gamechanger! Portant streamlines these tasks and allows me to focus on the things that require my attention and problem-solving!”
Frequently asked questions
An hourly invoice template should include your name or business name, contact information, the client's details, a unique invoice number, the invoice date and payment due date, and an itemized list of the work performed. For each line item, show the date or description of the work, the number of hours worked, the hourly rate, and the line total. Finish with a subtotal, any tax, the total amount due, and your accepted payment methods and terms. Clear hours and rates on every line make it easy for clients to verify your work and pay on time.
Multiply the hours worked by your hourly rate for each line item, then add the line totals together to get your subtotal. Apply any tax or discounts to reach the final amount due. If you track your hours in Google Sheets, you can let the spreadsheet calculate every line total and the grand total automatically, and Portant will merge those values straight into your invoice so the maths is always right.
Most businesses that bill hourly use decimal hours and round to a sensible increment, commonly 6 minutes (0.1 hours) or 15 minutes (0.25 hours). Pick one increment, state it in your payment terms, and apply it consistently on every invoice. Showing partial hours as decimals (for example 3.5 hours at $80) keeps the line totals easy to verify and avoids disputes about rounding.
Hourly billing suits work where the scope is open ended or likely to change, such as ongoing consulting, support, or maintenance, because you are paid for exactly the time you spend. A flat rate suits well defined projects with a clear deliverable. Many freelancers and agencies use both: a flat rate for fixed projects and an hourly invoice for everything outside the original scope. Whichever you choose, an itemized invoice that shows what the client is paying for will get you paid faster.
Yes. You can use Portant to generate hourly invoices from Google Sheets for free, and customise the template with your own logo, brand colours, hours, and rates. Portant also automates the boring part: it merges each row of your timesheet into a finished invoice and emails it to your client as a PDF, so you never copy and paste timesheet data again.
Explore related templates
Freelance Invoice Template
Copy our Freelance Invoice Template, customize it for your self employed business, and automate your sales invoice template process.
View template Invoice templateContractor Invoice Template
Copy our Contractor Invoice Template, and automate your invoice process.
View template Invoice templateConsulting Invoice Template
Copy our Consulting Invoice Template and automate your consulting business invoice process with ease.
View template Invoice templateIndependent Contractor Invoice Template
Download our Independent Contractor Invoice Template to streamline your invoicing process. Customize, save time, and ensure accurate payment terms.
View template Invoice templateService Invoice Template
Copy our Service Invoice Template, and automate your invoice process.
View template Invoice templateBusiness Invoice Template
Copy our Business Invoice Template, and automate your invoice process.
View template Invoice templateSales Invoice Template
Copy our Sales Invoice Template, automate your invoice process, and create professional invoices using customizable invoice templates.
View template Invoice templateProforma Invoice Template
Copy our Proforma Invoice Template, and automate your invoice process.
View template Invoice templateRental Invoice Template
Copy our customizable Rental Invoice Template to streamline your billing process, track rent payments, and automate your invoicing for rental business.
View template Invoice templateCommercial Invoice Template
Copy our Commercial Invoice Template and automate your invoice process for accurate commercial value.
View template Invoice templateGoogle Sheets Invoice Template
Connect your Google Sheet to a customizable invoice template and streamline your invoicing process effortlessly.
View template