Skip to main content
InvoicingTemplate.com main content

Form with Product Categoryc5008

Template with Product Category

"Form with Product Category" was found to be relative to Invoice Ledger Software with the score grade of 96.

...(79) However the support for custom fields in Uniform Invoice Software makes overcoming this limitation easy and quick. What you need to do is to add the custom field "Product Category" to the invoice body database table, and then name a column of cells where you want to display the category when creating an invoice - in this sample, we don't want to show product category on printed invoices, so the product category column is defined outside the printable area.

Engineering Service Billing Samplec3006

Engineering Service Billing Sample

"Engineering Service Billing Form" was found to be relative to Invoice Ledger Software with the score grade of 95.

...(233) 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 Engineering Service Invoice 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 Engineering Service Invoice 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 Engineering Service Invoice 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.

Advanced Invoicing Sample - Email Is Required Before Saving Invoicec5103

Advanced Invoicing Sample - Email Is Required Before Saving Invoice

"Advanced Invoicing Format - Email Is Required Before Saving Invoice" was found to be relative to Invoice Ledger Software with the score grade of 89.

...(42) Now when you click the "Save To DB" button to save an invoice, your own macro code will check if the email address field is empty. If so, it will refuses to save the invoice; otherwise, the invoice will be saved normally.

Basic Blank Service Invoice Format (One-tax)c2013

Basic Blank Service Invoice Layout (One-tax)

"Basic Blank Service Invoice Layout (One-tax)" was found to be relative to Invoice Ledger Software with the score grade of 85.

...(46) This configuration procedure isn't so basic and simple for someone who are not so familiar with Excel and Uniform Invoice Software templates. To get the job even easier, we build this template "c2013 Basic Blank Service Invoice Format (One-tax)" or Basic Blank Service Invoice Layout (One-tax).

Invoice Template with 4 Columnsc4001

4-Column Invoice Template

"4-Column Invoice Template" was found to be relative to Invoice Ledger Software with the score grade of 81.

...(45) The template has one tax set on the bottom of the invoice form. If you have Uniform Invoice Software installed, you can easily change it to two-tax or non-tax by clicking the Settings button on the Invoice worksheet, and then go to the Taxes tab.

Payment Receipt Templatec5045

Payment Receipt Form

"Payment Receipt Form" was found to be relative to Invoice Ledger Software with the score grade of 73.

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

Online Invoicing Samplec5121

Sample Invoice Template for Online Invoicing

"Sample Invoice Template for Online Invoicing" was found to be relative to Invoice Ledger Software with the score grade of 68.

...(25) This free Excel invoice template demonstrates how Uniform Invoice Software works with online Microsoft SQL Server database connections (instead of the default Microsoft Access database).

...(22) This SQL Server is located at Arizona, so it may not be as speedy as you want depending on where you are.

Sales Invoice Template with Discount Amount Columnc6010

Sales Template with Discount Amount Column

"Sales Template with Discount Amount Column" was found to be relative to Invoice Ledger Software with the score grade of 66.

...(29)Sales Invoice Template with Discount Amount Column is a sample invoice template that adds a discount amount column to the default sales invoice template shipped with Uniform Invoice Software.

...(258) To adjust the existing columns to leave space for new column or columns that will be added to the printable form for Sales Invoice Template with Discount Amount Column, we first unmerge the item# (or product#), description and quantity columns - these are usually merged columns that each contains several Excel raw columns. To do this, after opening Sales Invoice Template with Discount Amount Column as usual, select all the cells belong to these columns and then click the "Merge and Center" button on the Format toolbar in Excel 2003; in Excel 2003, the "Merge and Center" button can be found on the Home ribbon tab. Drag your mouse to select the Description column (this time, you select Excel raw column since the Description is no longer a merged column) and drag it one column left. Select the "oknProductName_1" cell (the first cell on the moved Description column) and drag your mouse to select the two adjacent cells at the right-hand too - so, you now select 3 cells started with the "oknProductName_1" cell. Now click the Merge and Center command again. This will expand the width of "oknProductName_1" to 3 columns. Do this process for all the other Description cells. Once done, you have one empty column that was left by moving the Description column to the left-hand of this original position. Adjust the columns widths of all the columns to make sure they have the proper widths that are able to hold the content they will display on this Sales Invoice Template with Discount Amount Column.

Hourly Service Bill Sample (Price Including Tax)c5068

Hourly Service Bill Sample (Price Including Tax)

"Hourly Service Bill Sample (Price Including Tax)" was found to be relative to Invoice Ledger Software with the score grade of 66.

...(165) If you use the Uniform Invoice Software version of Hourly Service Invoice Template (Price Including 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.

Simple Sales Invoice Template without Item Descriptionc8002

Simple Sales Invoice Format without Item Description

"Simple Sales Invoice Format without Item Description" was found to be relative to Invoice Ledger Software with the score grade of 65.

...(242) 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 Simple Sales Invoice Template without Item Description 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 Simple Sales Invoice Template without Item Description 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 Simple Sales Invoice Template without Item Description 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.

Hourly Service Invoice Template (UK Currency)c4026

Hourly Service Invoice Template (UK Currency)

"Hourly Service Invoice Template (UK Currency)" was found to be relative to Invoice Ledger Software with the score grade of 60.

...(36) This is a simple variant and customization sample on our basic hourly service invoice template. It differs from the original one in that the currency symbol on this template is changed to UK (United Kingdom) style.

Simple Sample - Customer Name on Product Reportc4059

Simple Invoicing Sample - Customer Name on Product Report

"Simple Sample - Customer Name on Product Report" was found to be relative to Invoice Ledger Software with the score grade of 48.

...(39) The default product report contains fields defined in the "Invoice Body" database table. This simple invoice template sample demonstrates how to add fields in the "Customer" or "Invoice Header" database tables to the "Product" report by using custom fields.

Clothing Shop Receiptc6001

Clothing Store Invoice Template

"Clothing Store Invoice Template" was found to be relative to Invoice Ledger Software with the score grade of 47.

...(34) Clothing Shop Receipt helps a clothing shop or store easily create professional receipt or invoice with a blank receipt template or blank invoice template. The "Size" column is usually required on such a form.

Cash Payment Voucher Templatec5053

Cash Voucher Template

"Cash Voucher Template" was found to be relative to Invoice Ledger Software with the score grade of 42.

...(70) Note that custom fields is a powerful feature introduced by previous version of Uniform Invoice Software (UIS), i.e. Excel Invoice Manager. The support for custom fields in Excel Invoice Manager requires a database definition file ("FDINFO10.rst") to be present in the folder where the database file was installed. With UIS, using custom fields is much simpler than in Excel Invoice Manager, and the database definition file is no longer required.

Hourly Service Billing Samplec4025

Hourly Service Billing Statement

"Hourly Service Billing Sample" was found to be relative to Invoice Ledger Software with the score grade of 32.

...(34) The default invoicing form calculates line totals from Quantity and Unit Price. This sample service bill template simply change the headings to Hours and Rate so that it becomes an hourly service bill template.

Simple Sample - Printing on Letterhead Paperc4058

Simple Sample - Printing on Letterhead Paper

"Simple Invoicing Template - Printing on Letterhead Paper" was found to be relative to Invoice Ledger Software with the score grade of 26.

  1. Before doing any customization, backup the template. In this case, we'll not touch the database fields / database definitions. So backing up the database file is not required.
  2. Open the template as usual.
  3. If you have Uniform Invoice Software (our Microsoft Excel-based e-billing software program / app / organizer) installed, click the "Design Mode" button.

    Otherwise, unprotect the sheet and then show gridlines and row/column headings; push down the "Design" button on Excel "Developer" ribbon tab.

  4. Move the content that will provided by the letterhead out of the printable form. In this case, we'll move the default logo image (the placeholder), company name (cell name: oknCompanyName), compay address (cell name: oknCompanyAddress), company city state zip code (cell name: oknCompanyCityStateZip), and company contact (cell name: oknCompanyContact) out of the printable section.

    To move the default logo image, click on it to select it, and then drag it to move it. Or in case you want to delete the logo image completely, hit DEL on your keyboard.

    To move the company information labels (ranging from F2 to H14 in this sample), drag your mouse to select these cells. And push your mouse key on the border of the selected area, without releasing the mouse key drag it to the new location you want to place the fields - in this case, we put it at the new location starting from $W$3.

  5. Move the big label "INVOICE", and two required fields, invoice date and invoice #, including theire labels, to proper place to leave space on the top of the form.

    In this case, we move the label "INVOICE" to row 3 and the two required fields to row 4. We also merged all the cells on row 3 by clicking the "Merge and Center" command on Excel "Home" ribbon tab to make it centered.

  6. Now adjust the height of the first line on the top of the printable form to make it equals to the height of the letterhead on your papers. One helper here is the ruler that shows when you switch to "Page Layout" view. To do this, switch to Excel "View" ribbon tab, push down the "Page Layout" button on the "Workbook Views" group. The page layout view shows a ruler that helps you to determine the height of each row. Once done, switch to normal view by pushing down the "Normal" button on the "Workbook Views" group.

    Another way to leave space on top of the form is to set margins. To do this, you first hide the empty row on the top (in this sample, row 2) by right-clicking the row header and then choose "Hide" from the shortcut menu. And then go to Excel "Page Layout" ribbon tab, choose "Margins" in the "Page Setup" group and then choose "Custom Margins..." to set the margins based on the size of the letterhead that you want to use.

  7. Once done, click the "Design Mode" button on the "Invoice" ribbon tab to exit design mode.
  8. Save the template by clicking the "Save" button on Excel quick access toolbar.

Simple Service Invoice Template without Item Descriptionc8001

Simple Service Invoice Format without Item Description

"Simple Service Invoice Template without Item Description" was found to be relative to Invoice Ledger Software with the score grade of 15.

...(71) Another unique feature of this simple invoice template, as compared to the other invoice templates here on InvoicingTemplate.com, is that there are two groups of "Product #, QTY, PRICE, LINE TOTAL" columns placed side by side on the invoice body. So, there are 15 lines on the invoice body, but in fact you can put up to 30 items on the single page of the invoices created by this invoice template.

Attorney Invoice Template (South Africa Currency)c5067

Attorney Invoice Template (South Africa Currency)

"Attorney Billing Statement (South Africa Currency)" was found to be relative to Invoice Ledger Software with the score grade of 12.

...(87) 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 Attorney Invoice Template (South Africa Currency).

Sample Sales Invoice Template 2c2001

Sample Sales Invoice Form 2

"Sample Sales Invoice Form 2" was found to be relative to Invoice Ledger Software with the score grade of 9.

...(70) This invoicing form is originally published in the member area on office-kit.com with the id number "c2-001". InvoicingTemplate.com tested it and found it to be fully compatible with the latest version of Uniform Invoice Software, and now it is available here on InvoicingTemplate.com in two editions - one free edition, and another edition that works with Uniform Invoice Software. A PDF version of the billing form is also available here.

...(23) Unlocking the line total fields is necessary in order to make the fields editable when the Invoice worksheet of the spreadsheet is protected.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c5008
Form with Product Category
Sunday, November 10, 2013,
12
5
A4
Portrait
Sales
c3006
Engineering Service Billing Sample
Friday, February 28, 2014,
12
3
A4
Portrait
Service
c5103
Advanced Invoicing Sample - Email Is Required Before Saving Invoice
Tuesday, November 22, 2016,
12
5
A4
Portrait
Sales
c2013
Basic Blank Service Invoice Format (One-tax)
Monday, November 16, 2015,
12
2
A4
Portrait
Service
c4001
Invoice Template with 4 Columns
Friday, November 1, 2013,
12
4
A4
Portrait
Sales
c5045
Payment Receipt Template
Saturday, January 4, 2014,
12
5
A4
Portrait
Receipt
c5121
Online Invoicing Sample
Wednesday, August 2, 2017,
12
5
A4
Portrait
Sales
c6010
Sales Invoice Template with Discount Amount Column
Monday, December 23, 2013,
20
6
A4
Portrait
Sales
c5068
Hourly Service Bill Sample (Price Including Tax)
Tuesday, September 30, 2014,
12
5
A4
Portrait
Service
c8002
Simple Sales Invoice Template without Item Description
Friday, January 10, 2014,
30
8
A4
Portrait
Sales
c4026
Hourly Service Invoice Template (UK Currency)
Monday, September 29, 2014,
12
4
A4
Portrait
Service
c4059
Simple Sample - Customer Name on Product Report
Friday, February 5, 2016,
12
4
A4
Portrait
Sales
c6001
Clothing Shop Receipt
Thursday, December 12, 2013,
12
6
A4
Portrait
Receipt
c5053
Cash Payment Voucher Template
Friday, May 30, 2014,
12
5
A4
Portrait
Receipt
c4025
Hourly Service Billing Sample
Sunday, September 28, 2014,
12
4
A4
Portrait
Service
c4058
Simple Sample - Printing on Letterhead Paper
Thursday, February 4, 2016,
12
4
A4
Portrait
Sales
c8001
Simple Service Invoice Template without Item Description
Thursday, January 9, 2014,
30
8
A4
Portrait
Service
c5067
Attorney Invoice Template (South Africa Currency)
Saturday, September 27, 2014,
12
5
A4
Portrait
Consulting
c2001
Sample Sales Invoice Template 2
Tuesday, December 17, 2013,
12
2
A4
Portrait
Sales

What Is Hot

Feature Galleries