Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Invoice Sample with Partial Payment and Payment History. Double-click the downloaded file to extract all files.
  2. Open the template "partial-payment.xlsx" or "partial-payment-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.

Invoice Sample with Partial Payment and Payment History

Invoice Sample with Partial Payment and Payment History (c5092)

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

Invoice Sample with Partial Payment and Payment History (UIS Edition)

Invoice Sample with Partial Payment and Payment History - UIS edition

Download Invoice Sample with Partial Payment and Payment History (c5092)

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.

293 KBDownload

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

2.77 MBDownload

Detail

Uniform Invoice Software supports partial payment. It is also able to payment historical record on the invoice form, although this feature was not noticed by many of the users. This sample template shows how.

When you open the default template integrated with the standard Uniform Invoice Software installer program, and then switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab, you may notice there are several hidden row between the "Total" section and the "Thank you for your business" label. To show these hidden rows:

  1. Open the template as usual (make sure you have backed it before customizing it).
  2. Click the "Design Mode" button on the "Invoice" ribbon tab.
  3. Drag your mouse to select the row headings between R40 and R47. This selection includes the hidden section that we'll make it visible.
  4. Right click one of the selected row heading and choose "Unhide" from the shortcut menu.
  5. The rows inside the hidden section are visible now.

This hidden section, titled with "PAYMENT DETAIL" includes a table with 5 columns - "Date" (cell name "oknPaymentCreatedDate"), "Total" (cell name "oknPaymentAmount"), "Applied" (cell name "oknPaymentTotalApplied", "Type" (cell name "oknPaymentTerm"), and "Notes" (cell name "oknPaymentNotes"). These columns match exactly the fields shown on the "New Payment" or "Edit Payment" window. The "New Payment" window is shown when you save a new invoice by clicking the "Save Invoice" command on the task pane, or by clicking the "Save To DB" command button (There is an option on the "Settings" window that you could use to turn off this feature).

So for example let's say the invoice total is $100.00, and the client firstly make a partial payment $30.00. When you show the invoice with the form, the "Payment Detail" section is filled with the related information too.

The default "Payment Detail" includes only 3 lines. That is by default this form allows you to show up to 3 partial payments posted to the invoice, including account credits. To show more lines:

  1. In design mode, right-click one of the row inside the "Payment Detail" section, R43, R44 or R45.
  2. Choose "Insert" from the menu. This inserts one row the section.

In this sample that you can download for free, we've added 2 more rows. So there are now 5 rows in total in the "Payment Detail" section.

This customization makes the form cannot be fit into one single A4 paper (most of the templates here on InvoicingTemplate.com are designed for 8 1/2 inch X 11 inch letter paper, or A4 paper). To fix this, we can hide some rows on the invoice detail section.

  • Drag your mouse to select row headings of R30, R31, R32 and R33 - 4 rows in total.
  • Right-click one of the selected row heading, choose hide.
  • Select all the cells of the last visible row (in this case, D29:K29).
  • Set a bottom-border for these cells.
  • The "Taxable" checkboxes of the hidden rows are still visible. You can safely delete these checkboxes. To do this, click one of the checkbox that is to be deleted, hit DEL key on keyboard.

Before finish, click Excel menu File / Print to preview the print result. Make sure the customized form, including both the invoice and partial payment sections, can be fit into the paper size specified. If no further modifications are needed, save the template.

Like other form designs here on InvoicingTemplate.com, Invoice Format with Partial Payment and Payment History 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#c5092
NameInvoice Sample with Partial Payment and Payment History
CategorySales Invoice Template
Release DateFriday, July 29, 2016
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Columns5
Lines8
Line Height (Points)18.00
Print Area$D$2:$K$48
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates