This invoice template for purchaser created tax invoices mimics the fields defined in the Australian Taxation Office pdf sample (NAT 73657), with only one field addition - the "Invoice#", placed above the "Invoice Date" field, as we believe it is a useful field / information for both parties (the seller and the buyer) involved in the transaction. If you have Invoice Manager for Excel (namely Uniform Invoice Software) installed, the automatic invoice numbering feature is able to generate invoice numbers for you. The invoice generator works when you click the "Save Invoice" command and leave the "Invoice#" field empty. The sequential numbering generator provides several options that you can use to control how it works, including the next start number, the prefix text added to each invoice#, the number of digits in each invoice# (for example, "INV003" has 3 digits in the invoice#). See simple invoice templates for more samples.
If you have Invoice Manager for Excel installed, setting tax types is as easy as clicking several buttons. For example, if you find a template here on InvoicingTemplate.com interesting but don't need tax fields, you can set it to non-tax by firstly clicking the Settings button on the Invoice worksheet, and then go to the Taxes tab of the Settings dialog box. The Taxes tab offers 3 options, non-tax, one-tax and two-tax. Tax names and rates can also be set on the "Taxes" page of the Settings window.
This template is a revised version of our original designs, Australian GST Invoice Template and Australian GST Invoice Template (2). With this new template, we move the ABN# field to the top of the invoice form, and also modify the layout of the form to make it looks better and works more smoothly with the latest version of Invoice Manager for Excel.
This Malaysia Tax Invoice Template translates all the text inside the printable form into Malay.
The basic layout of the sheet is similar to the standard bill format shipped with Invoice Manager, but the static text labels are translated using an online tool. For more tax invoice requirements in Malaysia, visit PDF Tax invoice and records keeping - GST, What is Tax Invoice? How to issue Tax Invoice? and Issuing Tax Invoices.
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 Invoice Manager for Excel (namely Uniform Invoice Software). Each template has a version that works with Invoice Manager for Excel (namely Uniform Invoice Software), and another free version that works without the installation of Invoice Manager for Excel (namely 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.
The additional fields, which are not present in the default sales invoice template that is shipped with Invoice Manager for Excel (namely Uniform Invoice Software) setup program, are placed outside the printable area (the area with white background color on the center of the invoicing form). This means that, the addtioanl fields will not be printed if you issue the Print command in Microsoft Excel. These addtional fields include: COMPOSER, INSTRUMENTATION, PUBLISHER, COMMENT, which are all added to the Excel invoice form as columns.
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 field titled with "Our File Ref", which has a cell name oknOurRef, is implemented as a drop-down list.
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 Invoice Manager for Excel, 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.