BoostExcel main content

Sample Sales Invoice Template: Fixed Items

Template#: c5040

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

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

Screenshot

The screen shot for Sample Sales Invoice Template: Fixed Items

Detail

This sample demonstrates how to use fixed or static product items on the body part of the form. It is a sales template, thus including shipping address fields.

For a practical example of using fixed items, visit Concrete Pumping Work Order and Invoice (c5149).

In some businesses, the number of products or service items offered is limited, i.e., the client always orders the same group of products or services. It would be nice to have the form always leave the item number, item description, or even item unit price there and not change them. We call these static or fixed items because they don't change.

Using static and fixed items prevents you from typing or choosing the same product items again and again, saving your time and avoiding typo mistakes.

Note that these static or fixed items are not static text labels, such as your company information in the heading section. The static or fixed items are linked to database fields and get saved to the database when you click "Save To DB".

The fixed items even won't get cleared when you execute the "Clear & New" command. It sounds interesting because the "Clear & New" command is designed to clear all the content to make it a blank form for the next new invoice. So how do we tell the "Clear & New" command not to touch the items that are fixed?

The secret is that all these cell values are associated with formulas. For example, the first "Description" cell has the following formula:

="This item is fixed"

For a version for services, please see Service Invoice Template: Fixed Items (c5041)".

Format and Specification

Template#c5040
Belongs to
Format (XLS or XLSX).xlsx
Columns5
Lines12
Line Height (Points)16.50
Print Area$E$2:$N$44
Papaer OrientationPortrait
Default Margins (Points)
Left36.00
Right36.00
Top72.00
Bottom72.00
PriceFree

Related

Sample Service Invoice Template: Fixed Items Thumbnail
5.5 Inch X 8.5 Inch: 2 Invoices On One Template Thumbnail
Invoice Design for Personal Trainer or Fitness Instructor Thumbnail
Net 30 Invoice Sample Thumbnail
Law Firm Invoice Template Thumbnail
Consulting Invoice Template (4th Sample: Taxable Column) Thumbnail