Openoffice Form Templates Spreadsheet

1. Commercial Template Sample - Adding Insurance Cost Field

"Commercial Template Sample - Adding Insurance Cost Field" was found to be relative to Openoffice Form Templates Spreadsheet with the score grade of 92.

(From Detail Page - about 29 words) - With the previous FedEx style commercial invoice samples the insurance cost and currency symbol fields were missed. This template shows how to add it onto the printable commercial form.

(From Detail Page - about 79 words) - Some of the commercial and proforma invoice templates here on InvoicingTemplate.com already contain the insurance cost field, for example in Commercial Invoice Template (UPS Style) the insurance cost field was located near the bottom of the form, above the "Other" field; Simple Proforma Invoice Template has this field too. For the list of all the commercial and proforma templates here on InvoicingTemplate.com, visit Pro forma and Commercial Invoice Template. On the DHL style template, you'll find these fields too.

(From Detail Page - about 46 words) - These fields - insurance and currency code, provides important information regarding the international shipping / freight and international trading. If you have looked at Commercial Template Sample - Complete Incoterms Rules, you may notice that many Incoterms rules specify how the insurance cost will be handled.

(From Detail Page - about 19 words) - However in this serial of FedEx style Excel-format blank commercial templates they are missed. So how we add them?

(From Detail Page - about 113 words) - c9006 - Commercial Template Sample - Adding Insurance Cost Field (Commercial Template Format - Adding Insurance Cost Field) is one of the templates in the serial Commercial Invoices (FedEx). As of Dec/26/2015, there are 5 template(s) in this serial. For the basic version of blank FedEx format commercial invoice sample, see Commercial Invoice - FedEx Style. For the version of blank FedEx format commercial invoice sample that is printable with landscape paper orientation, see Commercial Invoice - FedEx Style (Landscape). For the version that includes payment method checkboxes, see Commercial Template Sample - Using Payment Method Checkboxes. For the version that includes complete Incoterms option, see Commercial Template Sample - Complete Incoterms Option.

LEARN MORE PDF

2. Basic Blank Service Bill Format (Two-taxes, Long Description)

"Basic Blank Service Bill Layout (Two-taxes, Long Description)" was found to be relative to Openoffice Form Templates Spreadsheet with the score grade of 91.

(From Detail Page - about 35 words) - This is a free basic service template that includes only general fields common and required to almost all invoices. The blank invoicing form contains no sample data. It calculates two taxes automatically using Excel formulas.

(From Detail Page - about 100 words) - There are already a number of templates in this basic blank service invoice template serial published here on InvoicingTemplate.com. The first and the basic one, Basic Blank Service Format (No-tax), and based on that we designed Basic Blank Service Invoice Format (One-tax) and Basic Blank Service Invoice Format (Two-taxes). For those who service businesses that prefer less lines and long descriptions, we released Basic Blank Service Billing Format (No-tax, Long Description) and Basic Blank Service Invoicing Format (One-tax, Long Description). If you are looking invoice template in OpenOffice.org format, the easy way is to search on their Apache OpenOffice Templates.

(From Detail Page - about 221 words) - As a general and basic service invoice template, it could be used by many service businesses. There are many different types of service businesses. A service business is a business that sells services directly to consumers or other businesses. The service sector is active all over the world, and many people have interactions with such businesses on a daily basis. Companies can also have subdivisions that offer services; a computer company, for example, may have a service arm that provides support to its users. Services are intangible in nature, only appearing when required by the consumer, which makes the nature of this type of business very different from that of others. Some examples include the hospitality sector, consulting, appliance repair, computer support, health care, utilities, business services, real estate, legal services, and education. In all of these cases, people are being provided with a service, not a product, whether they are receiving treatment for a medical problem or learning in an elementary school classroom. At InvoicingTemplate.com, the two main categories of our invoicing templates are Sales Invoicing Template and Service Invoicing Template. The major difference between the two categories is that the invoice templates in the "Sales" category contains a "Shipping Address" section. No matter what service business you are in, Uniform Invoice Software could help you on processing your invoices.

LEARN MORE PDF

3. Basic Service Invoice Sample with Deposit

"Simple Service Invoicing Template with Deposit" was found to be relative to Openoffice Form Templates Spreadsheet with the score grade of 90.

(From Detail Page - about 33 words) - Large number businesses ask their clients to deposit a percentage of total amount as advance payment. This basic service invoice template with deposit deduction helps you create deposit invoices with easy and quick.

(From Detail Page - about 117 words) - While the default template comes with Uniform Invoice Software, which is our Microsoft Excel-based invoicing software program, already support dawn payment and security deposit, this feature is not specially documented (or many users simplify overlook this layout. With Uniform Invoice Software, each invoice / receipt can have several payments posted to it. When you click the "Save Invoice" button on the task pane, it not only generates a new invoice# for you automatically, there is also a "New Payment" window appears that allows you to save deposit or advance payment, including payment details like Payment Date, Total Payment, Payment Type, Reference Document#, as well as a fillable "Notes" field where you can fill in any additional information.

(From Detail Page - about 110 words) - With Uniform Invoice Software, if an invoice / receipt is overpaid then the overpaid amount becomes "credit" under the customer's account. The credit amount can then be applied to other invoices as payment. We've already published template for creating credit note (credit memo) here on InvoicingTemplate.com, at Free Credit Memo Template, or Service Credit Note Template, or Debit Note Template. If you prefer to take the security deposit or advance payment based on the percentage of the total receipt / invoice amount, such as for car rental / house rental / freelance design work / website development job, here is the template you can try at Advance Payment Invoicing Template.

...(112)...

(From Detail Page - about 205 words) - However one of the disadvantages of using a separate "New Payment" window is that, the options is not so obvious (you need to click the "Save Invoice" button). Sometimes you simply need to enter the payment method and payment amount, according to the agreement between you and the client, but don't really care about the other details about the payment, nor the "Payment Report" either. So in this sample invoice template with deposit, we'll add a new "Deposit" field and the original "Balance Due" cells back into the printable form, the later field was moved out in the sample c5075 Simple Sample - Moving Balance and Payment Cells. This time, we'll create a service invoice template, using the billing format / receipt format created in c5077 Simple Template - Moving Shipping Address as a starting point of the customization. To add a little detail to the deposit payment, we'll create and use another custom field called "Deposit Payment Method", to let you enter payment method information like cash, check, wire transfer or bank transfer etc. For a simple and quick tutorial on how to add / use custom fields (i.e. user-defined fields) in your bill format, visit c4051 Simple Invoice Template - Discount Amount Field.

1. First, back up the template and database file. In this customization of the invoice / receipt template, we'll need to modify the database to add the custom fields. Even you are very familiar with Uniform Invoice Software and know exactly what to do, it is still recommended that you back up the template and database file before customizing it.
2. Open the template as usual.
3. Click the "Design Mode" button on the "Invoice" worksheet. This switch the Excel worksheet into design mode, and also shows the gridlines and row / column headings.
4. Click the cell where you want to put the "Deposit" field (In this case, $K$40). Name the cell "oknDeposit".
5. Click and select the cell to the left of "oknDeposit", i.e. $J$40, enter the text label "Deposit".
6. Click the cell at $I$40 and name this cell "oknDepositPaymentMethod".
7. Enter the label "Deposit Payment Method" for the field "oknDepositPaymentMethod" at $H$40.
8. Push down CTRL key on your keyboard, click the cells "oknDepositPaymentMethod" ($I$40) and "oknDeposit" ($K$40) respectively without releasing the CTRL key. Right-click on of the selected key and choose "Format Cells from the shortcut menu.
9. Choose "Format Cells". This shows the "Format Cells" dialog box.
10. Go the "Protection" tab and clear the "Locked" property. Click OK to close the "Format Cells" dialog box.
11. Select the name "oknPayments" from the name drop down list on the left-side of the formula bar. Excel selects the cell named "oknPayments" on the spreadsheet for you ($B$39).
12. With the "oknPayments" ($B$39) cell still selected, drag the border of the selection box to move it into the printable area. In this sample, we put the "oknPayments" cell underneath the "Total" cell, at $K$90.
13. Create the text label for this cell at $J$39 "Paid".
14. Drag your mouse to select both the text label "Total Due" and its corresponding field at $P$40:$Q$40. Drag the border of the selected area to move it to the destination location $J41:$K41 in the printable area.
15. Click to select the cell at $H$40, and the text label "Deposit Payment Method".
16. Fine-tune the text colors, cell borders and fonts as you needed.
17. Modify the formula of the "Total" cell, so that it becomes "=ROUND(oknSubTotal + oknShippingCost - oknDeposit+ IF(oknTaxType=0,0,IF(oknTaxType=1,oknTax1,oknTax1+oknTax2)),2)". As this shows, we are deducting the deposit amount from the total payable amount.
18. Click "Design Mode" on the "Invoice" ribbon tab to exit design mode.
19. Click the "Invoices" button on the "Invoice" ribbon tab to open the data list window.
20. Click "Custom Fields" on the toolbar.
21. Click "Add Field".
22. Fill in the definition for the deposit field: Name - "Deposit"; Type - Decimal; Precision - 8; Scale - 2. Click OK to have Uniform Invoice Software creates the custom field for you.
23. Click "Add Field" again.
24. Fill the definition for the deposit payment method field: Name - "DepositPaymentMethod"; Type - Text; Size - 50 (meaning you are able to store up to 50 characters in this field). Click OK to have Uniform Invoice Software create the field for you.
25. Close the dialog boxes and return to the Excel invoice form.
26. Save the template by clicking the "Save" button on Excel quick access toolbar.

...(132)...

(From Detail Page - about 109 words) - This template "c5078 Basic Service Invoice Sample with Deposit" does not modify the taxing features defined by the based template. So like the origin one, it has two taxes, GST and PST on the bottom of the form. To change this, click the Settings button, and then go to the "Taxes" tab. For a sample on how to add the deposit to the Sales Report, refer to c4055 Simple Invoice Template - Discount Amount on Sales Report. If you would like to create a selectable drop-down list for the newly added payment method field, visit the sample and tutorial at c4062 Simple Tax Invoice Sample with Tax Rate List.

LEARN MORE PDF

4. Blank Sales Format (No-tax)

"Blank Sales Sample (No-tax)" was found to be relative to Openoffice Form Templates Spreadsheet with the score grade of 89.

(From Detail Page - about 30 words) - Blank Sales Format (No-tax) is a free sales invoicing template that includes a shipping / delivery address section, two editable columns (description and amount). This sample includes no tax cells.

...(191)...

(From Detail Page - about 96 words) - We've already released a number of samples in the sales invoice template category. For example, some of the most popular titles are - Simple Sales Invoice Template; Sample Sales Invoice Template: Fixed Items - which shows you how to make one or several items fixed (being static) on the invoice detail (invoice body) section, so that they will not change from invoice to invoice; Sales Invoice Template with Discount Percentage Column, Netherland (NZ) Sales Invoice Template. A general purpose sales invoice template could also be found on office-kit.com, at Download the Free Invoice Template for Excel.

(From Detail Page - about 143 words) - c2018 - Blank Sales Format (No-tax) (Blank Sales Sample (No-tax)) is one of the templates in the serial Blank Sales Invoicing Templates. As of Dec/07/2015, there are 6 template(s) in this serial. For a version that has one tax and shows all lines on the invoice body, see Blank Sales Invoice Sample (One-tax). For a version that has two taxes and shows all lines on the invoice body, see Blank Sales Invoice Layout (Two-tax). For a version that has no taxes and shows 6 lines on the invoice body, see Blank Sales Billing Format (No-tax, Long Description). For a version that has one tax and shows 6 lines on the invoice body, see Blank Sales Invoicing Sample (One-tax, Long Description). For a version that has two taxes and shows 6 lines on the invoice body, see Blank Sales Invoicing Sample (Two-tax, Long Description).

(From Detail Page - about 152 words) - Since our templates are in Microsoft Excel spreadsheet format (most of them are xlsx format). It is easy to do calculation using Excel formulas. This is one of the big advantages of Excel formatted template. If you try to design an invoice template in Word format, doing calculations will not as easy as it is in Excel. If you prefer OpenOffice.org, another popular office / productive system, they also have a number of sales invoice template sample. For example, with this sample template - Blank Sales Format (No-tax), we use Excel formulas for calculating subtotal and total. Note that with the default implementation, the "Payments" and "Balance Due" fields are put inside the Print_Area - the area that will be printed when you click the Print command in Uniform Invoice Software, or click Excel's own Print command. By utilizing the Print_Area name, we make this template more printer-friendly - and more printable.

(From Detail Page - about 62 words) - A free template will not do as much as a complete accounting or bookkeeping system does, but it does produce professional invoices, and sometimes even better than some commercial billing program. All template here on InvoicingTemplate.com are free, including those templates that are in Adobe PDF format. Feel free to browse our categories and download the one that meets your business requirements.

LEARN MORE PDF

5. Advance Payment Invoicing Format

"Advance Payment Invoicing Format" was found to be relative to Openoffice Form Templates Spreadsheet with the score grade of 75.

(From Detail Page - about 36 words) - If your business requires a percentage of the cost has been paid before the service or product delivery, then this Advance Payment Invoicing Format might be your choice. This form is printable on standard A4 paper.

...(57)...

(From Detail Page - about 87 words) - This template, Advance Payment Invoicing Format, differs from the original design in that it adds two new cells, "Advance Payment %" and "Advance Payment Amount" to the bottom of the invoice spreadsheet. The first cell "Advance Payment %" is a manually editable cell (that is, it is unlocked), where you enter the percentage of the advance payment. The second cell, "Advance Payment Amount" is calculated automatically based on the total payable and advance payment percentage. The advance payment amount is then deducted from the invoice balance due.

(From Detail Page - about 110 words) - 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 Advance Payment Invoicing Format without writing one line of programming code. For example, in this tax invoicing template named Mixed Tax Rates in an Invoice, we implement the support of mixed tax rates in the same invoice by using custom fields. The result of the customization is offered in two editions, as what we do to all the other templates available here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with Uniform Invoice Software installed.

(From Detail Page - about 71 words) - Note that custom fields is a powerful feature introduced by previous version of Uniform Invoice Software, 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 Uniform Invoice Software, using custom fields is much simpler than in Excel Invoice Manager, and the database definition file is no longer required.

...(163)...

(From Detail Page - about 106 words) - The design of Advance Payment Billing Format also takes advantages of Excel formulas. By using Excel formulas, we are able to create the relationship between Excel cells that are mapped to database fields in Uniform Invoice Software. This gives Uniform Invoice Software unusual flexibility that supports not only simple and regular invoicing and billing forms, but also complex layouts and formats that are required in many business practices. With the Excel-formatted spreadsheet forms, we are able to design invoices that are beautiful and professional. With the database connected via Uniform Invoice Software, your invoicing system will be able to manage customers, products, invoices and payments easily.

(From Detail Page - about 86 words) - For example, the invoice template at Sample Sales Invoice Template: Fixed Items locks the first item on the detail section of the printable invoicing form. Which means that, the first line (the description) will not be changed from invoice to invoice. In fact, all template here on InvoicingTemplate.com are created based on the default sales invoice template shipped with Uniform Invoice Software. Please refer to the "Customizing Invoice Template" chapter of Uniform Invoice Software help file for more information on how to customize our invoice templates.

LEARN MORE PDF

6. Commercial Template Sample - Complete Incoterms Option

"Commercial Template Sample - Complete Incoterms Option" was found to be relative to Openoffice Form Templates Spreadsheet with the score grade of 70.

...(29)...

(From Detail Page - about 230 words) - As detailed on export.gov, "The term, Incoterms®, is an abbreviation for International Commercial Terms. They are a set of rules which define the responsibilities of sellers and buyers for the delivery of goods under sales contracts for domestic and international trade." With the previous implementations of blank commercial invoice templates (FedEx style), terms of Sale (Incoterms) was limited to 3 options on the printable form - FOB (Free On Board - risk pass to buyer including payment of all transportation and insurance cost once delivered on board the ship by the seller. Used for sea or inland waterway transportation), C&F (Cost and Freight - CFR, Title, risk and insurance cost pass to buyer when delivered on board the ship by seller who pays the transportation cost to the destination port. Used for sea or inland waterway transportation) and CIF (Cost Insurance and Freight - Title and risk pass to buyer when delivered on board the ship by seller who pays transportation and insurance cost to destination port. Used for sea or inland waterway transportation). These options are implemented as checkbox on the bottom of the form. All the 3 options are rules for sea and inland waterway transport. Effective January 2010, the ICC once again updated Incoterms (see Incoterms 2010) to follow the modern trends in international trade. The number of Incoterms® rules has been reduced from 13 to 11.

(From Detail Page - about 114 words) - c9005 - Commercial Template Sample - Complete Incoterms Option (Commercial Template Format - Complete Incoterms Option) is one of the templates in the serial Commercial Invoices (FedEx). As of Dec/26/2015, there are 5 template(s) in this serial. For the basic version of blank FedEx format commercial invoice sample, see Commercial Invoice - FedEx Style. For the version of blank FedEx format commercial invoice sample that is printable with landscape paper orientation, see Commercial Invoice - FedEx Style (Landscape). For the version that includes payment method checkboxes, see Commercial Template Sample - Using Payment Method Checkboxes. For the version that includes insurance and currency symbol options, see Commercial Template Sample - Adding Insurance Cost Field.

...(106)...

...(98)...

(From Detail Page - about 41 words) - First, open your commercial invoice template. Make sure the "Invoice" worksheet is active (the current sheet). Push down the "Design Mode" button on the "Invoice" ribbon tab (If you don't see this tab, make sure you have Uniform Invoice Software installed).

(From Detail Page - about 29 words) - Second, choose a cell to place the Incoterms field. In this sample, we choose the range P38:P41. Clear the existing content / checkboxes. Name the "oknINCOTERM" and unlock it.

...(85)...

(From Detail Page - about 92 words) - Fourth, create the dropdown list by using Excel data validation. Select the "oknIncoterm" cell. Click Excel command on the ribbon: Data, Data Validation, and then Data Validation again. On the "Data Validation" dialog box, choose "List" from the "Allow" box, and then click the "Source" field, enter the range of the source - in this sample, it is "$W$4:$W$14". There are other options you can set on this dialog box too, for example you can specify the error message to show if a user entered an incorrect value. Once finished, click OK.

(From Detail Page - about 24 words) - Now if you click the "oknIncoterm" cell, a dropdown list mark appears. Click it to choose your Incoterms option for your next commercial invoice!

LEARN MORE PDF

7. Australian GST Invoice Template

"Australian GST Invoice Template" was found to be relative to Openoffice Form Templates Spreadsheet with the score grade of 67.

(From Detail Page - about 34 words) - Australian GST Invoice Template is a sample of customization of the default sales invoice template. Australian GST Invoice Template implements the invoice layout and form according to Australian Government / Australian Taxation Office requirements.

(From Detail Page - about 68 words) - Australian GST Invoice Template was designed according to the guidelines of Australian Taxation Office "How to set out tax invoices and invoices (NAT 11675)". While this is sample invoice template, like all the other blank invoice templates available here on InvoicingTemplate.com, is also created from the default sales invoice template shipped with Uniform Invoice Software, we've customize the template to meet the standards recommended by Australian Taxation Office.

(From Detail Page - about 109 words) - Why standardize the way tax invoices and invoices are set out? As Australian Taxation Office stated, the voluntary standards have been developed in consultation with small business, in response to feedback about their frustration with inconsistent tax invoice and invoice formats. The standards will help achieve greater consistency in the set out of tax invoices and invoices, making it easier for recipients to locate the necessary information for tax purposes. For more information about the specific requirements of a tax invoice, refer to Australian Taxation Office: Valid tax invoices and GST credits (NAT 12358), 'Section 03 - Issuing and obtaining tax invoices' in GST for small business (NAT 3014).

(From Detail Page - about 12 words) - As always Australian GST Invoice Template is offered in Excel spreadsheet format.

...(102)...

(From Detail Page - about 72 words) - There are two editions of Australian GST Invoice Template here on InvoicingTemplate.com - the first is a budget-friendly freeware edition, which you can download and use for free; and another which must be used with Uniform Invoice Software installed. Uniform Invoice Software is our Excel invoicing software that turns a simple Excel spreadsheet billing template into a powerful invoicing system, making automated electronic invoice processing with Excel possible and easy to do.

(From Detail Page - about 31 words) - This customized invoice template is suitable for companies whose goods or services include GST. As Australian Taxation Office and the law required, the billing form should include information as detailed below.

• the identity of the supplier, such as the business name at the top
• the Australian business number (ABN) of the supplier at the top, near the supplier's identity
• the date of issue of the tax invoice at the top, on the right hand side
• that the document is intended as a tax invoice, such as including the words 'tax invoice' at the top
• an invoice number shown prominently alongside the words 'tax invoice'
• the purchaser's identity such as a name or ABN, for goods or services costing $1,000 or more
• a unit description of each good or service supplied, including quantities - it is optional to include item numbers, and
• the GST exclusive price, the GST amount and the GST inclusive price for each item, together with the totals for these, vertically in the bottom right hand corner.

(From Detail Page - about 29 words) - Australian GST Invoice Template includes seven columns on the invoice body - DESCRIPTION, ITEM No., PRICE (excl. GST), QTY, SUB TOTAL (excl. GST), GST AMOUNT, AMOUNT PAYABLE (incl. GST).

LEARN MORE PDF

8. Commercial Template Sample - Using Payment Method Checkboxes

"Commercial Template Sample - Using Payment Method Checkboxes" was found to be relative to Openoffice Form Templates Spreadsheet with the score grade of 58.

(From Detail Page - about 21 words) - This sample commercial invoice template explains and demonstrates how to add and use checkboxes to our Excel format commercial invoice form.

(From Detail Page - about 93 words) - If you have visited Commercial Invoice - FedEx Style and Commercial Invoice - FedEx Style (Landscape), you may notice that the two templates use check boxes on the bottom of the form. Many other invoicing forms here on InvoicingTemplate.com use checkboxes too. If you have installed Uniform Invoice Software, you may noticed that the "taxable" column is a checkbox column which controls whether each item on the invoice detail section is taxable - if an item is taxable, the Excel formula set for the template calculates tax or VAT for the current item.

(From Detail Page - about 84 words) - A checkbox is an ideal way to present a "yes/no" option. The FedEx style of commercial invoice template, which we added here on InvoicingTemplate.com to mimic the layout of the PDF version of FedEx blank commercial invoicing template, uses 3 checkboxes on the bottom of the form in the section tilted with "Check One". There are 3 options there - FOB, C&F and CIF. On the Adobe PDF version of the commercial invoices converted from the Excel-formatted document, the checkboxes will work well too.

(From Detail Page - about 117 words) - With the sample, a payment method option is added, which comprises 3 checkbox - "L/C", "T/T" and "Other" - where T/T means telegraphic transfer, or simply wire transfer; and L/C Letter of credit (See the screenshot). For international trade, this payment detail should be useful when it appear on the commercial invoices. Generally, every dutiable shipment sent through FedEx, DHL or UPS must be accompanied with an invoice. The invoice must identify the seller and buyer. It must also clearly indicate the terms and date of sale, quantity, weight and volume of the shipment. It must also indicate a complete description of the shipped goods, shipping, insurance and other charges, unit value and total value as applicable.

...(22)...

...(89)...

(From Detail Page - about 57 words) - Note that these 3 cells must be unlocked so that when the Invoice worksheet is protected, Uniform Invoice Software is able to write to these cells. To do this, select the 3 cells and right-click one of them, choose Format Cells. On the Format Cells dialog box, clear the "Locked" boxes from the "Protection" tab. Click OK.

(From Detail Page - about 89 words) - In Microsoft Excel, there are in fact two ways to add checkbox to a spreadsheet - by using a form control, or by using an ActiveX control. Both options are located on Excel's "Developer" ribbon tab. This tab is not shown by default in Microsoft Excel. To make it visible, firstly you right-click an empty area on the ribbon and then choose "Customize the Ribbon" command from the shortcut menu. On the "Customize the Ribbon" section of the Excel Options dialog box, check the "Developer" option and click OK.

(From Detail Page - about 56 words) - To add a checkbox to the commercial invoicing template, click "Insert" in the "Controls" group on the "Developer" tab. Choose the checkbox from "Form Controls" or "ActiveX Controls". And then, click the location where you want to put the checkbox control. A new checkbox appears on the form. Change its label to "T/T", "L/C" or "Others".

...(68)...

(From Detail Page - about 74 words) - The last thing is that, if you want to be able to extract the commercial invoice (this means to create a new Excel spreadsheet file for the current invoice) along with the new checkbox, then the checkbox must be named with "oknWidget_" prefix. In this commercial invoice sample, we named the controls "oknWidget_checkTT", "oknWidget_checkLC" and "oknWidget_checkOther" respectively. More information could be found in the documentation that comes with the Uniform Invoice Software installer program.

LEARN MORE PDF

9. 4-Column without Tax

"4-Column without Tax" was found to be relative to Openoffice Form Templates Spreadsheet with the score grade of 58.

(From Detail Page - about 21 words) - This is a variant of the invoice template with 4 columns. The template is set with no tax and shipping address.

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

(From Detail Page - about 200 words) - This template has no shipping fields so it is more likely to be used as a service invoice template. But in case you need the shipping fields, you can move back the fields back to the printable area. The printable area on a form is the white area on the center of the form, which is defined by Excel name Print_Area. A print area is one or more ranges of cells that you designate to print when you don't want to print the entire worksheet. When you print a worksheet after defining a print area, only the print area is printed. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet. Setting print area is easy in Excel. First, on the worksheet, select the cells that you want to define as the print area. You can create multiple print areas by holding down CTRL and clicking the areas that you want to print; on the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area. Note that the print area that you set is saved when you save the workbook.

LEARN MORE PDF

10. Consulting Invoice Template (2nd Sample of Customization)

"Consulting Invoice Template (2nd Sample of Customization)" was found to be relative to Openoffice Form Templates Spreadsheet with the score grade of 44.

(From Detail Page - about 34 words) - Every business is different, so your consulting invoices should be. As detailed in this sample, changing the color palette in Excel could quickly give the original consulting invoice template a different look and feel.

(From Detail Page - about 73 words) - Most free invoice templates available here on InvoicingTemplate.com, along with the versions that work with Uniform Invoice Software, are designed with the similar color style. The secret behind this is simple 鈥?in the past several years we have created hundreds very different styles, but all the templates we created are based on the same sales invoice template, which is also the one that included in the installer program of Uniform Invoice Software.

(From Detail Page - about 98 words) - While it's understandable to have so many invoice templates in the similar color style, your business is different and special, so without doubt it is better to have a special invoice design that meets your business style and requirements. In addition to changing company details and replacing the logo image on the top of the invoice form, applying a new color theme is an easy and quick way to let your invoices stand out. So, here is the steps to quickly change the color palette in Excel 2010 to apply a new color to the consultant invoice template.

• Open Consulting Invoice Template (2nd 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.

(From Detail Page - about 28 words) - Note that if you use the Uniform Invoice Software version of the consulting invoice template, it is necessary to unprotect the Invoice form before you can customize it.

(From Detail Page - about 67 words) - The protection of the Invoice worksheet in Consulting Invoice Template (2nd 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 invoice worksheet. However for the purpose of this sample, we should firstly unprotect the Invoice worksheet in Consulting Invoice Template (2nd Sample of Customization).

(From Detail Page - about 99 words) - Microsoft Excel provides powerful tools for customizing the invoice form. Changing the color theme is just a simple step, yet it results a consultant invoice template with a new and different look and style. There are many more things you can do with Excel, which we'll detail in future invoice samples here on InvoicingTemplate.com. Uniform Invoice Software leverages not only the power of front-end Excel, but also the power of backend database, gives you easy-to-use yet powerful invoicing system. Feel free to download and try the fully functional trial version along with the consulting invoice template that you like.

LEARN MORE PDF