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

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

Screenshot

screenshot for Basic Sales Invoice with Blue-violet Gradient Background

Detail

This form is a variant of the Basic Sales Invoice Template (Light Blue) (c3001). It has an abstract blue-violet gradient painting in the background that looks like it was brushed with liquid.

The itemized detail section features 3 columns: "#", "Description", and "Amount". This "#" column is a line number column, but not the "Item#" or "Product ID" column as found in many other templates. The value of the "#" column is filled automatically using an Excel formula like this:

=IF ( oknLineTotal_1=0,0,1)

So when you fill in an item with the "amount" (field name "oknLinetotal_?") value, the "#" column is filled with a line number like "1, 2, 3..." etc.

The "Product ID" column is still in the template but is placed on column A (ranging from A20 to A31), which is outside the printable section of the worksheet. This layout design allows you to have more space left for the "Description" column while still being able to use the "Product ID" column to fill in items quickly by entering the shortcut code of a product (such as SKU# or barcode numbers read by a scanner).

The "Amount" column is manually editable. This is archived by removing all the formulas from the column.

Suggested by one of our app users who is a painter and likes to make everything different, this template may not be your favorite. Don't worry, we've got hundreds of original templates for you to choose from!

Format and Specification

Template#c3018
Belongs to

Sales

Format (XLS or XLSX).xlsx
Columns3
Lines12
Line Height (Points)19.50
Print Area$F$2:$O$42
Papaer OrientationPortrait
Default Margins (Points)
Left18.00
Right18.00
Top75.60
Bottom75.60
PriceFree