A building service billing template is also called building service invoice template, building service invoice form. The building service billing template is a blank service billing form that helps you create invoices with easy and quick.
This invoice template is a highly customized one that offers a very different billing form than the default general sales invoice template included in our invoicing software that you can downloaded from our site and test for free, even though the building service billing template is created from the general sales invoice template like all the customized invoice templates here on this site UniformSoft.com.
On the top of the invoice form, you will neither find the space for your company logo and name, address, nor the big 'INVOICE' heading. This is because the invoice template is designed to be printed the papers with letterhead on it, thus it is not necessary to include the same information again. To make the template suitable for various letterhead sizes, the heights of the several top lines are adjustable. To do this, first unprotect the Invoice worksheet, and then set the appropriate options to show row/column headings and gridlines, and then drag the border of the row heading to resize the rows.
The 'Bill To' section has 9 lines. This is the place for you to detail your client information. If you use the free invoice template, you can fill in this section as your usual practice. If you use the invoicing manager version, the values of the cells will be saved to database fields identified by cell names, and the purpose of each cell is listed to the left side of the print area, and they are: Name, Owner, Agent, Business Street 1, Business Street 2, Business Street 3, Business City, Business State, and Business Postal Code. If you have ever used the general sales invoice template included in our invoicing software setup program, you may notice the fields are different from those defined in the general sales invoice template, because in this building service billing template most of them are custom fields.
To the right of the 'Bill To' section there are 3 important fields, invoice#, invoice date and your own VAT#. The first two cells are editable, and the last cell is locked.
The invoice body section includes 3 columns. The first column is a description column, where you can detail the job done. The second column is the Amount column, and the third column is the VAT column. The VAT is calculated automatically when you enter the Amount values.
Following is a section of ' Disbursements', such as: a) Printing, Copying, b) Telephone, c) Postage, d) Travelling, e) General Expenses.
On the bottom of the invoice form, there are summary cells of Subtotal, VAT and Total Due. These cells are all calculated automatically.
If you use the version that runs with our invoicing software, it is recommended that you fill in customer information into the S14:S22 section outside the print area. This section also provides a drop-down list titled with 'Frequency'. If you don't need this, you can ignore it or delete it completely.
The invoice template itself does not create PDF format commercial invoices, but you can install one of those free add-in programs for your Office, such as PrimoPDF. Once such a program is installed, you can create your PDF commercial invoice by simply print to the PDF printer in Microsoft Excel.
On the top of the invoice body, the column heading section where it usually titled with 'Description' is now replaced with a label 'Re:' and a text field for showing site address. This (merged) cell is named oknSiteAddress and is filled with a formula automatically:
The above formula means that if the S43 cell has a value, then the value should be filled into oknSiteAddress, otherwise oknSiteAddress shows an empty string.
Now if you take a look at cell S43, it has a formula too:
=VLOOKUP(oknJobNumber,'Job & Site Ref'!B5:C100,2,FALSE)
The above formula tells Excel to search for the value of the cell named oknJobNumber in the B5:C100 section on the 'Job & Site' worksheet, and if found, use the value of on the second column to populate the current cell.
The above two formulas work together to implement a feature that allows you enter a reference number in the oknJobNumber cell (to the right side of the 'Invoice To' section), the site address will be automatically filled in according to the list of the B5:C100 area on the Job & Site Ref worksheet. For example, if the B5:C100 area has a line of 'j01', '12345 Appold Street', and you enter the job number 'j01' into the oknJobNumber cell, then the site address '12345 Appold Street' will be displayed/filled by the formulas.
Tip: Enlarge an image by clicking on it.
Choose the format you like and download Building Service Billing Template for free by clicking the corresponding "Download" button. The zip packages include the simplified version for Invoice Manager (Lite).
|The Excel template integrated with Invoice Manager for Excel||Download|
|Building Service Billing Template (Building Service Invoice Form) in PDF format||Download|
|Building Service Billing Template and database in a self-extracting zip package||Download|
|Building Service Billing Template, the Excel template (workbook) only (.xls or .xlsx)||Download|
|The Excel template in zip package||Download|
This free proforma invoice template provides an easy to use and professional proforma invoice format in Microsoft Excel format. The proforma invoice form helps you create and send pro forma business document in advance of a commercial invoice. Download this printable invoice template for free and see if it meets your business requirements.
Medical Invoice Template / Medical Billing Template are designed specially for small medical practice businesses, especially for those who offer medical care for infants, children and adolescents. On the body of the invoice form, the medical invoice form / medical billing form details not only the billing items, but also insurance etc.
The discount column on the invoice body are titled with '%Discount'. As you can see, the discounts you entered here are formatted and seen as percentags. For example, if quanity is 10, unit price is 20, '%Discount' is 5, then the line total is 190. All the calculations within the free invoice template are done with Excel formulas. You may also like to see: Template with Discount Amount Column and Template with Discount Column without Client.
If you are giving something to your customers for free for the goods or services purchased from you, it might be wise to list the free items on the invoices and state the fact clearly by displaying the word 'Free' or 'Gift' on the free items. This sample invoice template implement this by moving the actual price and line total columns outside the print area, and then on the invoice body use Excel formulas to check whether the current price and line total is zero - if it is, the formula shows the word 'Free'; if it isn't, the price and line total are shown as usual.
The sample invoice template here differs from the other invoice templates available here on UniformSoft.com in that it does not use 'Product ID' or 'Item #'. Instead, if you fill in an item description on a line, it shows the line number of the current line; but if the description is not filled in, it shows nothing in the field. All this is implemented by using a simple Excel formula.
The invoice template has two columns within the print area, a description column and a total column. 'Payment Type' can be chosen from a dropdown list on the bottom of the invoice form. The invoice template support 'change order' - if an item on the invoice form has the word 'change order' within the 'description' field, the grand total of the will become the total of the line with the word 'change order' appears.