Collaborate on Tax Invoice in Excel for Procurement with Ease Using airSlate SignNow

Tax invoice in excel for Procurement

hi hello viewers welcome to my channel this is ravi in this video i'm going to show you how to prepare gst purchase and sales invoices reports in excel but before going to that a small request those who are visiting first time to my channel please subscribe my channel and share it to your friends now let us see the concept how to prepare gst purchase and sales invoices reports in microsoft excel okay right so first of all uh okay i'm preparing the heading right so for that i have selected some cells now i am clicking on merging center this option merging center oh here i am typing gst purchase gst purchase and sales in voice report okay okay so after that so i am giving here the font size is [Music] 26 i am giving and here i am selecting this one and i am giving the color red color and this is i'm giving bold okay so here okay i'm filling with this color okay so now so here i'm giving serial number after that invoice number invoice number so after that invoice state after that invoice state stock item stock item after that quantity rate taxable valued taxable value gst list in gst if we talk about gst here we have two types of gst so one is cgst that means central gst on one is state gst okay cgst and another one is yes gst so one is central gst and the second one is state gst okay right after that we have invoice value invoice value right okay okay like this okay right so after this one what we have to do means see here so here here gst is only one in that we have two one is cgst means central gst so another one is state gst okay so uh so here two cells are there only here one cell is there so that's why i'm combining these two cells okay uh selecting these two cells and clicking on merging center okay right so you observe here here cgst gst invoice value is there but all these cells are all these cells are empty only so that's why what i'm doing here serial number so i'm merging this align this cell and clicking on merging center right okay so after that up to here the cells are empty so what i am doing is here see here selecting this cell with right click with the right click i am dragging up to here cgst okay so whenever i leave the right click so you will observe here some option c here fill format only or fill without format that means only we need the format here only we need the format here so that's why here we need only formatting which formatting this formatting you would have the serial number only we need the formatting so that's why i'm giving here fill format only see here so whatever the cell is then so like that all cells are came so again am selecting this one and here alignment is there in the alignment i am giving middle align see here middle align okay so after that we have to select all the cells i am selecting all the cells here up to here after that i am filling with color okay i am filling with this color and i'm giving bold okay i'm filling that color okay i'm giving bold also okay right so after that we have to enter the okay see there now i'm entering serial number invoice number here i'm giving so here taking board okay so why 1 0 1 2 this is the invoice number after that invoice date for example 0 5 0 6 20 okay this is the date stock item for example here we are talking about the mobile phones okay mobile phones vivo vivo okay vivo mobile phone stock item and quantity how much quantity 20 after that rate what is the rate of that one for example 15 000 okay here tans taxable value what is taxable value so taxable value is nothing but the value of this does not contain tax without tax okay so how it comes means quantity into rate so quantity is in f8 and rate is in g8 so is equal to okay so this one into this one this is the taxable value means without tax so after that here we have gst in gst we have two types one is cgst one is sgst for the mobiles the gst is 12 percent in this twelve percent for central six percent and the state is six percent okay right is equal to so gst how we can give mean see here taxable value into six percentage why because central sixth percentage state six percentage so six okay percentage six percent is enter after that here also same formula is equal to taxable value into six percentage okay so then what about this value invoice value invoice value is nothing but so total tax value without tax and taxes that is equal to so which one so this one plus this one plus this one okay so this is invoice value so that means suppose if we have different different gst for different different products at that time we have to go for tally software but whenever we have a small data and only small products are there at that time we can use excel so like this but whenever we have huge amount of data huge different different uh dsardena at that time we have to go for tally okay so this is about suppose here you observe we have given the formulas so now what i am doing here is see here up to taxable value okay now so now i'm dragging this up right okay we can drag up to 200 300 000 2010 000 okay so now what i'm giving here is second one and that invoice number is y one zero one three here invoice date we have to give here for example 20 okay here i am giving 20 okay here the product is oppo okay right quantity is 30 and the rate is for example 16 000 okay you observe here so whenever only one time i have given the formulas all the formulas you observe here so whenever i press tab button all the values will come see here see automatically all the values whenever i press tab button from the keyboard all the values like taxable value gst sgst and invoice value okay so like this we can prepare so gst purchase and sales invoice report in microsoft excel okay so if you have any doubts or any queries regarding this video keep in comment section if you like this video please subscribe my channel so like it and share it to your friends thank you so much for watching this video