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.
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
|Name||Invoicing Sample for Cosmetics Shops|
|Category||Sales Invoice Template|
|Release Date||Saturday, October 29, 2016|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||18.00|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|System||Windows 7 and later, and Excel 2007 and later.|
September 24, 2018
- Updated the Sales Report for cosmetics.xlsx.