Skip to main content
InvoicingTemplate.com main content

Simple Sample - Adding Discount Columnc4061

Simple Invoicing Sample - Discount Column

"Simple Sample - Adding Discount Column" was found to be relative to Excel Vba Billing Software with the score grade of 97.

...(107) We've already released several templates here on InvoicingTemplate.com that are focused on discounting. For example, this tutorial is based on the result template built in Simple Invoice Template - Discount Amount Field that demonstrates how to add a discount amount field to the bottom of the billing form. And, there are also bill / receipt designs that offer discount column, such as Sales Invoice Template with Discount Amount Column and Sales Invoice Template with Discount Percentage Column. There are also samples on uniformsoft.com, at Template with Discount Amount Column, and on office-kit.com, at Invoice Template with Discount Column. All these templates works with Uniform Invoice Software well.

Labor Invoicing Samplec4070

Labor Billing Format for Excel

"Labor Invoicing Sample" was found to be relative to Excel Vba Billing Software with the score grade of 85.

...(54) This labor billing format for Excel is in Microsoft Excel spreadsheet "xlsx" format. A PDF format is also generated using Excel, including the document for this template. If you have Uniform Invoice Software installed, the invoicing software app is able to create PDF invoice automatically and send to your clients with simple mouse clicks.

...(32) Just like most Excel sample invoicing template here on InvoicingTemplate.com, Labor Invoice Template has a logo placeholder image on the top of the form, which you can replace with your own image.

Musician Invoice Templatec2036

Musician Invoice Template

"Musician Billing Format" was found to be relative to Excel Vba Billing Software with the score grade of 83.

...(28) As a service invoice template, this design sample does not include the "Shipping Address" section. It is a basic template that includes only two columns, "description" and "amount".

...(25) Unlike the other two-column templates here on InvoicingTemplate.com, the "amount" field is calculated with Excel formulas, so it is not manually editable on creating invoices.

...(101) The "Advertisement" section is an auxiliary section, which is not directly related to your bills or invoices, but allows you to put a brief description about your business and service, or you can also put your payment term, service term here. Note that this is a static text section - you can modify it once the template is switched to design mode, but when you are creating invoices, this section is protected and thus couldn't be modified. This also means that the section is not defined as a field in the database, and thus cannot be changed from invoice to invoice.

Excel Quotation Templatec9008

Excel Quotation Format with Special Discounting Model

"Excel Quotation Template" was found to be relative to Excel Vba Billing Software with the score grade of 67.

...(31) This template is created for businesses who sell goods. For a job estimating and quoting template, visit Job Estimate Template for Excel. For a general estimate template, see General Estimate Template.

...(19) The value of the "Quantity" is calculated using an Excel formula like this, where "_?" is the line number:

...(122) On the bottom of the form, you'll find the usual "Subtotal", "Discount" and "Total" fields. There is also the "Last Balance" field and the "Total Due" cell. The "Last Balance" cell has its field name set to "oknAccountBalance", which is filled whenever you fill in the quotation form / estimation form with an existing client by using the on-sheet picker button, you by enter the client# into the "Customer#" cell (also located outside of the printable quotation form, at $U$2). See Invoice with Previous Balance (Sales) and Invoice with Previous Balance (Service) for more information on how to show previous balance on the form. The "Total Due" is the sum of the previous account balance and the total of the current quotation.

Web-hosting Invoicing Templatec2007

Web-hosting Invoicing Template

"Web-hosting Billing Form" was found to be relative to Excel Vba Billing Software with the score grade of 58.

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

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

Catering Invoice Templatec4045

Catering Billing Format

"Catering Invoice Template" was found to be relative to Excel Vba Billing Software with the score grade of 43.

...(141) Catering is the business of providing food service at a remote site or a site such as a hotel, public house (pub), or other location. Catering has evolved to become an artisanal affair. In fact, many other templates here on InvoicingTemplate.com could be used for catering invoicing. For example, Cleaning Service Invoice Template, Free Restaurant Dining Invoice Template (VAT), and Free Restaurant Dining Invoice Template (No Tax). By default, this template has one default logo image put on the top of the form. To replace this default logo image, simply install Uniform Invoice Software. Click the "Replace Logo Image" button on the "Invoice" ribbon to replace the default logo image. With Uniform Invoice Software installed, you can also easily customize the taxing options of the form. Click the Settings command on the Excel ribbon, and then go to the Taxes tab.

Contractor Billing Formatc3009

Contractor Invoicing Layout

"Contractor Invoicing Layout" was found to be relative to Excel Vba Billing Software with the score grade of 28.

...(123) To make this template work with Uniform Invoice Software, Contractor Billing Format adopts tricks. First, the most left column on the visible (and printable) area was a custom field "ItemLine", which was continuously named from "oknItemLine_1" to "oknItemLine_18", to tell Uniform Invoice Software that there are 18 lines on the invoice detail section. The other columns, such as "DATE", "DETAILS" and "AMOUNT", has an interruption in their name serials. For example, "oknItemDate_1" to "oknItemDate_6" are put onto same column, "oknItemDate_7" to "oknItemDate_12" are put onto another column outside the printable area, and "oknItemDate_13" to "oknItemDate_18" are put onto the same column as "oknItemDate_1" to "oknItemDate_6". This is necessary because the space for "oknItemDate_7" to "oknItemDate_12" is used by the tax and amount cells.

Engineering Invoice Templatec2006

Engineering Billing Template

"Engineering Billing Template" was found to be relative to Excel Vba Billing Software with the score grade of 25.

...(30) On the top-left corner of the engineering invoice form, there is a logo image. The default logo image is a placeholder image which you should replace it with your own.

...(69) In order to implement the support for change order with this Engineering Invoice Template, InvoicingTemplate.com modified the Excel formula of the Total cell, so that it searches for the keyword "Change Order" on the description column, and if that keyword is present, the total will be the amount appears on the change order line; if the "Change Order" keyword isn't present, the total is calculated from the line totals.

Welder Invoicing Templatec7021

Welder Invoicing Template

"Welder Billing Form" was found to be relative to Excel Vba Billing Software with the score grade of 21.

...(78) This invoice template for welding and fabrication, just like the other templates in this serial, is also set with one Tax, which is named "Maine" and rated at 5.500%. If you are using the freeware edition of this Welder Invoicing Template / Welder Billing Form, change this to your own tax name and rate by typing in proper values. If you use the Uniform Invoice Software version, there are better ways to configure your tax rules and system.

...(114) Merge and Center works by merging the selected cells into one and then centering the data in the new combined cell. While design a template layout like Welder Invoicing Template, Merge and Center could be a handy tool if used properly. One thing to note, however, since Uniform Invoice Software (UIS) relies on cell names (or field names) to create the relationship between the Excel form cells and the database fields, you should make sure the cell that contains a field name is the first one in the group of cells that are to be merged. This way, UIS will work with the merged cell by reading from or writing to the named cell.

Designer Invoice Template (Red)c4028

Designer Billing Form (Red)

"Designer Invoice Template (Red)" was found to be relative to Excel Vba Billing Software with the score grade of 14.

...(185) Compared to the default invoice template shipped with Uniform Invoice Software installer program, or compared to the basic consulting invoice template that Designer Invoice Template (Red) is based on, this design proposal and invoice template, which is named Designer Invoice Template (Red), has seen a major visual redesign. However it still targets to being printable on standard A4 paper, just like the default invoice template shipped with Uniform Invoice Software. And like all the other proposal and invoicing templates here on InvoicingTemplate.com, besides the freeware edition, there is also an Uniform Invoice Software edition, which means you can not only create proposals and invoices easily with the intuitive what-you-see-is-what-you-get billing form, it could also be a complete invoicing program / system with the ability to manage and track your clients, items, invoices and payments. Be sure to download our invoicing program for free and have a test, which is fully functional within the trial period. Whether you use this template as a web design invoice template or graphic design invoice template, Uniform Invoice Software could make a simple template become a fully featured billing system.

Simple Sample - Total Quantity on Sales Reportc4103

Simple Format - Total Quantity on Sales Report

"Simple Format - Total Quantity on Sales Report" was found to be relative to Excel Vba Billing Software with the score grade of 11.

...(47) In this sample template, we take c4062 Simple Tax Invoice Sample with Tax Rate List as the base template (i.e. the starting point of our customization). See how to create your invoice template for more information on the general rules to adhere and the basic technique details.

...(29) In this sample form design, we add a custom field to calculate / store the total quantity on an invoice, and then add this information to the sales report.

  1. First, make sure you have created a backup copy of the template.
  2. Open the template / spreadsheet file.
  3. Click "Invoices" on the "Invoice" ribbon tab.
  4. Click "Custom Fields" on the toolbar to open the "Custom Field Manager" dialog box.
  5. Make sure "Database Table" is showing "Invoice Header".
  6. Click "Add Field" to open the "Add New Custom Field" dialog box.
  7. Enter: Field Name - TotalQuantity; Type - Decimal; Precision - 10; Scale - 2.
  8. Click "OK" to create the new "TotalQuantity" field.
  9. Close all dialog boxes and return to Excel form.
  10. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon. This allows you to modify the invoice design.
  11. Click the cell where you want to place the quantity total. In this sample, we choose $I$34 - i.e. the cell below the "Quantity" column.
  12. Enter the formula to calculate the sum of all quantities:
    =sum(oknQuantity_1:oknQuantity_12)
  13. On the formula bar, click to activate the name box located at the left-end, enter the cell name "oknTotalQuantity". Note this name must be the combination of the prefix "okn" and the database field name "TotalQuantity". This name creates the map between the Excel cell and the backend Access database field to store the value when you save an invoice.

Construction Proposal Templatec1001

Construction Estimate Form

"Construction Proposal Template" was found to be relative to Excel Vba Billing Software with the score grade of 4.

...(46) The construction proposal template offers an intuitive blank form for you to fill in the details of your contract or proposal. It can be used by a subcontractor or a supplier. The form does not calculate totals, giving you the ability of filling in figures manually.

...(93) The sample building proposal template was original released as an example of customizing the default sales invoice template shipping with Uniform Invoice Software. It looks very different from the original template, yet Uniform Invoice Software can handle this form without problem. The construction proposal template is in Microsoft Excel format. It can be used as a construction bid proposal template. Microsoft word construction proposal template, on the other hand, while as easy as the Excel format on formatting a contract or proposal, lacks the ability to further processes numbers and figures as Excel.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c4061
Simple Sample - Adding Discount Column
Sunday, February 7, 2016,
12
4
A4
Portrait
Sales
c4070
Labor Invoicing Sample
Wednesday, May 11, 2016,
8
4
A4
Portrait
Service
c2036
Musician Invoice Template
Sunday, October 9, 2016,
6
2
A4
Portrait
Service
c9008
Excel Quotation Template
Friday, February 10, 2017,
37
9
A4
Portrait
Other
c2007
Web-hosting Invoicing Template
Wednesday, October 23, 2013,
6
2
A4
Portrait
Service
c4045
Catering Invoice Template
Tuesday, November 10, 2015,
12
4
A4
Portrait
Receipt
c3009
Contractor Billing Format
Saturday, October 17, 2015,
18
3
A4
Portrait
Service
c2006
Engineering Invoice Template
Monday, September 15, 2014,
9
2
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c7021
Welder Invoicing Template
Friday, September 26, 2014,
20
7
Letter (8-1/2 in. x 11 in.)
Portrait
Sales
c4028
Designer Invoice Template (Red)
Wednesday, October 8, 2014,
6
4
A4
Portrait
Consulting
c4103
Simple Sample - Total Quantity on Sales Report
Wednesday, November 23, 2016,
12
4
A4
Portrait
Sales
c1001
Construction Proposal Template
Friday, December 13, 2013,
16
1
A4
Portrait
Other

What Is Hot

Feature Galleries