Showing posts with label MMM. Show all posts
Showing posts with label MMM. Show all posts

Thursday, August 31, 2023

/Tally9/Tally9,exe’ NOTES ( tally notes) PART 1



 TALLY Notes 
Introduction of tally 

= Tally is an Accounting software in which we can record all the

business transactions through ledger and different types

of ledger vouchers. It maintain reports such as Balance sheet,

profit and loss alc Ratio analysis, cash flow statement ,

Funds flow statement ,Trial balance and many more with

the latest version of this software TALLY 9 ,you can do

different types of works such as:-

  1. Do all the basic accounting function 

  2. Manage your store and items 

  3. Maintain budget 

  4. Calculate interest on pending amount 

  5. Manage payroll

  6. Manage stocks on Godown and many more others features 


In fact ,intoday’s environment you just need a computer and Tally to manage your business and you to Run it , It was developed in India.


Accounting 

Manual Accounting and TAlly Accounting 

 

Manual Accounting 

TAlly Accounting

  • Voucher Entry 

  • Company creation 

  •   Posting and general Ledger

  • Group creation

  • Trail Balance

  • Ledger creation 

  •   Final Account

  • Voucher Entry 

  • Profit and loss Account / Balance sheet

  • Report 



 


Procedure to open tally


  • Click on tally icon of Destop and press enter 

Another method

  • Click on start button of status bar 

  • Clock on program 

  • Click on run (Run Dialogue box will appear)

  • Type ‘ c:/Tally9/Tally9 ,exe’ and press enter


How to create Company 

Steps:

  • Go to the Company Info (Alt + F3)

  • Click on create a company then a company creation form will appear

In a form 

  1. Type the Company in the name option 

  2. Type the another option as required 

  3. Press the enter or “ Ctrl +A “ to save or create the company. 


To Modify and Delete Company  

It is used to modify ( Alter ) and Delete the Company you have already created .

Steps:

  • Go to the Company Info ( Alt +F3 )

  • Click on Alter if you want to modify or change

  • Select the Company which Company you would like to Modify ( Alter ) and press Enter.

( Then a Company creation Form with appear. )

  • You can Modify( Alter ) which you want to modify on your created Company and press the Enter as required or Ctrl +A to save the company.

  • Click on Alter if you want to Delete the Company .

  • Select the  Company and press Enter  Company creation Form will appear 

  • Press Alt +D and Press Enter as required to delete the  Company. 





Ledger

= A Ledger is the actual account head to which you

identify  a transaction . In Tally you pass all the

accounting vouchers using Ledgers . However, all

ledgers have to be classified into groups. It means

that the Group is a collection of ledgers which

have the same natures. 

Steps 👍

  • Go to the Gateway of tally 

  • Click on Account info 

  • Click on Ledger 

  • Click on create Single/ Multiple Ledger 

  • Type the name of the ledger, select the Group where it lies.

  • Finally , press Enter as required or “Ctrl+A” to save the ledgers.


Point to Remember 

         Ledger Name 

     Under

Any Capital Alc 

Capital Alc

Drawing Alc

Capital Alc

Cash Alc

Cash Alc

Any Bank Alc

Bank Alc

Advertising Exp Alc

Indirect Exp Alc

Telephone Bill Alc

Water bill Alc

Salary Alc

Insurance premium Alc

Loss by theft Alc

Loss by Fire Alc

Any Suppliers Alc

Sundry creditors Alc 

Any customers Alc 

Sundry Debtors Alc 

Wages Alc 

Direct Exp

Freight Alc 

Coolie Alc 

Purchase return Alc 

Purchase Alc 

Purchase Alc 

Purchase Alc

Sales Alc

Sales Alc 

Sales return Alc 

Sales Alc 

Plant and Machinery Alc

Fixed Assets

Computer Alc

Land and Building Alc

Furniture Alc

Mobile Set Alc

Telephone Set Alc





Vouchers and Types of Vouchers


A vouchers is a document containing the details of transaction for every transactions you make a vouchers in tally.


It allows creating different types of Vouchers ( Voucher types ) which helps you to create Voucher.


Vouchers type 🙂 

Tally program provides 20 Vouchers types .

There are two kinds of Voucher type i.e 

Accounting Vouchers and Inventory Vouchers.


Accounting Vouchers And Inventory Vouchers 


Accounting Vouchers

Inventory Vouchers 

Contra Voucher 

Physical Stock 

Payment  “

Stock Journal 

Receipt     “

Manufacturing Journal 

Journal     “

Purchase Order 

Sales        “ 

Sales order 

Purchase    “

Delivery Note 

Memo     “

Receipt Note 

Index        “

Rejection in 

Debit Note   “

MFG Plan 

Credit Note    “

Purchase Quotation


 

How to create Voucher type 👏

  • Select “Accounting Info” or “Inventory Info”

from Gateway of tally .
  • Select Vouchers types 

  • Select create 

( Dialog will appear ) 


  • Vouchers 

    1. Contra Vouchers ( F4 ) 👍


  • = According to the Accounting rules , 

    when the current Assets ( Cash and Bank )

     are affected in the side of Debit or

     Credit while making the journal , 

    The transaction should be in Contra Voucher.


The following points helps us to know about 

its ( contra voucher ) Nature .


Cash account to Bank account 

Bank account to Cash account 

Bank account to Bank account 


For e.g. 


Cash Deposit into Nepal Rastra Bank Rs 5000.


Nepal Rastra Bank Alc …………Dr 5000

To Cash Alc…………………….5000

(Being cash deposit into NRB  .)



Cash withdrawal from Nepal Rastra Bank Rs 8000.


Cash Alc …………………………..…..Dr. 8000

To Nepal Rastra Bank Alc………..8000

(Being cash withdrew from NRB  .)


Cash Transferred from Nepal Rastra

 Bank to Laxmi Bank Alc Rs 15000


Laxmi bank Alc ………………………….Dr. 15000

To Nepal Rastra Bank Alc…………15000

(Being cash transferred from NRB to 

Laxmi bank .)


2.Payment Voucher ( F5 ) 👍


= When we pay the amount by cash or cheque to another

account and it is affected on the

side of Credit then we should do the entry in the

payment voucher.


For example 


Cash paid Rs 150000 to Maruti suppliers .


Maruti Suppliers Alc ……..Dr. 150000

To cash Alc…………………150000

(Being cash paid to maruti suppliers .)




Salary paid Rs 10000 to staff by

 Nepal Bank.


Salary Alc ………………..Dr. 10000

To Nepal Bank Alc…….10000


(Being salary paid to staff by nEPAL bANK .)



Computer purchase of Rs. 30000 in cash

 from Sherestra.


Computer Alc ………….…Dr. 30000

To cash Alc………………30000

(Being computer purchase from 

Mr.sheresta on cash .)


3.Receipt Voucher ( F6 ) 👍


= When we receive the amount by cash 

or cheque from another account and it’s 

effected in the side of Debit then we should

 do the entry in Receipt Voucher.


For examples:


Computer sold for Rs 30000 in cash to Shrestha.


Cash Alc ……………………….30000

To Computer Alc………..30000

(Being computer sold on cash to Mr.sheresta  .)


Cash received Rs.10000 from Maruti customers.


Cash Alc………………………….Dr. 10000

To Maruti Customers Alc……..10000

(Being cash received from Maruti customers .)


Interest received Rs 50000 From Maya.


Cash Alc …………….…..Dr. 50000

To Interest Alc ……….50000 

(Being interest received from Maya.)


Ram started Business with cash Rs 200000


Cash Alc ……………Dr. 200000

To Ram Alc……..200000

(Being Ram started business with cash.)


4. Journal Voucher ( F7 ) 👍

= This voucher is used to record the non-cash 

( cash, Bank ) and an adjustment transaction

which can’t affect the side of Debit and Credit.


For example:


Computer Purchase of Rs 30000 from Rakhi.


Computer Alc …………….Dr. 30000

To Rakhi Alc………..30000 

(Being computer purchase from RAkhi.)


Furniture sold for Rs 12000 to Deepali.


Deepali Alc ………..………Dr. 12000

To Furniture Alc………….12000

(Being furniture sold to Deepali.)


Depreciation charged on land and Building Rs 5000


Depreciation Alc …………………….Dr. 5000

To Land and building Alc……..5000

(Being Depreciation charged on land

 and building .)



5. Sales Voucher ( F8 ) 👍


= When the Goods/Inventories ( which are sold for

Business purpose ) sold on cash or non credit 

then we have to Enter it in sales Voucher.


For example:


Goods sold of Rs 5000 to prakesh.


Prakesh Alc ………….Dr. 5000

To sales Alc……..5000

(Being Good sold to prakesh .)


Good sold of Rs 12000 on cash.


Cash Alc ……………….Dr 12000

To sales Alc…………12000

(Being Good sold on cash .)


Computers parts sold on Cash (Bill no 450)

to sherestha are as:


Name of Goods 

Categories 

Quantity

Rate

Godown


Mouse 

L.G

20

120

KTM 

keyboard

C.G

15

450

KTM

 



6. Purchase Voucher ( F9 ) 👍


= When the Goods/Inventories ( which are purchase for

Business purpose ) purchased

 on cash or non credit  then we have to 

Enter it in purchase Voucher.


For example:


Goods purchase of Rs 5000 From RAkesh.


Purchase Alc ……………….Dr. 5000

To Rakesh Alc……………5000

(Being Good purchase from Rakesh.)


Goods purchase of Rs 45000 on cash.


Purchase Alc ………..Dr. 45000

To cash Alc……….45000

(Being Good purchase on cash .)


 (Note: Dr. वा Cr न आएमा press Ctrl + V )


7. Credit Note (Ctrl +F8 ) 👍


=Through this menu, The company keeps

the transaction of return goods which have

already been sold. It means, it helps us to keep the

transaction of sales return.


8. Debit Note ( Ctrl + F9 ) 👍


=Through this menu, The company keeps the transaction

of return goods which have already been Purchased.

It means, it helps us to keep the transaction of Purchase return.


Series of Action to active 

Debit and Credit Note 🎉


Press F11 ( Features ) from anywhere and then set “Yes”  

Debit Note / Credit Note and save it by pressing “Ctrl +A” 


9. Memo ( ) 👍


10. Index (  ) 👍


Voucher Entry






Do the following example





Currency 


The Currency is used to convert the rate of

exchange of foreign Currency into company

currency or Home Currency . It we want to use

Currency in our company then we have to follow the

following steps 😀

Steps 👍


  • Press F11 : Feature Button

  • Set “yes” in the “Allow -currency” option

on the accounting features window.

  • Then press “ Ctrl +A  to save it .

[ Alter this setting we can see the “Currencies” option

in the Account into Menu ]


🎉 Use Currency Menu to create Currency Symbol ,

Modify or Delete Currency Symbol , Create Rate of Exchange . 


Some task to create the Currency Symbol 

  • Gateway of tally 

  • Account Info 

  • Currency 

  • Create the following Symbol 




Currency Symbol 

Formal Name 

irs

Indian Currency 

$ ( shift + 4)

American Dollar 

€ ( Alt + 0128)

Euro Dollar 

£ ( Alt + 0163)

Pound Sterling 

¥ ( Alt + 0165 )


Japanese yen 


🎉 After creation , Try to Modify , Display and Delete the

symbol of Currencies.


Some Task to create RAte of Exchange 

Steps 👍

  • Gateway of tally 

  • Accounts Info 

  • Currency 

  • Rate of Exchange 




The Rate of Exchange are as follow:


Currency Name 

Units 

Std Rate 

Buying 

Rate 

Selling Rate

Indian currency 

100

160

160

160.15

American Dollar

 

131.94

131.94

132.54

Euro Dollar 


142.38

142.38

143.02

Pound Sterling 



166.06

166.06

166.81

Japanese Yen


10 

9.03

9.03

9.07

Chinese yuan 


1

18.10

18.10

18.18



Std RAte भनेको purchase Rate र Selling Rate को

Minimum RAte हो।  










Do the following Transactions






Bills Receivable and Payable 


 In modern Business, It is very important to keep the

record of the Bills. Tally is a very easy programme

which helps us to keep the Receivable Bills and Payable

Bills of Credit days. If the Payable bills are not done

at a time, you can keep it one by one too.It means goods

which are sold or purchase on credit and when its

Credit date will be expired, then tally helps us to create

the report of “Payable Bills” and “Receivable Bills”

And of course, the type of report facilities will be very

important for the Businessman, Those who operate

their business on Credit also.


Setting for the Bills Receivable and Bills Payable   

  

  • Gateway of Tally

  • Then press F11 : Features and then set “Yes” at

“Maintain Bill wise Details”


But don't make “yes” get ( for  Non Trading Alc )also

Because Maintain Bill wise Details” means only use bills in

Sundry

Debtors and Sundry Creditors.


Types of Reference Method


In tally there are 4 types of Reference Method

about the Bill Form there, we can select any. But each

Method has its own meaning and use.


  1. New Ref 🎉

= It is used in the condition of “Purchase Goods

and Sales Goods” on Credit .


For example : 


(A.) Purchase goods from Shrestha Rs 150000.( Bill No. Pb001)

(B.) Sold Goods to Raju and Preity Traders Rs 120000

( Bill No Sd001 )

 

    1.  Agst ( Against ) Ref 🎉


    = It is used in Against of Payment and Receipt Voucher,

    and the transactions which we Purchase and

    Sale on Credit and which use have selected in “New Ref”


    For Example : 


    (A.) Cash paid of Rs 150000 to shrestha.( Bill No Pb001 ) 

    ( B.)  Cash Received from Raju and preity traders

    Rs 120000( Bill No Sd001 )

      

    1.  Advance 🎉


    It is used for Payment and Received but more than

    responsible for payment received. Means

    “Advance Received and Payment”.


    For Example 😭


    (A.) Cash paid for shrestha Rs 180000. ( Bill No. Pb001)

    [ It will be advance, Because we had purchase goods on

    Rs 150000 only but now were going to paid Rs 30000 in Advance. ]

    (B.) Cash received  from Raju and preity traders Rs 150000.

    (bill No Sd001)

    [ It will also be the same.Because of the same reason.

    Rs 120000 and Rs 30000]   

     

    1.  On Account 🎉


    = It is used in case of Non-Billing Transaction.


    For Example : 


    (A.)  Computer Purchase from shrestha Rs 75000.

    (B.)Land and Building sold Rs 135000. 


    Note:- If you have choose the on account in the

    journal voucher then in Payment and Received voucher

    also we should choose “On Account” in the customer and

    supplier (Payment and Received voucher ).


    To Display Report of Bills Receivable


    Steps 👍

    • Gateway of Tally 

    • Display 

    • Statement of Account 

    • Then Receivable 


    To Display Report of Bills Payable 


    Steps 👍

    • Follow the above rule up to No.3

    • Then Payable 

     Note:- To Display in Details, Press Alt+ F1


    In this Menu we can see many more Details except

    Receicable and Payable .Except this, we can

    following Menu:


    1. Ledger :- This menu helps us to Display the

    current Due amount of the Bills.


    1. Group:- It is used to Display the Reports

    of Sundry Debtors and Sundry Creditors separately.


    1. Receivable :- It means, it Displays the report of

    total Receivable Bills which are sold on Credit .


    1. Payable :- It displays the Report of Total Payable

    due bills.


    Do the following Exercise .






    Interest Calculation


    When we give loan or Received loan then we have

    to pay or Receive Interest. TAlly provides the interest

    function to calculate the Interest for the specific Date .


    How to enable Interest Calculation 

    Steps 👍

    • unchecked

       Press F1 

    • unchecked

       Set “yes” at Interest calculation 

    • unchecked

       Save it


    ( Sense : Interest Payable ) 


    Example:-

    Loan Paid to Dinesh Rs 50000


    Dinesh Alc ………Dr. 50000

             To cash Alc……..50000


    Creating the Ledger of Dinesh

    • Name:- Dinesh 

    • Under:- loan and Advance ( Assets ) 

    • Achieve:- Interest Calculation “Yes”

    • Rate:-  3%

    • Calendar Month 

    • Save it 

      

    Interest Payable 

    This is Interest Payable which we have to pay 


    Steps 👍


    • Gateway of Tally

    • Display 

    • Statement of Account

    • Interest Calculation

    • Interest Payment    


    ( Sense : Interest Receivable ) 


    Example:-

    Loan Receive from Rohan Rs 100000


    Cash Alc ………Dr. 100000

             To Rohan Alc……..100000


    Creating the Ledger of Rohan 

    • Name:- Rohan 

    • Under:-  loan and liabilities  

    • Achieve:- Interest Calculation “Yes”

    • Rate:-  36%

    • Calendar Month 

    • Save it 

      

    Interest Receivable -

    This is Interest Payable which we have to Receive  


    Steps 👍


    • Gateway of Tally

    • Display 

    • Statement of Account

    • Interest Calculation

    • Interest Receivable   


    Stock



    Creating Group 🎉 

    = It provides information to classified or identify the

    ledger account according to their nature.


    • Select “Account Info” from Gateway of Tally 

    • Select Group

    • Select Create 

    ( Group Dialogue box will appear here)

    • After that change you required 

    • Press Ctrl +A then enter key 


    To Delete the existing Stock Group


    • Select Inventory Info from Gateway of Tally 

    Select stock Group

    • Select Alter 

    • Select Group NAme which you want to Delete 

    • Press Alt +D and Enter


    Unit of Measure 


    It is used to Create Unit for the measurement of any

    Production or Item.


    • Select “Inventory Info” From Gateway of Tally.

    • Select “Unit of Measure”

    • Select Create 

    ( Unit of Measure creation dialog box appear)

    • Type simple / command 

    • Symbol : Psc

    • Formal Name : Pieces 

    • Numerical of Decimal Places = 0

    • Press Ctrl + A to Save 


    Lab Work 

    Symbol 

    Formal Name 

    KG 

    Kilogram 

    Pcs 

    Pieces 

    Ltr

    Litres 

    Bx

    Box

    Pack 

    Package 

    Qnt 

    Quintale 

    Doz 

    Dozen 

    Br 

    Bora


    To Display the create Unit


    • Select “Inventory Info” Gateway of Tally

    • Select Unit of Measure 

    • Select Display 

    • Select Unit name which you want to display . 


    To Modify the create Unit


    • Select “Inventory Info” Gateway of Tally

    • Select Unit of Measure

    • Select Alter 

    • Select the Unit name which you want to Modify

    • Alter that changes as you required .

    • Select Ctrl+A then Enter to save 


    To Delete the existing Unit


    • Select “Inventory Info” Gateway of Tally

    • Select Unit of Measure that you want to Delete 

    • Press Alt +D To Delete the unit 


    To Copy Stock Item From one Company

    to another company


    • Open two Company ( Old and New)

    • Go to old Company by press F3

    • Select: “Inventory Info” from Gateway of Tally .

    • Select : “Stock Item”

    • Select: Alter from Multiple Side .

    • Select: All Items  

    •  Press F3 

    • Select: New Company 

    • Press Ctrl+A


    To Copy Ledger From one Company

    to another company 


    • Open two Company ( Old and New)

    • Go to old Company by press F3

    • Select “Account Info” from Gateway of Tally .

    • Select Ledger

    • Select Alter from Multiple Sides .

    • Select All Items  

    •  Press F3 

    • Select New Company 

    • Press Ctrl+A







COMPUTER OPERATOR HELPFUL NOTES HTML NOTES

  HTML   HTML stand for Hyper Text Mark up Language. It is the language used for creating webpage. To write   the HTML codes we can use ...