Download

DescriptionSizeDownload

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:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
429 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

screenshot for Payment Voucher Template (Golden Shop)

Detail

This form is designed for golden retail shops that want to show the weight of each item.

Note for our app users: This voucher template (receipt template) does not keep customer records. This is achieved by assigning the same customer number (i.e., "A") to all clients. While the whole sales record is still kept when you click the "Save To DB" button on the worksheet, and this information is available when you try to generate reports from the database, the form does not distinguish between different customers because all customers are assigned the same customer number "A".

The form contains details about the mode of payment, item details, payer details, and receiver details. It also has the details of the date, day, and total amount. It is used to keep a record of all the payments that have to be made.

Being a customized voucher template for Golden Shops, this voucher template includes six columns in the detail section: item number, description, quantity, weight, unit price, and amount (Line total). The first five columns are manually editable, and the last column, Amount (Line total), is calculated with the formula like this:

=quantity * weight * unit price

At the bottom of the form, the fields include Discount, Total, Advance Payment, and Balance. This "Discount" field is an amount field, and the amount entered into it will be deducted from the Total. The "Advance Payment" field is also a manually editable field that indicates the advance payment from the customer, which is deducted from the "Balance" automatically. If you would like to use this template as a cash payment voucher template, move both the Advance and Balance fields out of the printable range and make the "Advance" field equal to "Total" by using an Excel formula.

A general-purpose cash voucher template is also available at Cash Voucher Template (c5053). If you are not running a golden retail shop, you may find a general-purpose version at Excel Payment Voucher Template (c5052).

Format and Specification

Template#c6004
Belongs to

Receipt

Format (XLS or XLSX).xlsx
Columns6
Lines18
Line Height (Points)19.50
Print Area$E$2:$N$40
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree