Wednesday, July 16, 2014

Tally Inventory Tutorial: Problem - 2 (Volume-I)


Transitions: (Dt: 01.04.2014)

  1. Mr. Rahul started business with cash Rs. 3,00,000
  2. Purchased 20 Cricket Bats @ 5,000 each for cash
  3. Purchased 20 cricket Bats @ 5,000 Each from David
  4. Sold 36 Bats @ 6000 each for cash +Excise duty 12.36% + VAT 5%
  5. Paid Salaried 1000 & Rent 1000
Step No:1
Creation of Company
From Gateway of Tally Press Alt+F1
From Company  Info Menu Select  Create  Company
Enter all the details of the Company
(Name, Address, Financial Year)
Read More: How to Create New Company in Tall

Step No: 2
Creation of Ledger Accounts
From-> Gateway of Tally -> Accounts Info -> Ledger-> Create

Account Name: Group
Rahul Capital: Capital Account
Purchase: Purchase Account
Sales: Sales Account
David: Sundry Creditors
Excise duty @ 12.36%: Duties & Taxes 
VAT @ 5%: Duties & Taxes     
Salaries: Indirect Expenses
Rent: Indirect Expenses
Read More: How to Create Ledger

Step No.3
Creation of productor  inventory
Gateway of tally -> Inventory Info -> Stock Group -> Create
Name: Traded Goods Or Finished goods
Under : Primary
Can quantities of items be added :Yes
Read More: How to Create Stock Groups in Tally


Press 4 Times ESC Key
Gateway  of Tally -> Inventory Info -> Units of Measure -> Create
Symbol:Nos
Formal Name: Numbers
Numbers of decimal places :0



Press  Esc 4 times
Gateway of tally -> Inventory Info -> Stock item -> Create

Name: Computer
Under: Select “Finished goods ” from the list
Units: Select “Nos” from the list.
Set Standard Rates: Yes
Set Standard Cost:10,000          
Standard selling price: 12,000
Read More: How to Create Stock Items in Tally


Step No. 4
Passing Transaction
Gateway of Tally -> Vouchers Entry


Date
Particulars
Debit
Credit
1st April 2014
(Press F6) Receipts
Cr. Rahul Capital A/c
Dr. Cash A/c


3,00,000

3,00,000
1st April 2014
(Press F9) Purchase
Dr.Purchase A/c
Cr. Cash A/c
Cr.David A/c

20,000


10,000
10,000

1st April 2014 
*(Press F8) Sales
Dr. Cash A/c
Cr. Sales  A/c
Cr. Excise Duty @12.36%
Cr. VAT @ 5%


2,54,832


2,16,000
26,698
12,135




1st April 2014
(Press F5) Payment
Dr.Salaries A/c
Dr.Rent A/c
Cr.Cash A/c

1000
1000



2000

*
Basic Value: Rs.216,000
Add: E.D-12.36%: Rs.26,698
Sub Total: Rs.242,698
Add: VAT-5%:  12,135
Total Value: Rs.2,54,832/- 

VIEW REPORTS

Profit & Loss
Gateway of Tally -> Profit & Loss (P)
Balance sheet
Gateway of Tally -> Balance sheet (B)



4 comments:

  1. The payment entry is wrongly shown here.
    It sud b:
    Salary A/c Dr. 1000
    Rent A/c Dr. 1000
    Cash A/c Cr. 2000

    ReplyDelete
    Replies
    1. Dear Mr/Ms.Sutrina,

      Thank u for ur comment.

      Sorry for inconvenience. We have corrected our mistake.

      Thanks & Regards
      G.S.VASU
      Admin
      www.accounts4tutorials.com

      Delete
  2. I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. novalnet addison

    ReplyDelete
  3. I am happy to find your distinguished way of writing the post. Now you make it easy for me to understand and implement the concept. Thank you for the post. test bank

    ReplyDelete

Copyright © 2015 accounting tally taxation tutorials All Right Reserved
Subscribe by Email Get Free Updates
Don't Forget To Join US Our Community
×
blogger