InvoicingTemplate.com main content

Download

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 the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

552 KBDownload

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

5.80 MBDownload

Screenshots and Images

The printed version.

Invoice Sample with Partial Payment and Payment History

Open the template in Excel.

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

Detail

Invoice Manager for Excel 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 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.

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
Columns5
Lines8
Line Height (Points)18.00
Print Area$D$2:$K$48
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree (0.00 USD)
SystemWindows 7 and later, and Excel 2007 and later.

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.

Samples

Thumbnail for Net 30 Invoice Sample
Thumbnail for Sales Invoice Template with Discount Amount Column
Thumbnail for Advance Payment Invoicing Format
Thumbnail for Invoice Template with Credit Card Payment Option
Thumbnail for Service Invoice with Payment Advice
Thumbnail for Payment Receipt Template
Thumbnail for Hawaiian Invoice Template