Invoice template

Commercial Invoice Template

Copy our Commercial Invoice Template and automate your invoice process for accurate commercial value.

Commercial Invoice Template β€” template in Portant

Trusted by teams at

Commercial Invoice Template

You can create commercial invoices automatically from Google Sheets in a few easy steps. It is simple to use Portant as a free Google Sheets invoice template which contains all kinds of different elements including your logo, unique invoice numbers, payment terms and contact information. After you've opened Portant Workflow, select your Google Sheet, then connect a Google Docs invoice template, customise your blank invoice template with column tags, attach it to an email and finally click 'Start automation', and voila!, you’ve automated your invoicing from Google Sheets!

We know how painful and monotonous it can be to copy and paste invoice data into invoice templates, double check all the information is correct, save it as a pdf and then send the invoice to your customers. That’s why we’ve come to the rescue.
‍
With Portant you can connect a Google Sheet to an invoice template, click a few buttons and invoices will be magically generated and sent whenever you need to. You can also customise the email and who it's sent from (e.g accounts@portant.co). It's easy to place your invoicing on autopilot.

‍

How to automate your commercial 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 commercial 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 1: Open a Google Sheet

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 2: Connect your invoice template

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.

Step 3: Customize your output

Benefits

Eliminate unnecessary manual work

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

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

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.”

SC

Sam Clarke

Co-Founder, Clipboard

“This product is a gamechanger for all of those painful manual document merges. Love what you and the team have built!”

MB

Matthew B

Founder & Leadership, Upflowy

“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.”

LG

Lukas G

E-commerce Business Owner

“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!”

DI

Duncan I

Web, Google & WordPress

“Truly a gamechanger! Portant streamlines these tasks and allows me to focus on the things that require my attention and problem-solving!”

JH

Jordan H

Administrator, Mid-Market

“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.”

SC

Sam Clarke

Co-Founder, Clipboard

“This product is a gamechanger for all of those painful manual document merges. Love what you and the team have built!”

MB

Matthew B

Founder & Leadership, Upflowy

“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.”

LG

Lukas G

E-commerce Business Owner

“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!”

DI

Duncan I

Web, Google & WordPress

“Truly a gamechanger! Portant streamlines these tasks and allows me to focus on the things that require my attention and problem-solving!”

JH

Jordan H

Administrator, Mid-Market

Frequently asked questions

A commercial invoice is essential in international shipping because it serves as a legal document that customs officials use to assess duties, determine the commercial value, and verify the legality of a shipment. It provides detailed information about the goods being shipped, helping to prevent delays and facilitating the customs clearance process. By clearly outlining the terms of sale, product descriptions, and payment details, the commercial invoice also protects both the buyer and the seller from potential disputes. This document is critical to ensure a smooth transaction between the involved parties.

A commercial invoice template should include several key pieces of information: the seller's and buyer's contact details, invoice number, invoice date, purchase order number, a detailed description of the goods, quantity, unit price, total price, currency, payment terms, shipping method, delivery address, and any applicable taxes or duties. Additionally, it may include export references, country of origin, and any special instructions related to the shipment. For small business owners, it's important to create a customized template that accurately reflects the total value of the goods and complies with legal requirements.

‍

A commercial invoice and a proforma invoice serve different purposes. A commercial invoice is a final document used for shipping and customs clearance, reflecting the actual sale terms and the transaction's financial details. In contrast, a proforma invoice is a preliminary document sent to a buyer before the sale is finalized, providing an estimate or quote for the proposed transaction. While a proforma invoice helps in negotiations and order processing, a commercial invoice is used for accounting and legal purposes. In terms of usage, businesses often save the proforma invoice for internal records before creating the final commercial invoice.

‍

Yes, a commercial invoice template can be customized to suit different industries. While the core information remains consistent, specific industries may require additional details or fields that reflect their unique products or services. For example, the pharmaceutical industry might include batch numbers and expiration dates, while the technology sector might need detailed product specifications. Customizing the template ensures that all necessary information is captured accurately, enhancing compliance and communication. Companies may also need to match the design elements with their brand identity, making it easier for clients to recognize and trust the document.

‍

A commercial invoice is a legal document that binds the buyer and seller to the terms of the sale, acting as evidence of the transaction. It is used by customs officials to assess duties and taxes and verify the shipment's legitimacy. Errors or omissions in a commercial invoice can lead to legal disputes, fines, or shipment delays. Therefore, it's crucial to ensure that the information is accurate and complete, adhering to international trade laws and regulations. Businesses should also ensure that they add the correct origin and description of the goods to avoid complications during customs clearance.

‍

‍

To create a commercial invoice template for your business, you can use word processing or spreadsheet software like Microsoft Word or Excel, or choose specialized invoicing software that offers customizable templates. Start by including all essential fields, such as seller and buyer details, product descriptions, prices, and terms of sale. Ensure the design is professional and easy to read, and consider consulting with a legal or trade expert to ensure compliance with industry standards and regulations. You might also want to customize the template by adding your company logo and adjusting the layout to suit your branding.

In customs clearance, the commercial invoice acts as a critical document that customs officials review to determine the value and classification of the goods being shipped. It helps in calculating import duties and taxes and ensures the shipment complies with all applicable regulations. An accurate and complete commercial invoice can expedite the customs clearance process, reducing the risk of delays, penalties, or confiscation of goods. The document should clearly state the total value and the country of origin to facilitate the process.

Yes, specific regulations govern commercial invoices, and these can vary by country and industry. Generally, commercial invoices must adhere to international trade standards and include specific information required by customs authorities. Businesses must stay informed about the regulations in the countries they trade with, including any changes in documentation requirements, to ensure compliance and avoid legal issues. In some cases, additional information like the detailed description of the goods and their commercial value might be required.

‍

Explore related templates

Invoice template

Proforma Invoice Template

Copy our Proforma Invoice Template, and automate your invoice process.

View template
Invoice template

Sales Invoice Template

Copy our Sales Invoice Template, automate your invoice process, and create professional invoices using customizable invoice templates.

View template
Invoice template

Independent 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 template

Rental 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 template

Business Invoice Template

Copy our Business Invoice Template, and automate your invoice process.

View template
Invoice template

Consulting Invoice Template

Copy our Consulting Invoice Template and automate your consulting business invoice process with ease.

View template
Invoice template

Service Invoice Template

Copy our Service Invoice Template, and automate your invoice process.

View template
Invoice template

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 template

Contractor Invoice Template

Copy our Contractor Invoice Template, and automate your invoice process.

View template
Invoice template

Construction Invoice Template

Use our Construction Invoice Template as a versatile contractor invoice template or construction invoice form.

View template
Invoice template

Google Sheets Invoice Template

Connect your Google Sheet to a customizable invoice template and streamline your invoicing process effortlessly.

View template

Stop formatting,
start closing.

Start your 7 day free trial

Join over 40,000 sales teams using Portant to close deals faster in HubSpot.