Skip to main content
InvoicingTemplate.com main content

4-Column without Taxc4002

4-Column Invoice Template

"4-Column without Tax" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 94.

...(21) This is a variant of the invoice template with 4 columns. The template is set with no tax and shipping address.

...(87) If you have Uniform Invoice Software 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.

ABN Tax Invoicec7028

ABN Tax Invoice

"ABN Tax Invoice" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 94.

...(46) According to Australian Taxation Office, tax invoices for sales of $1,000 or more need to show the buyer's identity or ABN. These invoices are also called ABN tax invoices. This ABN tax invoice template include space for you to detail the ABN codes for your business.

...(40) If all your items are taxable or not taxable, you may not want to include the "Taxable" controls on the form. Don't worry. You can easily move ActiveX controls or Excel / Office form controls by following the steps below.

Excel Quotation Templatec9008

Excel Quotation Template

"Excel Quotation Template" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 89.

...(38) This free quotation and estimation template in Microsoft Excel ".xlsx" format provides a sample of customizing the default invoice template shipped with Uniform Invoice Software. It implements a special / complex discounting model to meet practical business requirements.

...(19) The value of the "Quantity" is calculated using an Excel formula like this, where "_?" is the line number:

...(23) "Unit Price" is a manually editable field. "Line Total" is also a calculated field, which looks like this (again, "_?" indicates line numbers):

...(15) The "LESS" is also a manually editable field, which is designed as a percentage value.

Jamaica Tax Invoice Templatec5072

Jamaica Tax Billing Format

"Jamaica Tax Invoice Template" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 88.

...(42) According to Tax Administration Jamaica (TAJ), all Registered Taxpayers must issue a Tax Invoice to all other Registered Taxpayers to whom taxable goods or services are supplied. Here we provide you with a ready-to-use Excel template that could simplify the invoice creations.

...(69) This template, Jamaica Tax Invoice Template, or Jamaica Tax Billing Format, was created with the above requirements in mind. In order to create this layout from the default template shipped with Uniform Invoice Software, we moved out the Product# (Item#) column from the detail section of the invoice form, and added a new column "Date Supplied", which is a custom field "DateSupplied" added to the "Invoice Body" database table.

Excel Payment Voucher Templatec5052

Payment Voucher Template

"Excel Payment Voucher Template" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 83.

...(131) In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Excel Payment Voucher Template. Note that if you have our invoicing program installed, and you are running Excel 2007, Excel 2010 and Excel 2013, it already provides a Design Mode button on the ribbon tab, so that you don't have to switch to design mode manually. Our invoicing software is able to turn a simple spreadsheet into a powerful invoicing system, with the ability to manage customers, products, bills and payments, it also includes various tools that could help you configure the layout of your form, such as the number of taxes and tax names and rates. If you don't have our invoicing program installed, here are how you can switch to design mode manually.

Recipient Created Tax Invoices Formc4077

Recipient Created Tax Invoices Form

"Recipient Created Tax Invoices Form" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 80.

...(40) In Australia tax invoices are usually issued by the supplier or seller. However Australian Taxation Office also allows the purchaser or recipient of the goods or services to issue tax invoice for the purchases, knowns as recipient-created tax invoices (RCTI).

...(58) As you can see, while PDF formatted documents has advantages in the business world, on creating invoices Excel formatted invoice template is much easier and saves time by doing automated calculations using formulas. And, with Uniform Invoice Software, you can simply click the "Extract/Email" button within the Excel spreadsheet to send PDF invoices using email in electronic format.

Blank Sales Invoice Layout (Two-tax)c2020

Blank Sales Invoice Sample (Two-tax)

"Blank Sales Invoice Layout (Two-tax)" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 68.

...(36) This two taxes invoice sample was created based on c2019 Blank Sales Invoice Format (One-tax). This customized template has similar layout as the original version, but differs from the original in that it has two taxes.

...(75) All templates that work with Uniform Invoice Software should be protected. This is highly recommended because without the protection, it is very easy to overwrite the static text labels (such as your company name, the column headings etc.) For this reason, Uniform Invoice Software even prompts on closing a template - if a template is not protected and you try to close it, it will prompt and ask you whether you want to protect it.

...(23) The default sales invoice template shipped with Uniform Invoice Software also has two taxes set by default, which are named GST and PST.

Mixed Tax Rates (5 Columns)c5034

Mixed Tax Rates (5 Columns)

"Mixed Tax Rates (5 Columns)" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 65.

...(252) To adjust the existing columns to leave space for new column or columns that will be added to the printable form for Mixed Tax Rates (5 Columns), we first unmerge the item# (or product#), description and quantity columns - these are usually merged columns that each contains several Excel raw columns. To do this, after opening Mixed Tax Rates (5 Columns) as usual, select all the cells belong to these columns and then click the "Merge and Center" button on the Format toolbar in Excel 2003; in Excel 2003, the "Merge and Center" button can be found on the Home ribbon tab. Drag your mouse to select the Description column (this time, you select Excel raw column since the Description is no longer a merged column) and drag it one column left. Select the "oknProductName_1" cell (the first cell on the moved Description column) and drag your mouse to select the two adjacent cells at the right-hand too - so, you now select 3 cells started with the "oknProductName_1" cell. Now click the Merge and Center command again. This will expand the width of "oknProductName_1" to 3 columns. Do this process for all the other Description cells. Once done, you have one empty column that was left by moving the Description column to the left-hand of this original position. Adjust the columns widths of all the columns to make sure they have the proper widths that are able to hold the content they will display on this Mixed Tax Rates (5 Columns).

Hotel Receipt Format with Blue Gradient Designc7027

Hotel Receipt with Blue Gradient Bar

"Hotel Receipt Format with Blue Gradient Design" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 63.

...(38) The design of this receipt template is based on is based on c7005 Hotel Receipt Template. This revised edition includes basically the same fields as the original design, but added several blue gradient elements to make it beautiful.

...(12) So to create this blue gradient bar, we followed the steps below.

...(39) This revised version does not change the column definitions of the original receipt template. There are still 7 columns on the form - "Room #", "Name", "Check in", "Check out", "# of Nights", "Price / Night" and "Line Total".

House Rent Receipt Templatec1002

House Rent Receipt Template

"House Rent Receipt Form" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 60.

...(36)House Rent Receipt Template in Excel spreadsheet ".xls" format provides a blank and printable house rent receipt form for you to create house rental receipts. It is also a sample of customizing our free invoicing templates.

...(62) This rent receipt template is one of our sales receipt examples created from the default sales invoice template shipped with Uniform Invoice Software. If you receive payments from tenant daily / monthly / yearly for the fee that have to pay and need to draft receipts, or are just looking for how to draft your receipts, this could be a great help.

Simple Template with Printable Watermarkc4075

Simple Format with Printable Background Image

"Simple Format with Printable Background Image" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 51.

...(35) Adding a background image or watermark can be an attractive and appealing enhancement, especially for business documents like invoices. This Simple Invoice Template with Printable Background Watermark demonstrates how to accomplish this in Microsoft Excel.

  1. As always before customizing a template you first need to back up it. To do this, simply copy the Excel template file in Windows Explorer.

    With Uniform Invoice Software installed, it is recommended to run the template in protected mode (by clicking Excel ribbon Review tab, and then click the "Protect Sheet" command, or go to the "Invoice" ribbon tab and make sure "Design Mode" is not enabled).

  2. In this sample, we need to change the design of the template. So click the "Design Mode" button on the "Invoice" worksheet to unprotect the sheet, display gridlines and row/column headings.
  3. Go to Excel "Page Layout" ribbon tab, click the expand button in the "Page Setup" group. This opens the "Page Setup" dialog box.
  4. Go to the "Header / Footer" tab.
  5. Click "Custom Header", or "Custom Footer", depending on whether you want to lay out the image from top or bottom. In this sample, we choose "Custom Header".
  6. Choose a section to place the image - "left section", "center section" or "right section". In this case, we click and choose "Center section".
  7. Click the "Insert Picture" button on the toolbar.
  8. Browse to and pick up your picture or watermark image from locally store, or download it online.
  9. The section now has a "&[Picture]" placeholder symbol. Click to select it, and then click "Format Picture" command on the toolbar (the last one).
  10. The "Format Picture" dialog box appears. Here you can set the size, scale ratio, cropping, color (automatic, grayscale, black & white and washout), brightness and contrast of the image.
  11. Once you have set the options done, click the dialog boxes.
  12. Go to Excel menu File / Print, you can see that the background image on the printed invoices (see screenshot images below). The background image / watermark will also be included in PDF invoices.
  13. To finish your design job, click the "Design Mode" button on the "Invoice" ribbon tab. Click the Save button on Excel quick access toolbar to persevere the changes.

2-Page Invoice Templatec5081

2-Page Invoicing Format

"2-Page Invoice Template" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 48.

...(25) The default template has 12 lines on one page. This sample template shows you a customized invoice layout that has 36 lines on two pages.

...(124) This invoice template is based on the default invoice template shipped with Uniform Invoice Software, which is our desktop invoice software which runs offline (without the requirement of an online Internet connection). This template includes 36 lines on the invoice body section, and is printable with 2 pages of standard 8.5 X 11 inch letter paper. This invoicing format is a "Sales Invoice Template", as it contains the "Shipping Address" section, it also added 3 custom fields on the bottom of the form to calculate labor hours and expense. The template shows only one tax on the bottom of the form - to change this tax option / layout, go to Uniform Invoice Software Settings window / Taxes tab and set your preferences easily.

Bill Format for Lamp / Lighting Businessc6027

Bill Format for Lamp / Lighting Business

"Bill Format for Lamp / Lighting Business" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 47.

...(32) For business who are specialists in lamps, bulbs and tubes for many hi-tech and specialized applications, this invoicing format might be helpful. This layout is printable with A4 paper in landscape orientation.

...(64) This sample is designed as a sales invoice template, so it includes the shipping address section where you can specify where the goods will be sent to. Note that the "Same As Bill To" button that we usually put near the "Ship To" section does not work for this template, as the "Bill To" section uses custom fields for address and postal code information.

Proforma Invoice Formatc7010

Proforma Invoicing Form

"Proforma Invoice Template" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 45.

...(35) This simple but useful Proforma Invoice Template help you, as a supplier that is trading across countries, create professional and beautiful proforma invoices required by the buyer in advance of providing the goods or service.

...(122) A proforma invoice is a quote in an invoice format that may be required by the buyer to apply for an import license, contract for pre-shipment inspection, open a letter of credit or arrange for transfer of hard currency. A proforma may not be a required shipping document, but it can provide detailed information that buyers need in order to legally import the product. If you are a small business that is not ready for an expensive and complete invoicing system, then InvoicingTemplate.com offers you this free Proforma Invoice Template for free. Once you are ready to do an upgrade, our fully featured invoicing program, Uniform Invoice Software, is able to turn your simple Excel invoice template into a powerful invoicing program.

Sales Invoice with Profit Calculationc5060

Sales Invoice with Profit Calculation

"Sales Invoicing Template with Profit Calculation" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 37.

...(38) This sales invoice template produces exactly the same printed invoices as the default sales invoice template that is included in the Uniform Invoice Software installer program. The main difference is that this template support the calculation of profit.

...(38) The magic of adding profit calculation depends on a powerful feature supported by all editions of Uniform Invoice Software - Uniform Invoice Software Standard, Uniform Invoice Software Net and Uniform Invoice Software Enterprise, which is called custom fields.

...(78) The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Sales Invoice with Profit Calculation without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

5.5 Inch X 8.5 Inch - 2 Invoices On One Templatec4067

Duplicate 5.5 X 8.5 Invoices per Page

"Duplicate 5.5 X 8.5 Invoices per Page" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 37.

...(38) In this simple invoicing template sample for Microsoft Excel we demonstrates how to customize the previous sample c4066 so that it prints two 5.5 inch X 8.5 inch invoices on a single 8.5 inch X 11 inch paper.

  1. Backup the template. This gives you an easy way to return to a working state if anything goes wrong during the customization. To do this, simple copy the template (xlsx format) in Windows Explorer.
  2. Open the template as usual.
  3. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon. The "Invoice" ribbon tab was created by UIS. If you cannot find this ribbon tab in your Microsoft Excel, make sure you have UIS installed.
  4. Drag your mouse on the row headings on all the rows that comprise the exiting invoicing form. In this case, we select row 2 to row 39. Note you need to select the row heading to select the entire rows, instead of highlighting any single cells.
  5. Press CTRL + C keywords on your keyboard to copy the selected rows to clipboard.
  6. Right-click to select the row heading of the first row where the duplicate copy will start. In this case, we choose the row 47. Choose "Paste" from the shortcut menu. This create a duplicate copy of the selected invoicing format on the location starting from row 47. The cells inside the duplicate copy have exactly the same format and value as what inside the original format. However the content of the cells in the duplication are all "Values", which means they will not change when the original invoicing form changes - for example, when you are creating a new invoice. We'll fix this by pasting links.
  7. Drag your mouse to select the date and "invoice#" cells in the original invoicing form. Note you need to select the cells that will change its content when you are creating invoices. In this example, K4 (the Invoice# cell), K5 (the invocie date cell). It is not necessary to select those label cells that will not be changed, for example J4 (text "DATE:"), J5 (text "INVOICE#:").
  8. Right-click one of the selected cell and choose "Copy".
  9. Click to select the corresponding cells inside the duplicate area. In this case, we select K49 and K50.
  10. Go to Excel "Home" ribbon tab. Pull down the "Paste" command group, and then choose "Paste Links" from the "Other Paste Options" group. This commands assigns formulas to the cells on the duplicate copy, so that they show the values from the corresponding cells inside the original copy. For example, Excel creates a formula for the K49 cell, as "=K4"; and for the K50 cell, the formula is "=K5".
  11. Repeat the above steps on all the field cells that change their values when you creating an invoice. In this sample, you should execute the "Copy-Paste" process:
    • once for the cells inside the "Bill To" section (target address: F54:F58)
    • once for the cells inside the "Ship To" section (target address: J54:J58)
    • once for the cells under the label "P.O.#" , "Sales Rep. Name", "Ship Date", "Ship Method", "Terms" and "Due Date" (target address: D64:K64)
    • once for all the cells on the "InvBdy" ("Description" column, "Quantity" column, "Unit Price" column, "Line Total" column) (target address: D67:K70)
    • Once for the cells on the summary section, from "Discount (Amount)" to "Total" (target address: I80:K84).
    • Once for the "Notes" field (target address: K82).
  12. Now drag your mouse to select all the cells inside the duplicate form. In this case, it is D47:K84.
  13. Right-click one of the selected cell, choose "Format Cells" from the shortcut menu. On the "Protection" tab, make sure "Lock" is checked. Click OK. This makes the entire duplicate form not manually editable - they will be filled with Excel formulas.
  14. Select both forms. In this case, the cells ranging from D2 to K84.
  15. Go to Excel "Page Layout" ribbon tab, choose "Print Area" and then "Set Print Area" from the "Page Setup" group. This tell Excel what to print when you execute the Print command.
  16. Go to Excel menu "File" and then choose "Print". Make sure the entire print area could be printed on a single page. If not, adjust the lines heights. In this sample, we already make sure the original format occupies only half of the paper size, so there will be no problem to print two duplicate invoices on a single page.
  17. Optional - You can also add a cut-off rule between the two invoicing forms. To do this, go to Excel "Insert" ribbon tab, from the "Illustrations" group choose "Shapes" and then the first line shape on the "Lines" group.
  18. Push down SHIFT key on keyboard and draw the line between the two invoicing forms - in this case, row 46. By pushing down the SHIFT key, you make sure the line will be exactly vertical or horizontal (not an oblique line).
  19. Using the "Drawing Tools / Format" ribbon tab, set the style, color of the cut-off rule. In this sample, we set it to be a gray dash dot line (see screenshots).
  20. In this sample, we also make sure the two copies of invoices will be printed on the center of the paper, by checking the "Center on page: Horizontally, Vertically" options on the "Margins" tab of the "Page Setup" dialog box.
  21. To adjust the space between to duplicate invoices, adjust the height of the empty row (row 46) between to invoicing forms.
  22. Once done, exit design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.
  23. Save the template by clicking the "Save" command on Excel quick access toolbar.

Bill Format for Quilting Servicec5095

Invoicing Sample for Quilting Service

"Invoicing Sample for Quilting Service" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 32.

...(31) This sample template designed for quilting service providers has added a number of custom fields added to the form suggested by one of our clients who provides long arm quilting service.

...(87) The first two custom fields are "Batting Backing Allowance" and "Tag Color", which are all defined as text fields. Most other custom fields above the invoice detail section are defined as decimal values. The values in this section are formatted with two colors - the green values are in Inch, and red values are in Feet. Only the values in the "Quit Size" section are editable (quit width and height), all the other values - Quilt Area, Binding, Batting and Backing, are all calculated automatically using Excel.

Simple Service Invoice Templatec4033

Simple Service Billing Format

"Simple Service Billing Format" was found to be relative to Tax Invoice Template Excel Malaysia with the score grade of 8.

...(70) Note that custom fields is a powerful feature introduced by previous version of Uniform Invoice Software (UIS), i.e. Excel Invoice Manager. The support for custom fields in Excel Invoice Manager requires a database definition file ("FDINFO10.rst") to be present in the folder where the database file was installed. With UIS, using custom fields is much simpler than in Excel Invoice Manager, and the database definition file is no longer required.

...(22) Once you have finished your design work for Simple Service Invoice Template, click the Design Mode button again to exit design mode.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c4002
4-Column without Tax
Saturday, November 2, 2013,
12
4
A4
Portrait
Service
c7028
ABN Tax Invoice
Sunday, July 3, 2016,
17
7
A4
Portrait
Sales
c9008
Excel Quotation Template
Friday, February 10, 2017,
37
9
A4
Portrait
Other
c5072
Jamaica Tax Invoice Template
Monday, August 3, 2015,
12
5
A4
Portrait
Sales
c5052
Excel Payment Voucher Template
Thursday, May 29, 2014,
12
5
A4
Portrait
Receipt
c4077
Recipient Created Tax Invoices Form
Monday, July 4, 2016,
8
4
A4
Portrait
Sales
c2020
Blank Sales Invoice Layout (Two-tax)
Sunday, November 22, 2015,
12
2
A4
Portrait
Sales
c5034
Mixed Tax Rates (5 Columns)
Sunday, November 24, 2013,
12
5
A4
Portrait
Sales
c7027
Hotel Receipt Format with Blue Gradient Design
Wednesday, June 29, 2016,
12
7
A4
Portrait
Receipt
c1002
House Rent Receipt Template
Sunday, January 19, 2014,
16
1
A4
Portrait
Receipt
c4075
Simple Template with Printable Watermark
Tuesday, June 28, 2016,
20
4
A4
Portrait
Sales
c5081
2-Page Invoice Template
Wednesday, March 2, 2016,
36
5
Letter (8-1/2 in. x 11 in.)
Portrait
Sales
c6027
Bill Format for Lamp / Lighting Business
Sunday, October 16, 2016,
12
6
A4
Landscape
Sales
c7010
Proforma Invoice Format
Saturday, October 26, 2013,
20
7
A4
Portrait
Pro-forma
c5060
Sales Invoice with Profit Calculation
Saturday, September 20, 2014,
12
5
A4
Portrait
Sales
c4067
5.5 Inch X 8.5 Inch - 2 Invoices On One Template
Tuesday, March 1, 2016,
4
4
Letter (8-1/2 in. x 11 in.)
Portrait
Sales
c5095
Bill Format for Quilting Service
Friday, October 14, 2016,
12
5
A4
Portrait
Service
c4033
Simple Service Invoice Template
Wednesday, November 12, 2014,
6
4
A4
Portrait
Service

What Is Hot

Feature Galleries