Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Receipt Template for Gold Shop (3). Double-click the downloaded file to extract all files.
  2. Open the template "receipttemplategold3.xls" or "receipttemplategold3-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Receipt Template for Gold Shop (3)

Receipt Template for Gold Shop (3) (c4021)

This is how the template looks like when you open the freeware template in Microsoft Excel.

Receipt Template for Gold Shop (3) - freeware edition

Receipt Template for Gold Shop (3) - freeware edition

The following template was designed for Uniform Invoice Software version 3.

Receipt Template for Gold Shop (3) - Uniform Invoice Software V3 edition

Receipt Template for Gold Shop (3) - Uniform Invoice Software V3 edition

Download Receipt Template for Gold Shop (3) (c4021)

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.

DescriptionSizeDownload

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

325 KBDownload

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

2.81 MBDownload

Detail

Receipt Template for Gold Shop (3) is a variant of Receipt Template for Gold Shop (1). Receipt Template for Gold Shop (3) differs from the original free receipt template in that it moves the Rate field inside the printable receipt form.

The original free receipt template places the Rate cell outside the printable form. This may not satisfy you if you want to show the rate on the receipts. This customized receipt template move the rate field inside the printable receipt form.

All the invoice formats and layouts here on InvoicingTemplate.com are created based on the default sales invoice template shipped with Uniform Invoice Software, and many of them can be designed by moving fields and cells.

Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in Receipt Template for Gold Shop (3) before doing the movement. And, if the target location contains merged cells, sometimes the movement fails. So it is also helpful to make sure the target location does not contain merged cell. If the target location Receipt Template for Gold Shop (3) is overlapping the original range and the original range contains merged cells, the movement could also fail because you cannot change part of merged cell - if this happens, you need to first move the cells to a temporal location in Receipt Template for Gold Shop (3) that are empty (i.e. not used), unmerge cells, and then move the cells from the temporal location to the desired location. If you need to unmerge a cell, first select it and then click the "Merge and Center" command on the Format toolbar in Excel 2003; or click the "Merge and Center" command on the Home ribbon tab in Excel 2007, 2010 and Excel 2013.

If you use the Uniform Invoice Software version of this receipt template, the most interesting part of this receipt template is the definition of the Rate field. The rate field is defined as a custom field both on the database level, and on the receipt template level.

Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. Receipt Template for Gold Shop (3) uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Receipt Template for Gold Shop (3) without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

When working with Uniform Invoice Software (UIS) version of Receipt Template for Gold Shop (3), how does UIS know to which cell when a field value write to when loading data from the database, and to which field a cell value must save when saving an invoice record, a customer or a product item? That is, how does UIS create the map or relationship between Excel cells on the template Receipt Template for Gold Shop (3) and database fields? The answer is by using names. For example, if the field name in the Product table in a database is "ProductType", it is writing to a cell named "oknProductType_?" (where ? is the line number of the invoicing item) when you pick up a product or item on creating an invoice, and when saving an invoice, all cells with the name "oknProductType_?" are saved to the "ProductType" field in the "InvBdy" database table. By using cell names, UIS allows you to move a cell on the form without breaking the feature depending on the field / cell. You can place the "Product Type" column either inside the printable area, which is printed when you issue the Print command in Excel or click the Print command on the "Invoice" worksheet form; or place the Product Type column outside the printable area, which will be included when you print or extract an invoice or receipt.

So with just a few clicks and movements, we now got a new receipt template format and layout. If your gold shop prefers to show rates on your receipts, this is the format designed for you.

Like other form designs here on InvoicingTemplate.com, Receipt Form for Gold Shop (3) is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2003, 2007, 2010, 2013 or 2016.

Format and Specification

Template#c4021
NameReceipt Template for Gold Shop (3)
CategoryReceipt Template
Release DateMonday, December 30, 2013
Format (XLS or XLSX).xls
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns4
Lines12
Line Height (Points)19.50
Print Area$E$1:$N$44
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left36.00
Right36.00
Top72.00
Bottom72.00

Sample Templates