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

Invoicing Template with Watermark of New York

c4101
Invoicing Template with Watermark of New York

Do you like New York, the state in the northeastern United States? You can even add it to your invoices and bills! This free downloadable invoicing template for Microsoft Excel (".xlsx" format) provides a sample on how to add a watermark of New York.

Invoicing Format for Bakery and Cake Shop

c4090
Invoicing Format for Bakery and Cake Shop

This free billing / invoicing and order form template is designed for bakeries and cake shops. It features a "Requirements" box to enter special notes about the order, and a beautiful Valentine cake image as the form background.

Simple Sample - Moving Taxable Controls

c5076
Simple Sample - Moving Taxable Controls
  1. First of all, back up your template. It is always recommended to back up the template before modifying the layout and format. This way, you could easily return to a working state in case something goes wrong during customization.
  2. Now click to push down the "Design Mode" button on the "Invoice" ribbon tab. This switch the spreadsheet into design mode, showing gridlines and column / row headings, unprotecting the sheet, as well as push down the "Design" button on Excel "Developer" ribbon tab (The "Developer" ribbon tab is not visible by default).
  3. Now push down the CTRL key on your keyboard. Without releasing the CTRL key, click the taxable boxes one by one with your mouse. This select the taxable controls that you click.
  4. Once all the taxable boxes are selected, release the keyboard CTRL key.
  5. Click and drag one of the taxable box. Drop it outside the printable area - in this sample, we put it on $C10. By dragging and dropping one of the selected controls, all the selected controls are moved to the new location.
  6. If you want to delete the controls completely, with all the controls still selected, hit DEL key on your keyboard. If you want to leave them there, skip this step.
  7. You can also modify the formulas of the tax fields to have them ignore the value of the taxable boxes completely. If all your products or items are always taxable, modify the formula of the first tax cell to " =ROUND( IF ( oknTaxType =0 ,0, oknTax1Rate * ( oknSubTotal + IF( oknTaxTotalIncludingShippingCost =0,0, oknShippingCost ))),2)"; and modify the formula of the second tax cell to " =ROUND ( IF( oknTaxType <> 2,0, oknTax2Rate * ( oknSubTotal + IF ( oknTaxTotalIncludingShippingCost = 0,0, oknShippingCost )+IF( oknTax2IsAppliedToTax1= 0 ,0, oknTax1 ))),2) ". If all your products / items are not taxable, simply choose "No-tax" from the "Taxes" page of the Settings dialog box that could be opened by clicking the "Settings" button on the "Invoice" ribbon tab.
  8. Now modify the column heading of the original "#/Taxable" column. To do this, simply replace the text "#/Taxable" with something like "Item#" or simply "#".
  9. Exit design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab again.
  10. Once done, save the template by clicking the Save button on Excel quick access toolbar.

Excel Quotation Template

c9008
Excel Quotation Template

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

The "LESS" is also a manually editable field, which is designed as a percentage value.

Excel Payment Voucher Template

c5052
Payment Voucher Template

InvoicingTemplate.com also offers the Invoice Manager for Excel (namely Uniform Invoice Software) version of this Excel Payment Voucher Template / receipt template. The Invoice Manager for Excel (namely Uniform Invoice Software) version is also free if you have Invoice Manager for Excel (namely Uniform Invoice Software) installed, and it has exactly the same layout as the freeware edition of the Payment Voucher Template, but with many buttons on it, such as "Clear & New", "Save To DB", "Exact / Email", "Print". Invoice Manager for Excel (namely Uniform Invoice Software), as the name suggests, is our invoicing software that has the ability to make any invoicing templates available here on InvoicingTemplate.com a complete invoicing program that is able to manage customers, products, invoices and payments. For example, if you click the "Clear & New" button, the payment voucher form is cleared and is ready for you to enter a new payment voucher, with several fields filled with default data - for example, the current date is filled into the "Date" field. If you click "Save To DB", the current voucher is saved to backend database and a voucher# is generated automatically. If you click "Exact / Email", a standard Excel spreadsheet is created and the current voucher is copied to the newly created Excel spreadsheet file, which you can email to your client. You can also create a PDF voucher document using Microsoft Excel.

Work Invoice in Excel

c4125
Work Billing Template in Excel

This work invoice template in Excel is designed for freelance workers who charges on an hourly basis. It has a word art logo that shows "WORK INVOICE", a "Work Description" section near the "Bill To" fields, and 4 columns that calculate totals using Excel formulas.

Commercial Invoice for Export in Excel

c7015
Commercial Invoice in Excel

Whether you are an individual or a corporation, the commercial invoicing template helps you create professional and beautiful invoices with quick and easy. However if you are a corporation we highly recommend the Invoice Manager for Excel version. With Invoice Manager for Excel installed, the commercial invoicing form becomes a powerful invoicing system, with the ability to manager customers, products, invoices and payments.

General Quote Template for Excel

c2035
General Quote Format in Excel Spreadsheet Format

As an Excel spreadsheet template, we use Excel formulas to calculate subtotal, tax and total. For example, for the subtotal field, the Excel formula assigned to the subtotal field is "=SUM(oknLinetotal_1:oknLinetotal_22)". This is one of the big advantages of using Excel spreadsheet templates. While you can create beautiful and professional forms too using Microsoft Word, Publisher, PowerPoint or even Adobe Photoshop, it is much easier when you need to do some calculations. This ability, combined with custom fields (user-defined fields) supported by Invoice Manager for Excel (namely Uniform Invoice Software), resulting extremely flexible form designs, as you can see from the samples online here on InvoicingTemplate.com. Or see the PDF quotation sample to find out what it will like when your customer receive the quotation created using UIS.

Building Construction Bill Format

c4130
Construction Bill Format in Excel

In addition to the required "Bill To" section, this form design has a section for "Job Information", including fields like "Job Name", "Subdivision" and "Lot No.", making it easy to further detail the project to bill, such spec homes, custom homes, room additions, outdoor living (decks, patios, and retaining walls), and remodeling.

Job Estimate Template for Excel

c4084
Job Estimate in Excel Format

On the top of the blank estimate form you see the service business name. Next to it is the highlighted "ESTIMATE#" and "ESTIMATE DATE" fields. These fields are essentially the "Invoice#" and "Invoice Date" cells that appear on most free invoice templates here on InvoicingTemplate.com.

Donation Receipt Template for Excel

c1004
Donation Receipt Format for Excel

Third, it is also required to clearly describe the donation, including the date the donation was made, as well as the amount of the donation.

Sales Invoicing Format for Germany

c4098
Sales Invoicing Format for Germany

Here on InvoicingTemplate.com we've already have a category of templates for VAT invoicing at VAT Invoice Templates, which lists the Excel forms that could be used to invoicing German-based clients, this template differs from the others in that all the text labels are translated into German. As detailed at 2016 European Union VAT rates, the standard Germany VAT rates is 19% for most goods and services, although a reduced rate could be applied for some foodstuffs; water supplies; medical equipment for disabled persons; some public transport; books; newspapers and periodicals; admission to cultural events; writers and composers; agricultural supplies; hotel accommodation; admission to sports events; social services; medical and dental care. This sample template set the default rate to 19%, and assuming all items on the form are taxable. In case you need to change the tax rate with Invoice Manager for Excel (namely Uniform Invoice Software), follow the steps below.

Print Shop Bill Sample

c4006
Print Shop Bill Sample

Print Shop Invoice Template could be used by a print shop or mail room for a school district. Compared to the default sales invoicing sample shipped with Invoice Manager for Excel (namely Uniform Invoice Software), in the Bill To section the "Name" changed to "Department", "Company" changed to "Contact Name", "Address" changed to "Department Code", etc.

Invoice with Date Column

c4004
Invoice with Date Column

Adding a new column is a bit complex than just moving cells. With the previous generation of Invoice Manager for Excel, which is named Excel Invoice Manager, you have to use Database Designer to add new fields to the Invoice Body database definition file and database table (and the field with the same name to the Product table, if you wish to fill the cell automatically when a product / service item is picked up), and then name the cells based on the database field name.

Work Order and Processing Sheet Practical Sample

c7008
Work Order and Processing Sheet Form Practical Sample

A processing sheet that shares database with the invoice template is also included. The processing sheet is a working sheet that will be giving to the person assembling the shade, i.e. they don't need to know price etc but they do need to know what parts to use.