InvoicingTemplate.com main content
Notary Invoice Template
c3007
Notary Invoice Template

Notary Invoice Template could also be seen as a general service invoice template and consultant invoice template. It helps you to create and print professional notary and general invoices and estimates. The billing form has 3 columns - Date, Description and Amount.

Invoicing Template for Roofing Service
c5098
Invoicing Template for Roofing Service

This billing and invoicing format for roofing service is created based on the standard invoicing template shipped with Invoice Manager for Excel installer program. See the standard invoice template category for more samples on this topic. The most noticeable differences between this customized format and the standard template is that, besides the color schema, this roofing service version shows a roofer image on top of the form. This image is added as a background image, so it will not show when you are creating invoices - the roofer image shows only on printed invoices, or the PDF version that you generate with Invoice Manager for Excel and email to your customer.

Product Names and Shipping Address on Aging Report
c5150
Product Info on Accounts Receivable Aging Report

It is not as easy as you might imagine to combine several cell values into one. As explained on trumpexcel.com there are multiple ways you can do this, but Excel offers no special formula for this -- except Excel 2016 (Office 365), which offers the "TEXTJOIN" function.

Building Construction Bill Format
c4130
Building Construction Bill Format

Like c4046 Construction Invoice Template, this template has 4 columns too, namely "Description", "Quantity", "Unit Price" and "Line total". This differs from c1001 Construction Proposal Template and c1005 Construction Contract Template, where there is only 1 column and the total amount is manually editable.

Excel Retail Invoice Template
c5155
Excel Retail Invoice Template

We have already published several formats for retail selling. For example c5010 Music Store Invoice Template (Retail), c3013 Pet Food Store Invoice, c7003 Book Store Invoice Format etc. UniformSoft.com also has published a popular title for clothing stores. While many of the templates are named with specific industry names, they are in fact not limited to what the names suggest. If you are looking for a billing template for your retail business, the most important thing to look for is whether the fields offered by a template meets your requirements.

Five Price Levels (Service, Amount, Custom Column)
c5028
Form with 5 Price Levels

This seventh sample in the multiple-price or multiple-discount serial has no shipping fields in the printable section, and the prices are set in amount (instead of percentage).

Malaysia Tax Invoice Template
c5161
Malaysia Tax Invoice Template

Use this template to make Invoice Manager an invoicing and billing software for Malaysia. The following table shows both the original and the translated text.

Hotel Receipt Format with Blue Gradient Design
c7027
Hotel Receipt with Blue Gradient Bar

So to create this blue gradient bar, we followed the steps below.

  1. Backup the template (as always).
  2. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab. All the template here on Invoicing Template are protected by default, but with no password set. The purpose of enabling protection is to prevent end users from altering the design of the template accidently.
  3. Select all the cells on the top line that we'll marge, in this case, $D$3:$N$3.
  4. On Excel "Home" ribbon tab, click "Merge and Center".
  5. Right-click the merged cell and choose "Format Cells".
  6. Switch to the "Fill" tab.
  7. Click "Fill Effects".
  8. From "Colors" section, choose "Two colors", make the "color 1" is white and "color 2" is blue.
  9. From "Shading Style" section choose "From corner".
  10. Click one of the fill effect from the "Variants" section.
  11. Click OK to close the "Fill Effects" dialog box.
  12. Click OK to close the "Format Cells" dialog box.
  13. "Your Hotel Name" is a placeholder for your hotel / business name. Before you can create your first invoice, you need to replace it with your business name.
  14. The "RECEIPT" title is now implemented as a text box. Compared to regular text on the spreadsheet form, adding text and label using text box gives you more options on formatting and placing text. Click to select the "RECEIPT" title, the "DRAWING TOOLS / Format" ribbon tab appears, where you have full control over the style and appearance of the text box. In this sample, we simply choose one of preset WordArt Style.
  15. Once you've done customization on the hotel receipt template, click "Design Mode" button again on the "Invoice" ribbon tab to exit design mode. This protect the "Invoice" worksheet and hide gridlines and row/column headings.
  16. Click the Save button on Excel quick access toolbar to save the template.
Mixed Tax Rates in an Invoice (7 Columns)
c5035
Mixed Tax Rates in an Invoice (7 Columns)

In the original version, which is named Mixed Tax Rates in an Invoice (5 Columns) here on InvoicingTemplate.com, we implemented a feature that allows you to tax different types of items with different rates on one same invoice by adding several custom fields and creating some Excel formulas. By using custom fields and Excel formulas, we can create exciting features that are not supported by the default sales invoice template that was shipped with Invoice Manager for Excel. The two newly added columns, which are "Product Type" and "Applied Tax Rates", are placed outside the printable invoice form in the original version. If the product / item description text labels are short, you may like to place these two new columns inside the printable invoice form. This customized form named Mixed Tax Rates in an Invoice (7 Columns) implements this.

Five Price Percentage Levels (Service, Custom Column)
c5030
Form with 5 Price Levels

After moving out the "Shipping Date" field, you may like to expand the size of the neighboring fields to make the layout organized. This is done by expanding the Terms label and field. Expanding the "Terms" label is done by first selecting the original terms cell and the empty cells left by moving out the "Shipping Date" field, and then execute the "Merge and Center" command on Excel ribbon tab. To do this for the Terms field, you first need to move the original Terms cell to the first (left-most) cell of the empty space, and then select all the cells you want to merge, and then execute the "Merge" command.

Consulting Invoice Template (2nd Sample of Customization)
c4017
Consulting (2nd Sample)

Note that if you use the Invoice Manager for Excel version of the consulting invoice template, it is necessary to unprotect the Invoice form before you can customize it.

Hotel Receipt Template
c7005
Hotel Receipt Template

If you use the Invoice Manager for Excel version of the hotel invoice template / hotel receipt template, the receipt# (or invoice#) is generated automatically when you save the document.

Hotel Guest Folios with Satisfied Business Traveler
c5091
Hotel Guest Folios with Satisfied Business Traveler

This hotel guest invoice / guest folios / guest bill format includes spaces for hotels / motels to detail number of guest(s), Room No., Arrival Date, Arrival time, Departure date, Departure time. To beautify the form design an image of a satisfied business traveler is added.

Sales Invoice Form with Discount Percentage
c5033
Sales Invoice Template - Discount Percentage

The meaning and the usage of the discount values, including the implementation details, can be found at Service Invoice Form with Discount Percentage. If you are look for information on moving Excel cells and controls, you can find it at Sales Invoice Form with Discount Amount.

Five Price Percentage Levels (Sales, Custom Column)
c5029
Form with 5 Price Levels

Custom Field is a concept introduced by Invoice Manager for Excel, which refers to the fields that are not defined in the default database structure of Invoice Manager for Excel. For example, for an invoice selling clothes you may like a "Size" column on the invoice body to indicate the size of the invoicing item, but the "Size" field does not exist in the default database definition. In this case, you can add it as a custom field in both the Product and Invoice Body database table, so that when you pick up a product on creating an invoice, the size field filled in automatically along with the description, price and product #, and when you save an invoice, the size field is saved too.

Sales Invoice Form in Croatian
c5158
Sales Invoice Template in Croatian

This Croatian Invoice Template is translated from the standard invoice template (default template) shipped with Invoice Manager.

Like the c5156 Turkish version and the c5157 Italian version, only the text inside the printable area is translated. Visit Croatia invoice requirements and VAT invoicing rules for VAT invoicing requirements in Croatia. See this document for more information on basic rules and techniques of customization.

Australian GST Invoice Template
c7018
Australian GST Billing Form

Note: a revised version of this template could be found at ABN Tax Invoice Template.

As always Australian GST Invoice Template is offered in Excel spreadsheet format.

Medical Invoice Template (1)
c7009
Medical Billing Form (1)

This free template is the first of our serial of medical billing forms. Originally provided on UniformSoft.com at Medical Invoicing Layout, this template was designed for those hospitals and health care providers who offer medical care for infants, children and adolescents. The other medical billing templates on this serial will offer more variants and formats for you. While the term "medical invoice" is as bare bones as a name can get, medical invoices can actually be a source of confusion if not designed to provide information in a clear and organized manner. A medical invoice can be used at any health care service and assists the health care service provider to maintain health care records of patients. It is used to bill the patient and contains detailed information on the type of treatment or medical service provided to the patients at their time of hospitalization.

Clinic Invoice
c7041
Clinic Invoice

This clinic bill and receipt template could be used by clinics such as dental clinic, cosmetic clinic, chiropractic physicians, psychologist, psychology service, mental health and acupuncture therapy. It has less fields than c7019 medical invoice template, but has a cuttable payment slip that copies invoice# (receipt#), date and amount due from the main part by using Excel formula.

What Is Hot

Thumbnail for Hotel Bill Format with Online Payment Button
Thumbnail for Service Invoice Form with Discount Amount
Thumbnail for Subscription Invoice Template (Service)
Thumbnail for Five Price Percentage Levels (Sales)
Thumbnail for Construction Contract Template with Watermark of Urban Buildings
Thumbnail for 1/2 Page Invoice Template
Thumbnail for Blank Service Invoice with Logo Picture Illustration
Thumbnail for Simple Sample - Moving Balance and Payment Cells
Thumbnail for Netherlands Service Invoice Template 2
Thumbnail for Sales Invoice Template with Discount Percentage Column