Collaborate on Shop Bill Format in Excel for Banking with Ease Using airSlate SignNow

Shop bill format in excel for Banking

so go to page layout so i'll make it [Music] and [Music] all right [Music] shop number 16-26 [Music] one two three four foreign [Music] [Music] invoice voice number right and foreign [Music] so make this format i'll just change the date format cell format format cell just general zero seven zero four zero seven two zero night copy so i'll just format this cell format cell [Music] [Music] is format cells general text okay zero zero one so here okay invoice number invoice so jane dweller's let's go all right let's upload [Music] um 24 okay so line wrap once again you have to have wrap text like this and address so we'll go for the descriptions and all those things now so i'm logged in a key product details serial number for description rate quantity and amount so this will be serial number so i just don't want to make this line i'll just remove it no border from here i'll start so this will be my sl number and example product description lmrt cells much description description um and here it will be uom which is unit of measurements and this will be per gram rate so i'll just increase the size and this is much more centers per gram and the rate much rit rate and any remarks so this will be total sorry uh rate capital a or extraterrestrial so this will be [Music] so this will be program okay and this will be rate rate and tax or else you can say gst and so gst also will be in the same way so including gst application with our map all right so i will just um oh it's a letter i'll just go for a4 size so now you'll get the exact one so now the people say to a4 so that means this is correct now i'll just make some lines so um yeah so borders um box photos but i will not make it like this nicolette border none sorry i should merge this cells right merge and rate merge it and yes in total so i just don't want to show i'll just remove the lines now just left and right lines so more borders up down yeah this is okay for me first i have to remove this border water sorry i have to know borders the custom border this one and only this one now i'll do the same thing to this um also i'll first remove the border and add the outside border so this is done sorry merge across okay i just want to make it much across just now it does something else so this is correct now yeah so i'll do the same thing for this also no border and what would i say round border you got it so this is the total value don't worry i'll decrease and increase the sizes later but first we'll concentrate on the calculation part is [Music] taxi so much across and merge across net amount um is this may be zero or this may be zero [Music] description or bankruptcy so here i'll use the signature kelly i used for for so in so on the company name whatever we have taken so that will come here much center right alignment foreign terms and conditions okay so i'll write one point here which i have remember regularly votes once sold will not be returned back and um subject to subject to hyderabad subjection engineering details so much sense so yeah for my foreign merge across so i'll write bank name bank name and ifsc support rfc code bank branch across so type [Music] so by your right alignment where it's right right right right one two okay i'll just for now i'll leave it off but to make it perfect i am doing this all things one six so this all should be formatted to text so format cells text okay and this will be a n b 1 3 0 9 1 2 3 branch i'll just make it like this so if anything is missing we'll add it later okay we'll work on the calculation part now the best part of my so let's go recording right right so serial number will be as it is so we don't need to worry about the serial number mostly so i'll just pick it to one two and drag it off you know okay i'm receiving that means 26 um right so this is perfect so i want to bore these things bold and make it center if possible this will be right alignment because it's an amount so we'll do the calculation part now i think this is not necessary the serial number 226 depending on the customer numbers you'll just add numbers so i'll just delete them and make it one for now and description will be silver 40 into photograph i'll add the quantity also so i'll just i'll remove it and i'll remove this merchant center so gram quantity qty quantity and rate so it will also be right alignment all right quantity also right so quantity so per gram i'll notepad for now text document notepad sorry notepad and i'll just do the calculations in cg here 40 rupees into 10 will be our value 400 [Music] [Laughter] 400 and 238 so this will be our 380 rupees sorry sorry not that it's wrong 40 into 10 so per gram 48 10 grams yeah sorry for the disturbance guys okay i'm free now so here you can see 40 rupees is per gram into 10 will give you the total grams 400 400 rupees is the total weight and the rate is 38 i'll do into 38. that will give you the value so 400 into 38 will give you the value which is gross amount so it is three percent will give you one value divided by one zero three so this is the tax value what is 442.718 so i'll do this calculations now um and we will get that this is the tax value and this is the total value now we'll see what will happen i will just do this into this this okay so here i'll just click on this sum this okay okay okay so it's clearly i'm getting a calculation sum open bracket this is into symbol into this field or close it and again make it into this field close it off we'll see whether the calculation is going correct or not i'll just leave it this so 1500 is our first value so 15 200 we got the 15 200 here total and we'll just see the tax value also three percent here three percent tax anyway so this divided by this this into this divided by this okay so we'll do this so we'll get the net amount first we'll do the taxes okay divide by two so three 1.5 1.5 will be um is equals to some open bracket this into j10 into three gst divided by divided by 1 0 100 plus this one close i think it's okay one second i'm not sure this is correct process i'll just make it a decimal ways format cells number decimal two places okay once again i'll do it not sure this is exactly what we're looking for so 1500 into gst divided by 100 plus three percent usu or sorry three percent okay so it's giving you 459 so 442 is the correct answer okay so this will be the total amount divided by 2 because we are making it in half the same formula for this also i should do the same thing copy so i'm just pasting it here right 229.50 229.50 i'll just cross check this by modulating the exact value so i'll just do this and check it out so we can do this in some other ways also just a second so what i have done was exactly not the correct thing i'll do once more so this sum this total amount into this gst tax sum divided by 100 plus gst close divide by two this will also give the same value what's happening divide by two so i'll just close it this right here divided by 100 sum j public 10 into 10 one second for now this is this one second so total amount okay so this will have the same formula copy sorry and paste it here so this will also be a decimal value properties format cells number decimal values too got it so this is our total amount um so in the next video i can show you now let me do anything calculation here i'll do something like say 50 50 rupees per gram and quantity will be 20 and for rate will be around 40 rupees so you can see 15 to 20 50 15 to 20 will be 1000 into 40 will give you 40 000 so the same calculations will be here also 40 000 and 60.61 not 1.50 601.50 so i will work on the test structure in the next video but we can we'll try to add one logo also here so insert picture i'll just click on downloads and see if i have anything oh this is too big [Music] something like that so i'll remove the text in [Music] i'll this try to print something here and print we'll just try to print it okay we'll see how it's going to look like i'll show you a format that it shows yeah so does a small changes current this is like this we can do this like this so right alignment so total amount will increase the size and will make it bold you can give some underline need to look a little bit more good to feel about like this okay like this and border underline something like this or it's not necessary okay this will move it to some next upline positive right now i'll try to show a print how it's going to look like in our printer so i'll just save it so print so i'm printing it my desktop so i'm just saving so this is a sample invoice right so i'll just minimize them i'll see in my desktop how it is going to save where is that yeah it's here sampling awesome so this is how our print is going to look like so this is what we wanted right so this is how the invoice looks like so in the next i'll don't worry guys i'll share this doc on this excel file into your in my website you can download it from there so thank you thank you very much