Skip to main content
InvoicingTemplate.com main content

Simple Sample - Using Currency Symbolc4050

Screenshot for c4050 - Simple Sample - Using Currency Symbol

"Simple Sample - Using Currency Symbol" was found to be relative to Help On What Is A Tax Invoice with the score grade of 98.

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

... While not displaying a currency symbol is acceptable for many businesses or companies, there are cases that it is helpful to show a specific currency symbol on the invoices or bills. This tutorial details the steps required to set a currency symbol for all the money fields on the invoice layout. The result of this customization is a simple invoice template that could be downloaded for free, like all the other templates available here on InvoicingTemplate.com

Five Price Levels (Sales, Amount)c4012

Screenshot for c4012 - Five Price Levels (Sales, Amount)

"Five Price Levels (Sales, Amount)" was found to be relative to Help On What Is A Tax Invoice with the score grade of 97.

... The discount level number of a customer and the discounted prices of the selected invoicing items, although appear on the invoice form when you create an invoice, they will not be included in the printed hard copy of an invoice or the extracted invoice that you sent to your customer. This happens because all these fields are placed outside the printable area, which is the area that will get printed when you issue the "Print" command in Excel.

... This invoice template has shipping fields included so it is more suitable for creating sales invoices. If you are looking for a service version, see Form with Five Price Levels (Service, Amount).

Consulting Invoice Template (1st Sample of Customization)c4016

Screenshot for c4016 - Consulting Invoice Template (1st Sample of Customization)

"Consulting (1st Sample)" was found to be relative to Help On What Is A Tax Invoice with the score grade of 84.

... By moving the "Machine#" field out of the printable invoice form, the original Consulting Invoicing Template becomes more universal and thus be suitable for more types of constants. The sample consulting invoice template created in this tutorial, like all the other templates here on InvoicingTemplate.com, has a free edition and an edition that should be used with Uniform Invoice Software.

... If you use the Uniform Invoice Software version of Consulting Invoice Template (1st Sample of Customization), note that this invoice template uses custom fields. Custom fields are the fields that are not defined in the default database design, but added by the end-users.

Simple Sample - Moving Item# Columnc4049

Screenshot for c4049 - Simple Sample - Moving Item# Column

"Simple Sample - Moving Item# Column" was found to be relative to Help On What Is A Tax Invoice with the score grade of 61.

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.

  1. Open the invoice template as usual.
  2. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.
  3. Drag your mouse to select the "To create an invoice" section, as well as the short advertisement section "Need a different invoice layout? Visit our invoice template collection" section. Move the entire selected area (N6:R46) several columns right. In this sample, we put this on $R$6.
  4. On the printable form, select the entire "Description" column, including the heading row, ranging from F21 to H33. Click the "Merge and Center" command on the "Home" ribbon tab. This unmerges the selected area.
  5. Now select the entire column "#/Taxable". The range address should be D21:D33. Move the selected area to the new location starting from $O$21.
  6. Now selected the unmerged "Description" column, ranging from F21 to F33. Move the selected area to the new location starting from $D$21.
  7. Select all the cells that will comprise the new column heading of the Description column, ranging from D21 to H21. Click "Merge and Center" command on the "Home" ribbon tab.
  8. Select all the cells that will comprise the new oknProductName_1 cell (the top-most product description cell), ranging from D22 to H22. Click "Merge and Center" command on the "Home" ribbon tab.
  9. Repeat the above step for all the other description cells.
  10. The "Merge and Center" command set text alignment to be "Center". We have to set this to "Left". To do this, select all the product description cells (excluding the heading cell), ranging from D22 to H33. Click the "Align Left" button on the "Home" ribbon tab / "Alignment" group.
  11. In Excel 2010 / Excel 2013 / Excel 2016, click File / Print to preview the result of a printed invoice.
  12. Exit print preview mode and go back to normal view. Add up borders and set colors to fine turn the printable invoicing form.
  13. Once finished, exit design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.

Service Invoice with Discount Amountc4024

Screenshot for c4024 - Service Invoice with Discount Amount

"Service Invoice with Discount Amount" was found to be relative to Help On What Is A Tax Invoice with the score grade of 54.

... Although it is easy to create the layout and format of Service Invoice with Discount Amount with Microsoft Word or other Microsoft Office programs, or even with some PDF programs like Adobe Acrobat, the support for Excel formulas makes doing automated calculations easy to implement and modify. For example, Service Invoice with Discount Amount uses Excel formulas extensively to do calculations whenever possible and necessary, such as the taxes, totals. If you use the Uniform Invoice Software version of Service Invoice with Discount Amount, Excel formulas are also used to create the relationship between several fields, such as one field should be the sum of two other fields.

... This free invoice template is a service invoice template, meaning that there is no fields defined for shipping address information.

Simple Sample - Moving Balance and Payment Cellsc5075

Screenshot for c5075 - Simple Sample - Moving Balance and Payment Cells

"Simple Sample Invoicing Template - Moving Cells" was found to be relative to Help On What Is A Tax Invoice with the score grade of 49.

... Different businesses require different invoice format and layout. While the default template shipped with Uniform Invoice Software installer program meets many business types, including home business, small business, freelancers etc., There are still many people find it does not meet their requirements exactly. So you need to customize it.

  1. Open the invoice template as usual. You may like to backup it before opening it, so that you can easily return to a working state in case something goes wrong.
  2. Switch to design mode. With Uniform Invoice Software installed, you can do this easily by clicking the "Design Mode" button on the "Invoice" ribbon tab. Click the same button again to exit design mode.
  3. Now drag your mouse to select all the cells you want to move. Once all the cells are selected, release your mouse key.
  4. Push your mouse key on the border of the selected area, drag it to the location out of the printable form - the section that will be printed when you print the invoice - in this sample template, we drag it to the location starting from $P$39.
  5. Once finished, click the Design Mode button on the "Invoice" ribbon tab again to exit design mode.

General Purchase Invoice Template (Consulting, One Tax)c2027

Screenshot for c2027 - General Purchase Invoice Template (Consulting, One Tax)

"General Purchase Invoice Template (Consulting, One Tax)" was found to be relative to Help On What Is A Tax Invoice with the score grade of 47.

... Many consulting fields are not regulated. For example, anyone can claim to be a marketing consultant, tech support consultant, business management consultant, public relations consultant, writer, editor or graphic designer. As a result, the invoicing format used by different businesses vary depending on the special requirements in each field. Generally, consulting invoices are categorized as service invoices. Here on InvoicingTemplate.com we created a dedicated category (Consultant Invoice Template) for this topic due to its popular demands. If you cannot find your desired format in the consulting invoice templates, browse our service invoice templates where you may find more choice. You can also find useful information on other websites like Sample consulting invoice | Consultant invoice.

Receipt Template for Gold Shop (2)c5042

Screenshot for c5042 - Receipt Template for Gold Shop (2)

"Receipt Template for Gold Shop (2)" was found to be relative to Help On What Is A Tax Invoice with the score grade of 44.

... To adjust the existing columns to leave space for new column or columns that will be added to the printable form for Receipt Template for Gold Shop (2), we first unmerge the item# (or product#), description and quantity columns - these are usually merged columns that each contains several Excel raw columns. To do this, after opening Receipt Template for Gold Shop (2) as usual, select all the cells belong to these columns and then click the "Merge and Center" button on the Format toolbar in Excel 2003; in Excel 2003, the "Merge and Center" button can be found on the Home ribbon tab. Drag your mouse to select the Description column (this time, you select Excel raw column since the Description is no longer a merged column) and drag it one column left. Select the "oknProductName_1" cell (the first cell on the moved Description column) and drag your mouse to select the two adjacent cells at the right-hand too - so, you now select 3 cells started with the "oknProductName_1" cell. Now click the Merge and Center command again. This will expand the width of "oknProductName_1" to 3 columns. Do this process for all the other Description cells. Once done, you have one empty column that was left by moving the Description column to the left-hand of this original position. Adjust the columns widths of all the columns to make sure they have the proper widths that are able to hold the content they will display on this Receipt Template for Gold Shop (2).

General Purchase Invoice Template (Service, One Tax)c2026

Screenshot for c2026 - General Purchase Invoice Template (Service, One Tax)

"General Purchase Billing Template (Service, One Tax)" was found to be relative to Help On What Is A Tax Invoice with the score grade of 31.

General Purchase Invoice Template (Service, One Tax) is a customized invoicing form based on c2025 General Purchase Invoice Template (Sales, One Tax). It differs from the original edition by removing the shipping address section.

... In order to create this template - "General Purchase Billing Template (Service, One Tax)", we moved out the shipping address fields out of the "Print_Area" range. In Excel spreadsheet documents, the range name "Print_Area" defines what part of the sheet to print when you issue the print command. If the name "Print_Area" is not defined, the whole sheet will be printed; otherwise, only the range defined by the "Print_Area" name will be printed. Put it in other words, it defines what area is the printable invoicing form.

... To move out the address section, we first need to put the template into design mode. To do this, simply push down the "Design Mode" button on the "Invoice" ribbon tab. This commands unprotect the sheet and then push down the "Design" button on the "Developer" ribbon tab.

Form with Product Categoryc5008

Screenshot for c5008 - Form with Product Category

"Template with Product Category" was found to be relative to Help On What Is A Tax Invoice with the score grade of 30.

The main purpose of creating this invoice template on InvoicingTemplate.com is to provide a sample on using custom fields with Uniform Invoice Software.

... However the support for custom fields in Uniform Invoice Software makes overcoming this limitation easy and quick. What you need to do is to add the custom field "Product Category" to the invoice body database table, and then name a column of cells where you want to display the category when creating an invoice - in this sample, we don't want to show product category on printed invoices, so the product category column is defined outside the printable area.

General Purchase Invoice Template (Sales, One Tax)c2025

Screenshot for c2025 - General Purchase Invoice Template (Sales, One Tax)

"General Purchase Billing Template (Sales, One Tax)" was found to be relative to Help On What Is A Tax Invoice with the score grade of 30.

Sometimes an invoice is also referred as purchase invoice from the view of the buyer. This general-purpose Excel-formatted purchase invoice sample includes two editable/fillable columns, Description and Amount, and a Taxable checkbox column.

... Several other templates here on InvoicingTemplate.com have the Taxable options put on the printable form too. This sample, General Purchase Billing Template (Sales, One Tax) differs from others in that it implements the taxable options using the Form Controls. Microsoft Excel, and thus Uniform Invoice Software, actually supports two types of checkboxes added to a spreadsheet form - i.e. form control and ActiveX control. In case you need to add your own control, visit the Controls group of the Developer ribbon tab. This tab is not visible by default. To display it, first right-click an empty area on the Excel ribbon, choose "Customize the Ribbon" and then check the Developer ribbon tab option.

Plumbing Service Invoice Template (Landscape)c4023

Screenshot for c4023 - Plumbing Service Invoice Template (Landscape)

"Plumbing Service Billing Template (Landscape)" was found to be relative to Help On What Is A Tax Invoice with the score grade of 21.

... Plumbing Service Billing Template (Landscape) includes exactly the same number of fields as the original version. Unlike the other 2-column samples, Plumbing Contractor Bill Sample (c2008) and Plumbing Contractor Billing Format (Landscape) (c2009), this plumber template defines sales tax, instead of VAT tax. Like Plumbing Service Billing Format (Sales Tax) (c4022), this service template for plumber also has the Taxable column moved into the printable invoice form. This layout design is suitable for those businesses who have both taxable and non-taxable items. Bill your customers with this plumbing bill design if you have relatively long description for your invoicing items.

... Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. Plumbing Service Invoice Template (Landscape) uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

Website Development Invoicing Samplec2024

Screenshot for c2024 - Website Development Invoicing Sample

"Website Development Invoicing Sample" was found to be relative to Help On What Is A Tax Invoice with the score grade of 15.

... This template is customized based on c4029 Free Designer Bill Template (Blue), which is suitable for web designer, graphic designer, freelancer, contractor etc. There are other variants of c4029 too here on InvoicingTemplate.com, like Free Designer Billing Template (Red), Free Designer Billing Form (Gray). If you are a freelancer, you may like to take a look at Free Freelance Bill Template. If you like a template that has its columns titled with "Hours" and "Rate", visit Beautiful Service Bill Template with Hourly Rate or Hourly Service Billing Template, Hourly Service Billing Sample (UK Currency), Free Hourly Service Billing Format (Price Including Tax) and Free Hourly Service Invoicing Sample (Price Excluding Tax). Each template here comes with a fillable PDF billing template along with an Excel spreadsheet format template.

... To move the columns out of the printable form, first of all the sheet must be unprotected.

Invoice with Previous Balance (Service)c5027

Screenshot for c5027 - Invoice with Previous Balance (Service)

"Invoice with Previous Balance (Service)" was found to be relative to Help On What Is A Tax Invoice with the score grade of 13.

This is a service invoice version of Invoice with Previous Balance (Sales). It differs from the original version by moving all shipping-related fields out of the printable invoice.

... Please also refer to the original version to find out implementation details about this invoice template, including how Uniform Invoice Software maps database fields to Excel cells, and how to unlock a cell to make sure Uniform Invoice Software can read/write a cell even when the spreadsheet is protected.

Commercial Template Sample - Adding Insurance Cost Fieldc9006

Screenshot for c9006 - Commercial Template Sample - Adding Insurance Cost Field

"Commercial Template Sample - Adding Insurance Cost Field" was found to be relative to Help On What Is A Tax Invoice with the score grade of 11.

... These fields - insurance and currency code, provides important information regarding the international shipping / freight and international trading. If you have looked at Commercial Template Sample - Complete Incoterms Rules, you may notice that many Incoterms rules specify how the insurance cost will be handled.

... In this example, we named the cells for the newly added fields "oknInsurance" and "oknCurrencyCode" respectively. In the underlying database tables, the corresponding fields are named "Insurance" and "CurrencyCode". As you can see from this sample, the mapping between database fields and Excel cells are archived by using names. To map a cell to a database field, simply name the field "okn + fieldname".

Proforma (1st Sample of Customization)c7011

Screenshot for c7011 - Proforma (1st Sample of Customization)

"Proforma Invoicing Form" was found to be relative to Help On What Is A Tax Invoice with the score grade of 6.

... All the templates available here on InvoicingTemplate.com were initially created based on the general invoice template that was shipped with the installer program of Uniform Invoice Software. Each template has a version that works with Uniform Invoice Software, and another free version that works without the installation of Uniform Invoice Software. If you are familiar with Microsoft Excel, you may already find that it is easy to do such customizations, but we think it is still helpful to detail some basics of customizations so that someone who is not very familiar with Microsoft Excel could follow. This is why we create this serial of samples based on the proforma invoice template on InvoicingTemplate.com.

Plumbing Contractor Invoice Template (Landscape)c2009

Screenshot for c2009 - Plumbing Contractor Invoice Template (Landscape)

"Plumbing Contractor Billing Template (Landscape)" was found to be relative to Help On What Is A Tax Invoice with the score grade of 3.

... To adjust the width of one column for Plumbing Contractor Invoice Template (Landscape), drag the boundary on the right side of the column heading until the column is the width that you want. To change the width of multiple columns for Plumbing Contractor Invoice Template (Landscape), select the columns that you want to change, and then drag a boundary to the right of a selected column heading. To change the width of columns to fit the contents for Plumbing Contractor Invoice Template (Landscape), select the column or columns that you want to change, and then double-click the boundary to the right of a selected column heading.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c4050
Simple Sample - Using Currency Symbol
Monday, January 25, 2016,
12
4
A4
Portrait
Sales
c4012
Five Price Levels (Sales, Amount)
Monday, November 11, 2013,
30
4
A4
Portrait
Sales
c4016
Consulting Invoice Template (1st Sample of Customization)
Wednesday, December 4, 2013,
16
4
A4
Portrait
Consulting
c4049
Simple Sample - Moving Item# Column
Sunday, January 24, 2016,
12
4
A4
Portrait
Sales
c4024
Service Invoice with Discount Amount
Sunday, May 18, 2014,
12
4
A4
Portrait
Service
c5075
Simple Sample - Moving Balance and Payment Cells
Saturday, January 23, 2016,
12
5
A4
Portrait
Sales
c2027
General Purchase Invoice Template (Consulting, One Tax)
Friday, January 22, 2016,
6
2
A4
Portrait
Receipt
c5042
Receipt Template for Gold Shop (2)
Wednesday, December 25, 2013,
12
5
A4
Portrait
Receipt
c2026
General Purchase Invoice Template (Service, One Tax)
Thursday, January 21, 2016,
6
2
A4
Portrait
Service
c5008
Form with Product Category
Sunday, November 10, 2013,
12
5
A4
Portrait
Sales
c2025
General Purchase Invoice Template (Sales, One Tax)
Wednesday, January 20, 2016,
6
2
A4
Portrait
Sales
c4023
Plumbing Service Invoice Template (Landscape)
Friday, May 16, 2014,
6
4
A4
Landscape
Service
c2024
Website Development Invoicing Sample
Wednesday, December 2, 2015,
6
2
A4
Portrait
Service
c5027
Invoice with Previous Balance (Service)
Saturday, November 9, 2013,
12
5
A4
Portrait
Service
c9006
Commercial Template Sample - Adding Insurance Cost Field
Tuesday, December 1, 2015,
9
9
A4
Landscape
Pro-forma
c7011
Proforma (1st Sample of Customization)
Tuesday, October 29, 2013,
20
7
A4
Portrait
Pro-forma
c2009
Plumbing Contractor Invoice Template (Landscape)
Wednesday, May 14, 2014,
6
2
A4
Landscape
Service

What Is Hot

Feature Galleries