Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

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

Payment Voucher Template for B5 Paper

Payment Voucher Template for B5 Paper (c5086)

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

Payment Voucher Template for B5 Paper (UIS Edition)

Payment Voucher Template for B5 Paper - UIS edition

Download Payment Voucher Template for B5 Paper (c5086)

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.

307 KBDownload

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

2.78 MBDownload

Detail

The print result of an Excel form usually is usually not ideal if the paper size isn't what the Excel form designed for. This sample Payment Voucher Template for B5 Paper demonstrates how to adjust the form design for a changed paper size.

In this sample, we'll take Excel Payment Voucher Template (c5052) as the base template, which is designed for A4 (8.27 inch x 11.69 inch) in Portrait orientation, and make it suitable for B5 paper (7.17 inch X 10.12 inch) with Portrait orientation. During the customization, we'll remove the redundant controls / buttons from the form since with the latest version of Uniform Invoice Software, they are no longer needed.

Step 1: Before customizing the payment voucher layout, we'll first need to make a backup copy of the original design. It is also recommended to make a backup during the customization, so that it is easy and quick to return to a previous step in case something goes wrong.

Step 2: Open the voucher template as usual, switch to design mode by clicking the "Design Mode" button on the "Invoice" worksheet.

Step 3: Go to Excel "Page Layout" ribbon, in "Page Setup" group click "Size" and then choose B5 paper size.

Step 4: Click Excel menu "File", and then "Print". Excel shows in preview how many pages it required to print the current form. In this case, Excel shows that it requires two pages to print the original voucher form with the new B5 paper size.

Step 5: Inspect the preview image. On the vertical direction, without scaling one page height is enough to print the original form. On the horizontal direction, the width is not enough - by default it is able to print 4 columns only, but our payment voucher has 5 columns.

Step 6: Still in print preview mode, click the "Show Margins" button on the bottom-right corner. When "Show Margins" is pushed down, the preview shows drag handlers for margins and columns. Drag these handlers to resize margins and columns. Since we need space for only 1 column (the "Amount" column), it is possible to add it by reduce the width of the other columns. Once there is enough space for the missing "Amount" column, it appears automatically.

Like the original template, this new design does not use the customer account feature - that is, when run with Uniform Invoice Software, it does not distinguish between customers, and thus not keep customer accounting / bookkeeping data. We simply assign a letter "A" automatically to the field "oknWhoID" (database field "CustomerID" in both the "Customer" and "Invoice Header" database tables), so that Uniform Invoice Software will not create a new customer account. With this voucher format, The "Name" and "Address" field on the printable form is always manually entered (See all our editable invoicing templates).

With this template, we removed all the product / item buttons. They are no longer necessary because Uniform Invoice Software now supports the "on-sheet" picker button. When you enable this function, the invoicing software shows a small button automatically whenever you click a product / item row, allowing you to open the list of all products / items, where you can search and select one or multiple items.

Like all the other templates here on "invoice templates", Payment Voucher Format for B5 Paper comes with a PDF voucher template too. You can also visit all PDF invoice templates.

Like other form designs here on InvoicingTemplate.com, Payment Voucher Format for B5 Paper 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#c5086
NamePayment Voucher Template for B5 Paper
CategoryReceipt Template
Release DateTuesday, July 5, 2016
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$C$3:$L$41
Printable with Papaer Size / OrientationA5 (148 mm x 210 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates