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:
This template is designed for produce distributors and wholesalers. If your business sells agriculture and farming products, then try this template.
The cell named "oknShipVia" is changed to an integral numeric, indicating the number of days between the invoice date and the shipping date. For example, if you enter "3" in the "oknShipVia" cell and the invoice date is July 5, 2023, the shipping date will be July 8, 2023. This is calculated automatically using the following Excel formula:
The "Due Date" cell is also calculated using an Excel formula like this:
So in this form design, the "Payment Term" cell accepts an integral numeric value only.
In the bottom section, there is a declaration like this:
The perishable Agricultural commodities listed on this invoice are sold subject to the statutory trust authorized by section 5(c) of the Perishable Agricultural Commodities Act , 1930 (7 U.S.C.499e(c)). The seller of these commodities retains a trust claim over these commodities, all inventories of food or other products derived from these commodities, and any receivable or proceeds from the sale of these commodities until full payment is received.
Format and Specification
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||21.75|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|