Skip to main content main content
sharing is caring! we do appreciate your time to let others know us!

Book Store Invoice Template

Book Store Billing Form

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.

Packing Slip Template

Packing Slip Format

The packing list template could be used either alone, or together with an invoice template, on same computer. In the latter case, make sure the two templates are connected with same database in order to share data. To do this, click the "Settings" button on the "Invoice" ribbon tab, go to the "Database Tab", click the "Open Database" to browse to and open the database file you want to use.

This design uses mainly the "Segoe UI Symbol" font, which is ideal for both printing and screen display purpose.

Invoicing Template in Euros

Invoicing Format in Euros

As a simple customized sample of VAT invoice created for Germany (See c4098 Sales Invoicing Format for Germany and Service Billing Template for Germany), we make the currency symbol shown for the appropriate cells. This customization is easy and simple. If you are interesting in the details, here is how.

Music Store Invoice Template (Retail)

Music Store Invoice Template (Retail)

Music Store Invoice Template (Retail) was designed specially for music company or store. The printable form (the main invoicing form on the center of the Invoice Excel spreadsheet is same as the default sales invoice template included in Invoice Manager for Excel (namely Uniform Invoice Software), but there are also several special fields added for music store business.

General Quote Template for Excel

General Quote Format in Excel Spreadsheet Format

Since the line totals are manually editable, i.e. not calculated from hours and rate or quantity and unit price, it is more like a general invoice template.

Spin Button to Add or Subtract One

Spin Button to Add or Subtract One

The spin button we'll use here one of the control in the "Form Controls" toolset, which is available in all the major apps in the Microsoft Office product family, like Excel (".xls" or ".xlsx"), Word (".doc" or ".docx"), Visio, Publisher, PowerPoint. Here on we've already published samples on using form controls. For example, the "Taxable" checkbox could be either implemented using ActiveX control, or a form control - in the standard invoice template shipped with Invoice Manager for Excel (namely Uniform Invoice Software) setup program, it use checkbox in the form control category.

Music Store Invoicing Sample (Wholesale)

Music Store Invoicing Sample (Wholesale)

You should also modify the formula of the "Total" cell to use the discounted amount instead of the original subtotal amount:

Simple Template with Printable Watermark

Simple Format with Printable Background Image

Adding a background image or watermark can be an attractive and appealing enhancement, especially for business documents like invoices. This Simple Invoice Template with Printable Background Watermark demonstrates how to accomplish this in Microsoft Excel.

Proforma Invoice with Printable Earth Map Background

Pro-Forma Invoice with Printable Earth Map Background

Since proforma invoices, like commercial invoices, are mainly for cross-board international trading, we believe an earth map is a suitable background / watermark for it. The earth map is an abstract image create from a vector image. It is placed on the center of the printable proforma invoicing form, which is defined by the special "Print_Area" Excel range name.

Hotel Bill Format with Online Payment Button

Hotel Bill Format with PayPal Payment Button

The form layout of this template is based on c7005 Hotel Receipt Template published here on As the original design, it includes 7 columns - "Room #", "Name", "Check in", "Check out", "# of Nites". "Price / Nite", "Line Total". The automatic calculation of the subtotals, totals, taxes are done using Excel formulas. This is one of the big advantages of Excel spreadsheet templates - you can use formulas to do calculations. While it is easy to do document formatting in Microsoft Word too, the auto calculation of Excel spreadsheet makes it much easier to create invoices.

Simple Sales Invoicing Sample

Simple Sales Invoicing Format

Simple Sales Invoicing Sample is the template designed by that helps you create beautiful and professional sales invoices in an easy and quick way.

Invoice Template with Hours and Rate

Invoice Template with Hours and Rate

If you use the Invoice Manager for Excel (namely Uniform Invoice Software) edition, setting tax options can be done by clicking the Settings button on the Invoice worksheet, and then go to the Taxes tab. With the freeware edition, you should first unprotect the spreadsheet and then unhide second tax line manually.

PDF Invoice with PayPal Button

PayPay Payment Button on PDF Invoices

Invoice Manager for Excel (namely Uniform Invoice Software) (UIS) is able to generate invoices in Adobe PDF (".pdf"), Microsoft Excel spreadsheet (".xlsx") and image format (".png"), and send the generated electronical invoices to customers via email. Starting from version 4.17, you can even add a PayPal payment button to your PDF invoices. Here are the steps to follow to enable to this feature.

Here are some important notes about the PayPal payment button.

VAT Invoicing Sample with 2 Separate Rates

VAT Billing Form with 2 Separate Rates

VAT Invoice Template with 2 Separate Rates was originally published on as a sample on customizing the default template included in Invoice Manager for Excel (namely Uniform Invoice Software) and a sample on using custom fields. It applies one of the defined VAT rates to each product / item depending on its tax category.