Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

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

Excel Payment Voucher Template

Excel Payment Voucher Template (c5052)

c5052 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open paymentvouchertemplate-uis.xlsx.

Excel Payment Voucher Template (UIS Edition)

Excel Payment Voucher Template - UIS edition

Download Excel Payment Voucher Template (c5052)

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.

254 KBDownload

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

2.80 MBDownload

Detail

Excel Payment Voucher Template is a editable sample voucher template created from Payment Voucher Template (Golden Shop). It differs from the original voucher template in that this sample Excel voucher template is suitable for general business.

Are you a small business owner? If so, you know just how important a payment voucher can be when making purchases or paying for services. This general purpose payment voucher template in Microsoft Excel spreadsheet format can help you create a voucher that is professional looking and easy to understand. Excel Payment voucher template is daily use document for every kind of sealing and purchasing businesses and payment voucher template is a designed format of professional voucher. All you need to do is download the free voucher template and open it using Microsoft Excel 2003 or later version and then update important info such as company's logo contact details.

InvoicingTemplate.com also offers the Uniform Invoice Software version of this Excel Payment Voucher Template / receipt template. The Uniform Invoice Software version is also free if you have Uniform Invoice Software installed, and it has exactly the same layout as the freeware edition of the Payment Voucher Template, but with many buttons on it, such as "Clear & New", "Save To DB", "Exact / Email", "Print". Uniform Invoice Software, as the name suggests, is our invoicing software that has the ability to make any invoicing templates available here on InvoicingTemplate.com a complete invoicing program that is able to manage customers, products, invoices and payments. For example, if you click the "Clear & New" button, the payment voucher form is cleared and is ready for you to enter a new payment voucher, with several fields filled with default data - for example, the current date is filled into the "Date" field. If you click "Save To DB", the current voucher is saved to backend database and a voucher# is generated automatically. If you click "Exact / Email", a standard Excel spreadsheet is created and the current voucher is copied to the newly created Excel spreadsheet file, which you can email to your client. You can also create a PDF voucher document using Microsoft Excel.

The original voucher template, Payment Voucher Template (Golden Shop), has a custom field Weight defined in both the Product and Invoice Body database tables. With this general purpose Excel Payment Voucher Template, InvoicingTemplate.com removed the Weight custom field from it and made it a general purpose voucher template.

This Excel payment voucher template contains 4 fields on the bottom of the voucher form, there are Discount, Total, Advance, and Balance. Both "Discount" and "Advance" are manually editable fields. "Total" is calculated from the sum of all the line totals subtracted by discount; "Balance" is calculated from Total subtracted by "Advance". If you prefer a voucher template that does not have the advance field, take a look at Cash Payment Voucher Template.

If you use the Uniform Invoice Software edition, note that the "Discount" and "Advance" are custom fields.

Note that there is a default Logo image on the top of form, which you must replace with your own logo image. To do this, unprotect the Invoice worksheet, and then switch to design mode.

The protection of the "Invoice" worksheet in Excel Payment Voucher Template prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in Excel Payment Voucher Template.

In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Excel Payment Voucher Template. Note that if you have our invoicing program installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products, bills and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.

  • In Excel 2003 click the Design Mode button on the Control Toolbox toolbar. Tip: If the Control Toolbox toolbar is invisible, click Excel menu View > Toolbars > Control Toolbox.
  • In Excel 2007, Excel 2010 and Excel 2013, click the Design Mode button in the Controls group of the Developer tab.

    TIP: If the Developer tab is not available in Excel 2007, do the following to display it: a) Click Microsoft Office Button, and then click Excel Options; b) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

    Or in Excel 2010 and Excel 2013 to display the Developer tab: a) Click File > Options > Customize Ribbon; b) In the area on the right, ensure that the box next to Developer is checked; c) When you click OK, the Developer tab will appear in the ribbon.

Once you have finished your design work for Excel Payment Voucher Template, click the Design Mode button again to exit design mode.

(Note that if you have installed the latest version of our invoicing software, Uniform Invoice Software, which is able to upgrade a simple template in Microsoft Excel spreadsheet format into a complete invoicing system, you don't have to replace the logo image manually - you can replace the default logo image by clicking the "Replace Logo Image" button on the ribbon tab in Excel 2007, Excel 2010 and Excel 2013). To replace the default LOGO image in Excel Payment Voucher Template with your own image, follow the steps below:

  • Right click the Logo image, and then select Properties from the menu.
  • Click the Picture property, and then click the "..." button.
  • Browse to the folder containing your icon file. Select and open the icon file.
  • Close the Properties dialog box.
  • Drag the border of the image object to resize it, if needed.

If you don't need the LOGO image and want to delete it, simply hit the DEL key on your keyboard after you selected it with your mouse key. Deleting the LOGO image leaves an empty area to the left of the Company Information section. You may like to move the entire Company Information section to fill in the empty area. To do this: Drag your mouse to select the entire Company Information area, including Company Name, Street Address, City, ST Zip Code, etc.; Push your mouse key on the border of the selected area; drag it to the new location.

The voucher# field is a must-filled-in field. It should be filled with a unique (and usually consecutive) value. If you use Uniform Invoice Software, the voucher# could be generated automatically by clicking the "Save To DB" button.

Payment voucher is a business document that is given to the customers and clients for any purpose. Companies used this document to given discount to their prospective customers when people purchased any products and items in company and markets. Business people and sales manager use this voucher for increasing the sale of the products and services. InvoicingTemplate.com offers several variants of the voucher templates. Be sure the check them and find the one that meets your business requirements.

Like other form designs here on InvoicingTemplate.com, Payment 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#c5052
NameExcel Payment Voucher Template
CategoryReceipt Template
Release DateThursday, May 29, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines12
Line Height (Points)19.50
Print Area$D$3:$K$41
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left50.40
Right50.40
Top75.60
Bottom75.60

Update History

August 15, 2016

  • Use Microsoft Excel theme-based colors. This way, you can easily change the colors used on the template by going to the "Page Layout" ribbon tab, and then choose the options on the "Themes" group.
  • Use "Bell Gothic Std Light" and "Bell Gothic Std Black" fonts.

Sample Templates