Small business owners, shopkeepers and freelancers often need a clear way to request payment and record what they have sold. A simple invoice template can help organise the details, reduce avoidable mistakes and make follow-up easier.
This guide explains what to include in an invoice, how to create one in Excel or Google Sheets, and what to check before sending it to a customer.
What is an invoice?
An invoice is a document that records the goods or services supplied, the amount due and the payment terms. It is different from a quotation: a quotation estimates the price before work begins, while an invoice usually requests payment for goods or services supplied.
What should a small business invoice include?
- Your business name and contact details
- A unique invoice number
- Invoice date and payment due date
- Customer name and relevant contact details
- Clear descriptions of products or services
- Quantity, rate and line amount
- Subtotal, discount and applicable tax where relevant
- Total amount due and payment instructions
- Payment terms and any useful notes
How to make an invoice template in Excel
- Create a new workbook and add your business details at the top.
- Make columns for item description, quantity, rate and amount.
- For each line, multiply quantity by rate. If quantity is in B8 and rate is in C8, enter
=B8*C8in the amount cell. - Use
=SUM(D8:D17)to total the line amounts, adjusting the range to fit your sheet. - Add clearly labelled cells for discounts, taxes if applicable, and the final amount due.
- Save a clean master copy, then create a separate copy for each invoice.
- Export the completed invoice as a PDF before sending it if a fixed layout is useful.
Invoice template checklist
Before sending an invoice, check the customer name, invoice number, dates, descriptions, arithmetic, payment details and applicable tax information. Keep a copy of the invoice and supporting records. Use a consistent numbering method so invoices are easier to find later.
Common mistakes to avoid
- Reusing the same invoice number for different invoices.
- Sending an invoice with missing customer or payment details.
- Forgetting to check formulas after adding or removing rows.
- Mixing personal and business expenses or records.
- Assuming a generic template automatically meets every country’s legal or tax requirements.
Invoice vs quotation: what is the difference?
A quotation gives a customer an estimated price and scope before the work is accepted. An invoice records a payment request for supplied goods or services. Some businesses use both: first a quotation, then an invoice when payment becomes due.
Frequently asked questions
Can I make invoices in Excel or Google Sheets?
Yes. Both can be used to create a basic editable invoice template. Review calculations and export or print the final document in a format your customer can open.
Should I add tax to every invoice?
Tax treatment depends on your location, registration status, transaction and applicable rules. Confirm requirements with an appropriate tax professional or official authority instead of copying a tax rate from a generic template.
Is a spreadsheet invoice template accounting software?
No. A spreadsheet can help create documents and organise records, but it does not replace accounting software or professional advice where those are needed.
Final thoughts
A clear invoice template is a practical first step toward better business record-keeping. Keep the layout simple, check every total and maintain copies of invoices and receipts. For routine tracking, an invoice can also be paired with an expense tracker and a customer follow-up sheet.
Disclaimer: This article is for general educational purposes only and is not legal, tax or accounting advice. Verify local invoicing and tax requirements before using a template for business transactions.