The printed version.
Simple Sample - Decimal Precision of Product Prices (c4060)
c4060 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open simple-sample-decimal-precision-uis.xlsx.
Simple Sample - Decimal Precision of Product Prices - UIS 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.
The default invoicing template shows two digits after the decimal pointer in the Unit Price field. This simple invoice sample shows you how to change it.
In the underlying database structure definition, the "Price" field appears in two places - the Product table, and the Invoice Body database table. The "Price" field is defined as "decimal (15,6)" which means you can have up to 6 digits after the decimal pointer and the field is able to store a decimal value up to 15 digits in total. However on the "Invoice" worksheet in the default template, the "Price" column is formatted to show only two digits by default. In this example, we show you how to change it so that it shows 4 digits after the decimal pointer.
The detailed steps of this customization sample are shown below, with the sample template created in c4051 Simple Invoice Template - Discount Amount Field as the starting point. Note that you need have Uniform Invoice Software installed in order to follow this tutorial, which is our invoicing software app (invoicing program) that combines the power of Excel with backend database, providing features that could hardly be implemented with pure Excel only, such as management of customers, products, invoices and payments.
As stated earlier, in the database the underlying definition of the "Price" field allows up to 6 digits after the decimal pointer. So to have the Excel billing format show 4 digits, all we need to do is to change the display format.
On the other hand, many other fields, such as line totals, subtotal, total, tax amounts, shipping cost, payment amount, balance due etc., allow only two digits after the decimal pointer - if you take a look at the formula of these cells, there is a "round" formula the make sure the result of calculation having only two digits after the decimal pointer. If you want to change this, you need to use the Advanced Database Field Customization tool provided by Uniform Invoice Software.
As you can see from this simple invoice template sample, it is pretty easy to customize the billing form with the help of Excel of Uniform Invoice Software. Although not as big and complicated as some accounting and billing systems, such as QuickBooks, Uniform Invoice Software does provide its unique features that help you to create beautiful and professional invoice (see the PDF version too), receipt and statement.
If you are running a small business that has limited budget on the invoicing solution, try Uniform Invoice Software (download the trial version for free) to see if it is the best fit for your requirements. With Uniform Invoice Software, you create invoice by filling a blank form as easy as filling a paper form. There is no hard learning curve in order to bill your customers!
Like other form designs here on InvoicingTemplate.com, Simple Invoicing Sample - Decimal Precision of Product Prices 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 - Decimal Precision of Product Prices|
|Category||Sales Invoice Template|
|Release Date||Saturday, February 6, 2016|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||18.00|
|Printable with Papaer Size / Orientation||Simple Sample - Decimal Precision of Product Prices - Portrait|
|Default Margins (Points)|