- Document for Excel Invoice Manager
This version of the document, "Webhosting Service Invoice Template with Payment Slip", 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.
If the line totals of invoiced items cannot be calculated from something like "InvoicingTemplate.com at Web-hosting Invoicing Template in the Service Invoice Template category, as well as our company site Uniform Software Ltd at Web Hosting Invoice Form, where you can download it for free without a member account." or " ", you may need to manually enter the line total for each item. Webhosting service is a good example for this, and the invoice template provided here meets such a requirement with additional unique features. Note that this template is now added to
The drawback of this approach is that field names will not reflect the data stored in; but there is advantage too - this invoice template does not rely on the use of custom fields.
In order to create this service invoice template for webhosting service, there are several essential steps to follow.
Once you have a desired invoice layout in mind, the design of the customized template usually starts from moving cells and controls. To move a cell:
To move a control:
The "Payment Slip" section at the bottom of the invoice is basically comprised of several static text labels that you can enter directly into the form. There are also several formulas created to import content from the main invoice form. For example, the formula created for the "" cell is:
And, the formula for the "" is:
With the default invoice template, the line total shows "-" when the value is zero. If an item is a gift, you might want to display the word "Free". With this service invoice template, we implement this feature by first moving out the actual line total column and put it out side the "", and then create a formula column at the original line total location. The formula is as follows.
In the above formula, "?" is the line number of each line. This means that, for the first line, the formula should be:
And for the second line, the formula should be:
The formula means that, if the service description is empty, then the cell shows an empty string too; if the service description is not empty, then the cells shows "Free" or the actual line total depending on whether the line total is zero.