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.

562 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.

Excel Quotation Template

Open the template in Excel.

Excel Quotation Template (IMFE Edition)

Detail

This free quotation and estimation template in Microsoft Excel ".xlsx" format provides a sample of customizing the default invoice template shipped with Invoice Manager for Excel. 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 Invoice Manager for Excel. 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 Invoice Manager for Excel.

Format and Specification

Template#c9008
NameExcel Quotation Template
CategoryOther Invoice Template
Release DateFriday, February 10, 2017
Format (XLS or XLSX).xlsx
Feature Gallery
Columns9
Lines37
Line Height (Points)15.75
Print Area$G$2:$Q$64
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right17.01
Top34.02
Bottom34.02
PriceFree (0.00 USD)
SystemWindows 7 and later, and Excel 2007 and later.

Samples

Thumbnail for General Estimate Template
Thumbnail for Telecom Consultant Estimation Template
Thumbnail for Job Estimate Template for Excel
Thumbnail for Service Proposal and Quote
Thumbnail for Construction Proposal Template
Thumbnail for General Quote Template for Excel
Thumbnail for Service Proposal Template with Checkbox Column