BoostExcel main content

Music Store Invoicing Sample (Wholesale)

Template#: c5059

Download

DescriptionSizeDownload

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:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
409 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

The screen shot for Music Store Invoicing Sample (Wholesale)

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
Columns5
Lines12
Line Height (Points)24.75
Print Area$F$3:$N$42
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree

Related

Soccer Shop Invoice Template Thumbnail
Invoicing Format for Bakery and Cake Shop Thumbnail
Bike Shop Invoice Template Thumbnail
Print Shop Bill Sample Thumbnail
Payment Voucher Template (Golden Shop) Thumbnail
Music Store Invoice Template (Retail) Thumbnail