Apple Numbers Invoice Template: Build One on Your Mac

Quick answer: An Apple Numbers invoice template is a Numbers spreadsheet set up with your business details, a line items table and formulas that calculate the subtotal, tax and total. Numbers is free on every Mac, includes ready-made invoice templates, and exports to PDF in a few clicks. It suits freelancers who want a calculating invoice without paying for software.

If you work on a Mac, you already own a capable invoicing tool. Numbers comes free with macOS, iPadOS and iOS, and it handles the maths that a word processor cannot. This guide covers how to make an invoice on a Mac with Numbers: using the built-in template, building your own from scratch with the right formulas, numbering, exporting a PDF, and knowing when a different tool would save you time.

Why use an Apple Numbers invoice template?

Numbers sits between a design tool and a heavy spreadsheet. Unlike Excel, each sheet is a freeform canvas: tables, text boxes and images can sit anywhere, which makes an invoice layout easier to arrange. Unlike a Pages or Word document, the line items table calculates.

Feature	Numbers	Excel	Google Sheets
Cost	Free on Apple devices	Paid (Microsoft 365) or limited web version	Free with a Google account
Built-in invoice templates	Yes	Yes	Yes, in the template gallery
Layout flexibility	High: freeform canvas	Grid based	Grid based
Works on Windows	Only via iCloud.com in a browser	Yes	Yes, in a browser
PDF export	Yes	Yes	Yes

If you also use other platforms, compare this with our guides on how to make an invoice in Excel and the Google Sheets invoice template. The formulas are almost identical across all three.

Option 1: Use the built-in invoice template

The quickest route is the template that ships with Numbers.

1. Open Numbers and choose File, then New. The template chooser opens.
2. Scroll to the business templates and select an invoice design. The exact names and styles vary by version, so pick the one that looks closest to what you need.
3. Replace the placeholder company name, address and logo with your own. To swap the logo, drag your image file onto the placeholder image.
4. Delete the sample line items and type your own. The totals update automatically.
5. Check the tax cell. Many templates include a sample tax rate that will not match your rate, or you may not need tax at all.
6. Save it as your own template: File, then Save as Template. It will appear in the chooser under My Templates.

The built-in template is a good starting point, but read every formula before trusting it. Templates are designed to look good in a demo, not to match your country's tax rules.

Option 2: Build your own Apple Numbers invoice template

Building your own takes about 20 minutes and gives you a layout you fully understand. Start with a blank sheet and delete the default table.

The header

Add a text box at the top left with your business name, address, email, phone and any tax registration number. Put your logo at the top right. Below it, add the word Invoice in a large font, followed by small text boxes or a two-column table for the invoice number, issue date, due date and, if the client uses one, their PO number.

The client block

Add a text box titled Bill To for the client's legal name, contact name and billing address. If the client is VAT or GST registered and your rules require it, add their tax number here too.

The line items table

Insert a table with four columns: Description, Qty, Rate and Amount. Make the first row a header row. Ten body rows are enough for most invoices; you can add more when needed. Set the Qty column to number format and the Rate and Amount columns to currency format using the Format sidebar.

The totals table

Add a small two-column table below and to the right of the line items with rows for Subtotal, Discount, Tax and Total Due. Keeping totals in their own table makes the layout cleaner and stops them moving when you add line items.

Payment details and terms

Below the totals, add a text box with how to pay: bank name, account name, account number or IBAN, sort code or routing number where relevant, and any payment link you use. State your terms in plain words, such as Payment due within 14 days, and mention any late fee only if your contract allows it. A short thank-you line and a reference instruction (Please quote the invoice number with your payment) make reconciliation easier for both sides.

Make the template easy to reuse

Shade the cells you change each time, such as client, dates and line items, in a light colour, and leave formula cells unshaded. When you or anyone else opens the Apple Numbers invoice template later, it is obvious what to fill in and what to leave alone. Remove the shading before export, or choose a colour subtle enough that it prints cleanly. Keep fonts to one or two families and use the same accent colour as your logo for headings.

The formulas you need

To enter a formula in Numbers, click a cell and type the equals sign. Numbers lets you click cells to insert references, and it shows references across tables by table name. The examples below assume the line items table is called Items with data in rows 2 to 11, and the totals table is called Totals.

Cell	Formula	What it does
Amount (row 2)	=B2*C2	Quantity times rate; fill down to row 11
Subtotal	=SUM(Items::D2:D11)	Adds every line amount
Discount	Typed value, for example 100	A fixed reduction before tax
Tax	=ROUND((B1-B2)*0.2,2)	20% tax on the discounted subtotal, rounded
Total Due	=B1-B2+B3	Subtotal minus discount plus tax

In the Totals table, B1 is the subtotal, B2 the discount and B3 the tax. Replace 0.2 with your own rate, or put the rate in its own cell and reference it so you can change it in one place. For the due date, add a duration to the issue date, for example =C2+DURATION(0,30) if your issue date sits in cell C2 of the header table, then format the result as a date. DURATION takes weeks first and days second, so (0,30) means 30 days.

To stop empty rows showing 0.00 in the Amount column, use =IF(B2="","",B2*C2). The line stays blank until you enter a quantity.

Worked example

A photographer invoices a client for a half-day shoot:

Description	Qty	Rate	Amount
Half-day shoot	1	450.00	450.00
Edited images	25	12.00	300.00
Travel	1	40.00	40.00

The subtotal is 790.00. After a 40.00 loyalty discount, the taxable amount is 750.00. At 20%, the tax is 150.00 and the total due is 900.00. Before you rely on the template, test it with figures you have worked out by hand like this. The sales tax calculator is a quick way to double-check tax amounts.

Numbering and record keeping

Each Numbers invoice is usually its own file, so nothing links them together. That means numbering is your job. A simple system works:

• Add a second sheet called Log to your template file, or keep a separate log spreadsheet, with columns for invoice number, client, date, total, due date and paid date.
• Before creating an invoice, take the next number from the log and record the new entry straight away.
• Use a clear format such as INV-2026-001. The invoice number generator can help you pick a consistent pattern.
• Name each file with the number and client, for example INV-2026-014 Acme.numbers, and the PDF the same way.
• Never delete an issued invoice. If it is wrong, cancel it and issue a corrected one following your local rules.

Duplicating last month's file is the fastest way to start a new invoice, and also the fastest way to send a client someone else's line items. Always start from your saved template instead.

Exporting a clean PDF

Clients should always get a PDF, not the .numbers file. Before exporting, open the Document sidebar and turn on page view (Print Setup in some versions) so you can see where the page edges fall. Drag the content to fit inside one page, and use the scale slider if needed.

1. Choose File, then Export To, then PDF.
2. Choose Best image quality if you have a logo.
3. Click Next, name the file with the invoice number, and save.
4. Open the PDF in Preview and check the totals, dates and client name.

Our invoice PDF and print checklist walks through the final checks. If you prefer documents to spreadsheets, the steps for making an invoice in Word translate closely to Pages, but you will have to calculate totals yourself.

Using Numbers on iPhone and iPad

Because Numbers syncs through iCloud Drive, you can build the template on your Mac and complete invoices from an iPhone or iPad. Keep input cells clearly labelled and lock or avoid editing the formula cells. Small screens make it easy to overtype a formula, so check totals on the exported PDF every time. For more ideas, see our guide to making an invoice on your phone.

Limits of a Numbers invoice

An Apple Numbers invoice template is a solid choice for a freelancer sending a few invoices a month. Its limits show up as you grow:

• Every file is separate, so reporting on unpaid invoices means maintaining a log by hand.
• There is no sending, reminders or payment tracking.
• Formulas can be broken by an accidental keystroke, and you may not notice.
• Sharing editable files with Windows users is awkward.
• Layout must be checked on every export, especially when line items grow.

If you like the look of other approaches, compare it with a Notion invoice template, which links invoices to clients and projects but has weaker layout control.

A faster alternative for Mac users

If you mainly want a professional PDF with correct totals, the free invoice generator runs in Safari or any browser on your Mac. You enter your details and line items; it calculates the subtotal, one tax rate, a percentage or fixed discount applied before tax, a shipping or extra charge, amount paid and balance due. You can add a logo and signature, choose a currency and pick a design such as the minimal invoice template. Drafts stay in your browser, and the PDF is generated on your device. It does not send emails or track payments, so keep your log sheet in Numbers for that.

Conclusion

An Apple Numbers invoice template gives Mac users a free invoice that calculates its own totals. Start from the built-in template or build your own with a line items table, SUM for the subtotal and ROUND for tax, then save it as a custom template. Keep a log for numbering, export a PDF for every invoice, and check it before sending. When you want a polished PDF without maintaining formulas, use the free invoice generator instead.