Skip to main content
InvoicingTemplate.com main content

South Africa Tax Invoice Template (Sales)c4036

South Africa Tax Invoice Template (Sales)

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

...(65) 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.

Recipient Created Tax Invoices Formc4077

Recipient Created Tax Invoices Form

"Template for Purchaser Created Tax Invoices " was found to be relative to Create An Invoice Template with the score grade of 78.

...(145) 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 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.

Proforma (1st Sample of Customization)c7011

Proforma (1st Sample of Customization)

"Proforma (1st Sample of Customization)" was found to be relative to Create An Invoice Template with the score grade of 73.

...(26) With this first sample, we do only three basic steps - convert ".xls" format to ".xlsx" format, unprotect the Invoice worksheet and then change some colors.

  1. First, open the original ".xls" formatted proforma invoice template in Excel 2010 (Excel 2007 and all the later versions support ".xlsx" spreadsheet format).
  2. Click Excel menu File / Save As. If you have Uniform Invoice Software installed, a warning message appears that says "If you save this workbook with a different file name, you must re-open it to ensure Uniform Invoice Software functions properly. Are you sure you want to continue? " Choose Yes.
  3. On the "Save As" dialog box, choose "Excel Workbook" from the "Save as type" drop-down list. Name the new template "proforma 1st sample", or something else you like.
  4. If you have Uniform Invoice Software installed, you may find that after executing Excel "Save As" command, all the buttons on the new template stop working. This is not a bug, bug by design - as stated above, you need to close and then reopen the template if you want to make the buttons work. But for the purpose of this sample, we'll skip this step.
  5. Now unprotect the Invoice worksheet. To do this in Excel 2010, go to the "Review" ribbon tab and click the Unprotect Sheet command.

    The protection of the "Invoice" worksheet in Proforma (1st Sample of Customization) 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 worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in Proforma (1st Sample of Customization).

  6. The background color we used for the labels "SHIP TO", "BILL TO", "SHIPPING DETAILS" and the heading line of the invoice body, as well as the fore color of the big title "PRO FORMA INVOICE", is a custom color defined in Excel palette. You can find this color on many of the templates designed by us here on InvoicingTemplate.com - In fact, we use this color since 2005 - when we released Excel Invoice Manager for the first time. To make sure all of our templates have a similar style, this color has never been changed.

    However, to make your own invoice template, you may like to change it. Here is how you can do it (Again, we are using Excel 2010 in this tutorial.)

    • Open Proforma (1st Sample of Customization) as usual.
    • Click Excel menu File, and then click Options.
    • Click Save.
    • Next to Choose what colors will be seen in previous versions of Excel, click Colors.
    • Click the color that you want to change - for example, the fourth on the last line, and then click Modify.
    • Specify the new color. Click OK to close the Colors dialog box.
    • Click OK to close the Color dialog box. Click OK again to close the Excel Options dialog box.
  7. Once returned to the Invoice worksheet, you can find the new color applied to the invoice form. See the figures below to find an example.

Customization of Standard Fieldsc4108

Customization of Standard Database Fields

"Customization of Standard Fields" was found to be relative to Create An Invoice Template with the score grade of 68.

...(17) See "Advanced Database Field Customization" chapter of Uniform Invoice Software documents for more information on this topic.

...(50) Note that if you change the size of the text field, you may also need to change the data validation of the corresponding cell. For example, if you change the size of customer name field to 80, to change the data validation of the Excel cell, follow the steps below.

  • When the Invoice worksheet is active, push the "Design Mode" button on the "Invoice" ribbon tab.
  • Click and choose the customer name cell that is named "oknWhoName".
  • Go to "Data" Excel ribbon tab, and then click "Data Validation" in the "Data Tools" group.
  • Specify the new validation - for this example, you just need to modify the "Maximum" field to be 80.
  • Exit design mode.
  • Save the invoice template.

Law Firm Invoice Templatec5104

Law Firm Invoice Template

"Law Office Billing Sample " was found to be relative to Create An Invoice Template with the score grade of 67.

...(43) This sample invoice provides another option that you can choose for you law firm or small law office. Like other templates available here on InvoicingTemplate.com, The Excel version works with Uniform Invoice Software (UIS), and the PDF version is created by using UIS.

...(83) Unlike c5067 Attorney Invoice Template, this law office billing template includes not only the "Bill To" section, the "Ship To" section (usually found on those sales invoice that allows you specify a different shipping address than the "Bill To" address) is kept inside the printable form, but has a new title "Rep. Of" (representative of), . This allows you to specify different parties who are responsive for paying the bill, and who is the party to the lawsuit or receives the law services.

Lightweight Service Invoice Templatec5071

Lightweight Service Invoice Template

"Lightweight Service Invoice Template" was found to be relative to Create An Invoice Template with the score grade of 60.

...(86) Naming a control or an image is easy in Microsoft Excel. First make sure your template Lightweight Service Invoice Template is in design mode. Right-click the control or image you want to assign it a name, choose Properties. On the Properties box, enter the name into the "name" field and press enter. Note that if you have several controls that you want to assign different names, you can do so by entering the name and then clicking to choose another control without closing the Properties window.

Proforma (2nd Sample of Customization)c7012

Proforma (2nd Sample of Customization)

"Proforma (2nd Sample of Customization)" was found to be relative to Create An Invoice Template with the score grade of 59.

...(52) Once the invoice spreadsheet is unprotected, it's straightforward to enter your own company information. Simply click a text label such as "Your Company Name", and then start typing in your own text. In the sample template that you can download here, we replace the placeholder text labels with our own company name.

...(55) The next step is to replace the default "InvoicingTemplates" logo image. To do this, you need to switch the invoice form into design mode, which is done by clicking the "design mode" command on the Developer ribbon tab. If your Excel does not show the Developer ribbon tab, here is how to make it visible.

Simple Template - Moving Shipping Addressc5077

Simple Template - Moving Shipping Address

"Simple Template - Moving Shipping Address" was found to be relative to Create An Invoice Template with the score grade of 55.

...(38) One of the most powerful feature supported by Uniform Invoice Software invoicing formats is that it allows you to move the fields around. This is the most simple yet powerful way of create new invoice layouts and designs.

...(70) 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.

Green Gradient Service Invoicec2037

Green Gradient Service Invoice Template

"Green Gradient Service Invoice Template" was found to be relative to Create An Invoice Template with the score grade of 45.

...(51) Microsoft Excel itself does not include a built-in feature for gradient background color. However as a number of invoice samples here on InvoicingTemplate.com show, it is easy to apply a background to the form, which is included in the invoices that you print, or PDF invoices generated using the Excel template.

...(30) For example at c4085 Simple Consulting Bill with Printable Background Image in the consulting invoices category, we added a drawing picture of a business man as a background / watermark.

Backorder Invoice Templatec7002

Backorder Invoice Template

"Backorder Billing Form" was found to be relative to Create An Invoice Template with the score grade of 36.

...(51)Backorder Invoice Template is provided in two editions - a freeware editions of Backorder Invoice Template, and a Uniform Invoice Software (UIS) edition of Backorder Invoice Template. Both editions can be downloaded for free from the download page. A PDF edition is also provided at the right section of this page.

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

Bill Sample in Estonianc6026

Bill Format in Estonian

"Bill Sample in Estonian" was found to be relative to Create An Invoice Template with the score grade of 32.

  1. Backup your template before customizing it.
  2. Open the template.
  3. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.
  4. Click to select the text label that you want to replace.
  5. Enter the new text to replace the existing one
  6. Repeat the above steps to replace all the text labels.
  7. Once done, exit design mode by clicking the "Design Mode" button again on the "Invoice" ribbon tab.
  8. Save the template.
  1. Once the template is in design mode, right-click the cell.
  2. Choose "Format Cells" from the shortcut menu.
  3. On the "Number" tab, choose "Date" from the "Category" list.
  4. Choose the proper date format from the "Type" list.

United Arab Emirates Invoice Templatec5073

United Arab Emirates Billing Form

"United Arab Emirates Billing Form" was found to be relative to Create An Invoice Template with the score grade of 28.

...(163) If you use the Uniform Invoice Software version of United Arab Emirates Invoice Template, there are additional taxing options on the Taxes tab of the Settings window. The first is the option for choosing the number of tax items; you have 3 choices - no tax, one tax and two taxes. Secondly, you can set the names and rates in percentage for each tax, such as VAT, GST or PST, or simply Sales Tax. Thirdly, there are a group of checkbox options on the dialog box, including: "Tax invoice total including shipping cost", which adds the shipping cost to the taxable amount when checked; "Tax 2 is applied to tax 1", which adds the amount of "tax 1" to the taxable amount if checked; and "tax rate can be zero", which allows you to set any of the tax rates to be the value of zero. If you modify the options on this dialog box, the spreadsheet will be changed accordingly if needed.

Invoice Template VAT UKc4106

Invoice Template VAT UK

"Invoice Template VAT UK" was found to be relative to Create An Invoice Template with the score grade of 21.

...(12) For a detailed tutorial on adding custom fields, visit this simple example.

  1. Unprotect the worksheet.
  2. Right-click the cell for which you want to set its format, or drag your mouse to select multiple cells and right-click one of the selected cells, choose Format Cells command from the menu.
  3. On the Number tab, click "Currency" on the Category list.
  4. Choose "£ (United Kingdom)" from the Symbol list.
  5. Set the other options as required.
  6. Click OK to close the Format Cells dialog box.
  7. Protect the sheet.
  8. Save your template.

Simple Sample - Using Segoe Print Fontc5090

Simple Invoice Sample - Using Segoe Print Font

"Simple Invoice Sample - Using Segoe Print Font" was found to be relative to Create An Invoice Template with the score grade of 19.

...(32) The default invoice format shipped with Uniform Invoice Software installer program uses the default font of Excel. To make your business documents differ from others you can simply change the font face.

...(73) With this simple customization tutorial, we simply set its font face to Segoe Print font family, and by default with one tax, no tax column (all items are taxable). By making these easy and quick modifications to the standard template, it now has a completely different look & feel, as you can see from the screenshots here on InvoicingTemplate.com. Need more samples on customization? Start by searching and downloading our free invoice templates!

...(14) Let's see how this could be done with Uniform Invoice Software and Microsoft Excel.

Irish Sales VAT Invoice Templatec7024

Irish Sales VAT Invoice Template

"Irish Sales VAT Billing Form" was found to be relative to Create An Invoice Template with the score grade of 18.

...(180) As Irish Revenue states: Persons who issue invoices and credit notes, and persons to whom these documents are issued, should ensure that the documents accurately represent the transactions to which they refer. Failure to do so may have serious consequences for all parties concerned...... An accountable person who supplies taxable goods or services (other than construction services supplied under a relevant contract) is obliged to issue a VAT invoice. Value-Added Tax is a tax on consumer spending. It is collected by VAT-registered traders on their supplies of goods and services effected within the State, for consideration, to their customers. Generally, each such trader in the chain of supply from manufacturer through to retailer charges VAT on his or her sales and is entitled to deduct from this amount the VAT paid on his or her purchases. The effect of offsetting VAT on purchases against VAT on sales is to impose the tax on the added value at each stage of production – hence Value-Added Tax. For the final consumer, not being VAT-registered, VAT simply forms part of the purchase price.

Simple Invoice Sample - Sales Rep Name on Product Reportc5084

Simple Invoicing Sample - Sales Rep Name on Product Report

"Simple Invoice Sample - Sales Rep Name on Product Report" was found to be relative to Create An Invoice Template with the score grade of 12.

  1. Before doing any modifications to an existing template, as always you should first back up it. In this simple sample, we'll modify the database structure too. So you'll also have to make a backup copy of the database file. To do this, in Windows Explorer simply copy the template and database files.
  2. Open the invoice template.
  3. Click the Design Mode button on the "Invoice" ribbon tab.
  4. Choose a blank (not used) area. In this sample, we choose the range at O22:O33 and assign it a slightly different background color.
  5. Name the cells "oknItemSalesRep_1", "oknItemSalesRep_2", "oknItemSalesRep_3" ... "oknItemSalesRep_12", from top to bottom. That is, O22 is named "oknItemSalesRep_1", O23 is named "oknItemSalesRep_2" and so on.
  6. Create a formula for each of the cells. For the "oknItemSalesRep_1" cell, the formula should be "=IF(oknProductName_1="","",oknSalesRepName)", and for the "oknItemSalesRep_2" cell, the formula should be "=IF(oknProductName_2="","",oknSalesRepName)", and so on. These formulas check if the product name (the "Description" column) cells are blank, and if not, the formulas retrieve the content of the "oknSalesRepName" cell and fill it into the current cell. "oknSalesRepName" cell is an manually editable cell that supports the on-sheet picker feature supported by Uniform Invoice Software. When creating an invoice (see tutorial), if you click to select "oknSalesRepName" (at $F$19 in this sample) cell, an on-sheet button appears. Click this button to choose a sales representative name from the list.
  7. Click the "Design Mode" button on the "Invoice" ribbon tab to exit design mode. The spreadsheet is now in design mode that allows you to modify the locked contents.
  8. Click the "Invoices" button on the "Invoice" ribbon tab.
  9. Click "Custom Fields".
  10. On the "Custom Field Manager" dialog box, choose "Invoice Body" from the "Database table" list.
  11. Click "Add Field".
  12. On the "Add New Custom Field" dialog box, enter the new field name "ItemSalesRep", leave" the "Type" field as the default value "Text". In the "Size" box, fill in the max text length 50. Click OK to create the new field.
  13. Click "Close" to close the "Custom Field Manager" dialog box.
  14. Now switch to the "Product" worksheet. By default, it has the following columns: Product ID (cell name: oknRpProductID), Date (cell name: oknRpInvoiceDate), Invoice # (cell name: oknRpInvoiceID), Description (cell name: oknRpProductName), Quantity (cell name: oknRpQuantity), Price (cell name: oknRpPrice), Line Total (cell name: oknRpLineTotal), Unit Cost (cell name: oknRpCost).
  15. Click to select the "Unit Cost" cell.
  16. On Excel "Home" ribbon tab, click "Format Painter".
  17. Click the cell next to "Unit Cost" on the Product worksheet. This copies the format of the "Unit Cost" cell this the new (empty) cell ($J$10).
  18. Enter the column heading into $J$10 - in this case, "Sales Rep".
  19. Name the cell "oknRpItemSalesRep". Note in this name, "oknRp" is the name prefix that is used in each name on the "Product" report worksheet; and "ItemSalesRep" is the column / field name in the database definition.
  20. Save the template by clicking the "Save" button on Excel quick access toolbar.

Invoicing Format for Bakery and Cake Shopc4090

Invoicing Template for Bakery and Cake Shop

"Invoicing Format for Bakery and Cake Shop" was found to be relative to Create An Invoice Template with the score grade of 10.

...(52) Most templates here on InvoicingTemplate.com are formatted with cool color themes like green and blue, to meet the fact that invoices are business documents that must be accurate and strict. However a bakery or cake shop provides delicacies, such as cupcake, so we used a warm color theme with this form design.

...(63) With Uniform Invoice Software installed, to simplify invoice creation, you can use the "Product" database table and assign each product / item a shortcut code (the "Product ID" field). When creating invoices, you simply type in the item# into the cell to retrieve the full description and unit price, so that you don't have to type in the same text again and again.

Soccer Shop Invoice Templatecn009

Invoicing Form for Soccer Shop

"Invoicing Form for Soccer Shop" was found to be relative to Create An Invoice Template with the score grade of 8.

...(84) Clicking any cells within the "Bill To" section, a small rectangle button appears underneath the active cell, clicking that button shows a list of all customers you've invoiced for. Double-click a customer on the list, Uniform Invoice Software retrieves the customer information form the underlying Microsoft Access database (or SQL Server database, see UIS editions), and populates the cells within the "Bill To" section. This feature is called "on-sheet picker", which you can easily disable or enable using the button on the ribbon tab.

Singapore GST Invoice Template (Sales)c6021

Singapore GST Billing Format (Sales)

"Singapore GST Billing Format (Sales)" was found to be relative to Create An Invoice Template with the score grade of 6.

...(123) 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.

...(48) This invoicing form was designed as a sales invoice template and thus it includes the shipping address section. If you are a service provider that does not need the shipping address, a variant of this template is also here on InvoicingTemplate.com, at c6022 Singapore GST Invoice Template (Service).

Service Billing Template for Germanyc4099

Service Invoicing Template for Germany

"Service Billing Template for Germany" was found to be relative to Create An Invoice Template with the score grade of 2.

...(40) Here on InvoicingTemplate.com we adhere to a simple rule to distinguish sales vs. service - i.e. if the Excel spreadsheet template has the "Shipping Address" section, it is categorized as sales invoicing template; otherwise it is a service invoicing template.

...(24) Like the original template c4098 Sales Invoicing Format for Germany, this template has all the labels on the service invoicing form translated into German.

...(28) Like the original invoicing sample for Germany, this template also has all the static text labels translated into English, such as " Auftrag # Verkäufer-name Versanddatum Versandart Fälligkeitsdatum."

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c4036
South Africa Tax Invoice Template (Sales)
Saturday, August 1, 2015,
12
4
A4
Portrait
Sales
c4077
Recipient Created Tax Invoices Form
Monday, July 4, 2016,
8
4
A4
Portrait
Sales
c7011
Proforma (1st Sample of Customization)
Tuesday, October 29, 2013,
20
7
A4
Portrait
Pro-forma
c4108
Customization of Standard Fields
Thursday, March 30, 2017,
6
4
A4
Portrait
Sales
c5104
Law Firm Invoice Template
Thursday, November 24, 2016,
12
5
A4
Portrait
Service
c5071
Lightweight Service Invoice Template
Sunday, July 19, 2015,
16
5
A4
Portrait
Service
c7012
Proforma (2nd Sample of Customization)
Wednesday, October 30, 2013,
20
7
A4
Portrait
Pro-forma
c5077
Simple Template - Moving Shipping Address
Wednesday, February 3, 2016,
12
5
A4
Portrait
Service
c2037
Green Gradient Service Invoice
Sunday, April 9, 2017,
12
2
A4
Portrait
Service
c7002
Backorder Invoice Template
Monday, May 19, 2014,
12
7
A4
Portrait
Sales
c6026
Bill Sample in Estonian
Thursday, October 13, 2016,
17
6
A4
Portrait
Service
c5073
United Arab Emirates Invoice Template
Wednesday, August 26, 2015,
12
5
A4
Portrait
Sales
c4106
Invoice Template VAT UK
Tuesday, March 21, 2017,
12
4
A4
Portrait
Service
c5090
Simple Sample - Using Segoe Print Font
Monday, July 18, 2016,
12
5
A4
Portrait
Sales
c7024
Irish Sales VAT Invoice Template
Tuesday, August 25, 2015,
18
7
A4
Portrait
Sales
c5084
Simple Invoice Sample - Sales Rep Name on Product Report
Saturday, June 25, 2016,
12
5
A4
Portrait
Sales
c4090
Invoicing Format for Bakery and Cake Shop
Friday, October 21, 2016,
8
4
Letter (8-1/2 in. x 11 in.)
Portrait
Service
cn009
Soccer Shop Invoice Template
Monday, July 10, 2017,
12
x
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c6021
Singapore GST Invoice Template (Sales)
Sunday, August 23, 2015,
18
6
A4
Portrait
Sales
c4099
Service Billing Template for Germany
Monday, November 21, 2016,
12
4
A4
Portrait
Service

What Is Hot

Feature Galleries