Valid Tax Invoice Template

1. South Africa Tax Invoice Template (Sales)

"South Africa Tax Invoice Template (Sales)" was found to be relative to Valid Tax Invoice Template with the score grade of 87.

(From Detail Page - about 65 words) - In order to comply with VAT regulations, for any sale of more than R50, you have to issue a tax invoice, with the word "tax invoice" printed on it. This is the most important document in the VAT system. The VAT Act prescribes that a tax invoice must contain certain details about the taxable supply as well as the parties to the transaction. This includes:

1. The value of the goods/services excluding VAT
2. The VAT amount (calculated at 14% of the above amount)
3. The value of the goods/services including VAT
4. The name, address and VAT registration number of the person buying the goods/services
5. And your own name, address and VAT registration number.

(From Detail Page - about 37 words) - It is of upmost importance to adhere to these valid tax invoice requirements. It is found that the South African Revenue Services (SARS) became very strict when they review or audit a Value added tax (VAT) period.

(From Detail Page - about 92 words) - If you are a service provider that does not need the shipping address section on the invoice form, see South Africa Tax Invoice Template (Service) here on InvoicingTemplate.com. We are also providing a special template that is suitable for attorney, where a "Date" column is added to the invoice detail section. Please refer to Free Attorney Invoice Template (South Africa Currency) for the details. All these templates and layout work with Uniform Invoice Software (UIS), which is able to turn a simple Microsoft Excel invoice template into a complete invoicing software system.

(From Format Page - about 63 words) - On Saturday, August 1, 2015 InvoicingTemplate.com released South Africa Tax Invoice Template (Sales) for the first time, and assigned "c4036" as its template#. Like all the other invoice templates here on InvoicingTemplate.com, South Africa Tax Invoice Template (Sales) has two editions, one free South Africa Tax Invoice Template (Sales) that is named "southafrica-sales-vat.xlsx", and another Uniform Invoice Software version that is named "southafrica-sales-vat-software.xlsx".

LEARN MORE PDF

2. Singapore GST Invoice Template (Sales)

"Singapore GST Billing Format (Sales)" was found to be relative to Valid Tax Invoice Template with the score grade of 70.

(From Detail Page - about 41 words) - Singapore GST Invoice Template (Sales), or Singapore GST Billing Format (Sales), meets the statutory compliance requirements that apply to Singapore private limited companies. The template is able to calculate tax (GST - Goods and Services Tax) and totals using Excel formulas.

(From Detail Page - about 123 words) - As IRAS (Inland Revenue Authority Of Singapore) states, a tax invoice must be issued when your customer is GST registered. Your customer needs to keep this tax invoice as a supporting document to claim input tax on his standard-rated purchases. In general, a tax invoice should be issued within 30 days from the time of supply. A tax invoice need not be issued for zero-rated supplies , exempt supplies and deemed supplies or to a non-GST registered customer. Your customers usually make payments only against valid original invoices. Following IRAS invoice requirements will ensure that invoices are valid. Note that your customers may have additional requirements regarding invoicing. Make sure your invoices meet their requirements so that you can get paid on time.

(From Detail Page - about 150 words) - Also known as Value Added Tax (VAT) in many other countries, Goods and Services Tax (GST) is a consumption tax that is levied on the supply of goods and services in Singapore and the import of goods into Singapore. GST is an indirect tax, expressed as a percentage (currently 7%) applied to the selling price of goods and services provided by GST registered business entities in Singapore. As a GST registered entity, you are required to submit a return to the tax authorities based on your accounting cycle, normally on a quarterly basis. GST registration is required only if the company falls under the following: 1) The turnover is more than S$1 million for the past 12 months 鈥?known as the retrospective basis 鈥揙R- 2) There is a reason to expect that the turnover will exceed S$1 million for the next 12 months 鈥?known as the prospective basis.

(From Detail Page - about 85 words) - This invoice template, c6021 Singapore GST Invoice Template (Sales), also named Singapore GST Billing Format (Sales), designed by InvoicingTemplate.com, was customized based on c6007 VAT Sales Invoice Template - Price Including Tax and c6008 VAT Sales Invoice Template - Price Excluding Tax. The service editions of these VAT invoice template could be found at c6013 VAT Service Invoice Template - Price Including Tax, and at c6014 VAT Service Invoice Template - Price Excluding Tax. The original invoice layouts were customized to meet the IRAS requirements:

LEARN MORE PDF

3. Handyman Invoice Template (No Tax)

"Handyman Billing Template (No Tax)" was found to be relative to Valid Tax Invoice Template with the score grade of 67.

(From Detail Page - about 40 words) - Handyman Invoice Template (No Tax) is a sample based on c7006 Handyman Invoice Template. Unlick the original template, where the invoicing items are charged with either one or two taxes (GST and PST), this handyman invoice template charges no tax.

...(16)...

(From Detail Page - about 56 words) - Handyman Invoice Template (No Tax) is provided in two editions - a freeware editions of Handyman Invoice Template (No Tax), and a Uniform Invoice Software edition of Handyman Invoice Template (No Tax). Both editions can be downloaded for free from the download page. A PDF edition is also provided at the right section of this page.

...(118)...

(From Detail Page - about 100 words) - While the free version of Handyman Invoice Template (No Tax) is simple, the result invoice created by using this template is as beautiful and professional as many commercial invoicing software program, or even better. It is an ideal tool for small businesses and freelances who offer services and don't need a shipping section on their invoicing form. It is a good service invoice creator, but if you need more features, like management of customers, products / service items, invoices and payments, just install Uniform Invoice Software to make all the buttons on Handyman Invoice Template (No Tax) work for you.

...(60)...

(From Detail Page - about 11 words) - To show gridlines and row/column headers in Excel 2000 - 2003:

1. Click and activate the worksheet you want to display gridlines and row/column headers for.
2. On the Tools menu, click Options, and then click the View tab.
3. Under Window options, check the Gridlines and Row & Column Headers check boxes.

...(40)...

(From Detail Page - about 14 words) - To show/hide gridlines and row/column headers in Excel 2007, Excel 2010 and Excel 2013:

1. Click and activate the worksheet you want to display gridlines and row/column headers for.
2. Go to the View tab of the Ribbon.
3. Click Show/Hide, and then check or uncheck the Gridlines and Headings options.

...(17)...

(From Detail Page - about 143 words) - The printable area, or print area, is the area with white background on the center of the Handyman Invoice Template (No Tax) spreadsheet. By default Microsoft Excel prints the entire worksheet when you issue the print command, but if the worksheet has a print area defined, such as what we do for Handyman Invoice Template (No Tax), only the print area will print. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet again. If you need to recreate the print area definition, here are what to do: On the "Invoice" worksheet of the Handyman Invoice Template (No Tax), select the cells that you want to define as the print area; On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

...(236)...

(From Detail Page - about 117 words) - To change the currency symbol of Handyman Invoice Template (No Tax), first make sure you've unprotected Handyman Invoice Template (No Tax) spreadsheet. Select the cells (fields) for which you want to modify the currency symbol, by dragging your mouse to select multiple cells on Handyman Invoice Template (No Tax), you push CTRL key on keyboard and click each cell on Handyman Invoice Template (No Tax) one by one, and then right-click one of the selected cell and choose Format Cells. From the Number tab, you can choose either "Currency" or "Accounting" from the Category list. Note that currency formats are used for general monetary values, you should use accounting formats to align decimal points in a column.

LEARN MORE PDF

4. New Zealand Tax Invoice Template

"New Zealand Tax Billing Form" was found to be relative to Valid Tax Invoice Template with the score grade of 55.

...(31)...

...(81)...

(From Detail Page - about 214 words) - GST, stands for Goods and Services Tax, is a value added tax, implemented in Canada, Hong Kong, India, Malaysia, New Zealand and Singapore etc. Goods and services tax (GST) is a tax on most goods and services in New Zealand, most imported goods, and certain imported services. GST is added to the price of taxable goods and services at a rate of 15%. GST in New Zealand is designed to be a broad based system with few exemptions. Exceptions that do exist include rents collected on residential rental properties, donations, precious metals and financial services. End-users pay this tax on all liable goods and services directly, in that the purchase price of goods and services includes GST. GST-registered organizations and individuals pay GST only on the difference between GST-liable sales and GST-liable supplies (i.e., they pay GST on the difference between what they sell and what they buy: income less expenditure). This is accomplished by reconciling GST received (through sales) and GST paid (through purchases) at regular periods (typically every two months, with some qualifying companies opting for one-month or six-month periods), then either paying the difference to the Inland Revenue (IRD) if the GST collected on sales is higher or receiving a refund from IRD if the GST paid on purchases is higher.

...(26)...

(From Detail Page - about 16 words) - As a Excel-based template, it is easy to implement the auto-calculation of tax by using formulas.

(From Detail Page - about 89 words) - As you can see from New Zealand Tax Invoice Template, one benefit of using Excel as your invoice creator, as compared to other invoice template formats like Microsoft Word invoice template and PDF invoice template, HTML invoice template or even Photoshop invoice template, is that you can easily apply formulas to do calculations. This means that, once the basic figures are entered on the form, like Quantity and Unit Price, or Hours and Hourly Rate, or Days and Daily Rate, the calculation of totals and taxes is done automatically.

...(90)...

• Right click the Logo image, and then select Properties from the menu.
• Click the Picture property, and then click the "..." button.
• Browse to the folder containing your icon file. Select and open the icon file.
• Close the Properties dialog box.
• Drag the border of the image object to resize it, if needed.

...(100)...

(From Detail Page - about 28 words) - If you don't need the shipping address section to appear on invoice form, it is easy to move the entire shipping address section out of the print area.

...(143)...

(From Detail Page - about 236 words) - Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in New Zealand Tax Invoice Template before doing the movement. And, if the target location contains merged cells, sometimes the movement fails. So it is also helpful to make sure the target location does not contain merged cell. If the target location New Zealand Tax Invoice Template is overlapping the original range and the original range contains merged cells, the movement could also fail because you cannot change part of merged cell - if this happens, you need to first move the cells to a temporal location in New Zealand Tax Invoice Template that are empty (i.e. not used), unmerge cells, and then move the cells from the temporal location to the desired location. If you need to unmerge a cell, first select it and then click the "Merge and Center" command on the Format toolbar in Excel 2003; or click the "Merge and Center" command on the Home ribbon tab in Excel 2007, 2010 and Excel 2013.

(From Detail Page - about 214 words) - New Zealand Tax Invoice Template, like the other invoicing templates here on InvoicingTemplate.com, are great choice for businesses, corporates, small / home businesses, consulting, freelancers, sales businesses or a contractor as well. If you were searching for invoice templates then you have landed at the right place because here you will not only get free invoice templates but premium invoice templates too. You may be in a corporate, sales business, consultancy firm, contractor, freelancer, Web designer or any other business, one thing you will need for sure and that is an "Invoice Template" for billing purposes. But at times, you find invoices which are either too boring, hard to customize or sometimes, you just don't find the right for your business. That's where a well designed invoice template can play a vital role because these templates not only gives you flexibility to use them on multiple platforms but also allows easy customization. New Zealand Tax Invoice Template, like all the other fill-in-blank invoicing templates here on InvoicingTemplate.com, are in Microsoft Excel spreadsheet format. You get all familiar Excel tools for customizing New Zealand Tax Invoice Template. For this reason, you can just use New Zealand Tax Invoice Template as a starting point of design your own invoice template that exactly meets your business style.

LEARN MORE PDF

5. Blank Commercial Invoice Template

"Blank Commercial Invoice Template" was found to be relative to Valid Tax Invoice Template with the score grade of 52.

...(48)...

(From Detail Page - about 82 words) - This simple yet elegant template should be used as a final bill after good have shipped. "Blank Commercial Invoice Template" has detailed buyer, seller, and order information as well as a section to specify agreement terms. This free commercial invoice template is in Microsoft Excel spreadsheet format. The template offers an intuitive blank commercial invoice form that is printable and highly customizable. You can download a high quality blank commercial invoice form to create your own professional commercial invoice for your business.

(From Detail Page - about 77 words) - The form offers an easy way to quickly complete a commercial invoice and print it directly from Microsoft Excel. All the essential information required by a commercial invoice is provided including invoice no, date, shipper/ exporter, consignee, booking #, term of payment, delivery conditions, port of lading, final destination, exporting carrier, currency of sale, total gross weight, cubic meters as well as other costs information such as packing cost, freight cost, insurance cost and duties and taxes.

...(53)...

(From Detail Page - about 114 words) - The freeware edition of Blank Commercial Invoice Template provides exactly the same form layout and design in Microsoft Excel format as the Uniform Invoice Software edition of Blank Commercial Invoice Template. The most noticeable difference, at the first glance, is that the Uniform Invoice Software edition of Blank Commercial Invoice Template contains many buttons on it, such as Customers, Products, Invoices and Reports, etc. These buttons calls features and functionalities implemented by Uniform Invoice Software. For example, if you click "Save To DB", the Uniform Invoice Software validates and checks the current document on Blank Commercial Invoice Template, generate a unique invoice number automatically (if necessary), and then save it to the backend database.

...(17)...

(From Detail Page - about 89 words) - (Note that if you have installed the latest version of our invoicing software, Uniform Invoice Software, which is able to upgrade a simple template in Microsoft Excel spreadsheet format into a complete invoicing system, you don't have to replace the logo image manually - you can replace the default logo image by clicking the "Replace Logo Image" button on the ribbon tab in Excel 2007, Excel 2010 and Excel 2013). To replace the default LOGO image in Blank Commercial Invoice Template with your own image, follow the steps below:

• Right click the Logo image, and then select Properties from the menu.
• Click the Picture property, and then click the "..." button.
• Browse to the folder containing your icon file. Select and open the icon file.
• Close the Properties dialog box.
• Drag the border of the image object to resize it, if needed.

...(100)...

(From Detail Page - about 12 words) - This Blank Commercial Invoice Template formats prices with US dollars currency symbols.

...(113)...

(From Detail Page - about 11 words) - Want to try another commercial invoice template? Try Commercial Invoicing Template.

LEARN MORE PDF

6. Debit Note Template for Attorney

"Debit Note Form for Attorney" was found to be relative to Valid Tax Invoice Template with the score grade of 37.

...(39)...

(From Detail Page - about 135 words) - Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the invoice form. Debit Note Template for Attorney uses custom fields to implement the features that are not available in the default sales invoice template. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, Uniform Invoice Software has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

...(111)...

(From Detail Page - about 232 words) - When working with Uniform Invoice Software version of Debit Note Template for Attorney, how does Uniform Invoice Software know to which cell when a field value write to when loading data from the database, and to which field a cell value must save when saving an invoice, a customer or a product item? That is, how does Uniform Invoice Software create the map or relationship between Excel cells on the template Debit Note Template for Attorney and database fields? The answer is by using names. For example, if the field name in the Product table in a database is "ProductType", it is writing to a cell named "oknProductType_?" (where ? is the line number of the invoicing item) when you pick up a product or item on creating an invoice, and when saving an invoice, all cells with the name "oknProductType_?" are saved to the "ProductType" field in the Invoice Body database table. By using cell names, Uniform Invoice Software allows you to move a cell on the form without breaking the feature depending on the field / cell. You can place the "Product Type" column either inside the printable area, which is printed when you issue the Print command in Excel or click the Print command on the Invoice form; or place the Product Type column outside the printable area, which will be included when you print or extract an invoice.

...(71)...

(From Detail Page - about 60 words) - 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.

(From Detail Page - about 19 words) - The field titled with "Our File Ref", which has a cell name oknOurRef, is implemented as a drop-down list.

...(135)...

...(44)...

(From Detail Page - about 194 words) - Creating the drop-down list is in fact easy and quick in Excel. First, you must have the list of valid entries prepared. To create a list of valid entries for the drop-down list for Debit Note Template for Attorney, type the entries in a single column or row without blank cells. Now select the cell where you want the drop-down list added for Debit Note Template for Attorney. On the Data tab, in the Data Tools group, click Data Validation. In the Data Validation dialog box, click the Settings tab. In the Allow box, click List. To specify the location of the list of valid entries, do one of the following: If the list is in the current worksheet, enter a reference to your list in the Source box; if the list is on a different worksheet, enter the name that you defined for your list in the Source box. Make sure that the In-cell dropdown check box is selected. To specify whether the cell can be left blank, select or clear the Ignore blank check box. Close the dialog box to have Excel creates the drop-down list for Debit Note Template for Attorney.

(From Detail Page - about 105 words) - Although it is easy to create the layout and format of Debit Note Template for Attorney with Microsoft Word or other Microsoft Office programs, or even with some PDF programs, the support for Excel formulas makes doing automated calculations easy to implement and modify. For example, Debit Note Template for Attorney uses Excel formulas extensively to do calculations whenever possible and necessary, such as the taxes, totals. If you use the Uniform Invoice Software version of Debit Note Template for Attorney, Excel formulas are also used to create the relationship between several fields, such as one field should be the sum of two other fields.

...(56)...

(From Detail Page - about 118 words) - The freeware edition of Debit Note Template for Attorney provides exactly the same form layout and design in Microsoft Excel format as the Uniform Invoice Software edition of Debit Note Template for Attorney. The most noticeable difference, at the first glance, is that the Uniform Invoice Software edition of Debit Note Template for Attorney contains many buttons on it, such as Customers, Products, Invoices and Reports, etc. These buttons calls features and functionalities implemented by Uniform Invoice Software. For example, if you click "Save To DB", the Uniform Invoice Software validates and checks the current document on Debit Note Template for Attorney, generate a unique invoice number automatically (if necessary), and then save it to the backend database.

LEARN MORE PDF

7. Simple Template - Moving Shipping Address

"Simple Template - Moving Shipping Address" was found to be relative to Valid Tax Invoice Template with the score grade of 26.

(From Detail Page - about 29 words) - The templates that have no shipping address section are categorized as service invoice template. This simple invoice template demonstrates how to create it by moving out shipping address fields.

(From Detail Page - about 33 words) - This customized simple invoice template is based on the result of c5076 Simple Invoice Template - Moving Taxable Controls, which was categorized as sales invoice template because it contains the shipping address section.

(From Detail Page - about 34 words) - Usually creating a new invoice template that works an invoicing software app sounds difficult. This is not true with Uniform Invoice Software, which is our invoicing software that use Excel spreadsheets as the front-end.

(From Detail Page - about 65 words) - By using Excel invoicing forms, it is possible to leverage all the powerful tools provided by Microsoft Excel to do design of invoicing forms, including create relationship between Excel cells by using formulas - for example, in c4051 Simple Invoice Template - Discount Amount Field a new field Discount Amount was added and its relationship between Subtotal and taxes are established by using Excel formulas.

(From Detail Page - about 70 words) - To those users who want to know more about how Uniform Invoice Software works - The reason that Uniform Invoice Software supports moving fields is simple - it identify cells by names. So even if a cell, such as in this sample the "oknShipName", is moved to a new location (from $J$9 to $T$9), Uniform Invoice Software is still able to find it and map it to the database field.

...(22)...

The detailed steps are described below.

...(482)...

(From Detail Page - about 46 words) - As you can see from the creation of this simple invoice template, it is not as hard as it sounds to create a new invoice form. You can use this template directly for your service business, or as a starting point of design your own template.

LEARN MORE PDF

8. Singapore GST Invoice Template (Service)

"Singapore GST Invoice Template (Service)" was found to be relative to Valid Tax Invoice Template with the score grade of 17.

...(37)...

(From Detail Page - about 37 words) - As a general business rule, it is of critical importance that the customer receives valid supporting documentation, meeting all legal and tax requirements. This will usually be an invoice drawn in accordance with the supplier's country regulations.

...(36)...

(From Detail Page - about 46 words) - As stated above, c6022 Singapore GST Invoice Template (Service), or Singapore GST Billing Format (Service), was created based on c6021 Singapore GST Invoice Template (Sales) or Singapore GST Billing Format (Sales), by moving out the shipping cells out of the printable area of the Excel sheet.

...(143)...

(From Detail Page - about 236 words) - Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in Singapore GST Invoice Template (Service) before doing the movement. And, if the target location contains merged cells, sometimes the movement fails. So it is also helpful to make sure the target location does not contain merged cell. If the target location Singapore GST Invoice Template (Service) is overlapping the original range and the original range contains merged cells, the movement could also fail because you cannot change part of merged cell - if this happens, you need to first move the cells to a temporal location in Singapore GST Invoice Template (Service) that are empty (i.e. not used), unmerge cells, and then move the cells from the temporal location to the desired location. If you need to unmerge a cell, first select it and then click the "Merge and Center" command on the Format toolbar in Excel 2003; or click the "Merge and Center" command on the Home ribbon tab in Excel 2007, 2010 and Excel 2013.

(From Detail Page - about 100 words) - While the free version of Singapore GST Invoice Template (Service) is simple, the result invoice created by using this template is as beautiful and professional as many commercial invoicing software program, or even better. It is an ideal tool for small businesses and freelances who offer services and don't need a shipping section on their invoicing form. It is a good service invoice creator, but if you need more features, like management of customers, products / service items, invoices and payments, just install Uniform Invoice Software to make all the buttons on Singapore GST Invoice Template (Service) work for you.

LEARN MORE PDF

9. Welding Invoice Template

"Welding Invoicing Form" was found to be relative to Valid Tax Invoice Template with the score grade of 11.

...(43)...

(From Detail Page - about 133 words) - All our templates are offered to you by InvoicingTemplate.com online in Microsoft Excel spreadsheet format, including this Welding Invoice Template. Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphing tools, pivot tables, and as a part of Microsoft Office - the other famous Office programs includes Word, PowerPoint and Access. It has been the industry standard for spreadsheets, and thus being an ideal maker and format for creating electronic (paperless) fillable, editable and printable sales orders, purchase orders, estimates, invoices, quotes, letters, brochures, receipts, time sheets, statements and other business forms. Our templates, including Welding Invoice Template, are also available in blank downloadable PDF format. We are also providing Uniform Invoice Software, which utilizes these templates and offer powerful processing and management features.

...(133)...

(From Detail Page - about 105 words) - InvoicingTemplate.com is also offering you other welder invoicing templates. c5064 Simple Welding Invoice Template, which contains only 5 columns, giving you the most fillable fields on the form; and c8004 Welding and Fabrication Service Invoice Template, which simplify the calculation of pricing plans. With c7021 Welder Invoicing Template, we moved the shipping address section back into the printable range, and moved out the Type column to give more space to the Description column. With c6017 Welding / Fabrication Tax Invoice, we moved the Dimension column out of the printable area, and moved in the taxable column so that it is included in the printable invoice.

(From Detail Page - about 60 words) - In order to detail the welding and fabrication job that has done, this free template has a number of custom fields added to the template. One custom fields added to the Customer database table is WhoTaxID, which replace the default CustomerID appears on the "Bill To" section, and the original CustomerID cell was moved out of the printable invoice area.

...(26)...

(From Detail Page - about 33 words) - The third custom field defined in the Product table is WeightPerFtPerSqFt, which is a decimal value, and is retrieved and filled into the corresponding Excel cell when an item is picked on invoicing.

...(91)...

=ROUND(IF(AG23>0,AG23*oknQuantity_1,
IF(AH23>0,AH23*oknWeightPerFtPerSqFt_1*oknQuantity_1,
IF(AI23>0,AI23*oknQuantity_1/12*oknWeightPerFtPerSqFt_1,0))),3)

(From Detail Page - about 97 words) - Adding a custom field to the Product table in the database makes it possible to save the field value to database along with the other data of a product. For example, adding the custom field "Product Type" to the Product database table allows you to save the type, such as "General" or "Labor", to the database when you save a product or item. If you use Uniform Invoice Software version template Welding Invoice Template and add the custom field to the invoice form, the value is retrieved whenever you pick up a product on creating an invoice.

(From Detail Page - about 86 words) - Adding a custom field to the Invoice Body database table makes it possible to save the data on the invoice form to database when the "Save To DB" button is clicked. For example, adding the custom field "Product Type" to the Invoice Body database table allows save the type value on the invoice form, such as "General" or "Labor", to database when you save an invoice by clicking the "Save To DB" button. This feature is not supported in the freeware edition of Welding Invoice Template.

(From Detail Page - about 67 words) - The Invoice Header database table holds 8 custom fields in this design. They are Discount, Insurance, Job Name, Order By, Other, Other Name, Shipping Tax ID, Who Tax ID. All these fields are mapped to cells on the invoicing form, by naming the cell with "okn" plus the database field name. For example, the cell that is mapped to the "Order By" database field is named oknOrderBy.

...(64)...

(From Detail Page - about 16 words) - There is also a comment on the bottom of the invoicing form, which reads as follows.

Price in effect applies at the time of order and subject to availability. ***% per month service charge applied to accounts past *** days. Annual rate of ***%. All claims and returned goods require original receipt. Price in effect applies at the time of shipment. Quotes Valid for *** days. Prices are subject to change without notice.

(From Detail Page - about 19 words) - Note that you have to replace the placeholders "***" with proper content, or you can delete the comment altogether.

(From Detail Page - about 34 words) - The "Received By" field on the bottom of the invoice form is for manually signature on the printed invoice. You can remove this from your own invoice layout if you send only electronic invoices.

LEARN MORE PDF

10. Music Store Invoice Template (Wholesale)

"Music Store Invoicing Form (Wholesale)" was found to be relative to Valid Tax Invoice Template with the score grade of 5.

...(45)...

...(104)...

(From Detail Page - about 76 words) - The steps of adding the discount rante and discount amount fields to database tables are similar to what we've done in Music Store Invoicing Form (Retail). Note that this time, you have to choose Invoice Header database table. If you want to set default Discount Rate for each computer, so that the rate value is populated automatically each time a customer is picked up, simply add the Discount Rate custom field to the Customer database table.

...(63)...

...(22)...

• Click the "Customers" button on the "Invoices" ribbon tab for Excel 2007, Excel 2010 and Excel 2013, or click the "Customers" button on the Invoice worksheet if you are running Excel 2003.
• Click the "Custom Fields" button on the toolbar to open the Custom Field Manager dialog box.
• Make sure the "Database Table" list shows "Customers", and then click "Add Field". The "Add New Custom Field" dialog box appears.
• Enter VATRegNumber in the "Field Name" box, select "Text" as the "Type", Enter "50" into the "Size" box. Click OK to create the custom field.
• Click "Close" to close the "Custom Field Manager" dialog box.
• Now you have successfully create a custom field named VATRegNumber. To map this field to the Excel layout, use cell names. In this sample, the field VATRegNumber map to cell named oknVATRegNumber. That is, add the prefix "okn" to the field name.

...(59)...

(From Detail Page - about 63 words) - The protection of the Invoice worksheet in Music Store Invoice Template (Wholesale) prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the invoice worksheet. However for the purpose of this sample, we should firstly unprotect the Invoice worksheet in Music Store Invoice Template (Wholesale).

...(39)...

(From Detail Page - about 40 words) - After your customization, go back to the Tools menu, Options, View tab. Under Window options, REMOVE the checks you previously placed by the two check boxes to hide gridlines and row/column headers. This will restore the appearance of your template.

...(14)...

1. Click and activate the worksheet you want to display gridlines and row/column headers for.
2. Go to the View tab of the Ribbon.
3. Click Show/Hide, and then check or uncheck the Gridlines and Headings options.

(From Detail Page - about 17 words) - The gridlines and row/column headings could help a lot when design the layout of the invoice form.

(From Detail Page - about 37 words) - To insert a new row underneath the "Subtotal" row: Right-click the row header of the first tax row, and choose "Insert" from the shortcut menu. A new row is inserted, now you have to name the cells.

...(11)...

=ROUND(oknSubTotal*oknDiscountRate,2)

(From Detail Page - about 21 words) - You should also modify the formula of the "Total" cell to use the discounted amount instead of the original subtotal amount:

=ROUND(oknSubTotal -oknDiscountAmount + oknShippingCost + 
 IF(oknTaxType=0,0,IF(oknTaxType=1,oknTax1,oknTax1+oknTax2)),2)

...(127)...

(From Detail Page - about 105 words) - Although it is easy to create the layout and format of Music Store Invoice Template (Wholesale) with Microsoft Word or other Microsoft Office programs, or even with some PDF programs, the support for Excel formulas makes doing automated calculations easy to implement and modify. For example, Music Store Invoice Template (Wholesale) uses Excel formulas extensively to do calculations whenever possible and necessary, such as the taxes, totals. If you use the Uniform Invoice Software version of Music Store Invoice Template (Wholesale), Excel formulas are also used to create the relationship between several fields, such as one field should be the sum of two other fields.

...(56)...

(From Detail Page - about 118 words) - The freeware edition of Music Store Invoice Template (Wholesale) provides exactly the same form layout and design in Microsoft Excel format as the Uniform Invoice Software edition of Music Store Invoice Template (Wholesale). The most noticeable difference, at the first glance, is that the Uniform Invoice Software edition of Music Store Invoice Template (Wholesale) contains many buttons on it, such as Customers, Products, Invoices and Reports, etc. These buttons calls features and functionalities implemented by Uniform Invoice Software. For example, if you click "Save To DB", the Uniform Invoice Software validates and checks the current document on Music Store Invoice Template (Wholesale), generate a unique invoice number automatically (if necessary), and then save it to the backend database.

LEARN MORE PDF