Skip to main content
InvoicingTemplate.com main content

Appliance Repair Service Bill Templatec5020

Appliance Repair Service Bill Template

"Appliance Repair Service Bill Template" was found to be relative to Simple Invoice Templates with the score grade of 99.

... A common requirements in the appliance repair business is that you need some fields to record the identifier of the device / appliance. Like in the auto repair invoice design, there are fields for auto maker, auto color and auto model. In this form design, there two fields designed for this purpose, which are "Computer Model" and "Computer Serial#". If you want to modify these labels to more common words like "Appliance Model" and "Appliance Serial#", it is easy to do with the help from Uniform Invoice Software. You can simply switch to design mode by clicking the "Design Mode" button on Excel "Invoice" ribbon tab, and then type in your own text to replace the existing labels. In fact, your own business name (as a service provider), address and contact information are entered in the same way.

Simple Proforma Invoicing Samplec6019

Simple Proforma Invoice Format

"Simple Proforma Invoicing Sample" was found to be relative to Simple Invoice Templates with the score grade of 90.

... If you use the Uniform Invoice Software version of Simple Proforma Invoicing Sample, there are additional taxing options on the Taxes tab of the Settings window. The first is the option for choosing the number of tax items; you have 3 choices - no tax, one tax and two taxes. Secondly, you can set the names and rates in percentage for each tax, such as VAT, GST or PST, or simply Sales Tax. Thirdly, there are a group of checkbox options on the dialog box, including: "Tax invoice total including shipping cost", which adds the shipping cost to the taxable amount when checked; "Tax 2 is applied to tax 1", which adds the amount of "tax 1" to the taxable amount if checked; and "tax rate can be zero", which allows you to set any of the tax rates to be the value of zero. If you modify the options on this dialog box, the spreadsheet will be changed accordingly if needed.

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

Simple Sample - Total Quantity on Sales Reportc4103

Simple Format - Total Quantity on Sales Report

"Simple Sample - Total Quantity on Sales Report" was found to be relative to Simple Invoice Templates with the score grade of 90.

  1. First, make sure you have created a backup copy of the template.
  2. Open the template / spreadsheet file.
  3. Click "Invoices" on the "Invoice" ribbon tab.
  4. Click "Custom Fields" on the toolbar to open the "Custom Field Manager" dialog box.
  5. Make sure "Database Table" is showing "Invoice Header".
  6. Click "Add Field" to open the "Add New Custom Field" dialog box.
  7. Enter: Field Name - TotalQuantity; Type - Decimal; Precision - 10; Scale - 2.
  8. Click "OK" to create the new "TotalQuantity" field.
  9. Close all dialog boxes and return to Excel form.
  10. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon. This allows you to modify the invoice design.
  11. Click the cell where you want to place the quantity total. In this sample, we choose $I$34 - i.e. the cell below the "Quantity" column.
  12. Enter the formula to calculate the sum of all quantities:
    =sum(oknQuantity_1:oknQuantity_12)
  13. On the formula bar, click to activate the name box located at the left-end, enter the cell name "oknTotalQuantity". Note this name must be the combination of the prefix "okn" and the database field name "TotalQuantity". This name creates the map between the Excel cell and the backend Access database field to store the value when you save an invoice.

Simple Consulting Bill with Printable Background Imagec4085

Simple Consulting Billing Template with Printable Background Image

"Simple Consulting Bill with Printable Background Image" was found to be relative to Simple Invoice Templates with the score grade of 84.

... As you can see from the samples we published here on InvoicingTemplate.com, Microsoft Excel is a fairly flexible form designer. As detailed on the Customizing Invoice Templates document, using Excel as the form designer you can customize the layout of the form by dragging and dropping, much easier than many other form designers, like HTML & CSS, Adobe PDF / AI. Adding a simple image to the original billing template assigns it a very different look and feel.

... Use the search tool to easily locate and download your favorite billing format. You don't have to be an artist or Excel professor to have a beautiful form. We've prepared a number of templates that you can choose from. Our templates are pure-Excel based template that are not locked with password, built without macros - just simple spreadsheet forms with Excel formulas to do basic calculations.

Basic Blank Service Invoice Format (One-tax)c2013

Basic Blank Service Invoice Format (One-tax)

"Basic Blank Service Invoice Format (One-tax)" was found to be relative to Simple Invoice Templates with the score grade of 78.

... Uniform Invoice Software is a special invoicing software app that uses Excel invoice templates as the front-end. The program is implemented as an Excel add-in program that runs inside Microsoft Excel. So after installing Uniform Invoice Software, you won't see a shortcut to the program as many other programs. What you'll see is a shortcut to the default invoicing format that is shipped with the setup program of Uniform Invoice Software. This default invoicing template is just the sample of the templates supported by Uniform Invoice Software. You can easily replace it with new templates available here on InvoicingTemplate.com. Simply download the template you like, extract the template (each template usually comes with a database file), and then double-click to open the template you like.

Invoicing Template in Eurosc4100

Invoicing Format in Euros

"Invoicing Template in Euros" was found to be relative to Simple Invoice Templates with the score grade of 74.

... As a simple customized sample of VAT invoice created for Germany (See c4098 Sales Invoicing Format for Germany and Service Billing Template for Germany), we make the currency symbol shown for the appropriate cells. This customization is easy and simple. If you are interesting in the details, here is how.

... As you can see, with Microsoft Excel it is fairly easy to change the format and layout of a form design. While there are many other templates available for billing and invoicing, like Microsoft Word or Publisher, Google Docs, OpenOffice.org, even HTML + CSS or Photoshop, it is much easier to do formatting with Microsoft Excel.

Basic Sales Invoice Template (Light Blue)c3001

Basic Sales Invoice Design (Light Blue)

"Basic Sales Invoice Template (Light Blue)" was found to be relative to Simple Invoice Templates with the score grade of 66.

  • In Excel 2003 click the Design Mode button on the Control Toolbox toolbar. Tip: If the Control Toolbox toolbar is invisible, click Excel menu View > Toolbars > Control Toolbox.
  • In Excel 2007, Excel 2010 and Excel 2013, click the Design Mode button in the Controls group of the Developer tab.

    TIP: If the Developer tab is not available in Excel 2007, do the following to display it: a) Click Microsoft Office Button, and then click Excel Options; b) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

    Or in Excel 2010 and Excel 2013 to display the Developer tab: a) Click File > Options > Customize Ribbon; b) In the area on the right, ensure that the box next to Developer is checked; c) When you click OK, the Developer tab will appear in the ribbon.

Basic Sales Invoice with Blue-violet Gradient Backgroundc3018

Basic Billing Format with Blue-violet Gradient Background

"Basic Sales Invoice with Blue-violet Gradient Background" was found to be relative to Simple Invoice Templates with the score grade of 64.

... The itemized detail section features 3 columns, "#", "Description" and "Amount". This "#" column is a line number column, but not the "Item#" or "Product ID" column as found in many other templates here on InvoicingTemplate.com. The value of the "#" column is filled automatically using an Excel formula like this:

... So when you fill in an invoiced item with the "amount" (field name "oknLinetotal_?") value, the "#" column is filled with a line # like "1, 2, 3 ..." etc.

... The "Amount" column on this field is manually editable on creating invoices. This is archived by removing all the formulas from the column, and then unlock the cells so that they are editable when the template is protected.

Basic Sales Invoice Template in Frenchc5065

General Sales Invoicing Form in French

"Basic Sales Invoice Template in French" was found to be relative to Simple Invoice Templates with the score grade of 54.

... To replace a label in English, such as "Invoice", with its French version, such as " FACTURE". With this implementation offered by InvoicingTemplate.com, we simply added a French label to its English version, so that "Invoice" on the default sales invoice template is now shown as " FACTURE/ INVOICE". The other examples are: "Bill To" becomes " Vendu à/Bill To", "Ship To" becomes "Expédié à/ Ship To", "Quantity" becomes " Qté/Qty ", "Price" becomes " Prix/Price", "Sub-Total" becomes " Sous-Total/ Sub-Total", "Paid" becomes " Payé/ Paid", "Total Due" becomes "Montant Dû/ Total Due", "THANK YOU" becomes " MERCI/ THANK YOU". The purpose of this sample is to demonstrate how easy it is to customize the our Excel invoicing templates, like what other samples on InvoicingTemplate.com show you.

Basic Service Invoice Template In Frenchc5066

General Service Invoicing Form in French

"Basic Service Invoice Template In French" was found to be relative to Simple Invoice Templates with the score grade of 51.

... The printable area, or print area, is the area with white background on the center of the Basic Service Invoice Template In French spreadsheet. By default Microsoft Excel prints the entire worksheet when you issue the print command, but if the worksheet has a print area defined, such as what we do for Basic Service Invoice Template In French, only the print area will print. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet again. If you need to recreate the print area definition, here are what to do: On the "Invoice" worksheet of the Basic Service Invoice Template In French, select the cells that you want to define as the print area; On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

Basic Blank Service Format (No-tax)c2012

Basic Blank Service Layout (No-tax)

"Basic Blank Service Layout (No-tax)" was found to be relative to Simple Invoice Templates with the score grade of 44.

... For an edition that supports one tax, please see Basic Blank Service Invoice Format (One-tax). For an edition that supports two taxes, please see Basic Blank Service Invoice Format (Two-taxes). If you need less lines but more space for each item description on your blank service invoice template, see Basic Blank Service Billing Format (No-tax, Long Description), and the one tax format at Basic Blank Service Invoicing Format (One-tax, Long Description), and the two-tax layout at Basic Blank Service Bill Format (Two-taxes, Long Description).

... 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 Lightweight Service Invoicec4073

Simple Lightweight Service Billing Format

"Simple Lightweight Service Invoice" was found to be relative to Simple Invoice Templates with the score grade of 43.

... Since this is a service invoicing template, it does not requires the shipping address fields. We've retargeted the fields so they are now designed for "Service Location", including fields for contact name, address, city state and ZIP. The "Bill To" section, like most invoicing templates here on InvoicingTemplate.com, are still there.

... This Simple Lightweight Service Billing Format has 4 columns on the detail section - Description, Quantity, Unit Price and Amount. The "Item#" column found on many forms here on InvoicingTemplate.com was moved out of the printable billing form. Although this column is not printed, or is not included when you are generating PDF invoices using Simple Lightweight Service Invoice Template, it is a required field for Uniform Invoice Software. An invoicing item (or line) is seen as incomplete if the item# is missing (this this case, if you want to save invoices without item# values, you have to enable "Allow incomplete lines on invoice body" option on the "Template" tab of the "Settings" dialog box (open it by clicking the "Settings" button on the invoice worksheet. Besides that, there is a useful feature assigned to the "Item#" cells by Uniform Invoice Software - you can type in the item# codes to retrieve the related description, unit price easily, so that you don't have to type in the text again and again on creating invoices. This feature is called "in-cell lookup" in Uniform Invoice Software. This feature also works for the Customer# ("oknWhoID") and Invoice# ("oknInvoiceID") cells.

Recipient Created Tax Invoices Formc4077

Template for Purchaser Created Tax Invoices

"Template for Purchaser Created Tax Invoices " was found to be relative to Simple Invoice Templates with the score grade of 33.

... On the upper-side of the invoice form you will find two sections "From Recipient" and "To-Supplier", where you, the buyer and the creator of the RCTI invoice, should provide detailed information about both businesses, both including Australian Business Number (ABN).

... The detail section of the form provides 4 columns, Description, Value, GST and Price, exactly like the PDF sample provided by Australian Taxation Office, where "Value" is the total amount of the invoicing item excluding GST, and "Price" equals to "Value" plus "GST". Since this template does not calculates "Value" from "Quantity" and "Unit Price", like what Australian GST Invoice Template and ABN Tax Invoice Template do, we've placed "Quantity" and "Unit Price" outside the printable form (which you can use to do the calculation, but will not be printed). The amount of GST will also be calculated automatically using Excel formulas based on the "Value" and tax rate, which can be set on the "Taxes" tab of the "Settings" window. To open the "Settings" window, click the "Settings" button on the "Invoice" worksheet.

Simple Consulting Invoice Templatec4034

Simple Consulting Billing Format

"Simple Consulting Billing Format" was found to be relative to Simple Invoice Template with the score grade of 31.

As a consultant you need a beautiful invoicing template to bill your clients, yet the template should be simple and easy to use. Simple Consulting Invoice Template might be your choice for creating invoices.

does not include the shipping address section on the printable invoicing form. If you need the shipping address fields, try

Simple Sample - Manually Fillable Line-totalsc2028

Simple Invoicing Format - Manually Fillable Line-totals

"Simple Invoicing Format - Manually Fillable Line-totals" was found to be relative to Simple Invoice Template with the score grade of 28.

... We've already seen sample on how to moving fields to create a new invoicing format in this serial of simple invoice templates. Such as with c4049 Simple Invoice Template - Moving Item# Column, we moved out the entire Item# column to create a new layout. Uniform Invoice Software is flexible enough to support this type customizations. By adjusting / customizing the formulas, it is also possible to define (or re-define) the relationship between cells.

Simple Welding Invoice Templatec5064

Simple Welding Invoice Template

"Simple Welding Invoicing Form" was found to be relative to Simple Invoice Template with the score grade of 22.

... Like most other templates here on InvoicingTemplate.com, Simple Welding Bill Template has a default logo image on the top of the invoice worksheet. This is a placeholder for your own logo image. To do this, you first have to unprotect the Invoice worksheet, and then switch the spreadsheet into design mode.

Simple Template - Moving Shipping Addressc5077

Simple Template - moving-shipping-address

"Simple Template - moving-shipping-address" was found to be relative to Simple Invoice Template with the score grade of 22.

... This customized simple invoice template is based on the result of c5076 Simple Invoice Template - Moving Taxable Controls, which was categorized as sales invoice template because it contains the shipping address section.

... Usually creating a new invoice template that works an invoicing software app sounds difficult. This is not true with Uniform Invoice Software, which is our invoicing software that use Excel spreadsheets as the front-end.

Simple Service Invoice Templatec4033

Simple Service Billing Format

"Simple Service Billing Format" was found to be relative to Simple Invoice Templates with the score grade of 7.

Simple Service Invoice Template is a service billing format designed under the need to itemize all the service that you offered. And by using this beautiful layout, you will able to collect all the information regarding all services that you performed.

... This invoice template is designed in a very convenient way. Creating invoices using Simple Service Invoice Template is just like filling in a blank paper form, so there is no hard learning curve. If you need more features such as tracking customer accounts, items, invoices and payments, this service invoice template also has a Uniform Invoice Software edition. The Uniform Invoice Software offers exactly the same layout as the freeware edition of Simple Service Invoice Template / Simple Service Billing Format, but with many functional buttons on the form, such as "Customers", "Products", "Invoices", "Save To DB", "Settings". For example, by clicking the "Save To DB" button, you can save the current invoice to the backend database, and if the invoice# cell is left blank, Uniform Invoice Software will automatically generates an invoice# for you, based on the rules defined on the Settings window. Uniform Invoice Software also supports networking, which means several users on the network can share database, so that, for example, one employer is responsive for entering customer data, and another employer in the accounting department is responsive for processing payments.

... Note that the "InvoicingTemplates" logo on the top of the invoice form is a placeholder, which you should replace with your own logo image. In order to do that, the invoice spreadsheet has to be switched to design mode.

Simple Invoice for Construction Businessc4046

Simple Billing Format for Contractor

"Simple Invoice for Construction Business" was found to be relative to Simple Invoice Templates with the score grade of 5.

... A printable invoice for use by a general contractor in the construction industry. Besides electronic format as either PDF or Excel spreadsheet (xlsx or xls) document, you can also print invoices. You need this simple invoice because you can use it anytime, anywhere. It has lines for description, quantity, rate, and amount, for both materials and labor. It automatically subtotals the items, adds sales tax and totals everything for you!

... 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 InvoicingTemplate.com too. If you charge based on hourly rates, visit Invoice Template Hourly Rate. A Handyman Invoice Template is also ready here for you.

Simple 2-Column Sales Invoice Samplec2002

Simple 2-Column Sales Invoice Form

"Simple 2-Column Sales Invoice Sample" was found to be relative to Simple Invoice Template with the score grade of 5.

...Simple 2-Column Sales Invoice Sample, like the default template, has two tax items on the bottom of the worksheet, which are applied to all the items, and a column of Taxable checkboxes to the left of the form body, which are corresponding to each invoicing item. You can change the tax names and rates on the bottom of the form by typing in whatever meet your requirements. These are the supported features implemented in both the freeware version and the Uniform Invoice Software version.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c5020
Appliance Repair Service Bill Template
Thursday, August 18, 2016,
12
5
A4
Portrait
Service
c6019
Simple Proforma Invoicing Sample
Thursday, October 9, 2014,
20
6
A4
Portrait
Pro-forma
c4103
Simple Sample - Total Quantity on Sales Report
Wednesday, November 23, 2016,
12
4
A4
Portrait
Sales
c4085
Simple Consulting Bill with Printable Background Image
Friday, August 19, 2016,
16
4
A4
Portrait
Consulting
c2013
Basic Blank Service Invoice Format (One-tax)
Monday, November 16, 2015,
12
2
A4
Portrait
Service
c4100
Invoicing Template in Euros
Tuesday, November 29, 2016,
12
4
A4
Portrait
Sales
c3001
Basic Sales Invoice Template (Light Blue)
Tuesday, April 22, 2014,
12
3
A4
Portrait
Sales
c3018
Basic Sales Invoice with Blue-violet Gradient Background
Sunday, October 30, 2016,
12
3
A4
Portrait
Sales
c5065
Basic Sales Invoice Template in French
Tuesday, September 23, 2014,
12
5
A4
Portrait
Sales
c5066
Basic Service Invoice Template In French
Wednesday, September 24, 2014,
12
5
A4
Portrait
Service
c2012
Basic Blank Service Format (No-tax)
Sunday, November 15, 2015,
12
2
A4
Portrait
Service
c4073
Simple Lightweight Service Invoice
Monday, May 9, 2016,
12
4
A4
Portrait
Service
c4077
Recipient Created Tax Invoices Form
Monday, July 4, 2016,
8
4
A4
Portrait
Sales
c4034
Simple Consulting Invoice Template
Friday, November 14, 2014,
6
4
A4
Portrait
Consulting
c2028
Simple Sample - Manually Fillable Line-totals
Tuesday, February 2, 2016,
12
2
A4
Portrait
Sales
c5064
Simple Welding Invoice Template
Monday, September 22, 2014,
12
5
A4
Portrait
Service
c5077
Simple Template - Moving Shipping Address
Wednesday, February 3, 2016,
12
5
A4
Portrait
Service
c4033
Simple Service Invoice Template
Wednesday, November 12, 2014,
6
4
A4
Portrait
Service
c4046
Simple Invoice for Construction Business
Thursday, November 12, 2015,
12
4
A4
Portrait
Service
c2002
Simple 2-Column Sales Invoice Sample
Monday, February 24, 2014,
12
2
A4
Portrait
Sales

What Is Hot

Feature Galleries