Create a Commercial Invoice Format in Excel for Inventory Management with Ease

Commercial invoice format in excel for Inventory

[Music] hello welcome to Sonic a commercial moisture Nader in this video I'm going to show you how to generate a commercial invoice easily to create an attractive moist of your company this video is Excel template makes easier titian invoice and sell your customers less time takes the national two sections basically attempt consists of three main sections emotion enter product or service database image the course and trick firstly you need to put your product or service in point database section that you can create or immersed in the generator section and allows your customers in the Picard section now let's start with the input our product in the state of s before that we need to identify all units because when needed our practice unit employees vital part so as default is bezel-set each box kilogram and ours responsible personal be ing to the tracking section to be able to follow who created the image later you can add or remove people from the list now in the info section you can write your unique product description and the information it can be website or any extreme let's create dummy product as an example and website link and I will use kilogram as Ignat and $215 and your currency will be appearing here because I've already set your currency on the dashboard after that click generator section here is a commercial invoice first of all in this section I will write my assigned information before I put in the consignor name shipper and their addresses and daily information and remarks like Incoterms HS code payment and so on hello you can select your product or service items from the drop zones plan click drops you will see your products let's select my Denning example from here as you can see the extra information' line units unit price niche price appear on my invoice is and at the bottom of the page you can see your total discount and net below and also you can show or hide or total discard from this drop-down additionally you can show these cons on your invoice or hide it finally you can easily export document as a PDF in order to set in your folder but if you do not record the MOS before that we want you to record it click yes and see your people yes invoice is ready you can also print this PDF after that you can check all our pessimists from the tracking section here our dubbing product is recording to this section that's all I prepared my commercial invoice text is ready to use excel template build a few minutes you can use this template over and over again for older products and silence thanks for watching and do not forget to check our other emotion ranges from sonica website thank you [Music]