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.
Running a jewelry store that sells rings, necklaces, bracelets, earrings, charms, watches, or assorted / personalized jewelry products? Download this free billing template to create beautiful invoices and receipts in Excel and PDF format.
As a jeweler you know how important it is to make your products elegant and to provide professional service to your customers. Do you notice your receipts and bills? They may be the last chance that you can express your business. Applying a professional and special jewelry receipt to your customers and clients to let them know you are caring about your business to even every small detail.
This free Excel template for jewelry store is created based on c4011 Receipt Format for Gold Shop (first sample). As detailed on the Creating and Designing an Invoicing Template document, the Excel spreadsheet template must be created based on the default template shipped with Invoice Manager for Excel (UIS) or any variant based on that template. This is because a template that works with UIS should include a number of required fields in order to functional properly, such as the link to backend Microsoft Access or SQL Server database. See Invoicing Software For Jewellery Shop for more samples on this topic.
So when we need to design a new form layout for a specific industry application, we started from looking for a similar Excel template that are already published here on InvoicingTemplate.com. This is true to the bill format for jewelry store too. If you are familiar with Microsoft Excel, you can do the customizations too, by following the tips and guidelines given in the Creating and Designing an Invoicing Template document.
This template features a watermark / background of jewellery. Unlock templates in Microsoft Word (".doc" or ".docx" files), where you can make the watermark / background visible even in the editing mode, the background added to an Excel worksheet is not visible in the editing mode. It takes effect only on the printed document, or the PDF invoices generated with UIS. This makes the form as clean as possible when you need to fill in data.
Like the original design for gold shop, this template does not include the customer details on the printable form. It includes on tax on the bottom of the form with the general name "TAX". If you want to rename it to something like "VAT" or change the default rate, clicking the "Settings" button, and then go to the "Taxes" tab.
The templates includes 12 rows on the detail section, each of the row allows you to enter multiple lines of text to description the items. Gems are expensive so usually it is important to describe the item as detail as possible, whether it is bracelet, diamond, earring, gemstone, necklace, ring, wedding & engagement ring.
The "ITEM#" column placed on the left-most column of the worksheet is functional if you have Invoice Manager for Excel installed. On creating a receipt or invoice, you enter the Item# / SKU# / barcode# into this cell, the corresponding description and unit price is automatically retrieved from the backend database. This saves you time and prevent typo errors. This feature is called "in-cell lookup" in Invoice Manager for Excel. You can turn this feature on or off on the "In-cell lookup" page of the "Settings" dialog box.
As you can see, by using UIS, the simple Excel workbook template becomes a powerful receipt generator. There are more it could help you on creating and managing receipts. So feel free to download the fully functional trial version and see how it works for you.
Format and Specification
|Name||Jewelry Receipt Template|
|Release Date||Friday, November 11, 2016|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||34.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|System||Windows 7 and later, and Excel 2007 and later.|