Skip to main content
InvoicingTemplate.com main content

Standard Invoice with Double Borderc5085

Standard Invoice Format with Double Border

"Standard Invoice Format with Double Border" was found to be relative to Standard Invoice Templates with the score grade of 97.

...(37) This is the standard (default) invoice template shipped with Uniform Invoice Software installer program but with double-border added. This sample template also demonstrates how to add row, column to an existing form and redefine the printable area.

  1. Drag your mouse to select the entire new "Print_Area". In this sample, it is $C$2:$L$48. Tip: you can just the the "Print_Area" name from the name box on the formula bar.
  2. Right-click one of the select cell and choose "Format Cells".
  3. Go to the "Border" tab.
  4. From the "Style" list, choose the double-border style.
  5. Choose a proper color.
  6. In the "Border" section, click the borders respectively.
  7. Click OK to close the "Format Cells" dialog box.

...(27) Step 6: Adjust the height of the newly added rows, adjust width of the newly added columns, to make proper margins between the borders and actual content.

Australian GST Invoice Templatec7018

Australian GST Billing Form

"Australian GST Invoice Template" was found to be relative to Standard Invoice Templates with the score grade of 97.

...(34) Australian GST Invoice Template is a sample of customization of the default sales invoice template. Australian GST Invoice Template implements the invoice layout and form according to Australian Government / Australian Taxation Office requirements.

...(31) This customized invoice template is suitable for companies whose goods or services include GST. As Australian Taxation Office and the law required, the billing form should include information as detailed below.

  • the identity of the supplier, such as the business name at the top
  • the Australian business number (ABN) of the supplier at the top, near the supplier's identity
  • the date of issue of the tax invoice at the top, on the right hand side
  • that the document is intended as a tax invoice, such as including the words 'tax invoice' at the top
  • an invoice number shown prominently alongside the words 'tax invoice'
  • the purchaser's identity such as a name or ABN, for goods or services costing $1,000 or more
  • a unit description of each good or service supplied, including quantities - it is optional to include item numbers, and
  • the GST exclusive price, the GST amount and the GST inclusive price for each item, together with the totals for these, vertically in the bottom right hand corner.

Standard Business Invoicing Template with Oval Buttonc5099

Standard Business Invoicing Format with Oval Button

"Standard Business Invoicing Template with Oval Button" was found to be relative to Standard Invoice Templates with the score grade of 96.

...(31) 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.

...(74) 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.

UIS V5.11 Standard Invoice Template and Shortcut Keysc5094

Standard Invoice Format and Shortcut Keys for UIS Version 5.11

"UIS V5.11 Standard Invoice Template and Shortcut Keys" was found to be relative to Standard Invoice Templates with the score grade of 89.

...(36) Uniform Invoice Software version 5 includes a new default / standard invoice template shipped with the installer program. This document explains the changes made to the template, and the default hotkeys defined by this new version.

#CommandShortcut KeyName
1Clear & NewCTRL + SHIFT + CoknCmdClear
2Save To DB (Save Invoice)CTRL + SHIFT + SoknCmdSave
3Extract / EmailCTRL + SHIFT + EoknCmdExtract
4PrintCTRL + SHIFT + PoknCmdPrint
5PaymentCTRL + SHIFT + AoknCmdPayment
6DetailCTRL + SHIFT + DoknCmdDetail
7CustomersCTRL + SHIFT + UoknCmdCustomer
8ProductsCTRL + SHIFT + RoknCmdProduct
9InvoicesCTRL + SHIFT + IoknCmdInvoice
10ReportCTRL + SHIFT + OoknCmdReport
11SettingsCTRL + SHIFT + ToknCmdSettings
12HelpCTRL + SHIFT + HoknCmdHelp
13As As New CustomerCTRL + SHIFT + VoknCmdSaveAsNewCustomer
14Customer EditCTRL + SHIFT + MoknCmdCustomerEdit
15About / RegistrationCTRL + SHIFT + BoknCmdAbout
16Same As Bill ToCTRL + SHIFT + LoknCmdSameAsBillTo
17Pick CustomerCTRL + SHIFT + F1 
18Pick Shipping AddressCTRL + SHIFT + F2 
19Pick Sales Rep. NameCTRL + SHIFT + F3 
20Pick "Ship Via" / Shipping MethodCTRL + SHIFT + F4 
21Pick Payment TermCTRL + SHIFT + F5 
22Pick Product / ItemCTRL + SHIFT + F6 

Customization of Standard Fieldsc4108

Customization of Standard Database Fields

"Customization of Standard Fields" was found to be relative to Standard Invoice Templates with the score grade of 86.

...(42) Standard fields are those that already created in the default database file shipped with Uniform Invoice Software (UIS), as opposed to custom fields (i.e. user-defined fields) which you should create yourself. This template demonstrates how to change the definition of standard fields.

  • When the Invoice worksheet is active, push the "Design Mode" button on the "Invoice" ribbon tab.
  • Click and choose the customer name cell that is named "oknWhoName".
  • Go to "Data" Excel ribbon tab, and then click "Data Validation" in the "Data Tools" group.
  • Specify the new validation - for this example, you just need to modify the "Maximum" field to be 80.
  • Exit design mode.
  • Save the invoice template.

Standard Invoicing Template with EANc6025

Standard Invoicing Template with EAN

"Standard Invoicing Template with EAN" was found to be relative to Standard Invoice Templates with the score grade of 72.

...(32) This is a variant of the standard invoice template shipped with Uniform Invoice Software installer program. This sample layout differs from the original version in that it has added an EAN column.

...(101) The additional EAN field is a custom field. Since this field is a property of an invoiced item (i.e. it should be saved along with the other product details such as description, price etc.), so it must be added to the "Product" database table; The EAN must also be saved along with each invoice, so this field must be added to the "Invoice Body" (i.e. "InvBdy") database table too. Note the field definitions in both tables must be exactly the same. In this sample template, it is "text (13)" - meaning the field is able to store up to 13 characters.

Clothing Store (Manufacturer) Invoice Template with Item Pickup Buttonscm004

Clothing Store (Manufacturer) Invoice Format with Item Pickup Buttons

"Clothing Store (Manufacturer) Invoice Format with Item Pickup Buttons" was found to be relative to Standard Invoice Templates with the score grade of 66.

...(50) This invoicing template for clothing stores or manufacturers is a variant of cm003 Clothing Store (Manufacturer) Invoice Template with Size Breakdown. It differs from the original edition in that this variant adds back the buttons that you can click to pick up customer, shipping address, sales representative and payment term.

...(54) Without the item picking buttons, like what we implemented with cm003 Clothing Store (Manufacturer) Invoice Template with Size Breakdown, or the standard invoice template shipped with Uniform Invoice Software, you can use the "on-sheet picker", which appears when you click and select a supported cell. However there are users that prefer the static buttons.

...(18) So with sample template, we look at how to add a button that allows you to pick customer.

ABN Tax Invoicec7028

ABN Tax Invoice Format

"ABN Tax Invoice" was found to be relative to Standard Invoice Templates with the score grade of 66.

...(46) According to Australian Taxation Office, tax invoices for sales of $1,000 or more need to show the buyer's identity or ABN. These invoices are also called ABN tax invoices. This ABN tax invoice template include space for you to detail the ABN codes for your business.

Note that if you use the Uniform Invoice Software and need to show the control on an extracted worksheet, then the control should be named with an "oknWidget_" prefix. For example, if you move the Taxable checkboxes into the , then the checkboxes should be named with "oknWidget_" prefix, such as oknWidget_taxtable1, oknWidget_taxable2, oknWidget_taxable3...

Blank Service Invoice with Green Gradient Designc2031

Blank Service Invoice with Green Gradient Design

"Blank Service Invoice with Green Gradient Design" was found to be relative to Standard Invoice Templates with the score grade of 60.

...(40) With this blank service invoice template we applied green gradient effects to various titles and headings on the invoice form, resulting in a pastel and sophisticated design. The invoice layout support Excel themes so you can change the colors easily.

...(103) If you want to modify the tax formula to ignore the "Taxable" options, in design mode click to select the tax cell (which is named "oknTax1"). Excel formula bar shows the current tax formula, like "=ROUND( IF ( oknTaxType=0, 0 , oknTax1Rate * ( oknLineTotalTaxable + IF( oknTaxTotalIncludingShippingCost = 0 , 0 , oknShippingCost ) ) ) , 2 )". To have it ignore the taxable options, simply replace "oknLineTotalTaxable" with "oknSubtotal", so that the formula looks like "=ROUND( IF ( oknTaxType=0, 0 , oknTax1Rate * ( oknSubtotal + IF( oknTaxTotalIncludingShippingCost = 0 , 0 , oknShippingCost ) ) ) , 2 )".

Clothing Store (Manufacturer) Invoice Template with Discount Percentagecm005

Clothing Store (Manufacturer) Invoice Format with Discount Percentage

"Clothing Store (Manufacturer) Invoice Format with Discount Percentage" was found to be relative to Standard Invoice Templates with the score grade of 49.

...(37) The previous invoicing templates designed for clothing stores (manufacturers) define a discount amount field. This new cloth bill format in Excel added a discount percentage field, as in many cloth shops discounts are given in percentage first.

...(141) Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. Clothing Store (Manufacturer) Invoice Template with Discount Percentage uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

Invoicing Template for Roofing Servicec5098

Bill Format for Roofing Service

"Invoicing Template for Roofing Service" was found to be relative to Standard Invoice Templates with the score grade of 47.

...(42) Download this Excel and PDF roofing invoicing template for free. Designed for roofing / ceiling service providers, such as a cooperated company or a contractor / freelancer. With simple customizations, this sample could also be used as an estimate or contract form.

...(32) This template shows both "Quantity" and "Unit Price" columns on the printable form. You can also easily changed it to "Hours" and "Hourly Rate" in when the template is in design mode.

...(87) With Uniform Invoice Software installed, all buttons on the "Invoice" worksheet will go live, which makes sorting your roofing specialists invoices a piece of cake. Stop spending hours each week struggling with paperwork and missing payments with our easy-to-use Excel template powered with Uniform Invoice Software. Uniform Invoice Software also helps in creating PDF invoices. With proper options set on the "Email" tab of the "Settings" window, you can create and email the invoice in PDF format with a single click on the "Extract / Email" button.

Spin Button to Add or Subtract Onec4083

Sample Invoice Template with Spin Button

"Spin Button to Add or Subtract One" was found to be relative to Standard Invoice Templates with the score grade of 46.

...(32) With this sample invoice template we demonstrates how to spin button, which is one of the Microsoft Forms Controls. The spin button allows you add one or subtract one from a number.

  1. As always, backup your invoice template.
  2. Open the template.
  3. Push down "Design Mode" button on the "Invoice" ribbon tab.
  4. Switch to Excel "Developer" ribbon tab. If this tab is not available in your Excel, do the following to make it visible.
    • Right-click an empty area on Excel ribbon, choose "Customize the ribbon"
    • In the "Customize the ribbon" section, check the "Developer" option.
    • Click OK to confirm the change.
    • Now Excel shows the "Developer" ribbon.
  5. In the "Controls" ribbon group, pull down "Insert".
  6. In the "Form Controls" section, click "Spin Button" (the forth in the list).
  7. Now it returns to the worksheet. Click the location where you want to place the spin button to create it. If this case, we want to place it at the left side of the "Quantity" cell. You can move it by dragging and dropping.
  8. Drag the border of the spin button to resize it. Each single spin button has two click spots (an up arrow and an down arrow), it is recommended to make it as large as possible.
  9. Right-click on the newly inserted button, choose "Format Control". Excel shows the "Format Control" dialog box with the "Control" tab activated by default.
  10. Click the button on the "Cell link" section, specify to which cell this button will be linked. For our first spin button, the target cell is $I$20 (i.e. the first "Quantity" cell).
  11. With the spin button still selected, press "CTRL + C" on keyboard, and then "CTRL +V" to create a new button.
  12. Move the second new button to the second "Quantity" cell. Right-click on it and choose "Format Control", specify the linked cell for this second spin button to the second "Quantity" cell.
  13. Repeat the above steps to create spin buttons for the other 4 "Quantity" cells.
  14. Once you have done the customization, click the "Design Mode" button again to exit design mode.
  15. Save the template by clicking the "Save" button on Excel quick access toolbar.

South Africa Tax Invoice Template (Service)c4037

South Africa Tax Billing Format (Service)

"South Africa Tax Invoice Template (Service)" was found to be relative to Standard Invoice Templates with the score grade of 41.

...(34) South Africa Tax Billing Format (Service) is a variant of South Africa Tax Invoice Template (Sales), created by removing the shipping address section from the form and thus it is suitable for service provides.

...(239) Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in South Africa Tax Invoice Template (Service) before doing the movement. And, if the target location contains merged cells, sometimes the movement fails. So it is also helpful to make sure the target location does not contain merged cell. If the target location South Africa Tax Invoice Template (Service) is overlapping the original range and the original range contains merged cells, the movement could also fail because you cannot change part of merged cell - if this happens, you need to first move the cells to a temporal location in South Africa Tax Invoice Template (Service) that are empty (i.e. not used), unmerge cells, and then move the cells from the temporal location to the desired location. If you need to unmerge a cell, first select it and then click the "Merge and Center" command on the Format toolbar in Excel 2003; or click the "Merge and Center" command on the Home ribbon tab in Excel 2007, 2010 and Excel 2013.

Advanced Invoicing Sample - Macro-Enabled Invoicing Templatec5101

Advanced Bill Sample - Macro-Enabled Billing Template

"Advanced Invoicing Sample - Macro-Enabled Invoicing Template" was found to be relative to Standard Invoice Templates with the score grade of 38.

...(31) 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.

...(27) 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".

...(40) 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.

Proforma Invoice Template (4th Sample, Landscape Page Orientation)c7014

Proforma (4th Sample)

"Proforma (4th Sample)" was found to be relative to Standard Invoice Templates with the score grade of 28.

...(48) Now adjust the column widths to make it suitable for landscape A4 paper. Remember our goal is to have more space for the description column, so we'll mainly increase the widths of the Excel raw columns that are part of the Description column on the proforma invoice form.

...(115) To adjust the width of one column for Proforma Invoice Template (4th Sample, Landscape Page Orientation), drag the boundary on the right side of the column heading until the column is the width that you want. To change the width of multiple columns for Proforma Invoice Template (4th Sample, Landscape Page Orientation), select the columns that you want to change, and then drag a boundary to the right of a selected column heading. To change the width of columns to fit the contents for Proforma Invoice Template (4th Sample, Landscape Page Orientation), select the column or columns that you want to change, and then double-click the boundary to the right of a selected column heading.

Recruitment Agency Invoice Templatec3011

Recruitment Agency Invoice Template

"Recruitment Agency Invoice Template" was found to be relative to Standard Invoice Templates with the score grade of 25.

...(37) Recruiter agent, Recruitment Agency could use this Excel invoice template, which is one of the templates in the consulting invoice templates category, to bill their clients in an easy way by filling in a blank spreadsheet form.

...(81) With Uniform Invoice Software installed, when you click a line on the invoice body section, the on-sheet picker button appears. Click this button to pop-up a window that shows all the pre-saved items that are the products you sell or the service you render. This is a time-saving feature that avoids to type in the same / similar text or price again and again from invoice to invoice. The on-sheet picker also works for the "Invoice#" cell, the "Bill To" section.

Five Price Percentage Levels (Service, Custom Column)c5030

Form with 5 Price Levels

"Five Price Percentage Levels (Service, Custom Column)" was found to be relative to Standard Invoice Templates with the score grade of 16.

...(21) This is the eighth sample of the multiple-price serial invoice templates. The template uses percentage discounts, and has no shipping fields.

...(111) After moving out the "Shipping Date" field, you may like to expand the size of the neighboring fields to make the layout organized. This is done by expanding the Terms label and field. Expanding the "Terms" label is done by first selecting the original terms cell and the empty cells left by moving out the "Shipping Date" field, and then execute the "Merge and Center" command on Excel ribbon tab. To do this for the Terms field, you first need to move the original Terms cell to the first (left-most) cell of the empty space, and then select all the cells you want to merge, and then execute the "Merge" command.

Rental Invoicing Templatec7001

Rental Invoicing Template

"Rental receipt form" was found to be relative to Standard Invoice Templates with the score grade of 1.

...(112) The rent invoice design differs from the standard template in that is has two additional columns, Start Month and End Month, on the body of the rental invoice form. Rental Invoice as the name is very much synonym for hire and leasing activities, anything which was given for a third party for temporary use could be charged with this rental invoice. For this reason, it is necessary to detail the start and end date on the invoice. Every business is different, you might find our free rent invoicing template does not 100% meet your requirements. If this is the case you can still use our free template as a rent invoice sample.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c5085
Standard Invoice with Double Border
Friday, July 1, 2016,
12
5
A4
Portrait
Sales
c7018
Australian GST Invoice Template
Saturday, March 1, 2014,
17
7
A4
Portrait
Sales
c5099
Standard Business Invoicing Template with Oval Button
Monday, October 24, 2016,
12
5
A4
Portrait
Sales
c5094
UIS V5.11 Standard Invoice Template and Shortcut Keys
Thursday, September 29, 2016,
12
5
A4
Portrait
Sales
c4108
Customization of Standard Fields
Thursday, March 30, 2017,
6
4
A4
Portrait
Sales
c6025
Standard Invoicing Template with EAN
Wednesday, October 12, 2016,
12
6
A4
Portrait
Sales
cm004
Clothing Store (Manufacturer) Invoice Template with Item Pickup Buttons
Monday, October 10, 2016,
12
x
A4
Portrait
Sales
c7028
ABN Tax Invoice
Sunday, July 3, 2016,
17
7
A4
Portrait
Sales
c4105
Service Invoice with Horizontal Logo
Sunday, March 19, 2017,
12
4
A4
Portrait
Service
c2031
Blank Service Invoice with Green Gradient Design
Thursday, June 30, 2016,
6
2
Letter (8-1/2 in. x 11 in.)
Portrait
Service
cm005
Clothing Store (Manufacturer) Invoice Template with Discount Percentage
Tuesday, October 11, 2016,
22
x
A4
Portrait
Sales
c5098
Invoicing Template for Roofing Service
Sunday, October 23, 2016,
12
5
A4
Portrait
Service
c4083
Spin Button to Add or Subtract One
Friday, August 12, 2016,
6
4
A4
Portrait
Sales
c4037
South Africa Tax Invoice Template (Service)
Sunday, August 2, 2015,
12
4
A4
Portrait
Service
c5101
Advanced Invoicing Sample - Macro-Enabled Invoicing Template
Sunday, November 20, 2016,
12
5
A4
Portrait
Sales
c7014
Proforma Invoice Template (4th Sample, Landscape Page Orientation)
Monday, December 9, 2013,
20
7
A4
Landscape
Pro-forma
c3011
Recruitment Agency Invoice Template
Thursday, February 25, 2016,
12
3
A4
Portrait
Consulting
c5030
Five Price Percentage Levels (Service, Custom Column)
Monday, November 18, 2013,
30
5
A4
Portrait
Service
c9007
Commercial Invoice Format with Editable Word Art Logo
Wednesday, July 13, 2016,
9
9
A4
Landscape
Pro-forma
c7001
Rental Invoicing Template
Tuesday, December 10, 2013,
6
7
A4
Portrait
Service

What Is Hot

Feature Galleries