Skip to main content
InvoicingTemplate.com main content
sharing is caring! we do appreciate your time to let others know us!

Commercial Invoice - FedEx Style

c9002
Commercial Invoice - FedEx Style

Note that there are two styles on FedEx, FedEx Express and FedEx Ground international shipping. This sample follows the one for FedEx Express. The Commercial invoice serves as an important document international trading, especially for the customs clearance process. Customs officials use commercial invoices to classify your merchandise. This in turn will help them in correctly assessing the applicable duties and taxes. Commercial invoices, like a bill of lading, one of the important documents used in international / foreign trade.

Commercial Invoice Template with Colorful Business Name

c7022
Commercial Invoicing Form with Colorful Business Name

Like most other invoicing templates available here on InvoicingTemplate.com, with the original Commercial Invoicing Template the company/business headings and the big "INVOICE" label are all general Excel cells. They differs from the other text labels on the spreadsheet with only font size and colors. With this customized design - Commercial Invoice Template with Colorful Business Name, they are replaced with text box and a litter bit of word art is also added. Suddenly, the original general commercial invoicing form looks bright and shines.

Commercial Invoicing Template (UPS Style)

c7025
Commercial Invoicing Sample (UPS Format)

If you are in the business of import and export, you need to understand the difference between pro forma and commercial. These are both key documents while dealing with customers. Goods, merchandise and documents that are imported or exported between countries must typically include appropriate documentation, which may include either a commercial invoice or a pro forma invoice. While both types of documents share a number of features, they have significant differences. Once after agreeing the terms of contract of sale, the buyer has to issue a purchase order or Letter of Credit. Just before this process, the seller has to send a "pro-forma invoice" to buyer, mentioning complete details of agreement of sale. Normally, purchase order or Letter of credit is opened on the basis of this pro-forma invoice sent by the seller. Once the seller receives the purchase order, he gets a confirmation to send the goods. He now ships the goods to the buyer along with a commercial invoice. The commercial invoice is more like an invoice and the legal document of the actual sale. This document is used to record the AR for the seller and AP for the buyer.

Excel Quotation Template

c9008
Excel Quotation Format with Special Discounting Model

On the bottom of the form, you'll find the usual "Subtotal", "Discount" and "Total" fields. There is also the "Last Balance" field and the "Total Due" cell. The "Last Balance" cell has its field name set to "oknAccountBalance", which is filled whenever you fill in the quotation form / estimation form with an existing client by using the on-sheet picker button, you by enter the client# into the "Customer#" cell (also located outside of the printable quotation form, at $U$2). See Invoice with Previous Balance (Sales) and Invoice with Previous Balance (Service) for more information on how to show previous balance on the form. The "Total Due" is the sum of the previous account balance and the total of the current quotation.

Excel Payment Voucher Template

c5052
Payment Voucher Template

InvoicingTemplate.com also offers the Uniform Invoice Software version of this Excel Payment Voucher Template / receipt template. The Uniform Invoice Software version is also free if you have Uniform Invoice Software installed, and it has exactly the same layout as the freeware edition of the Payment Voucher Template, but with many buttons on it, such as "Clear & New", "Save To DB", "Exact / Email", "Print". Uniform Invoice Software, as the name suggests, is our invoicing software that has the ability to make any invoicing templates available here on InvoicingTemplate.com a complete invoicing program that is able to manage customers, products, invoices and payments. For example, if you click the "Clear & New" button, the payment voucher form is cleared and is ready for you to enter a new payment voucher, with several fields filled with default data - for example, the current date is filled into the "Date" field. If you click "Save To DB", the current voucher is saved to backend database and a voucher# is generated automatically. If you click "Exact / Email", a standard Excel spreadsheet is created and the current voucher is copied to the newly created Excel spreadsheet file, which you can email to your client. You can also create a PDF voucher document using Microsoft Excel.

General Quote Template for Excel

c2035
General Quote Template for Excel

Due to this difference, it is important to clearly identify the document type on the header - whether it is a quote or an estimate. It is also useful, at least in some business areas, to include an expiry date on the document, if your prices are subject to change on the time. In this sample, we added it as a custom field "ExpiryDate". This field is defined as "text (100)" in the backend Access database, and the corresponding cell is named "oknExpiryDate" on the top quote form.

Job Estimate Template for Excel

c4084
Job Estimate in Excel Format

This job and work estimate template in Excel spreadsheet format is a design based on c4009 Service Proposal and Quote. With this blank sample template, we move in the "ESTIMATE#" cell and the "Item#" column.

Donation Receipt Template for Excel

c1004
Donation Receipt Format for Excel

Third, it is also required to clearly describe the donation, including the date the donation was made, as well as the amount of the donation.

Labor Invoicing Sample

c4070
Labor Billing Format for Excel

This printable labor invoice template covers job descriptions, hours, rates and total amounts, as well as the general fields for invoices such as invoice#, invoice date and payment term. It calculates taxes, subtotal, discount and total using Excel formulas.

Parts and Labor Invoicing Format

c4071
Parts and Labor Billing Format for Excel

This parts & labor invoice template in Excel spreadsheet format divides the invoice detail section into two parts, one for labor where the calculation of line totals is based on hours and rate; the another section for parts and materials, where line total calculation are based on price and quantity.

Excel Shipping Invoice with Printable Truck Background Image

c5087
Shipping Invoice with Printable Truck Background
  1. Again, make sure the "Invoice" worksheet is in design mode.
  2. Click to select a "pick up" (magnifying glass icons) button.
  3. Hit DEL key on keyboard.

General Purchase Invoice Template (Service, One Tax)

c2026
General Purchase Billing Template (Service, One Tax)

In order to create this template - "General Purchase Billing Template (Service, One Tax)", we moved out the shipping address fields out of the "Print_Area" range. In Excel spreadsheet documents, the range name "Print_Area" defines what part of the sheet to print when you issue the print command. If the name "Print_Area" is not defined, the whole sheet will be printed; otherwise, only the range defined by the "Print_Area" name will be printed. Put it in other words, it defines what area is the printable invoicing form.