Assuming you have downloaded and installed Uniform Invoice Software:
Prefer to have a look at other samples? Try our Search tool!
The printed version.
Clothing Store (Manufacturer) Invoice with Size Breakdown (cm003)
cm003 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open clothing-invoice-template-size-breakdown-uis.xlsx.
Clothing Store (Manufacturer) Invoice with Size Breakdown - UIS edition
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 invoice template has 11 columns on the invoice detail section (invoice body) that allow you to itemize the sizes of clothes sold out. Clothing stores and manufacturers could use this template for creating professional invoices.
We've already published an invoice receipt template for clothing stores and shops here on InvoicingTemplate.com, at Free Clothing Shop Receipt (c6001). It is also available on our company web site, at Clothing Store Invoice Template. The c6001 template has a "Size" column where a clothing or company could specify the size of each item like "XS", "M" or "L" etc. The "size" column in c6001 is implemented as a general purpose text column that allows any input. This means the c6001 template could be used by any other stores and manufacturers too that have the need to detail the size information of each product / item sold.
This implementation, cm003 (Clothing Store (Manufacturer) Invoice Template with Size Breakdown) goes one step further by breakdown the size column into 5 columns, with columns headings "0-2 XS/P", "4-6 S", "8-10 M", "12-14 L" and "16-18 XL". The "Quantity" column is also provided that calculates sum of all the size breakdowns using Excel formula. As a general rule of creating / customizing invoice template, a cell with formula assigned to it cannot be editable when you create an invoice (see the tutorial movie). To archive this goal we have set all the quantity cells to be locked.
If you need to set "Lock" property yourself on designing an invoice template (to prevent Excel from showing a warning on the cells that have formulas when the spreadsheet is protected), first you have to switch the template into design mode by clicking the "Design Mode" button on the "Invoice" worksheet, and then drag your mouse to select all the cells which you want to set the "lock" property for. And then, right-click one of the selected cells and then choose "Format Cells". On the "Protection" tab, check or uncheck the "lock" property to make the cells editable / not editable when the spreadsheet is protected.
Clothing Store (Manufacturer) Invoice Format with Size Breakdown has other two columns that designed specifically for clothing store and manufacturers that are "Style #and Color". The actual usage of these fields could vary from business and business, but general speaking, they allow you to further detail the items and products you are selling.
There is also a "Discount" field on the bottom of the form, which is implemented as an amount value. The form firstly calculates the subtotal (cell name "oknSubtotal") using Excel formula "=SUM(oknLineTotal_1:oknLineTotal_12)", and then calculates Total (cell name "oknTotal") using Excel formula " =ROUND(oknSubTotal - oknDiscount + oknShippingCost + IF(oknTaxType = 0,0,IF ( oknTaxType = 1,oknTax1, oknTax1 + oknTax2 )), 2)". This is one of the advantages of using Excel formatted invoice templates as you can easily using formulas to define the relationships between cells and fields.
The "Discount" field and all the clothing business-specific fields, such as "Color", and all the size breakdown fields, are all not defined in the standard invoice template shipped with Uniform Invoice Software installer program. They are implemented as custom fields (also called user-defined fields) added to either invoice header or invoice body database tables.
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 Clothing Store (Manufacturer) Invoice with Size Breakdown.
Different businesses have different invoicing requirements. For a clothing store or manufacturer, the new fields (custom fields) added in this invoice template could be useful in many situations.
Like other form designs here on InvoicingTemplate.com, Clothing Store (Manufacturer) Format with Size Breakdown 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||Clothing Store (Manufacturer) Invoice with Size Breakdown|
|Category||Sales Invoice Template|
|Release Date||Monday, June 27, 2016|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||19.50|
|Printable with Papaer Size / Orientation||A4 (210 mm x 297 mm) - Portrait|
|Default Margins (Points)|
October 12, 2016
This invoicing template for clothing stores or manufacturers is a variant of cm003 Clothing Store (Manufacturer) Invoice Template with Size Breakdown. It differs from the original edition in that this variant adds back the buttons that you can click to pick up customer, shipping address, sales representative and payment term.
The previous invoicing templates designed for clothing stores (manufacturers) define a discount amount field. This new cloth bill format in Excel added a discount percentage field, as in many cloth shops discounts are given in percentage first.
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.
The default product report does not include sales representative name. This simple tutorial on customization demonstrates how to add the sales rep name to the product report by using custom fields.
This Excel Invoicing Template contains 84 lines on the invoice detail section and is printable on 4 pages of standard A4 paper. It also contains fields that are required on general sales invoices such as invoice#, invoice date, client details, shipping details, P.O.#, sales rep. name, payment term etc.
On our templates "City, State ZIP" are usually put into one single cell, like a U.S. style address line (There is an option for UK style postal code on a separate cell). This simple invoice template shows you how to extract and store separate city, state and zip.
If you are running a pet food store or shop then this invoice template could be used for easy invoicing. The invoice format is printable on standard A5 paper size (148 mm X 210 mm, or 5.83 inch X 8.27 inch). A PDF version of the invoice template is also included and downloadable.
In Australia tax invoices are usually issued by the supplier or seller. However Australian Taxation Office also allows the purchaser or recipient of the goods or services to issue tax invoice for the purchases, knowns as recipient-created tax invoices (RCTI).
This free sample invoice template in Excel format demonstrates how to add a remittance slip to the bottom of an existing invoicing template. The remittance slip / letter is printable with the invoice, so that the customer can be detached and sent along with the check.
A shipping packing list is also called delivery docket, it shows what goods included on shipment, also serve as a bill of lading. It is naturally close related to invoices. In this sample template we demonstrates how to create a packing list and an invoice within one same form.