Best Value Complete Financial Planning Bundle →
✓ Financial Planning✓ Net Worth Tracker✓ Monthly Budgeting✓ Travel Budget Planner✓ Annual Budgeting Planner✓ Monthly Expense Tracker✓ Annual Tax Planner✓ Retirement Planning
$139 One purchase, no subscription
View Bundle →
by Segmio
View Bundles
Language
ENEnglishDEDeutschESEspañolFRFrançaisPTPortuguêsITItalianoARالعربيةNLNederlandsZH中文
Free Download - Excel & Google Sheets

Free Sales Invoice Spreadsheet Template for Google Sheets & Excel

Ten line items, each with a description, a quantity, a unit price and a category that keeps goods, shipping and add-ons apart. The Free Sales Invoice spreadsheet template puts the tax rate in a cell of its own rather than inside a formula, and works the subtotal, the tax and the TOTAL DUE out as you type. A complete invoice on one working sheet, Google Sheets or Excel. No macros, no VBA, no sign-up.

Works in Excel and Google Sheets · CC BY 4.0
Get more value with Essentials Spreadsheet Template
sales-invoice.xlsx
Free Sales Invoice Spreadsheet Template for Google Sheets & Excel - dashboard preview

Get More with the Essentials Sales Invoice Spreadsheet Template

Free Sales Invoice

Spreadsheet Template
Works in Excel and Google Sheets · CC BY 4.0
Works in Excel and Google Sheets · CC BY 4.0
What's Included
  • A complete invoice on one working sheet
  • Line items with a description, a quantity and a unit price
  • A category per line, keeping goods, shipping and add-ons apart
  • A tax rate in a cell of its own rather than inside a formula
  • Subtotal, tax and TOTAL DUE worked out as you type
Most popular
Essentials Sales Invoice spreadsheet template - Google Sheets and Excel preview

Essentials Sales Invoice

Spreadsheet Template
  • Everything in Free
  • Line items with SKU, description, quantity and unit price
  • Amounts that stay blank until quantity and price are both entered
  • The customer recorded by name, company, address and email
  • Invoice number, invoice date, due date and payment terms
View Essentials Sales Invoice Spreadsheet Template $19›

The FinancialAha Free Sales Invoice Spreadsheet Template is a one-sheet workbook for Google Sheets and Excel, with a How to Use guide on a second tab. It works as a Free Sales Invoice Excel template and a Free Sales Invoice Google Sheets template from the same download. Line items with quantities and unit prices, a tax rate you set rather than one baked into a formula, and a total a customer can pay from. No macros, no VBA, no sign-up.

Inside the workbook

What's inside the FinancialAha Free Sales Invoice spreadsheet template

The FinancialAha Free Sales Invoice Spreadsheet Template runs on a single working sheet, with the instructions on a tab of their own. It works in both Microsoft Excel and Google Sheets and here is what the Free Sales Invoice spreadsheet holds.

  1. 01 of 01

    Sales Invoice

    Your business at the top, the customer beside it, and the invoice's own details - number, date, due date and payment terms - underneath. Then the line items, each carrying a description, a category, a quantity and a unit price, with the line total worked out and everything summed at the foot. The tax rate sits in its own cell rather than inside the formula. That sounds like a small thing and is not: sales tax depends on where the seller is and what is being sold, and a template with a rate welded into a formula asks its user either to accept somebody else's jurisdiction or to go editing formulas on a document they are about to send a customer. Shipping and add-ons go in as line items here rather than as separate fields, which keeps the arithmetic visible - a customer querying a total can see every component of it on the same list. The due date and the payment terms are the two fields worth setting rather than leaving. An invoice without a date to work to is a document that gets paid when someone gets round to it.

    FinancialAha Sales Invoice spreadsheet template - Sales Invoice sheet

  2. Included guide

    How to Use

    A step-by-step guide on its own tab, covering how to replace the sample values, how the tax rate cell works, and how to change the currency. Because it ships inside the file, the instructions travel with the template wherever it is opened.

Works in both Google Sheets and Excel

Free Sales Invoice Spreadsheet template for Google Sheets

Upload the Free Sales Invoice Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Free Sales Invoice Google Sheets template needs no conversion step and the totals recalculate exactly as they do in Excel.

Free Sales Invoice Google Sheets template setup

A shared copy of the Free Sales Invoice Google Sheets template suits a business where someone raises invoices and someone else chases them, since both work from the same due dates.

Running the Free Sales Invoice Google Sheet

The Free Sales Invoice Google Sheet is filled in per sale and sent. Keeping a copy of each is what makes a later question about what was charged answerable.

Also available as:

Free Sales Invoice Spreadsheet template for Excel

The Free Sales Invoice spreadsheet Excel download is a plain .xlsx. Excel opens this Free Sales Invoice Excel template directly, with no import step and no compatibility prompt, and the totals update as you type. There are no macros and no VBA in the file, so it opens without a security warning.

Free Sales Invoice Excel template setup

The same Free Sales Invoice Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Free Sales Invoice spreadsheet download to choose between.

Free Sales Invoice spreadsheet Excel notes

The Free Sales Invoice spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt.

Opening the Free Sales Invoice spreadsheet Excel file

Nothing in the Free Sales Invoice Excel template is version-specific, so this Free Sales Invoice spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.

Also available as:

Spreadsheet template highlights

What the Free Sales Invoice spreadsheet template tracks

A line per item sold. This is what the Free Sales Invoice Spreadsheet Template records for each:

Description
what was sold, in terms the customer will recognise on their statement
Category
retail, add-on, shipping or your own headings
Qty
how many
Rate
the unit price charged
Line Total auto
derived, and summed into the subtotal beneath

Compare builds

FinancialAha Sales Invoice spreadsheet template: Free, Essentials, and Ultimate compared

Feature Free This page Essentials View Spreadsheet Template
Working sheets 1 1
Line items 10 12
SKU per line – Yes
Tax rate An editable cell An editable cell
Shipping as its own line A line item Its own field in the totals
Customer recorded Name and address Name, company, address and email
Payment instructions – Yes
Notes and terms block – Yes
Charts – –

The FinancialAha Free Sales Invoice Spreadsheet Template covers the sale: itemised lines, a tax rate you set and a total due. The Essentials Sales Invoice Spreadsheet Template for Google Sheets and Excel is the fuller document on the same single page - an SKU on every line, the customer recorded with a company and an email, shipping as its own field in the totals rather than a line item, and blocks for payment instructions and for notes and terms.

Compare the other builds: Essentials Sales Invoice spreadsheet template .

Good to know

Notes on working in the Free Sales Invoice spreadsheet template

  • Quantity is units and rate is the price per unit, so each line total is the extended price.
  • Unit prices carry their decimals through to the line total rather than rounding on the way.
  • Blank line rows return nothing rather than a zero.
  • The tax rate sits in a cell of its own and the tax line reads the subtotal against it.
  • One invoice per file. A log of what has been raised and what has come back is the Essentials build.
  • The dropdown beside the title relabels the rate and total columns. It changes the label and nothing else.

How the Sales Invoice template works

The Free Sales Invoice Spreadsheet Template is the document you send after a sale. Your business sits at the top, the customer beside it, and the invoice details - number, date, due date and payment terms - underneath. The line items follow with a description, a category, a quantity and a unit price, each line totalled, then a subtotal, tax and the total due. The tax rate sits in a cell of its own rather than inside the formula, because the right rate depends on where the seller is.

When this template helps

01

You have sold something and need a document the customer can pay from.

02

You want the tax rate to be a field rather than a formula edit.

03

You bill occasionally and do not want an invoicing subscription for it.

04

You need a PDF-ready layout that works the same in Excel and Google Sheets.

Tips to get the most out of it

  • A goods invoice gets read against a delivery, so descriptions that match what is on the box save a query later.
  • The category column separates product groups when an order runs long.
  • The due date and the terms are separate fields, so the invoice can state a date and the agreement it came from.

Common mistakes to avoid

  • Reusing an invoice number. It is the reference a customer quotes when they pay, and two invoices sharing one makes a payment impossible to match.
  • Leaving the sample business details in the header before sending.
  • Leaving the due date blank, which turns a payment date into a matter of opinion.
  • Keeping one file and overwriting it per sale. A copy per invoice is what makes a later question about what was charged answerable.

How to Use the Free Sales Invoice Spreadsheet Template

1
Add your details
Your business name and contact details at the top.
2
Name the customer
The Bill To block, with the address the invoice goes to.
3
Set the dates
Invoice number, invoice date, due date and payment terms.
4
List what was sold
Description, quantity and rate. The total due follows.
Essentials
Sales Invoice
Essentials (19) is the fuller build - the comparison table on this page lists exactly what it adds.
View Essentials $19

Built by Claude AI. Perfected by us.

We use Claude AI to draft each template, after a deep research. Then our team steps in. We refine the layout, stress-test every formula, fix edge cases, and polish the design until it feels like something we would actually use ourselves. The AI gets us 80% there. The last 20% is all human judgment.

Excel
Sheets
No signup
Download instantly, no email required
Formula-driven
All calculations update automatically
Dual compatible
Works in Excel and Google Sheets
Sample data included
See the template in action right away

Frequently Asked Questions

What is the difference between the free and Essentials Free Sales Invoice spreadsheet template?

Free is a single-sheet starter template with sample data and a How to Use guide. Essentials ($19) is the fuller build - more capacity, more detail, and more worked out for you rather than typed. This template has no Ultimate build. What each tier holds differs by template - the comparison table on every template page lists it exactly.

Which Free Sales Invoice spreadsheet template should I download?

Upgrade to Essentials if you want a dashboard with charts, more categories, larger capacity, and a more polished spreadsheet for ongoing use. The Free version is a good fit for one-off planning or trying out the layout.

Can I upgrade the Free Sales Invoice spreadsheet template later?

Essentials is a one-time $19 purchase with no subscription. It typically adds a full dashboard, 30-50% more categories or rows than the Free version, and richer formulas. Most buyers upgrade after using the Free version for a few weeks and hitting its limits.

Is the FinancialAha Free Sales Invoice Spreadsheet Template a Google Sheets template?

Yes. Upload the file to Drive and choose "Open with Google Sheets". Nothing needs rewriting in the Free Sales Invoice Google Sheets template, and Sheets exports to PDF in a couple of clicks, which is one way an invoice reaches a customer.

Is the FinancialAha Free Sales Invoice Spreadsheet Template an Excel template?

Yes. The download is a plain .xlsx, so the Free Sales Invoice Excel template opens directly in Excel with no import step. There are no macros and no VBA, which matters for a document emailed to a customer.

Will the FinancialAha Free Sales Invoice spreadsheet Excel file open in older versions of Excel?

Yes. The Free Sales Invoice spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.

Can I change the tax rate in the Free Sales Invoice spreadsheet template?

Yes. It is a cell rather than a figure inside the formula, so a different rate takes one edit and the tax and total due follow. That is deliberate: sales tax depends on where the seller is and what is being sold, and nobody should have to edit a formula on a document they are about to send a customer.

How do I add shipping to the Free Sales Invoice spreadsheet template?

As a line item, with the category set to shipping. Keeping it on the list means a customer querying the total can see every component of it in one place. A separate shipping field in the totals is on the Essentials build.

How many line items does the Free Sales Invoice hold?

Ten, with six filled in the sample. The Essentials Sales Invoice takes twelve and puts an SKU on each one.

What is the difference between the Free Sales Invoice and the Essentials build?

The free build covers the sale. Essentials is the fuller document on the same single page: an SKU on every line, the customer recorded with a company and an email, shipping as its own field in the totals, and blocks for payment instructions and for notes and terms.

Does the FinancialAha Free Sales Invoice spreadsheet track which invoices have been paid?

No. This is the document you send, one file per sale. Following which of them have been paid is what an invoice tracker is for.

How do I open the Free Sales Invoice spreadsheet template in Google Sheets?

Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.

Can I use the Free Sales Invoice spreadsheet template for commercial work?

All free templates are released under CC BY 4.0 (Creative Commons Attribution). You can use, modify, and share them freely - including for commercial purposes - as long as you credit FinancialAha.com. They are provided as-is and do not constitute financial advice.

More Free Invoicing & Billing Templates

Simple Invoice

Ten line items, each with a description, a quantity and a rate, and a category so one kind of work is tellable from another. The Free Simple Invoice spreadsheet template holds the tax rate in a cell of its own rather than buried inside a formula, and works out the subtotal, the tax and the TOTAL DUE as you type. A complete invoice on one working sheet, How to Use on a second. Google Sheets or Excel. No macros, no VBA, no sign-up.

Free

Service Invoice

Ten line items, each with its own description, quantity and rate, so rates differ line to line rather than one rate covering the whole invoice. A category on every line keeps one kind of hour tellable from another. The Free Service Invoice spreadsheet template holds the tax rate in a cell of its own rather than inside a formula, and totals to a figure the client can pay from. One working sheet plus How to Use. Google Sheets or Excel. No macros, no VBA, no sign-up.

Free

Consultant Invoice

Billed time and reimbursable expenses share the same ten lines, told apart by a category on each, so hours and passed-through costs stay legible without two separate tables. The Free Consultant Invoice spreadsheet template works each line total out from a quantity and a rate, and keeps the tax rate in a cell of its own rather than buried inside a formula. One printable invoice. Google Sheets or Excel. No macros, no VBA, no sign-up.

Free

Freelancer Invoice

Fixed-fee stages and hourly work sit on the same ten lines, told apart by a category, each line carrying its own rate rather than one rate for the whole invoice. The Free Freelancer Invoice spreadsheet template keeps the tax rate in a cell of its own instead of buried inside a formula, and puts its How to Use guide on a second tab. Google Sheets or Excel, one file. No macros, no VBA, no sign-up.

Free
Sales Invoice
Free · $19
View Essentials Sales Invoice Spreadsheet Template $19