Skip to main content
InvoicingTemplate.com main content

Law Firm Invoice Templatec5104

Law Office Billing Sample

"Law Firm Invoice Template" was found to be relative to Billing Template With Tear Off with the score grade of 95.

...(46) This free sample law firm invoice template provides an easy way to create professional bills and invoices for law firms / law offices and attorneys. Here you can find the template both in MS Excel format ("xlsx" format) and PDF format created by Uniform Invoice Software.

...(62) The "Currency" field is special on this template. It is defined as a custom field, but its value are fixed to the value "US $" by assigning it the formula ="US $" and by locking the cell. Uniform Invoice Software does not clear the cells when you click the "Clear & New" command, if the cells have formulas assigned and are locked.

Web-hosting Invoicing Templatec2007

Web-hosting Invoicing Template

"Web-hosting Invoicing Template" was found to be relative to Billing Template With Tear Off with the score grade of 91.

...(35) This free template in Excel spreadsheet format is suitable for business and companies who offer web hosting or other service, especially those small-scale businesses that are not ready for a complicated accounting or invoicing system.

...(73) There is also a payment slip attached on the bottom of the invoice form. For those of you who are new to this - a payment slip is a document sent by a creditor to a debtor with all the necessary information filled in order a payment to take place. The debtor confirms the payment by her/his signature and the sum due to be paid, in case the latter has not been included.

Contractor Billing Formatc3009

Contractor Billing Format

"Contractor Invoicing Layout" was found to be relative to Billing Template With Tear Off with the score grade of 86.

...(37) Contractor Billing Format differs from other templates here in that it itemizes "service" and "expense" in two separate sections on the invoice detail section. Each section has a different tax (including tax name and tax rate) applied.

...(36) The two custom fields added to this template, "Service Amount" and "Expense Amount", calculate the sum amount of each section. These two fields are also added to the "Sales Report", with the name "oknRsServiceAmount" and "oknRsExpenseAmount".

...(112) While there are many invoicing software apps that are able to handle simple and regular invoicing forms, Uniform Invoice Software is designed with flexibility in mind. This, with the help of Microsoft Excel, especially its formulas that allows us to define the relationship between cells (for example, how one cell is calculated from the value of the other cells), makes it possible for Uniform Invoice Software to handle complex invoicing forms and layouts. You may be still invoicing in the traditional paper way because there is no invoicing software app is able to handle the complex formats you need. Uniform Invoice Software helps you turn to electronical invoicing with easy and quick.

Catering Invoice Templatec4045

Catering Billing Format

"Catering Billing Format" was found to be relative to Billing Template With Tear Off with the score grade of 83.

  • In Excel 2003 click the Design Mode button on the Control Toolbox toolbar. Tip: If the Control Toolbox toolbar is invisible, click Excel menu View > Toolbars > Control Toolbox.
  • In Excel 2007, Excel 2010 and Excel 2013, click the Design Mode button in the Controls group of the Developer tab.

    TIP: If the Developer tab is not available in Excel 2007, do the following to display it: a) Click Microsoft Office Button, and then click Excel Options; b) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

    Or in Excel 2010 and Excel 2013 to display the Developer tab: a) Click File > Options > Customize Ribbon; b) In the area on the right, ensure that the box next to Developer is checked; c) When you click OK, the Developer tab will appear in the ribbon.

Engineering Invoice Templatec2006

Engineering Invoice Template

"Engineering Invoice Template" was found to be relative to Billing Template With Tear Off with the score grade of 73.

...(101) Like most other invoice templates available here on InvoicingTemplate.com, the engineering invoice template has a "Print Area" name defined which refers to the area on the center of the spreadsheet form. This is the printable area that defines the actual invoice format and layout. If you click the Print button on the invoice form of the Uniform Invoice Software version, or click the "Print" command in Excel, only the section defined by the "Print Area" name will be printed. And similarly, if you execute "Extract" command in Uniform Invoice Software, only the section referred by the "Print Area" will be kept.

...(18) The template has two columns - Description and Total. Both are manually editable fields on the Excel form.

Welder Invoicing Templatec7021

Welder Invoicing Template

"Welder Invoicing Template" was found to be relative to Billing Template With Tear Off with the score grade of 72.

...(43) After removing the text and names of the "Type" column, the space of the type column is merged into the Description column, so that the fillable description column could hold more content about the welding or steel fabrication job that have been done.

...(114) Merge and Center works by merging the selected cells into one and then centering the data in the new combined cell. While design a template layout like Welder Invoicing Template, Merge and Center could be a handy tool if used properly. One thing to note, however, since Uniform Invoice Software (UIS) relies on cell names (or field names) to create the relationship between the Excel form cells and the database fields, you should make sure the cell that contains a field name is the first one in the group of cells that are to be merged. This way, UIS will work with the merged cell by reading from or writing to the named cell.

Notary Invoice Templatec3007

Notary Billing Template

"Notary Invoice Template" was found to be relative to Billing Template With Tear Off with the score grade of 67.

...(42) Notary Invoice Template could also be seen as a general service invoice template and consultant invoice template. It helps you to create and print professional notary and general invoices and estimates. The billing form has 3 columns - Date, Description and Amount.

...(161) If you use the Uniform Invoice Software version of Notary Invoice Template, there are additional taxing options on the Taxes tab of the Settings window. The first is the option for choosing the number of tax items; you have 3 choices - no tax, one tax and two taxes. Secondly, you can set the names and rates in percentage for each tax, such as VAT, GST or PST, or simply Sales Tax. Thirdly, there are a group of checkbox options on the dialog box, including: "Tax invoice total including shipping cost", which adds the shipping cost to the taxable amount when checked; "Tax 2 is applied to tax 1", which adds the amount of "tax 1" to the taxable amount if checked; and "tax rate can be zero", which allows you to set any of the tax rates to be the value of zero. If you modify the options on this dialog box, the spreadsheet will be changed accordingly if needed.

Musician Invoice Templatec2036

Musician Billing Format

"Musician Billing Format" was found to be relative to Billing Template With Tear Off with the score grade of 53.

...(43) This invoice template designed for musician includes a stave background image. Besides the Excel spreadsheet template, a PDF billing format template for musician is also included. This sample is formatted with Australian currency but you can easily change it with Excel formatting tools.

...(25) Unlike the other two-column templates here on InvoicingTemplate.com, the "amount" field is calculated with Excel formulas, so it is not manually editable on creating invoices.

...(10) The formula assigned to the "Amount" field is like this:

...(101) The "Advertisement" section is an auxiliary section, which is not directly related to your bills or invoices, but allows you to put a brief description about your business and service, or you can also put your payment term, service term here. Note that this is a static text section - you can modify it once the template is switched to design mode, but when you are creating invoices, this section is protected and thus couldn't be modified. This also means that the section is not defined as a field in the database, and thus cannot be changed from invoice to invoice.

Canadian Invoice Template with HSTc6020

Canadian Billing Form with HST

"Canadian Invoice Template with HST" was found to be relative to Billing Template With Tear Off with the score grade of 47.

...(40) Canadian Invoice Template with HST, or Canadian Billing Form with HST, is an invoicing form that implements one tax (HST - Harmonized Sales Tax) . It also includes the "Taxable" checkbox column on the invoice detail section to support for

...(24) The Item# (product#) column, which is seen on the default invoice template, is also moved out of the print area of the invoicing form.

...(143) The printable area, or print area, is the area with white background on the center of the Canadian Invoice Template with HST spreadsheet. By default Microsoft Excel prints the entire worksheet when you issue the print command, but if the worksheet has a print area defined, such as what we do for Canadian Invoice Template with HST, only the print area will print. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet again. If you need to recreate the print area definition, here are what to do: On the "Invoice" worksheet of the Canadian Invoice Template with HST, select the cells that you want to define as the print area; On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

Bill Format for Computer Repair Servicec5096

Bill Format for Computer Repair Service

"Bill Format for Computer Repair Service" was found to be relative to Billing Template With Tear Off with the score grade of 45.

...(88) The "Bill To" section includes 6 fields - client#, name, address, city state and zip, email and phone. In many situations email is a key field now, especially if you want to send PDF invoices to your clients via email. By adding the email field to the "Bill To" section, you are able to create new customer records along with their email address populated; and besides that, it also ensure you can send a PDF version of the invoice to the customer by simply clicking the "Extract/Email" button.

Simple Sample - Splitting City State ZIPc4072

Simple Sample - Splitting City State ZIP

"Simple Invoice Template - Splitting City State ZIP" was found to be relative to Billing Template With Tear Off with the score grade of 39.

  1. Backup both your Excel Invoice Template and database file.
  2. Open the invoice template as usual.
  3. Click the Design Mode button on Excel "Invoice" ribbon tab. Note that to show the "Invoice" ribbon tab you have to install Uniform Invoice Software, our Excel invoicing software that leverage both the features of front-end Excel and back-end database.
  4. Look for an empty area to place the extracted city, state and zip values. Since we'll not show the extracted values on the printed invoices or auto-generated PDF invoices. In this case we choose the O6:P20 area outside of the printable invoice form. In cell o6, type in the name of this section - "separate U.S style city state zip".
  5. Click to select cell O7. Type in the formula ' =TRIM(oknWhoCityStateZip)'. This formula makes corrections to the original value - i.e. removing the leading and trailing spaces.
  6. Click to select cell O8. Type in the Excel formula ' =IF(O7="","",LEFT(O7,(FIND(",",O7))-1))'. This formula looks for the common symbol in the text, and retrieve the left part as the "city name". Click to activate the name box on the left-side of the formula bar, enter the name of this cell "oknCustomerCity".
  7. Click to select cell O9. Type in the Excel formula ' =IF(O7="","",MID(O7,FIND(",",O7)+2,FIND("*", SUBSTITUTE(O7, " ", "*", LEN(O7) - LEN(SUBSTITUTE(O8, " ", ""))))-(FIND(",",O7)+2)))'. This formula retrieve the part between the comma and space symbols. This is the state name. Name this cell "oknCustomerState".
  8. Click to select cell O10. Type in the formula ' =IF(O7="","",RIGHT(O7, LEN(O7) - FIND("*", SUBSTITUTE(O7, " ", "*", LEN(O7) - LEN(SUBSTITUTE(O7, " ", "")))))) '. This formula retrieve the zip / postal code from the "city, state zip string. Name this cell "oknCustomerZip".

    With all these formulas correctly set, if you enter "La Jolla, California 92092-0100" into the "oknWhoCityStateZip" cell, the "oknCustomerCity" cell should show "La Jolla", the "oknCustomerStateCell" should show "California", and the "oknCustomerZip" cell should show "92092-0100".

  9. Now exit design mode by clicking the "Design Mode" button again on the "Invoice" ribbon tab.
  10. Click the "Customers" button on the "Invoice" ribbon.
  11. Click "Custom Fields", and then "Add Field".
  12. Enter the name of the field "CustomerCity", choose its type "Text", and set the size to "50". Click OK to create the custom field.
  13. Click "Add Field" again. Create the second custom field - Name: oknCustomerState; Type: Text; Size: 50. Click OK to create the custom field.
  14. Click "Add Field" again. Create the third custom field - Name: oknCustomerZip; Type: Text; Size: 50. Click OK to create the custom field.
  15. Now from the "Database table" list, choose "Invoice Header". Click "Add Field".
  16. Repeat the above steps to add "CustomerCity", "CustomerState" and "CustomerZip" custom fields for the Invoice Header database table.
  17. Click "Close" to close the custom field manager.
  18. Save the invoice template by clicking the Save button on Excel quick access toolbar.
  19. Test the template.

Plumbing Contractor Invoice Template (Landscape)c2009

Plumbing Contractor Billing Template (Landscape)

"Plumbing Contractor Invoice Template (Landscape)" was found to be relative to Billing Template With Tear Off with the score grade of 39.

...(97) Like Microsoft Word, Microsoft Excel allows you to set paper options through its Page Setup dialog box. In Excel 2003, the Page Setup dialog box can be opened by clicking Excel menu File > Page Setup. With Excel 2007, Excel 2010, Excel 2013 and Excel 2016, the command for opening Page Setup dialog box can be accessed through Page Layout ribbon tab > Page Setup group and then click the arrow button on the group. The Page Setup dialog box offers various options for you to control the printing and layout of Plumbing Contractor Invoice Template (Landscape).

...(18) After setting the paper orientation, we adjust the column widths to make them suitable for the new paper.

...(22) To make the invoice form still being printable on single page, 6 lines were removed / hide from the invoice detail section.

New Zealand Tax Invoice Templatec4038

New Zealand Tax Billing Form

"New Zealand Tax Invoice Template" was found to be relative to Billing Template With Tear Off with the score grade of 14.

...(86) As you can see from New Zealand Tax Invoice Template, one benefit of using Excel as your invoice creator, as compared to other template formats like Microsoft Word invoice template and PDF invoice template, HTML format or even Photoshop format, is that you can easily apply formulas to do calculations. This means that, once the basic figures are entered on the form, like Quantity and Unit Price, or Hours and Hourly Rate, or Days and Daily Rate, the calculation of totals and taxes is done automatically.

3-Page Invoice Templatec5082

3-Page Invoicing Format

"3-Page Invoice Template" was found to be relative to Billing Template With Tear Off with the score grade of 11.

...(84) Custom fields (also called user-defined fields) are a powerful feature implemented by Uniform Invoice Software since many years ago - at that time, our desktop invoicing software is named Excel Invoice Manager. Custom fields could be added to all the main tables defined by Unifomr Invoice Software, including Customer, Product, Invoice Header and Invoice Body. And by using Excel formulas, you can easily create (define) the relationship between fields. For example in this template, the Labour Total value is calculated using the formula "=ROUND(J83*I83,2".

One Tax Column, No Shipping Addressc5002

One Tax Column, No Shipping Address

"One Tax Column, No Shipping Address" was found to be relative to Billing Template With Tear Off with the score grade of 10.

...(18) This "One Tax Column, No Shipping Address" invoice template is a variant of Invoice Template with Tax Column.

ABN Tax Invoicec7028

ABN Tax Invoice Format

"ABN Tax Invoice Format" was found to be relative to Billing Template With Tear Off with the score grade of 2.

...(64) Once ABN Tax Invoice is unprotected and switched into design mode, you can now move the controls to the new location you like. To do this, click to select a control, or push the CTRL on your keyboard and then select all the controls you want to move using mouse. Then, drag (one of) the select controls to move them to the new location.

Note that if you use the Uniform Invoice Software and need to show the control on an extracted worksheet, then the control should be named with an "oknWidget_" prefix. For example, if you move the Taxable checkboxes into the

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c5104
Law Firm Invoice Template
Thursday, November 24, 2016,
12
5
A4
Portrait
Service
c2007
Web-hosting Invoicing Template
Wednesday, October 23, 2013,
6
2
A4
Portrait
Service
c3009
Contractor Billing Format
Saturday, October 17, 2015,
18
3
A4
Portrait
Service
c4045
Catering Invoice Template
Tuesday, November 10, 2015,
12
4
A4
Portrait
Receipt
c2006
Engineering Invoice Template
Monday, September 15, 2014,
9
2
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c7021
Welder Invoicing Template
Friday, September 26, 2014,
20
7
Letter (8-1/2 in. x 11 in.)
Portrait
Sales
c3007
Notary Invoice Template
Thursday, October 2, 2014,
12
3
A4
Portrait
Service
c2036
Musician Invoice Template
Sunday, October 9, 2016,
6
2
A4
Portrait
Service
c6020
Canadian Invoice Template with HST
Wednesday, August 5, 2015,
12
6
A4
Portrait
Sales
c5096
Bill Format for Computer Repair Service
Tuesday, October 18, 2016,
12
5
A4
Portrait
Service
c4072
Simple Sample - Splitting City State ZIP
Saturday, May 7, 2016,
12
4
A4
Portrait
Sales
c2009
Plumbing Contractor Invoice Template (Landscape)
Wednesday, May 14, 2014,
6
2
A4
Landscape
Service
c4038
New Zealand Tax Invoice Template
Tuesday, August 4, 2015,
12
4
A4
Portrait
Sales
c5082
3-Page Invoice Template
Friday, May 6, 2016,
60
5
Letter (8-1/2 in. x 11 in.)
Portrait
Sales
c5002
One Tax Column, No Shipping Address
Wednesday, November 6, 2013,
12
5
A4
Portrait
Service
c7028
ABN Tax Invoice
Sunday, July 3, 2016,
17
7
A4
Portrait
Sales

What Is Hot

Feature Galleries