Free invoice template for Excel

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

1. Fill in your business and customer details once, then save a copy as your master.
2. Give each invoice the next number in your sequence and set the date and terms.
3. Enter the lines. Delete the two example lines first.
4. 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

1. Open Google Sheets and choose File, then Import, then Upload, and pick the downloaded file.
2. Choose "Replace spreadsheet" or "Insert new sheet(s)".
3. 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

Want a fuller version with worked examples? See Client Agreement Pack in the store. This free template stays free either way.

Want more than a template? See Freelancer Income Tracker.

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

Related: Free invoice generator (in your browser), Days sales outstanding calculator, Bookkeeping guides, or all free 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.