Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Excel Quotation Template. Double-click the downloaded file to extract all files.
  2. Open the template "excelquotationtemplate.xlsx" or "excelquotationtemplate-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.

Excel Quotation Template

Excel Quotation Template (c9008)

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

Excel Quotation Template (UIS Edition)

Excel Quotation Template - UIS edition

Download Excel Quotation Template (c9008)

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.

346 KBDownload

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

2.81 MBDownload

Detail

This free quotation and estimation template in Microsoft Excel ".xlsx" format provides a sample of customizing the default invoice template shipped with Uniform Invoice Software. It implements a special / complex discounting model to meet practical business requirements.

The discounting calculations in this template is built specially for a real business. It may not be suitable for you, but it is a good sample on how to customize the invoice template shipped with Uniform Invoice Software. For more samples on quotations and estimations, visit Estimate Templates.

This template is created for businesses who sell goods. For a job estimating and quoting template, visit Job Estimate Template for Excel. For a general estimate template, see General Estimate Template.

The template includes 9 columns. The first two columns are titled with "PACKAGE", under which two columns allows you to enter number of packages, and the package type that is implemented as a drop-down list with 3 options - "BOX", "S.BOX" and "GUDDI". Followed are the columns "BOX No.", "Description", "Per", "Quantity", "Unit Price", "Line Total" and "LESS".

The value of the "Quantity" is calculated using an Excel formula like this, where "_?" is the line number:

=oknPackage_?*oknPer_?

"Unit Price" is a manually editable field. "Line Total" is also a calculated field, which looks like this (again, "_?" indicates line numbers):

=IF(oknLineTotalManual_?=0,IF(oknQuantity_?=0,

ROUND(oknPer_?*oknPrice_?,2),

ROUND(oknQuantity_?*oknPrice_?,2)),oknLineTotalManual_?)

The formula for "Line Total" incorporates both the auto-calculated portion, and the manually fillable field ("oknLineTotalManual_?" fields, placed outside the printable area, which means it is manually editable on creating invoices / estimations, but will not be included on printable invoices).

The "LESS" is also a manually editable field, which is designed as a percentage value.

On the bottom of the form, you'll find the usual "Subtotal", "Discount" and "Total" fields. There is also the "Last Balance" field and the "Total Due" cell. The "Last Balance" cell has its field name set to "oknAccountBalance", which is filled whenever you fill in the quotation form / estimation form with an existing client by using the on-sheet picker button, you by enter the client# into the "Customer#" cell (also located outside of the printable quotation form, at $U$2). See Invoice with Previous Balance (Sales) and Invoice with Previous Balance (Service) for more information on how to show previous balance on the form. The "Total Due" is the sum of the previous account balance and the total of the current quotation.

As detailed above, this free quotation form is not general / common format that is suitable for general business. Another example of this is that it includes no visible seller company information on the printable form, except the logo image. You may not be able to apply this template to your own business without modifications, but it does demonstrate some ideas on how the template could be customized without breaking the support from Uniform Invoice Software.

Like other form designs here on InvoicingTemplate.com, Excel Quotation Format with Special Discounting Model 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#c9008
NameExcel Quotation Template
CategoryOther Invoice Template
Release DateFriday, February 10, 2017
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns9
Lines37
Line Height (Points)15.75
Print Area$G$2:$Q$64
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right17.01
Top34.02
Bottom34.02

Sample Templates