Screenshots and Images
The printed version.
Open the template in Excel.
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
This basic sales invoicing sample has an abstract blue-violet gradient painting in the background that looks like brushed with a liquid. This design sample also has the stripes background on the detail section removed.
This template is a variant of c3001 Basic Sales Invoice Template (Light Blue). As one of the basic invoicing templates, it features all the required elements of a formal invoice - the "invoice date" and "invoice#" field, all the essential information about the seller and the buyer, and the goods purchased.
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 here on InvoicingTemplate.com. 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 invoiced item with the "amount" (field name "oknLinetotal_?") value, the "#" column is filled with a line # like "1, 2, 3 ..." etc.
As required by Invoice Manager for Excel, the "Product ID" column is still on the template, but is placed on column A (ranging from A20:A31), which is outside the printable section of the worksheet. This layout design allows you to have more space left for the "Description" column, but still being able to use the "Product ID" column to fill in invoiced items quickly by entering the shortcut code of a product (such as SKU# or barcode numbers read by a scanner).
The "Amount" column on this field is manually editable on creating invoices. This is archived by removing all the formulas from the column, and then unlock the cells so that they are editable when the template is protected.
Since Invoice Manager for Excel is able to generate electronic PDF invoice, image invoice and Excel invoice, and then email the invoice to the customer, the email address field is an essential field in the "Bill To" section. We also removed the "Country" field from both the "Bill To" and "Ship To" sections, as they are not commonly used.
Suggested by one of the Invoice Manager for Excel users who are a painter and likes to make everything different, this template may not your favorite. Don't worry, we've hundreds original invoicing template designs for you to choose! Start from our home page, where you can find a search box to help you locate templates easily with template# or name.
Format and Specification
|Name||Basic Sales Invoice with Blue-violet Gradient Background|
|Category||Sales Invoice Template|
|Release Date||Sunday, October 30, 2016|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||19.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|Price||Free (0.00 USD)|
|System||Windows 7 and later, and Excel 2007 and later.|