Summary

In case you cannot find your desired format with payment slip on it from the following list, you can still customizing other templates to create the payment slip or remittance slip by dragging and dropping, as detailed in the "Create and Customizing" document.

Invoice with Remittance Slip

This free sample invoice template in Excel format demonstrates how to add a remittance slip to the bottom of an existing invoicing template. The remittance slip / letter is printable with the invoice, so that the customer can be detached and sent along with the check.

Contractor Invoices with Remittance-slip

The duplicate "Bill To" section is created simply using Excel formula. For example, "Client Name" ($F$39) is filled with the Excel formula "=oknWhoName", where "oknWhoName" is the cell name / range name for a cell inside the "Bill To" section; similarly, "Address" ($F$40) is filled with the Excel formula "=oknWhoAddress", where "oknWhoAddress" is also the name of a cell inside the "Bill To" section. All these fields within the remittance slip section are filled automatically whenever you pick up a client manually, or with the on-sheet picker button, or by entering the client# into the "Customer#" field directly.

Excel Payment Voucher Template

InvoicingTemplate.com also offers the Invoice Manager for Excel (namely Uniform Invoice Software) version of this Excel Payment Voucher Template / receipt template. The Invoice Manager for Excel (namely Uniform Invoice Software) version is also free if you have Invoice Manager for Excel (namely 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". Invoice Manager for Excel (namely 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.

Packing Slip Template

Even we've added many new lines to the form design, it still works with UIS well. The trick here is that all cells that should work with the backend database are identified by names. All templates we published here on InvoicingTemplate.com adhere to this rule. For example, on the "Product#" column, the cells are named as "oknProductID_1", "oknProductID_2", "oknProductID_3", and so on.

General Waybill

Secondly you can use this template along with Invoice Manager for Excel (namely Uniform Invoice Software). By installing Invoice Manager for Excel (namely Uniform Invoice Software), the simple pure-Excel formatted waybill template become a complete waybill generating system. For example, it allow you to quickly fill in customer (receiver or shipping destination) information by choose from a pop-up window, or simply typing the customer#. Finding out an existing waybill is also much easier. By using search bar provided by Invoice Manager for Excel (namely Uniform Invoice Software), you can search for an existing document by looking for particular value in any fields that available in the waybill template / packing slip template.

Payment Receipt Template

Receipt plays important role in the verification process and in the process of audit. The standard invoice template included in the setup program of Invoice Manager for Excel (namely Uniform Invoice Software) already provided the details of payments, but they are put into hidden cells for the purpose of simplifying the form. A detailed tutorial on how to unhide the payment details section of the invoice form was originally published on office-kit.com, but now moved here at Receipt Form on InvoicingTemplate.com.

Packing List Template

The template has a default Logo image on the top-left corner. This is a placeholder for your own logo image. To replace it with your own logo, first switch to design mode and then right-click the default image and choose Properties. Click the button on the "Picture" line, choose the image want to use on this Packing List Template.

Cash Payment Voucher Template

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.

Service Invoice with Payment Advice

Although this is a very different format or layout than the default invoice template shipped with Invoice Manager for Excel (namely Uniform Invoice Software), the fact is that it is not so hard to customize default invoice form to create this one. The most important operation during the customization is the moving of cells and fields. Let's say you want to move the shipping section in the default sales invoice template out of the printable area, for example, here are the steps.