Tally Prime

A COMPLETE ASSIGNMENT OF TALLY PRIME

Priyansh Mishra
 Unsolved : 1

Company Creation

1.. Directory C\Tally\Data

[Link] Your Name

[Link] Name Same as above

[Link] Your address

5. Statutory compliance for India

[Link] Utter Pradesh

[Link] Code Post cost of your city

[Link] No. Your No.

9.E-mail Address Your Email Id

[Link] Symbol Rs.

[Link] Year From 01/04/2017

[Link] Beginning Form 01/04/2017

[Link] Vault Password No

[Link] Security Code Yes

2
 Unsolved ; 2

Balance Sheet
Liabilities Assets
Capital Account Fixed Asset
Equity Share 3,20,000 Computer 1,50,000
Preference Share 5,58,000 Furniture & Fixture 1,45,000
Reserve & Surplus Land & Building 3,60,000
Capital Reserve 3,30,000 Motor Vehicles 2,80,000
General Reserve 2,00,000 Other Equipment 1,45,000
Loan (Liability) Investment
Bank O/D at IDBI A/C 3,43,324 NSC 1,27,900
Loan from Director 5,05,857 Share of Reliance 50,000
Current Liabilities Current Asset
O/S Generator Supply 30,000 Closing Stock 7,34,000
O/S Salary 35,509 Deposit Asset
CST Payable 18,000 Security Deposit 42,300
UPTT Payable 22,000 KVP Certificate 7,500
Provision for Taxation 32,900 Telephone Deposit 7,500
O/S Audit Fees 9,500 Loan & Advance
O/S Electricity Bill 5,559 Advance Salary 26,000
O/S Printing & Stationery 1000 Loan to Delta Enterprises 50,000
O/S Rent 12000 Sundry Debtors
O/S Telephone Bill 6,950 Raj & Raj Ltd. 30,000
Sundry Creditor Supreme World 1,70,000
Delta Enterprise 70,000 Computer World 1,00,066
Super Tec Pvt Ltd 1,50,000 Cash-in-Hand
Phillips-Smart 1,50,000 Cash 375,333
Total 2800599 Total 2800599

Party Bill Detail

Delta Enterprise Bill/Dlt/345 01-03-2017 35000.00

Delta Enterprise Bill/Dlt/423 02-03-2017 15000.00
Delta Enterprise Bill/Dlt/501 31-03-2017 20000.00
Sundry Super Tec Pvt. Ltd. SS/5001 01-03-2017 30000.00
Creditor Super Tec Pvt. Ltd. SS/5201 02-03-2017 70000.00
Super Tec Pvt. Ltd. SS/5602 31-03-2017 50000.00
Phillips Smart Ps/567 02-03-2017 35000.00
Phillips Smart Ps/1000 02-03-2017 70000.00
Phillips Smart Ps/1402 31-03-2017 45000.00
Total 370000.00

3
 Raj & Raj Ltd. BILL/RAJ/500 02-02-2017 30000.00
Supreme World BILL/SW/1000 02-02-2017 50000.00
Supreme World BILL/SW/1210 01-03-2017 60000.00
Supreme World BILL/SW/1245 02-03-2017 30000.00
Supreme World On Account 02-03-2017 30000.00
Computer World CM/1100 01-02-2017 35000.00
Computer World CM/1299 02-02-2017 35000.00
Computer World CM/1302 02-02-2017 30066.00 Displa
Total 3,00,066.00
y
Opening Trial Balance:

Gateway of Tally (GOT)-> Display->Trial Balance

Note:- press F 12. To configure the Trial Balance to show only Opening Balance say. Yes for Show
Opening Balance option.

Display Balance Sheet (as on 01/04/2017) GOT-> Balance Sheet.

Note: Press Alt +F1 to get details view to the report.

Display Outstanding Bill wise details of Debtors/Creditors.

GOT -> Display-> Statements of Account->Receivables/Payable

Payable=370000, Receivable=400066, Balance Sheet=2800599.

Unsolved : 3
Inventory Master

Stock Electronic

Stock Categories: Television, AC, Refrigerator.

Godown : Ashok Marg, Gomti Nagar

UOM: PCS

Opening
Stock Stock UO Quantity
Item Rate Total
Group Category M Ashok Gomti
Marg Nagar

4
 IGO Colour 21 Electronic Television Pcs 16500.00 165000.00
6 4
inch

Samsung Electronic Television Pcs 13750.00 110000.00

3 5
Plazma 24 inch
Lg Cool 165ltr Electronic Refrigerator. Pcs 6 4 20000.00 200000.00
Voltas 2 Ton Electronic AC Pcs 2 6 32375.00 259000.00
Total 734000.00

Display Balance Sheet (as on 01/04/2017): GOT> Balance Sheet: (Closing Stock 734000)

Note:- Press Alt +F1, which wi9ll show detail information of Balance Sheet as well as Closing
Display Stock Summary: GOT>Stock Summary.

Display Item-wise Stock report:GOT>Display>Inventery Books>Stock Item

Display Group-wise Stock report: GOT>Display>inventery Books> Group Summery

Display Godwon wise Stock report: GOT>Display>Statement of Inventroy> Godown wise Stock.

Unsolved : 4

Vouchers Entries

Press the following entries:-

(1) Open a new account in SBI A/C No. 98765 by depositing amount Rs. 1,30,000/ in cash as
on 01.04.2017 check book number 234501 to 234550.
(2) On 01-04-2017 Company Transfer Cash to Petty Cash worth Rs. 5000 for daily expenses.
(3) Purchase Stationery for Rs. 1500 form petty cash as on 01-04-2017.
(4) CST and UPTT Payable Cleared through SBI Account Cheque No.234501 Amounting Rs.
18000 and rest of the amount by cash Rs. 22000. Respectively on 02 -04-2017.
(5) Received the cheque No 8779547 of IDBI bank for Rs. 60000 on 02-04-2017 from Supreme
World against the bill no. [BILL/SW/1210] and deposit into SBI bank on same day.
(6) Paid to Delta Enterprise amounting Rs. 15000 against the bill No. [BILL/DLT/06-07/345]
through SBI Bank as on 02-04-2017 Cheque No 234502.
(7) Purchase Generator for office use worth Rs. 20000 from TISCO as on 02-04-2017 Ref
[TIS/023]
(8) Received the cheque no 6565657 of ICICI bank amounting Rs. 105000 on 02-04-2017 from
Supreme World against the full and final settlement outstanding bills and deposit the cheque
into SBI A/C No. 98765 on same day.
(9) Withdraw from SBI amounting Rs. 15000 on 02-04-2017 cheque no 234503.
(10). Paid for Tea & Biscuit amounting Rs. 125 from petty cash ofn 02-04-207.
(11). Full amount paid SBI Cheque No. 234504 [Auto] to Philips-Smart against the Bill No.
[PS/567,
5
PS/1000, PS/1402] on 02-04-2017 and get 5% discount.

6
(12). Cleared O/S Electricity Bill and O/S Printing & Stationery through cash on 02-04-2017.
(13). Commission Received in cash Rs 15000 on 02-04-2017.
Net Profit Rs.15,875 Balance Sheet Total Rs. 26,24,915

Unsolved : 5
Cost centre
& Categories

Cost categories: Furniture Telephone, Salesman, Stationery

Cost Centre: Table, Chair, Desk [Under furniture] 05223918216, 05223918217 [Under Telephone].
Mr. Aman, Mr. Robert [Under Salesman] Ruler, Carbon, Stapler [Under Stationery.
1). Purchase Furniture worth Rs. 15000 [Table 4000, Chair 3500, Desk 7500] for cash on
1/05/2017.
2). Cleared O.S Telephone Bill worth Rs. 6950 [05223918216 for Rs. 2000/- and rest for
05223918217 on 01/05/2017 through SBI Cheque no 234505
3). O/S Rent Cleared through cash on 01-05-2017
4). Withdrew from SBI bank for Rs. 6000. Dated 01-05-2017 Cheque no 234506
5). On 01-05-2017 Commission paid to Salesman for Rs. 3000 with equal between salesman dated
2/05/2017 Mr. Aman & Mr. Robert.
6). Stationary purchased of Rs. 1000 ( Ruler 300, Carbon 300, Stapler 400) in petty cash.
Display Balance Sheet GOT>Balance Sheet 26,01,965 Profile & Less as on 02-05-2017 Net Profit
11875/-
Display Day Book GOT> Display>Day Book
Display Cash//Bank Book: GOT>Display >Account Books>Cash/Bank Book (s)
Display Ledger-wise report :GOT>display>Account Book>Ledger
Display Group-wise report : GOT>Display>Account Books>Group Summery
Display Journal Register : GOT>Display>Accounts Book>Journal Register
Display Cost Centre-wise report : GOT> Display>Statement of Account > Cost Centers> Cost
Centre Break-up/Ledger Brea-up/Group Break-up [ for Indirect Expenses Group]
Display Cost Category-wise report : GOT>Display>Statement of Account> Cost Centers>
Category Summary

Unsolved : 6
Purchase/Sales

7
Create the Following Ledger

1. Name : Purchase
Under : Purchase Account
Inventory value are effected : Yes
Cost Center are Applicable : No
2. Name : Sales
Under : Sales Account
Inventory value are effected : Yes
Cost Center are Applicable : No

1). On 01-06-2017 Company placed and Purchase order to Phillip smart order No.
[PS/OD/3300] for 5pcs BPL Zoom 21” and 8 Pcs Lg-Flatiron 24”.
2). On 02-06-2017 Company received a Purchase Challan from Phillip-Smart Challan No.
[PS/CH/07-08/344] against the Order No. [ PS/DD/07-08/3300]
3). On-same day Philip-Smart Send an invoice BPL Zoom 21” @ Rs. 9000 & Lg-Flatiron 24”.
@ 10000 to us Ref N0. [ PS/BILL/07-08/900] ….challan No. [PS/CH/07-08/344]
4). Purchase made on 02-06-2017 from E-Zone 5 Pcs Sony DVD @ Rs. 12000, against Cash
No. [E-Zone/cash/999], the Company issue cheque of SBI cheque No. 9999.
5). On 02-06-2017 Cash Paid Rs. 20000 to philip Smart against the Bill No. [PS/BILL/07-
08/900].
6). On 02-06-2017 Company Received an Order of 5 BPL Zoom 21”. @ 12000 and 2Pcs. Voltaz
2ton Ac @ 35000 from Supreme World Order No. [RER/ORD/07-08/001]
7). On 02-06-2017 goods Delivered to Supreme World Challan No. [RLR/CH/123] against the
Order No.[RLR/ORD/07-08/001].
8). On a Same Day Bill Send to Supreme World Bill No. [RLR/BILL/333] against the Challan
No. [RLR/CH/123].
9). On 02-06-2017 Received a cheque No. 223344 of ICICI Bank on 02-07-2017 from Supreme
World against the bill No. [RLR/BILL/333] and allow him Discount @ 6%.
Display Profit & Loss A/c: GOT>profit & Loss Account G/P -20250 & N/P- 24,325
Display Balance Sheet (as on 02-06-2017) GOT>Balance Sheet Total B/S- 27,04,415
Display Purchase Register GOT>Display>Account>Books>Purchase/Sale Register
Display Purchase Order GOT>Display Inventory Books>Purchase/Sale Orders Books
Inventory Movement Analysis report: GOT>Display>Inventory Books>Movement Analysis>Stock
Group/Stock Item Analysis
Display purchase Bills Pending :GOT<Display>Statements of Inventory>Purchase/ Sate Bill
Pending

8
Display Stock Query report: GOT>Display>Statements of Inventory>Stock Query
Display Godown-wise Stock report : GOT>Display>Statements of Inventory>Godown

Unsolved : 7
GST

Activate GST Option for UP with GSTIN/UIN No 09AAAAA1234A1Z1

Create the Following Ledger

1. Name : Purchase GST

Under : Purchase Account
Inventory value are effected : Yes
Is GST Applicable : Applicable
Set/Alter GST Detail : No
Types of Supply : Goods

2. Name : Sales GST

Under : Sales Account
Inventory value are effected : Yes
Is GST Applicable : Applicable
Set/Alter GST Detail : No
Types of Supply : Goods

3. Name : Input CGST

Under : Duties & Taxes
Type of Duty Tax : GST
Tax Type : Central Tax

4. Name : Input SGST

Under : Duties & Taxes
Type of Duty Tax : GST
Tax Type : State Tax

5. Name : Output CGST

Under : Duties & Taxes
Type of Duty Tax : GST
Tax Type : Central Tax

6. Name : Output SGST

Under : Duties & Taxes

9
 Type of Duty Tax : GST
Tax Type : State Tax

7. Name : Round Off

Under : Indirect Exp.
Inventory value are effected : No
Cost Center are Applicable : No
Is GST Applicable : Not Applicable

1). On 01-07-2017 Company Purchase 10 Pcs Oscar DVD (HSN-09211) @ Rs. 6000 from
Galaxy world GST/TIN No 09AAAAA1234A1Z2 with GST @ 12% Bill No.
[GW/INV/450]
2). On same day Company purchase 7 Pcs Home Theator (HSN-09212) @ Rs. 4000 with GST
@ 12% from E-Zone GST/UIN No 09AAAAA1234A1Z3 Bill No. [E-ZONE/Cash]
3). Cash Paid to Galaxy World of Rs. 60000 against the bill no . [GW/INV/450]
4). On 02-07-2017 company sold 6 Pcs Oscar DVD @ Rs. 10000 and 5 Pcs. IGO Color 21”
(HSN-09213 GST @ 18%) @ 18000 each to Crystal House GST/TIN No
09AAAAA1234A1Z4 Bill No. [ RLR/BILL/001] with GST @ 12%
5). Receive cash from Crystal House against the Bill No. [ RLR/BILL/124] on 02-07-2017
6). On 02-07-2017 Company sold 5 Pcs LG Cool @ 23000 (HSN-09214 GST @18%) and 4
Pcs. Home Theator @ Rs. 4500 for Cash Bill No. [CASH/002] to Consumer.
7). Truck (HSN-09214 GST @18%) Purchase from Ashok Automobile GST/TIN No
09AAAAA1234A1Z5 on 01-07-2017 for Rs. 500000. But 20% Down Panyment made
through Cheque of SBI Bank Cheque No. 234506 for [Note: First Credit Adjustment of GST
will be made].
8). On 02-07-2017 Company Purchase 5 Pcs Oscar DVD @ 5600 from DVD Complex
GST/TIN No 09AAAAA1234A1Z6 with GST @ 12% Bill No.[DDC/07-08/987]
9). Company Sold 2 Pcs Home Theater @ Rs. 6500 to Mimbai Electric GST/TIN No
09AAAAA1234A1Z7 Sold on 02-07-2017 with GST @ 12% Bill No. [RLR/GST/003]
10). On 31-07-2017 Company made a GST adjustment entry and transfer the amount to GST
Payable [Note: pass the entry in GST Adjustment Voucher]

Display GST report: GOT>display>Statutory Reportsdgfds>GST Reports>GST Computation

Display CST Report:GOT>Display>Statutory Reports>CST Reports

Unsolve : 8
Debit/Credit Note
Rejection In/Out

10
All the Following items consist of GST @ 12%
1). On 01-08-2017 Company return 1 Pcs Home Theater return to E-Zone due to damage in
cabinet Ref: {RET/E-ZONE/100]
2). Company Purchase the following item 6 Pcs LG sharp HSN Code 09215 @ Rs. 10000 from
E-Zone Ref: [Ezone/07-08/RTS 6] on 01-08-2017.
3). On 02-08-2017 Company Return 1 Pcs lG sharp to E-Zone against the Bill No. [Ezone/07-
08/RT6] due to damage of goods. Ref: [HND/RET/009]
4). On 02-08-2017 Company Sold 2 Pcs LG Sharp @ Rs. 12000 to Mercury Electrical
09AAAAA1234A1Z8 Ref : [ REL/BILL/004]
5). ON 02-08-2017 Due to change in Rate of LG Sharp Company send debit Note to Mercury
Electronic worth Rs. 1000 Ref: [ DBN/90]
6). On 02-08-2017 received a Cheque of IDBI Bank Ch No. 8765 from Mercury Electronic and
deposit in SBI Bank.
7). On 02-08-2017 Company Received order of 3 Pcs LG Sharp from Sahara Complex
09AAAAA1234A1Z9 Order No , [ RLR/OD/07-08/456] and on the same day Challan send
to Sahara Complex Challan No. [RLR/Ch/456
8). Due to poor Quality at cabinet Sahara Complex return 1 Pcs LG Sharp to us on same day.
9). Bill Send to Sahara Complex bill No Rlr/Bill/456 @ 12500 each.
GOT-Sytock Summary.
GOT>Display->Inventory books->Stock items.
GOT->Display->Accounts books->ledger->

Unsolved : 9
MRP, Importy Export

MRP.[ActuGSTe MRP]. Import & Export.

1). On 02-08-2017 company purchase 6 Pcs 1-pod@Rs.2000 [MRP:2500] from Dalta Enterpise
GST No 09AAAAA1234A2Z1 Rdf: [DE/BILL/07-08/388].
2). On 02-08-2017 Company sold 2 Pcs I Pod @ 2200 each in Csah. Bill no Cash/006
3). Purchase the following items 5 pcs Mp3 @Rs.1500, 10 Pcs Oscar DVD @Rs. 5600 from
Sahara Complex GST No 09AAAAA1234A2Z2 Ref; [SC/BILL/499] on 02-08-2017.
4). Export 4 pcs Mp3 @ Rs. 1800 to singapore on 02-08-2017 bill no Export/006
5). On 02-08-2017 Company made a GST adjusment Entry and transfer to GST…………

11
 Unsolved : 10
Voucher Class

GST@12% [SGST @ 6%, CGST@ 6%] Inclusive.

GST@4% [SGST @ 6%, CGST@ 6%] Exclusive.
1). On 01-09-2017 Company Sold 4 pcs Oscar DVD @ Rs. 6200 to Europe Reflect GST No
09AAAAA1234A2Z3 Ref: [RLR/BILL/007] (Voucher Class: Sales@4%, Output GST@4%
Inclusive).
2). On 01-09-2017 Company sold 4 Pcs Oscar DVD @ Rs. 6200 to Super Tec. Pvt. Ltd. GST
No 09AAAAA1234A2Z4 Ref: [RLR/BILL/008]. (Voucher Class: Salas@4%, output
GST@4% Exclusive)
3). Made refreshment expenses for Rs. 200 on 01-09-2017 [Tea Rs.80, Biscuit Rs. 120]
4). Transfer cash to petty Cash worth Rs. 4000 dated 01-09-2017.
5). Stationery purchase for cash Rs. 1200 [Carbon Rs. 400,, Stapler Rs. 600, pen Rs. 200] on 01-
09-2017.
6). Received commission in Cash on 01-09-2017 worth Rs. 2000.

Unsolved : 11
Manufacturing

1). Company Purchase the following intems for production 5pcs Moniter 19 inch. @Rs.1000,
5pcs CPU @ Rs. 10000, 5pcs Ram @Rs.500, 5pcs Mother Boad @Rs. 2000, 5pcs Cabinet @ Rs.
800, 5pcs Mouse @ Rs. 200, 5pcs Keyboard @ Rs. 150, 10pcs Speaker @ Rs. 400, 5pcs UPS @
Rs. 1500, from Chital House Ref: [CH/BILL/1002] on 01-10-2017.
2). Create Product on formula
Computer
Moniter 19 Inch 1pcs
CPU 1pcs
RAM 1pcs
Mother Board 1pcs
Cabinet 1pcs
Mouse 1pcs
Keyboard 1pcs
Speaker 2pcs
UPS 1pcs

12
3). Create Voucher Class for Manufacture entry.
4). On 02-10-2017 company manufactured 3 Pcs Computer Some Additional cost made with
Labour Charge Rs. 200, Packing Charge Rs. 400.
5). On 02-10-2017 Company Sold 2pcs Computer to Mr. Agaral at 8% profit on production rate.
Cost of Computer Rs.17150/- Selling Price of Computer Rs.18522/-
GOT->Inventory books->Movement Analysis->Stock Group/Item Analysis.
GOT->Display->Statement of Inventory->Stock Query/Godown.

Unsolved : 12
Price List

Scheme Name Dhamaka Offer as on 01-11-2017

1). Sold 1Pcs Mp3 to Mr. Robert Solomon peter on 02-11-2017 under the Scheme give above
Ref: [RLR/BILL/790]/
2). Company Offer the scheme (Dhamaka Offer) to Mr. pradeep Bardhan on 02-11-2017.
3). Nokian92 Purchased for owner’s Son for Rs. 13000 in cash on 02-11-2017.
4). Company Conduct an interview on 02-11-2017 for the post f Jr. Accountant salary package
of Rs.5000 pm.
5). 5 bottle Cold drinks @ Rs. 10 purchase for the interviewee and payment made in cash.
6). On 02-11-2017 cash sale made of one Oscar DVD to Mr. Randhir Kaur in Cash. Ref
[CASH/899]

Unsolved : 13
TCS
TCS (Tax Collection At Sources).

13
ActiGSTe Enable… Collected at Sources (TCS) (Yes)
Set Alt ….. TCS details (Yes).
Ledger creation for TCS.
1). Name Sales Alcohohc Liquor
Under Sales Account
Inventory Value are effected Yes
2). Name Strocks
Under Sundry Debtor
Maintain balance Bill-by-Bill Yes
Is TCS Applicable Yes
Buyer Aessee Company Resident
3). Name Chives
Under Sundry Debtor
Maintain balance Bill-by-Bill Yes
Is TCS Applicable Yes
Buyer/lessee Individual/HUF Resident
4). Name TCS on Alcoholic Liquor
Under Duties & Taxes
Type of Duty tax TCS
Nature of Goods Alcoholic liquor for human consumption

Purchase the following Item

Item Name Under TCS Nature of Unit Rate Amount
Goods

8PM Hard Drink Alcoholic 100 175 17500

Liquor for
Bagpipper Hard Drink 50 200 10000
Human
Green Label Hard Drink Consumption 100 210 21000

1).10 Bottle 8PM @ Rs. 190, 20 Bottle Bagpiper @ Rs.220 each sold to Strocks with TCS on 1
Dec 2019 Bill No. Bill/Strocks/455
2).Cash received from strocks against the bill no Bill/Strocks/455

14
3).On 2 Dec 2019 Company sold 20 Bottle 8PM @ 190 and 20 Bottle Green Label @ 250 with TCS
to Chivas Bill No Bill/chivas/456.
4).Cheque received from chivas against bill no Bill/Chivas/456
5).All TCS paid trough cheque of SBI Bank Cheque no. 234508

Unsolved : 14
TDS Activation

SL. No. Particulars Threshold TDS

Limit Rate
(&)
1. Payments to Advertising Agency 20,000 1% *
2. Commission & Brokerage (other than 5,000 10%
transactions relating to Shares & Securities
3. Payment of fees to Professionals Technical 30,000 10%
Services
4. Payment of Rent 1,80,000 10%

1) On 01-12-2017 Salary paid to Mr. Sanjeev Srivastava (Individual/HUF Resident) from

SBI/Vc 98765 for Rs. 20000 after dedu8ctin TDS [ Income Tax 10%] Ref [ SAL/01]
2) On 01-12-2017 Office Rent paid to Landlord Abdul Aziz [ Individual/ HUF Resident] for Rs.
25000 and deducted TDS deducted from the amount [ Income Tax 10%] Ref.[RNT/02]
through SBI cheque No. 9999.
3) On 01-12-2017 Advertisement Contract was made with Hindustan Times [ Company
Resident] Rs. 40000 the amount will be set off in 3 years Deduct TDS [ Income Tax 1%]
Ref; [ADV/05]
4) Commission paid on 02-12-2017 to Sails Agent Pankaj Kumar [ Individual/HUF Resident on
02-12-2017 for Rs. 30000 through SBI A/c 98765 and deducted TDS from him [Income Tax
10%] Ref [COM/10]
5) On 31-12-2017 all the TDS outstanding amount cleared from SBI A/c 98765
GOT>Display>Statutory Report>TDS report
Display TDS outstanding Report: GOT>Display>Statement of A/c > TDS outstanding >TDS
Computations.
Display TDS Payable Report: GOT> Display>statement of A/c>TDS Payable

15