Skip to main content
InvoicingTemplate.com main content

Backorder Invoice Templatec7002

Backorder Billing Form

"Backorder Billing Form" was found to be relative to Sales Invoice Example For Small Or Home Business with the score grade of 92.

... The freeware edition of Backorder Invoice Template provides exactly the same form layout and design in Microsoft Excel format as the UIS edition of Backorder Invoice Template. The most noticeable difference, at the first glance, is that the UIS edition of Backorder Invoice Template contains many buttons on it, such as Customers, Products, Invoices and Reports, etc. These buttons calls features and functionalities implemented by UIS. For example, if you click "Save To DB", UIS validates and checks the current document on Backorder Invoice Template, generate a unique invoice number automatically (if necessary), and then save it to the backend database.

Proforma (2nd Sample of Customization)c7012

Proforma Invoicing Form

"Proforma (2nd Sample of Customization)" was found to be relative to Sales Invoice Example For Small Or Home Business with the score grade of 86.

... With the first sample on how to customize the proforma invoice template, we learnt how to unprotect the Invoice worksheet and how to modify Excel color palette to change the color theme of an existing template. This second sample of customizing the pro forma invoicing template will be focused on how to enter your company information and replace the default "InvoicingTemplates" logo image.

... Now right-click the InvoicingTemplates logo image and choose Properties from the shortcut menu. The Properties box appears. Look for the Picture property, and click the button on that line. Excel shows you a dialog box that allows you to browse to and specify your own logo image. Depending on your Excel version, the supported image file formats may vary, but JPG, PNG and GIF formats are good choices for storing your logo image that are likely supported by your Excel.

Proforma Invoice Templatec7010

Proforma Invoice Template

"Proforma Invoice Template" was found to be relative to Sales Invoice Example For Small Or Home Business with the score grade of 69.

This simple but useful Proforma Invoice Template help you, as a supplier that is trading across countries, create professional and beautiful proforma invoices required by the buyer in advance of providing the goods or service.

... Proforma invoices basically contain much of the same information as the formal quotation. It should give the buyer as much information about the order as possible so arrangements can be made efficiently. The invoices inform the buyer and the appropriate import government authority's details of the future shipment. This Pro Forma Invoice Template is professionally designed document for need of many small business companies that require simple, great looking, and yet reliable invoicing solution, which could be used as for domestic as well as international trade purposes.

Sales Invoicing Templatecn001

Sales Invoice Form

"Sales Invoicing Template" was found to be relative to Sales Invoice Example For Small Or Home Business with the score grade of 67.

Sales Invoicing Template is a general purpose template that is suitable for many business types. It includes both a "Bill To" and a "Ship To" section. There are also 5 columns on the invoice body, including Product#, Description, Quantity, Price and Line Total.

... On the bottom of the invoice form, Subtotal, Tax 1, Tax 2, Total and Total Due are calculated automatically using Excel formulas. The tax rates and tax names, payments, shipping and handing fee, are all editable.

Proforma (3rd Sample of Customization)c7013

Proforma Invoicing Form

"Proforma (3rd Sample of Customization)" was found to be relative to Sales Invoice Example For Small Or Home Business with the score grade of 60.

  • First choose a column (or row) to place the possible values. This should be an empty (not-used) area outside the printable form. In this example, we choose the range on the right side of the shipping details section. The possible currency types are: US Dollar, Euro, Pound Sterling, Japanese Yen - you could enter more on the column, just make sure there is no blank (empty) cells between valid possible values.
  • Select the cell where you want the drop-down list - in this example, you select the currency field (the cell after the label "currency"). If you are running Excel 2007, Excel 2010 or Excel 2013, on the Data tab, in the Data Tools group, click Data Validation. If you are running Excel 2003, choose Excel menu Tools > Validation.
  • In the Allow box, click List.
  • To specify the location of the list of valid entries, do one of the following:
    • If the list is in the current worksheet, enter a reference to your list in the Source box or click in the Source box and then select your list in the current spreadsheet to populate the reference automatically.
    • If the list is on a different worksheet, enter the name that you defined for your list in the Source box.
  • Make sure that the In-cell dropdown check box is selected.
  • To specify whether the cell can be left blank, select or clear the Ignore blank check box.
  • Optionally, display an input message when the cell is clicked.
  • Specify how you want Excel to respond when invalid data is entered.

...Tip: To delete a drop down list, select the cell with the list. Click the Data tab, and then in the Data Group, click Data Validation. In the Data Validation dialog box, click the Settings tab, and then click Clear All.

Contractor Billing Formatc3009

Contractor Invoicing Layout

"Contractor Invoicing Layout" was found to be relative to Sales Invoice Example For Small Or Home Business with the score grade of 56.

Contractor Billing Format differs from other templates here in that it itemizes "service" and "expense" in two separate sections on the invoice detail section. Each section has a different tax (including tax name and tax rate) applied.

... While there are many invoicing software apps that are able to handle simple and regular invoicing forms, Uniform Invoice Software is designed with flexibility in mind. This, with the help of Microsoft Excel, especially its formulas that allows us to define the relationship between cells (for example, how one cell is calculated from the value of the other cells), makes it possible for Uniform Invoice Software to handle complex invoicing forms and layouts. You may be still invoicing in the traditional paper way because there is no invoicing software app is able to handle the complex formats you need. Uniform Invoice Software helps you turn to electronical invoicing with easy and quick.

Proforma (1st Sample of Customization)c7011

Proforma Invoicing Form

"Proforma (1st Sample of Customization)" was found to be relative to Sales Invoice Example For Small Or Home Business with the score grade of 34.

  1. First, open the original ".xls" formatted proforma invoice template in Excel 2010 (Excel 2007 and all the later versions support ".xlsx" spreadsheet format).
  2. Click Excel menu File / Save As. If you have Uniform Invoice Software installed, a warning message appears that says "If you save this workbook with a different file name, you must re-open it to ensure Uniform Invoice Software functions properly. Are you sure you want to continue? " Choose Yes.
  3. On the "Save As" dialog box, choose "Excel Workbook" from the "Save as type" drop-down list. Name the new template "proforma 1st sample", or something else you like.
  4. If you have Uniform Invoice Software installed, you may find that after executing Excel "Save As" command, all the buttons on the new template stop working. This is not a bug, bug by design - as stated above, you need to close and then reopen the template if you want to make the buttons work. But for the purpose of this sample, we'll skip this step.
  5. Now unprotect the Invoice worksheet. To do this in Excel 2010, go to the "Review" ribbon tab and click the Unprotect Sheet command.

    The protection of the "Invoice" worksheet in Proforma (1st Sample of Customization) prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in Proforma (1st Sample of Customization).

  6. The background color we used for the labels "SHIP TO", "BILL TO", "SHIPPING DETAILS" and the heading line of the invoice body, as well as the fore color of the big title "PRO FORMA INVOICE", is a custom color defined in Excel palette. You can find this color on many of the templates designed by us here on InvoicingTemplate.com - In fact, we use this color since 2005 - when we released Excel Invoice Manager for the first time. To make sure all of our templates have a similar style, this color has never been changed.

    However, to make your own invoice template, you may like to change it. Here is how you can do it (Again, we are using Excel 2010 in this tutorial.)

    • Open Proforma (1st Sample of Customization) as usual.
    • Click Excel menu File, and then click Options.
    • Click Save.
    • Next to Choose what colors will be seen in previous versions of Excel, click Colors.
    • Click the color that you want to change - for example, the fourth on the last line, and then click Modify.
    • Specify the new color. Click OK to close the Colors dialog box.
    • Click OK to close the Color dialog box. Click OK again to close the Excel Options dialog box.
  7. Once returned to the Invoice worksheet, you can find the new color applied to the invoice form. See the figures below to find an example.

Singapore GST Invoice Template (Sales)c6021

Singapore GST Billing Format (Sales)

"Singapore GST Billing Format (Sales)" was found to be relative to Sales Invoice Example For Small Or Home Business with the score grade of 34.

  1. the words "tax invoice" in a prominent place
  2. an identifying number (Invoice #)
  3. the date of issue of the invoice (Invoice Date)
  4. the name, address and registration number of the supplier
  5. the name and address of the person to whom the goods or services are supplied
  6. a description sufficient to identify the goods or services supplied and the type of supply
  7. for each description, the quantity of the goods or the extent of the services and the amount payable, excluding GST
  8. any cash discount offered
  9. the total amount payable excluding GST, the rate of GST and the total GST chargeable shown as a separate amount
  10. the total amount payable including the total GST chargeable and
  11. if the amount under (9) to (10) above is in foreign currency, the corresponding Singapore currency has to be indicated

... Although this template is named with "Singapore", if you are from a country or region that has the similar taxing and invoicing requirements, such as Hong Kong and Malaysia, you can also use it directly, or use it as a starting point of creating your own template. All templates here on InvoicingTemplate.com are not locked with password, so you are free to do any customization you like.

Simple Sample - Moving Taxable Controlsc5076

Simple Invoicing Format - Moving Taxable Controls

"Simple Sample - Moving Taxable Controls" was found to be relative to Sales Invoice Example For Small Or Home Business with the score grade of 31.

... The idea to exclude the taxable boxes from printing is to move the controls out of the printable invoicing form which is identified by the special Excel range name "Print_Area". To find out what area on your template is defined as the print area, pull down the name list that is located on the left side of the formula bar, and on the bottom of the name list choose "Print_Area". Excel selects the area defined as the printable form on the current worksheet. You may need to switch the worksheet in to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab if the worksheet is protected.

Sales Invoice with Profit and Taxable Columnc5062

Sales Invoicing Form with Profit and Taxable Column

"Sales Invoicing Form with Profit and Taxable Column" was found to be relative to Sales Invoice Example For Small Or Home Business with the score grade of 27.

... Compared to c5060 Sales Invoice with Profit Calculation, this invoice template adds a column of "taxable" checkbox. Each checkbox tells Excel / Uniform Invoice Software that whether the current invoicing item is taxable - if the checkbox is checked, this amount of this selling item is included when calculating taxes. In the original invoice template (and many other invoicing forms that are available here on InvoicingTemplate.com), this taxable checkbox column is placed outside the printable area, which means it is not included when you are printing an invoice, or generating an electronic invoice. By moving the group of checkboxes into the print area, your customers and clients will see the whether each item is taxable.

... The protection of the "Invoice" worksheet in Sales Invoice with Profit and Taxable Column prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in Sales Invoice with Profit and Taxable Column.

, then the checkboxes should be named with "oknWidget_" prefix, such as oknWidget_taxtable1, oknWidget_taxable2, oknWidget_taxable3...

Blank Commercial Invoice Templatec7004

Blank Commercial Billing Form

"Blank Commercial Invoice Template" was found to be relative to Sales Invoice Example For Small Or Home Business with the score grade of 25.

... This simple yet elegant template should be used as a final bill after good have shipped. "Blank Commercial Invoice Template" has detailed buyer, seller, and order information as well as a section to specify agreement terms. This free commercial invoice template is in Microsoft Excel spreadsheet format. The template offers an intuitive blank commercial invoice form that is printable and highly customizable. You can download a high quality blank commercial invoice form to create your own professional commercial invoice for your business.

... (Note that if you have installed the latest version of our invoicing software, Uniform Invoice Software, which is able to upgrade a simple template in Microsoft Excel spreadsheet format into a complete invoicing system, you don't have to replace the logo image manually - you can replace the default logo image by clicking the "Replace Logo Image" button on the ribbon tab in Excel 2007, Excel 2010 and Excel 2013). To replace the default LOGO image in Blank Commercial Invoice Template with your own image, follow the steps below:

Service Invoice with Profit Calculationc5061

Service Invoice with Profit Calculation

"Service Invoicing Form with Profit Calculation" was found to be relative to Sales Invoice Example For Small Or Home Business with the score grade of 19.

... There are other variants and designs here on InvoicingTemplate.com too. For example, Sales Invoice Template with Profit and Taxable Column offers a similar invoicing form as Sales Invoice Template with Profit Calculation, but added a "Taxable" column on the printable area. And Service Invoice Template with Profit and Taxable Column offers a similar invoicing form as Service Invoice Template with Profit Calculation but with a "Taxable" column on the printable invoice design. As the name implies, the "Taxable" column is a checkbox column, which is placed outside the printable area on most invoice designs here on InvoicingTemplate.com. Microsoft Excel provides powerful features that let you easily customize the forms, such as adjust the fonts / colors, or even moving cells and controls. Uniform Invoice Software uses Excel templates and its front-end, allowing you leverage the full power of Microsoft Excel, the most used spreadsheet program around the world.

Agency Billing Templatec3004

Agency Billing Template

"Agency Billing Template" was found to be relative to Sales Invoice Example For Small Or Home Business with the score grade of 8.

... Agency Billing Template does not have a shipping section, as a typical issued by an agency company to a customer does not have this type of requirements. The section typically designed for shipping, such as in the general sales invoice template, is replaced with P.O. #, Sales Rep Name, Terms and Due Date. The 3 columns on the printable invoice body are #, Description and Line Total, with these columns you can itemize all the service or products a client purchase. The total number of lines on the invoice body is 18, which should be enough for most invoicing requirements. Read on to find tips and guidelines on creating agency invoices and bills.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c7002
Backorder Invoice Template
Monday, May 19, 2014,
12
7
A4
Portrait
Sales
c7012
Proforma (2nd Sample of Customization)
Wednesday, October 30, 2013,
20
7
A4
Portrait
Pro-forma
c7010
Proforma Invoice Template
Saturday, October 26, 2013,
20
7
A4
Portrait
Pro-forma
cn001
Sales Invoicing Template
Friday, October 18, 2013,
12
x
A4
Portrait
Sales
c7013
Proforma (3rd Sample of Customization)
Saturday, November 23, 2013,
20
7
A4
Portrait
Pro-forma
c3009
Contractor Billing Format
Saturday, October 17, 2015,
18
3
A4
Portrait
Service
c7011
Proforma (1st Sample of Customization)
Tuesday, October 29, 2013,
20
7
A4
Portrait
Pro-forma
c6021
Singapore GST Invoice Template (Sales)
Sunday, August 23, 2015,
18
6
A4
Portrait
Sales
c5076
Simple Sample - Moving Taxable Controls
Wednesday, January 27, 2016,
12
5
A4
Portrait
Sales
c5062
Sales Invoice with Profit and Taxable Column
Sunday, September 21, 2014,
12
5
A4
Portrait
Sales
c7004
Blank Commercial Invoice Template
Wednesday, May 21, 2014,
12
7
Letter (8-1/2 in. x 11 in.)
Landscape
Pro-forma
c5061
Service Invoice with Profit Calculation
Sunday, September 21, 2014,
12
5
A4
Portrait
Service
c3004
Agency Billing Template
Monday, October 21, 2013,
18
3
A4
Portrait
Service

What Is Hot

Feature Galleries