Skip to main content main content
Sharing Is Caring! We do appreciate your time to let others know us!

Excel Quotation Template

Excel Quotation Format with Special Discounting Model

The discounting calculations in this template is built specially for a real business. It may not be suitable for you, but it is a good sample on how to customize the invoice template shipped with Uniform Invoice Software. For more samples on quotations and estimations, visit Estimate Templates.

The value of the "Quantity" is calculated using an Excel formula like this, where "_?" is the line number:

Excel Shipping Invoice with Printable Truck Background Image

Shipping Invoice with Printable Truck Background
  1. First make sure the "Invoice" worksheet is in design mode (to switch to design mode, push down the "Design Mode" button on the "Invoice" ribbon tab).
  2. And then, select "Print_Area" from the "Name" box on Excel formula bar. This selects all cells in the printable invoice form.
  3. Right-click one of the selected-cells, and choose "Format Cells". On the "Format Cells" dialog box.
  4. Go to the "Fill" tab, choose "No color", and then click OK.

Shipping Invoice Template (2)

Freight Invoice Format (2)

If you are interesting in how we created this customized shipping invoice format from the original shipping invoicing sample, here are the steps: unprotect the Invoice worksheet, switch to design mode, display row headings and gridlines of the Excel spreadsheet, resize columns to make it printable on A4 paper in Landscape orientation.

Simple Template - Moving Shipping Address

Simple Template - moving-shipping-address

To those users who want to know more about how Uniform Invoice Software works - The reason that Uniform Invoice Software supports moving fields is simple - it identify cells by names. So even if a cell, such as in this sample the "oknShipName", is moved to a new location (from $J$9 to $T$9), Uniform Invoice Software is still able to find it and map it to the database field.

Excel Payment Voucher Template

Payment Voucher Template

The original voucher template, Payment Voucher Template (Golden Shop), has a custom field Weight defined in both the Product and Invoice Body database tables. With this general purpose Excel Payment Voucher Template, removed the Weight custom field from it and made it a general purpose voucher template.

General Quote Template for Excel

General Quote Template for Excel

Due to this difference, it is important to clearly identify the document type on the header - whether it is a quote or an estimate. It is also useful, at least in some business areas, to include an expiry date on the document, if your prices are subject to change on the time. In this sample, we added it as a custom field "ExpiryDate". This field is defined as "text (100)" in the backend Access database, and the corresponding cell is named "oknExpiryDate" on the top quote form.

Job Estimate Template for Excel

Job Estimate in Excel Format

With Uniform Invoice Software, the auto-generation of invoice# (in this case, estimate# or quote#) is based on a counter stored in the backend Access database.

Donation Receipt Template for Excel

Donation Receipt Format for Excel

While not required, this form includes a "Receipt#" field on the top of the form under the "Date" field. If you have used one of our form designs for invoicing, you may know it is just the "Invoice#" field - we just place a new label "Receipt#" before the cell. So all features Uniform Invoice Software offer for the "Invoice#" field, works for the "Receipt#" field too. For example, the automatic receipt numbering feature, which generates a unique, sequential and unique based on a counter stored in the backend database. You can also retrieve information about an already-saved receipt by type in the receipt number into the "Receipt#" field.

Invoicing Sample for Cosmetics Shops

Invoicing Sample for Cosmetics Shops

Download this free Excel bill sample for vendors, stores, retailers and wholesalers that are specialized in cosmetics and makeup. The template (".xlsx" file) features auto calculation and a cosmetics background picture.

Invoice Template with Credit Card Payment Option

Billing Format with Credit Card Payment Option

The invoice template implements options for "VISA" and "MASTERCARD", you can add other credit cards in a similar way.

"c4068 Invoice Template with Credit Card Payment Option" was created based on c4051 Simple Invoice Template - Discount Amount Field. As a sample of this serial of simple invoice templates, we demonstrates one simple customization technique with each implementation of a customized template. In this tutorial, we show you how to add the credit card payment option by using checkboxes on the invoicing form. Note that all invoice templates here on are able to work with Uniform Invoice Software, which is our invoicing software app that works on Windows desktop PCs running Microsoft Windows and Excel / Office. Feel free to try the fully functional trial version, which could be downloaded here.

Simple Template with Printable Watermark

Simple Format with Printable Background Image

Microsoft Excel provides options for background images too. For example in Microsoft Excel 2013, you can go to the "Page Layout" ribbon tab, click the "Background" to open a dialog box where you can browse to choose a local image, or search online image.

Bill of Sales Template

Bill of Sale Form

A bill of sale is used not only when transferring vehicle ownership. Whenever a property is sold, you can use a bill of sale. For example, The web site offers a wizard that allows you create a bill of sale for motor vehicle, trailer, boat / watercraft, animal and other properties. Note that each state has its own requirements for a bill of sale, so the second step on the Legal Contracts web site is to choose where the property is located.

UK Tax Invoice Template

UK Tax Invoice Template

In certain trades (UK Construction, for example) it is customary for a list price to be given (on some, but not all products) and then a percentage discount to be applied. I.e. Quantity 1, List price of £81.57, discount of 65%, giving a line total of £28.55.

Simple Consulting Invoice Template

Simple Consulting Billing Format

As a consultant you need a beautiful invoicing template to bill your clients, yet the template should be simple and easy to use. Simple Consulting Invoice Template might be your choice for creating invoices.

does not include the shipping address section on the printable invoicing form. If you need the shipping address fields, try

5.5 Inch X 8.5 Inch - 2 Invoices On One Template

Duplicate 5.5 X 8.5 Invoices per Page

However, if you put only few items on each invoice, and want to print two copies of each invoice on a single page. How can you create such a template? Well, it sounds difficult but in fact easy to do. Remember we are using templates in Microsoft Excel format (most templates here on are in Excel ".xlsx" format, some of earlier posts provides ".xls" formats too). Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS X, and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Since 2004, at that time UIS was named Excel Invoice Manager (released as 4 editions - Excel Invoice Manager Express, Excel Invoice Manager Platinum, Excel Invoice Manager Pro, Excel Invoice Manager Enterprise), our invoicing software app uses Excel as its front end and provides the flexibility of customizing invoicing forms that could be hardly found in other invoicing or billing programs.