Sample Sales Invoice

1. Sample Sales Invoice Template 2

"Sample Sales Invoice Template 2" was found to be relative to Sample Sales Invoice with the score grade of 99.

(From Format Page - about 60 words) - "Sample Sales Invoice Template 2" is categorized as "Sales Invoice Template". Sample Sales Invoice Template 2 has 2 columns on the form body. Sample Sales Invoice Form 2 has 12 lines on the invoice body, the line height for each line is 19.50 points. Sample Sales Invoice Template 2 defines its printable invoice form at "$G$1:$P$43" on the "Invoice" worksheet.

(From Format Page - about 39 words) - Sample Sales Invoice Template 2 is designed to be printable on "A4 (210 mm x 297 mm)" with portrait paper orientation. With this paper and orientation specification, Sample Sales Invoice Form 2 could be printed with the following margins.

...

(From Format Page - about 13 words) - Like Sample Sales Invoice Template 2? You may also like these invoice templates:

(From Format Page - about 47 words) - Including this Sample Sales Invoice Template 2, all invoice formats available here on InvoicingTemplate.com are created from the default invoice template shipped with Uniform Invoice Software. In fact, Sample Sales Invoice Template 2 can be seen as a sample on how to customize the default invoice template.

(From Format Page - about 16 words) - Sample Sales Invoice Form 2 has a PDF version too, which you can visit at samplesales2.pdf.

(From Format Page - about 38 words) - With the Uniform Invoice Software version, Sample Sales Invoice Template 2 connects to an Access database "c2001.mdb" by default. The Uniform Invoice Software version Sample Sales Invoice Template 2 is fully functional only with the invocing software installed.

(From Format Page - about 29 words) - As an invoicing template in Microsoft Excel format, the format and layout of Sample Sales Invoice Template 2 can be set via the Page Setup dialog box in Excel.

(From Download Page - about 143 words) - Sample Sales Invoice Template 2 helps you to create beautiful and professional invoices/business documents with an intuitive blank form in Microsoft Excel format. Sample Sales Invoice Template 2 has 2 columns on the form body. "Sample Sales Invoice Template 2" is categorized as "Sales Invoice Template". The template # of this Excel invoice template is "c2001" here on InvoicingTemplate.com. Creating a business document using this Sample Sales Invoice Template 2 is much like filling a blank paper form using a pen, but the Excel invoice template helps you go to electronic invoicing without a hard learning curve, and it also helps in computer-based accounting. Sample Sales Invoice Template 2 is printable like a general Excel document, and the print options can be easily adjusted by first opening Sample Sales Invoice Template 2, and then go to the Page Setup dialog box in Excel.

read more download format pdf

2. Blank Sales Invoice Layout (Two-tax)

"Blank Sales Invoice Layout (Two-tax)" was found to be relative to Sample Sales Invoice with the score grade of 98.

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

(From Detail Page - about 140 words) - The tax names are set to its default values, "TAX1" and "TAX2". To change the tax names and rates, simply unprotect the "Invoice" worksheet by clicking the "Unprotect Sheet" command in the "Review" Excel ribbon tab. All the templates here on InvoicingTemplate.com are protected by default. This is a good way to prevent modifications to the layout and formulas of the template. All editable / fillable cells are unlocked so that they are selectable and editable even when the spreadsheet is protected. To set / view the locking status of a cell, first unprotect the sheet, and then right-click the cell you want to set, choose Properties. On the "Protection" tab of the "Format Cells" dialog box, you'll find the "Locked" property. If this property is checked, the cell will not be editable / fillable when the sheet is protected.

(From Detail Page - about 144 words) - c2020 - Blank Sales Invoice Layout (Two-tax) (Blank Sales Invoice Sample (Two-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 no tax and shows all lines on the invoice body, see Blank Sales Sample (No-tax). 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 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).

read more download format pdf

3. Blank Sales Invoice Format (One-tax)

"Blank Sales Invoice Format (One-tax)" was found to be relative to Sample Sales Invoice with the score grade of 95.

(From Detail Page - about 31 words) - With this sample template, the "Ship To" fields are moved back into the printable invoicing form. The default "Ship To" fields includes Name, Address, City State and ZIP, Country and Contact.

(From Detail Page - about 57 words) - If you have taken a look at the documents included in Uniform Invoice Software, you knew that all Excel spreadsheet invoice samples here on InvoicingTemplate.com are created from the default sales invoice template shipped with Uniform Invoice Software. If a field is not needed in a customized template, we simply move it out of the printable area.

(From Detail Page - about 143 words) - The printable area, or print area, is the area with white background on the center of the Blank Sales Invoice Format (One-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 Blank Sales Invoice Format (One-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 Blank Sales Invoice Format (One-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.

...(123)...

...(144)...

(From Detail Page - about 229 words) - Sales, in general, is a transaction between two parties where the buyer receives goods (tangible or intangible), services and/or assets in exchange for money; the term is also used for an agreement between a buyer and seller on the price of a security. The sales invoice is perhaps the most common document in the business world. It is an important record for both the seller and the client, and it's an essential element in the management and bookkeeping of any business. Traditionally, invoices were sent in the mail or, when the technology became available, via fax. Today, as businesses gravitate toward paperless operations, they are commonly sent electronically via email and filed away on a computer (eHow). No matter whether you printed a hard copy of the invoices you created, make the information accurate, and make the layout professional. This does not mean you have to purchase an expensive accounting or bookkeeping app - a free invoice template like this one - c2019 Blank Sales Invoice Format (One-tax) could get the job done well. If you have a limited budget for invoicing, or just started a business, this free invoice template might be your best choice. If you need more - for example, pick customer and products from exiting records so that you don't have to type them each time on creating an invoice, then install Uniform Invoice Software.

read more download format pdf

4. Sample Sales Invoice Template: Fixed Items

"Sales Template with Fixed Items" was found to be relative to Sample Sales Invoice with the score grade of 90.

...(38)...

(From Detail Page - about 164 words) - In some businesses the number of products or service items offered are limited, i.e. the client / customers always order the same group of products / services from the company. It would be nice to have the invoice form always leaves the item#, item description, or even item unit price there and does not change them from invoice to invoice. We call these static or fixed items because they don't change. Using static and fixed items prevent you from type or choose the same product items again and again, saving your time and avoiding typo mistakes. The fixed items even won't get cleared when you execute "Clear & New" with Uniform Invoice Software installed - it sounds interesting because the "Clear & New" command is designed to clear all the content to make it a blank invoice form for next new invoice. So how do we tell the "Clear & New" command not to touch the items that shouldn't change from invoice to invoice?

...(67)...

(From Detail Page - about 129 words) - The "Lock" property is a very useful feature in Excel. When you protect a worksheet such as Sample Sales Invoice Template: Fixed Items, all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the Invoice worksheet of Sample Sales Invoice Template: Fixed Items. To lock a cell or a range of cells, first drag your mouse to select the cell or cells, and then right-click one of the selected cell on the form, choose Format Cells. On the Number tab, check the "Locked" box. To unlock a cell or a range of cells, simply clear the "Locked" box.

...(63)...

(From Detail Page - about 46 words) - Note that these static or fixed items are not static text labels such as your company information on the invoice header. The static or fixed items are linked to database fields, and get saved to database when you click "Save To DB" in Uniform Invoice Software.

(From Detail Page - about 69 words) - So with very little effort the items that don't change from invoice to invoice become static or fixed. They stay on the invoice form even if you click the "Clear & New" command in Uniform Invoice Software. The sample invoice template has exactly the same format and layout as the default sales invoice template included in Uniform Invoice Software setup program, but has some items fixed on the form.

(From Detail Page - about 26 words) - As the name implies "Sample Sales Invoice Template: Fixed Items" includes shipping fields. For a service invoice template please see "Sample Service Invoice Template: Fixed Items".

read more download format pdf

5. Sample Sales Invoice Template: Using Handwriting Signature

"Sample Sales Invoice Template: Using Handwriting Signature" was found to be relative to Sample Sales Invoice with the score grade of 84.

...(37)...

(From Detail Page - about 60 words) - Since the sample invoice template is in Microsoft Excel format, you can in fact add any number of images to the printable invoice form. The default logo image, for example, is added to the form as an ActiveX image object. This invoice template added a handwriting signature image due to its popular demands we received during the past several years.

(From Detail Page - about 64 words) - Since we've already added the handwriting signature image to the printable form, you don't have to add another ActiveX image control in order to use your own signature image. In order to use this sample sales invoice template, what you need to do is to replace our sample signature image with your own image, just like what you'll do with the default logo image.

(From Detail Page - about 38 words) - So, here is the description from Uniform Invoice Software documents that details how to replace the default logo image. Replacing the signature image on the Sample Sales Invoice Template: Using Handwriting Signature form involves exactly the same steps.

...(92)...

• 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.

(From Detail Page - about 100 words) - If you don't need the LOGO image and want to delete it, simply hit the DEL key on your keyboard after you selected it with your mouse key. Deleting the LOGO image leaves an empty area to the left of the Company Information section. You may like to move the entire Company Information section to fill in the empty area. To do this: Drag your mouse to select the entire Company Information area, including Company Name, Street Address, City, ST Zip Code, etc.; Push your mouse key on the border of the selected area; drag it to the new location.

(From Detail Page - about 97 words) - If you don't like our way to add/replace images described above, but prefer to copy and paste the image directly into the printable invoice form, one additional step must be taken to make the blank invoice template works with Uniform Invoice Software, that is to name the image / control with "oknWidget_" prefix. Only the images controls with the "oknWidget_" prefix will be included extracted invoices. All the other controls, such as those command buttons on the top of the form, the icon buttons, will be removed if you execute the "Extract/Email" command in Uniform Invoice Software.

(From Detail Page - about 64 words) - Your business is unique, so that you invoices should be. Adding a signature image is a good and easy way to go. This sample invoice template, Sample Sales Invoice Template: Using Handwriting Signature, demonstrates how easy it is to add new images to make your invoice unique. The service version of this template can be found at Sample Service Invoice Template: Using Handwriting Signature.

read more download format pdf

6. Sample Sales Invoice Template: Using Line Number Instead of Item#

"Sample Sales Invoice Template: Using Line Number Instead of Item#" was found to be relative to Sample Sales Invoice with the score grade of 60.

(From Detail Page - about 33 words) - This sample invoice template shows automatically the line number of an item in the place of item# or product# on the invoice body. The sample demonstrates the flexibility of an Excel-formatted invoicing template.

(From Detail Page - about 160 words) - Most invoice templates available here on InvoicingTemplate.com have a Product # (or sometimes titled "Product ID" or "Item#") column on the invoice body. If you are using Uniform Invoice Software, our invoicing software and billing software that uses Excel invoice templates as it's front-end, the product# or item# is a required field that is used to uniquely identify a product or an item. With the product# or item# field, Uniform Invoice Software is able to save the description, unit price and all the other related information into database, so that you can retrieve these type of information by entering the product# or item#, without typing the same description, unit price etc. again and again. So in most cases if the product# or item# column is not required to display on the printable invoice form, we move it out of the printable form, instead of delete it. The product# field also helps in generating the product report in Uniform Invoice Software.

(From Detail Page - about 59 words) - But there are situations where you don't need the product# or item# at all. In this Sample Sales Invoice Template: Using Line Number Instead of Item# we'll assign a line number to the product# field automatically using Excel formula. It is a good example on how the default sales invoice template could be customized in the way you like.

(From Detail Page - about 49 words) - This sample invoice template was originally published as a customization sample on office-kit.com at Sample Invoice Template: Using Line# as Product IDs, where you can also find detailed steps on how to create the sample invoice template based on the default sales invoice template shipped with Uniform Invoice Software.

(From Detail Page - about 45 words) - InvoicingTemplate.com categorizes this template as Sales Invoice Template, meaning it includes shipping fields on the form. A service template, where we moved out the shipping fields from the printable invoice form, is also available at Sample Service Invoice Template: Using Line Number Instead of Item#.

read more download format pdf

7. Sales Invoice Template with Discount Amount Column

"Sales Template with Discount Amount Column" was found to be relative to Sample Sales Invoice with the score grade of 57.

(From Detail Page - about 29 words) - Sales Invoice Template with Discount Amount Column is a sample invoice template that adds a discount amount column to the default sales invoice template shipped with Uniform Invoice Software.

...(110)...

(From Detail Page - about 117 words) - What if you need to show discounts in a more detailed manner? For example, show discounts applied to each item on invoice body separately? This requires an additional column on the invoice body, as compared to the 5 columns on the default sales invoice template that shipped with the setup program of Uniform Invoice Software. So in this customized sample invoice template - Sales Invoice Template with Discount Amount Column, we have 6 columns on the invoice body within the printable invoice body: Product ID, Description, Quantity, Unit Price, Discount, and Line Total. The "Discount" here is an amount value. We'll publish the percentage version of this sample invoice template here on InvoicingTemplate.com in the near future.

(From Detail Page - about 56 words) - Like all the other sample invoice templates here on Invoicing Templates, Sales Invoice Template with Discount Amount Column is also created from the default sales invoice template shipped with Uniform Invoice Software. In order to create this 6-column invoice layout, we need to adjust the existing 5-column invoice layout to leave space for the additional column.

(From Detail Page - about 258 words) - To adjust the existing columns to leave space for new column or columns that will be added to the printable form for Sales Invoice Template with Discount Amount Column, 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 Sales Invoice Template with Discount Amount Column 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 Sales Invoice Template with Discount Amount Column.

(From Detail Page - about 45 words) - Please download the Sales Invoice Template with Discount Amount Column for free to see how it differs from the default sales invoice template shipping with Uniform Invoice Software. A PDF version of this Sales Invoice Template with Discount Amount Column is also available for free.

read more download format pdf

8. Simple 2-Column Sales Invoice Template

"Simple 2-Column Sales Invoice Template" was found to be relative to Sample Sales Invoice with the score grade of 43.

(From Detail Page - about 32 words) - Simple 2-Column Sales Invoice Template is a sample of customizing the default sales invoice template shipped with Uniform Invoice Software. It has two columns, Description and Amount, on the printable invoice body.

(From Detail Page - about 66 words) - The default sales invoice template has 5 columns within the printable invoice body - product#, description, quantity, unit price, line total. This simple 2-column sales invoice template, designed for general invoicing purpose, moved the product#, quantity, and unit price columns out of the printable area. The description and amount columns left inside the printable area are all manually editable, making it suitable for general invoicing needs.

(From Detail Page - about 95 words) - Simple 2-Column Sales Invoice Template, like the default sales invoice template, has two tax items on the bottom of the invoice form, which are applied to all the items in an invoice, and a column of Taxable checkboxes to the left of the form body, which are corresponding to each invoicing item. You can change the tax names and rates on the bottom of the form by typing in whatever meet your requirements. These are the supported features implemented in both the freeware version of the sales invoice template and the Uniform Invoice Software version.

...(164)...

...(33)...

(From Detail Page - about 63 words) - The protection of the Invoice worksheet in Simple 2-Column Sales Invoice Template 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 Simple 2-Column Sales Invoice Template.

(From Detail Page - about 135 words) - In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Simple 2-Column Sales Invoice Template. Note that if you have our invoicing program (Uniform Invoice Software) 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 invoices 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.

...(153)...

(From Detail Page - about 23 words) - Once you have finished your design work for Simple 2-Column Sales Invoice Template, click the Design Mode button again to exit design mode.

(From Detail Page - about 90 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 Simple 2-Column Sales Invoice Template with your own image, follow the steps below:

...(53)...

(From Detail Page - about 100 words) - If you don't need the LOGO image and want to delete it, simply hit the DEL key on your keyboard after you selected it with your mouse key. Deleting the LOGO image leaves an empty area to the left of the Company Information section. You may like to move the entire Company Information section to fill in the empty area. To do this: Drag your mouse to select the entire Company Information area, including Company Name, Street Address, City, ST Zip Code, etc.; Push your mouse key on the border of the selected area; drag it to the new location.

(From Detail Page - about 54 words) - Feel free to download and try Uniform Invoice Software along with this simple 2-column sales invoice template. Installing Uniform Invoice Software, our Excel Invoice Software, will also install the help documents for the invoicing program, which includes detailed instruction on how to customize the invoice template such like this simple 2-column sales invoice template.

read more download format pdf

9. Sample Service Invoice Template: Fixed Items

"Sample Service Invoice Template: Fixed Items" was found to be relative to Sample Sales Invoice with the score grade of 41.

(From Detail Page - about 25 words) - Sample Service Invoice Template: Fixed Items is a variant of Sample Sales Invoice Template: Fixed Items. It is the service edition of the original one.

...(109)...

(From Detail Page - about 16 words) - This service edition is created by moving all the shipping fields out of the printable form.

...(239)...

(From Detail Page - about 95 words) - The two standalone fields, "Ship Date" and "Ship Via", are also moved out of the printable invoice form (Although "Shipping Cost" is left on the bottom of the form). The two adjacent fields, "Terms" and "Due Date", are expanded to fill in the space left by moving out the shipping fields. To do this, we first move "Terms" (both the label and field cell) two columns left, and move "Due Date" one column left, and then select the "Terms" label and its subsequent empty cell, and then click "Merge and Center" command on Excel ribbon.

(From Detail Page - about 119 words) - Merge and Center works by merging the selected cells into one and then centering the data in the new combined cell. While design an invoice template layout like Sample Service Invoice Template: Fixed Items, Merge and Center could be a handy tool if used properly. One thing to note, however, since Uniform Invoice Software relies on cell names (or field names) to create the relationship between the Excel form cells and the database fields, you should make sure the cell that contains a field name is the first one in the group of cells that are to be merged. This way, Uniform Invoice Software will work with the merged cell by reading from or writing to the named cell.

(From Detail Page - about 35 words) - So with several easy steps we have the Sample Service Invoice Template: Fixed Items. As detailed at the sales edition Sample Sales Invoice Template: Fixed Items, fixed items could be very helpful for some businesses.

read more download format pdf

10. Engineering Service Invoice Template

"Engineering Service Invoice Template" was found to be relative to Sample Sales Invoice with the score grade of 33.

(From Detail Page - about 58 words) - While all template available here on InvoicingTemplate.com are created from the default sales invoice template included with Uniform Invoice Software setup program, Engineering Service Invoice Template differs from other templates not only in the layout of the form, but also in that it uses a number of custom fields for detailing the engineering service offered by the business.

...(118)...

...(134)...

(From Detail Page - about 230 words) - When working with Uniform Invoice Software version of Engineering Service Invoice Template, 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 Engineering Service Invoice Template 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.

...(195)...

(From Detail Page - about 233 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 Engineering Service 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 Engineering Service 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 Engineering Service 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 30 words) - Engineering Service Invoice Template has one VAT tax defined on the bottom of the invoice form. The tax rate cells has also been moved of out the printable invoice form.

...(58)...

(From Detail Page - about 86 words) - Naming a control or an image is easy in Microsoft Excel. First make sure your template Engineering 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.

read more download format pdf

11. Invoice Template with Long Product Description

"Invoice Template with Long Product Description" was found to be relative to Sample Sales Invoice with the score grade of 19.

...(23)...

(From Detail Page - about 80 words) - The blank invoice template has 4 columns on the invoice body, and includes both the "Bill To" and "Ship To" sections. The detailed steps of the design could be found on office-kit.com, but the basic procedures are the same as with all the other designs here on InvoicingTemplate.com, including: unprotect the sheet, switch to design mode, move out unneeded cells (the product # column), merge cells / fields to expand the size / space of an existing cell or field.

(From Detail Page - about 65 words) - The protection of the Invoice worksheet in Invoice Template with Long Product Description 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 Invoice Template with Long Product Description.

(From Detail Page - about 136 words) - In design mode, Microsoft Excel allows you to move, add, or delete controls or images inside Invoice Template with Long Product Description. Note that if you have our invoicing program (Uniform Invoice Software) 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 invoices 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.

...(153)...

...(239)...

(From Detail Page - about 31 words) - Since this billing form is designed with long product description in mind, you may also like to adjust the width of the Description column to leave more space for the column.

...(109)...

(From Detail Page - about 58 words) - The flexibility of Microsoft Excel makes creating this customized Invoice Template with Long Product Description easy and quick. Don't forget to protect the Invoice worksheet and exit design mode once the design work is finished. If you find this invoice template interesting, download and try its free format, Uniform Invoice Software format or PDF format per your requirements.

read more download format pdf

12. Sample Service Invoice Template: Using Handwriting Signature

"Sample Service Invoice Template: Using Handwriting Signature" was found to be relative to Sample Sales Invoice with the score grade of 14.

...(28)...

(From Detail Page - about 110 words) - The difference between sales invoice template and service invoice template here on InvoicingTemplate.com is simple - if a template contains the "Ship To" section on the printable section, we call it sales invoice. If it does not contain the "Ship To" section, it is categorized as service invoice. If the form has a very special design in its layout, such as Tax Invoice for Printing Shop, which moves the "Ship To" section (titled with "Delivery To") to the body of the invoice form, we add the template to both the sales invoice template and service invoice template category. Sample Service Invoice Template: Using Handwriting Signature adheres to this rule too.

(From Detail Page - about 128 words) - The free Sample Service Invoice Template: Using Handwriting Signature does create professional-looking invoices for you without a hard learning curve, but the Uniform Invoice Software version offers more advanced features. For example, with the freeware edition of Sample Service Invoice Template: Using Handwriting Signature, you have to clear the invoice form manually to make it a blank invoice form in order to create a new invoice - that is, to delete all the existing field values, such as invoice date, invoice#, customer information etc. With the Uniform Invoice Software edition, by clicking the "Clear & New" button once, all the fields are cleared and some fields are filled with default values. For example, the "Clear & New" command fill in the invoice date field with the today's date.

(From Detail Page - about 147 words) - Speaking of dates, we have some off-topic words to talk about. Date values are not as easy as it sounds. Dates seem to cause people problems. Ask five people to enter a date into Excel and you'll get dates entered five different ways. We have created a little and handy utility to address this, an Excel date picker, called Pop-up Excel Calendar. The Excel Date Picker pops up a calendar whenever you click to move into a date cell - i.e. a cell that contains a date value, a date format, or underneath a cell that has the word "date" in it. If you are interesting in this please find more information at Pop-up Excel Calendar, Date Picker for Excel, and at Excel Date Picker, a Pop-up Excel Calendar for Excel. If you use dates frequently our Excel Date Picker could be a nice helper for you.

...(67)...

...(153)...

(From Detail Page - about 25 words) - Once you have finished your design work for Sample Service Invoice Template: Using Handwriting Signature, click the Design Mode button again to exit design mode.

...(242)...

(From Detail Page - about 39 words) - The difference between this Sample Service Invoice Template: Using Handwriting Signature and the default sales invoice template shipped with Uniform Invoice Software is minor, but it provides a good example on using custom images on the printable invoice form.

read more download format pdf

13. Sample Service Invoice Template: Using Line Number Instead of Item#

"Sample Service Invoice Template: Using Line Number Instead of Item#" was found to be relative to Sample Sales Invoice with the score grade of 11.

...(34)...

(From Detail Page - about 113 words) - The difference between sales invoice template and service invoice template here on InvoicingTemplate.com is simple - if a template contains the "Ship To" section on the printable section, we call it sales invoice. If it does not contain the "Ship To" section, it is categorized as service invoice. If the form has a very special design in its layout, such as Tax Invoice for Printing Shop, which moves the "Ship To" section (titled with "Delivery To") to the body of the invoice form, we add the template to both the sales invoice template and service invoice template category. Sample Service Invoice Template: Using Line Number Instead of Item# adheres to this rule too.

(From Detail Page - about 67 words) - If you know Microsoft Excel, creating this sample invoice template from the original sample sales invoice template should be easy. If you are not, but interesting in how to do the customization, here are the processes involved in creating the sample service invoice template. The detailed tutorial on creating the sample sales invoice template can also be found at Sample Invoice Template: Using Line# as Product IDs,

(From Detail Page - about 43 words) - Like what we do to all the customized invoice templates here on InvoicingTemplate.com, we start by unprotecting the Invoice worksheet, and then display gridlines and row/column headers, and then drag the shipping fields, including the related labels, out of the printable invoice form.

...(11)...

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.

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

...(17)...

(From Detail Page - about 87 words) - Sample Service Invoice Template: Using Line Number Instead of Item# demonstrates how easy it is to customize an invoice template in the way you like by using various tools provided by Excel. Regular data, such as your daily invoices, customers, items and payments, will be much easier to manipulate in the backend by using a database. So feel free to try the Uniform Invoice Software version of Service Template with Line Number, which provides all the features you need in management of customers, products, invoices and payments.

read more download format pdf

14. Australian GST Invoice Template (2)

"Australian GST Billing Form (2)" was found to be relative to Sample Sales Invoice with the score grade of 6.

(From Detail Page - about 30 words) - Australian GST Invoice Template (2) is the second sample of how to customize the default sales invoice template, corresponding to the second example given on Australian Taxation Office web site.

(From Detail Page - about 104 words) - The previous invoice template sample here on InvoicingTemplate.com, Australian GST Invoice Template (1), meets the layout and feature requirements of the first sample in the Examples of what they look like using the voluntary standards on the Australian Taxation Office web site, titled with "Goods or services that all include GST". This second invoice template sample is based on the previous invoice template, and meets the layouts and requirements as shown in the second sample in the Examples of what they look like using the voluntary standards on the Australian Taxation Office web site, titled with "Goods or services that don't all include GST".

...(173)...

(From Detail Page - about 37 words) - To resolve this problem Australian GST Invoice Template (2) a nice feature offered by Excel, conditional formatting. As always, Excel's powerful features on formatting data making it possible to draft invoices in the way your business likes.

(From Detail Page - about 19 words) - To create the conditional formatting for the GST Amount cells in Excel 2013, here are the steps to follow.

...(63)...

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.

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

(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 170 words) - Now you can set the conditional formatting for the "GST Amount" cells. Click to select the first GST Amount Cell located on Q20, on Excel ribbon click "Conditional Formatting" in the Styles group, and then choose Manage Rules. Click "New Rule..." and then Click "Use a formula to determine which cells to format" on the "Select a Rule Type" list. In the "Format Values where this formula is true" box, enter the formula "=AND(P20<>0, Q20=0)" (without the quotation marks). This formula means that the conditional formatting applies only when the P20 cell (which is a "Subtotal excl. GST" cell) is not zero and the Q20 cell (which is a "GST Amount" cell) is zero. Click the Format button to open the "Format Cells" dialog box. Go to the Number tab, and then click "Custom" on the "Category" list, enter the custom format string ";;-;" (without the quotation marks). This custom format means that, if the value is zero, display a "-" symbol. Click OK button to close all dialog boxes.

(From Detail Page - about 28 words) - We do the above steps for the second line on the invoice body. In the "Format Values where this formula is true" box, enter the formula "=AND(P21<>0, Q21=0)".

(From Detail Page - about 31 words) - Now by using the Format Painter of Excel, you can easily copy the conditional formatting of the first GST Amount cells to the other GST Amount Cells on the invoice body.

...(26)...

(From Detail Page - about 58 words) - While the free edition of Australian GST Invoice Template (2), which offers a budget-free edition for creating invoices, helps you create professional invoices with an intuitive billing form, like what the Adobe PDF version shows, with Uniform Invoice Software installed, it can even being the powerful invoicing software that helps you manage your customers, products, invoices and payments!

read more download format pdf

15. Netherland Sales Invoice Template 2

"Netherland Sales Billing Form 2" was found to be relative to Sample Sales Invoice with the score grade of 1.

(From Detail Page - about 35 words) - This is another variant and customization sample of Netherland Sales Invoice Template (c6009). The original design of the invoicing form include the "Maat" column. This sample demonstrates how to remove it from the invoice form.

(From Detail Page - about 74 words) - By moving out the "Maat" column, this invoice template is now more generic and thus suitable for more sales companies that need the shipping section on their invoicing form. If you are offering services and don't need the shipping address fields, refer to c5051 Netherland Service Invoice Template 2. If you would like to see a service invoice template where the "Size" column has its title changed to "Hours", see Netherland Service Invoice Template.

(From Detail Page - about 32 words) - Note that this Netherland sales invoice template is designed to offer only one tax on the form. As detailed at EU regulations concerning invoices, the following statements are required for VAT purposes:

• date of issue;
• a specific number;
• where necessary, the VAT identification number of the taxable person and his customer;
• full name and address of the taxable person and his customer;
• description of the goods or services;
• quantity of goods supplied or, if necessary, of services rendered;
• date of supply of goods or rendering of services;
• place of supply of goods or rendering of services;
• taxable amount per rate;
• VAT rate;
• VAT amount payable;
• total amount payable;
• where an exemption is involved, reference to the provision which justifies the exemption.

(From Detail Page - about 55 words) - Netherland Sales Invoice Template 2 adhere to the above requirement statements. In addition to the fields defined in the c6009 Netherland Sales Invoice Template, this VAT invoice template (Netherland Sales Billing Form 2) also defined a new field VatID in both the Customer and Invoice Header database tables, which is implemented as a custom field.

...(135)...

(From Detail Page - about 111 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 Netherland Sales Invoice Template 2 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.

...(63)...

(From Detail Page - about 102 words) - Adding a custom field to the Customer table in the database makes it possible to save the field value to database along with the other data of a customer / client. For example, adding the custom field Company Name to the Customer database table allows you to save the company name of a customer to the database when you save a customer. If you use Uniform Invoice Software version template Netherland Sales Invoice Template 2 and add the custom field to the invoice form, the value is retrieved and filled into Netherland Sales Invoice Template 2 whenever you pick up a customer.

...(146)...

...(232)...

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

(From Detail Page - about 25 words) - Netherland Sales Invoice Template 2 has its corresponding service invoice template edition too. Please refer to c5051 Netherland Service Invoice Template 2 to learn more.

read more download format pdf