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 Freelancer Invoice Spreadsheet Template for Google Sheets & Excel

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.

Instant digital delivery · Terms & Conditions apply

Essentials Freelancer Invoice spreadsheet template - Google Sheets and Excel preview

What's Included

  • A description, an amount and a status on every milestone
  • A Complete or Pending dropdown on every milestone
  • An invoice that bills only the milestones marked complete
  • The whole engagement totalled separately, so both figures are visible
  • A deposit already paid, taken off after the tax
  • A tax rate you set, applied to what is being billed
  • The project named, with a contract reference in the invoice details
  • The client recorded by name, company, address and email
  • A payment instructions block and a notes and terms block
  • A currency dropdown beside the title that relabels the money columns
  • Works in Microsoft Excel and Google Sheets with no setup required
  • A check that flags a milestone left without a status, so nothing is silently unbilled

The FinancialAha Essentials Freelancer 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 Freelancer Invoice Excel template and an Essentials Freelancer Invoice Google Sheets template from the same download. Eight milestones, each marked complete or pending, with the invoice billing what is done and taking off the deposit already paid. No macros, no VBA.

Inside the workbook

What's inside the FinancialAha Essentials Freelancer Invoice spreadsheet template

The FinancialAha Essentials Freelancer 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 Freelancer 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, which here include a contract reference and, on its own line, the project. Freelance work is agreed in writing more often than it is remembered accurately, and a contract reference on the invoice is what settles a scope question without a search. Eight milestones follow, each with a description, an amount, and a status picked from a dropdown: complete or pending. Beneath them the whole engagement is totalled, which is the number the client agreed to overall. The summary underneath bills something narrower, and this is the part that matters. It adds up only the milestones marked complete, applies the tax rate to that, and takes off any deposit already paid. What is left is the balance due. Marking a milestone pending keeps it in the project total and off this invoice - which is the whole point of billing by stage, and the thing that makes a mid-project invoice defensible. A check sits beside that subtotal. If the completed and pending amounts do not add up to the project total, something has been left without a status, and the sheet says so rather than quietly billing less than it should. Underneath sit payment instructions and a notes and terms block, which is where deposit terms, revision scope and when the work becomes the client's belong.

    FinancialAha Freelancer Invoice spreadsheet template - Invoice sheet

  2. Included guide

    How to Use

    A step-by-step guide on its own tab, covering what the status dropdown drives, how the balance summary reaches the amount due, 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 Freelancer Invoice Spreadsheet template for Google Sheets

Upload the Essentials Freelancer Invoice Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Essentials Freelancer Invoice Google Sheets template needs no conversion step, the status dropdown comes across as a Sheets dropdown, and the totals recalculate exactly as they do in Excel.

Essentials Freelancer Invoice Google Sheets template setup

A copy of the Essentials Freelancer Invoice Google Sheets template per project keeps one engagement's milestones out of another's, and the same file can be reissued as stages complete.

Running the Essentials Freelancer Invoice Google Sheets template

The Essentials Freelancer Invoice Google Sheet is reissued rather than rewritten. Flipping a milestone from pending to complete is what moves it onto the next invoice.

Essentials Freelancer Invoice Spreadsheet template for Excel

The Essentials Freelancer Invoice spreadsheet Excel download is a plain .xlsx. Excel opens this Essentials Freelancer 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 Freelancer Invoice Excel template setup

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

Essentials Freelancer Invoice spreadsheet template notes for Excel

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

Opening the Essentials Freelancer Invoice spreadsheet Excel file

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

Spreadsheet template highlights

What the Essentials Freelancer Invoice spreadsheet template tracks

A row per milestone. This is what the Essentials Freelancer Invoice Spreadsheet Template records for each:

Description
the deliverable, named the way the contract names it
Amount auto
what that stage is worth, typed rather than derived from a rate
Status
complete or pending, from a dropdown, and what decides whether the stage is billed on this invoice

Compare builds

FinancialAha Freelancer Invoice spreadsheet template: Free and Essentials compared

Feature Free View Spreadsheet Template Essentials This page
Working sheets 1 1
Billable lines 7 8 milestones
Priced by Quantity and rate A milestone amount
Delivered / not delivered per line – A Complete or Pending dropdown
Bills only what is delivered – Yes
Deposit already paid – Its own field
Project and contract reference – Yes
Client recorded Name and address Name, company, address and email
Payment instructions – Yes
Notes and terms block – Yes
Charts – –

The Free Freelancer Invoice Spreadsheet Template bills stages and hours together on the same lines. The FinancialAha Essentials Freelancer Invoice Spreadsheet Template is built around milestones instead: eight of them, each marked complete or pending from a dropdown, with the invoice billing only what is marked complete, a deposit already paid taken off, and the project and contract named on the document.

Compare the other builds: Free Freelancer Invoice spreadsheet template .

Good to know

Notes on working in the Essentials Freelancer Invoice spreadsheet template

  • The status dropdown is what decides the bill. Pending keeps a stage in the project total and off this invoice.
  • The project total and the amount billed are shown apart, so a client sees both what was agreed and what is being asked for.
  • The deposit comes off after the tax, because it is money already received rather than a reduction in the price.
  • A contract reference on the invoice settles a scope question without a search.
  • Milestone amounts are typed rather than worked out from a rate, which is what fixed-fee work means.
  • 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 Freelancer Invoice Spreadsheet Template

1

Name the project

The project line, plus a contract reference in the details.

2

List the milestones

List the milestones a row each, with a description and an amount.

3

Mark what is done

Complete or pending, from the dropdown on each row.

4

Read the balance due

Completed work, plus tax, less the deposit paid.

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 Freelancer Invoice Spreadsheet Template a Google Sheets template?

Yes. Upload the file to Drive and choose "Open with Google Sheets". The Essentials Freelancer Invoice Google Sheets template needs no conversion step and the status dropdown comes across as a Sheets dropdown.

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

Yes. The download is a plain .xlsx, so the Essentials Freelancer 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 Freelancer Invoice spreadsheet Excel file open in older versions of Excel?

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

What does the status dropdown do in the Essentials Freelancer Invoice spreadsheet?

It decides what gets billed. The balance summary adds up only the milestones marked complete, so marking one pending keeps it in the project total and off this invoice.

Why does the Essentials Freelancer Invoice spreadsheet show the project total as well as the amount billed?

Because a client reading a mid-project invoice wants both: what was agreed overall, and what is being asked for now. Showing only one of the two invites the question.

Where does the deposit come off in the Essentials Freelancer Invoice spreadsheet?

After the tax. A deposit is money already received rather than a reduction in the price, so it comes off the total rather than the taxable amount.

Can I add milestones to the Essentials Freelancer Invoice spreadsheet?

A row per milestone, and you can right-click inside the table and choose Insert when a project needs another - the total expands to include it. The Free Freelancer Invoice bills whatever you put on its lines rather than tracking a status.

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

No. This is the document you send, reissued as stages complete. Following which of them have been paid is what an invoice tracker is for.

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

Simple Invoice

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.

$19

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
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 →