Skip to main content
InvoicingTemplate.com main content

Excel Payment Voucher Templatec5052

Payment Voucher Template

"Excel Payment Voucher Template" was found to be relative to Business Invoice Template with the score grade of 88.

... In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Excel Payment Voucher Template. 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.

Advanced Invoicing Sample - Invoiced Total in English Wordsc5102

Advanced Invoicing Sample - Invoiced Total in English Words

"Advanced Invoicing Sample - Invoiced Total in English Words" was found to be relative to Business Invoice Template with the score grade of 74.

... Most templates here on InvoicingTemplate.com are ".xlsx" files. ".xlsx" workbooks are Microsoft Excel Open XML Format Spreadsheet files. It's an XML-based spreadsheet file created by Microsoft Excel version 2007 and later. One limitation of ".xlsx" format is that it cannot store macros (i.e. VBA codes). To save the macro function code with the Excel invoicing template, you have to firstly convert your template into ".xlsm" format, which is called "Excel macro-enabled Workbook". See c5101 - Advanced Invoice Sample - Macro-Enabled Invoicing Template for more information on this topic.

  1. First open the invoice template as usual.
  2. Click Excel menu "File", and then "Save As".
  3. Choose the location to save new workbook file.
  4. On the "Save As" dialog box, from the "Save as type" drop down list choose "Excel macro-enabled workbook (*.xlsm)", and then type in the file name for the new workbook.
  5. Click "Save".

Standard Business Invoicing Template with Oval Buttonc5099

Standard Business Invoicing Template with Oval Button

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

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

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

Invoice and Packing List on Separate Worksheetc4080

Invoice and Packing Slip on Separate Worksheet

"Invoice and Packing Slip on Separate Worksheet" was found to be relative to Business Invoice Template with the score grade of 73.

... This template differs from our existing packing slip template in that we put the packing slip (waybill) in a separate worksheet, but within same Excel template as the invoice form. The advantages of this approach is that - you don't have open another template for the purpose of printing a packing slip (like what we implemented in c3010 and cn010), or you don't have to always print an invoice and a packing list together (like c4078). Since we place the packing list form in a separated worksheet, we can define its own "Print_Area", and print the number of copies as needed - for example, print one invoice, and then print 2 copies of packing list.

Advanced Invoicing Sample - Email Is Required Before Saving Invoicec5103

Advanced Invoicing Sample - Email Is Required Before Saving Invoice

"Advanced Invoicing Sample - Email Is Required Before Saving Invoice" was found to be relative to Business Invoice Template with the score grade of 68.

  1. First open your invoice template as usual.
  2. Press ALT+F11 on keyboard to open the macro editor (Visual Basic for Applications editor).
  3. Add a reference to "UniformInvoiceSoftwareHelper": click the menu "Tools" / "Reference"; on the "References - VBA Project" dialog box check "UniformInvoiceSoftwareHelper" and then click "OK".
  4. Create a new module by clicking the menu "Insert", and then "Module".
  5. Copy & paste the following code into the editor.
    
    Option Explicit
    Public Sub NewSaveToDBProc()
        
        If Range("oknWhoEmail").Value = "" Then
            MsgBox "Please enter email address in the 'Bill To' section.", vbExclamation + vbOKOnly, "Save Invoice"
            Exit Sub
        End If
        
        UISClickProc ("oknCmdSave")
        
         
    End Sub
    
  6. Click menu "File" and then "Save".
  7. Click menu "File" and then "Close and Return to Microsoft Excel".
  8. Click the "Design Mode" button on the "Invoice" worksheet.
  9. Right-click the "Save To DB" button, choose "Assign Macro..." from the shortcut menu.
  10. On the "Assign Macro" dialog box, click and choose "NewSaveToDBProc" (which is the procedure name we created in the previous steps).
  11. Click "OK" to assign this new macro to the button and close the "Assign Macro" dialog box.
  12. Exit design mode by clicking the "Design Mode" button again on the "Invoice" worksheet.
  13. Save the template by clicking the "Save" button on Excel quick access toolbar.

Web-hosting Invoicing Templatec2007

Web-hosting Billing Form

"Web-hosting Invoicing Template" was found to be relative to Business Invoice Template with the score grade of 61.

... The template has two columns, a description column and an amount column. The amount column is manually editable, as it is not calculated from something like Quantity and Price, or Hourly and Rate. This makes the template suitable for general service businesses. With the "Description" column you can enter the service performed, such as the hosting plan a client purchased from you.

... The template has 6 lines on the invoice body. If you enter a description, the amount cell shows the word 'Free'. If you enter the actual amount in the cell outside the print area, the entered amount appears in the print area. This feature makes it possible for you to clearly display the word 'FREE' for the products or services you offered for free.

Advanced Invoicing Sample - Macro-Enabled Invoicing Templatec5101

Advanced Invoicing Sample - Macro-Enabled Invoicing Template

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

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

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

Excel Shipping Invoice with Printable Truck Background Imagec5087

Shipping Invoice with Printable Truck Background

"Excel Shipping Invoice with Printable Truck Background Image" was found to be relative to Business Invoice Template with the score grade of 48.

... Fortunately it is still possible to print an image in the background of a worksheet. This technique could also implement watermark effect on your invoices, as shown in Simple Invoice Template with Printable Watermark.

... Secondly, we deleted all "pick up" buttons as they are not needed for now. Our new Uniform Invoice Software version implements an "On-Sheet Picker" that shows a small button when you click one of the supported fields, including all fields defined in the "Customer" database table, the "Invoice#", all the fields on the invoice detail section, "Sales Rep. Name" and "Payment" term. So it won't affect the usability if we delete the "pick up" (magnifying glass icons) buttons. Here is how you can delete an icon button from the "Invoice" worksheet.

Simple Invoice for Construction Businessc4046

Simple Billing Format for Contractor

"Simple Invoice for Construction Business" was found to be relative to Business Invoice Template with the score grade of 44.

Have you ever said "I need a simple invoice?" Simple Invoice for Construction Business / Simple Billing Format for Contractor might be your choice. No need to learn complex accounting and invoicing software system. The format is in MS Excel format that could be filled just like a paper form and could be easily sent as electronic PDF document.

... A printable invoice for use by a general contractor in the construction industry. Besides electronic format as either PDF or Excel spreadsheet (xlsx or xls) document, you can also print invoices. You need this simple invoice because you can use it anytime, anywhere. It has lines for description, quantity, rate, and amount, for both materials and labor. It automatically subtotals the items, adds sales tax and totals everything for you!

Bill Format for Lamp / Lighting Businessc6027

Invoicing Template for Lamp / Lighting Business

"Invoicing Template for Lamp / Lighting Business" was found to be relative to Business Invoice Template with the score grade of 34.

... This template is designed with a UK business in mind, so the layout meets the requirements of a UK VAT invoice. For example, below your business detail section a "VAT Registration #" label was added. The default tax name is also set to "VAT" and the default rate is set to 17.5%. You can change the taxation rules on the "Taxes" tab of the "Settings" window.

... Since this template is designed for standard A4 paper in landscaping orientation, the "Description" field is relatively long compared to many other templates here on InvoicingTemplate.com. This is recommended by one our customers that is a vendor of special purpose lamps. The business offers a wide range of products - for medical equipment, like "Lunar LED Headlight System" and "Saturn Xenon Lightsource and Fibre-optic headlight"; and there are also lamps and bulbs for scientific and laboratory equipment made by many different manufacturers.

Commercial Invoice Template with Colorful Business Namec7022

Commercial Invoice Template with Colorful Business Name

"Commercial Invoice Template with Colorful Business Name" was found to be relative to Business Invoice Template with the score grade of 32.

... As you can see from this commercial invoice template sample, with a few simple text boxes, a general commercial invoice template could be a beautiful, yet powerful and professional invoice template. With Microsoft Excel, InvoicingTemplate.com takes the "what you see is what you get" approach to a whole new level. The entire invoice creation process is handled on a single page. There is no need to navigate through countless pages of the site to add clients, set up tax schemes or get a preview of the final invoice. It all happens on one single page - how about that for a truly "what you see is what you get" approach? And, if you install Uniform Invoice Software, there are more you can do with the Excel template - management of your products and client accounts, tracking invoices and payments.

Hotel Guest Folios with Satisfied Business Travelerc5091

Hotel Bill Layout with Satisfied Business Traveler

"Hotel Bill Layout with Satisfied Business Traveler" was found to be relative to Business Invoice Template with the score grade of 30.

... The 5 columns on the detail section allows you to post any debit / credit regarding a room# or guest account. Usually when a folio is opened the starting balance is zero. All transactions which increase (debit) or decrease (credit) the balance of the account are recorded on the folio, for example, room charges, cash payment advance deposit, etc. For those business guests who are planning a meeting, conference or special event, related fees could be posted here too. While guest settles the final bill an Invoice is generated usually with a unique Invoice number by Uniform Invoice Software (UIS) for future reference. To set options for auto-generation of invoice numbers, such as prefix and starting number, click the "Settings" button on the "Invoice" ribbon tab, and then go to the "Database" tab.

Five Price Levels (Sales, Amount, Custom Column)c5009

Form with 5 Price Levels

"Form with 5 Price Levels" was found to be relative to Business Invoice Templates with the score grade of 29.

... The color column is a custom field defined both in the Product and Invoice Body database tables, which is the most noticeable difference between this customized invoice template and the original 5 Price Levels (Sales, Amount) invoice template. This means that for each product, you can set its color property, and the color values are filled automatically when you choose products from the database. Like all the other invoice templates in this serials available here on InvoicingTemplate.com, the full power of the invoice template comes only with the installation of Uniform Invoice Software, although the free version of this "Form with 5 Price Levels (Sales, Amount, Custom Column)" invoice template can also help you create professional and beautiful invoices.

Recruitment Agency Invoice Templatec3011

Recruitment Firm Billing Sample

"Recruitment Firm Billing Sample" was found to be relative to Business Invoice Templates with the score grade of 27.

... On the top-right section are the invoice date, invoice# and customer# fields. The invoice date field is filled automatically with current computer when you click the "Clear & New" button. It is also manually fillable / editable when you create an invoice. Likewise, invoice# field is manually fillable too - but usually, you can just leave it blank, and when you click "Save Invoice" to save an invoice to the back end database, Uniform Invoice Software will produce a new invoice# for you. The auto generation of invoice# is based on a prefix and a serial number stored in the database, which you can adjust by clicking the "Settings" button on the "Invoice" ribbon tab and then go to the "Database" tab.

Basic Blank Service Format (No-tax)c2012

Basic Blank Service Format (No-tax)

"Basic Blank Service Format (No-tax)" was found to be relative to Business Invoice Templates with the score grade of 26.

... For an edition that supports one tax, please see Basic Blank Service Invoice Format (One-tax). For an edition that supports two taxes, please see Basic Blank Service Invoice Format (Two-taxes). If you need less lines but more space for each item description on your blank service invoice template, see Basic Blank Service Billing Format (No-tax, Long Description), and the one tax format at Basic Blank Service Invoicing Format (One-tax, Long Description), and the two-tax layout at Basic Blank Service Bill Format (Two-taxes, Long Description).

Daycare Invoice Templatec5080

Daycare Invoice Template

"Daycare Invoice Template" was found to be relative to Business Invoice Templates with the score grade of 26.

... If you don't need the LOGO image and want to delete it, simply hit the DEL key on your keyboard after you selected it with your mouse key. Deleting the LOGO image leaves an empty area to the left of the Company Information section. You may like to move the entire Company Information section to fill in the empty area. To do this: Drag your mouse to select the entire Company Information area, including Company Name, Street Address, City, ST Zip Code, etc.; Push your mouse key on the border of the selected area; drag it to the new location.

General Estimate Templatec2034

General Estimate Format

"General Estimate Template" was found to be relative to Business Invoice Template with the score grade of 12.

... Both the "Description" and "Amount" column on this form are manually editable / fillable. The "Item#" column, which is required by Uniform Invoice Software, is moved out of the printable form. The printable form is the area defined by the "Print_Area" name. In Microsoft Excel spreadsheets, each worksheet could have a print area defined - you it is not defined, the whole used area is printed when you issue the print command; otherwise, only the area identified by "Print_Area" name is printed.

... All the templates available here on InvoicingTemplate.com have the "Print_Area" name defined. To find out what is printable on the current worksheet, pull down the name box located on the left-side of the formula bar, scroll down to the end of the list and choose "Print_Area", Excel selects the printable form on the current worksheet.

Backorder Invoice Template (Landscape)c7020

Backorder Invoice Template (Landscape)

"Backorder Billing Form (Landscape)" was found to be relative to Business Invoice Template with the score grade of 11.

... The printable area, or print area, is the area with white background on the center of the Backorder Invoice Template (Landscape) spreadsheet. By default Microsoft Excel prints the entire worksheet when you issue the print command, but if the worksheet has a print area defined, such as what we do for Backorder Invoice Template (Landscape), only the print area will print. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet again. If you need to recreate the print area definition, here are what to do: On the "Invoice" worksheet of the Backorder Invoice Template (Landscape), select the cells that you want to define as the print area; On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

Consulting Invoicing Formc4008

Consulting Invoicing Form

"Consulting Invoicing Form" was found to be relative to Business Invoice Template with the score grade of 7.

... If you running a consulting business, this simple consulting invoice could be used as a sample or starting point of your own invoices. Being a consultant your most important work includes setting consulting fee rates and making money, but providing a professional and beautiful consulting invoices could help you collect payments easily and quickly.

... The template is in Microsoft Excel spreadsheet format. Compared to a Word document, it is much easier to do calculations using Excel. It is a simple template, with only a limited feature set that cannot be compared with a fully featured accounting system or invoicing program, such as Uniform Invoice Software. However, the invoices produced by the consulting form are just as good as many professional billing software programs. Please feel free to try the Uniform Invoice Software version too, which is also provided here on InvoicingTemplate.com.

Service Invoice with Profit Calculationc5061

Service Invoicing Form with Profit Calculation

"Service Invoicing Form with Profit Calculation" was found to be relative to Business Invoice Template with the score grade of 1.

Service Invoice with Profit Calculation is a variant of Sales Invoice Template with Profit Calculation. The printing result is exactly same as the service invoice template here on InvoicingTemplate.com, but it has the ability to calculate profit based on the cost you enter.

... The printable area, or print area, is the area with white background on the center of the Service Invoice with Profit Calculation spreadsheet. By default Microsoft Excel prints the entire worksheet when you issue the print command, but if the worksheet has a print area defined, such as what we do for Service Invoice with Profit Calculation, only the print area will print. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet again. If you need to recreate the print area definition, here are what to do: On the "Invoice" worksheet of the Service Invoice with Profit Calculation, select the cells that you want to define as the print area; On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c5052
Excel Payment Voucher Template
Thursday, May 29, 2014,
12
5
A4
Portrait
Receipt
c5102
Advanced Invoicing Sample - Invoiced Total in English Words
Sunday, November 20, 2016,
12
5
A4
Portrait
Sales
c5099
Standard Business Invoicing Template with Oval Button
Monday, October 24, 2016,
12
5
A4
Portrait
Sales
c4080
Invoice and Packing List on Separate Worksheet
Sunday, July 10, 2016,
20
4
A4
Portrait
Sales
c5103
Advanced Invoicing Sample - Email Is Required Before Saving Invoice
Tuesday, November 22, 2016,
12
5
A4
Portrait
Sales
c2007
Web-hosting Invoicing Template
Wednesday, October 23, 2013,
6
2
A4
Portrait
Service
c5101
Advanced Invoicing Sample - Macro-Enabled Invoicing Template
Sunday, November 20, 2016,
12
5
A4
Portrait
Sales
c5087
Excel Shipping Invoice with Printable Truck Background Image
Friday, July 8, 2016,
16
5
A4
Portrait
Sales
c4046
Simple Invoice for Construction Business
Thursday, November 12, 2015,
12
4
A4
Portrait
Service
c6027
Bill Format for Lamp / Lighting Business
Sunday, October 16, 2016,
12
6
A4
Landscape
Sales
c7022
Commercial Invoice Template with Colorful Business Name
Saturday, October 4, 2014,
12
7
A4
Portrait
Sales
c5091
Hotel Guest Folios with Satisfied Business Traveler
Thursday, July 28, 2016,
7
5
A4
Portrait
Receipt
c5009
Five Price Levels (Sales, Amount, Custom Column)
Friday, November 15, 2013,
30
5
A4
Portrait
Sales
c3011
Recruitment Agency Invoice Template
Thursday, February 25, 2016,
12
3
A4
Portrait
Consulting
c2012
Basic Blank Service Format (No-tax)
Sunday, November 15, 2015,
12
2
A4
Portrait
Service
c5080
Daycare Invoice Template
Sunday, February 28, 2016,
12
5
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c2034
General Estimate Template
Monday, August 15, 2016,
18
2
Letter (8-1/2 in. x 11 in.)
Portrait
Other
c7020
Backorder Invoice Template (Landscape)
Tuesday, May 20, 2014,
6
7
A4
Landscape
Sales
c4008
Consulting Invoicing Form
Sunday, October 20, 2013,
16
4
A4
Portrait
Consulting
c5061
Service Invoice with Profit Calculation
Sunday, September 21, 2014,
12
5
A4
Portrait
Service

What Is Hot

Feature Galleries