You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
Screenshots and Images
The printed version.
Open the template in Excel.
The invoice template is designed for book wholesaler, publisher or store. It calculates discounts on each product as they are entered on an invoice, by using Excel formulas. Besides wholesale, it also allows applying discounts to retail customers when you invoice them.
Note: This billing format was originally published on office-kit.com as C7-003.
Discounts could vary by product. Some invoices may have products at 40% discounts, others at 50%, for example.
In order to implement the feature required with this invoicing format, the template uses 3 custom fields (custom columns) on the invoice body.
|Field name||Field type||Note|
|Disc||Decimal (8,6)||Discount, a percentage value shown on invoice body. This custom field is also added todatabase table so that you can define default discount for each product which is loaded whenever you pick up a product.|
|UnitCost||Decimal (15,6)|| The applied price for the customer. |
On invoice body, the invoice template uses the following formula to calculate UnitCost:
Where "?" is a line number, ranging from 1 to 30.
|ExtRetail||Decimal (15,6)|| ExtRetail is calculated using the following formula: |
On the bottom of the invoice form, there are also 2 custom fields that are labeledand . These custom fields are defined in the (Invoice Header) database table, and are named and , respectively.
Format and Specification
|Name||Book Store Invoice Template|
|Category||Sales Invoice Template|
|Release Date||Wednesday, March 15, 2017|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||15.00|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|System||Windows 7 and later, and Excel 2007 and later.|