MEN

TallyPrime

Chapter - 1.1
1 Create acompany as below
Company Ltd. - A0016756] mentioned details. [Add vour student code after company name, like Anderson

Company Dta Path

Compeny ame
CUeubltTalyPrdmeDeta
Anderson Company L°d.
Maling Ha
Fnancial ybegiing toen 1dpr20
Address
:Anderson Conpey Ld. Books begivming from 1A0r20
32,8. Kumar Aornu
Arabinda Nag
Kolkata

St :Wet Bengal
Countty
Pincode T0056
Teleghone 03335694506
Mobie 9156344752
Fa
E-mal anderson@gmall.com
Wabsite wwAdenon.to
Bse Curency symbol
Form name INR

2. Alter the E-mail IDas "acl.anderson@gmail.com"

3. Create a folder in D:\ drive with Your Name along with Your Student Code. Then change the default path of
data files as "D:\ Your Name with your student code".
4. Set the configuration in suchaway that when you will open tally your company will open first.
5. Shut your Company.

15
 Chapter - 1.2

below mentioned Irnal

which vou have created in last chapter. Now from the
I. Open the company
Balance create the required ledgers. creation window.
create rest of the ledgersfrom Multi ledger
Note: After creating two ledgers,
For 31-03-2020
Particulars Opening Balance
Debit (?) Credit ()
3,22,000.00
80,000.00
Share Capital
General Reserve 90,500.00
Vehicle 1,12,000.00
Machinery 16,200.00
Cash 1,000.00
Petty Cash 16,500.00
Loan from Anil 1,15,000.00
Loan from HDFC 1,10,000.00
Furniture 2,40,000.00
257896452013458)
Corporation Bank (A/CNo, - 20,600.00
Outstanding Electricity Bill
3,500.00
Prepaid Rent 7,800.00
Investment at IDBI
12,000.00
Drawings 25,200.00
Computer 64,100.00
Profit & Loss A/C 6,18,200.00 6,18,200.00
Grand Total

opening balance 9,500.

2 Nowcreate another ledger as Provisions for Depreciation with
2 Chanethe ledger 'Machinery' as ´Plant &Machinery' and 'Furniture' as 'Furniture & Fixture
4 Now delete the ledger ´Provision for Depreciation'.
Bs using multi ledger alteration change the opening balance of Plarnt &Machinery as &11l000.00
8800.00.
and Investment as
6 Ceck the Trial Balance and Balance Sheet.
Take backup of your company in "D:\Your Name with your student code".
 Chapter - 1.3

Chapter name for the financial vear

your name followed by vour student code and
I.Cete aCompany with
ledgers with opening balances:
of 2020-21. Now, create the following 1,20,000.00, Loan from ICICIBank -
15.000.00, Machinery
Corporation Bank - 2,50,000.00,
Cash -
20,600.00, M/s Chase Enterprises (5undry Debtor) -
Bill - ? willbe treated as
,60,0.00, Outstanding Electricity Creditor) -48,500.00 & remaining amount
(Sundry
1,25,000.00, M/s Style Furniture
ShareCapital.
follows:
and Sundry Creditor are as
2. Details of Sundry Debtor
Sundry Debtor Details
Credit Days Amount ()
Invoice Invoice Number
Name Date 75,000.00
01-01-2020 AGC/220/20-21 30
M/sChase Enterprises 15 30,000.00
02-02-2020 AGC/275/20-21
M/s Chase Enterprises 20,000.00
01-03-2020 AGC/310/20-21 15
M/s Chase Enterprises
Sundry Creditor Details
Invoice Number Credit Days Amount ()
Invoice Date
Name 15 25,000.00
31-01-2020 Inv250/SF/20-21
M/s Style Furniture
Inv290/SF/20-21 30 23,500.00
M/sStyle Furniture 02-02-2020
[Cheque
Electricity Bill by Cheque of Corporation Bank.
no. -

3. On 01.04.2020Company paid Outstanding

478596].
of Allahabad
Chase Enterprises on 02.04.2020 through a Cheque
4. Company received 90,000.00 from M/s of first bill and remaining from second bill.
On the same day
Bank and they want to clear the total amount
no.- 247365]
deposited the Cheque to Corporate bank. [Cheque
Furniture through Cheque of Corporation Bank in full
5. On 02.04.2020company paid 48,000.00to M/sStyle
and final settlement (Cheque no.- 478597]
Corporation Bank.
6. On ûl.05.2020 company deposited cash of ? 10,000.00 into
the month of April'20 35,000.00.
7, On 02.05.2020 Company book the rent in favour of Ultra Properties for
Cheque ot
8. On 31.05.2020 company received the remaining amount from M/s Chase Enterprises through a
HDFCBank and deposited into Corporation bank on the same day. (Cheque no.- 247388]
42,000.00.
9 Go to Daybook modify the amount of the transaction which you passed on 02.05.2020 to
10 Chec the Balance Sheet and Profit & Loss A/c. Also, take the backup on your company.

50)
 Chapter - 1.4

name for the vear

followed by your student code arnd Chapter
1. Create a new company with your name
2020-21.

2. Create the following ledgers with opening balance: Liabilities Amount )

Assets Amount ) 2,22,000.00
1,25,000.00 Capital 1,020.00
Machinery 21,000.00Outstanding Telephone Bill
Cash in Hand 34,980
1,10,000.00|Profit & Loss
|Corporation Bank 2,36,000.00
2,56,000.00
Cheque of SBI
to Smart India Pvt. Ltd. and received a
company sold an old machinery deposited into Corporate Bank on
the same
3. On01.05.2020 [Cheque No. - 145874] and
21,870.00- WDV value is 27,000.00.
in below
day.
salary 55,000.00 depends on the percentage given
paid the staff details of each
4. On 01.05.2020 Company
salary
such a way so that we can be able to view the
mentioned table. Pass the entry in
employee. [Cheque no.- 258745].
Staff Percentage
Saumendu Das 32%
Adrish Chatterjee 38%

Pritesh Singh 30%

business. For that company paid?65,000.00through Cheque of Corporation

5. Company decided toexpand the [Cheque no.- 258746):
various advertisement medium as below
Bank to lndia Printing Ltd. on 02.05.2020 for
1,500.00
A.Poster
1,000.00
B. Leaflets
40,000.00
C.News Paper
. Times of India
10,000.00
12,000.00
ii. Sanmargh
iii.Statesman 18,000.00

D.Websites 4,000.00

E. Banner 5,000.00

F. News Channel 13,500

i. BBC News 8,000.00

ii. Star News 5,500.00

66
 TallyPrime
Company withdrawn ? 5,000.00 from Corporation Bank on
02.05.2020 for office use. [Cheque no. - 258747|.
-Dtthe bank date from Bank Statement on
01.06.2020 as below:
Corporation Bank
Kolkata- 700 001
Account Statement: 01.05.2020 to
Account Number: 47856230145
31.05.2020
Branch Name : Kolkata
Branch ID : 1458
Date Particulars Cheque No. Debit Credit Balance
0105.2020 Opening Balance
110000.00
02.05.2020 Clg 541203 145874 21870.00 131870.00
02,05.2020 IndiaPrinting Itd. 258746 65000 66870.00
31.05.2020 Bank Charges 135.00 66735.00
31.05.2020 Closing Balance
66735.00
8. Now check Profit &Loss A/c,
Balance Sheet, Cost Center and Category Report from appropriate path.
Notes :

67
 TallyPrime

Chapter - 1.5

With your name tollowedby your student code and Chapter name for the year 2020

Caethe tollowing ledgers with opening balance:

Assets Amount () Liabilities Amount )
Computer 25000.00 Capital 320000.00

Stock in Hand 1553335.00 Outstanding Telephone Bill 1020.00

Corporation Bank 110000.00 M/s Anand & Co. 84600.00

Cash in Hand 21000.00 Profit &Loss 1303715.00

21,09,335.00 21,09,335.00

3. Create the opening stock details as follows:

Quantity Godown Rate
Brand Name Model No.
Stock Type (Pcs.)
15 7,844.00
Galaxy J2
Samsung New Alipore 8,990.00
Galaxy J3 12

9 13,999.00
Micromax Canvas 6
Gariahat 43,990.00
Samsung GalaxyNote5 14

Fire 4G 6 5,999,00
Micromax
20 5,850.00
Samsung Galaxy J1
8 Bhawanipore 38,500.00
iPhone SE
Apple 5
724,900.00
iPhone 5s
Galaxy Note 5,5
Samsung Galaxy J3, 3 Pcs Apple iPhone SE, 7 Pes. Samsung
4.On 02.05.2020 transfer 5 Pcs
Pes Micromax Fire 4G to Tollygunj Godown.
5. Now check the Stock Summary report.

Notes:
 TallyPrime

Chapter -1.6
1 Create a new company with your name followed by
your student code and Chapter name for the year 2020
21.
2Create the following ledgers with opening balance:
Liabilities Amount ) Assets Amount )
Capital 2,75,000.00 Furniture 3,26,000.00
Loan from Indian Bank 1,22,000.00 HDFCBank 91,000.00
Profit & Loss 32000.00 Cash 12,000.00
4,29,000.00 4,29,000.00

3. Placed a purchase order on 01/07/2020 to E-world Dealers and for the following products [Order no: EWD/
Ord-00127/ 2020-21]
TVType Screen Size Model No. Quantity Rate

Samsung 22" UA22D50N 10Pcs 7 20,900

LED TV Samsung 32" UA32D40N 3 Pcs 40,900

Sony 32" KDL32E720 12 Pcs 757,900

Samsung 22" LA22D40E1 4 Pcs 715,000

LCD TV KLV40B400 3 Pcs 53,900
Sony 40"
02/07/2020. Challan No. EWD/Ch-00127 /2020-21
4. Following Goods are sent against the above order on
and stored in Park Street Godown.
Model No. Quantity Rate
Screen Size
TV Type
UA22D50N 10 Pcs ?20,900.00
Samsung 22"
LED TV KDL32E720 8Pcs 57,900.00
Sony 32"
LA22D40E1 4 Pcs 715,000.00
Samsung 22"
3 Pcs 753,900.00
LCD TV KLV40B400
Sony 40"
?15,00000
LA22D40E1 4 Pcs
Samsung 22" 53,900.00
LCD TV KLV40B400 3 Pes
Sony 40"
quality (Ref
rejected 1 Pcs of Sony 32" LED TV (KDL32E720) due to bad picture
5. On 02/07/2020company
No: EWD/REJ-01 /2020-21).
the rejected goods on the same date (Ret. No EWD/
immediately and replaces EWD/INV-00127/22021)
b. E-world Dealers responds invoice arainst the goods sent (Invoice No.
Ch-REJO02/2020-21) along with the
95
 Tallylrime

(hapter 7

ea company willh your n

lollowvd by your student code
2020 21 and ceate the followiny ledys withopeniny, balaues adhptt hame for the ina ial yeat
Liabilities
Amount Assets Amount )
Capital
3,54,500, 00 uniture 3,24,/M040
General Reserve
2,4%,6)(00 ock inHand 3,29,20W)0X)
Profit & Loss
32,000,00D Bank
Loan from Indian Bank
1,22,000 (00 Cash 12,/%0 0)
7,52,200.00 7,52,20M).)
2. The opening stock item details are as follows

TV Type Sereen Size Model No. Quantity Godown Rate (3)

Samsung, 22" UA22D50N Strand Road 20),0()
LED TV LG 22" 22L53000 4pes 19,7).00
Sony 22" KDL22FA20 2ps 20,900,(0
LCD TV
Samsung 22" LA22D40EI 4pes 15,000.00
Sony 22" Taratala
KLV22B320 5pes 15,9%0,00
3. A sales order is received on 01/07/20200 from Deepak Electronics for the
following goods [ORD No RE/
ORD-0012/2020-21|
Model No. Quantity Rate ()
22LE53000 (LG 22" LED TV) 4 PCs 22,5/00,00)
LA22D40El(Samsung 22" ICD TV) 4 Pes 18,300,(0
KLV22B320 (Sony 22" L.CD TV) 5 PCs 19400.0)

1 All the product is sent to Deepak Electronics against the above order on the next day. [Challan No, RE/
CH0012/2020-21|
5. On 02/07/2020 they rejected 1 Pcs KLV22B320 (Sony 22" LCD TV) and conpany stored the goods at
laratala Godown. [Ref No: RE/REJ-001/2020-21|
b On 31/07/2020 company raised invoice to Deepak Electronics against the above challan and received 70%
of the total dues by C
Cheque. | Invoice No: RE/Sale-012/2020-21|
7.On 01/08/2/2020 Company purchases some accessories from India Mart (Bill No.SI/INV/0654/ 1112), The
details of the product as mentioned.

(119)
 Bateh No,
MÙg Date
Iys Date Nlred A
Quantity Rate (
Podt laalala
lnatala
1
Rate ()
Quantity
Poduct

Hani Sniti

Hani iWash
Taratal.a (.idow and issev
Compnv stond it at
Wash.
rums 2:NN Hand
hNNWash shns RE/CRN/0/0N-21).
il Ret No (No. 78652] of Asansol btsn. t
Na}ust the Bank'sCheque
a nit dues through Yes
his full
29NMGaeshStonsclear of000.
10 On allwndcash disvåunt
and ompay

Notes :
 Chapter -18 &19
1. Create a company w
with your name followed by your student code and Chapter name for the Financial

Year 2020-21.

2 Create the following ledgers:

Capital - 3,22,000.00, Corporation Bank - 2,80,000.00, Loan from Mittal Traders - 150SS,

Outstanding Salary -8,000.00, Profit & Loss -65,000.00

Mob
Digital Express for 8 Pcs Micromax Canvas 6 where one
3. On 01.05.2020Company placed an order to SanDisk Pen Drive where the scherme is buy 1ge..
Plastic Cover free with each Mobile set. 40 Pcs, 64 GB
PO/009/20-21)
free, 20Pcs Earphone, Samsung Galaxy J3. [Ref. no.:
your company and stored all the iterns into
4. On 02.05.2020, Digital Express delivered all the products to
Bhawanipore Godown. (Ref. no.: DE/CH/020/2020-21]
Micromax Canvas 6 @13,999.00, 64 GB San Disk
5. On 02.05.2020, Digital Express raised a bill where the price of
Pen Drive @620.00, Earphone @150.00, and Samsung Galaxy J3 @8,990.00. They charged loading charges
of 1,500.00 in the invoice Ref. no.: DE/In/2021/025].
9,800.00 to Tech Media
6. On 31.05.2020 Company sold 8 Pcs Earphone @180.00,2 Pcs Samsung Galaxy J3 @
with 1.5% Trade discount on each Pcs [Ref. no: ACL/0050/2020-21].
7. On 31.05.2020 Company paid the entire due amount to Digital Express by Cheque of Corporation Bark
Cheque No: 440330]
8. On 01.06.2020 Company purchased the following products from Ramco Systems Ltd. &set the fixed selling
price for the same and stored all the products into Bhawanipore Godown [RS/ 036/2021]:
Date of Date of Qty Rate )
Item Batch no.
Manufacture Expiry (Pcs) Purchase Selling Price
Junior Horlicks 1 Kg JB/475/120 Feb 20 Jan 21 10 410.00 460.00
Nutrite 200 Grams NT/10/124 Jan 20 Oct 21 15 195.00 21500
Oats 500 Grms KL/142/001 Jan 20 Nov21 9 120.00 135.00
9. On 01 06.2020 Company received the full amount from Tech Media
through a Cheque of HDFC Bank. Gdra
Branch. (Cheque No- 750125)
10.Company sets credit limit of 2500.00 and credit days for 15 davs to
Rosell India Ltd. On 020 U
Companysold 2 Pcs. Junior Ilorlicks and 4 Pes Oats 500
Grms. (Ref. no.: ACL/0052/20-21]
11.On01 07 2021) Company paid full billamount to Ramco
Bank |Cheque No - 440331). Systems Ltd. through a Cheque of Corporat
12On the same day company received the full
o,- 001245| amount from Rosell India Ltd. by a Cheque of UBI.
(hey
(146)
 TallyPrime

Chapter - 1.10

Ceale acopany wih y ae

Tollowed by your student code and Chapter name for the
w)ad ceate te ollowng Tdeh with opening balacets, financial year
Liabilities
Amount ) Assets
Amount (?)
Capital
Loanfrom lndanBank
2,75,000.00 urniture 3,26,000,00
l'roit &Lo
L22,000,00 |DFC Bank 91,000,00
32,000.00 Cash
12,000,00
4,29,000,00 4,29,000.00
) On 0104.2020 Company purchased 25 Pes HCL Tablet o|1200,00 ad 20 Pes
from Deepak . Worl (Bill No, Blue Tooth H850 @ 1200.00
3 On
Inv/P012/2020-21).
0L,05.2020Company received a Cheque of ICICI Bank
SriramFinanceatan interest rate of |3% P'er (Ch. No: 250124) as lo0an of
Annum. Company agreed to pay interest on 225000.00 from
4 Ceate a voucher class quarterly basis.
under Sales Voucher typewilh the
I. Class
following specifications.
Name: Credit Sales
I| Group Include only Sundry Debtors,
I|L 1 %o salesaount should be
translerred to Children Welfare'und butshould not be shown in
invoice.
IV.Total bill will be rounded off rounding, limit 1.
5 On 02,05.2020 Company old 12 Pes
|ICL Tablet @14,500,00 and 12 1Pcs Blue Tooth
Brothers |BillNo: RE/S-O025/2020-21, 15 days credit H850 1,650.00 to Das
period,
period]. P'ass the entry using the Cedit Sales voucher class.
2"% monthly compound interest after
credit
6 On 31.05.2020 Company charged interest on outstanding bill amount to
delay in payment. Pass the required entry so thal the Das Brother as per contract for
required interest amount will update automatically.
7On 31.07.2020 Company issues a Cheque of HDFC Bank (Ch.
No: 250OT25) to clearthe interest on loan from
Sriram Finance,
h On 31 07.2020 Das Brother clear the entire due
amount with interest by Cheque of Axis Bank (Ch No
652321). las the necessary entries.
 Chapter - 1.11

followed by your student code and Chapter name for the financial vese
1. heat a company withvour name
2020-21 Now ceate the tollowing Ledgers.
Amount () Assets Amount )
Liabilities
2,75,000.00 Furniture 3,26,000.00
Capital
Loan from Indian Bank 1,22,000.00 HDFC Bank 91,000.00
Profit & Loss 32,000.00 Cash 12,000.00
4,29,000.00 4,29,000.00

company purchases following

2Companies started manufacturing Chocolate Cakes and for this propose
GB/BILL/088/20-21).
goods from M/s Gangaram Brothers on 01.04.2020 (Bill No.
Product Quantity Godown Rate )
Butter 6 kg 200 /kg
Sugar 10kg 80/kg
Chocolate(Unsweetened) 5kg 650/kg
Flour 15 kg 45 /kg
Milk 12 kg Uluberia 75 /kg
100Pcs 4/Pcs
Eggs
Vanilla Extract 3kg 1000 /kg
Baking Powder 1kg 3700/kg
Salt 1kg 40/kg
**Note: Use alternative units for all items as "grams." [1 Kg=1000 grams]
3. To produce 1.5 Pound of Chocolate Cake the following ingredients and quantities required.
Ingredients Quantity
Butter 125 grams
Sugar 200 grams
Chocolate (Unsweetened) 85 grams
Flour 350grams
Milk 300grams
Eggs 3Pcs

(172)
 TallyPrime
Ingredients Quantity
Tanilla Extract
15 grams
Raking Powder 12 grams
Sult 10grams
.005.2020 Companyproduced 50 Pound of Chocolate Cake and stored it at Uluberia Godown.
aaid Labour Expenses of 1000 in cash. Consider other Company
expenses to get cost of sale as below.
I Factory Electricity- 15% of Material Cost

IL Factory Rent- 5% of Material Cost

II. Administrative Expenses- 2% of Material cost IV.Carriage Expenses -1% of
Material Cost.
5.On 02.05.2020the entire produced cakes have been transferred to
Esplanade Shop floor and incurred 478
as transportation expenses by cash. Revise the cost of goods by
transportation expenses.
6. On 01.06.2020 Company declared a price scheme for the customers as
below.

Scheme Name Product Quantity Sold Level Rate per Pound

Discount
()
Up to 10 pounds 250 Nil
11 to25 pounds 235 Nil
Chocolate
Great Deal
Cake
26 to 30 pounds 235 2%
31 to 40pounds 225 Nil
41 pounds onward 225 3%

7. On 02.06.2020 Company cleared the 50% dues of M/s Gangaram Brothers by Cheque of HDFC Bank
[Cheque No. 666300].
8. On 01.07 2020 Company sold 28 Pound of Cake from Esplanade Shop by cash (Ref No.
C9A/CS/321/20.
21).

(173)
 Chapter -1.12
1. Create a company with your name followed by your student code and Chapter name for the financial vear

2020-21. Now create the following Ledgers.

Liabilities Amount ) Assets Amount )
Capital
2,75,000.00 Furniture 3,26,000.00
Loanfrom Indian Bank 1,22,000.00 HDFC Bank 91,000.00
Profit & Loss 32,000.00 Cash 1,2000.00
4,29,000.00 4,29,000.00

buys stationeries. The

2. On 01.05.2020 Company gives Cash of 5,000 to an employee, Mr. Asim Burman to
actual bill is not confirmed now hence pass the memorandum entry.
to cashier. Make
3. On 02.05.2020 Mr. Asim submitted stationery bill of 4,600 and returned balance amount
necessary effects in books of accounts.

4. On 01.07.2020 Company projected a future sale of 45,000 to M/sMohan's. Now you pass the entry through
optional voucher so that books of accounts will not get any effects.
5. For the mid-term analysis of financial statements on 31.07.2020 pass a reversing journal entry of salary due
for the month of July'2020 of 35,000 and the entry should be reverse after 01.08.2020.

6. Now view the P/L and B/S as on 31.07.2020 by creating scenario including the Optional and Reversing
Journal entries as shown below.

7. Create a budget on Travelling Expense of? 10,000 for the period 01.10.2020 to 31.12.2021. Travelling expenses
is having two categories, i.e. Local Travel (.2,000) and Outside Travel (.8,000).

8.C131.10.2020 Travelling Expenses is paid for ? 2,100. [Local Travel: 550, Outside Travel 1550]

9. Check budget variance report for the month of October 2020.

10.On 02.11.2020 Travelling Expenses is paid for ? 3,200. (Local Travel 1,050, Outside Travel 2,150]
11.Check total budget variance report.

186
 TallyPrime
,MEN

Chapter - 1.13

1Create acompany with your name followed by your student code and Chapter name for the financial year
020-21. Now create the following ledgers.
Liabilities Amount ) Assets Amount )
Capital 3,00,000.00 Furniture 3,26,000.00
Loan from Indian Bank 1,22,000.00 HDFC Bank 91,000.00
Profit & Loss 32,000.00 Cash 12,000.00

Mohan Brothers 25,000.00

4,54,000.00 4,54,000.00

2. Now put the following information in your company:

PAN NO: AEGCR3651K, Address:27, N. S. Road, Dalhousie ldeal Tower, Kolkata -700001
Ltd.
3. On 02.06.2020 Company purchased 12 Pcs Karbonn A3 Plus mobile phone @3,800.00 form ABC
settlement by Cheque of
4. On 02.04.2020 company received .24,500.00 from Mohan Brother in full and final
SBI (Cheque No: 125036)
information:
5. Alter the ledger of Mohan Brother and update the following
Kolkata - 700014.
PAN: AVGCM85691, Address: 37, APC Road,
mobile phone @4,600.00 to Mohan Brothers.
6. On 01.07.2020company sold 8 Pcs Karbonn A3 Plus
vouchers.
7. Export all the masters and
import all the exported data.
8. Now create a new company by your student code and
and Trail Balance in Excel & PDF.
9. Export the Balance Sheet, Profit & loss A/c,
accounts statement of Mohan Brothers.
On 31.07.2020 take a printout of confirmation of

(193)
 TallyPrime

Chapter-1.14
Ceate acompany withh your Mae lollowed by your stulentcole a l Chapter name orthe tiuancal yeat
020-21 and createthe tollowingllgnwitlh openng lalawen.
Liabilities Amount () Assets Amount ()
Capital 3,22000(00 Funiture 2,19,00000

Loan fronn Aadi Brothers I,30,00000 Axin BankLl. 1,45,000,0

M/s Galaxy lntotech 44,000.00 Canh 28,00000

Protit & Loss 0,800.00 Stock 04,800.00

5,06,800,00 5,06,800.00

Stock Details are as below: -

Product Quantity Godown Rate ()
D-Link DI-524 Wireless Router I5 PeN I800,00

Logitech 2.1Speakers System Z3|3 Chandni 2?1500

APC50OVA UPS 15 Pes 290.00

2. Now enabled security control ofyour company ineluding Tally Autit feature aml wet Adumistrator Nanw
as your first nanme and password as your ICA center name in smallcase.
3. Go to Tally Audit Report and aceept all your master's and Voucher Entries till made in the compny.

4. Now create two security levels tor your company with tollowing details,
Accts Executive Stock Executive

Use basic facilities of owner Use basic tacilities of owner

Allowed 31 days for back dated Allowed 15 days for back dated
vouchers VoucherS
> Disallowed Alteration rights of Disallowed Alteration rights
Account Master & Vouchers Avcount Master, Inventory Master &
Vouchers
Disallowed Full Access rights of
Inventory Master & Stock Summary Disallowed Full Access rights of P/L
& Balnce Sheet

E Nw creale iwo users namely Ankit and Sanjit. Ankit is working as an Avount Fxutive and his passwordt
willbe 2345, whereas Sanjitis working as st0Ck Exeutive and his password will b S432L

6 Now shut your company andopen he company using usDame Ankit &his Dassword

(203)
 7. P'ass the following entry under user Ankit. Infotech
issued aCheque (No.556612) of 15,000.00 to M/s Galaxy
a.On 01.04.2020 Company
against his dues.
machinery worth 40,000.00 by Cheque of Axis Bank
purchased
b.On 02.04.2020 Company
(No.556613).
open the company as user Sanjit using his password. Then pass the
8. Now shut companyand again
following entry. C12A/SAL/3214/2020
below goods on 01.08.2020 to M/s Sky Infotech via bill no.
a.Company sold
21.
Quantity Rate )
Product
8 Pcs 2,200
D-Link DI-524Wireless Router
10Pcs 2,150
Logitech 2.1 Speakers System Z313
7 Pcs 2,760
APC500VA UPS

b. On 02,08.2020 Company purchased following

goods from M/s RampalComputers via bill no.
RP/ BILL/2262/2020-21.
Product Quantity Godown Rate ()
10pcs 4,800.00
HP Laserlet1018 Laser Printer
15 pcs Chandni 1,350.00
Logitech Cordless Desktop EX 100
Logitech USB mouse (black) 25 pcs 300.00

and then verify the

9. Now shut the companyand load again as administrator user and password
entries made bydifferent users and accept them.
10.Divide your company in 2 parts so that 1st company willhold only data up to 31.07.2020 and the
rest will be in 2 company.
11.Shut allyouropen companies then load previouscompanyand current company and merge them
in a way so that both companies' data willpresent consolidated reports.
12.Now assign tallyvault password as "ica" for your current company so that no one can identify the
company we are using from selection list of companies.

204)
 TallyPrime
Chapter 1.15 Project on Tally Accounting

Create acompany with the name "Project on Tally Pvt. Ltd. followed by your student code and chapter
name" into "D:\Tally.ERPO\Your Code &Project on Tally Pvt. Ltd." Path for the financial year 2020-2021.
1. Create the following ledgers with opening balances.
Liabilities Amount Assets Amount

Capital 250000 Goodwill 100000

Add: Net Profit 45000 Investment in NSE Nifty 125000
Bees

Less: Drawings 30000 265000 Sundry Debtors:

Capital Reserve 25000 Modern Traders(bill/
sal/123) 15000

Loan from HSBC 30000 Shakti India(bill /sal/126) 14000 29000

Loan from Sharon Stone 20000 Loan to Mr. Prakash 30000

14000 Cash at Bank (SBI) 50000

Outstanding Office Rent
Outstanding Salary 50000 Cash in hand 70000

Total 4,04,000 Total 4,04,000

Note: Configure the Cheque book details for the bank ledger so that at the time of passing any entries Cheque
mumber will be generated automatically.
2. On 01.04.2020 the owner further invests 1,25,000 in Furniture &Fixture.
3. On 01.04.2020transferred ? 5000 from cash to petty cash.
4. On 02.04.2020 Company paid the outstanding office rent by Cheque of SBI.
5. On 02.04.2020 Purchased stationery (Printing Paper - 625, Stapler &Pin - 55, Notebook - 125) by Petty
Cash.

6. On 01.05.2020Company received an order from Style && Spafor manufacturing and supply500 bottles (200
mleach) of Body Oil @220.
of HDFC
7. On 01.05.2020company received 13,500 from Shakti India from their pervious dues by Cheque
Bank [Cheque No: 657653] in fulland final settlement.
within different News
8. Company has decided to allocate Advertisement Expense based on fixed percentage
comparny has paid?
Paper. This distribution is as Telegraph 35% and Times of India 65%. On 02.05.2020
200 by Cheque of SBI.
ADV/ S&S/001] by Cheque of ICICI
9. On 01.05.2020 received ? 25,000 from Style &Spa as advance [Ref No:
Bank (Ch. No: 442021| and deposited the same into SBI.
(205)
1ca
we needthe following
ingredients and quantities. So,
10. For manufacturing of one bottle (200r ml) of Bodv Oil
prepare the production formula.
Oil @50ml. Kapoor @5mg, Haridra @5mg, NeemOl @15ml, Arachis
Glycein@ SOml,Paraffin @20ml. Olive
Oil @10ml, Colour @5ml and Essence @10ml.
Ghosh & Co. and stored at Sealdah
purchased the following materials from
11.On 02.05.2020 Company
Godown. (BillNo: PUR/GC/002)
Trade Discount
Rate
Product Quantity 2%
50000 ml 0.75/ml
Glycerin
10000 ml 1.35/ml
Paraffin
1%
Olive Oil 25000 ml 70.65/ml
5%
250mg 1.20/mg
Kapoor 5%
Haridra 300 mg 72/mg
71.30/ml 2%
Neem Oil 10000 ml
2.40/ml 2%
Arachis Oil 5000 ml
2%
Colour 2500 ml 70.35/ml
5000 ml 0.45/ml 2%
Essence

stored at Sealdah Godown. Company paid Labour

12.On 31.05.2020 Company produced 500 bottles and
Pass the Manufacturing Entry.
Charges of 1200and Electricity @10% of Material Cost.
markup price along with the Challan (No: CH/
13.On 01.06.2020Company sent the entire goods with 20%
S&S/001) to M/sStyle &Spa.
the above Challan and adjust the advance
14.On 02.06.2020 Company sent a Bill (No: SALES/ S&S/001)against
with the invoice.
Furniture World for office Use.
15.On 02.06.2020 Purchased 5 Pcs chair @1800 and 2 Pcs Table @3,200 from
office stationeries. The
16. On 07.06.2020 Companv pays 2,700 to Mr. Rajat (Office Boy) for purchase some
actual billamount is not confirmed. So, pass the appropriate entrv.

17. The firm signed a contract with LG India Ltd who has given 15 days' credit. After 15 davs, the vendor will
charge interest @1.5%/month (30 days) on the pending bills.
18.Purchased the following items from LG India Pvt. Ltd on 01.07. 2020.

206)
 TallyPrime
Product Model Rate ) Oty
LCD TV 47SL90OR 19,500
LCD TV 42SL90QR 21,000
Plasma TV 60PS8OFR 52,000 1
Flat TV 21FD5WGE 9,000 2
Flat TV 21FD5RGE4 9,500 2

Flat TV 21FG6RGE4 8,700 4

19. Thefollowing table is showing the details of cash sales made:

Date Product Qty Rate )
02.07.2020 21FG6RGE4 1 11310
02.07.2020 21FG6RGE4 1 11,310
31.07.2020 21FD5WGE 1 10,800

20. Export the Balance Sheet in Excel Spread sheet "D:\Tally.ERP9\Your Code &Project on Tally Pvt. Ltd."
Path.
Admin
21. Set security control of your company including Tally Audit feature and set Administrator Name as
and PasSword as "CIA".

22. Create auser namely Ankit as an Accounts Executive arnd his password will be 123 (He only able to create
masters and vouchers, not able to view Reports or Edit and Delete vouchers and Transection)
23. Pass the following entry under user Ankit.
a. On 01.07.2020purchaseda machinery from Bengal Machinery of 1,75,000.
b. On 02.07.2020 withdrawn 12,000from Bank.

207