Skip to main content
InvoicingTemplate.com main content

Simple Sample - Adding Discount Columnc4061

Simple Invoicing Sample - Discount Column

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

...(84) By adding the "Discount" column, we meant not only re-design the Excel spreadsheet form so that it has an additional column, by also make the newly added column work with Uniform Invoice Software -- i.e. when you click the "Save Invoice" button, the content on the "Discount" column should also be saved along with each invoicing item; if "Clear & New" command is clicked, the "Discount" column should get cleared too. This is implemented by using custom fields (user-defined fields) in Uniform Invoice Software.

...(64) This tutorial differs from others in that it focus on the steps that we followed to add the "Discount" column. The basic template that we used as the origin and starting point of this tutorial already has a "Discount" field added, which is a manually fillable custom field. After adding the "Discount" column, we'll also use Excel formula for automated calculation of discount amount.

Labor Invoicing Samplec4070

Labor Invoicing Sample

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

...(39) This printable labor invoice template covers job descriptions, hours, rates and total amounts, as well as the general fields for invoices such as invoice#, invoice date and payment term. It calculates taxes, subtotal, discount and total using Excel formulas.

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

Musician Invoice Templatec2036

Musician Billing Format

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

...(43) This invoice template designed for musician includes a stave background image. Besides the Excel spreadsheet template, a PDF billing format template for musician is also included. This sample is formatted with Australian currency but you can easily change it with Excel formatting tools.

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

...(10) The formula assigned to the "Amount" field is like this:

Excel Quotation Templatec9008

Excel Quotation Format with Special Discounting Model

"Excel Quotation Format with Special Discounting Model" was found to be relative to Excel Vba Billing Software with the score grade of 67.

...(38) This free quotation and estimation template in Microsoft Excel ".xlsx" format provides a sample of customizing the default invoice template shipped with Uniform Invoice Software. It implements a special / complex discounting model to meet practical business requirements.

...(48) The discounting calculations in this template is built specially for a real business. It may not be suitable for you, but it is a good sample on how to customize the invoice template shipped with Uniform Invoice Software. For more samples on quotations and estimations, visit Estimate Templates.

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

Web-hosting Invoicing Templatec2007

Web-hosting Billing Form

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

...(35) This free template in Excel spreadsheet format is suitable for business and companies who offer web hosting or other service, especially those small-scale businesses that are not ready for a complicated accounting or invoicing system.

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

...(130) In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Catering Invoice 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.

Contractor Billing Formatc3009

Contractor Invoicing Layout

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

...(81) Take a look at the screenshot of this invoice template, you'll easily find the differences between this template and other templates available here on InvoicingTemplate.com. There are 18 lines on the detail section, but these lines are grouped into two sections - the "Services" section and the "Expenses" section, with each section identified by a blue title bar. You can use 6 lines on each section to itemize the service and expense. The other lines are reserved for taxes and amounts.

...(74) This template has two taxes like the default template shipped with Uniform Invoice Software. However unlike the default template, where the two taxes applied to all taxable items added to the invoice detail section, Contractor Billing Format applies each tax to one section. In this implementation, "Tax 1" was applied to the "Service" section, and "Tax 2" was applied to the "Expense" section. All the tax-calculation formulas are modified according to this design requirement.

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.

...(41) This two-column engineering invoice template is suitable for project architects & engineers who offers service to customers and has the need to bill the customers. It is another sample on customizing the default sales invoice template shipped with Uniform Invoice Software.

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

Welder Invoicing Templatec7021

Welder Billing Form

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

...(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 Billing Form (Red)" was found to be relative to Excel Vba Billing Software with the score grade of 14.

...(167) One of the major problems with invoicing is that many of the tools available make it difficult for a company to customize the invoice. There may be a set range of templates available, but these don't always work for everyone. Fortunately, an invoice template in Excel spreadsheet does not have these issues because it offers excellent customization for invoice template design (quotes, too), so you have the functionality to get creative with your invoice. Why not take some inspiration from some of the beautiful designs? You can simply download our templates from here on InvoicingTemplate.com, use them as the starting points of your own design for invoices / proposals / quotes. To make some sample of customizations, we provide c4029 Designer Invoice Template / Designer Billing Form (Blue) and c4030 Designer Invoice Template / Designer Billing Form (Gray). The customized versions, c4029 and c4030, have the exactly same form layout and database fields as Designer Invoice Template (Red) - the only thing changed is the color schema.

Simple Sample - Total Quantity on Sales Reportc4103

Simple Format - Total Quantity on Sales Report

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

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

Book Store Invoice Templatec7003

Book Store Invoice Template

"Book Store Billing Form" was found to be relative to Excel Vba Billing Software with the score grade of 4.

...(18) Discounts could vary by product. Some invoices may have products at 40% discounts, others at 50%, for example.

...(23) In order to implement the feature required with this invoicing format, the template uses 3 custom fields (custom columns) on the invoice body.

Field nameField typeNote
DiscDecimal (8,6) Discount, a percentage value shown on invoice body. This custom field is also added to Product database table so that you can define default discount for each product which is loaded whenever you pick up a product.
UnitCostDecimal (15,6) The applied price for the customer.

On invoice body, the invoice template uses the following formula to calculate UnitCost:

=oknPrice_? * (1-oknDisc_?)

Where "?" is a line number, ranging from 1 to 30.

ExtRetailDecimal (15,6) ExtRetail is calculated using the following formula:

=ROUND(oknPrice_?*oknQuantity_?,2)

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
c7003
Book Store Invoice Template
Wednesday, March 15, 2017,
30
7
A4
Portrait
Sales

What Is Hot

Feature Galleries