Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Debit Note Template. Double-click the downloaded file to extract all files.
  2. Open the template "debitnotetemplate.xlsx" or "debitnotetemplate-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Debit Note Template

Debit Note Template (c6016)

This is how the template looks like when you open the freeware template in Microsoft Excel.

Debit Note Template - freeware edition

Debit Note Template - freeware edition

The following template was designed for Uniform Invoice Software version 3.

Debit Note Template - Uniform Invoice Software V3 edition

Debit Note Template - Uniform Invoice Software V3 edition

Download Debit Note Template (c6016)

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

300 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.79 MBDownload

Detail

Debit Note Template is a general purpose Excel-formatted template for creating professional debit note and debit note invoice with easy and quick. The debit note form has 6 columns on it, including item#, description, quantity, UOM (Unit of Measure), Unit Price and Line Total.

A debit note is a note indicating an amount owed by a person or company, serves the similar function as an invoice. A debit note or debit memorandum (memo) is a commercial document issued by a buyer to a seller as a means of formally requesting a credit note. A seller might also issue a debit note instead of an invoice in order to adjust upwards the amount of an invoice already issued (as if the invoice is recorded in wrong value). A debit note is raised in number of cases as given below: a) If Material short received in quantity, 2) If excess rate charged by the party, 3) If anything which is not mentioned in purchase order is charged by party in invoice like Freight / Loading - Unloading exp. etc. As a comparison, an Invoice is prepared whenever goods are sold to customer, which contains item description / item code / quantity sold / rate per unit / Unit of Measure (UOM) / total Amount / tax etc. An Invoice is raised under the following circumstances: 1) when there is a buyer and a seller, 2) Sale transaction happens and title to the goods passes on to the buyer, 3) Complete list of such goods dealt by an enterprise, are registered with the VAT authorities.

You can think that a debit note is a document used by a purchaser to inform a vendor of the quantity and dollar amount of goods being returned, and requesting that the dollar amount be returned to the purchaser. A debit note is often used to return goods on credit. The vendor then issues a credit note to the purchaser indicating that the goods have been received, and that the purchaser will not have to pay for them.

Debit notes are generally used in business-to-business transactions. Such transactions often involve an extension of credit, meaning that a vendor would send a shipment of goods to a company before the goods have been paid for. Although real goods are changing hands, until an actual invoice is issued, real money is not. Rather, debits and credits are being logged in an accounting system to keep track of inventories shipped and payments owed.

The implementation of this debit note template in Microsoft Spreadsheet format is designed for general purpose usage. As a sample of creating custom formats and layouts, InvoicingTemplate.com also is also providing you with another debit note template for attorney.

This debit note template contains regular fields that are seen in the default sales invoice template shipped with Uniform Invoice Software. In addition to that, it also contains two custom fields - Agent and Ref#, as well as a custom column UOM (Unit of Measure). Agent and Ref# are custom fields that are added to Invoice Header database table, and the UOM field is a custom field that is added to both the Product and Invoice Body database table.

Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. Debit Note Template uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

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 Debit Note Template 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.

Adding a custom field to the "InvHdr" table in the database makes it possible to save the field value to database along with the other data of an invoice record. For example, adding the custom field Company Name to the "InvHdr" database table allows you to save the company name of a customer to the database when you save an invoice. If you use Uniform Invoice Software version template Debit Note Template and add the custom field, the value is saved from or retrieved to Debit Note Template whenever you save or reload an invoice record.

Adding a custom field to the Product table in the database makes it possible to save the field value to database along with the other data of a product. For example, adding the custom field "Product Type" to the Product database table allows you to save the type, such as "General" or "Labor", to the database when you save a product or item. If you use Uniform Invoice Software version template Debit Note Template and add the custom field to the spreadsheet, the value is retrieved whenever you pick up a product on creating an invoice.

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 Debit Note Template.

Like other form designs here on InvoicingTemplate.com, Debit Note Form is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

Template#c6016
NameDebit Note Template
CategoryOther Invoice Template
Release DateThursday, September 18, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns6
Lines12
Line Height (Points)19.50
Print Area$F$1:$O$43
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates