The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.
How to use:
This form is designed for gold shops. It has a Rate field outside of the printable section, with which you can specify the current unit price of gold.
This form has no "Bill To" or "Ship To" sections. The "Bill To" information is required for our app. To meet this requirement, we move the Bill To section out of the printable area and then assign a fixed value to the required fields.
For example, the formula for the client’s name cell looks like this:
The discount field allows you to apply a discount. This form does not have tax fields.
It has a "Making Charge" column outside the printable range. It is a common practice for gold shops to add a making charge to the base cost (unit price X weight). So the cost for each item is actually calculated with the following formula:
=Weight * Rate + Making Charge
- Receipt Template for Gold Shop (2) (c5042): The Making Charge column has been moved into the printable section.
- Receipt Template for Gold Shop (3) (c4021): The Rate cell has been moved into the printable section.
- Receipt Template for Gold Shop (4) (c5043): Both the Rate and Making Charge fields have been moved into the printable section.
Format and Specification
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||19.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|