Invoice Template - for Products


Free Delivery

Immediate Download

So much more than an Invoicing Template ...    

Our Invoicing Template for a Product based business incorporates the following features as standard.

For users of Microsoft Excel [full version] version 2003, 2007, 2010 or 2013. 

Unsuitable for Mac Users

                                The ability to design your own invoice formats including Fonts and Colour Schemes                      
  Incorporate you own Company Logo's    
  Data is maintained within databases - so no need to re-type each time.    
  Easy to use and understand, with  most information selected via simple drop down boxes    
  All Invoices can be viewed and re-printed at any time.  
  Produces both Invoices and Credit notes  
  Maintains a 'Sales Day Book' that records the financial details of all invoices raised.  
  Option to use many discount methods  
  Incorporates several time saving features such as 'Quick Lines' and 'Invoice Calculations' views  
  Suitable for both VAT and Non VAT Registered businesses.  
  Allows for VAT Rate changes.  
  Comprehensive notes on setting up and using the software.  


Features that are specific to the PRODUCT Invoice Template include:

A 500 line Stock Database which records the Description, Code, Price, VAT Rate (and amount) and the Products Discount Code - see screen shot below.

A Discount Matrix worksheet that allows you to assign discount levels to both Products and to Customers. This means that every customer could have potentially different rates for each of your stock lines. If this feature is not required, then it is easy to switch it off.

If Discounts are not in use, then the Discount column on the Invoice disappears. Similarly, if you are not VAT Registered, then references to VAT will not show.

Each Invoice can have up to 20 lines. For every line there is a corresponding 'Back Office' view, which shows how the line prices and discounts are calculated.

For ' non Stock ' items, there is the facility to record up to 20 'Narratives' together with prices. This is used for variable items such Postage, Freight, Insurances etc.



Sreen Shots of the main worksheets are shown below. 

If there are any questions you would like to ask prior to purchase, then please email


This is what the Invoice looks like - Our Standard Format - The standard Invoice design can be modified to suit your businesses requirements, this include the Fonts, Colour Scheme and many of the 'narratives'. You can incorporate your own logo's and business headers.  

Product File Worksheet - This maintains all of your Stock Lines with appropraite Prices, VAT and Discount Structures


The Discount Matrix - Facilitates both Customer and Product Discounts


The Customer File - This is a truncated view of a much larger database.


The Sales Day Book - The Financial Data for ALL of your Invoices and Credit Notes is maintaned here.



Additional information and small print 
Mr.Spreadsheet is a registered trading name and division of Heron Accounting Services, Poole, Dorset.
This software is protected by international copyright and is sold on a single-user annual licence agreement for the use by the licensee or licensees business only. Unlawful decoding, copying and distribution will result in prosecution.

We make no warranty or representation, either express or implied, with respect to this software and documentation, their quality, performance, merchantability, or fitness for purpose. This software is licensed ' as is ', and you, the licensee, by making use thereof, are assuming the entire risk as to their quality and performance. In no circumstances will we be held liable for direct, indirect, special, incidental or consequential damages arising out of the use or inability to use the software or documentation. 




Please Choose:

Excel Spreadsheet

Excel Download

Add to Basket: