Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Auto Repair Invoicing Sample (2). Double-click the downloaded file to extract all files.
  2. Open the template "autorepair2.xls" or "autorepair2-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Auto Repair Invoicing Sample (2)

Auto Repair Invoicing Sample (2) (c5049)

This is how the template looks like when you open the freeware template in Microsoft Excel.

Auto Repair Invoicing Sample (2) - freeware edition

Auto Repair Invoicing Sample (2) - freeware edition

The following template was designed for Uniform Invoice Software version 3.

Auto Repair Invoicing Sample (2) - Uniform Invoice Software V3 edition

Auto Repair Invoicing Sample (2) - Uniform Invoice Software V3 edition

Download Auto Repair Invoicing Sample (2) (c5049)

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

365 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.82 MBDownload

Detail

Auto Repair Invoice Template (2) is a sample on customizing Auto Repair Invoice Template (1). This sample adds a drop-down list box to the original design, allowing to select car model from a list, instead of typing in manually.

In the original format design, the "model" field is a simple Excel cell, or we can call it a text box, which allows you to enter the model manually. While the freely editable field makes it possible to enter any value into it, a drop-down box makes entering car model much easier and avoids typo errors.

There are other sample formats online too, such as Word, HTML or PDF, but Excel is our favorite here at InvoicingTemplate.com. The auto invoicing example given here demonstrating just one advantage of using Microsoft Excel based form designs. By using a drop-down list box instead of a manually editable text field, you can draft an invoice much easy than before.

If you are interesting in the Uniform Invoice Software (UIS) version of our templates, don't worry - adding the drop-down list to the Excel spreadsheet will not break UIS. UIS welcomes any customizations and designs you could make with Microsoft Excel, as long as you adhere to the guidance described in the "Customizing Invoice Template" document included in UIS. This customized format, like all the other templates available here on InvoicingTemplate.com, are just examples of how to customize the default sales invoicing sample shipped with UIS - a generic format that is suitable for many business types. So to speak, InvoicingTemplate.com offers not only general invoice online, but also special formats that are suitable for different business types. Invoices are the important part in business and trading, so make sure your forms meet your business requirements.

During the past several years, we've designed thousands customized designs and templates that meet requirements of different business and work with UIS - which is formerly named Excel Invoice Manager and hosted on Office-Kit.com. Both Office-Kit.com and InvoicingTemplate.com are web sites built and running by Uniform Software Ltd. We'll put the templates online here on InvoicingTemplate.com. Each customized template comes with two editions - one free edition that works without UIS, and another enhanced edition that should run with UIS installed.

If you are running a small business that creates invoices rarely, a free invoicing template helps you draft your invoices and cash receipts in an easy and quick way and the documents created by the templates look professional. If you need more control over your business, such as managing customers, products, invoices and payments, UIS is your choice. InvoicingTemplate.com is providing you with the fully functional trial version. Feel free to download and try the trial version - no license key or registration code is required to run the trial version within the trial period. You or your company need to purchase nothing in order to trial our invoicing software.

All templates offered here on InvoicingTemplate.com are not protected and are not locked. You don't need a password or special key in order to modify it. For example, if you use the UIS version, you can even create a credit memo template or credit note template based on the sample templates provided here. Remember that professional and beautiful business documents, such as the ones created by this printable form design, do help you collect your money easy and quick.

So how do we at InvoicingTemplate.com design this customized auto repair billing form based on the previous layout? It is in fact easy if you know Excel a little. Our procedures are as follows: unprotect the Invoice worksheet in the Excel spreadsheet and switch to design mode; select the area where you want to put your car / vehicle model list - in this sample, we choose to place the model list to the right side the printable area, starting from Q16, so that you can easily add new entries to it whenever needed. Once the car models are setup, you can then easily go to the Data ribbon tab, execute the Data Validation command to create the drop-down list.

The protection of the "Invoice" worksheet in Auto Repair Invoicing Sample (2) 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 Auto Repair Invoicing Sample (2).

In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Auto Repair Invoicing Sample (2). Note that if you have our invoicing program installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products, bills and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.

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

Once you have finished your design work for Auto Repair Invoicing Sample (2), click the Design Mode button again to exit design mode.

To show gridlines and row/column headers in Excel 2000 - 2003:

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. On the Tools menu, click Options, and then click the View tab.
  3. Under Window options, check the Gridlines and Row & Column Headers check boxes.

After your customization, go back to the Tools menu, Options, View tab. Under Window options, REMOVE the checks you previously placed by the two check boxes to hide gridlines and row/column headers. This will restore the appearance of your template.

To show/hide gridlines and row/column headers in Excel 2007, Excel 2010 and Excel 2013:

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. Go to the View tab of the Ribbon.
  3. Click Show/Hide, and then check or uncheck the Gridlines and Headings options.

The gridlines and row/column headings could help a lot when design the layout of the form.

To UIS version users: The form is protected to prevent accident modifications to layout and formulas. If you unprotect the sheet and try to close it, UIS prompts a warning message about the protection status of the template. If you want to be able to change the list when creating invoices, you should unlock the range starting from Q16.

The "Lock" property is a very useful feature in Excel. When you protect a worksheet such as Auto Repair Invoicing Sample (2), all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the "Invoice" worksheet of Auto Repair Invoicing Sample (2). To lock a cell or a range of cells, first drag your mouse to select the cell or cells, and then right-click one of the selected cell on the form, choose Format Cells. On the Number tab, check the "Locked" box. To unlock a cell or a range of cells, simply clear the "Locked" box.

Tip: If you create a formula for a field or a cell be sure to lock it otherwise a warning mark appears on the cell. On the other hand, if you remove a formula from a locked cell in Auto Repair Invoicing Sample (2), unlock the cell to make sure it is editable when Auto Repair Invoicing Sample (2) is protected.

Once everything is prepared, it is the time to use the Data Validation to create the drop-down list.

Data validation is an Excel feature that you can use to define restrictions on what data can or should be entered in a cell. You can configure data validation to prevent users from entering data that is not valid. If you prefer, you can allow users to enter invalid data but warn them when they try to type it in the cell. You can also provide messages to define what input you expect for the cell, and instructions to help users correct any errors. One thing you may not be aware of is that, most of the templates available here on InvoicingTemplate.com, including this Auto Repair Invoicing Sample (2), as well as the default spreadsheet template shipped with Uniform Invoice Software setup program, are using Data Validation to prevent incorrect data being entered.

The data validation tool, as shown in this example of Auto Repair Invoicing Sample (2), is one of the good examples of how Microsoft Excel-formatted templates could be an ideal tool for creating invoices and receipts. You may find business templates, whether free or not, available online in other formats, such as Microsoft Word, HTML or even PDF. But only Excel-formatted templates allows the end users without any programming knowledge to add features like what offered by the Data Validation tool. This is one of the important reasons why InvoicingTemplate.com choose to offer you invoicing templates in Microsoft Excel format.

Among other things, you can use data validation to do the following: 1), Restrict data to predefined items in a list; 2), Restrict numbers outside a specified range; 3), Restrict dates outside a certain time frame; 4), Restrict times outside a certain time frame; 5), Limit the number of text character; Validate data based on formulas or values in other cells. This template, Auto Repair Invoicing Sample (2), uses the first technique to create a drop-down list.

As shown in this example of Auto Repair Invoicing Sample (2), when you create a drop-down list for a cell, it displays an arrow in that cell. To enter information in that cell, click the arrow, and then click the entry that you want.

Creating the drop-down list is in fact easy and quick in Excel. First, you must have the list of valid entries prepared. To create a list of valid entries for the drop-down list for Auto Repair Invoicing Sample (2), type the entries in a single column or row without blank cells. Now select the cell where you want the drop-down list added for Auto Repair Invoicing Sample (2). On the Data tab, in the Data Tools group, click Data Validation. In the Data Validation dialog box, click the Settings tab. 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; 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. Close the dialog box to have Excel creates the drop-down list for Auto Repair Invoicing Sample (2).

So with some simple clicks and entries, we have added a drop-down list to this template. There are many more things you can do with Excel. Feel free to play with it and use our invoicing templates as samples of creating your very own invoicing and billing templates.

Like other form designs here on InvoicingTemplate.com, Blank Vehicle Repair Invoice (2) is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2003, 2007, 2010, 2013 or 2016.

Format and Specification

Template#c5049
NameAuto Repair Invoicing Sample (2)
CategoryService Invoice Template
Release DateSaturday, January 18, 2014
Format (XLS or XLSX).xls
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines12
Line Height (Points)19.50
Print Area$F$2:$N$44
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates