Canadian Commercial Invoice Template is a sub-topic of Blank Commercial Invoice . Here are our templates closely related to Canadian Commercial Invoice Template.
This Excel form has 8 columns on the detail section, including "Product ID", "Side", "Description", "Qty", "Unit Price", "Extended Price" (usually called "Line total" or "Amount" on other templates available here on InvoicingTemplate.com), "Client" and "ADP". the "ADP" column is calculated automatically based "Extended Price" and "Client", using an Excel formula like this (note the question mark "?" here indicates the line number on the detail section):
"Country of Export", "Country of manufacture" and "Country of ultimate destination" also have their locations moved in order to use less lines on the vertical orientation. Like the original design, this template has 8 columns too - "Harm. code", "No. of pkgs" "Type of packaging", "Full description of goods", "Qty", "Units of measure" , "Weight", "Unit Value" and "Total Value". The "SHIPPER" and "DATE" fields on the bottom of the form are designed to be signed manually.
A pro forma invoice only needs to include sufficient information to allow for a determination of duties and examination. Since there is no required format for either type of invoice, a commercial invoice and a pro forma invoice may appear virtually identical or they may appear radically different. You can find several samples on pro forma invoice templates too here on InvoicingTemplate.com, for example Proforma Invoicing Sample, Simple Proforma Invoice Template, Proforma Invoice Template (4th Sample, Landscape Page Orientation), etc. For a full list of the commercial and proforma invoice template available here, visit the category page at commercial and proforma invoice template.
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.
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.
Since this is an estimate template, the "Payment" button in the Invoice Manager for Excel (namely Uniform Invoice Software) edition is actually useless. It is kept in case you need to convert this estimate template into an invoice template for billing and payments. Also there is one tax named GST on the bottom of the form, which you can easily modify or completely delete it once the invoice form is unprotected.
If you prefer this lightweight invoice layout but still want a logo image on the form, it is easy to add one if you have the latest version of Invoice Manager for Excel (namely Uniform Invoice Software) installed. To do this, simply click the "Replace logo image" command on the "Invoice" ribbon tab. This will open a dialog box that asks if you want to add a new logo image since there is no default logo image placeholder on the form. Confirm that you want to add a logo image, and then browse to and choose the your own logo image. The newly added logo image will be in design mode, which allows you to resize and move the image, and there are even more options you can use to adjust the image if you right-click the image and choose Properties. The options on the Properties pane are provided by Microsoft Excel, but not Invoice Manager for Excel (namely Uniform Invoice Software). As you can see, one of the advantages of Invoice Manager for Excel (namely Uniform Invoice Software), compared to other invoicing solutions, is that it utilizes the full power of Microsoft Excel, so that you can easily design / customize the invoice form with familiar tools. This lightweight sales invoice template, just like the other invoice templates available here on InvoicingTemplate.com, are just samples on how to customize the default invoice template shipped with the Invoice Manager for Excel (namely Uniform Invoice Software) installation program, although they could be used directly without any modifications.
Step 1: Before doing our customizing job, first you have to back up the template.
Invoice Manager for Excel (namely Uniform Invoice Software) is our invoicing software that runs with desktop Windows and Microsoft Office / Excel. It is implemented as a COM add-in program that runs inside Excel, connects any compatible Excel invoice templates with back end database, providing features that could not be implemented with pure Excel templates, such as the on-sheet picker feature, in-cell lookup of customer, product or invoice records. The invoicing app also provides powerful reporting features - For example, with a few mouse clicks and then fill in the date range, you can generate a sales report for the specified date range. Unlike a pure-Excel invoicing solution, with Invoice Manager for Excel (namely Uniform Invoice Software) all the data are stored in a back end database, in either Microsoft Access or SQL Server format. With the Enterprise edition of Invoice Manager for Excel (namely Uniform Invoice Software), you can also hosting the database online and connect it via Internet, which means that you can access and share your data across the world. See help document included in Invoice Manager for Excel (namely Uniform Invoice Software) to find out more information on how you can upsizing from Access to SQL Server and how to connect to online SQL Server.
The other two custom fields on the form include "Site Code" and "Project". The 4 columns on the invoice detail section include "Description", "Quantity", "Unit Price" and "Amount". Each row on the invoice body section allows about 3 lines of text. The text on the item cells are formatted as left alignment on horizontal, and middle on vertical.
Like all the other Excel invoicing templates here on InvoicingTemplate.com, this invoicing layout for bike shop works well too with Invoice Manager for Excel (namely Uniform Invoice Software). By installing Invoice Manager for Excel (namely Uniform Invoice Software), which is our Excel-based invoicing software app, this simple Excel-formatted invoice template becomes a powerful invoicing software program that is able to manipulate your client, products, invoices / receipts and payments data, saving your time and effort on invoicing.