Skip to main content
InvoicingTemplate.com main content

Simple Sample - Manually Fillable Line-totalsc2028

Simple Sample - Manually Fillable Line-totals

"Simple Invoicing Format - Manually Fillable Line-totals" was found to be relative to Tax Invoice Online Tips with the score grade of 86.

...(63) In this sample of simple invoice template, we look at how to move out the Quantity and Unit Price column, remove the formulas of all the "Line-total" cells to make it manually fillable. With this design, the line totals will not be calculated automatically, but be filled in manually. This is useful businesses, such as service providers, who charge customers on a project-basis.

  1. Backup the template that you want to customize. This allows you to start again if something goes wrong during the customization steps.
  2. Open the template.
  3. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.
  4. Drag your mouse on all cells on the Quantity column to select the cells, ranging I21:I33. Drag on the border of the selected area and move to the new location of this column - in this sample, we choose the new location starting from X21.
  5. Do the same movement for the Unit Price column, from original address J21:J33 to the new location starting from Y21.
  6. Drag your mouse to select all the cells for the "Description" heading, including two empty cells on the same row next to the heading, ranging D21:J21. Click the "Merge and Center" button on Excel "Home" ribbon tab twice - the first click on the button unmerges the originally merged cells (i.e. the original "Description" heading), the second click on the button merges all the selected cells - this will be our new "Description" heading.
  7. Drag your mouse to select all the cells for the "oknProductName_1", including two empty cells on the same row next to "oknProductName_1", ranging from D22:J22. Click the "Merge and Center" button twice. Like the previous step, the first click unmerges originally merged cells, and the second click merges all the selected cells.
  8. Repeat the above step for all the other "oknProductName_?" cells ("?" - from 2 to 12).
  9. Drag to select all the "oknProductName_?" cells, ranging from D22 to J33. Click "Align Left" in the "Alignment" group on Excel "Home" ribbon tab.
  10. Drag mouse to select all line total cells, ranging K22:K33. Hit DEL key on keyboard to delete all the formulas assigned to these cells.
  11. Right-click one of the selected line total cells, choose Format Cells from the shortcut menu. On the Protection tab, clear the "Locked" property. This will make sure that when the worksheet is protected (i.e. when you are creating invoices), the line total cells are manually fillable / editable.
  12. Click the "Design Mode" button on the "Invoice" ribbon tab again to exit design mode.
  13. Click the Settings button on the "Invoice" ribbon tab.
  14. On the "Template" tab, check "Allow incomplete lines on invoice body" option. Click "Apply" and then "Close" to close the Settings dialog box.
  15. Save the template by clicking "Save" command on Excel quick access toolbar.

Real Estate Agent Invoice Templatec4035

Real Estate Manager Billing Form

"Real Estate Agent Invoice Template" was found to be relative to Tax Invoice Online Tips with the score grade of 75.

...(31) This invoice template is designed for real estate agent or manager. On the "Bill To" section there is a "site" custom field that allows you detail critical information about the transaction.

...(58) The other two custom fields on the form include "Site Code" and "Project". The 4 columns on the invoice detail section include "Description", "Quantity", "Unit Price" and "Amount". Each row on the invoice body section allows about 3 lines of text. The text on the item cells are formatted as left alignment on horizontal, and middle on vertical.

Five Price Levels (Service, Amount)c4013

Form with 5 Price Levels

"Form with 5 Price Levels" was found to be relative to Tax Invoice Online Tips with the score grade of 75.

...(29) This is a variant of 5 Price Levels (Sales, Amount) invoice template. It differs from the original one in that it is service-oriented, i.e. it has no shipping fields.

...(50) After unprotect the sheet, the second step is to switch to design mode, which is done by clicking the Design Mode button on the Developer ribbon tab in Excel 2007, Excel 2010 and Excel 2013, or in Excel 2003 by clicking the Design Mode command button on the Controls toolbar.

...(51) Once you moved the cells and controls out of the printable area, and done all the other formatting jobs, such as setting colors and background patterns, setting up borders, you need to restore the invoice template to its working state - that is to exit design mode and protect the sheet.

Five Price Percentage Levels (Sales)c4014

Form with 5 Price Levels

"Five Price Percentage Levels (Sales)" was found to be relative to Tax Invoice Online Tips with the score grade of 70.

...(28) This is a variant of 5 Price Levels (Sales, Amount) invoice template. It differs from the original template in that it uses percentage values in the price fields.

...(165) This template uses the same database structure and field definition as the original version, but changes the meaning of the fields. The 5 prices field in the original database definition are decimal (15,6) which is enough for storing a percentage value. In this implementation offered by InvoicingTemplate.com, the first price custom field (Discount Price A) is used as the base price, and the other 4 prices (from Discount Price B to Discount Price E) are used to store discount percentage values. For example, in the sample database attached with this template, product "ABC-01" has 5 custom fields defined for prices, named from "Discount Price A" to "Discount Price E", and the values are 19.00, 0.11, 0.21, 0.31 and 0.41. If the discount level of a customer is 1 and he purchases the product "AB-01", the base price (19.00) will be applied; If the customer's discount level is 3, the discount will be 0.21 (i.e. 21%), the applied price will be 19 * (1-0.21) = 15.01.

Simple Template - Moving Shipping Addressc5077

Simple Template - Moving Shipping Address

"Simple Template - moving-shipping-address" was found to be relative to Tax Invoice Online Tips with the score grade of 66.

...(29) The templates that have no shipping address section are categorized as service invoice template. This simple invoice template demonstrates how to create it by moving out shipping address fields.

...(65) By using Excel invoicing forms, it is possible to leverage all the powerful tools provided by Microsoft Excel to do design of invoicing forms, including create relationship between Excel cells by using formulas - for example, in c4051 Simple Invoice Template - Discount Amount Field a new field Discount Amount was added and its relationship between Subtotal and taxes are established by using Excel formulas.

Five Price Levels (Service, Amount, Custom Column)c5028

Form with 5 Price Levels

"Five Price Levels (Service, Amount, Custom Column)" was found to be relative to Tax Invoice Online Tips with the score grade of 44.

...(27) This seventh sample in the multiple-price or multiple-discount serial has no shipping fields in the printable section, and the prices are set in amount (instead of percentage).

4-Column without Taxc4002

4-Column Invoice Template

"4-Column without Tax" was found to be relative to Tax Invoice Online Tips with the score grade of 33.

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

Psychologist Invoice Templatec6024

Psychologist Billing Format

"Psychologist Billing Format" was found to be relative to Tax Invoice Online Tips with the score grade of 32.

...(29) This free invoice template designed for psychological services features a "Bill To" section, a separate "Patient" section, and 6 columns - "Date", "Service", "Charges", "Payments", "Insurance Payments", "Current Balance".

...(66) In this invoice template layout, the "Service" and "Charges" columns are usually called "Description" and "Price" columns with usual templates here on InvoicingTemplate.com. The "Quantity" column found on the default invoice template shipped with Uniform Invoice Software are now moved out of the printable form, and was assigned a formula so that if the "Service" column is not empty, the "Quantity" column is assigned with 1.

Shipping Invoice Template (1)c5013

Freight Invoice Format (1)

"Freight Invoice Format (1)" was found to be relative to Tax Invoice Online Tips with the score grade of 29.

...(76) This sample free shipping invoice template designed by us at InvoicingTemplate.com has two editions - the first is the freeware edition, and the second is the Uniform Invoice Software edition which must be run with our Excel Invoicing Software installed. Uniform Invoice Software has the ability to turn a simple Excel invoice template a powerful invoicing system. For example, using this Shipping Invoice Template along with Uniform Invoice Software, it becomes your powerful Shipping Billing Software.

...(77) The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Shipping Invoice Template (1) without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

Notary Invoice Templatec3007

Notary Billing Template

"Notary Invoice Template" was found to be relative to Tax Invoice Online Tips with the score grade of 27.

...(42) Notary Invoice Template could also be seen as a general service invoice template and consultant invoice template. It helps you to create and print professional notary and general invoices and estimates. The billing form has 3 columns - Date, Description and Amount.

...(161) If you use the Uniform Invoice Software version of Notary Invoice Template, 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.

Sample Service Invoice Template: Using Handwriting Signaturec5039

Service Template with Signature

"Sample Service Invoice Template: Using Handwriting Signature" was found to be relative to Tax Invoice Online Tips with the score grade of 25.

...(147) Speaking of dates, we have some off-topic words to talk about. Date values are not as easy as it sounds. Dates seem to cause people problems. Ask five people to enter a date into Excel and you'll get dates entered five different ways. We have created a little and handy utility to address this, an Excel date picker, called Pop-up Excel Calendar. The Excel Date Picker pops up a calendar whenever you click to move into a date cell - i.e. a cell that contains a date value, a date format, or underneath a cell that has the word "date" in it. If you are interesting in this please find more information at Pop-up Excel Calendar, Date Picker for Excel, and at Excel Date Picker, a Pop-up Excel Calendar for Excel. If you use dates frequently our Excel Date Picker could be a nice helper for you.

Service VAT Invoice Templatec4010

Service VAT Invoice Format

"Service VAT Invoice Template" was found to be relative to Tax Invoice Online Tips with the score grade of 22.

...(36)Service VAT Invoice Template is an Excel format VAT invoice template designed mainly for United Kingdom (UK) businesses, including fields designed for VAT such as VAT Registration No., a VAT column and a VAT Rate column.

...(44) Since this VAT invoice template is designed for UK businesses, the currency symbol on this invoice template is formatted with UK currency symbol. This service tax invoice format is offered as an Excel ".xls" format, and for now it does not work with OpenOffice.

...(92) As always, InvoicingTemplate.com offers this Service VAT Invoice Template in two edition, on free edition, and another edition that works with Uniform Invoice Software installed. If you use the Uniform Invoice Software version, which is our invoicing software that turns a simple Excel-format invoice template into a complete invoicing system, note that are a number of fields added to support the requirements of this VAT invoice template. The newly added fields, as compared to those fields defined by the default sales invoice template shipped with Uniform Invoice Software, are called custom fields.

Hourly Service Invoice Template (Price Excluding Tax)c5069

Hourly Service Invoice Template (Price Excluding Tax)

"Hourly Service Invoice Template (Price Excluding Tax)" was found to be relative to Tax Invoice Online Tips with the score grade of 16.

...(17) Since the prices in this template don't include tax, it uses the following formula to calculate tax,

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

One Tax Column, Summary on Topc5003

One Tax Column, Summary on Top

"One Tax Column, Summary on Top" was found to be relative to Tax Invoice Online Tips with the score grade of 16.

...(21) This "One Tax Column, Summary on Top" invoice template is a variant of "One Tax Column, No Shipping Address" invoice template.

...(60) This is also a service invoice template, which as no big difference as compared to the original version. If you are familiar with Excel, it could be created by yourself easily by just moving the cells. We publish it here on InvoicingTemplate.com just for someone who is not familiar with Excel but still want to make their invoices look different.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c2028
Simple Sample - Manually Fillable Line-totals
Tuesday, February 2, 2016,
12
2
A4
Portrait
Sales
c4035
Real Estate Agent Invoice Template
Monday, July 20, 2015,
10
4
A4
Portrait
Service
c4013
Five Price Levels (Service, Amount)
Tuesday, November 12, 2013,
30
4
A4
Portrait
Service
c4014
Five Price Percentage Levels (Sales)
Wednesday, November 13, 2013,
30
4
A4
Portrait
Sales
c5077
Simple Template - Moving Shipping Address
Wednesday, February 3, 2016,
12
5
A4
Portrait
Service
c5028
Five Price Levels (Service, Amount, Custom Column)
Saturday, November 16, 2013,
30
5
A4
Portrait
Service
c4002
4-Column without Tax
Saturday, November 2, 2013,
12
4
A4
Portrait
Service
c6024
Psychologist Invoice Template
Saturday, February 27, 2016,
20
6
A4
Portrait
Service
c5013
Shipping Invoice Template (1)
Tuesday, January 14, 2014,
16
5
A4
Portrait
Sales
c3007
Notary Invoice Template
Thursday, October 2, 2014,
12
3
A4
Portrait
Service
c5039
Sample Service Invoice Template: Using Handwriting Signature
Friday, December 20, 2013,
12
5
A4
Portrait
Service
c4010
Service VAT Invoice Template
Monday, January 13, 2014,
12
4
A4
Portrait
Service
c5069
Hourly Service Invoice Template (Price Excluding Tax)
Wednesday, October 1, 2014,
12
5
A4
Portrait
Service
c5003
One Tax Column, Summary on Top
Thursday, November 7, 2013,
12
5
A4
Portrait
Service

What Is Hot

Feature Galleries