Dhl Commercial Invoice Form

1. Commercial Template Sample - Adding Insurance Cost Field

"Commercial Template Sample - Adding Insurance Cost Field" was found to be relative to Dhl Commercial Invoice Form with the score grade of 80.

(From Detail Page - about 133 words) - Unlike those invoicing templates in HTML, Adobe PDF or Microsoft Word format, it is relatively easy to add new fields to an existing invoicing form. This is true to OpenOffice spreadsheet templates too. This reason is simple - with a spreadsheet format template, the space on the blank forms was divided into cells and fields naturally. To add a new field, simply look for a blank (not used) cell and type in the related information. Of course, if you want to include the new field on the printed versions / exported PDF versions, make sure the location of the new fields is within the range defined by Print_Area name - this name defines the printable form. Cell and contents outside this area will not be printed or included in the generated PDF documents.

(From Detail Page - about 83 words) - In this sample, we placed the insurance and currency cells F15:K15. This was done by unmerge the original "Country of ultimate destination" cell to make space for the new cells. We also rearranged the "Country of Export", "Country of manufacture" cells. By moving the fields and labels, we aligned all the content in the F13:K17 section to make the form look professional and beautiful. Be sure to unlock the cells so that even if the sheet is protected, the cells are still fillable.

(From Detail Page - about 86 words) - Your business grows fast. So you need a more powerful tool to handle your commercial invoices! By installing Uniform Invoice Software, our Excel-based billing and invoicing software app, a simple Excel invoice template could be a complete invoicing system. So how about the new fields added to a template, such as in this example, the insurance cost and currency code fields? No problem! Uniform Invoice Software (and even Excel Invoice Manager) support custom fields, which are user-defined fields added to both the template and database file.

LEARN MORE PDF

2. Commercial Template Sample - Using Payment Method Checkboxes

"Commercial Template Format - Using Payment Method Checkboxes" was found to be relative to Dhl Commercial Invoice Form with the score grade of 80.

(From Detail Page - about 115 words) - c9004 - Commercial Template Sample - Using Payment Method Checkboxes (Commercial Template Format - Using Payment Method Checkboxes) 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 complete Incoterms option, see Commercial Template Sample - Complete Incoterms Option. For the version that includes insurance and currency symbol options, see Commercial Template Sample - Adding Insurance Cost Field.

(From Detail Page - about 22 words) - So how is this designed? What is the key point to implement it and make sure they work with Uniform Invoice Software?

(From Detail Page - about 89 words) - First, 3 custom fields will be created to store the value of the checkboxes. To do this, click the Invoices button on the "Invoice" ribbon tab. Click Custom Fields, and then Add Field. Enter "PaymentMethodTT" in the "Name" box, and then choose "Integer" from the "Type" list, click OK. Click "Add Field" again, Enter "PaymentMethodLC" in the "Name" box, and then choose "Integer" from the "Type" list, click OK. Click "Add Field" again, Enter "PaymentMethodOther" in the "Name" box, and then choose "Integer" from the "Type" list, click OK.

(From Detail Page - about 93 words) - Now switch to design mode by pushing the "Design Mode" button on the "Invoice" ribbon tab. You have to choose 3 cells that will show the value of the "PaymentMethodTT", "PaymentMethodLC" and "PaymentMethodOther" fields. In this sample, we choose the $AA$40:$AA$42 range for this purpose, and named 3 cell "oknPaymentMethodTT","oknPaymentMethodLC" and "oknPaymentMethodOther" respectively. As you can see from this commercial invoice sample, the map (or link) between the database field and the Excel cell is archived by using names - you name the cell by adding the prefix "okn" to the field name.

LEARN MORE PDF

3. Commercial Invoice - FedEx Style (Landscape)

"Commercial Invoice Format - FedEx Style (Landscape)" was found to be relative to Dhl Commercial Invoice Form with the score grade of 74.

(From Detail Page - about 33 words) - This commercial invoicing sample was a customized version of "c9002 Commercial Invoice - FedEx Style". This form is still be printable on standard A4 paper, but the paper orientation is changed to landscape.

(From Detail Page - about 157 words) - In order to create this template, we've also moved the address fields on the "Shipper/Exporter", "Recipient" and "Importer (If other than recipient)" sections. The purpose of this movement is to make the sections occupy less lines on the vertical orientation. In the original design, each of the section occupy 8 lines for these fields - Tax ID/VAT No, Contact Name, Company Name, Address, City State/Province, Postal Code, Country/Territory, and Phone. Now each of the section uses only 4 lines. With this commercial invoice format design, the lines for "Federal Express International Air Waybill Number" still uses one whole line; "Date of Export" and "Export References" use another whole line. These fields are put on the top of the form because they are the most important cells, at least in the FedEx design. The PDF version of this blank commercial invoice template for shipping, which was created by using Excel's built in feature, has exactly the same layout.

...(77)...

(From Detail Page - about 100 words) - As detailed on the FedEx web site, all shipments / freight must be accompanied by a FedEx International Air Waybill & two duplicate copies of commercial invoices. With Uniform Invoice Software installed, printing of two copies of your commercial invoices could be done with a single click of mouse. Go to the Print tab on the Settings window to find all the printing options. All forms available here on InvoicingTemplate.com are printable and fillable. You can adjust the printing and paper options by using Excel's own features too - for example, by choosing the options on Excel's Page Layout tab.

(From Detail Page - about 167 words) - Here on InvoicingTemplate.com, we have a number of commercial invoices and proforma invoice template built for you to choose, including samples that are similar to layouts recommended by DHL, UPS and FedEx. All the templates work well with Uniform Invoice Software. Feel free to visit U.S. Customs and Border Protection documentation for Requirements, criteria, or format of a commercial invoice, bill of sale, receipt that must be provided when clearing or filing entry documents. In foreign trade / international transactions, commercial invoice documents are important to both export trade and import trade. It is used when dutiable goods are shipped internationally, and as a customs declaration provided by the person or corporation that is exporting an item across international borders. It is used by the customs officials to classify your merchandise. This in turn will help them in correctly assessing the applicable duties and taxes. The Commercial Invoice is prepared by the exporter and is required by the foreign buyer to prove ownership and arrange for payment.

LEARN MORE PDF

4. Commercial Invoice - FedEx Style

"Commercial Invoice - FedEx Style" was found to be relative to Dhl Commercial Invoice Form with the score grade of 67.

...(31)...

...(80)...

(From Detail Page - about 50 words) - There are already sample forms on FedEx, such as How to Complete a Commercial Invoice. The templates on FedEx is in either Adobe PDF or HTML format. Here at InvoicingTemplate.com we provide you with another alternative in Microsoft Excel spreadsheet format (and also a PDF version generated with Excel itself).

(From Detail Page - about 167 words) - Note that there are other commercial invoicing templates too. For example, DHL has a tutorial on this topic at Prepare Your Commercial Invoice. ShipNorthAmerica Transportation provides Free generic commercial invoice forms & templates on their website. Microsoft has an online version here. And here at InvoicingTemplate.com, we've already published several sample templates too, such as Commercial Invoicing Template, Commercial Invoice Template with Colorful Business Name, Blank Commercial Invoice Template, Free Commercial Invoice Template (UPS Style). There is no specified format for either a commercial invoice or a pro forma invoice, according to the U.S. Customs and Border Protection website. However, a commercial invoice must disclose certain required information, including a description and quantity of each item being shipped, the value of the shipment in both U.S. dollars and in the foreign currency, the country of origin, location of purchase, and the names and addresses of both the seller and the purchaser. U.S. Customs and Border Protection does not require the same information on a pro forma invoice.

...(103)...

(From Detail Page - about 212 words) - While you can find many commercial invoice formats on the Internet, most of them are PDF documents which require a PDF editor program to work with, such as Adobe Acrobat. And if you have number to calculate on the invoices - surely you have on an invoice - it is hard to automate the process with PDF format. Here, you see one of the important advantages of Excel spreadsheet templates - it is very easy to do such calculation (make the calculation automated) in Excel sheet with formulas. For example, in this implementation, the total number of packages, the total weight, freight, total invoice value and value of each line are all calculated automatically. And, Microsoft Excel is now able to generate PDF invoices too. If you have installed Uniform Invoice Software, generating PDF commercial invoices can even be done with a single click of mouse. Here you see another key advantage of Excel invoice templates (all templates here on InvoicingTemplate.com are firstly published in Excel format - most in xlsx format, and some of them in xls format) - they work well with Uniform Invoice Software. If you want to create electronic invoices - the paperless way of doing invoices, Uniform Invoice Software will help you done the job with easy.

(From Detail Page - about 61 words) - All fields on this template are fillable, including Federal Express International Air Waybill Number, Date of Export, Export References and those checkboxes on the bottom of the form - FOB, C&F, CIF, except the "SHIPPER" and "DATE" fields located on the very bottom of the form. These should be manually signed, and thus not be stored into Uniform Invoice Software database.

LEARN MORE PDF

5. Singapore GST Invoice Template (Sales)

"Singapore GST Invoice Template (Sales)" was found to be relative to Dhl Commercial Invoice Form with the score grade of 55.

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

...(123)...

...(85)...

1. the words "tax invoice" in a prominent place
2. an identifying number (Invoice #)
3. the date of issue of the invoice (Invoice Date)
4. the name, address and registration number of the supplier
5. the name and address of the person to whom the goods or services are supplied
6. a description sufficient to identify the goods or services supplied and the type of supply
7. for each description, the quantity of the goods or the extent of the services and the amount payable, excluding GST
8. any cash discount offered
9. the total amount payable excluding GST, the rate of GST and the total GST chargeable shown as a separate amount
10. the total amount payable including the total GST chargeable and
11. if the amount under (9) to (10) above is in foreign currency, the corresponding Singapore currency has to be indicated

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

(From Detail Page - about 67 words) - Although this template is named with "Singapore", if you are from a country or region that has the similar taxing and invoicing requirements, such as Hong Kong and Malaysia, you can also use it directly, or use it as a starting point of creating your own template. All templates here on InvoicingTemplate.com are not locked with password, so you are free to do any customization you like.

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

LEARN MORE PDF

6. Plumbing Service Invoice Template (Sales Tax)

"Plumbing Service Billing Template (Sales Tax)" was found to be relative to Dhl Commercial Invoice Form with the score grade of 53.

(From Detail Page - about 38 words) - Plumbing Service Invoice Template (Sales Tax) is a 4-column variant and alternative of the 2-column plumbing invoice template. The 4 columns that are printable on this service plumbing invoice template are Quantity, Description, Unit Price and Line Total.

(From Detail Page - about 61 words) - We've also modified the taxing system in this Plumbing Invoice Template (Sales Tax). The original plumbing invoice template, c2008 Plumbing Contractor Invoice Template and c2009 Plumbing Contractor Invoice Template (Landscape), are designed with VAT tax in mind. In this sample plumbing invoice template, InvoicingTemplate.com changed it to sales tax, and the Taxable column is also moved into the printable invoice form.

(From Detail Page - about 23 words) - The tax options supported by this plumbing service invoice template is similar to the default sales invoice template shipped with Uniform Invoice Software.

...(96)...

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

(From Detail Page - about 63 words) - Unlike the default sales invoice template, this Plumbing Service Billing Invoicing Template (Sales Tax) also has the Taxable column moved into the printable area. The taxable column is implemented as a column of checkbox, that each checkbox controls whether the corresponding item is taxable - if the box is checked, the current item is counted when calculating taxes; otherwise, it will be excluded.

...(54)...

(From Detail Page - about 65 words) - The protection of the Invoice worksheet in Plumbing Service Invoice Template (Sales Tax) 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 Plumbing Service Invoice Template (Sales Tax).

...(136)...

...(67)...

Note that if you use the Uniform Invoice Software and need to show the control on an extracted invoice, then the control should be named with an "oknWidget_" prefix. For example, if you move the Taxable checkboxes into the printable invoice form, then the checkboxes should be named with "oknWidget_" prefix, such as oknWidget_taxtable1, oknWidget_taxable2, oknWidget_taxable3...

(From Detail Page - about 15 words) - Once your design work is done, make sure you protect $PageTitle and exit design mode.

(From Detail Page - about 17 words) - With this invoice layout, we've also changed the currency symbol from UK pound sterling to US dollar.

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

(From Detail Page - about 62 words) - One thing to note is that InvoicingTemplate.com tested the templates, including Plumbing Service Invoice Template (Sales Tax), on Microsoft Windows (with Excel, not Word) only, and the testing on Mac was usually not performed. If you need to run Plumbing Service Invoice Template (Sales Tax) on Mac, test it with Mac version of Microsoft Excel before you apply it for production purpose.

LEARN MORE PDF

7. Canadian Invoice Template with HST

"Canadian Invoice Template with HST" was found to be relative to Dhl Commercial Invoice Form with the score grade of 49.

...(40)...

...(42)...

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

...(24)...

(From Detail Page - about 236 words) - Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in Canadian Invoice Template with HST 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 Canadian Invoice Template with HST 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 Canadian Invoice Template with HST 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.

LEARN MORE PDF

8. One Tax Column, Summary on Top

"One Tax Column, Summary on Top" was found to be relative to Dhl Commercial Invoice Form with the score grade of 29.

(From Detail Page - about 21 words) - This "One Tax Column, Summary on Top" invoice template is a variant of "One Tax Column, No Shipping Address" invoice template.

(From Detail Page - about 60 words) - This is also a service invoice template, which as no big difference as compared to the original version. If you are familiar with Excel, it could be created by yourself easily by just moving the cells. We publish it here on InvoicingTemplate.com just for someone who is not familiar with Excel but still want to make their invoices look different.

(From Detail Page - about 57 words) - Uniform Invoice Software, our invoicing program that you can download and try for free, uses invoice templates in Excel format as its front-end, and connects the template with back end database for storing and managing large amount data. We are sure that you'll find this is a completely different invoicing system than that pure-Excel based invoicing solutions.

LEARN MORE PDF

9. New Zealand Tax Invoice Template

"New Zealand Tax Invoice Template" was found to be relative to Dhl Commercial Invoice Form with the score grade of 28.

...(31)...

...(214)...

(From Detail Page - about 26 words) - This template, New Zealand Tax Invoice Template, or New Zealand Tax Billing Form, is implemented in a way so that the prices does not including tax.

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

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

...(58)...

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

...(143)...

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

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

LEARN MORE PDF

10. Plumbing Contractor Invoice Template (Landscape)

"Plumbing Contractor Invoice Template (Landscape)" was found to be relative to Dhl Commercial Invoice Form with the score grade of 12.

(From Detail Page - about 36 words) - Plumbing Contractor Invoice Template (Landscape) is a variant of c2008 Plumbing Contractor Invoice Template. It differs from the original Excel invoice template in that the layout is suitable for printing on A4 paper in landscape orientation.

...(94)...

(From Detail Page - about 95 words) - Like Microsoft Word, Microsoft Excel allows you to set paper options through its Page Setup dialog box. In Excel 2003, the Page Setup dialog box can be opened by clicking Excel menu File > Page Setup. With Excel 2007, Excel 2010 and Excel 2013, the command for opening Page Setup dialog box can be accessed through Page Layout ribbon tab > Page Setup group and then click the arrow button on the group. The Page Setup dialog box offers various options for you to control the printing and layout of Plumbing Contractor Invoice Template (Landscape).

...(18)...

...(22)...

(From Detail Page - about 222 words) - Before you can hide a row, make sure the Invoice worksheet of Plumbing Contractor Invoice Template (Landscape) is unprotected and row / column headings are shown. To hide a single row in Plumbing Contractor Invoice Template (Landscape), first right click on the row header of the row to be hidden; Choose Hide from the menu; The selected row and the row number will be hidden from view. To hide adjacent rows in the worksheet, for example, you want to hide rows 14, 15, and 16 in the Plumbing Contractor Invoice Template (Landscape): In the row header drag select to highlight all of the rows you want to hide; Right click on the selected rows; Choose Hide from the menu; The selected rows and row numbers will be hidden from view. To hide separated rows in Plumbing Contractor Invoice Template (Landscape), for example, you want to hide rows 3, 5, and 7: In the row header left click on the first row to be hidden; Press and hold down the CTRL key on the keyboard; Continue to hold down the CTRL key and left click on the rest of rows to be hidden; Right click on one of the selected rows; Choose Hide from the menu; The selected rows and row numbers will be hidden from view of Plumbing Contractor Invoice Template (Landscape).

...(60)...

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

LEARN MORE PDF