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 Excel template integrated with Uniform Invoice Software||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 invoice template sample was created based on the general sales invoice template. The most notable characteristic of this free invoice template is that the summary fields are moved to the top of the invoice form. There are 3 printable columns, line#, description and amount, reside within the print area. The line# column is filled in automatically when you enter an amount; both the description and amount columns are editable.
Since this is a service invoice, it does not use 'Ship To' fields. Instead, it offers a group of 'Site Address' and one additional 'Job Address' field to let you detail the address the service performed. The 'Code' column on the invoice body part allows you to use simplified and standardized code to identify the server or job that is being invoiced, for example 'S01' for small plumbing jobs, 'F01' for full heating systems, 'F02' for under floor heating, and 'N01' for new high efficiency boilers, etc. The 'Description' column should be filled with a detailed description of the current item. All the computable fields are listed on the invoice body, including Materials, Labor, Subtotal, VAT, Total Including VAT, Total, Paid, and Total Due.
This variant of our general sales invoice template includes 3 columns. Both the 'Description' and the 'Amount' column are editable. This free invoice from assumes that the shipping address is same as the 'Bill To' address, so it sill keeps the 'Shipping and handling' field on the bottom of the invoice form for you to enter shipping cost. The subtotal, taxes and totals are calculated with Excel formulas.
This free invoice form is a variant of the general sales invoice template shipped with Invoice Manager. It differs from the general sales invoice template in that it has only two columns - a 'Description' column and an 'Amount' column. The 'Amount' column on this invoice form is manually-input, i.e. it is not calculated from Quantity and Price as seen in many other invoice templates. However the subtotal and total are calculated automatically. The invoice form does not have taxes set - if you need, you can unhide Excel worksheet row 31 and row 32 to display the tax rows. Or, if you have Invoice Manager for Excel installed, and are using the version of the template for Invoice Manager, you can set up tax options on the 'Settings' window.
It is a simple, easy to use, free job invoice template that can be customized to fit your specific circumstance. On the top right corner there is a big "job invoice" title. "Start Date" and "End Date" allow you detail when the job started and ended. "Job Location" details the place where the job is done. On the invoice body, you can detail what was done. Job Invoice Template was revised and published on our new site Invoicingtemplates.com, at Job Invoice Template, as both a free invoice template and a template that works with Uniform Invoice Software. Please visit our new site Invoicing Templates for the updated documents and download links of this template "Job Invoice Template" .
There are two columns on the invoice body within the print area. The 'Description' column is where you enter the hosting plan the client purchased. The 'Amount' column within the print area is for display purpose only - If the current billing item is not free, this 'Amount' column display the amount as usual, and if he current billing item is free, the column value will the Word 'Free'. You enter the actual 'Amount' value outside the print area, which is located near the right-side of the print area. The invoice template has only 6 lines, but added a payment slip to the bottom of the form. It is now added to InvoicingTemplates.comhere.