Skip to main content main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

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 Invoice Manager for Excel. This is what you will see when you open partial-payment.xlsx.

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

Invoice Sample with Partial Payment and Payment History - IMFE edition


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.


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

3.38 MBDownload

Without database file. How to download and use

65 KBDownload

Download this if you have already installed IMFE, and are looking for additional customized templates; or if you want a template for Invoice Manager (Lite).

506 KBDownload


Invoice Manager for Excel (namely Uniform Invoice Software) supports partial payment and Progress Billing. It is also able to payment historical detail 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 Invoice Manager for Excel (namely 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 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, Invoice Format with Partial Payment and Progress Billing 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, 2016 or 2019.

Format and Specification

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 / Excel 2019
Line Height (Points)18.00
Print Area$D$2:$K$48
Papaer Size / OrientationPortrait
Default Margins (Points)

Update History

August 10, 2017

  • Unlocked all the cells in the "Payment Detail" section. Without this modification, payment history cannot be updated properly. See locking / unlocking cells for more information.