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

Business Invoice Template

Business Invoice Template

We also have designed invoice formats that are specific to certain businesses. For example, c6001 Clothing Shop Receipt includes the "size" column on the detail section; cm003 Clothing Store (Manufacturer) Invoice with Size Breakdown adds even more columns, i.e. "Color", "0-2 XS/P", "4-6 S", and so son, so that you can break down quantity in detail for the clothes you sold.

Contractor Billing Format

Contractor Invoicing Layout

Take a look at the screenshot of this invoice template, you'll easily find the differences between this template and other templates available here on There are 18 lines on the detail section, but these lines are grouped into two sections - the "Services" section and the "Expenses" section, with each section identified by a blue title bar. You can use 6 lines on each section to itemize the service and expense. The other lines are reserved for taxes and amounts.

Hotel Guest Folios with Satisfied Business Traveler

Hotel Bill Layout with Satisfied Business Traveler

The blank bill template includes a logo image on the top form. To replace with your own image, click the "Replace Logo Image" button on the ribbon tab.

Basic Blank Service Format (No-tax)

Basic Blank Service Format (No-tax)

While some businesses prefer customized, no-standard invoicing forms, others find it is much simpler to use a basic invoicing layout, such as the layout implemented by this template - Basic Blank Service Format (No-tax) or Basic Blank Service Layout (No-tax). As a general purpose invoicing template, it does not include fields that are specific to certain businesses, and thus it is suitable for many service business types, like consulting agencies, solicitors and law firms, designers, cleaning service providers, freelancing agencies, accountants and other organizations in similar field.

Simple Invoice for Construction Business

Simple Billing Format for Contractor

Although this template is named with the word "construction" and "contractor", it could also been seen as a general service invoice template. For example, consultants, service providers, and other small businesses could use this invoicing form too. We have other layouts here on too. If you charge based on hourly rates, visit Invoice Template Hourly Rate. A Handyman Invoice Template is also ready here for you.

Business Invoice with Customer-Specific Discounting

Business Invoice Template with Customer-Specific Discounting

Some customers are very important so you need to allocate discounts to them whenever you invoice them. This template implements this by adding a custom field, Discount, to both the Customer and InvHdr (Invoice Header) database tables. For each customer, you can set a default discount, either 0 or a non-zero value. Whenever you create invoice for the customer, the discount is applied automatically.

Blank Sales Invoice Layout (Two-tax)

Blank Sales Invoice Sample (Two-tax)

The tax names are set to its default values, "TAX1" and "TAX2". To change the tax names and rates, simply unprotect the "Invoice" worksheet by clicking the "Unprotect Sheet" command in the "Review" Excel ribbon tab. All the templates here on are protected by default. This is a good way to prevent modifications to the layout and formulas of the template. All editable / fillable cells are unlocked so that they are selectable and editable even when the spreadsheet is protected. To set / view the locking status of a cell, first unprotect the sheet, and then right-click the cell you want to set, choose Properties. On the "Protection" tab of the "Format Cells" dialog box, you'll find the "Locked" property. If this property is checked, the cell will not be editable / fillable when the sheet is protected.

Bike Shop Invoice Template

Invoicing Layout for Bike Shop

Like all the other Excel invoicing templates here on, this invoicing layout for bike shop works well too with Uniform Invoice Software. By installing Uniform Invoice Software, which is our Excel-based invoicing software app, this simple Excel-formatted invoice template becomes a powerful invoicing software program that is able to manipulate your client, products, invoices / receipts and payments data, saving your time and effort on invoicing.

Five Price Levels (Service, Amount)

Five Price Levels (Service, Amount)

This is a variant of 5 Price Levels (Sales, Amount) invoice template. It differs from the original one in that it is service-oriented, i.e. it has no shipping fields.

Service Invoice with Profit Calculation

Service Invoice with Profit Calculation

This variant format is created based on the Sales Invoice Template with Profit Calculation, by moving the entire shipping address section out of the print area.

Simple Sample - Using Currency Symbol

Simple Sample - Using Currency Symbol

This simple invoice template details the steps required to show a specific currency symbol on all the currency-related fields, for example "Unit Price", "Line Total", "Subtotal", "Total", "Paid" and "Total Due".

Advanced Sample - Email Is Required Before Saving Invoice

Advanced Format - Email Is Required Before Saving Invoice

This sample template demonstrates how you can call UIS action procedures (i.e. those actions performed when you clicking the buttons on the "Invoice" worksheet. By calling the UIS procedures from your own macro, you'll be able to include your own business logic on invoicing processing.

Simple Sample - Moving Item# Column

Simple Sample - Moving Item# Column

This simple invoice template demonstrates how to move out the Item# (or Product #) column from the printable invoicing form. The result template still has the item# column but it is not printable.

Basic Sales Invoice with Blue-violet Gradient Background

Basic Sales Invoice with Blue-violet Gradient Background

As required by Uniform Invoice Software, the "Product ID" column is still on the template, but is placed on column A (ranging from A20:A31), which is outside the printable section of the worksheet. This layout design allows you to have more space left for the "Description" column, but still being able to use the "Product ID" column to fill in invoiced items quickly by entering the shortcut code of a product (such as SKU# or barcode numbers read by a scanner).

PayPal Payment Button Using Custom Image

Excel Invoice with PayPal Payment Button Using Custom Image

For steps on adding the PayPal payment button to your invoices and bills, see PDF Invoice with PayPal Button.

In this example, we take c3012 Freelance Writer Invoice format as the base template and starting point, demonstrates how to replace the image using Excel. "c3012 Freelance Writer Invoice" is a service invoice template, and is one of the featured template on invoice templates for freelancers.

Five Price Levels (Sales, Amount)

Five Price Levels (Sales, Amount)

It's common business practice to give certain customers, such as returning customers or VIP customers, a discount. You may even expect the ability from an invoicing system that makes it possible to give different levels of discount depending on the types of a customer. for example, in the cosmetic business it is common to define several levels of discounts. The default invoice template shipped with Uniform Invoice Software does not support this. However just like many other features that are not directly supported by the default invoice template - because every business is different, thus it is not possible to create one invoice template to make it suitable for every business type - customizing the template to create such a feature is possible and easy with Uniform Invoice Software. This is not a magic. The secret behind this is that Uniform Invoice Software combines the powerful of a backend database and a front end Excel spreadsheet, leveraging the power of the two mature platforms.