[go: up one dir, main page]

0% found this document useful (0 votes)
220 views18 pages

TALLY Assignment

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
220 views18 pages

TALLY Assignment

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 18

TALLY-PRIME PRACTICAL

QUESTIONS(SAMPLE) (DAY-1)

1. Create a Company as “Sagar Industries Ltd.” in Tally with


inventory management.

LEDGER CREATION
Ledger Name Group Name
Advance Consulting Revenue Current Liability
25000
Advertise Expense Expense Indirect EXP 6500
Air Conditioner Fixed Assets
120000
Alfatech Solutions Sundry Debtors 2500

Bad Debts Expense Indirect 500


Bank Charges Expense Indirect 5000
Bills Payables Current Liability 8000
Bills Receivable Current Assets
6000
Cab Hiring Charges Expense Indirect 4500
Carriage Inward Direct Expense
6000
Carriage Outward Expense Expense Indirect
1500
Cash Cash in Hand
250000
Cellular Phone Fixed Assets 25000
closing Stock of Stationery Current Assets 250
Commission on sales Expense Indirect
4500
Computer Fixed Assets 90000
Consulting Revenue Direct Income
750000
Conveyance Exp Payable Provisions
1500
Conveyance Expense Expense Indirect
5000
Data Tech Computers Sundry Debtors
6500
Depreciation Expense Expense Indirect
25600
Debenture Discount Misc. Expense (Assets) 500

Discount Expense Expense Indirect


5600
Discount Received Income indirect 5500
Donation Expenses Expense Indirect 4850
Drawings Capital Account 10000
Electrical Fittingss Fixed Assets
250000
Electricity Expense Payable Provisions 5600
Electricity Expense Expense Indirect 9500
Ensign Multimedia Sundry Debtors
6500

CASH – BANK TRANSACTIONS


1- April 1) Started a new Business with capital of Rs
1,00,00,000 in cash
2) Opened a bank account with HDFC bank and Deposit Rs
6000000
3Purchase Stationary by cash worth Rs 15000.
4) Receive Consulting Fees Rs 150000
6) Paid Office Rent By Cheque Rs 8000.
7) Paid salary Rs 1500 by cash.
8) Paid Telephone Expense by cheque 8500
9) Paid Electrical Expense by cash 21750
10) Receive Consulting Fees by cash Rs 96000.
11) Withdraw Rs 5000 for personal use from bank.
12 Receive cash for consulting fees Rs 120000
13) Paid Salary Rs 18000 by cash.
14) Paid office Rent Rs 8000 by cheque.
15) Paid Telephone Expense Rs 7500.
16) Paid Electrical Bill of Rs 9500 by cheque.
17) Purchase a new cabinet worth Rs 10200 by cash
Purchase Entry:
1- Aug) 1) Purchase Goods worth Rs 12000 from Raj & Co.
2) Purchase Goods worth Rs 18000 from Raj by cash.
3) Paid Rs 11500 to Raj & co.
4) Purchase goods worth Rs 30000 from Jayesh.
5) Purchase Goods worth Rs 15000 from Swati Trading.
6) Purchase Goods worth Rs 5000 by cash.
7) Purchase goods worth Rs 12000 from Dolly.
8) Paid 80% of bill amount to Jayesh.
9) Paid Rs 15000 to Swati Traders.
10) Paid Rs 12000 to Dolly by Cheque.
11) Purchase Goods worth Rs 21500 from Sultan
12) Purchase Goods worth Rs 6000 from Jayesh.
13) Paid Full Amount To Jayesh.
14) Paid Remaining Amount to Raj & co.
15) Purchase Goods worth Rs 500 by cash.
2. Pass the following Entries :-
(i) Sagar started “Sagar Industries Ltd.” by bringing Capital
Rs.3, 00,000/- Cash.
(ii) He deposited Rs.1, 00,000/- cash at ICICI bank.
(iii) He paid electricity bill for Rs.1, 200/- by cash.
(iv) He withdrawn Rs.10, 000/- cash for his personal use.
(v) He purchased the following item from Computer Lab. Ltd. on
credit with (a) Computer - 10 Nos. - @20000/- each
(vi) He sold the following item to Somnath Traders in cash with
(a) Computer - 5 Nos. - @27500/- each

(vii) He received Rs.6, 000/- as commission from Rohit by cash.

(viii) He paid House Rent for Rs.5, 000/- by cash.

(ix) He withdrawn Rs.25, 000/- cash from ICICI Bank.

(x) He purchased furniture for Rs.25, 000/- by cash for office


use.

3. Show the Trial Balance and Balance Sheet of “Sagar


Industries Ltd.”

4. Show the Cash Book & Bank Book of the company.

5. Show the Day Book.


(DAY-2)
Inventory Practice

Exp-1. Create Inventory Entry in Electronics Mart.

Cash Balance: - 2, 00,000


Bank Balance: - 2, 00,000

Creditor: - Sun Electronics


Debtors: - Moon Electronics

Stock Item
Opening Purcha Sales Closi
Stock se ng
QT Price QTY QT Pric Stock
Y Y e
Samsung Galaxy 10 1149 15 20 1444 5
F41 9 9
Realme 7i (up to 10 8999 15 20 1079 5
128 GB) 9
Poco c3 10 4749 15 20 6749 5
Oppo A52 (4 GB 10 1099 15 20 1299 5
128 GB) 0 0
Poco X3 10 1499 15 20 1699 5
9 9
Realme 7Pro 10 1699 15 20 1999 5
9 9
Realme C15 (up to 10 6499 15 20 8499 5
4 GB)
Realmenarzo 20A 10 6499 15 20 8499 5
Infinix Note 7 (4 10 7990 15 20 9999 5
GB)
OPPO Reno2 F (6 10 1499 15 20 1699 5
GB 256 GB) 0 0
During creation of following items use
Units: Nos
Set Standard Rates (Yes) : Provide Rate of respective item from
below table.
Opening Balance : Quantity of item
Godown : Onside and Warehouse, as mentioned below (Do’t fill
rate here)

Standar Selling
Item Unde Quanti Wareho Amou
d Cost Price
Name r ty use nt
Rate Rate

P086 Syste
750 940 8 1 6000
MX m

P092 Syste
900 1130 15 13 13500
MX m

P110 Syste
1030 1290 12 10 12360
MX m

MBP
Parts 240 320 2 0 480
133

MBP
Parts 285 380 6 0 1710
150

MBP
Parts 335 450 10 0 3350
166

Eight
Gold 8 45 60 2 0 90
Speed

Silver Eight 55 70 4 0 220


8 Speed

Brown Eight
60 80 4 0 240
8 Speed

Gold Ten
75 100 25 0 1875
10 Speed

Silver Ten
95 130 20 0 1900
10 Speed

Data
Base Ace 175 250 10 0 1750
A

Speed
Short Ace 155 220 15 0 2325
A

Data
King 100 150 7 0 700
Base K

Speed
Short King 140 200 8 8 0 1120
K

Data
1
Base Queen 210 306 10 0 2100
0
Q

Cost Centers & Category

Cost Category = Department Cost Centre = Employees


F 11 –Accounting Features— Maintain Cost Centre---Yes More
than one Payroll/cost Category—Yes
Account Info Cost Category
Create Account Info Cost Centre Create
Cost Category Cost Centers
Administration Staff 5 (with 1 HOD)
Marketing Staff 5 (With 1 HOD)
Clerks 4
Peon 2
Counselors 3
Technical Staff 4
Account Dept. 4 (with 1 HOD)
Voucher Entry:
1) Paid Salary Administration Staff 40000
Marketing Staff 32000
Counselors 9000
Clerks 12000
Account Dept 10000
Peon 8000
Technical staff 9000
Paid D.A. Administration Staff 16000
Display Statement of Accounts
Cost Centre 1) Cost Category 2) Cost Centre 3) Ledger
breakup 4) Group Breakup

DAY-3
INTEREST CALCULATION
F11: Accounting Features Activate interest calculation-----Yes
(Use advanced parameters) -----Yes To see interest Amount: --
Display—Statement of Accounts—Interest Calculations:
1) Interest receivable
2) Interest payable
3) Ledger
4) Group.
Transaction: 1 st April Sales to Rajesh Shukla worth Rs 1,
00,000 with the credit period of 15 days (10% interest p.a. will
charge for delay payment).
2 nd June Receive Bill amount from Rajesh Shukla.
2 nd June Receive Interest amount by cash.
01 st May Sales to Rohit & co. worth Rs 1, 20,000 with credit
period of 45 days (10% interest p.a. will charge for delay
payment: gracing 3 days apply).
1 st Aug Receive Rs 60000 from Rohit & co. by cash. 1 st Oct
Receive remaining amount from Rohit & co. without interest.
2 nd April Purchase goods worth Rs. 80000 from Shekhar Shah
with credit period of 30 days (12% will charge for delay of
payment.)
1 st June Paid bill amount to Shekhar Shah by cheque.
2 nd June Paid interest amount by cash to Shekhar Shah.
DEBIT NOTE & CREDIT NOTE
1) F11 Accounting /Inventory Features Use Debit Credit Notes :
Yes

Use Invoice Mode for Credit Notes: Yes

Use Invoice Mode for Debit Notes: Yes

2) G.O.T. Voucher Entry F8 for Credit Note –

F9 for Debit Note

Accounts Info Ledger Create:- Sales Return and Purchase


Party Name
FREE SCHEME
BATCH WISE DETAILS

F 11: Inventory Features—Storage & Classification


Maintain Batch Wise Details—Yes

Set Expiry Dates for Batches--Yes

Crate Following Master: Stock Group: Medicine

Unit of Measurement— Stp- Strips – 1 At Item Creation –

Maintain in Batches—Yes

Track Date of MFG—Yes

Set Expiry Date - ---Yes

Creat a Ledger of Discount :


DAY-4
GODOWN TRANSFER TRANSACTIONS >>

F11: Inventory Features: Maintain Multiple Godown ----------- Yes

Create Following Godown (Maninagar, Paldi, Vatva, Vadaj &


Odhav)
Inventory Info---Godown –Create--- F12 : Accts/Inventory info—
Use Addresses for Godowns--Yes
Create Following Items with given opening Stock:
Group: Shampoo Unit: No.- Numbers-0
Sales and Purchase Order
F11: Inventory Features:
1) Allow Invoicing --------------------------------------Yes
2) Allow Purchase Order Processing------------------Yes
3) Allow Sales Order Processing --------------------- Yes
4) Use Tracking Numbers ------------------------------Yes
5) Use Rejection Notes --------------------------------- Yes
F12: Invoice\Order Entry: 1) Accept Supplementary Details
-----------------------Yes
3) Use Common Ledger A/c for item Allocation -----Yes
MANUFACTURING
Create a voucher Type
Account Info\Inventory InfoVoucher Type
Create Name : Manufacturing Type of Voucher : Stock
Journal
Use as a manufacturing. Voucher : Yes Accept Inventory
Info:
Group: Raw Material Group: Finished Goods
Stock Item –Create
F 12: Allow component List Details (Bill of Material) --Yes Set
Components---No ---------------When Item of the Raw Material Set
Components---Yes---------------
When Main Item is created and Give standard allocation for
1 item Main Item Name :-
POS- POINT OF SALES
To create voucher type –
G.o.t-acc.info - voucher type- create Name - pos - point of
sales - Under - sales
Use for pos invoicing- yes.
Print msg 1 Print msg

2 Stock Item Creation : Group : Electronics Unit : Pcs


In item creation
(F12- allow standard rates -yes) Set std. rates? – Yes
(And set the standard selling price)

DAY-5

TDS- Tax Deduction at Source


1 July] Paid Rs.90000 to Sunil Shrama (Individual Resident)
for Audit Fees on Which TDS Applicable 2.
2 July] Paid Rs.80000 as Labour Charges to Asia & Co
Ltd(Company Resident) on Which TDS Applicable
2. 31 July] Paid Rs.85000 Insurance Commission to Relatives
Pvt Ltd(Partnership) Calculates the TDS 4.
3. Aug] Paid Rent of Building to Tina Mehta
Rs.250000(Company Resident) on which TDS application
4. 5. 2 Aug] Paid Dividend to Mahesh Prajapati
Rs.12000(Company resident) Calculates the TDS
5. 6. 1 Sep] Paid remaining Amount to different Parties.... 7.
6. 2 Sep] Paid total TDS to the Government by Cheque

GST ENTRIES
7. 123Ltd. Sales 3 same watch to Madan who live in Rajasthan
Dated 01/07/2017 through flipkart.com Rs. 1200 each
charge GST 28% and HSN code is- 91011100, Pass the
entry.

8. Q.2 On 02/07/2017 123Watch Pvt. Ltd. Sales 2 titan watches


to Rakesh who live in Delhi Rs. 2,500 each and charge
gst@28% through shopclus.com HSN code is same, pass
appropriate entry.

9. Q.3 0n 02/07/2017 one point watch ltd. Sales 10 fastrack


watch to 123Watch Pvt. Ltd. Of Rs. 500 each and charge
GST@28%, pass purchase entry in the books of 123 watch
Pvt. Ltd. And one point Watch ltd. Live in Delhi.

10. 123Watch Pvt. Ltd. Purchase 5 watches from New time


ltd. Rs. 600 each and pay GST@28 %, dated 01/07/2017
New time establish in Haryana, so pass the entry in
appropriate manners.
GSTIN-09DQTPK9758M1ZG Intra –State Sales
Q. 1 On 1st April 2018 New Tech Enterprises receive an order
(order no- 12345678) From Flipkart , 1 pcs mobile phone and
back cover of Rs.8999/pcs and Rs.120/ pcs and Shipping
charges Rs. 79 on this order. Charge GST on mobile phone
@12% (HSN code-8517) and GST on back cover @28% (HSN
code-4202). Customer Details Name :- Rahul Kumar Address :-
house no-40 , Gali no-2 , Kanpur, Uttar Pradesh
Inter-State Sales
Q. 2 On 1st April 2018 New Tech Enterprises receive an order
From Amazon (order no1234567) 1 pcs Wrist-Watches of
Rs.1449/- and Rs.79 Shipping charges on this order. Charge
GST on @18% (HSN code-9102).
-----------------------------------------------------------------------------------------------------------------
----------

You might also like