Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Bill Format with Change Calculation

Bill Format with Change Calculation (c5021)

c5021 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open bill-format-with-change-calculation-uis.xlsx.

Bill Format with Change Calculation (UIS Edition)

Bill Format with Change Calculation - UIS edition

Download

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

Without database file. How to download and use

113 KBDownload

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

326 KBDownload

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

2.82 MBDownload

Detail

This simple invoice template and bill format demonstrates how you can add the feature of change calculation to an existing form design by using Excel formulas. This could be useful for businesses who receive payments in cash frequently.

The template add 3 new fields to the left bar of the form. The first one is titled with "Total", which is the total amount the customer has to pay. The value of this cell is got from the "Total" cell on the bottom by using this formula:

=oknTotal

The second cell is titled with "Paid". If you click the cell that allows you to enter the payment amount, you'll notice the cell is named "oknPaymentBeforeChange", which differs from default "oknPayments" cell in the default template shipped with Uniform Invoice Software. This is the only manually editable one in this section, identified with a special background color.

The third cell is "Change". The cell has an Excel formula cell assigned:

=oknPaymentBeforeChange-oknTotal

As you've already known, this cell is the amount of change you have to pay back.

This template was originally published on uniformsoft.com as c5-021. We revisited it here on InvoicingTemplate.com to make it work well with the latest version of Uniform Invoice Software. The following description from Uniform Invoice Software could help you get a better understanding of the billing format with change calculation. For more business invoice samples and templates visit business invoice template.

If you are running a retail store or shop, you may need a feature that could calculate change to pay back automatically. For example, if the invoice total is 105.75 and the customer pays 108.00, you would own them 0.25 cents. With this free invoice template, you just enter 108.00 into the payment cell and it calculates the change to give back (i.e. 0.25) using a simple Excel formula.

Like other form designs here on InvoicingTemplate.com, Invoice Template with Change 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.

Format and Specification

Template#c5021
NameBill Format with Change Calculation
CategorySales Invoice Template
Release DateMonday, March 27, 2017
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines12
Line Height (Points)19.50
Print Area$F$3:$N$43
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35