Download
| Description | Size | Download |
|---|---|---|
The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them. How to use:
| 449 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Screenshot
Detail
This is a quotation and estimation template. It implements a special and complex discounting model to meet practical business requirements.
The calculations for discounts are designed for real businesses. It may not be suitable for you, but it is a good sample of how to customize the template shipped with our invoicing app.
For more samples of quotations and estimations, visit Free Excel Quote Templates.
The template includes nine columns. The first two columns are titled "PACKAGE", under which two columns allow you to enter the number of packages and the package type that is implemented as a drop-down list with three options: "BOX", "S.BOX" and "GUDDI". Followed are the columns "BOX No.", "Description", "Per", "Quantity", "Unit Price", "Line Total", and "LESS".
The value of "Quantity" is calculated using an Excel formula like this ("_?" is the line number):
=oknPackage_?*oknPer_?
"Unit Price" is a manually editable field. "Line Total" is also a calculated field. The formula looks like this (again, "_?" indicates line numbers):
=IF(oknLineTotalManual_?=0,IF(oknQuantity_?=0,ROUND(oknPer_?*oknPrice_?,2),ROUND(oknQuantity_?*oknPrice_?,2)),oknLineTotalManual_?)
"LESS" is also a manually editable field that 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 a cell name of "oknAccountBalance". The value is filled whenever an existing client is retrieved from the database. See Previous Balance (Sales) (c5007) and Previous Balance (Service) (c5027) for more information on how to show the previous balance on the form.
The "Total Due" is the sum of the previous account balance and the total of the current quotation.
