BoostExcel main content
Book Store Invoice Template

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 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 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 Invoicing Form (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, but there are also several special fields added for music store business.

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.

Sample Invoice Template with Spin Button

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 setup program, it use checkbox in the form control category.

Music Store Invoicing Form (Wholesale)

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

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.

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 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 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.

Billing Format with Hours and Rate

If you use the Invoice Manager for Excel 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.

PayPay Payment Button on PDF Invoices

Invoice Manager for Excel (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 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 and a sample on using custom fields. It applies one of the defined VAT rates to each product / item depending on its tax category.

What Is Hot

Credit Memo Template
Construction Invoice Template
Consultant Invoice with Travel and Hourly Expenses
Consultant VAT Invoice for U.K. Limited Company
Travel Service Bill Format
Simple 2-Column Service Bill Sample
Cash Payment Voucher Template
Job Invoicing Template
Simple Sales Invoice Template without Item Description
Subscription Invoice Template (Sales)