BoostExcel main content
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:
| 410 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Screenshot
Detail
This is a variant of Music Store Invoicing Form (Retail) (c5010). It differs from the original version in that this form includes a new custom field, Discount. It enables you to apply discounts to wholesale clients.
If you want to set the default Discount Rate for each customer, simply add the Discount Rate custom field to the Customer database table.
The Excel formula for the discount amount cell is as follows:
=ROUND(oknSubTotal*oknDiscountRate,2)
The formula for the "Total" cell is also updated to use the discounted amount:
=ROUND(oknSubTotal -oknDiscountAmount + oknShippingCost + IF(oknTaxType=0,0,IF(oknTaxType=1,oknTax1,oknTax1+oknTax2)),2)
Format and Specification
| Template# | c5059 |
| Belongs to | |
| Format (XLS or XLSX) | .xlsx |
| Columns | 5 |
| Lines | 12 |
| Line Height (Points) | 24.75 |
| Print Area | $F$3:$N$42 |
| Papaer Size / Orientation | Portrait |
| Default Margins (Points) | |
| Left | 22.68 |
| Right | 22.68 |
| Top | 45.35 |
| Bottom | 45.35 |
| Price | Free (0.00USD) |
Related
