InvoicingTemplate.com main content

Screenshots and Images

The printed version.

Excel Quotation Template

Open the template in Excel.

Excel Quotation Template (IMFE Edition)

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

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

Screenshot for General Estimate Template

General Estimate

Screenshot for Telecom Consultant Estimation Template

Telecom Consultant Estimation

Screenshot for Job Estimate Template for Excel

Job Estimate in Excel Format

Screenshot for Service Proposal and Quote

Proposal and Quote Template

Screenshot for Construction Proposal Template

Construction Proposal

Screenshot for General Quote Template for Excel

General Quote Format in Excel Spreadsheet Format

Screenshot for Service Proposal Template with Checkbox Column

Checkbox Column

Screenshot for Soccer Shop Invoice Template

Soccer Shop

Screenshot for Receipt Sample for Seafood Restaurant

Seafood Restaurant

Screenshot for Service Billing Template for Germany

Service Invoicing Template for Germany

Screenshot for Construction Invoice Template

Construction Business

Screenshot for Invoicing Template for Roofing Service

Roofing Service