Tally: Question to practice

Company Name               :               MAGNET COMPANY
Address:                              :               No. 31, S.S.K. Chawl, Dharavi Cross Road, Dharavi, Mumbai – 17.
LEDGER NAME
UNDER GROUP
OPENING BALANCE
SHARE CAPITAL
CAPITAL ACCOUNT
10,00,000
LOAN FROM SBI BANK
SECURED LOAN
4,00,000
PROVISION FOR DEPRECIATION
PROVISION
32,500
O/S RENT
CURRENT LIABILITY
3,600
O/S SALARIES
CURRENT LIABILITY
19,000
DEPOSIT FOR PREMISES
DEPOSITS (ASSETS)
1,55,000
INVESTMENT IN SHARES
INVESTMENT
18,550
FURNITURE
FIXED ASSETS
15,000
COMPUTERS
FIXED ASSETS
80,000
CASH IN BANK
BANK ACCOUNT
1,93,000
CASH IN HAND
CASH IN HAND
25,000
CLOSING STOCK
STOCK IN HAND
67,000

To maintain Stock Statement
Group
Categories
Stock item
Purchase price
Quantity
Godown
ECONOMICS
MARSHAL
V.1
300
60
DHARAVI
V.2
325
80
GLOBAL
C.1
450
120
C.2
500
160
MANAGEMENT
HENRY
BASIC
125
300
SION
INTERMEDIATE
225
325
FINAL
600
350
INDIAN
SIMPLE
75
400
ADVANCE
325
600
Goods are purchased from these parties. (VAT @12.5%)
Date
Bill no.
Party name
Stock item
Godown
Qty
1ST MAY
OM 001
BABAJI STORE
V.2
DHARAVI
45
5TH  MAY
OM 002
AMUL STORE
C.1
SION
50
6TH  MAY
OM 003
ANAND STORE
V.2
SION
60
8TH  MAY
OM 004
ABINAYA STORE
BASIC
DHARAVI
31
10TH  MAY
OM 005
AZIM’S STORE
FINAL
DHARAVI
90
17TH JUNE
OM 006
SARASWATI STORE
INTERMEDIATE
SION
15
19TH JULY
OM 006
ANAND STORE
ADVANCE
SION
45
23RD JULY
OM 007
ABINAYA STORE
SIMPLE
DHARAVI
75
29TH AUGUST
OM 008
BABAJI STORE
C.2
SION
52



Goods are sold to these parties. (VAT @12.5%)
Date
Bill no.
Party name
Stock item
Godown
Qty
Selling price
1ST MAY
OM P001
Reliance store
V.2
DHARAVI
15
650
5TH  MAY
OM P002
TATA store
C.1
SION
40
675
6TH  MAY
OM P003
Omtex store
V.2
SION
53
685
8TH  MAY
OM P004
Vishwas store
BASIC
DHARAVI
31
695
10TH  MAY
OM P005
Philips store
FINAL
DHARAVI
100
902
17TH JUNE
OM P006
Omtex store
INTERMEDIATE
SION
20
625
19TH JULY
OM P006
IPL store
ADVANCE
SION
36
635
23RD JULY
OM P007
Reliance
SIMPLE
DHARAVI
90
644
29TH AUGUST
OM P008
Philips store
C.2
SION
42
702

When amount received from parties use Receipt voucher (F6)
Date
Party name
MODE OF PAYMENT
CHEQUE NUMBER
AMOUNT
2nd  MAY
Reliance store
CASH
---------------------
70000
2nd  MAY
TATA store
CASH
---------------------
25000
2nd  MAY
Omtex store
CHEQUE
0229892
42000
2nd  MAY
Vishwas store
CHEQUE
C/B 654258
18000
2nd  MAY
Philips store
CHEQUE
S/B 7139852
120000
2nd  MAY
IPL store
CASH
---------------------
15500

When amount paid to parties use payment voucher (F6)
Date
Party name
MODE OF PAYMENT
CHEQUE NUMBER
AMOUNT
2nd  MAY
BABAJI STORE
CASH
---------------------
30000
2nd  MAY
AMUL STORE
CASH
---------------------
20000
2nd  MAY
ANAND STORE
CHEQUE
8459625
18000
2nd  MAY
ABINAYA STORE
CHEQUE
6548721
6000
2nd  MAY
AZIM’S STORE
CHEQUE
9685721
22000
2nd  MAY
SARASWATI STORE
CASH
---------------------
3000



Purchase and Sales Return
On 1st June, goods purchased from Babaji store has been returned. Details are
Stock item
Godown
Quantity
Bill no.
V.2
Dharavi
2
OM 001
On 1st August, goods purchased from Saraswati store has been returned. Details are
Bill no.
Godown
Quantity
Stock item
Om 006
Sion
1
Intermediate
On 1st October, goods purchased from Anand store has been returned. Details are
Bill no.
Godown
Quantity
Stock item
Om 003
Sion
5
V.2

On 1st July, goods sold to Philips Store were returned. Details are
Bill no.
Godown
Quantity
Stock item
Om p005
Dharavi
5
Final
On 31st December, goods sold to Reliance company were returned. Details are
Bill no.
Godown
Quantity
Stock item
Om p007
Sion
2
Simple
On 31st January, 2011 goods sold to IPL store were returned. Details are
Bill no.
Godown
Quantity
Stock item
Om p006
Dharavi
2
Advance

Contra Entries
1.       On 1st September, Withdraw Rs. 50000 from Abhyudaya bank for business purpose.
2.       On 30th November, With drawn Rs. 25000 from Cash in bank for business purpose.
3.       On 28th February, Deposit Rs. 25000 in Abhyudaya bank.

Charging Depreciation
On 31 – 3 – 2011 Charge depreciation @ 10% on furniture, 20% on computer, 12.5% on Machinery, 7.5% on Building. 


Particulars
Under category
Amount
(Rs.)
Mode of payment
Discount Allowed A/c
Commission Allowed A/c
Indirect expenses
Indirect expenses
1800
300
Cash
cash
Salary A/c
Indirect expenses
500
Cheque
Travelling Expenses
Indirect expenses
900
Cheque
Rent A/c
Indirect expenses
450
Cash
Brokerage Account
Indirect expenses
1250
Cash
Printing & Stationery
Electricity charges
Miscellaneous expenses
Advertisement
Office expenses
Interest
Delivery van expenses
Conveyance Expenses
Refreshment Expenses
Administrative expenses
Discount received A/c
Commission received A/c
Indirect expenses
Indirect expenses
Indirect expenses
Indirect expenses
Indirect expenses
Indirect expenses
Indirect expenses
Indirect expenses
Indirect expenses
Indirect expenses
Indirect income
Indirect income
600
1200
820
960
1020
350
125
650
250
450
900
4500
Cheque
Cash
cash
Cheque
Cheque
Cheque
Cheque
Cheque
Cheque
Cheque
Cheque
Cheque