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中文

Instant digital delivery · Terms & Conditions apply

Essentials Template - Excel & Google Sheets

Essentials Simple Invoice Spreadsheet Template for Google Sheets & Excel

A discount field, subtracted before the tax is worked out, with the taxable amount shown as a line of its own. The Essentials Simple Invoice spreadsheet template takes ten itemised lines that stay blank until both quantity and rate are entered, derives the tax from a rate you set, and leaves blocks for how to pay and what the terms are. One working sheet and a How to Use tab. Google Sheets and Excel in one file. No macros, no VBA.

Instant digital delivery · Terms & Conditions apply

Essentials Simple Invoice spreadsheet template - Google Sheets and Excel preview

What's Included

  • Line items with a description, a quantity and a rate
  • Amounts that stay blank until quantity and rate are both entered
  • A discount field, subtracted before the tax is worked out
  • The taxable amount shown as its own line
  • A tax rate you set, with the tax amount derived from it
  • The client recorded by name, company, address and email
  • Invoice number, invoice date, due date and payment terms
  • A payment instructions block and a notes and terms block
  • Laid out to print on a single page
  • A currency dropdown beside the title that relabels the money columns
  • Works in Microsoft Excel and Google Sheets with no setup required

The FinancialAha Essentials Simple Invoice Spreadsheet Template is a single-sheet workbook for Google Sheets and Excel, with a How to Use guide on a second tab. It works as an Essentials Simple Invoice Excel template and an Essentials Simple Invoice Google Sheets template from the same download. Itemised lines, a discount taken off before the tax is worked out, and blocks for how to pay and what the terms are. No macros, no VBA.

Inside the workbook

What's inside the FinancialAha Essentials Simple Invoice spreadsheet template

The FinancialAha Essentials Simple 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 Essentials Simple Invoice spreadsheet holds.

  1. 01 of 01

    Invoice

    The client recorded properly - a name, the company behind it, the address and an email - beside the invoice's own details. The line items follow, each with a description, a quantity and a rate, and an amount that stays blank until both are entered, so a half-finished invoice does not show a column of zeros. The totals block is where this build differs most from the free one, and where the arithmetic matters. Subtotal, then the discount, then the taxable amount, then the rate and the tax it produces, then the total due. The order is the point: a discount comes off before the tax is worked out, because tax is owed on what the client actually pays. An invoice that taxes the full subtotal and takes the discount off afterwards bills them for tax on money that never changes hands, and a client who checks will find it. Underneath sit the two blocks that decide whether an invoice gets paid without a follow-up: payment instructions - how to pay, to which account, quoting what - and notes and terms, which is where the payment window and anything about ownership of the work belongs.

    FinancialAha Simple Invoice spreadsheet template - Invoice sheet

  2. Included guide

    How to Use

    A step-by-step guide on its own tab, covering what each block expects, how the discount and the tax rate feed the total, 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

Essentials Simple Invoice Spreadsheet template for Google Sheets

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

Essentials Simple Invoice Google Sheets template setup

A shared copy of the Essentials Simple Invoice Google Sheets template suits a small practice where one person raises invoices and another chases them, since the terms and the payment instructions are on the same page both are reading.

Running the Essentials Simple Invoice Google Sheets template

The Essentials Simple Invoice Google Sheet is filled in per job. The discount ordering and the terms block are the parts that prevent the follow-up conversations.

Essentials Simple Invoice Spreadsheet template for Excel

The Essentials Simple Invoice spreadsheet Excel download is a plain .xlsx. Excel opens this Essentials Simple Invoice Excel template directly, with no import step, and it is laid out to print on one page. There are no macros and no VBA in the file.

Essentials Simple Invoice Excel template setup

The same Essentials Simple 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 Essentials Simple Invoice spreadsheet download to choose between, and the Essentials Simple Invoice spreadsheet template behaves the same in each.

Essentials Simple Invoice spreadsheet template notes for Excel

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

Opening the Essentials Simple Invoice spreadsheet Excel file

Nothing in the Essentials Simple Invoice Excel template is version-specific, so this Essentials Simple Invoice spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds. The Essentials Simple Invoice spreadsheet Excel file needs no add-in of any kind.

Spreadsheet template highlights

What the Essentials Simple Invoice spreadsheet template tracks

A line per item billed. This is what the Essentials Simple Invoice Spreadsheet Template records for each:

Description
the work or item, in terms the client will recognise
Qty
hours, units, or one for a fixed fee
Rate ($)
what each one is charged at
Amount ($) auto
derived, and blank until quantity and rate are both filled in

Compare builds

FinancialAha Simple Invoice spreadsheet template: Free and Essentials compared

Feature Free View Spreadsheet Template Essentials This page
Working sheets 1 1
Line items 10 10
Category per line Yes –
Tax rate An editable cell An editable cell
Discount – A field, taken off before tax
Client recorded Name and address Name, company, address and email
Payment instructions – Yes
Notes and terms block – Yes
Charts – –

The Free Simple Invoice Spreadsheet Template covers the job with a category on every line. The FinancialAha Essentials Simple Invoice Spreadsheet Template records the client with a company and an email, adds a discount field that comes off before the tax is worked out, and carries blocks for payment instructions and for notes and terms. What it does not carry is the free build's per-line category column.

Compare the other builds: Free Simple Invoice spreadsheet template .

Good to know

Notes on working in the Essentials Simple Invoice spreadsheet template

  • The discount comes off before the tax is worked out, because tax is owed on what the client actually pays.
  • Amounts stay blank until quantity and rate are both entered, so a half-finished invoice shows no zeros.
  • An email on the invoice is where a query goes and where a copy gets sent when the first is mislaid.
  • The taxable amount is shown as its own line, so the arithmetic is checkable rather than implied.
  • An invoice that answers how to pay it on its own face saves the email that asks.
  • The currency dropdown beside the title relabels the money columns. It changes the label only and does not convert the numbers.

How to Use the Essentials Simple Invoice Spreadsheet Template

1

Add your details

Business name and contact details across the top.

2

Record the client

Name, company, address and email in the Bill To block.

3

Bill the work

Bill the work, each line with a quantity and a rate.

4

Discount and tax

The discount first, then the rate. The total due follows.

Stress-tested with AI.

Every template starts with deep research into how people actually track the topic. We design the layout, build the formulas, and polish the design until it feels like something we would use ourselves. Along the way, we use AI to stress-test the calculations: unusual inputs, edge cases, and formula behavior, checked until the numbers hold.

Instant digital delivery · Terms & Conditions apply

Frequently Asked Questions

Is the FinancialAha Essentials Simple Invoice Spreadsheet Template a Google Sheets template?

Yes. Upload the file to Drive and choose "Open with Google Sheets". The Essentials Simple Invoice Google Sheets template needs no conversion step, and Sheets exports to PDF in a couple of clicks.

Is the FinancialAha Essentials Simple Invoice Spreadsheet Template an Excel template?

Yes. The download is a plain .xlsx, so the Essentials Simple Invoice Excel template opens directly in Excel with no import step. There are no macros and no VBA in the file.

Will the FinancialAha Essentials Simple Invoice spreadsheet Excel file open in older versions of Excel?

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

Does the Essentials Simple Invoice spreadsheet take the discount off before or after the tax?

Before. The subtotal less the discount gives a taxable amount, and the tax is worked out on that. Taxing the full subtotal and taking the discount off afterwards bills a client for tax on money that never changes hands.

Why does the Essentials Simple Invoice spreadsheet show the taxable amount as its own line?

So the arithmetic is checkable rather than implied. A client querying the total can follow it from the subtotal to the amount due without reconstructing a step.

Can I set the tax rate in the Essentials Simple Invoice spreadsheet template?

Yes. It is a labelled cell rather than a figure inside the formula, so a job at a different rate takes one edit.

How many line items does the Essentials Simple Invoice hold?

Ten. The Free Simple Invoice also takes ten, though it carries a category column this build does not.

Does the FinancialAha Essentials Simple Invoice spreadsheet track which invoices have been paid?

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

How do I open the Essentials Simple 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.

More Essentials Invoicing & Billing Templates

Service Invoice

Hours rather than quantities: ten lines carrying a description, the hours and a rate that can differ line to line, with the hours totalled beneath them. Part hours show as part hours instead of being rounded on screen, and an amount stays blank until both hours and rate are in. The Essentials Service Invoice spreadsheet template also carries blocks for how to pay and what the terms are. Two tabs, Google Sheets or Excel. No macros, no VBA.

$19

Sales Invoice

An SKU sits ahead of the description on all twelve line items, and an amount stays blank until both a quantity and a unit price are entered. The Essentials Sales Invoice spreadsheet template records the customer by name, company, address and email, carries an invoice number, invoice date, due date and payment terms, and derives the tax from a rate you set. Shipping has a field of its own. Google Sheets or Excel. No macros, no VBA.

$19

Consultant Invoice

Service lines carry a description, hours and a rate, with the amount staying blank until both are entered and part hours shown as part hours rather than rounded away on screen. The Essentials Consultant Invoice spreadsheet template totals the hours billed beneath those lines and keeps reimbursable expenses in a section of their own, subtotalled apart. Google Sheets and Excel, one file. No macros, no VBA.

$19

Freelancer Invoice

Eight milestones, each with a description, an amount and a Complete or Pending dropdown, and the invoice bills only the ones marked complete. The Essentials Freelancer Invoice spreadsheet template totals the whole engagement separately so both figures stay visible, then takes off the deposit already paid after the tax. Two tabs, the second a How to Use guide. Google Sheets and Excel, one file. No macros, no VBA.

$19
Essentials
Preview

Instant digital delivery · Terms & Conditions apply

Highlights:

Instant download after purchase
No macros or VBA required
No sign-up, no subscription
Lifetime free updates
Works in
Excel Google Sheets

Looking for premium spreadsheet templates?

Our paid templates include advanced multi-sheet dashboards, native Excel charts, and ongoing updates.

View Premium Templates Browse All Essentials Templates

Private & secure

Your financial data stays on your device. We never see it.

Learn more →

Need help?

Check our guides or reach out with questions.

View FAQ →