Free Excel template

Free Excel invoice template

Q: How do I calculate the due date in Excel?

Add the number of days to the invoice date, for example =D3+30. Excel treats dates as numbers, so the result is a real date you can format any way you like.

For freelancers and small businesses who need a clean invoice without paying for invoicing software. Enter your items and quantities; the template multiplies out each line, adds tax, subtracts what has been paid and works out the due date from your payment terms.

cellwise-invoice-template.xlsxExcel workbook · 4.2 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup

Download free template

Preview and try it

This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.

	A	B	C	D
1	INVOICE
2	Your Business Name		Invoice #	INV-1042
3	210 Market St, Suite 4, Portland, OR 97204		Invoice date	Nov 2, 2026
4	[email protected]		Terms (days)	30
5			Due date	46358
6	Bill to
7	Northwind Dental Group
8	450 Oak Ave, Riverside, CA 92501
9
10	Description	Qty	Unit price	Amount
11	Website redesign: homepage and 4 inner pages	1	2400	2400
12	Copywriting (hours)	6.5	85	552.5
13	Stock photo licenses	5	12.5	62.5
14	Hosting, November to December (months)	2	29	58
15
16
17
18	Notes		Subtotal	3073
19	Thank you for your business.		Tax rate	0.0825
20	Please include the invoice number with your payment.		Tax	253.52

How the formulas work

Line totals that stay blank on empty rows

D11=IF(B11="","",ROUND(B11*C11,2))

Quantity times unit price, rounded to cents so the printed lines always add up to the subtotal. If the Qty cell is empty, the formula returns an empty string instead of $0.00, so unused rows stay clean. SUM ignores those empty strings.

Due date from payment terms

D5=D3+D4

Excel stores dates as day numbers, so adding 30 to the invoice date gives the date 30 days later. Change the terms to 14 or 45 and the due date moves with it. If the result shows a number like 46358, format the cell as a date (Home > Number Format > Short Date).

Tax on the subtotal

D20=ROUND(D18*D19,2)

Subtotal times the tax rate in D19, rounded to cents. Type the rate as a percentage (8.25%) or a decimal (0.0825); both store the same value. If you do not charge tax, set D19 to 0. Which items are taxable depends on where you and your client are, so check your local rules.

A payment line that writes itself

A23=IF(D23<=0,"Paid in full","Please pay "&TEXT(D23,"$#,##0.00")&" by "&TEXT(D5,"mmm d, yyyy"))

TEXT turns the balance and the due date into formatted text so they can be joined into a sentence with &. Without TEXT, the date would appear as a plain number. Once the balance reaches zero it says Paid in full.

Make it yours

Need more lines? Insert rows between row 11 and row 16 and copy the Amount formula down. The Subtotal SUM range grows automatically when you insert inside it.
Give every invoice a unique number (INV-1042, INV-1043 ...) and save each one as its own file. File > Save As and pick PDF when you send it to a client.
Set the print area so the invoice fits on one page: select A1:D23, then Page Layout > Print Area > Set Print Area, and choose Fit Sheet on One Page in the print settings.
Add your logo with Insert > Pictures and drag it into the top right corner.

FAQ

How do I make an invoice in Excel?

List your items with a quantity and unit price, multiply them for each line, SUM the lines into a subtotal, then add tax and subtract payments. This template already has all of those formulas, so you only replace the sample details.

How do I calculate the due date in Excel?

Add the number of days to the invoice date, for example =D3+30. Excel treats dates as numbers, so the result is a real date you can format any way you like.

Can I turn the Excel invoice into a PDF?

Yes. Use File > Save As (or Export) and choose PDF. In Google Sheets, use File > Download > PDF.

Functions used

Related guides

More free templates

Updated November 2, 2026