Skip to main content main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Subscription Invoice Template (Sales). Double-click the downloaded file to extract all files.
  2. Open the template "subscriptionsalesinvoice.xlsx" or "subscriptionsalesinvoice-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.

Subscription Invoice Template (Sales)

Subscription Invoice Template (Sales) (c7007)

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

Subscription Invoice Template (Sales) (UIS Edition)

Subscription Invoice Template (Sales) - UIS edition

Download Subscription Invoice Template (Sales) (c7007)

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 have already installed UIS, but are looking for additional customized templates.

364 KBDownload

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

2.82 MBDownload


Subscription Invoice Template (Sales) adds two new columns, Start Month and End Month to the invoice body. It is suitable for products that are subscription or rental based for which a date range should be detailed.

This invoice template was originally published on at Invoice Template for Newsletter Publishing Service (C7-007), and also on our company site at Newsletter Publishing Invoice Template. While it was named with "newsletter publishing", it is actually suitable for many subscription or rental based products and items, such as magazines, property renting or hiring.

The two newly added columns, Start Month and End Month, are actually defined as "Date" data type in the database. They are, of course, custom fields that are not defined in the default database shipped with the sales invoice template of Uniform Invoice Software.

Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. Subscription Invoice Template (Sales) uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Subscription Invoice Template (Sales) without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on, that are one freeware edition, and another edition that works only with our invoicing software installed.

By default, the Start Month and End Month show dates in the format "Month Name / Year". For example, if you enter a date value "12/1/2014", the text shown on the cell will be "Dec/14". If you right-click the cell, and then choose Format Cells to open the Format Cells dialog box of Microsoft Excel, on the Number tab you can find the format codes of the Start Month and End Month cells " [$-409]mmm/yy;@". You can easily change the date format by using the Format Cells dialog box. Date values are not easy to work with. If you would like to try a date picker for Excel that pops up whenever a date value is needed, try our date picker for Excel at Excel Date Picker, or at Pop-up Excel Calendar - Date Picker for Excel.

By adding two new date columns, the default sales invoice template becomes Subscription Invoice Template (Sales) that is suitable for detailing product subscription or renting. If you are running a service business try Subscription Invoice Template (Service) here on

Like other form designs here on, Subscription Invoice Form (Sales) 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

NameSubscription Invoice Template (Sales)
CategorySales Invoice Template
Release DateSunday, January 5, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Line Height (Points)24.75
Print Area$E$2:$P$43
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)

Update History

April 21, 2017

  • Applied green color theme to this template.
  • Removed web site link from the "Web address, phone number" text label.

Sample Templates