BoostExcel.com main content

Download

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 the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

396 KBDownload

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

5.94 MBDownload

Screenshots and Images

The printed version.

Receipt Template for Gold Shop (1)

Open the template in Excel.

Receipt Template for Gold Shop (1) (IMFE Edition)

Detail

Receipt Template for Gold Shop is a free blank receipt template and cash receipt template designed especially for gold shop. The template has a Rate field outside of printable receipt form, with which you can specify the current unit price of gold.

The free receipt template does not include "Bill To" and "Ship To" section inside the printable receipt form. The two common sections that appear on almost all free invoice templates available here on InvoicingTemplate.com, the "Bill To" and "Shipping To" sections, are moved out of the printable receipt form. If you have tried Invoice Manager for Excel, you probably have noticed that the information appear in the "Bill To" sections are required - especially the Customer# field. If the Customer# is blank when the "Save To DB" command is being clicked, Invoice Manager for Excel shows a warning message and refuse to save the invoice to database.

So how we make it possible to save a receipt in Invoice Manager for Excel without manually filling in customer/client information? The secret is simple. Remember we are using Microsoft Excel that has a unique feature called Excel formula, which does not exists in Microsoft Word. By using Excel formula, we can easily assign default values (or place holder values) to those fields that must be filled according to Invoice Manager for Excel, but not used in this money receipt template.

For example, after moving the "Bill To" section out of the printable receipt form, we assign the formula (="PSName001") to the client name of the receipt, and assign the formula (="ps001") to the client# cell. Both Excel cells are then locked to prevent accidental modifications to the formula. Since the gold shop does not use or record these information, we can in fact assign any default values to these required cells.

The discount field located on the bottom of the free receipt template allows you apply a discount to the whole receipt. The payment receipt template does not include tax fields on the bottom of the form.

The cash receipt template also has a "Making Charge" column outside the printable receipt form. It is a common practice for gold shops to add a making charge to the base cost (unit price * weight). So in this receipt the cost of each item is in fact calculated with the following formula: Weight * Rate + Making Charge. If you are running a gold shop, feel free to download and test the free receipt template to see it meets your requirements.

InvoicingTemplate.com also offers you variants of this receipt template, see Receipt Template for Gold Shop (2), which has the Making Charge column placed inside the printable receipt form; and Receipt Template for Gold Shop (3), which as the Rate cell moved into the printable receipt form; and Receipt Template for Gold Shop (4), which as both the Rate and Making Charge column moved into the printable blank receipt template.

Format and Specification

Template#c4011
NameReceipt Template for Gold Shop (1)
CategoryReceipt Template
Release DateTuesday, December 24, 2013
Format (XLS or XLSX).xlsx
Columns4
Lines12
Line Height (Points)19.50
Print Area$D$2:$M$45
Papaer Size / OrientationPortrait
Default Margins (Points)
Left36.00
Right36.00
Top72.00
Bottom72.00
PriceFree (0.00USD)
SystemWindows 7 and later, and Excel 2007 and later.

Update History

December 1, 2016

  • Removed unnecessary "pick an item" buttons from the Excel worksheet, as now Uniform Invoice Software supports a live on-sheet picker which pops-up whenever you click a supported cell.
  • "oknWidget_logo" is now a standard Excel "Picture" object, instead of an ActiveX Image control.
  • Applied "Bell MT" font-style.
  • Expanded the size of "Receipt#" and "Receipt Date" cells.