Assuming you have downloaded and installed Uniform Invoice Software:
Prefer to have a look at other samples? Try our Search tool!
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed UIS, but are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
This labor invoice calculates amount from hours and hourly rate, just like its base template. It differs from the base template in that we added a gradient border to surround the entire printable form.
We've already published several samples on using form-level borders. For example, borders could be implemented using Excel's own cell border (sample: Standard Invoice Template with Double Border), or using shape object (you can find a downloadable sample at Simple Sample - Using Shape Object).
With this sample we look at yet another way to implemented border - by using the fill effect of Excel cells. We'll use c4070 Labor Invoice Template as the base format (also see Parts and Labor Invoice Template). C4070 is a printable labor invoice template that covers job descriptions, hours, rates and total amounts, as well as the general fields for invoices such as invoice#, invoice date and payment term. It calculates taxes, subtotal, discount and total using Excel formulas (also please visit invoice formats for general purpose).
In order to implement the borders using Excel cells' fill effects, we'll need to first add four rows and four columns to the existing printable form that surround the exiting form - add 2 rows on top of existing printable area, add 2 rows below the bottom of the existing printable form; add 2 columns to the left edge of the existing printable form; and add 2 columns to the right edge of the existing printable form. We'll use the outer rows and columns to mimic the borders, and use the inner rows and columns to adjust the space (or margin) between the borders and actual invoice content. The detailed procedure is demonstrated in c5085 Standard Invoice Template with Double Border. In this tutorial we'll not cover that details again, but start from how to create borders using fill effects of cells.
In Microsoft Excel, when you choose to fill solid color, gradient colors or a pattern to cell / cells, the operation is done towards each cell (or merged cell). So if you selected 10 adjacent but unmerged cells and execute the fill operation, Excel executes the fill operation 10 times, with each cell filled with exactly the same pattern.
Assuming the printable form has 10 rows and we choose to fill the left-border column with gradient colors, each of the 10 cells on the left-border column will be filled with a separate gradient effect. This isn't what we want because we want the whole left-border, from top to bottom, be filled with only one gradient effect.
To deal with this, we have to merge all the cells on the left-border column. In this sample, we merge cells from D2 to D51 for the left-border. To merge cells, first drag your mouse to select all the cells to merge, and then click the "Merge and Center". Do this merging process for the top border, ranging from E2 to O2; do this merging process for the right border, ranging from P2 to P51; do this merging process for the bottom border, ranging from E51 to P51.
Now the interesting part - fill the (merged) border cells with gradient colors. To do this, follow the steps below.
Set the gradient fill effects for other 3 borders - the top horizontal border, the right vertical border and the bottom horizontal border. In this design, make sure all 4 border use the same dark color and the same bright color. This, combining the proper selection of shading variants, we get the result as shown in the screenshot images - the top-left corner and bottom-right corner appear dark the other two corners, the gradient change is smooth without interruption. You may like to play with other possible options too. With the powerful tools provided by Excel, you can easily make your invoices stand out from the usual.
Note that this type of invoice design is not ink-friendly, meaning they require more ink to be printed on papers. If you always have the need to print each invoice on paper, consider the Simple Invoice Template collection. However if you use only electronical invoices, for example send PDF or image invoices using Uniform Invoice Software, this won't be a problem at all.
Like other form designs here on InvoicingTemplate.com, Labor Service Invoice with Gradient Border is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.
|Name||Labor Invoice with Gradient Border|
|Category||Service Invoice Template|
|Release Date||Saturday, July 2, 2016|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||30.00|
|Printable with Papaer Size / Orientation||A4 (210 mm x 297 mm) - Portrait|
|Default Margins (Points)|
This parts & labor invoice template in Excel spreadsheet format divides the invoice detail section into two parts, one for labor where the calculation of line totals is based on hours and rate; the another section for parts and materials, where line total calculation are based on price and quantity.
With this blank service invoice template we applied green gradient effects to various titles and headings on the invoice form, resulting in a pastel and sophisticated design. The invoice layout support Excel themes so you can change the colors easily.
As a freelancer, independent contractor, sub-contractors, or any self-employed person offering services to others, you need to create invoices to get payments in time. Creating invoices using Independent Contractor Invoice Template is as easy as fill in a blank paper form.
If you are running an auto repair shop, car mechanics or repair garage and need a quick, easy and budget-free solution for invoicing, this free Excel auto repair service bill sample could be your choice.
Almost all invoice templates here on InvoicingTemplate.com include a logo image, which in many case is implemented as an ActiveX control. This blank service invoice template sample shows how to use the "Picture" illustration to add the invoice logo.
To getting paid on time for your freelance writing / designing / editing / journalist / website developing / consulting / video production / translation work the best way is to send an invoice, by traditional postal mail or electronical email, in either PDF format, Excel spreadsheet (xlsx / xls) format, or even image format.
It is said that a picture is worth a thousand words. Do you want to place a beautiful image on your service bills to impress your satisfied customers? It is actually easy to do with Microsoft Excel and Uniform Invoice Software (UIS). This invoice sample shows you how.
This free invoicing template designed for gym, personal trainer or fitness instructor includes 4 columns, much like a general hours and rate based template. It differs from other form designs in that it includes a pretty personal trainer woman picture as the background.