Assuming you have downloaded and installed Uniform Invoice Software:
Prefer to have a look at other samples? Try our Search tool!
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.
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)|
Music Store Invoicing Form (Wholesale) is a variant of Music Store Invoicing Form (Retail). It differs from the original version in that this wholesale version includes a new custom field, Discount, on the bottom of the form, allowing you to apply discount to wholesale clients.
Music Store Invoice Template (Retail) was designed specially for music company or store. The printable form (the main invoicing form on the center of the Invoice Excel spreadsheet is same as the default sales invoice template included in Uniform Invoice Software, but there are also several special fields added for music store business.
If you are running your own welding and fabrication business, this serial of free welding invoice templates is designed for you as a welder or manager. We have various formats and layouts here to help you create professional-looking welding invoices and receipts easily.
In the welding and fabrication service business there many ways a proposal or quote could be offered, it is also true when doing invoices and statements. This fifth sample on our welding invoices, Welding / Fabrication Tax Invoice, deals with the tax options.
Commercial Invoicing Form with Colorful Business Name is a customized invoicing template based on Commercial Invoicing Template. It has the same number of fields as the original template, but looks professional and beautiful with the additional colorful text boxes.
Invoice Template with Hours and Rate or Billing Format with Hours and Rate is a service billing format that calculates line totals from hours and hourly rate. Based on c4025 Hourly Service Billing Format, this template offers a different look and feel by applying various Excel formatting options.