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

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.

497 KB Download

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

6.27 MB Download

Screenshots and Images

The printed version.

Receipt Template for Gold Shop (2)

Open the template in Excel.

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

Detail

Receipt Template for Gold Shop (2) is a variant of Receipt Template for Gold Shop (1). This free receipt template differs from the original one in that Marking Charge is now moved into the printable receipt form.

The cash receipt templates here on InvoicingTemplate.com calculates the line total of each item being sold by using the formula: Weight * Rate + Marking Charge. Both free receipt templates, Receipt Form for Gold Shop (1) and Receipt Form for Gold Shop (2), use the same formula for calculating line total.

However with Receipt Form for Gold Shop (1), the Marking Charge column is placed outside the printable receipt form. This means that, although you can fill in the marking charges manually into the fields, and the Excel formulas with add making charges to line totals without problem, the making charges will not show on printed invoices, or extracted invoices if you are using Invoice Manager for Excel.

If you are one of those gold shop owners who want to display making charges clearly on invoice for each item being sold, this customized free receipt template is for you. With this Receipt Form for Gold Shop (2), we move in the marking charge column into the printable receipt form, so that it shows on both the printed receipts and extracted receipts in case you are using the Invoice Manager for Excel version.

To create the receipt sample there are 3 main steps - unprotecting the Invoice worksheet, adjusting the existing column to leave space for the new column, moving in the Making Charge column.

There is no need to adjust the formulas on this customized receipt template, as the formulas defined in the original receipt template work fine for this new receipt template.

Format and Specification

Template# c5042
Name Receipt Template for Gold Shop (2)
Category Receipt Template
Release Date Wednesday, December 25, 2013
Format (XLS or XLSX) .xlsx
Columns 5
Lines 12
Line Height (Points) 21.75
Print Area $F$3:$N$42
Papaer Size / Orientation Portrait
Default Margins (Points)
Left 36.00
Right 36.00
Top 72.00
Bottom 72.00
Price Free (0.00 USD)
System Windows 7 and later, and Excel 2007 and later.

Update History

February 5, 2018

  • Applied the "light-yellow" color style.
  • Moved the logo placeholder image "InvoicingTemplate.com" to the center-bottom of the printable receipt form.
  • Deleted all the "select-a-product" buttons.
  • Fine-tuned the line heights to make it suitable for a full-page A4-paper.