The printed version.
Sales Invoice with Profit Calculation (c5060)
This is how the template looks like when you open the freeware template in Microsoft Excel.
Sales Invoice with Profit Calculation - freeware edition
The following template was designed for Uniform Invoice Software version 3.
Sales Invoice with Profit Calculation - Uniform Invoice Software V3 edition
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.
This sales invoice template produces exactly the same printed invoices as the default sales invoice template that is included in the Uniform Invoice Software installer program. The main difference is that this template support the calculation of profit.
When running a business you may prefer to know the cost and profit, whether you are selling goods or providing services. The default sales invoice template included in the Uniform Invoice Software installer program does not support this by default (at least at the time when we are preparing this invoice template), which brings many inconvenience for example such as when you are doing marketing plans. This is true even when you are providing service, such as plumbing. The good news is that, adding the support for profit calculation is easy.
You can download the finished billing template, Sales Invoice with Profit Calculation, from the download page, or download the PDF version by clicking the corresponding link at the right-hand of this page. The service version of this template, Service Invoice with Profit Calculation, which does not include the shipping address section, is also provided. We've also created a variant for each of these templates, Sales Invoice with Profit and Taxable Column, which is a sales invoice template includes the profit calculation, and also adds the "Taxable" column to the printable invoice form; and Service Invoice with Profit and Taxable Column, which is the service edition that includes both profit calculation (outside the printable invoicing form), and the taxable column (inside the printable area). All these designs and forms are providing you for free by InvoicingTemplate.com.
If you are interested in the implementation details regarding this invoicing template, read on. You may find that it could be a good sample on adding profit and taxable column to your own invoice template. The following description assumes the circumstances that we are creating this template based on the default sales invoice template. You job may differ, but as said before, you can see this as a sample on adding the profit calculation feature.
The magic of adding profit calculation depends on a powerful feature supported by all editions of Uniform Invoice Software - Uniform Invoice Software Standard, Uniform Invoice Software Net and Uniform Invoice Software Enterprise, which is called custom fields.
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. Sales Invoice with Profit Calculation 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 Sales Invoice with Profit Calculation 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.
In order to calculate the profit, you'll need the cost figure which is either set the Product Edit form, or entered manually according to the agreement or contracts on the invoicing form when you are creating an invoice. The cost is the amount you pay the vendor for each item you purchased, equal to the "price" listed on the orders you send to your vendors. On the other hand, the price is the amount your clients or customers pay you. On the invoices that you'll send to your customers, whether they are printed hard-copy, or as electronic bill in PDF / Excel / HTML format, the cost figures will not be shown to your customers, since this column is placed outside the printable area. It is designed for your own accounting or book keeping purpose only.
Like the sales invoice template shipped with Uniform Invoice Software, this Sales Invoice with Profit Calculation contains 5 columns on the invoice body, that are Item#, Description, Price, Quantity and Line Total. If you use Uniform Invoice Software, the inventory of an item will be subtracted automatically when an invoice is saved - and in the meantime, an invoice# is generated automatically according to the rules you set on the Settings window. The auto-generated invoice# is titled with the label "INVOICE#" on the header of the invoice form, near the name and details of your business or company, but you can changed it to anything like "receipt#" (for creating receipts). You don't have to be a technician in order to make such modifications - simply unprotect the sheet, and then enter the label you like to replace the default text labels. However, if you are planning to create estimates or quotes, note that our invoicing software will subtract the inventory once the document is saved. There are ideas that let you easily overcome this, which will be detailed in other documents here on InvoicingTemplate.com.
Like other form designs here on InvoicingTemplate.com, Sales Invoicing Template with Profit Calculation 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||Sales Invoice with Profit Calculation|
|Category||Sales Invoice Template|
|Release Date||Saturday, September 20, 2014|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||19.50|
|Printable with Papaer Size / Orientation||A4 (210 mm x 297 mm) - Portrait|
|Default Margins (Points)|