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

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

Screenshot

screenshot for General Purchase Invoice Template (Sales, One Tax)

Detail

This form includes two editable columns, Description and Amount, and a Taxable checkbox column.

It includes the "Ship To" section, which contains 5 fields, namely oknShipName, oknShipAddress, oknShipCityStateZip, oknShipCountry, and oknShipContact.

The formulas are set so that when a Taxable box is checked, the Amount of the current line is included when calculating taxes. This is done by using an array formula for a hidden cell named oknLineTotalTaxable:

{=SUM(oknTaxable_1:oknTaxable_6*oknLineTotal_1:oknLineTotal_6)}

Note the "{" and "}" symbols in the formula, which indicate it is an array formula.

Format and Specification

Template#c2025
Belongs to

Sales

Format (XLS or XLSX).xlsx
Columns2
Lines6
Line Height (Points)39.75
Print Area$D$3:$M$41
Papaer OrientationPortrait
Default Margins (Points)
Left16.56
Right36.00
Top72.00
Bottom72.00
PriceFree