Sending a clear, professional invoice is one of the simplest ways to get paid faster. Clients pay sooner when they can see right away what they owe, when it's due and how to pay. You don't need accounting software to do it well. A good template can handle almost all of it for you.
This guide covers what every small business invoice needs, the mistakes that slow down payment, and two free ways to make a professional invoice in minutes.
What to include on every invoice
Whether you're a designer, a cleaner, a consultant or a bakery, every invoice should show:
- Your business details: name, address, email and phone, plus your logo if you have one.
- Your client's details: the company name, the contact person and their address.
- A unique invoice number such as INV-1001, so you and your client can find it later. Never reuse a number.
- The invoice date and the due date. Spell out the actual due date (for example, "Due Nov 26, 2026"), not just "Net 15". People act on dates, not terms.
- Line items: what you did or sold, the quantity, the price and the line total.
- Subtotal, discounts, tax and shipping, then the total.
- The balance due, especially if the client has already paid a deposit.
- How to pay: bank transfer, Zelle, card, check, and who to make checks payable to.
- A short note, like "Thank you for your business!"
Common invoicing mistakes that delay payment
- Math errors. One wrong total and your client has to email you, and the clock restarts. Let formulas do the math.
- No due date. Without a clear date, your invoice drops to the bottom of the pile.
- Vague line items. "Services – $1,200" invites questions. "Logo design, 3 concepts and 2 revision rounds – $650" doesn't.
- Missing payment instructions. If paying you takes extra steps, people put it off.
- Losing track of who has paid. Without a simple log, overdue invoices slip through the cracks and you lose money you've already earned.
How to make an invoice in Excel (the fast way)
You can build an invoice from a blank sheet, but you'll spend more time formatting than billing. A good template should do the repetitive work for you. Here's the setup we recommend, and it's how our Excel invoice template works:
- Enter your business details once. Your name, address, payment instructions, tax rate and invoice number prefix live on a settings sheet, and every invoice pulls from it.
- Save your clients. Keep a simple client list. When you pick a client from a dropdown, their contact details fill in automatically.
- Save what you sell. List your products and services with their prices. Pick an item on the invoice and the description and price fill in.
- Choose your payment terms. Pick Net 15 or Net 30 and the due date calculates itself.
- Let the totals calculate. Subtotal, discount, tax, shipping, deposits and balance due update as you type.
- Save as PDF and send. Make sure it fits on one clean page.
- Log it. Record each invoice in a tracker so you can see at a glance what's paid, open and overdue.
Make a free invoice right now
Need an invoice today? Use the Template Palace Free Invoice Maker. Add your logo, type your details and line items, and download a polished PDF. The totals, tax and due date are calculated for you, and it runs in your browser, so nothing you type is uploaded or stored.
The free version includes a small "Free invoice by Template Palace" footer at the bottom.
Invoice often? Get the Excel version
If you send invoices every week, the Excel invoice template with tracker is $9 and has only your brand on it:
- Client and item dropdowns that fill in addresses, descriptions and prices
- An automatic due date from your payment terms
- Discounts, tax, shipping and deposits calculated for you
- A big Amount Due box that turns red when an invoice is overdue and shows a green PAID mark when you've been paid
- Invoice numbers that count up on their own
- A built-in tracker showing what you've invoiced, collected and are still owed
- One-page, print-ready layout. No macros, nothing to enable.
Next step: know where your money is going
Invoicing is how money comes in. To see the whole picture (revenue, expenses, profit and the next 13 weeks of cash), take a look at Business Clarity OS, our Excel dashboard and cash flow planner for small businesses. You can try the free demo first.