Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Cash Payment Voucher Template. Double-click the downloaded file to extract all files.
  2. Open the template "cashvouchertemplate.xlsx" or "cashvouchertemplate-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.

Cash Payment Voucher Template

Cash Payment Voucher Template (c5053)

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

Cash Payment Voucher Template - freeware edition

Cash Payment Voucher Template - freeware edition

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

Cash Payment Voucher Template - Uniform Invoice Software V3 edition

Cash Payment Voucher Template - Uniform Invoice Software V3 edition

Download Cash Payment Voucher Template (c5053)

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.

282 KBDownload

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

2.78 MBDownload

Detail

Cash Payment Voucher Template is a sample voucher template created from Excel Payment Voucher Template and Payment Voucher Template (Golden Shop). Draft beautiful and professional cash payment vouchers with this blank cash payment voucher template.

The download page offers both a freeware edition and a Uniform Invoice Software edition of this cash payment voucher template and receipt template. The two free templates has exactly the same layout and format, except that the Uniform Invoice Software has many buttons on it that will be functional and go alive once you install Uniform Invoice Software. A PDF version of this cash payment voucher template could also be downloaded here.

Cash Payment Voucher Template contains 5 columns (item#, description, quantity, price, and amount) and no "Advance" field on the bottom of the form. The "Discount" field on the bottom of the voucher form is a custom field - meaning that the default sales invoice template (the origin of all the templates available here on InvoicingTemplate.com) does not contain this field. In order to be able to give discount to customers, all the payment voucher templates in this serials include the discount custom field, which is defined in the Invoice Header database table.

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. Cash Payment Voucher Template 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 Cash Payment Voucher Template 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 Cash Payment Voucher Template, 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 Cash Payment Voucher Template 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.

Naming a cell is easy in Excel, no matter you are using the free edition of Cash Payment Voucher Template or the Uniform Invoice Software edition of Cash Payment Voucher Template, and the process is the same no matter which Excel version you are using - Excel 2003, Excel 2007, Excel 2010 or Excel 2013. To name a cell, after opening Cash Payment Voucher Template firstly make the sheet is not protected, and then click the cell you want to name (or drag your mouse to select the range you want to name), and then enter the name into the name box on the formula bar. Note that Excel does not allow you to reuse an existing name in this way. For example, if a cell has already been named "oknTaxType" in Cash Payment Voucher Template, and you click and select an empty cell then enter the name "oknType" into the name box, Excel activates the cell with the name "oknTaxType" in Cash Payment Voucher Template, instead of naming the empty cell "oknTaxType". To name a new (empty) cell with an existing name, you have to firstly delete the exiting cell name, and then use this name to name the new cell. To delete an existing cell name, in Excel 2003 click Excel menu Insert > Name > Define to open the Define Name dialog box; in Excel 2007, 2010 and 2013, the Name Manager can be launched by going to the formulas ribbon tab, Defined Names group.

Note that custom fields is a powerful feature introduced by previous version of Uniform Invoice Software (UIS), i.e. Excel Invoice Manager. The support for custom fields in Excel Invoice Manager requires a database definition file ("FDINFO10.rst") to be present in the folder where the database file was installed. With UIS, using custom fields is much simpler than in Excel Invoice Manager, and the database definition file is no longer required.

One thing to note is that InvoicingTemplate.com tested the templates, including Cash Payment Voucher Template, on Microsoft Windows (with Excel, not Word) only, and the testing on Mac was usually not performed. If you need to run Cash Payment Voucher Template on Mac, test it with Mac version of Microsoft Excel before you apply it for production purpose.

To change the currency symbol of Cash Payment Voucher Template, first make sure you've unprotected Cash Payment Voucher Template spreadsheet. Select the cells (fields) for which you want to modify the currency symbol, by dragging your mouse to select multiple cells on Cash Payment Voucher Template, you push CTRL key on keyboard and click each cell on Cash Payment Voucher Template one by one, and then right-click one of the selected cell and choose Format Cells. From the Number tab, you can choose either "Currency" or "Accounting" from the Category list. Note that currency formats are used for general monetary values, you should use accounting formats to align decimal points in a column.

Like other form designs here on InvoicingTemplate.com, Cash Voucher Template is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

Template#c5053
NameCash Payment Voucher Template
CategoryReceipt Template
Release DateFriday, May 30, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Columns5
Lines12
Line Height (Points)19.50
Print Area$E$2:$N$40
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates