Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Service Proposal Template with Checkbox Column. Double-click the downloaded file to extract all files.
  2. Open the template "Service-proposal-template-with-checkbox-column.xlsx" or "Service-proposal-template-with-checkbox-column-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.

Service Proposal Template with Checkbox Column

Service Proposal Template with Checkbox Column (c4107)

c4107 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open Service-proposal-template-with-checkbox-column-uis.xlsx.

Service Proposal Template with Checkbox Column (UIS Edition)

Service Proposal Template with Checkbox Column - UIS edition

Download Service Proposal Template with Checkbox Column (c4107)

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.

677 KBDownload

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

2.80 MBDownload

Detail

The layout of this service proposal template is similar to c4009 service proposal template. While it does not include major changes to the proposal form layout, we take a closer look at how the checkboxes work on the Excel form.

The following document was originally published on office-kit.com for the proposal and quote template C4-009. We revisited and published it here on InvoicingTemplate.com.

This template provides a sample of creating a service proposal template/service quote template from the default invoice template shipped with the installer program of Uniform Invoice Software. As a service proposal template/service quote template, it does not contain "Ship To" fields. The most specific feature of this template is that it offers a checkbox column, which you can check/uncheck on various service items so that your customers can see what the totals would be for those particular items only.

The layout of the proposal template

This template was created with consideration for a service company who installs lights for customers. The company does not want to show Invoice# (i.e. proposal# or quote# in this case), customer# on the printable form, so these fields are move out of the Print_Area. The Invoice Date field remains inside the Print_Area, but with a new label "Proposed", indicating the date of the proposal or quote.

The main form body contains 4 columns. The first column is Room#, indicating the room where the rights should be installed. The other columns are Description, Quantity and Line Total. All the fields on the form body are manually editable - the template does not calculate Line Total from Quantity and Unit Price, but it can easily be modified by using Excel formulas to calculate Line Total from Quantity and Unit Price.

Between Room and Description there is a column of checkboxes. If you check a box, the Line Total on the current line is added to the "TOTAL OF ITEMS SELECTED" cell on the bottom of the proposal or quote, which is a custom field. Since the checkboxes are located inside Print_Area, they will be included on printed invoices, as well as the extracted Excel document.

The Key Points to Implement the Checkboxes

As described above, the checkboxes should be included in the extracted version of proposals or quotes.

  • Since Uniform Invoice Software removes all the ActiveX controls and form controls except those have specific prefixes in their names, you should name the checkboxes oknWidget_1, oknWidget_2, oknWidget_3, and so on. See How to Create Invoice Template for the details.
  • In order to be able to save a proposal or quote to database and reload it at a later time, the value of the checkboxes should be saved to the backend database too. To implement this, the values of the checkboxes are linked to Excel cells, and the cells being linked are defined as custom fields.

    To link a checkbox to an Excel cell:

    1. Make sure the sheet is unprotected. To do this, click the "Design Mode" button on the "Invoice" ribbon tab.
    2. Right-click the checkbox, choose Properties.
    3. Find the LinkedCell property; enter the cell name to which the current checkbox is linked
    4. Once done, exit design mode and save the template

    The "TOTAL OF ITEMS SELECTED:" on the bottom of the proposal form calculates line totals of all items where the checkbox is checked. The Excel formula used is:

    =SUMIF(oknSelected_1:oknSelected_16,TRUE,oknLineTotal_1:oknLineTotal_16)+
    SUMIF(oknSelected_1:oknSelected_16,-1,oknLineTotal_1:oknLineTotal_16)

    Custom fields

    The following chart details all the custom fields used in this template.

    Table nameField nameField typeComment
    InvHdrDaysDecimal(12,2)The number of days to complete the job.
    InvHdrSelectedTotalDecimal(12,2)The sum of all the selected service items.
    InvBdyRoomText(60)The place to do the job.
    InvBdySelectedIntegerIs the current service item selected?

    Note

    Customer Name is a required field. You can fill it with a fixed value such as "A" using Excel formula. If you don't want the Customer Name to appear on the printed invoices, you can even move the cell out of the Print_Area.

    Like other form designs here on InvoicingTemplate.com, Service Proposal Format with Checkbox Column 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#c4107
    NameService Proposal Template with Checkbox Column
    Category
    Release DateThursday, March 23, 2017
    Format (XLS or XLSX).xlsx
    Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
    Feature Gallery
    Columns4
    Lines16
    Line Height (Points)24.00
    Print Area$F$3:$O$41
    Printable with Papaer Size / OrientationLetter (8-1/2 in. x 11 in.) - Portrait
    Default Margins (Points)
    Left18.00
    Right18.00
    Top75.60
    Bottom75.60

    Sample Templates