What is the Excel Invoice With Live Totals for?
An Excel invoice where amounts, tax and the total calculate themselves.
Use it when quantities and prices change from one invoice to the next. It is a real .xlsx file, and the amounts, tax and total recalculate when you edit the quantities and prices.
What is in it?
An Excel invoice where amounts, tax and the total calculate themselves. DocFila creates it as a real Excel workbook (.xlsx) saved to your library, so you can edit it in the Workspace or in any spreadsheet app. The gallery tags it as live totals. It contains these parts:
- Invoice header and details
- Line items with quantity and unit price
- Amounts, tax and total with live formulas
What can I change before I create it?
When you create it you choose a colour (Graphite, Cobalt, Forest, Terracotta or Plum), a typeface (Editorial, Modern or Classic) and the paper (A4 or Letter), and you can switch on the option to fill in your name and contact details from your profile. Because the result is an ordinary file, everything else is yours to edit afterwards.
What does a filled-in Excel Invoice With Live Totals look like?
These are the lines the template starts with. You replace them with your own.
Description, Qty, Unit price, Amount
Discovery workshop, Design and documentation, Implementation support (hours)
Subtotal, VAT, Total due: formulas that update as you edit.
How do I fill it in and sign it in DocFila?
- Open the template gallery in DocFila Workspace (the Templates page, or Start from a template on the Workspace home) and open the Invoices & quotes group.
- Choose Invoice with live totals.
- Pick a colour, a typeface and the paper size, and switch on the option to fill in your name and contact details if you want them added.
- Choose Use this template. DocFila creates the workbook in your library and opens it.
- Replace the placeholder text with your own. When it is final, export a PDF, and send it for signature or sign it in DocFila if it needs a signature.
What should I check before I send it?
- Change only the cells for quantity, price and tax rate, and leave the formulas alone.
- Save a copy for each invoice, or keep a numbered tab.
- Export a PDF to send, so the client cannot change the numbers.
Overwriting a formula cell with a typed number silently stops that line from updating. If the totals look wrong, check that the amount cells still contain formulas.
What does DocFila cost?
Free, with no time limit and no card. Paid plans from $4.99 a month (Starter). Business for organizations: $24.99 per seat a month, from 2 seats. There is no free trial. The Free plan sends 3 documents for signature a month; Starter and every plan above it have no monthly limit. Signers need no account, and signing a document yourself is free on every plan. See plans and prices.
More in this category
Invoice template Receipt template Purchase order template Word Invoice Template Quote Template All invoices and quotes templates
For what an electronic signature is worth in your country, read the e-signature legality guides. Terms such as electronic signature are defined in the glossary.
Questions about the Excel Invoice With Live Totals
Do the totals update by themselves?
Yes. The invoice sheet uses live formulas, so the amounts, tax and total update when you change quantities and prices.
Can I sign this document electronically in DocFila?
Yes. DocFila signatures are simple electronic signatures with an audit trail: the signer consents to sign electronically and verifies with an emailed one-time code. A few documents, such as a notice that the law requires in handwriting, need more, so check the guide for your country.
Is this Excel Invoice With Live Totals legal advice?
No. It is a general template and general information, not legal advice. DocFila does not provide legal advice, and the document has not been reviewed for your jurisdiction or situation. For anything high-value or regulated, ask a qualified professional.
Related DocFila tools
Keep going with the document workflow that matches this page. Open the tool you need, then finish the file in DocFila.