Collaborate on Ms Excel Bill Sheet for Retail Trade with Ease Using airSlate SignNow

Ms excel bill sheet for Retail Trade

Hello friends automatic stock management automatic Inventory management purchase purchase return sales sales return Net stock profit 2 then price without G am then 28 GST total 128 in the total am the GST am that means price into GST then amse Quan amount then purchase return sales sales return then I mean Net stock means or less profit profet purchase net sales Quan cost total am then a moment oil 250 okay then sales okay fine that means net purchase and net sales Okay purchase and details just [Music] F automatic Inventory management software prepared first first sheet main second one purchase third one purchase next sales sales return Net stock profit net P ands now net purchase and sales next one products list then G1 then B3 particular then next period then quantity amount then G3 product then quantity amount then e r in the that means A8 dat next ID then products then party name then quantity then at the S price then GST amount total the I column okay okay then font size then then then then then size then color okay the home mid alignment okay then3 then purchase report then thick outside bord okay then then color F then font color okay then keybo next F coloro then my table has head then all borders then first row eow next products for example Samsung 4 GB R 64 memory then mobile 4 GB Ram so 4 then 64 64 memory mobile okay then Sony TV 32 in Sony then TV data tab dat validation Val then [Music] products product validation then L then okay okay thene dat data valid then look open then lookup value table AR function then column index number products column second column so then next party name next GST section GST column in theck Val then percentage comma 5age comma 12 percentage comma 18 percentage comma 28 percentage okay okay CLE okay we look open look up value the product ID that means product codeck then comma table array then TV 32 18 GST 250 then price price without GST GST then plus price sel5 okay okay then total C total 105 into 15 Quan okay then plus into into then g575 Indian currency symbol right cck format Sals then currency simple indianen then range then crer bracket close then ENT okay then equal sum if range range product ID crer Su range total amob dat wise month wise 4 dat if bracket open range range criteria function am then custom General okay 1 4 2020 equal greater than Sy equal function key then date column double quation less than symbol equal andb table year wi purchase quane am then in the S click equal Su if bracket open sum range then comma double quotation greater than symbol equal double quotation close then and andb then open comma 1 comma 1 bracket close Comm then double quation less than symbol equal and symb 12 comma 31 close bracket then table one toal meane then purchase return then F color okay then sales report sales report okay different color sales return okay F then second R second ser number products product ID quantity minimum quantity amount remainer size alignment B then color then Home Center size 20 mid alignment then color yellow okay next in the okay all borders okay okay fine next Net stock bracket open range purchase sheet product criteria crer minus Sal sheet purchase minus sales minus purchase return plus sales return okay product ID then criteria range add then minus minus range range then rangee return bracket CL then range sales return purchase minus sales minus purchase return plus sales then look up value product ID table AR product idum index number induct ID column 1 2 3 4 5 6 7 the am column in the column G Thena then Z bracket close cck mobile okay 15534 13 okay equal 13 into am34 equal if bracket open quantity column then less than equal minimum double double quotation formatting P highlight cell RS then text that contains format cells that contains the text place order B1 profit I home then C then F in the sell products ID then quantity cost total quantity cost total profit tax percentage amount net profit SI then mer Center alignment okay any color then font okay then mer Center alignment size 20 color fill yellow all all bers okay then color then font color white okay merer okay sales okay okay fine then mer Center mid alignment center mid alignment okay mid alignment Merin Center mid alignment net profit Merin Center mid alignment okay okay formula equal Su if bracket open range purchase sheet Su rangeet close minus Su if bracket open then range criteria profit rangee return purchase quantity net purchase quantity that means net Purchase cost equal we look look value look value comma table array purchase sheet purch IND number IND number bracket CL double two times then bracket CL equal then quantity into cost ental am 1 into 118 equal 13 into 118 correct next sucket open range sales sales return sales return in the net purchase minus purchase return quantity net sales quantity sales minus sales return that means sales quantity minus sales return look look value table AR Sal sheet am sales then then remaining total calculation equal quanti into cost okay thenice then salice sheet 100 177 okay profit equal brackes cost that means net sales cost minus Purchase cost bracket close then into bracket open remaining tax perc the that means okay 2 20 okay quantity okay price okay okay 3 5 20 20 product name oil 250 Okay Okay purchase return Then sales purchase 100 okay then 4 5 20 20ct okay price 140 price 140 quantity 10 then sales return 6 5 2020 same product okay oil 250 140 okay tax amount that means GST percent GST am that means that am 21 rupes okay then equal profit minus then G two times then total okay dou two times okay next bracket two times then then double quation two times remaining okay then delete then total equal sum okay tax percent return sal sal fin net purchase and sales quantity amount date wise then the serial number 1 to 365 then purchase Quan Cal equal if then criteria the she the dat cck then range then minus open then criteria in the DAT cck comma SU return Then amount equal sum if bracket open range criteria then range minus then bracket opene return sheet crer then okay okay 1,77 right 236 okay 1,770 minus 2 236 okay check, = 1,770 minus 236 nextus bracket return she particular 14 2020 sales return 15 sorry same 15 minus 15 equal open range dateria then range then then sheet then crer in the sheet then Su range Sal return 2,665 sales return 1,77 check 2,6 55 okay check equal 2,665 minus sales return okay 885 okay remaining next datse monse equal Su if bracket open sh function fange next salal Su if bracket open range the control shift down key function then then range then bracket close nextal sucket Su range contr shift down then crer range shft function double quotation greater than symbol equal double CL and symbol then April shift down double quotation less than symbol equal double quotation and symbol then function [Music] sales equal sum e bracket open sum okay key function double quotation greater than symbol equal double quation close and symbol then ail function less symbol equal double quotation close and symbol e two times equal sum if bracket open shift down arrow key function key function double quotation greater than symbol equal symbol double quotation and symb open F 1A 1ck shift down function double quotation less than symbol equal double quotation and symb I mean then1 bracket two times okay3 fine okay okay right edit text first purch purchase Okay purchase report fine size INE okay size is increased to 24 okay B then mid alignment center alignment okay purchase report F okay second one then control V third one okay again control V fourth one okay first one purchase report again purchase return r e t u r n purchase okay copy okay sales then sales return sales return okay stock Net stock okay then next one profit profit okay fine purchase report purchase return okay sales sales return Net stock profit Center AO aut atic stock management type automatic stock management size INE okay alignment okay fine okay then place in this document okay okay then sales next one sales right sales click okay then stock right click link then stock click okay then purchase right click link purchase okay then sales return right cck sales return right okay then profit right click right click okay okay f okay right click GRE okay right click right click okay right click right click cck home right click link okay underline REM b b okay then next stock right click a link main okay size 20 control B bold okay sze return right click link main okay size then sales right click link main okay REM size 20 contr b bold Okay purchase return right click link main okay and remove then 20 control b b Okay purchase purchase return sales sales return Then profit thank you for watching