Skip to main content main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Invoicing Sample for Cosmetics Shops

Invoicing Sample for Cosmetics Shops (c4095)

c4095 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open cosmetics.xlsx.

Invoicing Sample for Cosmetics Shops (IMFE Edition)

Invoicing Sample for Cosmetics Shops - IMFE edition


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.


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

3.74 MBDownload

Without database file. How to download and use

503 KBDownload

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

876 KBDownload


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 Invoice Manager for Excel (namely 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 Invoice Manager for Excel (namely 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 Invoice Manager for Excel (namely 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, 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.

Format and Specification

NameInvoicing Sample for Cosmetics Shops
CategorySales Invoice Template
Release DateSaturday, October 29, 2016
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Line Height (Points)18.00
Print Area$D$3:$K$47
Papaer Size / OrientationPortrait
Default Margins (Points)

Update History

September 24, 2018

  • Updated the Sales Report for cosmetics.xlsx.