This is a chapter of Uniform Invoice Software's help document. To get the help document, download and install Uniform Invoice Software, open the default template by clicking "Invoice.xlsx" shortcut on Windows desktop, and then click "Help" on the "Invoice" ribbon tab.
Customizing invoicing templates means creating your own templates that can interact with Uniform Invoice Software and connect to databases to store and retrieve data. All templates here on InvoicingTemplate.com are created based on these rules.
Please read this document carefully before customizing your template.
An invoice template uses a number of hidden properties and cells to identify itself as a valid invoice template so that the Uniform Invoice Software can and will interact with it.
Because of this, generally it is not recommended to create a template or workbook from scratch using Microsoft Excel. It's better to create a new invoice template based on an existing valid invoice template. To do this, copy an existing invoice template using your Windows Explorer, and customize that copy to create your own invoice workbook.
However if you still want to integrate your existing template with Uniform Invoice Software, or create a new format from scratch, the steps are detailed with the sample at c4056 Simple Sample - Building & Remodeling Invoice.
An invoice template has two states: design mode and run mode. In design mode, the Uniform Invoice Software will stop interacting with the invoice template, so that you can move, add, or delete controls or cells.
To switch to design mode, click thebutton on the ribbon tab. Click this button again to exit design mode.
By default, theworksheet is protected. You need to unprotect it for most of the customization work. To unprotect the worksheet, in Excel 2007/2010/2013 click the button in the group of the tab.
It is strongly recommended that you protect the worksheet again after your customization. To protect a sheet, just click the same button again.
If a worksheet is protected, locked cells and those cells that contain formulas are not manually editable. To lock or unlock a cell:
When customizing a workbook, it is very helpful to display gridlines and row/column headers. To show gridlines and row/column headers in Excel 2003:
After your customization, go back to themenu, , tab. Under , 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 workbook.
To show/hide gridlines and row/column headers in Excel 2007/2010/2013:
All objects in an invoice workbook, including ActiveX controls, drawing objects and cells, are identified by names.
To distinguish from other names, all names used by Uniform Invoice Software are prefixed with okn (Office-Kit.com's Name).
In Excel, names are available to any sheet. For example, if the name oknID refers to the range A20:A30 on the first worksheet in a workbook, you can use the name oknID on any other sheet in the same workbook to refer to range A20:A30 on the first worksheet.
To name a drawing object or cell:
To name an ActiveX control object:
See your Excel help document for more information about using names.
Microsoft Excel has two types of controls. ActiveX controls are appropriate for most situations. Forms Toolbar Controls are compatible with earlier versions of Excel, beginning with Excel version 5.0, and can be used on XLM macro sheets.uses a number of standard ActiveX controls, such as buttons, check boxes, and graphics.
To add an ActiveX control:
If a worksheet has defined a PRINT_AREA name and it refers to a range of cells, Excel will print the specified area instead of the whole sheet when you click the printable invoice template)command on the Excel menu. (See our template gallery at
In the invoice workbook, each worksheet contains a PRINT_AREA name. You can view what the name refers to by selecting PRINT_AREA from thebox at the left end of the formula bar. If you want to redefine the PRINT_AREA name, follow the steps below:
By default, all objects added to a worksheet are printable. You may want to exclude some of them from printing, such as the Customer Selection button on theworksheet (seen in the default invoice template shipped with Uniform Invoice Software version 3 and earlier versions).
To exclude a Drawing Object from printing in Excel 2007/2010/2013:
To exclude an ActiveX control from printing:
Since all the cells/fields and controls are identified by names, you can easily redesign the layout by moving cells/fields/controls. For example, if you don´t want to show the, cells/fields on your printed invoice, you can move them out of the Print_Area:
To move a control:
To make the extracted worksheet as clean as possible, all ActiveX controls and drawing objects will be removed from the extracted worksheet. If you want to keep an ActiveX control or a drawing object, add a prefix oknUser_ or oknWidget_ to its name. For example, a logo image could be named, instructing Uniform Invoice Software to keep the logo image on the extracted document.
This free quotation and estimation template in Microsoft Excel ".xlsx" format provides a sample of customizing the default invoice template shipped with Uniform Invoice Software. It implements a special / complex discounting model to meet practical business requirements.
This blank service invoice template adopted Chinese auspicious clouds borders to beautify the bill form. The borders does not show when you are creating or editing an invoice, but it is printable with the billing form, and will also be included in the PDF blank service invoice generated with UIS.
This free sample law firm invoice template provides an easy way to create professional bills and invoices for law firms / law offices and attorneys. Here you can find the template both in MS Excel format ("xlsx" format) and PDF format created by Uniform Invoice Software.
In most business situations the quantity numbers on an invoice are not addable - for example, if you are invoicing for both goods sold and service rendered. But there are cases where you want to add up quantities on an invoice and show the sum on the sales report.
Starting from Uniform Invoice Software version 5, a new Excel add-in module "Uniform Invoice Software Helper" was introduced to provide functions for the Excel on-sheet buttons on the Invoice and report worksheets. This sample demonstrates how you can call the action procedures from your own macro.
This blank service invoice template is a redesigned version of c3008 Blank Service Invoicing Template. This customized version keeps most of the fields found in the original design, but have a complete new look and feel due the addition of the image borders.
As a business document, an invoice sent by a business to a client to denote an obligation to pay for goods or services. One of the most important fields is the total amount to pay. This sample invoicing template shows you how to show the invoiced total in English words.
Do you like New York, the state in the northeastern United States? You can even add it to your invoices and bills! This free downloadable invoicing template for Microsoft Excel (".xlsx" format) provides a sample on how to add a watermark of New York.
Download this free simple VAT invoice template in Excel format for invoicing in Euros. This design has a similar layout as the German version. The differences are that all labels are in English, and it shows the Euro symbol on cells, and also has a Euro watermark on the form.
This Excel template (".xlsx") is based on c1001 Construction Proposal Template / Construction Estimate Form. This new construction contract template adds a background watermark of urban buildings and tower crane.