You are safe to download the resources. We've added our digital signatures to the files.
Without database file. How to download and use
Download this if you have already installed UIS, but are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
A default value is the value assigned to a field or cell. The value of the cell must be changeable / editable, but if it is not changed or edited, the default value appears on invoice and save to database.
If you click "Clear & New", the current invoice on the form is cleared and a default value is assigned to each field. These default values fall into 3 categories.
The first category includes the special fields, including "invoice date" and "invoice#". The "invoice date" is filled with the current date. "Invoice#" is blank; but if you click "Save To DB" and leave the "invoice#" blank, a new sequentially increasing invoice number is generated automatically based on the previous numbers.
The second category includes "Payment Term", "Shipping Method" (or "Shipping via"), "Customer Category", "Product Category" and "Sales Rep. Name". The default values of these fields can be changed manually by following the steps below.
The third category includes all the other fields on the sheet. These fields are filled with a default value of an empty text string, or numeric value zero. By assign an empty text string or zero values to these fields, the "Clear & New" button makes the form clean, so that it is ready for you to create next invoice. What if we want to assign a non-empty text to the one of the fields?
The following tutorial takes c2005 print shop invoice template as a sample, and add non-empty default value to the first "Description".
=IF(oknDescriptionManual="","Print documents, A4 paper",oknDescriptionManual)
This formula means that, if "oknDescriptionManual" is empty, then show the default value "Print documents, A4 paper"; otherwise show the text from the "oknDescriptionManual" cell.
Feel free to visit our editable invoice templates gallery.
Note: Be sure to replace the "Your Business ID# or TIN#" on top of the sheet with your TIN# - this could be your social Security Number, Employer Identification Number, Individual Taxpayer Identification Number, ATIN or PTIN. See Taxpayer Identification Numbers (TIN) for more information. Visit our tax invoice templates for more samples.
Like other form designs here on InvoicingTemplate.com, Simple Sample - Editable Default Value 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.
|Name||Simple Sample - Default Value|
|Category||Service Invoice Template|
|Release Date||Saturday, January 6, 2018|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||15.75|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|