Skip to content

Invoice spreadsheet

An invoice in a spreadsheet: line items, discount, tax, total due and due date worked out.

Invoice spreadsheet template, first page

Fill it in and preview

Invoice spreadsheet

An invoice in a spreadsheet. Enter who it is from and to, the invoice number and date, and one row for each item. The sheet multiplies quantity by price, applies a discount and tax, and shows the subtotal, the total due and the due date from your payment terms. Download it as Excel, OpenDocument, PDF or CSV.

Invoice

Invoice

Fill in the yellow cells. Amounts, discount, tax, the total and the due date are worked out.

From Kestrel Design Studio

Seller address 14 Harbour Lane, Dunmore, Ireland

Tax or VAT number IE 1234567T

Bill to Alder and Finch Ltd

Client address 9 Mill Road, Leeds, United Kingdom

Invoice number 2027-0042

Invoice date 2027-04-12

Payment terms in days 30

Currency EUR

Tax rate (%) 21.00

Discount (%) 5.00

Due date 2027-05-12

Description Quantity Unit price Amount
Brand identity design, 3 concepts 1 2,400.00 2,400.00
Logo files and usage guide 1 450.00 450.00
Extra revision rounds (hours) 6 85.00 510.00
Business card layout 2 120.00 240.00
Subtotal 3,600.00
Discount -180.00
Amount before tax 3,420.00
Tax 718.20
Total due 4,138.20
Payment details IBAN IE00 BANK 0000 0000 0000 00, reference 2027-0042
Notes Thank you for your business. Late payment may be charged as the contract says.

Open this spreadsheet in nerixA preview of the first rows with sample figures. Open it in nerix to fill in your own and change any cell.

Templates are a careful starting point, not legal advice. Where the law matters, check what applies where you are.

Finance and accounting

What this template is for

An invoice template for Excel: add your details and line items, and the amounts, discount, tax, total due and due date are calculated for you. Free.

It is free to fill in online, needs no account, and downloads as a Word document or a PDF. See all Finance and accounting templates All free Excel and spreadsheet templates

Finance and accounting

What you fill in

The form asks for 14 details. The document fills itself in as you type.

  • From (your business)

    For example: Kestrel Design Studio

  • Your address

    For example: 14 Harbour Lane, Dunmore, Ireland

  • Your tax or VAT numberoptional

    For example: IE 1234567T

  • Bill to

    For example: Alder and Finch Ltd

  • Client address

    For example: 9 Mill Road, Leeds, United Kingdom

  • Invoice number

    For example: 2027-0042

  • Invoice date

    For example: 2027-04-12

  • Payment terms in days

    Days after the invoice date by which payment is due.

    For example: 30

  • Currency

    For example: EUR

  • Tax rate (%)optional

    Leave empty if you charge no tax.

    For example: 21

  • Discount (%)optional

    For example: 5

  • Items

    One row for each product or service.

  • Payment detailsoptional

    Bank account, payment link or how to pay.

    For example: IBAN IE00 BANK 0000 0000 0000 00, reference 2027-0042

  • Notesoptional

    For example: Thank you for your business.

Finance and accounting

What is inside

The parts of this document, in order.

  1. 1An invoice in a spreadsheet. Enter who it is from and to, the invoice number and date, and one row for each item. The...

Templates

How it works

  1. 01

    Open

    Open the spreadsheet in nerix and fill in the short form. Your answers go straight into its cells.

  2. 02

    Change

    Every figure is a live formula. Change any cell and the totals, differences and charts work themselves out.

  3. 03

    Download

    Save it as an Excel file, an OpenDocument sheet, a PDF or CSV.

Make it yours with AI

Open it in the chat and ask for changes: shorter, firmer, another situation, another language.

Adapt it with nerix

Finance and accounting

Questions people ask

What details does this template ask for?

The form asks for 14 details, starting with From, Your address, Bill to, Client address, Invoice number. 5 more are optional.

Can I download this template as Word or PDF?

Yes. Open it in nerix and the finished spreadsheet downloads as Excel, OpenDocument, PDF or CSV. It is free and the page only shows sample figures.

Is what I type sent anywhere?

No. What you type stays in your browser while you fill in the document. It only goes to nerix if you choose to open the template in the chat.

What should I check before I use this template?

Invoice rules differ by country: some require a tax number, a sequential number or specific wording. Check what yours require. Tax is calculated at one rate for all lines.

Are these finance templates free?

Most are. Fill in and download them for free as Word or PDF, with no account. A few longer documents are premium: free to fill in, paid once to download, and marked with their price.

Do these templates include tax rules?

No. Tax and invoicing rules differ by country. Each template has fields for amounts and references, and you add the tax details your local rules require.

Can I use them with my accounting software?

Yes. They are plain documents. Download the Word version, or copy the figures into your software.