UniformSoftware main content

Commercial Template Sample: Adding Insurance Cost Field

Template#: c9006

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.
473 KBDownload

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

Screenshot

The screen shot for Commercial Template Sample: Adding Insurance Cost Field

Detail

This commercial invoice template adds the "Insurance Cost" and "Currency Symbol" fields to its original version.

The other templates that contain the "insurance cost" and the "currency symbol" fields are:

These insurance and currency code fields provide important information about international trading. As shown in Incoterms Rules (c9005), many incoterms rules specify how the insurance cost will be handled.

In this example, we placed the insurance and currency fields in the F15:K15 range. This was done by unmerging the original "Country of ultimate destination" cell to make space for the new cells. We also rearranged the "Country of Export" and "Country of Manufacture" cells. By moving the fields and labels, we aligned all the content in the F13:K17 section to make the form look professional and beautiful.

The cells for the newly added fields are named "oknInsurance" and "oknCurrencyCode", respectively. In the underlying database tables, the corresponding fields are named "Insurance" and "CurrencyCode".

The formula of the total cell is changed to the following:

=SUM(oknLineTotal_1:oknLineTotal_12)+oknInsurance

Format and Specification

Template#c9006
Belongs to

Commercial

Format (XLS or XLSX).xlsx
Columns9
Lines9
Line Height (Points)15.75
Print Area$F$3:$P$40
Papaer OrientationLandscape
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree