INDIAN INDIAN INSITUT INSITUTE E OF OF JOB-OR JOB-ORIEN IENTED TED TRAININ TRAINING G TALLY ASSIGNMENT Company Creation: [ Company Info (Alt+ F3) Create] Name Address
: :
'tatutory Compl#ane for 'tate #n /elep0one No 1o2#le No !ma#l Curreny 'ym2ol 1a#nta#n F#nan#al Year from *oo&s *e"#nn#n" from /ally ault ass4ord se 'eur#ty Control
: : : : : : : : : : : :
<> Name>> 9 !l"#n $oad %ol&ata Ind#a est *en"al ,-- -.opt#onal opt#onal opt#onal $s Aounts 4#t0 In5entory -67-876-67-876Not Appl#a2le Yes Name of Adm#n#strat Adm#n#strator: or: II;/ II;/ ass4ord: II;/6
'a5e t0e 'reen Create t0e follo4#n" Aount#n" roups: [ate4ay of /ally Aounts InforoupsCreate] Name of of roups =utstand#n" !penses
nder Current ?#a2#l#t#es
Create t0e follo4#n" led"er 4#t0 Appropr#ate roup and put t0e open#n" 2alane [ate4ay of /ally Aounts Info?ed"er Create] Name of Ledger !@u#ty '0are Cap#tal eneral $eser5e Cap#tal $eser5e ?oan from DEFC $an2#r ?td os4am# 5t ?td ro5#s#on for dou2tful de2ts =utstand#n" $ent =utstand#n" /elep0one 2#ll =utstand#n" A 1 C rof#t and ?oss Aount ?and G *u#ld#n" lant G 1a0#nery Furn#ture G F#ture
Account Groups Cap#tal Aount $eser5e and 'urplus $eser5e and 'urplus 'eured ?oan 'undry Cred#tors 'undry Cred#tors ro5#s#ons =utstand#n" !penses =utstand#n" !penses =utstand#n" !penses r#mary F#ed Assets F#ed Assets F#ed Assets
Amount .B---.B---B9B-B-----.B86-..B--6B--6B-3B--6,B68 ,B8.B-B86-B-66 8B,--
Computer G er#p0erals In5estment #n '0ares A2#r 5t ?td 'uraH ?td Clos#n" 'to& repa#d Insurane ?oan to !mployee Cas0 I C I C I *an&
F#ed Assets In5estments 'undry Ee2tors 'undry Ee2tors 'to& #n7 Dand Current Assets ?oans and Ad5anes (Assets) Cas0 #n Dand *an& Aounts
6-8B.6..B8B-.B---3B---.B8B-8B6.6B8-6B.-6,B633
Eo not reate Clos#n" 'to& led"er as 4e are ma#nta#n#n" ompany as Aounts 4#t0 In5entory Eo not reate t0ese led"ers alter t0e led"ers and put open#n" 2alane
*#ll 4#se deta#ls of 'undry Cred#tors: Ranbir Ltd Eate *#ll No -67-,7-9 -6.3 -.76-7-9 -6, 367-676-.-B
Goswami Pvt Ltd Eate -.7-676-67-376=n Aount
*#ll No -B6 -6,
Cred#t Eays .6 .6 .6
Amount B--,---6696--
Cred#t Eays 6B 6B
Amount 6B---,.B-.B--
Cred#t Eays .6 .6
Amount 63---6.----
*#ll 4#se deta#ls of 'undry Ee2tors Abir Pvt Ltd Eate -676.7-9 -.7-.76Suraj Ltd Eate -67-376367-376=n Aount
*#ll No '6.6 '63-
*#ll no '3-6. '8.B-
Cred#t Eays 6B 6B
Stock etai!s: At#5ate t0e follo4#n" opt#on #n In5entory Features (F66) Inte"rate Aounts and In5entory Yes 1a#nta#n 'to& Cate"or#es Yes 1a#nta#n 1ult#ple odo4n Yes (for Creat#on of odo4n) Create t0e follo4#n" 'to& roup [ate4ay of /ally In5entory Info 'to& roup] .
Amount ..B--66..B6.,B-
Computer G er#p0erals In5estment #n '0ares A2#r 5t ?td 'uraH ?td Clos#n" 'to& repa#d Insurane ?oan to !mployee Cas0 I C I C I *an&
F#ed Assets In5estments 'undry Ee2tors 'undry Ee2tors 'to& #n7 Dand Current Assets ?oans and Ad5anes (Assets) Cas0 #n Dand *an& Aounts
6-8B.6..B8B-.B---3B---.B8B-8B6.6B8-6B.-6,B633
Eo not reate Clos#n" 'to& led"er as 4e are ma#nta#n#n" ompany as Aounts 4#t0 In5entory Eo not reate t0ese led"ers alter t0e led"ers and put open#n" 2alane
*#ll 4#se deta#ls of 'undry Cred#tors: Ranbir Ltd Eate *#ll No -67-,7-9 -6.3 -.76-7-9 -6, 367-676-.-B
Goswami Pvt Ltd Eate -.7-676-67-376=n Aount
*#ll No -B6 -6,
Cred#t Eays .6 .6 .6
Amount B--,---6696--
Cred#t Eays 6B 6B
Amount 6B---,.B-.B--
Cred#t Eays .6 .6
Amount 63---6.----
*#ll 4#se deta#ls of 'undry Ee2tors Abir Pvt Ltd Eate -676.7-9 -.7-.76Suraj Ltd Eate -67-376367-376=n Aount
*#ll No '6.6 '63-
*#ll no '3-6. '8.B-
Cred#t Eays 6B 6B
Stock etai!s: At#5ate t0e follo4#n" opt#on #n In5entory Features (F66) Inte"rate Aounts and In5entory Yes 1a#nta#n 'to& Cate"or#es Yes 1a#nta#n 1ult#ple odo4n Yes (for Creat#on of odo4n) Create t0e follo4#n" 'to& roup [ate4ay of /ally In5entory Info 'to& roup] .
Amount ..B--66..B6.,B-
Name Dard4are 'oft4are
"nder r#mary r#mary
Can #uantities of item be added Yes Yes
Create follo4#n" 'to& Cate"or#es [ate4ay of /ally In5entory Info 'to& Cate"or#es] Name Input Ee5#e =utput Ee5#e Appl#at#on 'oft4are =perat#n" 'oft4are ames 'oft4are
nder r#mary r#mary r#mary r#mary Appl#at#on 'oft4are
Create t0e follo4#n" n#ts [ate4ay of /ally In5entory Info n#t of 1easure] /ype 'ym2ol No of Ee#mal laes '#mple s '#mple 1tr . Create t0e follo4#n" odo4n [ate4ay of /ally In5entory Info odo4ns] Name %ol&ata
nder r#mary
Address Address - * C0o4r#n"ee $oad %ol&ata 7 ,---.-
Create t0e follo4#n" 'to& Items: [ate4ay of /ally In5entory Info 'to& Item] All sto& #tems measured #n C'
Name D r#nter
Group Dard4are
Category #uantity Godown =utput Ee5#e 6-- %ol&ata
? ?CE 1on#tor
Dard4are
=utput Ee5#e
,8
%ol&ata
8B--
333---
Ae Ae Aou Aount# nt#n" n" 'oft 'oft4a 4are re 'oft4 'oft4ar aree
Appl Appl#a #at# t#on on 'oft 'oft
B-
%ol& %ol&at ataa
6BB-6BB--
,,B-,,B---
/ally 1ult# ser
'oft4are
Appl#at#on 'oft
6B
%ol&ata
.B---
3,B---
/' %ey2oard
Dard4are
Input Ee5#e
8,
%ol&ata
8B-
.6-6B-
!pson r#nter
Dard4are
=utput Ee5#e
8-
%ol&ata
BB--
..----
'ams 'amsun" un" ?CE ?CE 1on#t 1on#tor or
Dard4 Dard4are are
=utp =utput ut Ee5# Ee5#ee
B-
%ol& %ol&at ataa
BB3 BB3
..B ..B-
$ouc%er &ntries: -67-876$s .B-- pa#d for r#nt#n" #n as0 3
Rate 3B--
Amount 3B----
-67-876$s B--- pa#d for omm#ss#on #n as0 -.7-876$s B--- pa#d to $an2#r ?td 2y 0e@ue no 6-6.-6 a"a#nst referene no: -6.3
-.7-876$s B--- ree#5ed as d#5#dend 2y 0e@ue no 6B.-6 of AJI' 2an& t0e 0e@ue depos#ted #nto ICICI *an& -67-B76$s 63---- ree#5ed from A2#r 5t ?td #n 0e@ue no B8-- of *I a"a#nst *#ll no '6.6 and t0e same 4as depos#ted #n ICICI 2an& -67-B76$s 6B--- depos#ted #nto ICICI *an& -.7-B76$s .B-- pa#d for 'tat#onery #n as0 -.7-B76$s 3B--- pa#d for =utstand#n" /elep0one 2#ll 2y 0e@ue no 6-6.-. of ICICI *an& -.7-B76repa#d Insurane of $s 6B6.- adHusted 4#t0 urrent yearKs Insurane 0ar"es -.7-B76?oan to !mployee $s B---- adHusted 4#t0 'alary aL -67-76$s 9--- pa#d for =utstand#n" $ent #n as0 -67-76$s .----- ree#5ed from 'uraH ?td 2y 0e@ue no 6B,.6- of DEFC 2an& a"a#nst 2#ll no: '3-6. t0e 0e@ue depos#ted #nto ICICI -67-76$s B-- a#d for /ra5el#n" !penses
-67-76Furn#ture of $s B---- pur0ased from 1odern Furn#ture In5o#e No: 1FL---6 -67-76Cas0 4#t0dra4n of $s .B--- from ICICI 2an& 2y 0e@ue no6-6.-3
Cost Centre and Cost categories: o to Aount#n" Features (F66) and at#5ate t0e follo4#n" opt#ons: 8
a) 1a#nta#n ost entres 7 Yes 2) 1ore t0an one payrollLost ate"ory Yes Create t0e follo4#n" Cost ate"or#es: [Aounts Info Cost Cate"or#es Create] Cate"ory Name
r#nt#n" 1ed#a !letron# 1ed#a Car
Alloate $e5enue Items
Alloated Non $e5enue Items
Yes Yes Yes
No Yes No
Create t0e follo4#n" Cost Centres: [Aounts Info Cost Centres Create] Cate"ory Name !letron# 1ed#a 'tar Net4or& !letron# 1ed#a Mee Net4or& !letron# 1ed#a 'tar lus !letron# 1ed#a 'tar 'ports !letron# 1ed#a Mee 'ports r#nt#n" 1ed#a /#mes of Ind#a r#nt#n" 1ed#a /ele"rap0 Car *7-.7E76B. Car *7-37C7.-B
nder r#mary r#mary 'tar Net4or& 'tar Net4or& Mee Net4or& r#mary r#mary r#mary r#mary
-67-76$s 6---- pa#d for Ad5ert#sement #n Mee 'ports 2y C0e@ue no 6-6.-8 of ICICI 2an& -67-76$s B-- pa#d for Ad5ert#sement #n /#mes of Ind#a #n as0 -.7-76$s B--- pa#d for Ad5ert#sement #n /ele"rap0 #n as0 -67-,76$s 3B-- pa#d for Car epenses relat#n" to Car No *7-37C7.-B
-67-,76$s 6---- pa#d for Ad5ert#sement #n 'tar lus #n as0 -.7-,76$s ,B- pa#d for ar epenses relat#n" to Car No *7-.7E76B. S%ow t%e cost Centre report 'isp!ay
Statements of Accounts
)ank Reconci!iation Statement
B
Cost centre
Category summary(
ou0er Eate 6L8L.-6.L8L.-6.L8L.-66LBL.-6.LBL.-6.LBL.-66LL.-66LL.-66LL.-6-
art#ulars =pen#n" *alane $an5#r ?td Clear#n" Clear#n" Cas0 Eepos#t *'N? /elep0one Cas0 #t0dra4al Clear#n" AE A"eny
*an& 'tatement for t0e per#od of 67876- to .776C0e@ue Clear#n" No: Eate Eepos#t #t0dra4al
*alane
$s B-----
$s $s $s $s $s
6,B633-6,883-6,8B33-6,B33-6,B93--
6-6.-6 6B.-6 B8--
.L8L.-66LBL.-6.LBL.-6.LBL.-6-
6-6.-.
367B76-
$s 3B-----
$s
6,B33--
6-6.-3 6B,.66-6.-8
6LL.-6.LL.-6.LL.-6-
$s .B-----
$s $s $s
6,B33-6,,33-6,,.3--
$s B----$s 63-----$s 6B-----
$s .------$s 6------
*S &ntry '*a+ educted at Source( o to ompany features for 'tatutory G /aat#on (F66) and at#5ate t0e follo4#n" opt#ons: !na2le /a Eeduted as 'oure (/E') Yes 'et L Alter /ds Eeta#ls Yes /a Assessment Num2er Inome /a C#rleLard (/E') Eedutor /ype Name of erson $espons#2le 'onLEau"0ter of Ees#"nat#on
: : : : : :
A'C68B,' .3(.) =t0ers <> <> Aounts 1ana"er
Create t0e follo4#n" ?ed"ers: Ledger Name "nder
,s *S deductab!e
#pro ?td
'undry Cred#tors
Yes
Company7 $es#dent
A=C*6-8$
As0a Co7=perat#5e 'o#ety 'undry Cred#tors
Yes
Cooperat#5e 'o#ety
AN**6-9;
1r ; %apoor
'undry Cred#tors
Yes
Ind#5#dualLDF 7 $es#dent
A/%6-8%
AC! Computers
'undry Cred#tors
Yes
Ind#5#dualLDF 7 $es#dent
A/C6-8?
o&ul Co7operat#5e *u#ld#n" 'o#ety
'undry Cred#tors
Yes
Cooperat#5e 'o#ety
A/*6-81
Aept t0e /E' Eedutor deta#ls
Ledger Name
"nder
*ype
eductee *ype
Nature of Payment
PAN-,* No.
/ds on /e0 'er5#e
Eut#es G /aes
/E'
Fees for rofess#onal or /e0n#al 'er5#e
/E' on Comm#ss#on
Eut#es G /aes
/E'
Comm#ss#on on *ro&era"e
/E' on $ent
Eut#es G /aes
/E'
$ent of ?and *u#ld#n" =r Furn#ture
Ledger Name
"nder
Cost Centre App!icab!e
,s *ds App!icabe
efau!t Nature of Payment
/e0n#al 'er5#e
Ind#ret !penses
No
Yes
Fees for rofess#onal or /e0 'er5#e
Comm#ss#on !penses
Ind#ret !penses
No
Yes
Comm#ss#on or *ro&era"e
$ent
Ind#ret !penses
No
Yes
$ent of ?and *u#ld#n" or Furn#ture
ass t0e follo4#n" /E' entr#es us#n" ;ournal 1ode [Aount#n" ou0er ;ournal (F,)
*S on &+penses /0ourna! $ouc%er1 -.7-,76A 2#ll of $s ---- ree#5ed from #pro ?td for /e0n#al 'er5#e *#ll No: IL/e0L--6 and at t0e t#me of pass#n" of t0#s 2#ll /ds on /e0n#al 'er5#e also deduted
Accounting of Expenses and Deducting TDS Later -.7-,76A 2#ll of $s 6B--- ree#5ed from As0a Cooperat#5e 'o#ety for $ent *#ll No: As0aL$entL--6 /ds 4#ll 2e deduted later
Accounting Advance Payments -.7-,76- [D#nt: se ayment 1ode FB] $s 6---- pa#d as Ad5ane to 1r ; %apoor $ef no: AEL;%LC=1L--6 for omm#ss#on and /ds on omm#ss#on also 2e deduted from t0e ad5ane amount -.7-,76- [D#nt: se ;ournal 1ode F,] A 2#ll for omm#ss#on of $s 3---- ree#5ed from 1r ; %apoor *#ll No *?LC=1L;%L--B /0e 2#ll #s adHusted 4#t0 t0e Ad5ane amount pa#d $ef no: AEL;%LC=1L--6 and /ds on Comm#ss#on also appl#a2le on t0e rema#n#n" 2alane 2ut #t not deduted r#"0t no4
TDS on Expenses @ Lower Rate ,
02-07-10 A Bill received from ACE Computers for Rs.8! towards commission charges. ACE Computers has a certificate for deduction of Income ta at Lower rate @ "#! on Commission. Bill "o. B#$ACE$001
TDS on Expenses @ $ero Rate 02-07-10 A Bill received from %o&ul Co-operative Building 'ociet( for Rs.%!! towards )ent on Building and *urniture. &o'u( )o*operative +ui(ding Society has a certificate for non*deduction ,-ero rate of /ncome tax on Rent. Bill "o. B#$%CB'$001.
ass t0e follo4#n" /E' Eedut#on !ntr#es us#n" ;ournal 1ode 4#t0 /E' Eedut#on (A?/+ ') -.7-,76ass t0e /E' Eedut#on entry for As0a Cooperat#5e 'o#ety a"a#nst *#ll No: As0aL$entL--6 -.7-,76ass t0e /E' Eedut#on entry for 1$ ; %A==$ a"a#nst *?LC=1L;%L--B -.7-,76=utstand#n" Amount of #pro ?td pa#d 2y 0e@ue no: 6-6.-B of ICICI *an& -.7-,76=utstand#n" 2alane of $s 1r ; %apoor leared #n as0 367-,76=utstand#n" amount of As0a Cooperat#5e so#ety pa#d 2y 0e@ue no : 6-6.- of ICICI 2an&
S%ow t%e *S Computation report and *S 2utstanding Report. 'isp!ay Reports 2utstanding *S Payab!e
Statutory Reports
*S
367-,76a#d all /ds paya2le amount 2y 0e@ue no: 6-6.-, of ICICI *an& ass t0ree separate payment entry ment#on#n" same 0e@ue no C%eck *S 2utstanding Report C%eck t%e print preview of 3orm 45A 'isp!ay 3orm 45A(
Statutory Reports
*S Reports
Purc%ase 6 Sa!es wit% $at Go to Company 3eatures of ,nventory 3eatures /3441 and activate t%e fo!!owing options Allo4 - 5alued entr#es #n 1aster Yes [For man" entr#es 4#t0out any amount]
Allo4 pur0ase order roess#n" Yes [For reord#n" ur0ase =rder]
Return
Print
se /ran" num2er (Eel#5ery and $ee#pt Notes) Yes [ For enter#n" oods $ee#pt Note( ur0ase C0allan) and oods Eel#5ery Note ('ales C0allan) se $eHet#on In4ardL=ut4ard Notes Yes [Normally us#n" for "oods returned after 0allan and 2efore 2#ll#n" 2ut #t 0as some ot0er appl#at#on also] 'eparate E#sount olumn #n In5o##n" Yes
Go to Company 3eatures of Accounting 3eatures /3441 and activate t%e fo!!owing options se Ee2#t Note and Cred#t Note Yes se Ee2#t Note for #n5o#e format Yes se Cred#t Note for In5o#e format Yes
$at Setup Go to Company 3eatures of Statutory 6 *a+ation 3eatures /3441 and activate t%e fo!!owing options. !na2le alue Added /a (A/) Yes 'et L Alter A/ Eeta#ls Yes 'tate est *en"al /ype of Eealer $e"ular $e"ular A/ Appl#a2le From 6787.-6A/ /IN ($e"ular) B,B,B88B,,6 Inter 'tate 'ales /a Num2er ,898BBBB AN L INC=1! /AJ N= : A;IM388C
Create t%e fo!!owing !edgers Ledger
"nder
6 ur0ase 8O AL . ur0ase 6.BO AL 3 ur0ase PCst AL 8 'ales 8O AL B 'ales 6.BO AL 'alesPCst AL
ur0ase AL ur0ase AL ur0ase AL 'ales AL 'ales AL 'ales AL
Yes Yes Yes Yes Yes Yes
Eut#es G /aes Eut#es G /aes Eut#es G /aes Eut#es G /aes Eut#es G /aes
*ype of uty A/ A/ C'/ A/ A/
, Input at8O Input at 6.BO 9 C'/ 6- =utput at8O 66 =utput at 6.BO
,nventory $a!ues are affected
Pass t%e fo!!owing purc%ase order entries:7 8479749
9
"sed in vat return
*a+ c!ass
Yes Yes Yes Yes Yes Yes
ur0ase 8O ur0ase 6.BO Inter7'tate ur0ase 'ales 8O 'ales 6.BO Inter 'tate 'ales
Input 5at 8O Input at 6.BO Inter 'tate 'ales =utput 5at 8O =utput at 6.BO
lae a pur0ase order to $ana2#r ?td =rder No =rdL$anL-6 ,*&; 6 Ae Aount#n" 'oft4are . ? ?CE 1on#tor
#uantity 6- ps 6B ps
8479749 laed a pur0ase order to os4am# p5t ?td =rder No =rdLDL-6 ,*&; 6 'amsun" ?CE 1on#tor . /ally 1ult#user
#uantity 6- s 6B s
8479749 oods ree#5ed from $ana2#r ?td a"a#nst order No =rdL$anL-6 C0allan No7 $NL$ANL-6 oods stored at %ol&ata odo4n
8479749 In5o#e $ee#5ed form $ana2#r ?td In5o#e No INL$ANL-6 a"a#nst C0allan No $NL$ANL-6 ,*&; 6 Ae Aount#n" 'oft4are . ? ?CE 1on#tor
#uantity 6- s 6B s
RA*& $s 63--$s 8B--
$A* 8O 8O
8479749 laed a pur0ase order to os4am# p5t ?td =rder No =rdLDL-. ,*&; 6 ? ?CE 1on#tor . /' %ey2oard 3 !pson r#nter
#uantity 6- s 6B- s .B s
8479749 oods ree#5ed from os4am# 5t ?td a"a#nst order No =rdLDL-6 and =rdLDL-. C0allan No $NLDL-6 oods stored #n %ol&ata "odo4n 8479749 Follo4#n" "oods ree#5ed from 'upreme /e0nolo"#es 5t ?td C0allan No7 $NL'/L--8 All "oods stored at %ol&ata "odo4n ,*&; 6 ? ?CE 1on#tor . D r#nter 3 8 * 1emory Card
#uantity 6- s 6B s ,B s
8479749 . s 'amsun" ?CE 1on#tor $eHeted and returned to os4am# 5t ?td a"a#nst C0allan No $NLDL-6
6-
[D#nt: se $eHet#on =ut] 8479749 In5o#e $ee#5ed from os4am# 5t ?td In5o#e INLDL-6 a"a#nst C0allan No $NLDL-6and ,*&; 6 'amsun" ?CE 1on#tor . /ally 1ult# ser 3 ? ?CE 1on#tor 8 /' %ey2oard B !pson r#nter
#uantity s 6B s 6- s 6B- s .B s
RA*& $s 36-$s .-B-$s BB-$s 86B $s 8B-
$A* 8O 8O 8O 8O 8O
8479749 In5o#e $ee#5ed from /ally solut#on 5t ?td In5o#e No INL/'L-6 for t0e follo4#n" Items tran" No G $ee#pt Note Not A5a#la2le All "oods stored at %ol&ata "odo4n ,*&; #*< RA*& $A* 6 /ally 1ult# ser 6- s $s.6-BC'/7.O . /ally '#n"le ser 3B s $s B-C'/7.O 8479749 In5o#e ree#5ed for follo4#n" #tems from 'upreme /e0nolo"#es 5t ?td In5o#e No: INL'/L--6 a"a#nst 0allan no $NL'/L--8 ,*&; #uantity Rate $at 6 ? ?CE 1on#tor 6- s $s 3B8O . D r#nter 6B s $s 8B-8O 3 8 * 1emory Card ,B s $s 8,B 6.BO
o to In5entory Features (F66) and at#5ate t0e follo4#n" opt#on QAllo4 'ales order proess#n"R Yes 9479=749 =rder ree#5ed from ?C ?td 4#t0 t0e follo4#n" deta#ls order No =rdL?CL--6 ,tem 6 ? ?CE 1on#tor . !pson r#nter
#uantity .- s .B s
9479=749 =rder ree#5ed from A2#r 5t ?td 4#t0 t0e follo4#n" deta#ls =rder No =rdLA2#rL--6 ,tem 6 Ae Aount#n" 'oft4are . /ally '#n"le ser
#uantity 6B s .B s
9479=749 =rder ree#5ed from A2#r 5t ?td 4#t0 t0e follo4#n" deta#ls =rder No =$ELA2#rL--3 ,tem #uantity 6 D r#nter .. s . /ally 1ult# ser 6 s 9>79=749
66
oods del#5ered to ?C ?td from %ol&ata "odo4n a"a#nst order No =rdL?CL--6 C0allan No E?L?CL--6 9>79=749 1a&e 'ales In5o#e a"a#nst C0allan No E?L?CL--6 4#t0 t0e follo4#n" rate and ot0er 0ar"es In5o#e No INL?CL--6 Name 6 ? ?CE 1on#tor . !pson r#nter
#uantity .- s .B s
Rate $s B-$s ,---
$at 8O 8O
9>79=749 oods del#5ered to A2#r 5t ?td a"a#nst order No =rdLA2#rL--6 and =rdLA2#rL --3 and C0allan No E?LA2#rL-- oods del#5ered from %ol&ata "odo4n 9>79=749 Cas0 'ales made to 'uraH ?td 4#t0 t0e follo4#n" Eeta#ls oods del#5ered from %ol&ata "odo4n Name #*< RA*& $A* /ally 1ult# ser 3 s $s .B-8O 9>79=749 6 s of Ae aount#n" soft4are reHeted 2y A2#r 5t ?td a"a#nst C0allan No E?LA2#rL-- "oods stored at %ol&ata "odo4n 9>79=749 In5o#e made to A2#r 5t ?td a"a#nst 0allan No E?LA2#rL-- 4#t0 follo4#n" Eeta#ls In5o#e No In5LA2#rL--6 Name #*< RA*& $A* 6 Ae Aount#n" 'oft4are 68 s $s 6BB-8O . /ally '#n"le ser .B s $s 6,6B8O 3 !pson r#nter .. s $s ,6B8O 8 /ally 1ult# ser 6 s $s .9-8O 8479=749 In5o#e made to Compte0 !nterpr#ses In5o#e No In5L'aleL--B for t0e follo4#n" Items All t0e #tems del#5ered from %ol&ata "odo4n Name 6 /ally 1ult# ser . /ally '#n"le ser
#*< s 3 s
RA*& $s .B$s 6,6B-
iscount BO BO
CS* .O .O
o to Company Features of In5entory Features (F66) and at#5ate t0e follo4#n" opt#ons Qse E#fferent atual and 2#lled Suant#tyR Yes 8479=749 'ales #n5o#e made to 'a5y Computer 4#t0 t0e spe#al offer offer #s for e5ery pur0ase of B- s of /' %ey2oard B s as a2solutely free
'a5y Computer pur0ase 6-- s /' %ey2oard B.6 er s 4#t0 C'/ .O In5o#e No In5L'aleL--, 8479=749
6.
$s .---- $ee#5ed from 'a5y Computers a"a#nst 2#ll No In5L'aleL--, #n as0 8479=749 $s ---- ree#5ed from ?C ?td a"a#nst 2#ll No In5L?CL--6 2y C0e@ue No 6B6-- of AJI' *an& and depos#ted #nto 2an& 8479=749 Follo4#n" "oods pur0ase from Arun rasad ?td In5o#e No: In5LB8BL.6.6 ,tem Name 1ouse ad
#uantity 68- EoTen
Rate 3-L ps
$A* 6.BO
8479=749 $s 3---- 4#t0 dra4n from ICICI *an& 2y C0e@ue No 6-6.-
o to Aount#n" features (F66) and 0e& t0e follo4#n" opt#ons 40et0er t0e opt#ons are at#5ated or not 6 Qse Ee2#tLCred#t NotesR Yes . Qse In5o#e mode for red#t noteR Yes 3 Qse In5o#e mode for Ee2#t noteR Yes 8479=749 Follo4#n" "oods are returned 2y Compte0 !nterpr#ses a"a#nst In5o#e No In5L'aleL--B Cred#t note $ef :7 C$L'$/L--6 Name #*< RA*& CS* /ally 1ult# ser 6 p $s .B.O [D#nt: se Cred#t note as #n5o#e 4#t0out ment#on#n" any /ran" Num2er] $at Adjustment
Create t0e 5ou0er lass for at adHustment: [Aounts Info ou0er /ypes Alter ;ournal] Name
*ype of $ouc%er
Name of C!ass
"se for $at Adjustment
;ournal
;ournal
at AdHustment Class
Yes
$at on Capita! goods :7 Create t0e follo4#n" led"ers 4#t0 follo4#n" deta#ls Name 6 !letr#al 1otor AL . at on ap#tal "oods
3 Input red#t on Cap#tal "oods 8 Input at red#t B Amount $ound off
"nder "sed in$at Return F#ed Asset Yes 1#sellaneous !pend#ture(Asset) *ype Eut#es G /aes A/ Current Asset Ind#ret epenses
8479=749
63
$at C!ass ur0ase ap#tal "oods 8O
ur0ase Cap#tal "oods 8O
ur0ases an !letr#al 1otor ost#n" $s ---- on 40#0 at 0ar"ed 8O from ?eno5o ?td [D#nt: se ;ournal 1ode F,] 8479=749 ass t0e entry for 5at adHustments on Cap#tal "oods [D#nt: se at AdHustment Class from ;ournal mode F,] 8479=749 C0e& t0e at omputat#on report from -67-876- to 367-76- and ass t0e Input Cred#t adHustment entry aord#n"ly [D#nt: se at AdHustment Class from ;ournal mode F,] 8479=749 ass =utput at adHustment entry 4#t0 Input Cred#t [D#nt: se at AdHustment Class from ;ournal mode F,]
$ouc%er C!ass Create t%e fo!!owing vouc%er C!ass based 2n Sa!es :7 [Aounts Info ou0er /ypes Alter 'ales] 4. Sa!es $ouc%er for $at ? @
Name of Class 'ales 8O atU Inlude "roup 'undry Ee2tor Cas0 #n 0and *an& Aounts U Eefault aount alloat#on for ea0 #tem 'ales 8O AL atL/a Classsales 8OU erenta"e6--O =5err#de us#n" t0e Eefault YesU 2t%er C%arges:7 =utput at 8O =n at $ate 8O Amount $ound off /otal amount $ound#n" Normal $ound#n" $ound#n" l#m#t 6 'a5e all t0ese >. Sa!es $ouc%er for CS*? >
Name of Class C'/ 'ales .OU Inlude "roup 'undry Ee2torsU Eefault Aount Alloat#on for ea0 #tem 'alesPCst AL atL/a ClassInter 'tate 'ales erenta"e6--O =5err#de us#n" t0e Eefault YesU 2t%er C%arges :7 C'/ =n total 'ales .O Amount $ound off /otal amount $ound#n" Normal $ound#n" $ound#n" l#m#t 6 'a5e all t0ese
;AN"3AC*"R,NG :7 Create t%e fo!!owing products :7 ,*&; NA;&
;easurement "nit 68
6 Ca2#net . 1ouse 1ot0er2oard 3 're4 8 #re B 'roll 0eel , 'roll 1ouse (F#n#s0ed rodut)
s s s 1tr s s s
Set t%e fo!!owing )i!! of materia! for t%e ,tem Scro!! ;ouse :7 /o 1anufature 6 of sroll mouse follo4#n" $a4 1ater#als are re@u#red ,tems Godown No. of Pcs. 6 Ca2#net %ol&ata 6 . 1ouse 1ot0er2oard %ol&ata 6 3 're4 %ol&ata 8 s 8 #re %ol&ata 6.B 1tr B 'roll %ol&ata 3 s 0eel %ol&ata 6
9479B749 ur0ase t0e follo4#n" Items from 1onoH#t !letron#s 5t ?td In5o#e No :7 In5LurL69 ,tems 6 Ca2#net . 1ouse 1ot0er2oard 3 're4 8 #re B 'roll 0eel
#uantity .B--- s .--- s .----- s B---- 1tr 6---- s 3---- s
Rate $s -$s 6B-$s -.B $s ,.$s 6$s .3-
$at 8O 8O 8O 8O 8O 8O
Create a $ouc%er *ype based on Stock 0ourna! :7 [Aounts Infoou0er /ypeCreate] Name 1anufatur#n" ;ournalU /ype of ou0er 'to& ;ournalU se as manufatur#n" ;ournal YesU 'a5e #t Create a ;anufacturing "nit /Godown1 :7 *ud"e *ud"e n#t 9>79B749 rodue 6---- s 'roll mouse at t0e *ud"e *ud"e n#t [D#nt: se 1anufatur#n" ;ournal Alt+F,] &+tra C%arges :7 A) ?a2our 0ar"es $s ,---- *) Fatory =5er Dead 33O 9>79B749 rodue 63--- s 'roll mouse at *ud"e *ud"e n#t [D#nt: se 1anufatur#n" ;ournal Alt+F,] &+tra C%arges :7 A) $s er n#t as ?a2our 0ar"es *) Fatory =5er0ead 33O 94749749 /ransfer 6---- 'roll mouse to %ol&ata "odo4n from *ud"e *ud"e n#t 6B
9>749749 B--- s 'roll mouse $s 63-3 4#t0 =utputat 8O 'old to A2#r 5t ?td In5o#e No INLA*I$L-6 [D#nt: se 'ales 8O at Class] 9>749749 /ransfer 63-- s sroll mouse from *ud"e *ud"e n#t to %ol&ata odo4n [se 'to& ;ournal Alt+ F,] 84749749 6-- s sroll mouse $s 636B9 4#t0 C'/ .O sold to 'uraH ?td #n5o#e No In5L'aleL-B36 [D#nt: se 'ales 8O at Class] 84749749 Follo4#n" "oods sold to ? ? !nterpr#se In5o#e no: In5LB8BL6-766 oods del#5ered from %ol&ata "odo4n ,tems #uantity Rate $at 'roll 1ouse 6B- s 63B3. 8O 1ouse ad - EoTen 68B6.BO 8 * 1emory Card 3- s BB-6.BO
D#nt: ass t0#s entry 4#t0out us#n" #n 'ales ou0er Class
Point 2f Sa!e Create a POS Invoice without Voucher Class
o to ate4ay of /ally > Aounts Info > ou0er /ype > Create Name
:
=' In5o#e
*ype of $ouc%er
:
'ales
"se for P2S invoicing
:
Yes
Pass t%e fo!!owing entries using Pos ,nvoice. 84749749
'old B s 'roll 1ouse and 6- ps 8 * 1emory Card $s63B3. and $sBB to ? ? !nterpr#se In5o#e no: In5LB8L6-766 4#t0 8O 5at #ft ou0er #ft ou0er .---Cred#tLde2#t ard ICICI 3----- Card No B8A838B,9B. C0e@ue ICICI .----- *an& Name A#s *an& C0e@ue No 83--. Cas0 Cas0 63,9 Cas0 tendered 68---*alane: .-38 Create a POS Invoice with Voucher Class
o to ate4ay of /ally > Aounts Info > ou0er /ype > Alter > os In5o#e *ype C!ass Name
:
=' In5o#e
6
'et t0e follo4#n" Eefault ?ed"ers Aounts for =' In5o#e ou0er Class &nab!e No Yes Yes Yes
Gift $ouc%er Credit-debit card C%eue Cas%
Ledger Name
'*I red#t ard ICICI Cas0
84749749
'old 6 s 'amsun" ?CE 1on#tor $s ,--- 4#t0 8O 5at [In5o#e no In5LB8,L6-766] to A2#r 5t ?td Credit-debit card ICICI Card No. 8----B8A838B,8B ICICI 3----ICICI C%eue )ank Name C%eue No. 93--3 Cas% Cas% tendered 3---)a!ance: .--Cas0 .---
,N*&R&S* CALC"LA*,2N (#) (##)
At#5ate t0e follo4#n" opt#on from Aount#n" features (F66) At#5ate Interest Calulat#on Yes se Ad5ane arameter Yes
Create two vouc%er c!asses based on ebit Note :7 ' D#nt: Aounts Info ou0er /ype Alter Ee2#t Note] Name of C!ass '#mple Interest Compound Interest
"sed for ,nterest Ca!cu!ations Yes Yes
Amount to be treated as Compound No Yes
Set t%e fo!!owing ,nterest Parameter for A),R Pvt Ltd :7 Rate ,nterest Sty!e 2n )a!ance App!icabi!ity 6-O 3B Eay Year =n Ee2#t *alane =nly Al4ays
Ca!cu!ate 3rom Eue Eate of In5o#e
Set t%e fo!!owing ,nterest Parameter for S"RA0 Ltd :7 Rate .BO
,nterest Sty!e 3- Eay 1ont0
2n )a!ance =n Ee2#t *alane =nly
84749749 C0ar"e '#mple Interest to A2#r 5t ?td 84749749 C0ar"e Compound Interest to 'uraH ?td
PR,C& L,S* 6,
App!icabi!ity Al4ays
Ca!cu!ate 3rom Eue Eate of In5o#e
Create t%e fo!!owing price Leve! :7 o to In5entory Feature and at#5ate t0e follo4#n" opt#ons (F66):7 6 Q'eparate E#sount olumn #n In5o##n"R Yes . Qse mult#ple r#e le5elR Yes Name of Price !eve! :7 6 0ole 'eller . $eta#ler Create t%e Price !ist for D%o!e se!!er on Scro!! mouse :7 #uantity Rate to 6-6-B From 6-6 to .B6-.B6 =n 4ards 9B
iscount 6O 6BO .O
Create anot%er Price !ist for Retai!er on Scro!! mouse :7 #uantity Rate to B66From B6 to 6-6- 6-6 =n 4ards 6-.
iscount 7 .O 3O
94744749 oods sold to IndraH#t 5t ?td a 40ole seller In5o#e No INLIndL--6 ,tem Name 'roll 1ouse
#uantity 3-- s
$at 8O
94744749 oods sold to 'uman !nterpr#se a $eta#ler In5o#e No INL'1L--6 ,tem Name 'roll 1ouse
#uantity - s
$at 8O
"nconventiona! $ouc%ers At#5ate t0e follo4#n" opt#on from Aount#n" Feature (F66) use opt#onal and $e5ersal ;ournal Yes Pass t%e fo!!owing entries using appropriate unconventiona! $ouc%er :7 94744749 $ent to 2e pa#d $s B---- (1emorandum) 94744749 Insurane 0ar"es to 2e pa#d $s 6,--- (ayment =pt#onal) 9>744749 Eepre#at#on to 2e 0ar"ed on furn#ture of $s 6B--- (;ournal =pt#onal) 9>744749 'alary to 2e pa#d $s 6B--- and t0#s 5ou0er appl#a2le only on -.76676- ($e5ers#n" ;ournal)
6
9>744749 'ales made to 'uman !nterpr#se a $eta#ler In5o#e No INL'1L--. (ass t0#s entry t0rou"0 'ales opt#onal) ,tem Name #uantity $at 'roll 1ouse B- s 8O
Scenario Create Scenarios from Accounts ,nfo E Create Name roHet $eport
,nc!ude Actua! Yes
,nc!ude 6 'ales =pt#onal . 1emorandum 3 ayment =pt#onal 8 ;ournal =pt#onal B $e5ers#n" ;ournal
'a5e t0e 'enar#o '0o4 t0e proHeted *alane '0eet and rof#t G ?oss AL on -.7667.-6- 2ased on 'enar#o
S&R$,C& *AF At#5ate t0e follo4#n" opt#on #n 'tatutory Feature (F66) 6 Q!na2le 'er5#e /aR Yes . Q!nter 'er5#e /a Eeta#lsR Yes 'er5#e /a $e"#strat#on Num2er A;IM388C'/--6 Eate of $e"#strat#on 68.-6- Assessee Code 6.8 rem#ses Code No7 !?LB66 /ype of or"an#nat#on $e"#stered u2l# ?td Company
ivision Code 7 -63 Name !astern
Range Code 66B Name %ol&ata
Commissionerate Code .3(.) Name ? ro5er
Create t%e fo!!owing Ledger :7 Ledger Name
"nder
*ype of uty-*a+
'er5#e /a on Course Fees 'er5#e /a on Cour#er C0r"s
Eut#es G /aes Eut#es G /aes
Course Fees Cour#er C0ar"es
,s Service *a+ App!icab!e E#ret Inome Yes Ind#ret !penses Yes
Commer#al /ra#n#n" G Coa0#n" Cour#er A"eny
'undry Ee2tors
&+emption etai!s Not Appl#a2le
1r ram#t 0os0
'er5#e /a 'er5#e /a
Category Name
Yes 69
Commer#al /ra#n#n" G Coa0#n" Cour#er A"eny
*lue Eart Cour#er ?td 'er5#e /a aya2le
'undry Cred#tors Yes Current ?#a2l#t#es
Not Appl#a2le
Pass t%e )i!! &ntries using Sa!es /3=1 wit% Account ,nvoice :7 9474>749 A 2#ll of $s 3B--- for ourse fees made on 1r ram#t 0os0 4#t0 'er5#e /a 0ar"e 6-O and !duat#onal Cess .O and 'eondary !du Cess 6O In5o#e No: INLCFL---6 Pass t%e )i!! &ntries using Purc%ase /3B1 wit% Account ,nvoice :7 9>74>749 A 2#ll of $s 6---- ree#5ed on aount of Cour#er C0ar"es from *lue Eart Cour#er ?td 4#t0 'er5#e /a 0ar"e 6-O and !duat#onal Cess .O and 'eondary !du Cess 6O In5o#e No: INL*ELB.6F
9>74>749 Amount ree#5ed #n full from 1r ram#t 0os0 a"a#nst In5o#e No: INLCFL---6 2y C0e@ue No: ,8B.6 of A#s *and and 0e@ue depos#ted #n ICICI *an& 9>74>749 Amount pa#d #n full to *lue Eart Cour#er ?td a"a#nst In5o#e No: INL*ELB.6F #n as0 Service *a+ Adjustment
Create t0e 5ou0er lass for 'er5#e /a adHustment: [Aounts Info ou0er /ypes Alter ;ournal] Name *ype of $ouc%er Name of C!ass ;ournal
;ournal
'er5#e /a AdHustment Class
"se for Service *a+ Adjustment
Yes
9>74>749 ass t0e 'er5#e /a AdHustment !ntry us#n" 'er5#e /a AdHustment Class and 2alane transferred to 'er5#e /a aya2le aount
*ransactions re!ated wit% Abnorma! Loss Provision for )ads oubtfu! ebt and epreciation :7 9>74>749 6B-- s sroll mouse Eestroyed 2y f#re $s B ea0 at %ol&ata "odo4n And Insurane la#m made on t0at a#dent 9>74>749 Insurane ompany 0as a"reed to pay after #n5est#"at#on of $s ,B--- 8474>749
.-
Insurane la#med ree#5ed from Insurane Company 2y C0e@ue No 66B-6 of *an& of Ind#a and t0e C0e@ue depos#ted #nto ICICI *an& 94794744 Amount ree#5ed #n full from ? ? !nterpr#se #n as0 a"a#nst In5o#e no: In5LB8BL6-766 9>79>744 It #s epeted t0at $s 6---- not to 2e real#Ted from A2#r 5t ?td and #t #s treated as *ad Ee2t 9>79>744 ro5#s#on for Eou2tful Ee2ts for re5#ous Year to 2e adHusted 4#t0 *ad Ee2t $s B--- 84st ;arc% >944 Create a ne4 pro5#s#on for dou2tful Ee2t 3O on sundry Ee2tor 84st ;arc% >944
C0ar"e depre#at#on 6-O on ?and G *u#ld#n" .-O on Furn#ture and 6BO on lant G 1a0#nery
)udget At#5ate t0e follo4#n" opt#on from Aount#n" Feature (F66): Q1a#nta#n *ud"et and ControlR Yes Create t%e 3o!!owing Ledger :7 Ledger Name 6 /#ff#n !penses . eneral !penses
"nder Ind#ret !penses Ind#ret !penses
Cost Centres App!icab!e No No
Create t%e fo!!owing )udget :7 )udget for 3o!!owing Ledger :7 )udget Name !penses *ud"et Period Ledger 66.-66 363.-66 Yes 66.-66 363.-66 Yes Accept t%e )udget Pass t%e fo!!owing *ransaction :7
"nder r#mary Amount Name eneral !penses /#ff#n !pense
*ype =n Clos#n" *alane =n Nett /ransat#on
947947>944 E $s 3B-- pa#d for eneral !penses #n as0 9>79>7>944 E $s 6B-- pa#d for eneral !penses #n as0 947987>944E $s BB-- pa#d for eneral !penses #n as0 947947>944 E $s - pa#d for /#ff#n !penses #n as0 9>7947>944 E $s B- pa#d for /#ff#n !penses #n as0
'0o4 t0e *ud"et ar#ane $eport from /r#al *alane for eneral !penses '0o4 *ud"et ar#ane $eport for /#ff#n !penses for t0e per#od 66.-6- to .6.-6- .6
Amount 8--6B--
0ob Costing: At#5ate t0e follo4#n" opt#on #n Aount#n" Features (F66) 1a#nta#n Cost Centres Yes se Cost Centres for ;o2 Cost#n" Yes Create t0e follo4#n" Cost Centres [Aounts Info Cost Centres] Category r#mary Cost Cate"ory
Name $a#l4ay '0ade at Do4ra0
"nder r#mary
"se for 0ob Costing Yes
Create t0e follo4#n" "odo4n for t0e proHet:[In5entory Info odo4ns] Name
Address
"nder
A!!ow Storage of ;ateria!s
Set 0ob-Project Name for 0ob Costing
Do4ra0 odo4n
8BL. / $oad
r#mary
Yes
$a#l4ay '0ade at Do4ra0
Create t0e follo4#n" ?ed"er [Aounts Info ?ed"er Create] Name nder a"es E#ret !penses roHet Inspet#on C0ar"es Ind#ret !penses roHet Ees#"n#n" C0ar"es Ind#ret !penses roHet =5er0ead !penses Ind#ret !penses 'ale of $a#l4ay '0ade E#ret Inome 'ale of 'rap Ind#ret Inome o5t of Ind#an $a#l4ay 'undry Ee2tors 1e"0a !nterpr#ses 'undry Cred#tors
Cost Centres are Appl#a2le Yes Yes Yes Yes Yes Yes No No
Create t0e follo4#n" 'to& Item for t0e proHet [In5entory Info'to& Items Create Name nder n#t Dea5y Capa#ty 'teel $od roHet 'to& 1tr Dea5y Capa#ty 'teel Ca"e roHet 'to& s 'uper Sual#ty As2estas '0ade roHet 'to& s ;o#n#n" Instruments roHet 'to& s Create t0e follo4#n" 5ou0er lass 2ased sto& Hournal for Ho2 ost#n" onsumpt#on [Aounts Info ou0er /ypes Alter 'to& ;ournal] Name
*ype of $ouc%er
Name of C!ass
'to& ;ournal
'to& ;ournal
;o2 Cost#n" Consumpt#on
"se for 0ob Costing Consumption
Yes
947947>944 ur0ase t0e follo4#n" sto& #tem from 1e"0a !nterpr#ses In5o#e No: INL1!L8B6 and all sto&s stored at Do4ra0 odo4n
Item
Suant#ty
$ate ..
Dea5y Capa#ty 'teel $od 6.8- 1tr $s 6B. Dea5y Capa#ty 'teel Ca"e B-- s 'uper Sual#ty As2estas '0ade .B-- s ;o#n#n" Instruments B--- s
$s 3B8$s B$s B.
847947>944 $s .B---- pa#d for a"es for $a#l4ay '0ade at Do4ra0 2y 0e@ue no B86--6 of ICICI *an& 847947>944 $s B.8- pa#d for roHet =5er0ead !penses for $a#l4ay '0ade at Do4ra0 2y C0e@ue No B86--. of ICICI *an& 9479>7>944 $s 6B8- pa#d for roHet Ees#"n#n" C0ar"es for $a#l4ay '0ade at Do4ra0 2y C0e@ue No: B86--3 of ICICI *an& 9>79>7>944 $s .B--- pa#d for roHet Inspet#on C0ar"es for $a#l4ay '0ade at Do4ra0 2y C0e@ue No B86--8 of ICICI *an& 947987>944 $s 86.B- ree#5ed from 'ale of 'rap 2y C0e@ue No ,8B68 of *I and t0e same 4as depos#ted #nto ICICI *an& 9>7987>944 Follo4#n" "oods are onsumed from Do4ra0 odo4n to f#n#s0 t0e proHet [D#nt: In5entory ou0er 'to& ;ournal ;o2 Cost#n" Consumpt#on] Item Suant#ty $ate Dea5y Capa#ty 'teel $od 6.-- 1tr $s 6B. Dea5y Capa#ty 'teel Ca"e 8B- s $s 3B8'uper Sual#ty As2estas '0ade .8B- s $s B;o#n#n" Instruments 8B-- s $s B. 847987>944 roHet of $a#l4ay '0ade at Do4ra0 del#5ered to o5t of Ind#an $a#l4ay at a r#e of $s ,B----- Contrat um In5o#e No: 'LELB8,L6-76-
847987>944 $s B------ ree#5ed from o5t of Ind#an $a#l4ay 2y 0e@ue no ,8B66 of '*I and t0e same depos#ted #nto ICICI *an&
'0o4 t0e Ho2 Analyses $eport
&+cise uty for ea!ers: &+cise for ea!ers ;odu!e: At#5ate t0e follo4#n" 'tatutory and /aat#on Features (F66) !na2le !#se Yes 'et L Alter !#se Eeta#ls Yes $e"#strat#on /ype Eealer Address: 9 !l"#n $oad 6st Floor #n Code ,---./elep0one No: +96338--6-.8 .3
&+cise etai!s: n#t ma#l#n" Name !#se $e"#strat#on (!CC) No Eate of $e"#strat#on:
: s :'!C8B8EJE--6 :-67-876-
2t%er etai!s: Range ivision Code: 68B Code: ,8 Name: *el#a"0ata Name: !astern Address: B8 Nar&eldan"a Address: B, !splanade $o4
Commissionerate Code: 3.8 Name: uls0an Address: B86 Ne4 Al#pore
Create t0e follo4#n" odo4n: In5entory Infoodo4n L !#se n#tCreate Name nder !#se $e"#strat#on /ype 'et L Alter !#se Eeta#ls
: : : :
Eunlop odo4n r#mary Eealer Yes
&+cise etai!s /ea!er "nit1
n#t 1a#l#n" Name : !#se $e"#strat#on (!CC) : Eate of $e"#strat#on :
Eunlop odo4n '!C8B8EJE--6 -67-87.-6-
2t%er etai!s: Range ivision Code: 68B Code: ,8 Name: *el#a"0ata Name: !astern Address: B8 Nar&eldan"a Address: B, !splanade $o4
Address : #n Code : /elep0one No : Allo4 'tora"e of 1ater#als : 'et ;o2LroHet Name for ;o2 Cost#n" :
Commissionerate Code: 3.8 Name: uls0an Address: B86 Ne4 Al#pore
B8 * / $oad Doo"ly est *en"al ,8B6.B +96 33 8--B98 Yes Not Appl#a2le
Create t%e 3o!!owing *ariff - $at Commodity: [In5entory Info /ar#ff L at Commod#tyCreate]
Name Commod#ty nder sed For D'N Code Commod#ty Code '0edule Num2er '0edule 'er#al Num2er
: : : : : : :
!JL'L--6 Dard4are oods 'an#tary4ares G 1#ll 'tores *ot0 B6--68B6--68I 669 .8
Create t%e 3o!!owing Stock ,tem wit% t%e &+cise etai!s: [In5entory Info 'to& ItemCreate]
Name nder n#ts /ar#ff Class#f#at#on 'et L Alter !#se Eeta#ls
: : : : :
' r#mary s !JL'L--6 Yes
&+cise "nit Name Eunlop odo4n
Reporting "2;
Set -A!ter uty etai!s Yes
*ype of uty *as# !#se Euty !duat#on Cess 'eondary !duat#on Cess
App!icab!e 3rom -67-876-67-876-67-876-
Rate of uty 6-O .O 6O
$at etai!s Commod#ty $ate of at (O)
!JL'L--6 8
;et%od of Ca!cu!ation =n Assessa2le alue =n Euty alue =n Euty alue
Create t0e follo4#n" ou0er /ypes for !#se: [Aounts Info ou0er /ypesCreate] Name !#seP ur0ase !#seP 'ales !#seP ur0ase $eturn !#seP 'ales $eturn
*ype of $ouc%er ur0ase 'ales Ee2#t Note Cred#t Note
"se for &+cise efau!t &+cise "nit ,s *a+ ,nvoice Yes Eunlop odo4n Yes Eunlop odo4n Yes Yes Eunlop odo4n Yes Eunlop odo4n
Create t%e fo!!owing Ledger:
Name AC Industr#es ?td
nder 1a#nta#n *#ll #se Eeta#ls 'undry Cred#tors Yes
* * !letorn#s ?td
'undry Ee2tors
Yes
'etLAlter !#se Eeta#ls Yes !#se $e"d No: S'E!B86.'J1--6 Eate of $e"d : -67-876$an"e : '#l#"ur# Eefault Nature =f ur0ase : 1anufaturer Yes !#se $e"d No: 'E!'B.68AJ1--6 Eate of $e"d : -67-7.-6$an"e : %ol&ata Eefault Nature =f u0ase : 1anufaturer
Pass t%e fo!!owing Purc%ase &ntries using 3B and se!ect Purc%ase &+cise $ouc%er
Eate
: -.7-.7.-66 .B
In5o#e No arty Name !#se n#t
: INLACL-6 : AC Industr#es ?td :Eunlop "odo4n
Name of Item '
Eate In5o#e No arty Name !#se n#t
Suant#ty 3-- s
$ate 9B
$L.3E !ntry No ACL--6
at 8O
$ate 998
$L.3E !ntry No ACL--B
at 8O
: -67-37.-66 : INLACL-B : AC Industr#es ?td : Eunlop odo4n
Name of Item '
Suant#ty 3B- s
Pass t%e fo!!owing Sa!es &ntry using 3= and se!ect Sa!es &+cise $ouc%er
Eate In5o#e No arty Name !#se n#t Name of ,tem
'
Eate In5o#e No arty Name !#se n#t Name of ,tem
'
: -.7-37.-66 : INL!JL'A?!L--6 : * * !letron#s ?td :Eunlop "odo4n Supp!ier #uantity ,nvoice No INLACL-6 6B- s
Rate
RG->8 &ntry No
6B-
ACL--6
Rate
RG->8 &ntry No
6B-
ACL--3
8O
: 367-37.-66 : INL!JL'A?!L--3 : * * !letron#s ?td :Eunlop "odo4n Supp!ier #uantity ,nvoice No INLACL-6 6B- s INLACL-B 6-- s
'
Sa!es ,nvoice No
6
Sa!es ,nvoice t
-.7-37.-6-
#uantity
Rate
$at
.- s
6B-
8O
.
$at
8O
Pass t%e fo!!owing Sa!es Return &ntry using Ctr! H 3= and se!ect &+cise Sa!es Return $ouc%er Eate : 367-37.-66 $ef No : $!/L!JL'A?!L--6 arty Name : * * !letron#s ?td !#se n#t :Eunlop "odo4n Name of ,tem
$at
&+cise uty for ;anufacturer: Create a ne4 ompany 4#t0 t0e follo4#n" deta#ls: [ Company Info (Alt+ F3) Create] Name Address
: :
'tatutory Compl#ane for 'tate #n 0one Num2er !ma#l Address 1a#nta#n F#nan#al Year from *oo&s *e"#nn#n" from /ally ault ass4ard se 'eur#ty Control
: : : : : : : : : :
<<'olo last#s 5t ?tdPYour $oll Num2er>> 9 !l"#n $oad %ol&ata Ind#a est *en"al ,-- -.+96 33 ..9 86.B opt#onal Aounts 4#t0 In5entory -67-876-67-876Not Appl#a2le No
At#5ate t0e follo4#n" 'tatutory and /aat#on Features (F66) Yes !na2le !#se 'et L Alter !#se Eeta#ls Yes $e"#strat#on /ype 1anufaturer st Address: 9 !l"#n $oad 6 Floor #n Code ,---./elep0one No: +96338--6-.8 &+cise etai!s: n#t ma#l#n" Name !#se $e"#strat#on (!CC) No Eate of $e"#strat#on /ype of 1anufaturer !#se *oo& Name (As per $ule 66)
: 'olo last#s 5t ?td :'!C!B8,'J1--6 :-67-876: $e"ular : Ne4 Num2er
Name
;et%od of Numbering
6-6
Automat#(1anual o5err#de)
Prevent Starting up!icates Number
Yes
6
Restart Numbering
Prefi+ etai!s
Appl#a2le From 67Apr7.-6-
Appl#a2le From 67Apr7.-6-
art#ulars Yearly
Didt% of Numerica! Part
2t%er etai!s: Range ivision Code: 68B Code: ,8 Name: *el#a"0ata Name: !astern Address: B8 Nar&eldan"a Address: B, !splanade $o4
3
Yes
Suffi+ etai!s art#ulars !JL
Appl#a2le From 67Apr7.-6-
Commissionerate Code: 3.8 Name: uls0an Address: B86 Ne4 Al#pore
.,
Prefi!! wit% Iero
art#ulars L6-76-
At#5ate t0e follo4#n" 'tatutory G /aat#on Features from Company Features F66 !na2le alue Added /a Yes 'et L Alter A/ Eeta#ls Yes 'tate /ype of Eealer $e"ular at Appl#a2le From A/ /IN ($e"ular) Inter 'tate 'ales /a Num2er AN L Inome /a No
est
*en"al $e"ular 6787.-6 ,8B68B9.B 886..B6 '!C!B8,'
Create t0e follo4#n" odo4n: In5entory Infoodo4n L !#se n#tCreate Name nder !#se $e"#strat#on /ype 'et L Alter !#se Eeta#ls
: : : :
Eunlop odo4n r#mary 1anufaturer Yes
&+cise etai!s /ea!er "nit1
n#t 1a#l#n" Name !#se $e"#strat#on (!CC) Eate of $e"#strat#on /ype of 1anufaturer !#se *oo& Name 'tart#n" Num2er Address #n Code /elep0one No
: : : : : : : : :
Eunlop odo4n '!C!B8,'J1--6 -67-87.-6$e"ular 6-6 6 B8 * / $oad Doo"ly est *en"al ,8B6.B +96 33 8--B98
2t%er etai!s: Range ivision Code: 68B Code: ,8 Name: *el#a"0ata Name: !astern Address: B8 Nar&eldan"a Address: B, !splanade $o4
Commissionerate Code: 3.8 Name: uls0an Address: B86 Ne4 Al#pore
Create t0e follo4#n" ou0er /ypes for !#se: [Aounts Info ou0er /ypesCreate] Name !#seP ur0ase !#seP 'ales !#seP ur0ase $eturn !#seP 'ales $eturn
*ype of $ouc%er ur0ase 'ales Ee2#t Note Cred#t Note
"se for &+cise efau!t &+cise "nit ,s *a+ ,nvoice Yes Eunlop odo4n Yes Yes Eunlop odo4n Yes Yes Eunlop odo4n Yes Yes Eunlop odo4n Yes "se As ;anufacturing 0ourna!
.
1anufatur#n" ;ournal
'to& ;ournal
Yes
Create t0e follo4#n" ?ed"er: [Aounts Info ?ed"er Create] Name "nder *ype of &+cise Accounting uty-*a+ Code
uty Jead
!#se Euty [Cen5at] Current Assets
Cen5at
6---6-6-
*as# !#se Euty
6-O
!duat#on Cess [Cen5] Current Assets
Cen5at
6--66-6-
!duat#on Cess
.O
'e !duCess [Cen5a] Current Assets
Cen5at
6--.6-6-
'e !duat#on Cess
6O
!#se Euty 6-O
Eut#es G /aes
!#se
B6--669
*as# !#se Euty
6-O
!duat#on Cess .O Eut#es G /aes
!#se
B6--6.-
!duat#on Cess
.O
'e !du Cess 6O
!#se
B6--6.6
'e !duat#on Cess
6O
Eut#es G /aes
Input at 8O
Eut#es G /aes
A/
$A*-*a+ C!ass Input at 8O
=utput at 8O
Eut#es G /aes
A/
=utput at 8O
ur0ase of 1ater#als ur0ase Aount
,nventory $a!ues are Affected Yes
'ales 8O AL
Yes
'ales Aount
;aintain ba!ance Address )i!! by bi!!
Percentage of Ca!cu!ation
"sed in $at $A*-*a+ Returs C!ass Yes ur0ase 8O
Yes
'ales 8O
Pan -,* No $at etai!s &+cise etai!s
%usum roduts ?td
'undry Ee2tors
Yes
B8LA Eur"apur *urd4an est *en"al ,8B6-
S'A 8B,/
Yes 8,B,B. 86.
Yes S'A8B ,/J1-- Nature of ur: 1anufature Nature of $m5l Eomest#
D? 1anufatur#n"
'undry Cred#tors Yes
,88 A ; ? N $oad %ol&ata est *en"al ,---B-
D'!E ,BB$
Yes 8,B8B ,8B
'=' !nterpr#ses
'undry Cred#tors Yes
866 *
Yes D'!E968$ J1--8 Nature of ur: 1anufature Nature of $m5l Eomest# Yes
.9
S/Y'
Yes
N'C *ose $d %ol&ata est *en"al ,---8-
B. $
,8B68B B8,
S/Y'B.$ J1 --9 Nature of ur: 1anufaturer Nature of $m5l Eomest#
Create t0e follo4#n" sto& #tem: Create t%e 3o!!owing *ariff - $at Commodity: [In5entory Info /ar#ff L at Commod#tyCreate]
Name Commod#ty nder sed For D'N Code Commod#ty Code '0edule Num2er '0edule 'er#al Num2er
: : : : : : :
!JLL--6 ?A'/IC $**!$ FI*$! ?A'' G =/D!$ 'YN/D!/IC $=EC/ *ot0 --6.--6 --6.--6 I .--6
Create t%e 3o!!owing *ariff - $at Commodity: [In5entory Info /ar#ff L at Commod#tyCreate]
Name Commod#ty nder sed For D'N Code Commod#ty Code '0edule Num2er '0edule 'er#al Num2er
: : : : : : :
!JL'/L--6 1!/A? *ot0 --..--. --..--. I .--.
Create t%e 3o!!owing *ariff - $at Commodity: [In5entory Info /ar#ff L at Commod#tyCreate]
Name Commod#ty nder sed For D'N Code Commod#ty Code '0edule Num2er '0edule 'er#al Num2er
: : : : : : :
!JLCL--6 ?A'/IC $**!$ FI*$! ?A'' G =/D!$ 'YN/D!/IC $=EC/ *ot0 --8.--8 --8.--8 I .--8
Create t%e 3o!!owing Stock ,tem wit% t%e &+cise etai!s: [In5entory Info 'to& ItemCreate]
Name nder n#ts /ar#ff Class#f#at#on
: : : :
last# ranules r#mary % !JLL--6 3-
'et L Alter !#se Eeta#ls
:
Yes
&+cise "nit Name Eunlop odo4n
Reporting "2; %
$a!uation *ype
:
*ype of uty *as# !#se Euty !duat#on Cess 'eondary !duat#on Cess
App!icab!e 3rom -67-876-67-876-67-876-
$at etai!s Commod#ty $ate of at (O)
!JLL--6 8
Set -A!ter uty etai!s Yes
Ad alorem Rate of uty 6-O .O 6O
Stock ,tem *ype r#n#pal Inputs
Create t%e 3o!!owing Stock ,tem wit% t%e &+cise etai!s: [In5entory Info 'to& ItemCreate]
Name nder n#ts /ar#ff Class#f#at#on 'et L Alter !#se Eeta#ls
: : : : :
'teel Dandle r#mary s !JL'/L--6 Yes
&+cise "nit Name Eunlop odo4n
Reporting "2; s
$a!uation *ype
:
*ype of uty *as# !#se Euty !duat#on Cess 'eondary !duat#on Cess
App!icab!e 3rom -67-876-67-876-67-876-
$at etai!s Commod#ty $ate of at (O)
!JL'/L--6 8
Set -A!ter uty etai!s Yes
Ad Suantum Rate of uty 6- L s -. L s -6 L s
Stock ,tem *ype r#n#pal Inputs
Create t%e 3o!!owing Stock ,tem wit% t%e &+cise etai!s: [In5entory Info 'to& ItemCreate]
Name nder 'et Components (*=1) V Components of n#t of 1anufature
: : : : :
6- ?/$ last# Conta#ners r#mary Yes 6- ?/$ last# Conta#ners 6 s
I/!1 last# ranules 'teel Dundle
=E=N Eunlop odo4n Eunlop odo4n 36
SAN/I/Y 6 % 6 s
/ar#ff Class#f#at#on 'et L Alter !#se Eeta#ls
: :
!JLCL--6 Yes
&+cise "nit Name Eunlop odo4n
Reporting "2; s
aluat#on /ype 1$ A2atement O
: : :
*ype of uty
App!icab!e 3rom
*as# !#se Euty !duat#on Cess 'eondary !duat#on Cess
-67-876-67-876-67-876-
$at etai!s Commod#ty $ate of at (O)
!JLCL--6 8
Set -A!ter uty etai!s Yes
1$ *ased 8-- L s 3- O Rate of uty
Stock ,tem *ype
6-O .O 6O
F#n#s0ed oods
Set A!ter Reporting )2; Yes
Create t%e vouc%er c!ass for C&N$A* Credit Adjustment &ntry based on 0ourna! [Aounts Info ou0er /ypes Alter ;ournal] Name
*ype of $ouc%er
Name of C!ass
"se C!ass for &+cise-Cenvat
;ournal
;ournal
C!NA/ Cred#t AdHustment
Pass t%e fo!!owing purc%ase entries '"se &+ciseK Purc%ase vouc%er pressing 3B(
Eate In5o#e No arty Name !#se n#t
: -6L-8L6: INLD?L-6 : D? 1ANFAC/$IN :Eunlop "odo4n
Name of ,tem last# ranules
#uantity B--- %
2t%er C%arges !#se Euty [Cen5at] !duat#on Cess [Cen5at] 'e !duat#on Cess [Cen5at]
: : :
6-O .O 6O
Input at 8O
:
8O
Eate In5o#e No
Godown Eunlop odo4n
: -.L-8L6: INL'='L-6 3.
Rate 9,B-
Yes
arty Name !#se n#t
: '=' !nterpr#ses :Eunlop "odo4n
Name of ,tem 'teel Dandle
#uantity B--- s
Godown Eunlop odo4n
2t%er C%arges !#se Euty [Cen5at] !duat#on Cess [Cen5at] 'e !duat#on Cess [Cen5at]
: : :
6-O .O 6O
Input at 8O
:
8O
Rate 3B-
-67-B76rodue 8B-- s of 6- ?/$ last# Conta#ners [se 1anufatur#n" ;ournal press A?/ + F,]
Pass t%e sa!es entry using &+cise7Sa!es pressing 3=
Eate In5o#e No arty Name !#se n#t
: 367-B76: INL%'1L-6 : %usum roduts ?td :Eunlop "odo4n
Name of ,tem 6- ltr last# Conta#ner
#uantity 8.B- s
2t%er C%arges !#se Euty 6-O !duat#on Cess .O 'e !duat#on Cess 6O:
: :
=utput at 8O
:
Godown Eunlop odo4n
Rate 3B-
6-O .O 6O 8O
367-B76ass t0e C!NA/ Cred#t adHustment entry [se C!NA/ Cred#t AdHustment lass press#n" F, 4#t0 !#se Delp] -67-76a#d t0e 2alane amount of !#se Euty !duat#onal Cess and 'e !duat#onal Cess #n as0
Payro!! &nab!ing Payro!! in *a!!y Go to Gateway of Tally > F11: Featue!> A""ou#t$#% Featue! 'et t0e follo4#n" features to Yes a 1a#nta#n ayroll 33
2 1ore t0an one ayroll L Cost Cate"ory !na2le Payro!! Statutory feature o to Gateway of *a!!y 344: 3eatures 38: Statutory 6 *a+ation 'et &nab!e Payro!! Statutory to
NL;NL66.3,L--63. NL;NL66.3,L--68B NL;NL66.3,L--6B NL;NL66.3,LB,9 'ealda0 6B----. Eays
Go to Gateway of *a!!y 7 Press 34>: Configuration E Payro!! Configuration. 3ie!d '0o4 'tatutory Eeta#lsV '0o4 assportL#sa Eeta#lsV '0o4 Contrat Eeta#lsV
escription 'et t0#s f#eld to Yes 'et t0#s f#eld to Yes 'et t0#s f#eld to Yes
Create t%e fo!!owing "nits ay Jour;ont% and ;inutes to reord t0e attendane used for alulat#on of pay G2* 7 Payro!! ,nfo E "nits E Create. Also reate ompound un#ts su0 as ;t% of 89 day and Jr of 59 ;in Create Attendance-Production *ypes o to =/ ayroll Info AttendaneLrodut#on /ypes Create
AttendaneLrodut#on /ypes ?ea5e 4#t0out pay
Name
"nder
npa#d ?ea5e
r#mary
a#d ?ea5e
r#mary
Casual ?ea5e
a#d ?ea5e
AttendaneLlea5e 4#t0 pay 7
A2sent
npa#d ?ea5e
7
=5ert#me
r#mary
rodut#on 38
n#t Automat#ally appears Automat#ally appears Automat#ally appears Automat#ally appears Dr of - 1#n
Create t%e fo!!owing pay %eads: Go to Gateway of Tally > &ayoll I#fo > &ay 'ea(! > )eate SL No .
Name
6
*as#
Pay Jead *ype
Eearness Allo4ane
!arn#n"s for !mployees !arn#n"s for !mployees
3
Douse $ent Allo4ane
!arn#n"s for !mployees
8
Con5eyane Allo4ane ro5#dent Fund
.
B
,
9
!mployerKs !' Contr#2ut#on 33O
!mployerKs !F Contr#2ut#on 3,O
!'I
!mployerKs !'I Contr#2ut#on
"nder
Name to appear in Pays!ip
"sed for Gratui ty
Ca!cu!ation *ype
Ind#ret !penses
*as#
Yes
=n Attendane
Ind#ret !penses
EA
Yes
Ind#ret !penses
D$A
no
!arn#n"s for !mployees
Ind#ret !penses
Con5eya ne
No
!mployees 'tatutory Eedut#on
Current ?#a2#l#t#e s
!mployerKs 'tatutory Contr#2ut#o n
!mployerKs 'tatutory Contr#2ut#o n
!mployees 'tatutory Eedut#on !mployerKs 'tatutory Contr#2ut#o n
F
Ind#ret !penses
7
Ind#ret !penses
Current ?#a2#l#t#e s
Ind#ret !penses
7
7
!'I
7
7
3B
As Computed alue [ =n *as# B-O] As Computed alue [ =n *as# + EA].-O Flat $ate As Computed alue [ =n *as# 6.O] As Computed alue [*as# upto B-- 33O on 2as# ot0er4#se $s B86] As Computed alue [ (!mployeeKs F6.O 7
Leave wit%ou t pay
Ca!cu!ati on Period
Per day ca!cu!a tion basis As per alenda r year
A2sent
1ont0
NLA
1ont0
NLA
1ont0
NLA
1ont0
NLA
1ont0
NLA
NLA
7
7 7
1ont0
NLA
7
1ont0
NLA
!mployerKs !' Contr#2ut#on 33O) 6--O of t0at]
As Computed 5alue (=n Current !arn#n"s /otal 6,BO) As Computed alue (=n Current !arn#n"s /otal 8,BO)
7
1ont0
NLA
1ont0
NLA
7
6-
=5ert#me
66
rofess#onal /a
!arn#n"s for !mployees
Ind#ret !penses
=/
No
!mployees 'tatutory Eedut#on
Current ?#a2#l#t#e s
/a
7
7
7
7
7
6.
ratu#ty
ratu#ty
63
'alary aya2le
Not Appl#a2le
68
F aya2le
Not Appl#a2le
6B
!'I aya2le
Not Appl#a2le
Current ?#a2#l#t#e s Current ?#a2#l#t#e s Current ?#a2#l#t#e s Current ?#a2#l#t#e s
=n rodut#on [rodut#on type :=5ert#me] As Computed 5alue (=n Current !arn#n"s /otal)
Dr of m#n
NLA
7
1ont0
NLA
7
7
7
7
7
7
7
7
MS!ab rate for P.*a+ is given be!ow:7
&ffective 3rom
3rom Amount
Amount "pto
-67-87.-6-
3--B----,----9--6B--.B--8----
3--B----,----9--6B--.B--8----
$a!ue )asis
388B B966636B.--
MMS!ab Rate detai!s for Gratuity ca!cu!ation Gratuity ays of a ;ont%s : >5 Number of ;ont%s &!igibi!ity days for gratuity ca!cu!ation per year From /o 6 6 6B
3
Create &mp!oyee groups o to Gateway of Tally> &ayoll I#fo*> E+,loyee Gou,!> )eate Cate"ory Name nder r#mary Cost Cate"ory r#mary Admin r#mary Cost Cate"ory r#mary Sa!es Create &mp!oyees wit% t%e fo!!owing detai!s :
Contat Num2er !71a#l IE *an& Name *ran0 *an& AL Num2er !mployee I/ AN F Aount Num2er !'I Num2er assport Num2er Country of Issue assport !p#ry Eate #sa Num2er #sa !p#ry Eate or& erm#t Num2er Contrat 'tart Eate Contrat !p#ry Eate
r#mary Cost Cate"ory As%is apoor Adm#n -67-7699 !1-6 1ana"er Adm#n#strat#on !l"#n 1ale 67,769, *+ 1r AHay %apoor .9L. C0r#stop0er $oad %ol&ata 7,-- -8 -337..,3-.6 As0P6.Bya0ooo#n '*I !l"#n --9B--63 AANI8B86? 3BB,9-6 JJJ 6-3-, Ind#a -.76.7.-6. 'SI-.B8B 3676.7.-6N3BB8, -67-,7.--B 367-,7.-6.
Category Name nder Eate of ;o#n#n" !mployee Num2er Ees#"nat#on Funt#on ?oat#on ender
r#mary Cost Cate"ory Priya Set%i Adm#n -67-,76999 !1-. 'en#or !eut#5e !eut#5e !l"#n Female
Category Name nder Eate of ;o#n#n" !mployee Num2er Ees#"nat#on Funt#on ?oat#on ender Eate of *#rt0 *lood roup Fat0er L 1ot0er Name Address
3,
Eate of *#rt0 *lood roup Fat0er L 1ot0er Name Address Contat Num2er !71a#l IE *an& AL Num2er *an& Name *ran0 F Aount Num2er !'I Num2er !mployee I/ AN assport Num2er Country of Issue assport !p#ry Eate #sa Num2er #sa !p#ry Eate or& erm#t Num2er Contrat 'tart Eate Contrat !p#ry Eate Category Name nder Eate of ;o#n#n" !mployee Num2er Ees#"nat#on Funt#on ?oat#on ender Eate of *#rt0 *lood roup Fat0er L 1ot0er Name Address Contat Num2er !71a#l IE *an& AL Num2er *an& Name *ran0 F Aount Num2er !'I Num2er !mployee I/ AN assport Num2er Country of Issue assport !p#ry Eate #sa Num2er #sa !p#ry Eate or& erm#t Num2er
-.7-8769. A+ %aran 'et0# 78 CI/ $oad %ol&ata7,-- -68 -337..,9B.8 sP680otma#lom 33.9B--6 '*I !l"#n 3BB,36. JJJ *EFEI8B8.? !6-B,99 Ind#a -.7-,7.-6. D38,98 3676.7.-6. '!.666. -67-,7.--, 367-,7.-6. r#mary Cost Cate"ory Ro%an Agarwa! 'ales 67-976999 !1-3 ;r !eut#5e 'ales !l"#n 1ale -67-B769, A+ As0o& A"ar4al 8B AT"ar 1#str# lane %ol&ata 7,-- -.B -337..B9,8 ro0an0otma#lom 33.B,98. '*I !l"#n 38B,9-B JJJ '!/I88B? '!6-89-, Ind#a -.76.7.-6. /I6B8., 3676.7.-6. I8,9.-6 3
Contrat 'tart Eate Contrat !p#ry Eate
-67-,7.--, 367-,7.-6.
4. Create Sa!ary etai!s for an &mp!oyee Group:
o to Gateway of Tally> &ayoll I#fo*> Salay Deta$l!> )eate 'elet one 2y one 4. Admin >. Sa!es Admin &ffecti ve 3rom
-67-876-
Pay Jead
Rate
*as#
6----
Sa!es Rate Per
SALAR< &*A,LS Pay %ead type Ca!cu!ation *ype
EA
!arn#n"s for !mployees !arn#n"s for !mployees
D$A
!arn#n"s for !mployees
As Computed alue
!arn#n"s for !mployees
Flat $ate
Con5eya ne =5ert#m e ro5#de nt Fund !'I rofess# onal /a
---
1ont0
--
6B--
1ont0
-
-
Dr
!arn#n"s for
!mployees !mployees 'tatutory Eedut#on !mployees 'tatutory Eedut#on !mployees 'tatutory Eedut#on
Computed 2n
on Attendane As Computed alue
*as# 'alary *as# 'alary + EA
=n rodut#on As Computed alue As Computed alue
*as# 'alary =n Current !arn#n" /otal =n Current !arn#n" /otal
49. A!ter Sa!ary etai!s for &mp!oyee: o to Gateway of *a!!y Payro!! ,nfo. Sa!ary etai!s A!ter Se!ect t%e !mployee from t0e ?#st of !mployeesLroup a !ffet#5e from 6L8L.-6- >'elet opy from arent alue for all t0e employees eept r#ya 'et0# 2 *as# of r#ya 'et0# 4#ll 2e $s9---L71 G o5ert#me rate #s $s,-L7 per 0our 44. Attendance $ouc%er &ntry E o to Gateway of Tally > &ayoll ou"'e! > )TRL.F/: Atte#(a#"e In t0e mont0 of EeK6- some employee 0as ta&en lea5e and some 4or&ed o5ert#me ass t0e neessary transat#on 4#t0 t0e follo4#n" deta#ls "#5en 2elo4 a As0#s %apoor 0as ta&en a asual lea5e on 6st EeK6- and 4or&ed 68- m#n as o5ert#me on 36st EeK6- 2 r#ya 'et0# 0as ta&en a asual lea5e on 6st Ee 4or&ed o5ert#me on .nd EeK6- for 3 0rs and a2sent on 36st EeK6- $o0an A"ar4al 0as 4or&ed o5ert#me for . 0our and 3- m#nutes on 6st and .nd EeK6-
39
4>. Attendane '0eet L Attendane $e"#ster $eport: C0e& attendane s0eet and attendane re"#ster report for t0e mont0 of Ee K6- [D#nt: =/ E#splay ayroll $eport Attendane '0eet L Attendane $e"#ster]
48. ayroll 5ou0er entry: enerate t0e pay sl#p of t0e employee as on 36st Ee K6$eord t0e F paya2le entry on 36st Ee K6$eord t0e !'I paya2le entry on 36st Ee K64@. Payment vouc%er entry: =n 36st Ee .-6- salary payment #s made t0rou"0 ICICI *an& =n 36st Ee .-6- F pa#d t0rou"0 ICICI *an& =n 36st Ee .-6- !'I pa#d t0rou"0 ICICI *an& =n 36st Ee .-6- /a pa#d t0rou"0 ICICI *an&
4O. C%eck t%e 3o!!owing Payro!! Report:7 a ay 'l#p 2 ayroll 'tatement ayment Ad5#e d ratu#ty and !pat $eports
45. As%is apoors pay structure %as been revised wit% effect from 947947>944 and t%e detai!s are as fo!!ows. Name *as# EA D$A Con5eyane
2!d Pay Structure $s6---B-O on *as# .-O on *as#+EA $s-- as mont0ly flat rate
=5ert#me
$s- er Dour
New Pay Structure $s66---O on *as# .BO on *as#+EA $s6.-- as mont0ly flat rate $sB er Dour
6, Priya Set%i %as taken advance of Rs.49999 from t%e concern on 4 st 0anuary Rs.4999 is adjusted every mont% from %er sa!ary.
6 uring t%e mont% of 0anuary >944 record t%e fo!!owing emp!oyees !eave taken and overtime worked. &mp!oyee Name As0#s %apoor r#ya 'et0#
Casua! Leave . Eays 6 Eay
Absent 7 6 Eay
4B. Payro!! $ouc%er &ntry: enerate t0e pay sl#p of t0e employee as on 36st ;anuary .-66 Record t%e P3 payab!e entry on 36st ;anuary .-66
8-
2vertime 9- 1#n . Dours
Record t%e &S, payab!e entry on 36st ;anuary .-66
>9. Payment $ouc%er &ntry: =n 36st ;anuaryK .-66 'alary payment #s made t0rou"0 ICICI *an& =n 36st ;anuaryK .-66 F pa#d t0rou"0 ICICI *an& =n 36st ;anuaryK .-66 pa#d t0rou"0 ICICI *an& =n 36st ;anuaryK .-66 /a pa#d t0rou"0 ICICI *an&
>4. C%eck t%e fo!!owing reports :7 a ay 'l#p 2 ayroll $e"#ster ?ed"er !mployee *rea&up d ay '0eet e ayment Ad5#e for t0e mont0 of ;anuary .-66 f F#nally 5#e4 rof#t G ?oss and *alane s0eet
&+port ,mport !port t0e *alane '0eet of your ompany to !el f#le 4#t0 t0e follo4#n" Instrut#ons : 7 Format 'pread '0eet output Name * '0eet J ?' !port #t Create a ne4 ompany 4#t0 t0e name Arun 5t ?td 4#t0 f#nan#al year -67-87.-6- =pen your !#st#n" Company and !port All 1aster 4#t0 J1? Format out put f#le name !JJml [D#nt:E#splay ?#st of Aounts7 !port] =pen Your Eay 2oo& for t0e per#od 68.-6- to 363.-66 and !port #t 4#t0 t0e out put f#le name Eay *oo& Jml =pen t0e ne4 ompany Arun 5t ?td and Import All 1aster from !J Jml f#le 4#t0 /ally [D#nt: =/ Import 1aster ] Import all transat#on from Eay *oo&Jml [D#nt:=/ Import /ransat#on]
Sp!it Company =pen your !#st#n" Company 'tart year end#n" proess 4#t0 spl#t ompany data from 68.-66 [D#nt: Comp Info 'pl#t ompany Eata ]
Group Company ata Create a "roup ompany 4#t0 Qyour name(roup)R 1em2ers of t0e "roup ompany are: F#rst Co (Your e#st#n" ompany ) 'eond Co (Arun 5t ?td) #e4 t0e mer"ed report of t0e "roup o 86