BoostExcel main content


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.

Description Size Download

Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

1460 KB Download

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

6.67 MB Download

Screenshots and Images

The printed version.

Invoicing Sample for Cosmetics Shops

Open the template in Excel.

Invoicing Sample for Cosmetics Shops (IMFE Edition)


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 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 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 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.

Format and Specification

Template# c4095
Name Invoicing Sample for Cosmetics Shops
Category Sales Invoice Template
Release Date Saturday, October 29, 2016
Format (XLS or XLSX) .xlsx
Columns 4
Lines 12
Line Height (Points) 18.00
Print Area $D$3:$K$47
Papaer Size / Orientation Portrait
Default Margins (Points)
Left 18.00
Right 18.00
Top 75.60
Bottom 75.60
Price Free (0.00 USD)
System Windows 7 and later, and Excel 2007 and later.

Update History

September 24, 2018

  • Updated the Sales Report for cosmetics.xlsx.