Invoice template for Excel users

Excel invoice templates calculate, but somebody has to build the formulas, guard them against edits and keep a copy for every client. Download the .xlsx file below with all formulas ready, or use the same template in the free generator with none of the upkeep.

Quantities multiply, discounts apply before VAT, and Nigeria's 7.5% VAT is one toggle. Both options are free with no signup.

Download Excel file (XLSX)

Why use this instead of an Excel template?

Excel works until a formula gets overwritten, a row is inserted in the wrong place, or the file is opened in a different app that breaks the layout. Those silent errors end up on the invoice your client sees.

Here the structure is fixed and the maths cannot be broken by editing. You get the calculation power of a spreadsheet with the polish of a finished document.

How to use this Excel-style template

Add a row per item with quantity and unit price, choose a percentage or fixed discount, toggle VAT on, and the subtotal, tax and amount due update live. Add your bank details once and they stay saved in your browser.

Prefer the full generator?

This template runs on the free invoice generator, alongside the proforma invoice generator and receipt generator. Browse all invoice templates.

Your logo

Chinedu Electronics

Invoice

INV-0001

Issued 23 October 2026

Due 6 November 2026

Billed to

Obi Stores Ltd

Payment terms

Payment due within 14 days

  • Standing fan, 18 inch rechargeable

    10 × ₦85,000.00₦850,000.00

  • LED bulbs, 20W (pack of 6)

    25 × ₦12,000.00₦300,000.00
Subtotal₦1,150,000.00
Discount (5%)− ₦57,500.00
VAT (7.5%)₦81,937.50
Amount due₦1,174,437.50

Pay to

Chinedu Electronics

First Bank

203XXXXXXX

Notes

Thank you for your business.

Live sample. Your entries replace it.

Download Excel file

More free templates

Word-style invoice template

A clean document-style invoice, without opening Word.

View template →

PDF invoice template

Print-ready and pixel-perfect on every device.

View template →

Simple invoice template

The fewest fields that still make a proper invoice.

View template →

Excel-style invoice template questions

What Nigerians ask about the excel-style invoice template.

How do I create an invoice template in Excel?

Build a table with columns for description, quantity, unit price and amount, then add SUM formulas, a discount row and a 7.5% VAT row. It works, but every new invoice risks breaking a formula, which is why a tool that calculates for you is safer.

Where is the invoice template in Excel?

Open Excel, choose New, and search for invoice in the template gallery. Microsoft offers a few free ones. They still need your prices, VAT logic and bank details added by hand.

Is Excel or this tool better for invoices?

Excel is better if you already run your whole business in spreadsheets. For invoicing alone, this tool is faster: no formulas to maintain, automatic VAT, Nigerian bank details built in, and a PDF your client can open anywhere.

Can I download this template as an Excel file?

Yes. Press Download Excel file above for a real .xlsx invoice with live formulas: amounts, subtotal, discount, 7.5% VAT and total all recalculate when you edit quantities and prices. Change the rate cells to match your own VAT or WHT.

Does it handle discounts and VAT together?

Yes. Discounts apply first, then 7.5% VAT is charged on the discounted subtotal, which is the correct order.

Is this Excel-style template free?

Yes. No signup, no payment and no watermark. The invoice shows only what you type.