Excel Invoice Template
If you enter values into the 'Product ID', 'Description', 'Quantity' and 'Unit Price' columns of the above invoice template, the 'Row Total', 'Subtotal', 'Tax' and 'Total' fields are automatically calculated.
Some of the cells in the spreadsheet have been locked, to prevent you from accidentally overwriting the formulas in these cells. However, if you wish to have more control over the spreadsheet, you can unlock it by:
In Excel 2003:
In Excel 2007 - 2013:
The Excel functions and operators used in the above Invoice Template are:
The multiplication operator is used to multiply the quantity with the individual item price,
to calculate each total of each row in the invoice.
The multiplication operator is also used to calculate the Tax.
|If function||Used to keep the 'Row Total' column of the invoice tidy. If no value is present in the corresponding cell of the 'Quantity' column, the entry in the 'Row Total' column remains blank. Otherwise, the row total is calculated and displayed.|
|Isnumber function||Used to check if a numeric value is present in the 'Quantity' column of the Invoice.|
|SUM function||Used to calculate the Invoice Subtotal before Tax and the final Invoice Total.|