---
title: "Free Invoice Template (Excel): Download and Edit | MCC"
description: "A free one-page invoice template for Excel and Google Sheets. It works out the due date, discount, sales tax and balance for you. No sign-up."
url: "https://mcc-solutionsnj.com/bookkeeping/templates/invoice-template"
---

Free template

# Free invoice template for Excel

One clean page you can print or save as a PDF. Type your lines, and the due date, subtotal, tax and balance work themselves out.

[![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.png)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)

Keeping your own books? Tallyfinch does invoices, bank import and reports on your computer. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software)

[Download the Excel file](/downloads/templates/invoice-template.xlsx)Free. No sign-up. Excel file (.xlsx), 8 KB. Works in Google Sheets too.

## What is inside

- **Your details and the customer's** Business name, address, contact and the bill-to block.
- **Invoice number, date and terms** Enter the date and the number of days allowed, and the due date calculates.
- **Ten line items** Description, quantity or hours, and rate. Each line multiplies for you.
- **Discount, sales tax and payments** A discount percent, a sales tax percent you set yourself, and an amount already paid, leading to the balance due.

## How to use it

- Fill in your business and customer details once, then save a copy as your master.
- Give each invoice the next number in your sequence and set the date and terms.
- Enter the lines. Delete the two example lines first.
- Print to PDF and send. Record the invoice in your books the same day, and mark it paid when the money arrives.

## Using it in Google Sheets

- Open Google Sheets and choose File, then Import, then Upload, and pick the downloaded file.
- Choose "Replace spreadsheet" or "Insert new sheet(s)".
- Check the formulas and the dropdown lists after the import. Most carry over, but Google Sheets handles a few functions and formats differently.

## Things to watch

- **Number invoices in order.** Gaps and repeats make it hard to tell which invoices are paid. Keep one master list.
- **Say when payment is due.** A due date on the invoice is the easiest way to collect on time. Terms of 15 or 30 days are common choices, and the choice is yours.
- **Set sales tax yourself.** Leave the rate at 0 if you do not charge it. Which sales are taxable is decided by the NJ Division of Taxation, not by the template.
- **Match it to your books.** Every invoice you send should appear in your accounting records once, in the month you earned it.

## Questions

**Is the invoice template free?**

Yes. It downloads straight away, with no sign-up. Use it for your business as often as you like.

**Can I use it in Google Sheets?**

Yes. Upload the file to Google Sheets and check the formulas after the import.

**Do I have to charge sales tax?**

It depends on what you sell and where. The template has a tax percent you can leave at 0. Ask the NJ Division of Taxation or your CPA what applies to you.

**How do I get paid faster?**

State the due date, how to pay and who to contact. Send the invoice the day the work is done, and follow up politely a few days after it is due.

Want a fuller version with worked examples? See [Client Agreement Pack](/toolkits/client-agreement-pack) in the store. This free template stays free either way.

Want more than a template? See [Freelancer Income Tracker](/toolkits/freelancer-income-tracker).

Want every toolkit? The [toolkit membership](/membership) includes all of them, with a lower rate if you pay yearly.

Related: [Free invoice generator (in your browser)](/bookkeeping/free-invoice-generator), [Days sales outstanding calculator](/bookkeeping/days-sales-outstanding-calculator), [Bookkeeping guides](/bookkeeping/guides), or [all free templates](/bookkeeping/templates).

These templates track your own numbers. They are not tax, legal or accounting advice, and MCC Solutions is not a CPA firm. Ask your CPA how rules apply to you.

Tallyfinch

### Books you keep on your own computer

Tallyfinch does invoices, bills, bank import, reconciliation and the main reports, in a file you own. $99 once, then $5 a month for updates; the app keeps working if you stop the plan. It does not do payroll or sales tax filing. The free download records up to 60 entries.

[See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) [Download it free](/tools/pro/trial/mccBooks) [Compare the three apps](/software)

## Want the books handled for you?

[See bookkeeping](/bookkeeping/)[Call (908) 444-6373](tel:+19084446373)