You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
Screenshots and Images
The printed version.
Open the template in Excel.
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.
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:
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 Invoice Manager for Excel 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.
Format and Specification
|Name||Welding Invoice Template|
|Category||Sales Invoice Template|
|Release Date||Sunday, September 21, 2014|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||15.00|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|Price||Free (0.00 USD)|
|System||Windows 7 and later, and Excel 2007 and later.|
August 27, 2018
- This template was updated to be compatible with UIS 6.