- Document for Excel Invoice Manager
This version of the document, "Invoice Template for Engineering Services with Support for Change Order", was written for Excel Invoice Manager, which was now renamed to Uniform Invoice Software. For the latest version of this document, please download Uniform Invoice Software.
Invoice Template for Engineering Services with Support for Change Order was revised and published on InvoicingTemplate.com, at Engineering Invoice Template, in the service invoice template category, as both a free invoice template and a template that works with Uniform Invoice Software. Invoicing Templates also offers a variant of this invoice template that does not support change order and includes one default tax, at Architect Invoice Template - again, it includes two editions - one freeware edition and another edition that works with Uniform Invoice Software.
If you are looking for a custom build of Uniform Invoice Software that integrates Invoice Template for Engineering Services with Support for Change Order as the default invoice template, please visit Engineering Invoice Template for Excel Invoice Software on Excel Invoice Software to download it. The variant, Architect Invoice Template, has also implemented by Excel Invoice Software, at Architect Invoice Template for Excel Invoice Software.
It is a service company that does not have products. The services are delivered on a lump sum basis.
This template uses the first line of the invoice body as the "Project" and "Job#" cell. The "Line Total" cell of the first line is fixed to "1". The other lines on the invoice body are implemented as usual in the default invoice template.
When the word "Change Order" appears on the invoice body, the total of the whole invoice should be the line total of the change order. To get this result, firstly we use a formula to check whether the word "Change Order" appears on invoice body:
The above formula returns the line total value of the line where "Change Order" appears; if not found, the result will be "#N/A". The result of the formula is then put into the printed invoices.cell that is located outside the range, so that it will not be shown on the
Then, on the actualcell, the following formula is created to determine the correct invoice total:
This formula checks whethercontains error. If yes, it returns the sum of all the line totals; otherwise, it returns the value of .