The printed version.
Invoicing Sample for Cosmetics Shops (c4095)
c4095 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open cosmetics-uis.xlsx.
Invoicing Sample for Cosmetics Shops - UIS edition
You are safe to download the resources. We've added our digital signatures to the files.
Without database file. How to download and use
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.
Download this free Excel bill sample for vendors, stores, retailers and wholesalers that are specialized in cosmetics and makeup. The template (".xlsx" file) features auto calculation and a cosmetics background picture.
The itemized detail section in the sample invoicing template allows you to list the products a customer purchased, for example "Dermactin-TS Collagen Gel Patches", "Dermactin-TS Anti-Wrinkle Eye Cream" etc. Whether you are a reseller or wholesaler, you can use the "Products" database table to manage your product / inventory. By default Uniform Invoice Software connects with Access database (you don't have to install Microsoft Access in order to just use the database), but Enterprise edition of Uniform Invoice Software supports SQL Server database too. For SQL Server, you can even run it online and access your data anywhere around the world via an Internet connection.
This sample is implemented as a sales invoicing template. For stores that don't ship goods, and you need more lines on the detail section, you can move the "Shipping To" section out of the printable invoicing form, and then adjust the layout of the "Bill To" section to leave space for the detail section.
With Uniform Invoice Software installed, there are several ways you can pick items on creating invoices.
Firstly you can use the "on-sheet picker" button which appears next to the active Excel cell. Clicking the "on-sheet picker" button pops up a list of active products / items that you are selling. Above the product list you'll also find a search bar which allows you to filter / search the product list with any property belongs to a product, such as product# (SKU#, barcode etc.), product name and unit price etc. The search bar allows you to enter only part of the item name. For example, if you specify the search criterion "contains words" for the field "Product Name", and then enter the search word "eye cream", all products contains that word will be listed.
The second way to quickly fill in items into the invoice or bill is that you can enter the product# (this could be your SKU# or barcode retrieved with a scanner) into the "Product ID" field, which is put outside the printable form.
For cosmetics stores and shops where the bills are usually paid using cash or credit card on the spot (in this case, it is commonly referred as a receipt), the "Paid" and "Total Due" cells are usually not required on the bills. For a wholesaler, an invoice may be paid after the cosmetics shipped. In this case, you may like to move the "Paid" and "Total Due" cells into the printable form.
Like other form designs here on InvoicingTemplate.com, Billing Template for Cosmetics Shops 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||Invoicing Sample for Cosmetics Shops|
|Category||Sales Invoice Template|
|Release Date||Saturday, October 29, 2016|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||18.00|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|