Skip to main content
InvoicingTemplate.com main content

4-Column without Taxc4002

4-Column Invoice Template

"4-Column without Tax" was found to be relative to Invoice Template With Late Fee with the score grade of 85.

...(21) This is a variant of the invoice template with 4 columns. The template is set with no tax and shipping address.

...(87) If you have Uniform Invoice Software installed, setting tax types is as easy as clicking several buttons. For example, if you find a template here on InvoicingTemplate.com interesting but don't need tax fields, you can set it to non-tax by firstly clicking the Settings button on the Invoice worksheet, and then go to the Taxes tab of the Settings dialog box. The Taxes tab offers 3 options, non-tax, one-tax and two-tax. Tax names and rates can also be set on the "Taxes" page of the Settings window.

Cash Payment Voucher Templatec5053

Cash Voucher Template

"Cash Payment Voucher Template" was found to be relative to Invoice Template With Late Fee with the score grade of 84.

...(248) Naming a cell is easy in Excel, no matter you are using the free edition of Cash Payment Voucher Template or the Uniform Invoice Software edition of Cash Payment Voucher Template, and the process is the same no matter which Excel version you are using - Excel 2003, Excel 2007, Excel 2010 or Excel 2013. To name a cell, after opening Cash Payment Voucher Template firstly make the sheet is not protected, and then click the cell you want to name (or drag your mouse to select the range you want to name), and then enter the name into the name box on the formula bar. Note that Excel does not allow you to reuse an existing name in this way. For example, if a cell has already been named "oknTaxType" in Cash Payment Voucher Template, and you click and select an empty cell then enter the name "oknType" into the name box, Excel activates the cell with the name "oknTaxType" in Cash Payment Voucher Template, instead of naming the empty cell "oknTaxType". To name a new (empty) cell with an existing name, you have to firstly delete the exiting cell name, and then use this name to name the new cell. To delete an existing cell name, in Excel 2003 click Excel menu Insert > Name > Define to open the Define Name dialog box; in Excel 2007, 2010 and 2013, the Name Manager can be launched by going to the formulas ribbon tab, Defined Names group.

...(58) One thing to note is that InvoicingTemplate.com tested the templates, including Cash Payment Voucher Template, on Microsoft Windows (with Excel, not Word) only, and the testing on Mac was usually not performed. If you need to run Cash Payment Voucher Template on Mac, test it with Mac version of Microsoft Excel before you apply it for production purpose.

Excel Payment Voucher Templatec5052

Payment Voucher Template

"Payment Voucher Template" was found to be relative to Invoice Template With Late Fee with the score grade of 83.

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

Work Order Templatec5015

Work Order Form

"Work Order Template" was found to be relative to Invoice Template With Late Fee with the score grade of 81.

...(25) The work order template added several new fields to the original invoice template to describe related information about the work or job to be done.

...(30) The following chart details the custom fields added to the work order template, in addition to the standard fields used by the default invoice template shipped with Uniform Invoice Software.

Table nameField nameField type
Invoice Header (InvHdr)Equipmenttext (30)
Invoice Header (InvHdr)Modeltext (30)
Invoice Header (InvHdr)Serial Number text (30)
Invoice Header (InvHdr)Work Requestedtext (255)
Invoice Header (InvHdr)Hours Workeddecimal (12,2)
Invoice Header (InvHdr)Travel Timedecimal (12,2)

Service Receipt Templatec5047

Service Receipt Form

"Service Receipt Form" was found to be relative to Invoice Template With Late Fee with the score grade of 80.

...(230) 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 Service Receipt Template 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 Service Receipt Template 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 Service Receipt Template 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.

Credit Memo Templatec5044

Credit Note Template

"Credit Memo Template" was found to be relative to Invoice Template With Late Fee with the score grade of 80.

...(34)Credit Memo Template is a free sample template that helps you create credit notes and credit memos. The credit note template in Excel format and its PDF format are all available free for download.

...(100) A credit note is also called credit memo (memorandum). It is a commercial document issued by a seller to a buyer and states the amount of money that has been credited to the buyer's account. The credit note format available for free here on InvoicingTemplate.com was originally a sample on customizing the default sales invoice template shipped with Uniform Invoice Software, and it is now provided as a free template. The credit note template is offered in Microsoft Excel (.xls) format, which you can easily convert to the new (.xlsx) format by executing the "Save As" command in Microsoft Excel.

Hourly Invoice Templatec5022

Hourly Billing Form

"Hourly Invoice Template" was found to be relative to Invoice Template With Late Fee with the score grade of 72.

...(91) If you are running a service business that charge the services by hour, the hourly invoice form organizes your billable hours efficiently. The invoice template offer to you free of charge here at UniformSoft.com is suitable for small businesses who don't need a complete and complicated accounting system and still need to create professional and beautiful invoices in an easy and quick way. The invoice template is in Excel spreadsheet (.xls) format and can be used to bill time you spent on client site or project in any field of life.

...(57) While it is a service invoice template for hourly rate billing, the free hourly invoice form still keeps the 'Ship To' section from the general sales invoice template designed by us at UniformSoft.com, but now the section has a new title labeled with 'Job Location', with which you can detail the place where the services are performed.

Payment Receipt Templatec5045

Payment Receipt Form

"Payment Receipt Template" was found to be relative to Invoice Template With Late Fee with the score grade of 72.

...(24)Payment Receipt Template uncovers a hidden feature available in the default sales invoice template shipped with Uniform Invoice Software but overlooked by most users.

...(118) A receipt is a document that verifies payment was received in exchange for goods or services. A receipt should contain all details about mode of payment, item details, payer details and receiver details. It also has the details of date, day and total amount. Receipt plays important role in the verification process and in the process of audit. The default sales invoice template included in the setup program of Uniform Invoice Software already provided the details of payments, but they are put into hidden cells for the purpose of simplifying the invoice template. A detailed tutorial on how to unhide the payment details section of the invoice form can be found on office-kit.com, at Creating a Receipt Form.

Babysitting Invoice (Happy Kids on Earth Style)c5088

Babysitting Invoice (Happy Kids on Earth Style)

"Babysitting Invoice (Happy Kids on Earth Style)" was found to be relative to Invoice Template With Late Fee with the score grade of 70.

...(114) Choosing a trustworthy babysitter or nanny is serious business and no parents will take lightly! Managing kids can be a challenge. One moment they're snuggling up for stories and introducing you to their imaginary friends. The next, they're biting their siblings and painting the new puppy purple. So save time on creating invoices by using our templates. This Babysitting Receipt Format (Happy Kids on Earth Style), like all the other templates available here on InvoicingTemplate.com, fully support Uniform Invoice Software. Which means you can easily make this simple pure-Excel invoice template a powerful invoicing software system, utilizing the features such as automatic invoice numbering, management of clients, invoicing items, payments, and taxes and reporting.

Restaurant Dining Invoice Template (No Tax)c4040

Restaurant Dining Invoice Template (No Tax)

"Restaurant Dining Receipt Format (No Tax)" was found to be relative to Invoice Template With Late Fee with the score grade of 56.

...(164) If you use the Uniform Invoice Software version of Restaurant Dining Invoice Template (No Tax), there are additional taxing options on the Taxes tab of the Settings window. The first is the option for choosing the number of tax items; you have 3 choices - no tax, one tax and two taxes. Secondly, you can set the names and rates in percentage for each tax, such as VAT, GST or PST, or simply Sales Tax. Thirdly, there are a group of checkbox options on the dialog box, including: "Tax invoice total including shipping cost", which adds the shipping cost to the taxable amount when checked; "Tax 2 is applied to tax 1", which adds the amount of "tax 1" to the taxable amount if checked; and "tax rate can be zero", which allows you to set any of the tax rates to be the value of zero. If you modify the options on this dialog box, the spreadsheet will be changed accordingly if needed.

Backorder Invoice Template (Landscape)c7020

Backorder Billing Form (Landscape)

"Backorder Billing Form (Landscape)" was found to be relative to Invoice Template With Late Fee with the score grade of 55.

...(162) If you use the Uniform Invoice Software version of Backorder Invoice Template (Landscape), there are additional taxing options on the Taxes tab of the Settings window. The first is the option for choosing the number of tax items; you have 3 choices - no tax, one tax and two taxes. Secondly, you can set the names and rates in percentage for each tax, such as VAT, GST or PST, or simply Sales Tax. Thirdly, there are a group of checkbox options on the dialog box, including: "Tax invoice total including shipping cost", which adds the shipping cost to the taxable amount when checked; "Tax 2 is applied to tax 1", which adds the amount of "tax 1" to the taxable amount if checked; and "tax rate can be zero", which allows you to set any of the tax rates to be the value of zero. If you modify the options on this dialog box, the spreadsheet will be changed accordingly if needed.

Clothing Store (Manufacturer) Invoice with Size Breakdowncm003

Clothing Store (Manufacturer) Format with Size Breakdown

"Clothing Store (Manufacturer) Invoice with Size Breakdown" was found to be relative to Invoice Template With Late Fee with the score grade of 42.

...(88) Adding a custom field to the "InvBdy" database table makes it possible to save the data on the invoice spreadsheet to database when the "Save To DB" button is clicked. For example, adding the custom field "Product Type" to the "InvBdy" database table allows save the type value on the invoicing form, such as "General" or "Labor", to database when you save an invoice by clicking the "Save To DB" button. This feature is not supported in the freeware edition of Clothing Store (Manufacturer) Invoice with Size Breakdown.

United Arab Emirates Invoice Templatec5073

United Arab Emirates Billing Form

"United Arab Emirates Invoice Template" was found to be relative to Invoice Template With Late Fee with the score grade of 25.

...(108) Although it is easy to create the layout and format of United Arab Emirates Invoice Template with Microsoft Word or other Microsoft Office programs, or even with some PDF programs like Adobe Acrobat, the support for Excel formulas makes doing automated calculations easy to implement and modify. For example, United Arab Emirates Invoice Template uses Excel formulas extensively to do calculations whenever possible and necessary, such as the taxes, totals. If you use the Uniform Invoice Software version of United Arab Emirates Invoice Template, Excel formulas are also used to create the relationship between several fields, such as one field should be the sum of two other fields.

Hong Kong Service Invoice Templatec5114

Hong Kong Service Billing Form

"Hong Kong Service Invoice Template" was found to be relative to Invoice Template With Late Fee with the score grade of 20.

...(44) This template for Hong Kong service businesses is built for translation service, but you can easily adapt it for other service business too. The form includes 4 columns, including a user-defined date column for you to detail the date when the service was performed.

...(39) As you can see from the above formula, it now uses "oknDiscountedSubtotal" to calculate "oknTaxableSubtotal". This means all invoiced items are seen as taxable, no matter whether the "Taxable" option is checked or not on the "Product Edit" window.

Multiple Tax Rates on One Invoicec5016

Multiple Tax Rates on One Invoice

"Multiple Tax Types on One Invoice" was found to be relative to Invoice Template With Late Fee with the score grade of 13.

...(60) One thing to note is that, since the formulas and relationship of fields on the form are deeply customized, the options on the "Taxes" tab of the "Settings" window may not work. So if you want to further customize such templates / forms, you may need to do that manually -- i.e. without using the options on the "Taxes" tab.

...(77) The default invoice template does allow you to choose tax-type with 3 options: no-tax, one tax and two taxes, but this option is applied to all the items on the invoice form. This slightly-customized invoice template differs from the default invoice template in that it allows you, on the single invoice form, to have some products with no tax, some products with one tax (such as GST) and some products with two (such as GST and PST).

Irish Sales VAT Invoice Templatec7024

Irish Sales VAT Invoice Template

"Irish Sales VAT Billing Form" was found to be relative to Invoice Template With Late Fee with the score grade of 12.

...(100) The difference between sales and service here on InvoicingTemplate.com is simple - if a template contains the "Ship To" section on the printable section, we call it sales invoice. If it does not contain the "Ship To" section, it is categorized as service invoice. If the form has a very special design in its layout, such as Tax bill for Printing Shop, which moves the "Ship To" section (titled with "Delivery To") to the body of the spreadsheet form, we add the template to both the sales and service category. Irish Sales VAT Invoice Template adheres to this rule too.

Consulting Invoice Template (4th Sample - Taxable Column)c4019

Consulting (4th Sample - Taxable Column)

"Consulting (4th Sample - Taxable Column)" was found to be relative to Invoice Template With Late Fee with the score grade of 6.

...(87)Consulting Invoice Template (4th Sample - Taxable Column), like the default template, has two tax items on the bottom of the worksheet, which are applied to all the items, and a column of Taxable checkboxes to the left of the form body, which are corresponding to each invoicing item. You can change the tax names and rates on the bottom of the form by typing in whatever meet your requirements. These are the supported features implemented in both the freeware version and the Uniform Invoice Software version.

  1. Push CTRL key on your keyboard.
  2. Without releasing the CTRL key, click the Taxable checkbox one by one. Since the template is now in design mode, clicking on it won't trigger normal control activity - instead, Microsoft Excel will put the control into selection.
  3. Now release the keyboard CTRL key, and then click and drag one of selected Taxable box to put the entire Taxable column at its new location.

Simple Invoice Sample - Sales Rep Name on Product Reportc5084

Simple Invoicing Sample - Sales Rep Name on Product Report

"Simple Invoicing Sample - Sales Rep Name on Product Report" was found to be relative to Invoice Template With Late Fee with the score grade of 3.

...(40) By default, the main contents of the "Product" report come from "Invoice Body" database table, including fields such as Product#, Product Description, invoice#, invoice date, quantity, unit price, line total. It also includes the cost field for each invoiced item.

  1. Before doing any modifications to an existing template, as always you should first back up it. In this simple sample, we'll modify the database structure too. So you'll also have to make a backup copy of the database file. To do this, in Windows Explorer simply copy the template and database files.
  2. Open the invoice template.
  3. Click the Design Mode button on the "Invoice" ribbon tab.
  4. Choose a blank (not used) area. In this sample, we choose the range at O22:O33 and assign it a slightly different background color.
  5. Name the cells "oknItemSalesRep_1", "oknItemSalesRep_2", "oknItemSalesRep_3" ... "oknItemSalesRep_12", from top to bottom. That is, O22 is named "oknItemSalesRep_1", O23 is named "oknItemSalesRep_2" and so on.
  6. Create a formula for each of the cells. For the "oknItemSalesRep_1" cell, the formula should be "=IF(oknProductName_1="","",oknSalesRepName)", and for the "oknItemSalesRep_2" cell, the formula should be "=IF(oknProductName_2="","",oknSalesRepName)", and so on. These formulas check if the product name (the "Description" column) cells are blank, and if not, the formulas retrieve the content of the "oknSalesRepName" cell and fill it into the current cell. "oknSalesRepName" cell is an manually editable cell that supports the on-sheet picker feature supported by Uniform Invoice Software. When creating an invoice (see tutorial), if you click to select "oknSalesRepName" (at $F$19 in this sample) cell, an on-sheet button appears. Click this button to choose a sales representative name from the list.
  7. Click the "Design Mode" button on the "Invoice" ribbon tab to exit design mode. The spreadsheet is now in design mode that allows you to modify the locked contents.
  8. Click the "Invoices" button on the "Invoice" ribbon tab.
  9. Click "Custom Fields".
  10. On the "Custom Field Manager" dialog box, choose "Invoice Body" from the "Database table" list.
  11. Click "Add Field".
  12. On the "Add New Custom Field" dialog box, enter the new field name "ItemSalesRep", leave" the "Type" field as the default value "Text". In the "Size" box, fill in the max text length 50. Click OK to create the new field.
  13. Click "Close" to close the "Custom Field Manager" dialog box.
  14. Now switch to the "Product" worksheet. By default, it has the following columns: Product ID (cell name: oknRpProductID), Date (cell name: oknRpInvoiceDate), Invoice # (cell name: oknRpInvoiceID), Description (cell name: oknRpProductName), Quantity (cell name: oknRpQuantity), Price (cell name: oknRpPrice), Line Total (cell name: oknRpLineTotal), Unit Cost (cell name: oknRpCost).
  15. Click to select the "Unit Cost" cell.
  16. On Excel "Home" ribbon tab, click "Format Painter".
  17. Click the cell next to "Unit Cost" on the Product worksheet. This copies the format of the "Unit Cost" cell this the new (empty) cell ($J$10).
  18. Enter the column heading into $J$10 - in this case, "Sales Rep".
  19. Name the cell "oknRpItemSalesRep". Note in this name, "oknRp" is the name prefix that is used in each name on the "Product" report worksheet; and "ItemSalesRep" is the column / field name in the database definition.
  20. Save the template by clicking the "Save" button on Excel quick access toolbar.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c4002
4-Column without Tax
Saturday, November 2, 2013,
12
4
A4
Portrait
Service
c5053
Cash Payment Voucher Template
Friday, May 30, 2014,
12
5
A4
Portrait
Receipt
c5052
Excel Payment Voucher Template
Thursday, May 29, 2014,
12
5
A4
Portrait
Receipt
c5015
Work Order Template
Tuesday, March 21, 2017,
12
5
A4
Portrait
Other
c5047
Service Receipt Template
Wednesday, January 8, 2014,
12
5
A4
Portrait
Receipt
c5044
Credit Memo Template
Friday, January 3, 2014,
12
5
A4
Portrait
Other
c5022
Hourly Invoice Template
Tuesday, March 28, 2017,
12
5
A4
Portrait
Service
c5045
Payment Receipt Template
Saturday, January 4, 2014,
12
5
A4
Portrait
Receipt
c5088
Babysitting Invoice (Happy Kids on Earth Style)
Saturday, July 9, 2016,
12
5
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c4040
Restaurant Dining Invoice Template (No Tax)
Friday, August 28, 2015,
20
4
A4
Portrait
Receipt
c7020
Backorder Invoice Template (Landscape)
Tuesday, May 20, 2014,
6
7
A4
Landscape
Sales
cm003
Clothing Store (Manufacturer) Invoice with Size Breakdown
Monday, June 27, 2016,
12
x
A4
Portrait
Sales
c5073
United Arab Emirates Invoice Template
Wednesday, August 26, 2015,
12
5
A4
Portrait
Sales
c5114
Hong Kong Service Invoice Template
Wednesday, April 5, 2017,
8
5
A4
Portrait
Service
c5016
Multiple Tax Rates on One Invoice
Friday, March 17, 2017,
12
5
A4
Portrait
Sales
c7024
Irish Sales VAT Invoice Template
Tuesday, August 25, 2015,
18
7
A4
Portrait
Sales
c4019
Consulting Invoice Template (4th Sample - Taxable Column)
Saturday, December 7, 2013,
16
4
A4
Portrait
Consulting
c5084
Simple Invoice Sample - Sales Rep Name on Product Report
Saturday, June 25, 2016,
12
5
A4
Portrait
Sales

What Is Hot

Feature Galleries