How to use it in Microsoft Excel
- 1
Download the .xlsx file and open it in Excel. Click Enable Editing if Excel asks.
- 2
Type your business details and the client’s into the header cells.
- 3
Enter a description, unit cost, and quantity on each row. The Amount column fills itself in.
- 4
Type your tax rate in the Tax Rate cell. Subtotal, Tax, and Invoice Total update automatically.
- 5
Insert extra rows inside the item block if you need them, then copy an Amount formula down.
- 6
Choose File, Save As, PDF to create the copy you send.
Why the taxes stay separate
Authorities that levy more than one tax generally require each to be shown with its own rate and amount, and a bookkeeper will reject an invoice that rolls them together. Here each tax is calculated independently on the subtotal. Rename the labels to GST, PST, HST, VAT, or whatever applies.
Compounding and exemptions
By default the second tax does not compound on the first. If your region requires it, edit the Tax 2 formula to multiply by the subtotal plus Tax 1. If one tax does not apply to a client, set its rate to 0% and the line shows zero.
Tips
- Rename Tax 1 and Tax 2 to the names your clients expect.
- Keep both registration numbers in the header.
- Check the rates each year; provincial and local rates change.
Questions about this template
Can I make Tax 2 compound on Tax 1?
Yes. Change the Tax 2 formula to multiply its rate by the subtotal plus the Tax 1 amount.
What if some items are exempt from one tax?
Add a Taxable column as in the Itemized Excel Invoice, or split the invoice.
Does it work in Google Sheets?
Yes, and our Google Sheets Multi-Tax Invoice is the same design.
