Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Advanced Invoicing Sample - Macro-Enabled Invoicing Template. Double-click the downloaded file to extract all files.
  2. Open the template "advanced-invoice-sample-macro-enabled-invoicing-template.xlsm" or "advanced-invoice-sample-macro-enabled-invoicing-template-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.

Advanced Invoicing Sample - Macro-Enabled Invoicing Template

Advanced Invoicing Sample - Macro-Enabled Invoicing Template (c5101)

c5101 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open advanced-invoice-sample-macro-enabled-invoicing-template-uis.xlsx.

Advanced Invoicing Sample - Macro-Enabled Invoicing Template (UIS Edition)

Advanced Invoicing Sample - Macro-Enabled Invoicing Template - UIS edition

Download Advanced Invoicing Sample - Macro-Enabled Invoicing Template (c5101)

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.

834 KBDownload

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

3.15 MBDownload

Detail

While most templates here on InvoicingTemplate.com are ".xlsx" and ".xls" formats, Uniform Invoice Software does work with macro-enabled invoice templates. This sample introduces the steps to use ".xlsm" workbooks and templates.

With the Simple Invoice Templates series we demonstrate how to do basic customizations on create and customizing your own bill format for your business, such as how to change fonts, move cells to create a new layout, change formulas to create a new business logic, etc. See this document to find out more information on the rules and guidelines on creating your own invoice template.

If you are an expert in Microsoft Excel if may want to do more with your invoice template. One of the advanced way is to use Excel macros.

Uniform Invoice Software supports all the Excel file formats, including the traditional ".xls" and ".xla" formats, and the new ".xlsx" (Excel XML-based file format), ".xlsm" (Excel XML-based and macro-enabled file format), and ".xlsb" (Excel Binary (or BIFF12) file format). ".xlsx" are now the most widely used workbook file format. Feel free to see our Invoice Template ".xlsx" topic page.

To convert an Excel workbook or template from ".xlsx" to ".xlsm" format, simply issue the "File" and "Save As" command. We'll skip the detailed steps here as there are already many resource online, such as Create a Macro in Excel - EASY Excel VBA, and How to Use Macros in Excel: 15 Steps (with Pictures), and Quick start: Create a macro.

The sample invoice template used here is c5099 Standard Business Invoicing Template. See our business invoice templates for more samples that are most closely related to "BUSINESS".

One of the major concerns about using macro-enabled templates is that security settings of Microsoft Excel. If the macro you create does not have a digital signature, with the default security settings Excel disables it with a warning message shown.

To overcome this you have to either lower the security level, or sign your macro code. Lowering Excel security level is not recommended, so the best way is to digitally sign your Excel macro. See Digitally sign your macro project for more information. Refer to c5102 - Advanced Invoice Sample - Invoiced Total in English Words for a working sample of using and digitally signing your Excel macros.

Like other form designs here on InvoicingTemplate.com, Advanced Bill Sample - Macro-Enabled Billing Template is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

Template#c5101
NameAdvanced Invoicing Sample - Macro-Enabled Invoicing Template
CategorySales Invoice Template
Release DateSunday, November 20, 2016
Format (XLS or XLSX).xlsm
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines12
Line Height (Points)18.00
Print Area$D$3:$K$46
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left18.00
Right18.00
Top75.60
Bottom75.60

Sample Templates