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.
Screenshots and Images
The printed version.
Open the template in Excel.
This invoicing format is basically the default template shipped with Invoice Manager for Excel (UIS), but with the "Taxable" boxes removed and an image of furniture and appliances on it. This sample template is suitable for stores and manufacturers that operate as a retailer or wholesaler. For a professional template designed for the furniture business, visit Professional Tax Invoice Template for Furniture.
By default the Excel form is protected. In the protected mode Excel will not allow you to change anything on the form, except those unlocked / editable cell values. To make the template editable, simply unprotect the Excel spreadsheet by going to the "Review" ribbon tab, and then choose "Unprotect sheet" from the "Changes" group. Once unprotected, it becomes an editable invoicing template.
The idea to remove the "Taxable" boxes is that for many business entities either all the invoiced items are taxable, or all are not taxable (or tax-exempt). In such situation showing the "Taxable" boxes on the printable form is not necessary and redundant, as the boxes occupy editable Description space on the form. With the removal of the "Taxable" options, we also modify the Excel formula assigned to the fields that calculates taxes. So in this version, taxes are calculated based "oknSubtotal", but not "oknLineTotalTaxable".
Like the original form design, all columns on this form, including "Product#", "Description", "Unit Price" and "Quantity" are manually fillable / editable on creating invoices, except the "Line total" cells which are calculated using a group of Excel formulas. All line totals are rounded to 2 decimals after the point, which is suitable for many countries / regions around the world like United States, United Kingdom and Australia etc. And by default, the "Unit Price" field, although is formatted to show 2 decimals after the point, you can in fact enter up to 4 digits after the point by simply apply an Excel numbering format to the cells.
Unlike Microsoft Word (".doc" or ".docx" format), the background image / watermark we added to an Excel file (".xls" or ".xlsx" format) does not show in the edit mode. Instead, it shows only on the printed document, or the PDF format editable bill sample for furniture and appliances.
Invoice Manager for Excel the Invoice worksheet to be protected (Excel "Review" ribbon tab / "Changes" group / "Protect Sheet" command), otherwise the invoicing software program will not react to the clicks on the on-sheet command buttons. When the sheet is protected, all cells that have been locked are not editable. All cells with formulas assigned are locked by default (and thus not editable to protect the formulas from being changed / overwritten), such as the "Line total" and "Subtotal", "Payment", "Total Due" cells on this template. All cells that are unlocked are manually editable / fillable on creating invoices, such as the cells in the "Bill To" and "Ship To" section, the "Invoice#" and "Invoice Date" cells, etc.
Format and Specification
|Name||Editable Bill Sample for Furniture and Appliances|
|Category||Sales Invoice Template|
|Release Date||Tuesday, November 1, 2016|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||18.00|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|System||Windows 7 and later, and Excel 2007 and later.|
November 19, 2018
- Removed the "shortcut keys" pane from sheet.