Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Standard Business Invoicing Template with Oval Button. Double-click the downloaded file to extract all files.
  2. Open the template "standard-business-invoicing-template-with-oval-button.xlsx" or "standard-business-invoicing-template-with-oval-button-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.

Standard Business Invoicing Template with Oval Button

Standard Business Invoicing Template with Oval Button (c5099)

c5099 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open standard-business-invoicing-template-with-oval-button-uis.xlsx.

Standard Business Invoicing Template with Oval Button (UIS Edition)

Standard Business Invoicing Template with Oval Button - UIS edition

Download Standard Business Invoicing Template with Oval Button (c5099)

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.

791 KBDownload

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

3.15 MBDownload

Detail

This free Excel standard business invoicing template is a advanced customization variant of the default invoicing template shipped with Uniform Invoice Software version 5. A PDF sample invoice is also provided.

With Uniform Invoice Software version 5 (UIS), we use a new way (through Uniform Invoice Software Helper add-in macro) to capture and relay the clicks events occurred on the Excel form. By using this method, we are no longer relying on ActiveX buttons that were used since Excel Invoice Manager (August 1, 2005). Instead, all shapes objects in Excel that can have a macro assign to could be used as a button. We've already have several samples that explains the new features of the standard invoice template released with UIS, such as c5094 UIS version 5 Standard Invoice Template and Shortcut Keys, which introduces the layout features and shortcut keys assigned to each button; and c6025 Standard Invoicing Template with EAN, which shows you how to add an EAN column to the default form design by using custom fields (i.e. user-defined fields). See Standard Invoicing Templates for more samples on this topic.

Along with the release of Uniform Invoice Software 5, all Excel invoicing Templates here on InvoicingTemplate.com are converted to use the new button types supported by UIS 5. UIS 5 itself also includes an auto-upgrade procedure, which converts all ActiveX button to text-box buttons automatically. So if you are upgrading from earlier versions of Uniform Invoice Software, you don't have to worry about to redesign your template or lost the support of on-sheet buttons.

Both the buttons existing InvoicingTemplate.com templates, and those converted by UIS 5, are all traditional rectangle buttons. As mentioned before in this article, any shape objects could be used as a button if the shape object could have a macro assign to. In this sample, we change the "Save As New Customer", "View Customer Info." and "Same As Bill To" button to oval buttons. Although this is an advanced customization technique, you can do it yourself if you follow the steps carefully. In this tutorial, we'll use Microsoft Excel 2013.

  1. Before we begin the customization procedure, back up the template first. Do this by simply copying the template in Windows Explorer.
  2. Open the template.
  3. Switch to design mode button by clicking the "Design Mode" button on the "Invoice" worksheet. This command combines several switches and options from Microsoft Excel: unprotect the worksheet, push down the "Design" button on the "Developer" ribbon tab, show gridlines and row/column headings. In design mode, UIS stops react to clicks on buttons, so that you can move / resize the buttons and other objects.
  4. Right-click to select the "Save As New Customer" button. When creating invoices, you can use this button to create new customer accounts, or update existing customer record.

    Note you may have to right-click on the area near the border on the button. Otherwise you are activating the button text to make it editable. Right-clicking on the area near the border of the button makes you are selecting the shape object itself, but not the text / label inside it.

  5. Click to activate the "Format" Excel ribbon tab.
  6. From the "Insert Shapes" group, click to pull down "Edit Shape", and then choose "Change Shape", and then from the "Basic Shapes" group choose the first one "Oval" - Excel changes the "Save As New Customer" from rectangle to oval.
  7. Repeat the above steps for "View Customer" and "Save As Bill To" buttons. The "View Customer" button allows you to open the "Edit Customer" window for the client identified by the "oknWhoID" cell value (i.e. the client#), which will show you the detailed account information including account receivable, detailed contact information, or you can click the "History Invoice" button on the "Customer Edit" window to get a list of all invoices of this particular customer, where pending, paid and void invoices are marked with different colors.

    The "Save As Bill To" button simply copies the address and contact information filled in the "Bill To" section to the "Ship To" section. This could be a handy time-saver when it could be used.

  8. You can of course change other buttons like "Customers" and "Products", "Reports" etc. To keep this tutorial simple and clear, we'll stop here.
  9. Now exit design mode by clicking the "Design Mode" button again on the "Invoice" worksheet.
  10. Save the template by clicking the "Save" button on Excel quick access toolbar.

With this customized version of the standard business invoicing format, a new business image is also add to the top of the form. This is a background image, which is shown only on printed invoices and bills, or UIS-generated business invoices. This image shows a team of business people. The image / picture is adjusted to 35% opacity globally, and also has a gradient opacity from the top to bottom applied using Adobe Photoshop.

If you want to make the business invoice really private or special to your own small business, whether a cooperated / limited company or a group of freelancers - you can even show your own / real sales team or service team on the background of your invoices. This might be an easy and quick to let the invoiced party pay attention to your invoices, products and services.

Like other form designs here on InvoicingTemplate.com, Standard Business Invoicing Format with Oval Button 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#c5099
NameStandard Business Invoicing Template with Oval Button
CategorySales Invoice Template
Release DateMonday, October 24, 2016
Format (XLS or XLSX).xlsx
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