Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Book Store Invoice Template

Book Store Invoice Template (c7003)

c7003 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open book-store-uis.xlsx.

Book Store Invoice Template (UIS Edition)

Book Store Invoice Template - UIS 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

Without database file. How to download and use

116 KBDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

341 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.83 MBDownload

Detail

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 nameField typeNote
DiscDecimal (8,6) Discount, a percentage value shown on invoice body. This custom field is also added to Product database table so that you can define default discount for each product which is loaded whenever you pick up a product.
UnitCostDecimal (15,6) The applied price for the customer.

On invoice body, the invoice template uses the following formula to calculate UnitCost:

=oknPrice_? * (1-oknDisc_?)

Where "?" is a line number, ranging from 1 to 30.

ExtRetailDecimal (15,6) ExtRetail is calculated using the following formula:

=ROUND(oknPrice_?*oknQuantity_?,2)

On the bottom of the invoice form, there are also 2 custom fields that are labeled TOTAL QUANTITY and TOTAL EXT. RETAIL. These custom fields are defined in the InvHdr (Invoice Header) database table, and are named TotalQuantity and TotalExtRetail, respectively.

Like other form designs here on InvoicingTemplate.com, Book Store Billing Form is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

Template#c7003
NameBook Store Invoice Template
CategorySales Invoice Template
Release DateWednesday, March 15, 2017
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Columns7
Lines30
Line Height (Points)15.00
Print Area$F$3:$O$53
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35