Skip to main content
InvoicingTemplate.com main content

Welding / Fabrication Tax Invoicec6017

Welding / Fabrication Tax Billing Template

"Welding / Fabrication Tax Billing Template" was found to be relative to Excel Invoice Spreadsheet with the score grade of 98.

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

...(236) Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in Welding / Fabrication Tax Invoice before doing the movement. And, if the target location contains merged cells, sometimes the movement fails. So it is also helpful to make sure the target location does not contain merged cell. If the target location Welding / Fabrication Tax Invoice is overlapping the original range and the original range contains merged cells, the movement could also fail because you cannot change part of merged cell - if this happens, you need to first move the cells to a temporal location in Welding / Fabrication Tax Invoice that are empty (i.e. not used), unmerge cells, and then move the cells from the temporal location to the desired location. If you need to unmerge a cell, first select it and then click the "Merge and Center" command on the Format toolbar in Excel 2003; or click the "Merge and Center" command on the Home ribbon tab in Excel 2007, 2010 and Excel 2013.

Simple Template with Printable Watermarkc4075

Simple Template with Printable Watermark

"Simple Template with Printable Watermark" was found to be relative to Excel Invoice Spreadsheet with the score grade of 97.

...(35) Adding a background image or watermark can be an attractive and appealing enhancement, especially for business documents like invoices. This Simple Invoice Template with Printable Background Watermark demonstrates how to accomplish this in Microsoft Excel.

...(50) However this type of background images are not printable. If you go to Excel menu "File" and then choose "Print", Excel shows the print preview of the current invoice spreadsheet. However the background image set previously is not included. And for watermarks, Excel does not provide directly support for it.

...(40) There are still ways to create invoice template with printable background image or watermark. In this sample, we'll use c4074 Simple Invoice Format for Letterhead Paper here on InvoicingTemplate.com as the starting point and basic invoice template for demonstration purpose.

Excel Quotation Templatec9008

Excel Quotation Template

"Excel Quotation Template" was found to be relative to Excel Invoice Spreadsheet with the score grade of 97.

...(48) The discounting calculations in this template is built specially for a real business. It may not be suitable for you, but it is a good sample on how to customize the invoice template shipped with Uniform Invoice Software. For more samples on quotations and estimations, visit Estimate Templates.

...(23) "Unit Price" is a manually editable field. "Line Total" is also a calculated field, which looks like this (again, "_?" indicates line numbers):

...(15) The "LESS" is also a manually editable field, which is designed as a percentage value.

General Quote Template for Excelc2035

General Quote Template for Excel

"General Quote Template for Excel" was found to be relative to Excel Invoice Spreadsheet with the score grade of 91.

...(45) This general purpose price quote template in Microsoft Excel spreadsheet format is a slightly modified version of the General Estimate Template. With this form design all fields and columns are manually editable, except the subtotal, tax and total fields that are calculated using Excel formulas.

...(123) As an Excel spreadsheet template, we use Excel formulas to calculate subtotal, tax and total. For example, for the subtotal field, the Excel formula assigned to the subtotal field is "=SUM(oknLinetotal_1:oknLinetotal_22)". This is one of the big advantages of using Excel spreadsheet templates. While you can create beautiful and professional forms too using Microsoft Word, Publisher, PowerPoint or even Adobe Photoshop, it is much easier when you need to do some calculations. This ability, combined with custom fields (user-defined fields) supported by Uniform Invoice Software, resulting extremely flexible form designs, as you can see from the samples online here on InvoicingTemplate.com. Or see the PDF quotation sample to find out what it will like when your customer receive the quotation created using UIS.

Excel Payment Voucher Templatec5052

Payment Voucher Template

"Payment Voucher Template" was found to be relative to Excel Invoice Spreadsheet with the score grade of 83.

...(109) Are you a small business owner? If so, you know just how important a payment voucher can be when making purchases or paying for services. This general purpose payment voucher template in Microsoft Excel spreadsheet format can help you create a voucher that is professional looking and easy to understand. Excel Payment voucher template is daily use document for every kind of sealing and purchasing businesses and payment voucher template is a designed format of professional voucher. All you need to do is download the free voucher template and open it using Microsoft Excel 2003 or later version and then update important info such as company's logo contact details.

Job Estimate Template for Excelc4084

Job Estimate Template for Excel

"Job Estimate Template for Excel" was found to be relative to Excel Invoice Spreadsheet with the score grade of 83.

...(35) This job and work estimate template in Excel spreadsheet format is a design based on c4009 Service Proposal and Quote. With this blank sample template, we move in the "ESTIMATE#" cell and the "Item#" column.

...(119) For this reason, the "ESTIMATE#" support all the features assigned to the "Invoice#" cell by Uniform Invoice Software. For example, if you click "Save To DB" or "Save Invoice", a sequential, progressive and unique estimate# is generated automatically if the "Estimate#" cell is left blank (see our gallery page at Excel Invoice Template Automatic Invoice Numbering). With pure-Excel spreadsheet solutions, this automatic numbering is not possible without using macros. To display / retrieve an existing estimate or quote, you can simply enter the estimate# into the cell. With the support from Uniform Invoice Software, the pure-Excel spreadsheet template is not only printable, but also enables features that could be hardly to implement with pure-Excel estimating and quoting software apps.

Donation Receipt Template for Excelc1004

Donation Receipt Format for Excel

"Donation Receipt Template for Excel" was found to be relative to Excel Invoice Spreadsheet with the score grade of 73.

...(34) This general donation receipt template in Microsoft Excel spreadsheet format (".xlsx") includes fields for charity / organization name, address, contact information, donor name, several lines of description, an amount field, a handwriting signature field.

...(25) Third, it is also required to clearly describe the donation, including the date the donation was made, as well as the amount of the donation.

...(109) While not required, this form includes a "Receipt#" field on the top of the form under the "Date" field. If you have used one of our form designs for invoicing, you may know it is just the "Invoice#" field - we just place a new label "Receipt#" before the cell. So all features Uniform Invoice Software offer for the "Invoice#" field, works for the "Receipt#" field too. For example, the automatic receipt numbering feature, which generates a unique, sequential and unique based on a counter stored in the backend database. You can also retrieve information about an already-saved receipt by type in the receipt number into the "Receipt#" field.

Labor Invoicing Samplec4070

Labor Billing Format for Excel

"Labor Invoicing Sample" was found to be relative to Excel Invoice Spreadsheet with the score grade of 70.

...(39) This printable labor invoice template 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.

...(100) If you don't need the LOGO image and want to delete it, simply hit the DEL key on your keyboard after you selected it with your mouse key. Deleting the LOGO image leaves an empty area to the left of the Company Information section. You may like to move the entire Company Information section to fill in the empty area. To do this: Drag your mouse to select the entire Company Information area, including Company Name, Street Address, City, ST Zip Code, etc.; Push your mouse key on the border of the selected area; drag it to the new location.

Parts and Labor Invoicing Formatc4071

Parts and Labor Billing Format for Excel

"Parts and Labor Invoicing Format" was found to be relative to Excel Invoice Spreadsheet with the score grade of 66.

...(50) 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.

...(96) The tax calculation methods differs completely from the default invoice template shipped with Uniform Invoice Software, where two taxes (if two taxes are all applied / enabled for the template) are all applied to all the items listed on the template. Since this design breaks the assumption of the locations of tax cells, you cannot adjust the number of taxes using the features on the "Taxes" tab on "Settings" window inside Uniform Invoice Software. On the other hand, Uniform Invoice Software will have no problem to help you adjust the tax names and rates for you.

Excel Shipping Invoice with Printable Truck Background Imagec5087

Shipping Invoice with Printable Truck Background

"Shipping Invoice with Printable Truck Background" was found to be relative to Excel Invoice Spreadsheet with the score grade of 55.

...(79) On creating invoices, Excel invoice templates has many advantages over the other formats, like Microsoft Word (docx), PDF, HTML / CSS, or even Adobe Photoshop (PSD), etc. Maybe programs like Photoshop is possibly able to generate beautiful invoices (however, without a proper Photoshop-based invoice template, it is a time consuming work to do), none of the other formats could do automated calculations using formulas like Microsoft Excel, which is critical if you need to create several invoices each day.

  1. Again, make sure the "Invoice" worksheet is in design mode.
  2. Click to select a "pick up" (magnifying glass icons) button.
  3. Hit DEL key on keyboard.

Invoicing Template in Eurosc4100

Invoicing Format in Euros

"Invoicing Format in Euros" was found to be relative to Excel Invoice Spreadsheet with the score grade of 50.

...(50) Download this free simple VAT invoice template in Excel format for invoicing in Euros. This design has a similar layout as the German version. The differences are that all labels are in English, and it shows the Euro symbol on cells, and also has a Euro watermark on the form.

  1. Backup the template before you modifying the template.
  2. Click the "Design Mode" button. This unprotect the sheet, show gridlines and row / column headings.
  3. Click to select the cell that you want to show a currency symbol. Or, if you want to make the change for multiple cells, push CTRL key on keyboard and click each cell one by one.
  4. Right-click one of the selected cell and choose "Format Cells" from Excel shortcut menu.
  5. On the "Number" tab, choose "Accounting" from the "Category" list, make sure "Decimal Place" is "2", and from the "Symbol" list choose Euro.
  6. Once done, click the "Design Mode" button again to exit design mode.
  7. Save the template by clicking the "Save" button on Microsoft Excel quick access toolbar.

Hotel Guest Folios with Satisfied Business Travelerc5091

Hotel Guest Folios with Satisfied Business Traveler

"Hotel Bill Layout with Satisfied Business Traveler" was found to be relative to Excel Invoice Spreadsheet with the score grade of 47.

...(46) This hotel guest invoice / guest folios / guest bill format includes spaces for hotels / motels to detail number of guest(s), Room No., Arrival Date, Arrival time, Departure date, Departure time. To beautify the form design an image of a satisfied business traveler is added.

...(133) The 5 columns on the detail section allows you to post any debit / credit regarding a room# or guest account. Usually when a folio is opened the starting balance is zero. All transactions which increase (debit) or decrease (credit) the balance of the account are recorded on the folio, for example, room charges, cash payment advance deposit, etc. For those business guests who are planning a meeting, conference or special event, related fees could be posted here too. While guest settles the final bill an Invoice is generated usually with a unique Invoice number by Uniform Invoice Software (UIS) for future reference. To set options for auto-generation of invoice numbers, such as prefix and starting number, click the "Settings" button on the "Invoice" ribbon tab, and then go to the "Database" tab.

General Purchase Invoice Template (Service, One Tax)c2026

General Purchase Billing Template (Service, One Tax)

"General Purchase Invoice Template (Service, One Tax)" was found to be relative to Excel Invoice Spreadsheet with the score grade of 43.

...(34)General Purchase Invoice Template (Service, One Tax) is a customized invoicing form based on c2025 General Purchase Invoice Template (Sales, One Tax). It differs from the original edition by removing the shipping address section.

...(87) In order to create this template - "General Purchase Billing Template (Service, One Tax)", we moved out the shipping address fields out of the "Print_Area" range. In Excel spreadsheet documents, the range name "Print_Area" defines what part of the sheet to print when you issue the print command. If the name "Print_Area" is not defined, the whole sheet will be printed; otherwise, only the range defined by the "Print_Area" name will be printed. Put it in other words, it defines what area is the printable invoicing form.

Invoice with Previous Balance (Sales)c5007

Invoice with Previous Balance (Sales)

"Invoice with Previous Balance (Sales)" was found to be relative to Excel Invoice Spreadsheet with the score grade of 39.

...(25) This invoice template has fields for forwarding previous outstanding balance, making it easy for your client to see past due amount on the new invoice.

...(162) So to create this Invoice with Previous Balance, all you need to do is to name a cell "oknAccountBalance". To do this, first unprotect the Invoice worksheet, and then select the cell you want to assign the name, and then enter the name in the name box on the formula bar. One additional step might be required, that is to unlock the named cell - If a cell is locked and the sheet is protected, Uniform Invoice Software will not be able to write to it. To unlock a cell, first unprotect the Invoice worksheet and then right-click the cell and choose Format Cells. Go to the last tab, uncheck the Lock box. After naming the cell, you can move it without breaking the functionality of the template. Moving cell to a new location could be done by dragging and dropping - more detailed sample and instructions can be found on Proforma (1st Sample of Customization) and Proforma (2nd Sample of Customization).

...(45) You may also like to add the "Total Due" cell, like what we did to the template here on InvoicingTemplate.com, and then use an Excel formula to add up previous balance and current invoice balance. Please download the template for free to see the details.

UIS V5.11 Standard Invoice Template and Shortcut Keysc5094

Standard Invoice Format and Shortcut Keys for UIS Version 5.11

"UIS V5.11 Standard Invoice Template and Shortcut Keys" was found to be relative to Excel Invoice Spreadsheet with the score grade of 28.

...(70) The default or standard invoice template shipped with Uniform Invoice Software version 3 or earlier contains buttons on the worksheets, which are implemented using ActiveX controls. With version 4, a contextual task pane is added to each worksheet, which contains commands available to each sheet, and the ActiveX command buttons were removed from the default template shipped with UIS - however command buttons implemented with ActiveX technique are still supported.

  • Backup your invoice template.
  • Open it as usual.
  • Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.
  • Go to Excel "Insert" ribbon.
  • Click "Text Box" in the "Text" group, and click the location on the sheet where you want to put the button. Excel creates a new text box on the sheet, and put the control in text edit mode.
  • Enter the button caption text, such as "Customers".
  • Click the corner of the text box. This exits text edit mode, and selects the text box itself.
  • Go to the "Format" ribbon tab (This tab shows only when the shape object is selected).
  • In the "Shape Styles" group, click the "More" down-arrow on the preset style list to show the list of all preset theme fill effects. Choose one of the feel effect from the list. For example, with the default template shipped with UIS, we choose "Subtle effect - Black, Dark 1" - the forth one on the left-most column. By assign the text box a proper background, the text box now looks like a button.
  • Name the text box by entering the name in the name box located on the left-end of Excel formula bar. For example, the text box labeled as "Customers" should be named "oknCmdCustomer".
  • Now right-click the control and choose "Assign Macro".
  • Enter the following macro command.
    UisClickProc
  • Repeat the above steps to add all the other buttons. See table below for button names and captions.
  • Once done, exit design mode by clicking the "Design Mode" button again on the "Invoice" ribbon tab.
  • Save the template by clicking the Save button on Excel quick access toolbar.

Plumbing Contractor Invoice Template (Landscape)c2009

Plumbing Contractor Billing Template (Landscape)

"Plumbing Contractor Invoice Template (Landscape)" was found to be relative to Excel Invoice Spreadsheet with the score grade of 27.

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

...(60) One thing to note is that InvoicingTemplate.com tested the templates, including Plumbing Contractor Invoice Template (Landscape), on Microsoft Windows (with Excel, not Word) only, and the testing on Mac was usually not performed. If you need to run Plumbing Contractor Invoice Template (Landscape) on Mac, test it with Mac version of Microsoft Excel before you apply it for production purpose.

Sales Invoicing Format for Germanyc4098

Sales Invoicing Example for Germany

"Sales Invoicing Example for Germany" was found to be relative to Excel Invoice Spreadsheet with the score grade of 19.

...(47) The German tax law is very formal and also the VAT invoice requirements are very strictly. The German rules are conform to the obligations of the EU VAT Directive and its VAT invoice requirements. Refer to German VAT invoice requirements and VAT invoicing rules for more information.

...(34) If you are not charging VAT (MwSt), you can hide the fields / cells completely by using this "Settings" box. In this case, you'll also need to add a declaration to the invoicing form,

Work Order and Processing Sheet Practical Samplec7008

Work Order and Processing Sheet Form Practical Sample

"Work Order and Processing Sheet Practical Sample" was found to be relative to Excel Invoice Spreadsheet with the score grade of 18.

...(52) Like other templates here on InvoicingTemplate.com, this format is provided in Excel (".xlsx") format too. You may find work order template in Microsoft Word (".docx" or ".doc") elsewhere, but Excel-based ".xlsx" format has its advantages over Word such as automated calculations etc. Furthermore, all our templates works well with Uniform Invoice Software.

...(36) To share data between the invoice template and processing sheet template, all you need to do is to connect the two templates to the same database file. To connect a template to a specified database file:

...(24) The following table summarizes the columns inside / outside the print area in the invoice template. The columns without a formula are manually editable.

Service Invoicing Templatecn003

Service Invoice Form

"Service Invoice Form" was found to be relative to Excel Invoice Spreadsheet with the score grade of 6.

...(46) The Service Invoicing Template is the most popular template in its category "Service Invoice Template" here on InvoicingTemplate.com. During the past several years we've built a number of variants based on this service invoicing form but this template is the most downloaded one in its category.

...(78) On the top of the invoice form, you can find the fields for invoice number and invoice date. These are required fields that help you to track the invoice and keep your book organized. In the Bill To section, you can add the customer details including name, address, city, state, zip code and phone. A list of itemized services, including description, quantity, unit price and line item total, allow you to enter your services and cost of each.

Commercial Template Sample - Complete Incoterms Optionc9005

Commercial Template Format - Complete Incoterms Option

"Commercial Template Format - Complete Incoterms Option" was found to be relative to Excel Invoice Spreadsheet with the score grade of 1.

...(29) This sample of blank commercial invoice template demonstrates how to add a complete Incoterms option, in the format of the dropdown list, to replace the existing checkbox-based freight rules.

...(41) First, open your commercial invoice template. Make sure the "Invoice" worksheet is active (the current sheet). Push down the "Design Mode" button on the "Invoice" ribbon tab (If you don't see this tab, make sure you have Uniform Invoice Software installed).

...(92) Fourth, create the dropdown list by using Excel data validation. Select the "oknIncoterm" cell. Click Excel command on the ribbon: Data, Data Validation, and then Data Validation again. On the "Data Validation" dialog box, choose "List" from the "Allow" box, and then click the "Source" field, enter the range of the source - in this sample, it is "$W$4:$W$14". There are other options you can set on this dialog box too, for example you can specify the error message to show if a user entered an incorrect value. Once finished, click OK.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c6017
Welding / Fabrication Tax Invoice
Friday, September 26, 2014,
20
6
Letter (8-1/2 in. x 11 in.)
Portrait
Sales
c4075
Simple Template with Printable Watermark
Tuesday, June 28, 2016,
20
4
A4
Portrait
Sales
c9008
Excel Quotation Template
Friday, February 10, 2017,
37
9
A4
Portrait
Other
c2035
General Quote Template for Excel
Friday, August 19, 2016,
18
2
Letter (8-1/2 in. x 11 in.)
Portrait
Other
c5052
Excel Payment Voucher Template
Thursday, May 29, 2014,
12
5
A4
Portrait
Receipt
c4084
Job Estimate Template for Excel
Wednesday, August 17, 2016,
10
4
Letter (8-1/2 in. x 11 in.)
Portrait
Other
c1004
Donation Receipt Template for Excel
Monday, August 22, 2016,
8
1
A4
Portrait
Receipt
c4070
Labor Invoicing Sample
Wednesday, May 11, 2016,
8
4
A4
Portrait
Service
c4071
Parts and Labor Invoicing Format
Thursday, May 12, 2016,
18
4
A4
Portrait
Sales
c5087
Excel Shipping Invoice with Printable Truck Background Image
Friday, July 8, 2016,
16
5
A4
Portrait
Sales
c4100
Invoicing Template in Euros
Tuesday, November 29, 2016,
12
4
A4
Portrait
Sales
c5091
Hotel Guest Folios with Satisfied Business Traveler
Thursday, July 28, 2016,
7
5
A4
Portrait
Receipt
c2026
General Purchase Invoice Template (Service, One Tax)
Thursday, January 21, 2016,
6
2
A4
Portrait
Service
c5007
Invoice with Previous Balance (Sales)
Friday, November 8, 2013,
12
5
A4
Portrait
Sales
c5094
UIS V5.11 Standard Invoice Template and Shortcut Keys
Thursday, September 29, 2016,
12
5
A4
Portrait
Sales
c2009
Plumbing Contractor Invoice Template (Landscape)
Wednesday, May 14, 2014,
6
2
A4
Landscape
Service
c4098
Sales Invoicing Format for Germany
Sunday, November 20, 2016,
12
4
A4
Portrait
Sales
c7008
Work Order and Processing Sheet Practical Sample
Tuesday, March 14, 2017,
16
7
A4
Portrait
Other
cn003
Service Invoicing Template
Saturday, October 19, 2013,
12
x
A4
Portrait
Service
c9005
Commercial Template Sample - Complete Incoterms Option
Monday, November 30, 2015,
9
9
A4
Landscape
Pro-forma

What Is Hot

Feature Galleries