Invoices templates built in a spreadsheet do more than look neat: they calculate totals, taxes and due dates, and they let you track many bills in one place. If you send several invoices every month, a sheet-based system is easy to set up and costs nothing.
Invoices templates: one sheet or a whole workbook?
A simple approach uses two tabs. The first holds the printable invoice. The second is a log with one row per invoice: number, client, date, amount, status. When you issue an invoice, copy the key facts to the log. Over time, this log answers questions like who owes money and which month was busiest.
For the layout of the document itself, see invoice templates, which lists the fields to include.
Building the invoice tab
Start with a header area for your business and the client. Below, create a table with columns for description, quantity, unit price and line total. In the line total cell use a formula that multiplies quantity by price. At the bottom, add the subtotal with SUM, a tax line that multiplies the subtotal by your rate, and a total.
Handy formulas
- Line total: quantity times unit price.
- Subtotal: sum of line totals.
- Tax: subtotal times the tax rate stored in one cell.
- Due date: issue date plus payment days.
Put the tax rate and payment days in separate labelled cells so you only change them in one place.
Making the invoice log useful
Add a status column with a dropdown: Draft, Sent, Paid, Overdue. Apply conditional formatting so overdue rows turn red. A formula can compare today’s date with the due date and the status, so overdue items highlight themselves. Add a monthly summary with SUMIFS to see income per month.
Protect your formulas
Lock cells containing formulas so a stray click does not break them. In Google Sheets use protected ranges; in Excel use Protect Sheet. Keep an unprotected copy for yourself as a backup.
Exporting and sending
Print or save as PDF. Check that the page fits within the margins and that the totals appear on the first page. Name files consistently, for example “2026-014-ClientName.pdf”. For more on spreadsheets in general, read Google spreadsheet templates.
Limits of a spreadsheet system
Sheets are manual. You must remember to follow up, and it is easy to duplicate a number. If you issue dozens of invoices every week, consider dedicated software that sends reminders and accepts payments. Until then, a good sheet is dependable and flexible.
Good habits
- Back up the file weekly.
- Never edit a sent invoice; issue a correction.
- Record payments the day they arrive.
- Reconcile with your bank statement monthly.
These habits fit neatly with the routines in small business bookkeeping basics.
Currency and tax variations
If you bill in more than one currency, add a currency cell and show the exchange rate you used. For businesses that charge different tax rates, add a tax-rate column per line. Always follow local tax rules.
Starting from scratch: a five-minute checklist
Open a new sheet and name the first tab “Invoice”. Type your business details in the top left, a client block on the right and the table below. Format currency cells properly. Name the second tab “Log”. Create headings for number, date, client, amount, status and payment date. Save the file as your master copy and make a duplicate for daily use.
Tracking late payers
Add a column that calculates days overdue. Sort by it every Friday and send reminders to anyone beyond the due date. A short, friendly reminder usually works; if it does not, escalate with a firmer note. Keeping a log of reminders protects you if a dispute arises later.
Year-end review
At the end of the year, filter the log by client and see who brought the most revenue and who paid slowest. Those facts guide pricing and the clients you want more of.
Backing up and migrating
Download a copy of the workbook every month, and store it in a different location from the original. If you later move to invoicing software, the log you built exports cleanly as a CSV, so your history comes with you. A tidy sheet today is a smooth migration tomorrow.
Using tabs for each client
Larger operations sometimes keep a separate tab for each major client, listing every invoice and payment. A master tab then pulls the totals with simple formulas. This setup gives a clear view of balances and eases conversations about overdue amounts, because everything is visible in a single row.
Printing tips
Set the print area to the invoice section, adjust the margins and choose “fit to one page wide”. Check the preview, because a stray column can create a second page. Save a PDF copy for your records every time.
Frequently asked questions
Is Excel or Google Sheets better?
Both work. Sheets is easier to share, Excel handles heavy calculations better.
Can I add my logo?
Yes. Insert it as an image in the header area.
How do I stop duplicate numbers?
Use a formula that takes the highest number in the log and adds one.
Google Sheet Templates: Pick One and Make It Yours
Most people meet a spreadsheet problem on a Tuesday afternoon: a budget that needs building, a rota that…
Planner Templates: Pick One You’ll Use and Keep the Habit
A planner is only useful if you open it. That sounds obvious, but most abandoned planners fail for…
OneNote Templates: Create, Apply and Fix Page Layouts Fast
OneNote is generous with space and short on structure. You get an endless canvas, which is wonderful until…
Notion Templates Free: 5 Worth Duplicating and How to Use
Paid template packs get all the attention, but you can run a very capable workspace on free Notion…




