This is a variant of the invoice template with 4 columns. The template is set with no tax and shipping address.
According to Australian Taxation Office, if your tax invoices meet the requirements for sales of $1,000 or more, you can also use them for sales of lesser amounts. So this template could be seen as a replacement of our original two formats. Furthermore, we redesigned the original "Taxable" checkboxes - in the original version, they are ActiveX controls; in this new version they are Excel / Office form controls. With the development of Microsoft Office / Excel, it seems that form controls get better support than old ActiveX controls. We've also moved all the "Taxable" controls into the printable forms, so that they will be included when printed (see the screenshot images below), or be included when you are generating PDF invoice (see all PDF invoice templates here on InvoicingTemplate.com).
The taxable checkboxes were removed completely, assuming all the products are taxable, no matter whether the Taxable option is checked or not for each product. This avoids an occasionally happened mistake when a taxable product or item must be manually entered on the invoice body, as the Taxable checkbox is not checked by default. The template implements this feature by deleting all the Taxable checkboxes and assigning a value of 1 (TRUE) to all the oknTaxable cells located in the hidden column C.
The tax names are set to its default values, "TAX1" and "TAX2". To change the tax names and rates, simply unprotect the "Invoice" worksheet by clicking the "Unprotect Sheet" command in the "Review" Excel ribbon tab. All the templates here on InvoicingTemplate.com are protected by default. This is a good way to prevent modifications to the layout and formulas of the template. All editable / fillable cells are unlocked so that they are selectable and editable even when the spreadsheet is protected. To set / view the locking status of a cell, first unprotect the sheet, and then right-click the cell you want to set, choose Properties. On the "Protection" tab of the "Format Cells" dialog box, you'll find the "Locked" property. If this property is checked, the cell will not be editable / fillable when the sheet is protected.
All the templates available here on InvoicingTemplate.com were initially created based on the general invoice template that was shipped with the installer program of Uniform Invoice Software. Each template has a version that works with Uniform Invoice Software, and another free version that works without the installation of Uniform Invoice Software. If you are familiar with Microsoft Excel, you may already find that it is easy to do such customizations, but we think it is still helpful to detail some basics of customizations so that someone who is not very familiar with Microsoft Excel could follow. This is why we create this serial of samples based on the proforma invoice template on InvoicingTemplate.com.
Music Store Invoice Template (Retail) was designed specially for music company or store. The printable form (the main invoicing form on the center of the Invoice Excel spreadsheet is same as the default sales invoice template included in Uniform Invoice Software, but there are also several special fields added for music store business.
In detail, the custom fields added to the Invoice Header database table are "voucher", "YourRef", "OurRef", "InvCurrency", "TotalOfficial" and "TotalProfessional". In addition to that, there are also a custom field, "Official", added to both the Product table and Invoice Body database table, which appears as a column on the debit note form, as you can see from the screenshots below.
The template has 6 lines on the invoice body. If you enter a description, the amount cell shows the word 'Free'. If you enter the actual amount in the cell outside the print area, the entered amount appears in the print area. This feature makes it possible for you to clearly display the word 'FREE' for the products or services you offered for free.
The color column is a custom field defined both in the Product and Invoice Body database tables, which is the most noticeable difference between this customized invoice template and the original 5 Price Levels (Sales, Amount) invoice template. This means that for each product, you can set its color property, and the color values are filled automatically when you choose products from the database. Like all the other invoice templates in this serials available here on InvoicingTemplate.com, the full power of the invoice template comes only with the installation of Uniform Invoice Software, although the free version of this "Form with 5 Price Levels (Sales, Amount, Custom Column)" invoice template can also help you create professional and beautiful invoices.