Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
436 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

screenshot for Bill Format with Change Calculation

Detail

This template demonstrates how you can add the feature of change calculation to an existing form. This is useful for businesses that receive payments in cash frequently.

The template adds three new fields to the left bar of the form. The first one is titled "Total", which is the total amount the customer has to pay. The value of this cell is gotten from the "Total" cell at the bottom by using this formula:

=oknTotal

The second cell is titled "Paid". It is named "oknPaymentBeforeChange". This is an editable field, 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 is the amount of change you have to pay back.

Format and Specification

Template#c5021
Belongs to

Sales

Format (XLS or XLSX).xlsx
Columns5
Lines12
Line Height (Points)19.50
Print Area$F$3:$N$43
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree