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.
The main purpose of creating this invoice template on InvoicingTemplate.com is to provide a sample on using custom fields with Invoice Manager for Excel.
If you use the freeware edition of this invoice template, you may find there is no much difference between this invoice template and the default sales invoice template shipped with Invoice Manager for Excel. The only difference appears outside the printable area on the center of the form, where you can find a Product Category column near the invoice body. Visit the gallries at Simple Invoice Template and Blank Invoice Templates for more information.
"Product Category" is a standard field defined in the Product database table, but not added to the "Invoice Body" database table. So when you create an invoice with Invoice Manager for Excel, the category information is not loaded along with product data, and thus not saved along with other invoice details.
However the support for custom fields in Invoice Manager for Excel makes overcoming this limitation easy and quick. What you need to do is to add the custom field "Product Category" to the invoice body database table, and then name a column of cells where you want to display the category when creating an invoice - in this sample, we don't want to show product category on printed invoices, so the product category column is defined outside the printable area.
For more information on using custom files, refer to the documents of Invoice Manager for Excel, which is included in the Invoice Manager for Excel setup program that you can download for free. Invoice Manager for Excel is fully functional within the trial period.
Format and Specification
|Name||Form with Product Category|
|Category||Sales Invoice Template|
|Release Date||Sunday, November 10, 2013|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||18.00|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|Price||Free (0.00 USD)|
|System||Windows 7 and later, and Excel 2007 and later.|
December 23, 2017
- Removed all the "select a product" buttons from the Excel form as the feature is now provided by the on-sheet picker button.
- Replaced all "Taxable" checkboxes with Excel form controls.
December 6, 2018
- Added descriptive text to the form to explain the usage of the "Product Category" cells.