Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Welding Invoice Template. Double-click the downloaded file to extract all files.
  2. Open the template "weldinginvoice.xlsx" or "weldinginvoice-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Welding Invoice Template

Welding Invoice Template (c8003)

This is how the template looks like when you open the freeware template in Microsoft Excel.

Welding Invoice Template - freeware edition

Welding Invoice Template - freeware edition

The following template was designed for Uniform Invoice Software version 3.

Welding Invoice Template - Uniform Invoice Software V3 edition

Welding Invoice Template - Uniform Invoice Software V3 edition

Download Welding Invoice Template (c8003)

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

319 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.80 MBDownload

Detail

If you are running your own welding and fabrication business, this serial of free welding invoice templates is designed for you as a welder or manager. We have various formats and layouts here to help you create professional-looking welding invoices and receipts easily.

All our templates are offered to you by InvoicingTemplate.com online in Microsoft Excel spreadsheet format, including this Welding Invoice Template. Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphing tools, pivot tables, and as a part of Microsoft Office - the other famous Office programs includes Word, PowerPoint and Access. It has been the industry standard for spreadsheets, and thus being an ideal maker and format for creating electronic (paperless) fillable, editable and printable sales orders, purchase orders, estimates, invoices, quotes, letters, brochures, receipts, time sheets, statements and other business forms. Our templates, including Welding Invoice Template, are also available in blank downloadable PDF format. We are also providing Uniform Invoice Software, which utilizes these templates and offer powerful processing and management features.

Welding Invoice Template includes a number of custom fields compared to the default sales invoice template included in Uniform Invoice Software.

Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. Welding Invoice Template uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Welding Invoice Template without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

InvoicingTemplate.com is also offering you other welder invoicing templates. c5064 Simple Welding Invoice Template, which contains only 5 columns, giving you the most fillable fields on the form; and c8004 Welding and Fabrication Service Invoice Template, which simplify the calculation of pricing plans. With c7021 Welder Invoicing Template, we moved the shipping address section back into the printable range, and moved out the Type column to give more space to the Description column. With c6017 Welding / Fabrication Tax Invoice, we moved the Dimension column out of the printable area, and moved in the taxable column so that it is included in the printable invoice.

In order to detail the welding and fabrication job that has done, this free template has a number of custom fields added to the template. One custom fields added to the Customer database table is WhoTaxID, which replace the default CustomerID appears on the "Bill To" section, and the original CustomerID cell was moved out of the printable invoice area.

The Product database table has 3 custom fields defined. The first is ItemType, which as the definition of text(50), and is designed for you to detail the type of the invoicing item, such as 304 Stainless, 6061 Alum, A36 Steel, Alloy, Aluminum, Brass, Cold Finish, CR Steel, Ea., Electric Arc, Grade 60, HR Steel, Metal Saw, Metal Shear, MIG Wire, Mild Steel, Other, Polished Steel, Seamless, Stainless, Steel, Steel Galv., Store Item, Tig/Mig, Torch, Tungsten and Weld Fab Shop. Note that there is also a Category field defined in the Product table, which allows you to categorize invoicing items - a possible category list is: Abrasive, Angle, Beam, Channel, Flat, Hardware, Metal, Misc. Supply, Pipe Fitting, Pipe Stainless, Pipe, Plate Alum, Plate S.S., Plate, Round, Saw Service, Service, Shear Service, Sheet Alum, Sheet, Square, Store Item, Trailer, Tube Alum., Tube DOM, Tube EWT., Tube Rec., Tube S.S., Tube Sq., and Welding Service.

The second custom field defined in the Product table is UM, which means Unit of Measure, and the sample values could be "Ea.", "Hrs.", "Inch.", "lbs.".

The third custom field defined in the Product table is WeightPerFtPerSqFt, which is a decimal value, and is retrieved and filled into the corresponding Excel cell when an item is picked on invoicing.

All the 3 custom fields defined the Product database tables are also added to the Invoice Body database table. The Invoice Body database table also has two other custom fields defined, which are Dimension and Units. Both of them are text fields. The "Dimension" field is used for custom entry for size purchased". The "Units" column multiplies entry in column "Foot, Shear Cut Inches, Flame Cut Inches" or "SQ.FT." or "INCHES" by "weight per ft." in column "Weight Per Ft . Sq.Ft.", which is archived by using a formula like this:

=ROUND(IF(AG23>0,AG23*oknQuantity_1,
IF(AH23>0,AH23*oknWeightPerFtPerSqFt_1*oknQuantity_1,
IF(AI23>0,AI23*oknQuantity_1/12*oknWeightPerFtPerSqFt_1,0))),3)

Adding a custom field to the Product table in the database makes it possible to save the field value to database along with the other data of a product. For example, adding the custom field "Product Type" to the Product database table allows you to save the type, such as "General" or "Labor", to the database when you save a product or item. If you use Uniform Invoice Software version template Welding Invoice Template and add the custom field to the spreadsheet, the value is retrieved whenever you pick up a product on creating an invoice.

Adding a custom field to the "InvBdy" database table makes it possible to save the data on the invoice spreadsheet to database when the "Save To DB" button is clicked. For example, adding the custom field "Product Type" to the "InvBdy" database table allows save the type value on the invoicing form, such as "General" or "Labor", to database when you save an invoice by clicking the "Save To DB" button. This feature is not supported in the freeware edition of Welding Invoice Template.

The Invoice Header database table holds 8 custom fields in this design. They are Discount, Insurance, Job Name, Order By, Other, Other Name, Shipping Tax ID, Who Tax ID. All these fields are mapped to cells on the invoicing form, by naming the cell with "okn" plus the database field name. For example, the cell that is mapped to the "Order By" database field is named oknOrderBy.

One thing that is quite important is the numbering system. If you do repeated business with a company, they might track invoice numbers. If number are duplicate they might kick it out and delay payment. If you have Uniform Invoice Software installed, the invoice numbers (invoice#) will be automatically generated when the "Save To DB" button is clicked, based on the rules you defined.

There is also a comment on the bottom of the invoicing form, which reads as follows.

Price in effect applies at the time of order and subject to availability. ***% per month service charge applied to accounts past *** days. Annual rate of ***%. All claims and returned goods require original receipt. Price in effect applies at the time of shipment. Quotes Valid for *** days. Prices are subject to change without notice.

Note that you have to replace the placeholders "***" with proper content, or you can delete the comment altogether.

The "Received By" field on the bottom of the invoice form is for manually signature on the printed invoice. You can remove this from your own invoice layout if you send only electronic invoices.

Like other form designs here on InvoicingTemplate.com, Welding Invoicing Form 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.

Format and Specification

Template#c8003
NameWelding Invoice Template
CategorySales Invoice Template
Release DateSunday, September 21, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Columns8
Lines20
Line Height (Points)15.00
Print Area$G$2:$R$53
Printable with Papaer Size / OrientationLetter (8-1/2 in. x 11 in.) - Portrait
Default Margins (Points)
Left18.00
Right18.00
Top61.92
Bottom0.00

Sample Templates