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.

Japanese Invoice Templatec4112

Japanese Invoice Template

"Japanese Billing Form" was found to be relative to Invoice Template With Late Fee with the score grade of 84.

...(83) As detailed on Japan Consumption Tax compliance and rates on VATLive.com, The Japanese CT (Consumption Tax) rate is currently 8%, and 7% national levy; 1% regional levy. This template has the default tax rate set to 8%. Make sure you set this correctly before issuing an invoice. With Uniform Invoice Software, you can not only set default tax rate via the "Settings" window / "Taxes" tab, but also change the tax rate on a per-invoice basis. To do this, follow the steps below.

  1. Click the "Clear & New" to clear the form and make it ready for new invoice. This fills the default rate (such as 8%) into the tax rate cell (next to the "消費税額" label).
  2. Fill in customer and products / services information as usual.
  3. Enter a new tax rate into the tax rate cell (next to the "消費税額" label).

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

...(137) 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. Cash Payment Voucher Template 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.

Excel Payment Voucher Templatec5052

Excel Payment Voucher Template

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

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

...(37) The voucher# field is a must-filled-in field. It should be filled with a unique (and usually consecutive) value. If you use Uniform Invoice Software, the voucher# could be generated automatically by clicking the "Save To DB" button.

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

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

...(59) The free receipt sample, as all the other invoice templates here on InvoicingTemplate.com, are a customized version of the sales invoice template shipped with Uniform Invoice Software. For this reason, the receipt template works well with Uniform Invoice Software. For example, you can have Uniform Invoice Software generates an invoice# (receipt#) automatically by clicking the "Save To DB" button.

...(44) You can download the freeware version of this service receipt template, the Uniform Invoice Software version or the PDF version of this template, from here on InvoicingTemplate.com. If case you are interesting in the implementation detail of this customized service receipt template, read on.

Credit Memo Templatec5044

Credit Memo Template

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

...(102) Although it is easy to create the layout and format of Credit Memo 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, Credit Memo 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 Credit Memo 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.

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.

...(108) The invoice template has an image located on the top-left corner of the form that serves as a placeholder for your own company or business logo. To do this, simply unprotect the Invoice worksheet and then switch to design mode. Then, right-click the default logo image and choose Properties. Click the '...' button on the Picture property to browse to and use your own logo image. You can also delete the logo image completely if you don't need it. To do this, while in design mode and the Invoice worksheet is not protected, click the image to select it, hit DEL key on your keyboard to delete it.

Babysitting Invoice (Happy Kids on Earth Style)c5088

Babysitting Receipt Format (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 Receipt Format (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) Invoice 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 Invoice Template

"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 Types 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 Billing Form

"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
c4112
Japanese Invoice Template
Thursday, May 11, 2017,
12
4
A4
Portrait
Sales
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
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