Tally
Tally is fully computerized financial business accounting software. It is develop by Tally solutions private limited India in 1988. In this software we will learn to create, modify and delete of company. We will also learn to create ledger and voucher entry of the transactions. When we entry the voucher, the software will automatically display the final reports, cash flow e.t.c. In the market, we can get two types of Tally software. First one is Tally authorized versions or full versions and Tally educational version. Authorized versions are used by company or organization but evaluation versions are used to learn about data entry. Tally 5.4, Tally 6.3, Tally 7.2, tally 8.1 and tally 9.0 are versions of tally
Tally is fully computerized financial business accounting software. It is develop by Tally solutions private limited India in 1988. In this software we will learn to create, modify and delete of company. We will also learn to create ledger and voucher entry of the transactions. When we entry the voucher, the software will automatically display the final reports, cash flow e.t.c. In the market, we can get two types of Tally software. First one is Tally authorized versions or full versions and Tally educational version. Authorized versions are used by company or organization but evaluation versions are used to learn about data entry. Tally 5.4, Tally 6.3, Tally 7.2, tally 8.1 and tally 9.0 are versions of tally
Cycle of Accounting
Ledger
Final accounts
Profit and loss,
Balance sheet
Journal voucher
Tail Balance
Creating New Company in tally
1 Open tally
2 Press esc if there ask serial no.
3 Click on company information or
4 Press alt+f3
5 Select create company option press enter
6 Type the company name and other details e.g. mailing address, select stator, contact no. currency symbol, financial year of the company, maintain of company e.g. accounts only or accounts with inventory, tally vault password, security control( users and password)
7 Define the currency information
8 At finally save it (ctrl+A) or
9 Accept it
Modify of Company in tally
9 Open tally
10 Press esc if there ask serial no.
11 Click on company information or
12 Press alt+f3
13 Select alter press enter
14 Select required company press enter
15 Modify the company as your requirements
16 At finally press ctrl+a
Ledger
Final accounts
Profit and loss,
Balance sheet
Journal voucher
Tail Balance
Creating New Company in tally
1 Open tally
2 Press esc if there ask serial no.
3 Click on company information or
4 Press alt+f3
5 Select create company option press enter
6 Type the company name and other details e.g. mailing address, select stator, contact no. currency symbol, financial year of the company, maintain of company e.g. accounts only or accounts with inventory, tally vault password, security control( users and password)
7 Define the currency information
8 At finally save it (ctrl+A) or
9 Accept it
Modify of Company in tally
9 Open tally
10 Press esc if there ask serial no.
11 Click on company information or
12 Press alt+f3
13 Select alter press enter
14 Select required company press enter
15 Modify the company as your requirements
16 At finally press ctrl+a
Delete of Company in tally
17 Open tally
18 Press esc if there ask serial no.
19 Click on company information or
20 Press alt+f3
21 Select alter press enter
22 Select required company press enter
23 Press alt+d(now there shows a message)
24 Press y, or press enter
25 Again press enter
17 Open tally
18 Press esc if there ask serial no.
19 Click on company information or
20 Press alt+f3
21 Select alter press enter
22 Select required company press enter
23 Press alt+d(now there shows a message)
24 Press y, or press enter
25 Again press enter
Voucher:
The change of transaction into dr/cr form according to the rules of accounting is called voucher. Vouchers are classified in two categories. First one is accounting voucher, which is used to entry the transactions of income and expenditure. Second one is inventory voucher which is used to entry the transactions of goods which are purchase trading point of view. In other words inventory describe about purchase and sales. Accounting vouchers are classified in four categories.
They are.
1. receipt voucher(f6)
2. payment voucher(f5)
3. contra voucher(f4)
4. journal voucher(f7)
The change of transaction into dr/cr form according to the rules of accounting is called voucher. Vouchers are classified in two categories. First one is accounting voucher, which is used to entry the transactions of income and expenditure. Second one is inventory voucher which is used to entry the transactions of goods which are purchase trading point of view. In other words inventory describe about purchase and sales. Accounting vouchers are classified in four categories.
They are.
1. receipt voucher(f6)
2. payment voucher(f5)
3. contra voucher(f4)
4. journal voucher(f7)
1. Receipt voucher:
The voucher having cash a/c
or bank a/c debit and another account (apart from cash and bank) credit is
called receipt voucher.e.g.
Business started with cash Rs.100000
Cash a/c dr 100000
To capital a/c 100000
(Being business started with cash)
Business started with cash Rs.100000
Cash a/c dr 100000
To capital a/c 100000
(Being business started with cash)
Commission received from
Shankar Rs. 20000
Cash a/c dr 20000
To commission income a/c 20000
(Being commission received from Shankar)
Cash a/c dr 20000
To commission income a/c 20000
(Being commission received from Shankar)
2. Payment voucher:
The voucher having cash a/c
or bank a/c credit and another account debit is called payment voucher. E.g.
Furniture purchased in cash Rs 20000
Furniture a/c dr 20000
To cash a/c 20000
(Being purchase of furniture in cash)
House rent paid through Himalayan bank 30000
House rent a/c dr 30000
To Himalayan bank a/c 30000
(Being house rent paid through Himalayan bank)
3. Journal voucher:
Furniture purchased in cash Rs 20000
Furniture a/c dr 20000
To cash a/c 20000
(Being purchase of furniture in cash)
House rent paid through Himalayan bank 30000
House rent a/c dr 30000
To Himalayan bank a/c 30000
(Being house rent paid through Himalayan bank)
3. Journal voucher:
The voucher having no cash a/c
and no bank account at both sides( debit and credit side) is called journal
voucher
E.g. stationery purchased from top traders on credit rs 5000
Stationery a/c dr 5000
To top traders a/c 5000
E.g. stationery purchased from top traders on credit rs 5000
Stationery a/c dr 5000
To top traders a/c 5000
4. Contra voucher:
The voucher having
Cash a/c dr
To bank a/c
Or bank a/c dr
To cash a/c
Or one bank a/c dr
To another bank a/c
Is called contra voucher
E.g. cash deposited at Himalayan bank rs 100000
Cash withdraw from Himalayan bank rs 50000
Cash transferred from Himalayan bank to kumari bank rs 10000
Note: Final accounts means
Profit and loss a/c and Balance sheet
Rules of Debit and credit:
1. Personal account:
This account is involve with person or organization, IN this account receiver is debited givers is credited.
Receiver DR.
Giver Cr.
2. Real account:
This account is related with assets and liabilities in this account what comes in debit, what goes out is credit.
What comes in Dr?
What goes out Cr.?
3. Nominal account:
This account is related with income and expenditures or profit and loss, in this account expenditure and loss are debited, income and profit are credited.
Expenditure/ loss Dr.
Income/profit CR.
Examples:
1. House rent paid in cash Rs 10000
House rent a/c dr ...........10000
To cash a/c ..........................10000
(Being house rent paid)
2. Furniture purchase paid in cash Rs 30000
Furniture a/c ..........dr 30000
To cash a/c ................30000
(Being furniture purchased)
3. Sales received in cash Rs 10000
Cash a/c Dr ..................10000
To sales a/c ............10000
(Being sales in cash)
4. Sales to hari on credit Rs 30000
Hari a/c Dr ................30000
to sales a/c ................30000
( being sales on credit. )
5. Salary payable to Ram Rs 50000
salary a/c Dr .............50000
to Ram a/c ............50000
(being salary payable)
6. Commission receivable from Janak - Rs 30000
Janak a/c Dr ...........30000
To commission a/c .............30000
(Being commission receivable)
Creating Ledger:
Gateway of Tally
1. Select account info press enter.
2. select ledger
3. select create.
Ledger creation.
Name : House rent a/c /furniture a/c / capital a/c
Under: Indirect expenses/ fixed assests / capital a/c
Inventory value are effected : No opening balance .
4. Press CTRL + A
Display of Ledger:
Gateway of Tally ( Heading )
1. select account info Press enter.
2. select ledger.
3. select display.
Modify of Ledger:
1. Select account info Press enter.
2. Select ledger.
3. Select alter.
4. Select required ledger.
5. Modify the ledger.
6. Press CTRL + A to save.
Delete a ledger:
1. Select account info Press Enter.
2. Select Ledger.
3. Select alter.
4. Select required ledger.
5. Press CTRL + D
Transfer of ledger from one company to another company
1. Create a new company
2. Open a ledger having ledger
3. Select account info press enter
4. Select ledger press enter
5. Select alter of multiple ledger press enter
6. Select all items press enter
7. Press f3
8. select required company press enter
9. Press ctrl+a
(note: for ledger transfer currency of both company should be same)
Report Display:
Display of Daybook:
1. Select display of reports menu Press enter.
2. Select day book.
3. Press ALT + F1 for details.
Display of total number of vouchers:
1. select display Press enter.
2. Select statement of account.
3. Select statistics.
Display of Ledger reports.
1. select display Press enter.
2. Select account book.
3. Select ledger.
4. Select required ledger.
Display of cash book and bank book:
1. Select display Press enter.
2. select account book.
3. select cash / Bank book.
select bank account for bank book.
Display of Trail balance:
1. Select Display . Press Enter.
2. select Trail Balance.
3. Press ALT + F1 for details.
Display of Profit and Loss Accounts:
1. Select profit and loss a/c of report menu Press Enter.
2. Press ALT + F1 for Details.
Display of Balance sheet:
1. Select balance sheet of reports menu. Press Enter.
2. Press ALT + F1 for details.
Modify for wrong voucher entry:
1. Select display . Press Enter.
2. Select day book.
3. select required voucher entry .
4. Modify the voucher with date, voucher type , ledger and amounts.
5. Press CTRL + A
Delete of Unnecessary voucher:
1. Select display of report menu.
2. Select Day book.
3. Select required voucher.
4. Press ALT + D.
INVENTORY VOUCHER:
The voucher related to stock is called inventory voucher.
It is involved with product or stock item; there are four types of inventory voucher.
1. Purchase voucher.
2. Debit note on purchase return.
3. Sales voucher.
4. Sales returned on credit note.
1. Purchase voucher:
If we purchase good for resale (trading point of view) that voucher is called purchase voucher.
Example:
1. Purchase of following items on credit from xyz supplier for resale
Sony color TV 10 sets @ 20000
L.G color TV 20 sets @ 50000
Samsung color TV 20 sets @ 10000
Purchase a/c Dr
Sony COLOUR TV 10@20000=
LG COLOUR TV 10@50000 =
SAMSUNG COLOUR TV 20@10000=
TO xyz supplier a/c
(BEING PURCHASE OF VARIOUS ITEMS IN CASH)
2. Debit Note on purchase return :
This voucher is use the time of purchase returned to the supplier whose entry is opposite of purchase voucher .
Example:
Purchase returned to the XYZ supplier of following items.
Sony color TV 2 sets @ 20000
LG color TV 2 sets@ 50000
Samsung color TV 2 sets @ 10000
xyz supplier a/c Dr.
To purchase returned a/c
Sony color TV 2 sets @ 20000
L.G color TV 2sets @ 50000
Samsung color tv 2 sets @ 40000
(BEING PURCHASE RETURNED )
Cash a/c dr
To bank a/c
Or bank a/c dr
To cash a/c
Or one bank a/c dr
To another bank a/c
Is called contra voucher
E.g. cash deposited at Himalayan bank rs 100000
Cash withdraw from Himalayan bank rs 50000
Cash transferred from Himalayan bank to kumari bank rs 10000
Note: Final accounts means
Profit and loss a/c and Balance sheet
Rules of Debit and credit:
1. Personal account:
This account is involve with person or organization, IN this account receiver is debited givers is credited.
Receiver DR.
Giver Cr.
2. Real account:
This account is related with assets and liabilities in this account what comes in debit, what goes out is credit.
What comes in Dr?
What goes out Cr.?
3. Nominal account:
This account is related with income and expenditures or profit and loss, in this account expenditure and loss are debited, income and profit are credited.
Expenditure/ loss Dr.
Income/profit CR.
Examples:
1. House rent paid in cash Rs 10000
House rent a/c dr ...........10000
To cash a/c ..........................10000
(Being house rent paid)
2. Furniture purchase paid in cash Rs 30000
Furniture a/c ..........dr 30000
To cash a/c ................30000
(Being furniture purchased)
3. Sales received in cash Rs 10000
Cash a/c Dr ..................10000
To sales a/c ............10000
(Being sales in cash)
4. Sales to hari on credit Rs 30000
Hari a/c Dr ................30000
to sales a/c ................30000
( being sales on credit. )
5. Salary payable to Ram Rs 50000
salary a/c Dr .............50000
to Ram a/c ............50000
(being salary payable)
6. Commission receivable from Janak - Rs 30000
Janak a/c Dr ...........30000
To commission a/c .............30000
(Being commission receivable)
Creating Ledger:
Gateway of Tally
1. Select account info press enter.
2. select ledger
3. select create.
Ledger creation.
Name : House rent a/c /furniture a/c / capital a/c
Under: Indirect expenses/ fixed assests / capital a/c
Inventory value are effected : No opening balance .
4. Press CTRL + A
Display of Ledger:
Gateway of Tally ( Heading )
1. select account info Press enter.
2. select ledger.
3. select display.
Modify of Ledger:
1. Select account info Press enter.
2. Select ledger.
3. Select alter.
4. Select required ledger.
5. Modify the ledger.
6. Press CTRL + A to save.
Delete a ledger:
1. Select account info Press Enter.
2. Select Ledger.
3. Select alter.
4. Select required ledger.
5. Press CTRL + D
Transfer of ledger from one company to another company
1. Create a new company
2. Open a ledger having ledger
3. Select account info press enter
4. Select ledger press enter
5. Select alter of multiple ledger press enter
6. Select all items press enter
7. Press f3
8. select required company press enter
9. Press ctrl+a
(note: for ledger transfer currency of both company should be same)
Report Display:
Display of Daybook:
1. Select display of reports menu Press enter.
2. Select day book.
3. Press ALT + F1 for details.
Display of total number of vouchers:
1. select display Press enter.
2. Select statement of account.
3. Select statistics.
Display of Ledger reports.
1. select display Press enter.
2. Select account book.
3. Select ledger.
4. Select required ledger.
Display of cash book and bank book:
1. Select display Press enter.
2. select account book.
3. select cash / Bank book.
select bank account for bank book.
Display of Trail balance:
1. Select Display . Press Enter.
2. select Trail Balance.
3. Press ALT + F1 for details.
Display of Profit and Loss Accounts:
1. Select profit and loss a/c of report menu Press Enter.
2. Press ALT + F1 for Details.
Display of Balance sheet:
1. Select balance sheet of reports menu. Press Enter.
2. Press ALT + F1 for details.
Modify for wrong voucher entry:
1. Select display . Press Enter.
2. Select day book.
3. select required voucher entry .
4. Modify the voucher with date, voucher type , ledger and amounts.
5. Press CTRL + A
Delete of Unnecessary voucher:
1. Select display of report menu.
2. Select Day book.
3. Select required voucher.
4. Press ALT + D.
INVENTORY VOUCHER:
The voucher related to stock is called inventory voucher.
It is involved with product or stock item; there are four types of inventory voucher.
1. Purchase voucher.
2. Debit note on purchase return.
3. Sales voucher.
4. Sales returned on credit note.
1. Purchase voucher:
If we purchase good for resale (trading point of view) that voucher is called purchase voucher.
Example:
1. Purchase of following items on credit from xyz supplier for resale
Sony color TV 10 sets @ 20000
L.G color TV 20 sets @ 50000
Samsung color TV 20 sets @ 10000
Purchase a/c Dr
Sony COLOUR TV 10@20000=
LG COLOUR TV 10@50000 =
SAMSUNG COLOUR TV 20@10000=
TO xyz supplier a/c
(BEING PURCHASE OF VARIOUS ITEMS IN CASH)
2. Debit Note on purchase return :
This voucher is use the time of purchase returned to the supplier whose entry is opposite of purchase voucher .
Example:
Purchase returned to the XYZ supplier of following items.
Sony color TV 2 sets @ 20000
LG color TV 2 sets@ 50000
Samsung color TV 2 sets @ 10000
xyz supplier a/c Dr.
To purchase returned a/c
Sony color TV 2 sets @ 20000
L.G color TV 2sets @ 50000
Samsung color tv 2 sets @ 40000
(BEING PURCHASE RETURNED )
3. sales voucher:
If we sell good for trading point of view ( which goods where purchased for Resale) that voucher is called sales voucher.
Examples:
Sales of following items on credit to the ABC company.
Sony color tv 5 sets @ 25000
LG color tv 5 sets @55000
Samsung color tv 5 sets @ 15000
ABC company ……..Dr 47500
To sales a/c …………………47500
Sony color tv 5 sets @ 25000=
LG color tv 5 sets @55000=
Samsung color tv 5 sets @ 15000=
(BEING SALES TO ABC COMPANY)
4.sales returned or credit note:
This voucher is credited at the time of sales returned by the customer the voucher entry of sales returned is opposite entry of sales.
The following item one returned by ABC Company.
Sony color tv 1sets@25000
LG color TV 1sets @ 55000
Samsung color TV 1 set @ 15000
Sales returned A/C Dr 95000
Sony color tv 1sets@25000
LG color TV 1sets @ 55000
Samsung color TV 1 set @ 15000
To ABC company 95000
(BEING SALES RETURNED FROM ABC COMPANY)
Here looking at the above transactions there are not only ledgers but also stock items ,stock group and sub group
Stock group : computer/television
Stock subgroup: computer/desktop/laptop
Stock subgroup: television/colour/b/w
Units of measure : sets
Stock items : sony,lg, ibm,tvm etc
Stock groups
Computer
Television
Desktop
Laptop
Colour
b/w
IBM
tvm
mercury
national
Toshiba
Sony
lg
STOCK GROUP:
CREATING STOCK GROUP:
1. Select inventory info. Press enter.
2. Select stock group
3. Select create.
Name: computer / TV.
Under: primary.
4. Press CTRL + A
CREATING STOCK SUBGROUP:
1. Select inventory info. Press enter.
2. Select stock group.
3. Select create. Press enter.
Subgroup:
Name: Desktop / Laptop
Under: computer.
Tv.
Name : color/ B.w.
Under: TV.
CREATIONG UNIT TO MEASURE:
1. select inventory info. Press enter.
2. Select units to measure.
3. Select create. Press enter.
Type: simple.
Symbol: sets 1 kg / bottle.
Foral Name (kilogram)
4. Press CTRL + A.
CREATIJN STOCK ITEM / PRODUCT:
1. select inventory info. Press enter.
2. Select stock item.
3. Select create.
Name: Sony / Lg/ IBM / TVM.
Under : Desktop / Laptop/ color .
Units : sets.
Opening Balance.
Quantity : rate amount
4. Press CTRL + A (accept / Deny)
ENTRY OF PURCHASE VOUCHER (INVOICE)
Process before entry of purchase voucher
1. Press f11
2. Select inventory features
3. Go to invoicing
4. Allow invoicing (yes)
5. Enter purchase in invoice format (yes)
ENTRY OF PURCHASE VOUCHER (INVOICE )
1. Select accounting voucher.
2. Press F9 for purchase voucher.
3. Type Ref. No (Bill No)
4. Select pary Name (cash, bank, supplier.).
5. Select Purchase ledger.
6. Select required item.
7. Type quantity and rate CTRL + A.
8. Type the narration Press CTRL+ A.
ENTRY OF SALES VOUCHER:
1. Select accounting voucher.
2. Press F8, for sales voucher. Type ref.no.
3. Select party Name (cash, bank, customer.)
4. Select sales ledger.
5. Type quantity & rate.
6. Type the narration.
7. Press CTRL + A.
STOCK REPORT:
DISPLAY OF STOCK ITEMS:
1. Select display.
2. Select inventory books
3. Select stock item or group summary
4. Select required item
DISPLAY OF MOVEMENT ANALYSIS
1. Select display
2. Select inventory books
3. Select movement analysis or stock group analysis or ledger analysis
4. Select required item.
DISPLAY OF STORE QUERY
1. Select display
2. Select display of inventory
3. Select stock query
4. Select required stock item.
BUDGET:
A budget is the guess of Income and expenditure which is planned before financial year which may match or may not match with actual transaction.
Process of Budget:
1. Press F11.
2. Select accounting feature press enter.
3. Select related company Press enter.
GO TO BUDGET:
1. Maintain Budget and control yes.
2. Press CTRL + A
Crediting budget:
1. Select account info press enter.
2. Select credit Press enter.
Budget creation:
Name: Budget.
Under: Primary.
Period of budget set/ alter badger of
From to groups ledger.
Paper -2000 31 mar 2007 No Yes.
(Note period must same period of company)
Account name types Budget amount.
Sales a/c on closing Balance 130000
Service charge income “ 13000
Press Enter two (2) time:
Press CTRL + A
DISPLAY OF Budget VARIATION:
1. Select profit & Loss A/c Press enter.
2. Press ALT + C.
3. Select related company:
COULUMS DETAILS:
Name of company: ABC COMPANY.
Types of value to show: Budget.
Show variation: Yes.
DEPRECITATION / APPRECIATION:
Depreciation and appreciation are used at the case of fixed assists. Depreciation decrease the value of Assets and Appreciation increase the value of Assets.
1. Purchase of computer Rs 50000 dep. has been charged @15 % with fixed installment method.
2. Purchase of Furniture Rs 30000 dep. has been charged 20%.
3. Purchase of building with Rs 1500000 at the end of year the value of building is Rs 2000000.
4. Purchase of land with Rs 1000000 at the end of year the value of land is calculated Rs 1200000.
Entry of Depreciation:
Dep a/c dr.
To assets a/c (related.)
Entry of appreciation:
Assets a/c dr (related)
To app a/c
Example of:
Q.N.4 Land a/c dr ……..1000000
To cash ………………………..1000000
Land a/c ………dr………………….200000
To app a/c ……………………200000
Q.N.2 Furniture a/c dr………….30000
To cash a/c …………………30000
Dep a/c dr ………….6000
To furniture a/c ………….6000
Q.N.3 Building a/c dr……..1500000
To cash a/c …………………..1500000
Building a/c...dr ……………500000
To app. a/c …………………..500000
Q.N.1 computer a/c DR…………….50000
To cash a/c ……………………….50000
Dep a/c dr.………………..7500
To computer a/c ……………….7500
TRANSFER OF LEDGER FROM ONE COMPANY TO ANOTHER COMPANY:
1. Create a new company.
2. Select an old company having a ledger.
3. Select account info. Press enter.
4. Select ledger press enter
5. Select of alter of Multiple ledger. Pe .
6. Select all items
7. Press F3
8. Select required company where u want to send ledger.
9. Press CTRL + A
VALUATION OF CLOSING STOCKS (PREPARING OF TRADING DISCOUNT)
1. Press f11
2. Select statement of inventory
3. Go to general
4. Integrate account and inventory= (yes)
CREATING GODOWN
1. Press f11 go to inventory features
2. Go to storage and classification
3. Maintain multiple godowns (yes)
4. Ctrl+a
5. Select inventory info
6. Select go down
7. Select create
Example,
Name: Katmandu, pokhara
Under: main location
Baneshwor: under: Katmandu
Bagar: under: pokhara
VOUCHER ENTRY AT PURCHASE HAVING GODOWN
1. Select accounting voucher
2. Press f9 for purchase voucher
3. Type re-do
4. Select party name and purchase ledger
5. Select required item
6. Select required godown
7. Type quantity and rate
8. Press ctrl+a
DISPLAY OF GODOWN AND REPORTS
1. Select display
2. Select statement of inventory
3. Select required item
4. Select required godown
ENTRY OF DEBIT AND CREDIT NOTE
PROCESS OF DEBIT NOTE AND CREDIT NOTE
1. Press f11=select inventory features (f2)
2. Go to inventory=use debit/credit notes (yes)
3. Use invoice mode for or credit note= (yes)
4. Use invoice mode for debit note = (yes)
5. Press ctrl+a
ENTRY OF PURCHASE RETURN (DEBIT NOTE)
1. Select accounting voucher
2. Click on debit note or press ctrl f9
3. Type ref no.
4. Party name: eg, ABC company (supplier name)
5. Select purchase ledger= purchase a/c
6. Select required item
7. Type quantity and rate
8. Then save it.
ENTRY OF SALES RETURN (CREDIT NOTE)
1. Select accounting voucher
2. Click on credit note or press ctrl+f8
3. Type ref no.
4. Parties account name: customer name
5. Select sales ledger
6. Select required item
7. Type quantity and rate= save it
Process of PURCHASE AND SALES ORDER:
1. Press F11 > select inventory feature.
2. Press enter > order processing.
3. Allow purchased order processing = Yes.
4. Allow sales order processing = Yes.
5. CTRL + A.
ENTRY OF PURCHASE ORDER:
1. Select inventory voucher.
2. Press (ALT + F4) or, click or, purchased order.
3. Click party‘s name.
4. Type order no.
5. Select purchase ledger.
6. Select required item.
7. Type quantity and rate > save it.
ENTRY OF SALES ORDER:
1. Select inventory voucher.
2. Press ALT + F5
3. Select order no.
4. Select sales ledger.
5. Select required item.
6. Type quantity and rate > save it.
DISPLAY OF PURCHASE AND SALES ORDER:
1. Select display of reports.
2. Select statements of inventory.
3. Select sale order summary or purchased order summary.
4. Select required stock group.
PAYROLL ACCOUNTING:
1. Select accounting voucher.
2. Press F9 for purchase voucher.
3. Type Ref. No (Bill No)
4. Select pary Name (cash, bank, supplier.).
5. Select Purchase ledger.
6. Select required item.
7. Type quantity and rate CTRL + A.
8. Type the narration Press CTRL+ A.
ENTRY OF SALES VOUCHER:
1. Select accounting voucher.
2. Press F8, for sales voucher. Type ref.no.
3. Select party Name (cash, bank, customer.)
4. Select sales ledger.
5. Type quantity & rate.
6. Type the narration.
7. Press CTRL + A.
STOCK REPORT:
DISPLAY OF STOCK ITEMS:
1. Select display.
2. Select inventory books
3. Select stock item or group summary
4. Select required item
DISPLAY OF MOVEMENT ANALYSIS
1. Select display
2. Select inventory books
3. Select movement analysis or stock group analysis or ledger analysis
4. Select required item.
DISPLAY OF STORE QUERY
1. Select display
2. Select display of inventory
3. Select stock query
4. Select required stock item.
BUDGET:
A budget is the guess of Income and expenditure which is planned before financial year which may match or may not match with actual transaction.
Process of Budget:
1. Press F11.
2. Select accounting feature press enter.
3. Select related company Press enter.
GO TO BUDGET:
1. Maintain Budget and control yes.
2. Press CTRL + A
Crediting budget:
1. Select account info press enter.
2. Select credit Press enter.
Budget creation:
Name: Budget.
Under: Primary.
Period of budget set/ alter badger of
From to groups ledger.
Paper -2000 31 mar 2007 No Yes.
(Note period must same period of company)
Account name types Budget amount.
Sales a/c on closing Balance 130000
Service charge income “ 13000
Press Enter two (2) time:
Press CTRL + A
DISPLAY OF Budget VARIATION:
1. Select profit & Loss A/c Press enter.
2. Press ALT + C.
3. Select related company:
COULUMS DETAILS:
Name of company: ABC COMPANY.
Types of value to show: Budget.
Show variation: Yes.
DEPRECITATION / APPRECIATION:
Depreciation and appreciation are used at the case of fixed assists. Depreciation decrease the value of Assets and Appreciation increase the value of Assets.
1. Purchase of computer Rs 50000 dep. has been charged @15 % with fixed installment method.
2. Purchase of Furniture Rs 30000 dep. has been charged 20%.
3. Purchase of building with Rs 1500000 at the end of year the value of building is Rs 2000000.
4. Purchase of land with Rs 1000000 at the end of year the value of land is calculated Rs 1200000.
Entry of Depreciation:
Dep a/c dr.
To assets a/c (related.)
Entry of appreciation:
Assets a/c dr (related)
To app a/c
Example of:
Q.N.4 Land a/c dr ……..1000000
To cash ………………………..1000000
Land a/c ………dr………………….200000
To app a/c ……………………200000
Q.N.2 Furniture a/c dr………….30000
To cash a/c …………………30000
Dep a/c dr ………….6000
To furniture a/c ………….6000
Q.N.3 Building a/c dr……..1500000
To cash a/c …………………..1500000
Building a/c...dr ……………500000
To app. a/c …………………..500000
Q.N.1 computer a/c DR…………….50000
To cash a/c ……………………….50000
Dep a/c dr.………………..7500
To computer a/c ……………….7500
TRANSFER OF LEDGER FROM ONE COMPANY TO ANOTHER COMPANY:
1. Create a new company.
2. Select an old company having a ledger.
3. Select account info. Press enter.
4. Select ledger press enter
5. Select of alter of Multiple ledger. Pe .
6. Select all items
7. Press F3
8. Select required company where u want to send ledger.
9. Press CTRL + A
VALUATION OF CLOSING STOCKS (PREPARING OF TRADING DISCOUNT)
1. Press f11
2. Select statement of inventory
3. Go to general
4. Integrate account and inventory= (yes)
CREATING GODOWN
1. Press f11 go to inventory features
2. Go to storage and classification
3. Maintain multiple godowns (yes)
4. Ctrl+a
5. Select inventory info
6. Select go down
7. Select create
Example,
Name: Katmandu, pokhara
Under: main location
Baneshwor: under: Katmandu
Bagar: under: pokhara
VOUCHER ENTRY AT PURCHASE HAVING GODOWN
1. Select accounting voucher
2. Press f9 for purchase voucher
3. Type re-do
4. Select party name and purchase ledger
5. Select required item
6. Select required godown
7. Type quantity and rate
8. Press ctrl+a
DISPLAY OF GODOWN AND REPORTS
1. Select display
2. Select statement of inventory
3. Select required item
4. Select required godown
ENTRY OF DEBIT AND CREDIT NOTE
PROCESS OF DEBIT NOTE AND CREDIT NOTE
1. Press f11=select inventory features (f2)
2. Go to inventory=use debit/credit notes (yes)
3. Use invoice mode for or credit note= (yes)
4. Use invoice mode for debit note = (yes)
5. Press ctrl+a
ENTRY OF PURCHASE RETURN (DEBIT NOTE)
1. Select accounting voucher
2. Click on debit note or press ctrl f9
3. Type ref no.
4. Party name: eg, ABC company (supplier name)
5. Select purchase ledger= purchase a/c
6. Select required item
7. Type quantity and rate
8. Then save it.
ENTRY OF SALES RETURN (CREDIT NOTE)
1. Select accounting voucher
2. Click on credit note or press ctrl+f8
3. Type ref no.
4. Parties account name: customer name
5. Select sales ledger
6. Select required item
7. Type quantity and rate= save it
Process of PURCHASE AND SALES ORDER:
1. Press F11 > select inventory feature.
2. Press enter > order processing.
3. Allow purchased order processing = Yes.
4. Allow sales order processing = Yes.
5. CTRL + A.
ENTRY OF PURCHASE ORDER:
1. Select inventory voucher.
2. Press (ALT + F4) or, click or, purchased order.
3. Click party‘s name.
4. Type order no.
5. Select purchase ledger.
6. Select required item.
7. Type quantity and rate > save it.
ENTRY OF SALES ORDER:
1. Select inventory voucher.
2. Press ALT + F5
3. Select order no.
4. Select sales ledger.
5. Select required item.
6. Type quantity and rate > save it.
DISPLAY OF PURCHASE AND SALES ORDER:
1. Select display of reports.
2. Select statements of inventory.
3. Select sale order summary or purchased order summary.
4. Select required stock group.
PAYROLL ACCOUNTING:
Payroll means pay to the
staffs in many headings like basic salary, allowance, overtime etc.
PROCESS OF PAYROLL VOUCHER:
1. Press F11 > select accounting features.
2. Go to cost / profit center management.
3. Maintain payroll> Yes.
4. More than one payroll / cost catering.
5. Press CTRL +A
ENTRY OF PAYRLL VOUCHER:
1. Select payroll voucher.
2. Select cash account or bank a/c from the account option.
3. Pres enter.
4. Press ALT + C.
5. Type the name of category.
Example:
Name: staff.
Press ALT + C (employer creation)
Category: staff.
Name: Ram.
Under: primary.
Date of opening 1-11-2008
General of payment details
6. Press ALT + A.
7. Press ALT + C (pay head creation)
8. Pay head info.
Pay head earning for employee.
Under: Direct Expenses.
Affect Net salary > Yes.
Name to appear in pay slip > basic salary.
Use of continuity > No.
Calculation type: as use defined value
Then save it.
Questions Related to Payroll accounting
Salary paid to staffs
Staff
Ram
Basic salary 15000
Bonus 2000
Overtime 600
Allowance 10000
Hari
Basic salary 20000
Bonus 1500
Overtime 600
Allowance 10000
Sita
Basic salary 30000
Bonus 1500
Overtime 600
Allowance 5000
Janak
Basic salary 25000
Bonus 1500
Overtime 600
Allowance 10000
DISPLAY OF PAYSHEET:
1. Select display > press enter.
2. Select payroll report.
3. Select statement of payroll.
4. Select pay sheet.
Process of expiry dates and batch no.
· press f11
· select inventory feature press enter
· go to storage and classification
· maintain batch wise details (yes)
· set expiry dates for batches (yes)
· press ctrl+a
PROCESS OF PAYROLL VOUCHER:
1. Press F11 > select accounting features.
2. Go to cost / profit center management.
3. Maintain payroll> Yes.
4. More than one payroll / cost catering.
5. Press CTRL +A
ENTRY OF PAYRLL VOUCHER:
1. Select payroll voucher.
2. Select cash account or bank a/c from the account option.
3. Pres enter.
4. Press ALT + C.
5. Type the name of category.
Example:
Name: staff.
Press ALT + C (employer creation)
Category: staff.
Name: Ram.
Under: primary.
Date of opening 1-11-2008
General of payment details
6. Press ALT + A.
7. Press ALT + C (pay head creation)
8. Pay head info.
Pay head earning for employee.
Under: Direct Expenses.
Affect Net salary > Yes.
Name to appear in pay slip > basic salary.
Use of continuity > No.
Calculation type: as use defined value
Then save it.
Questions Related to Payroll accounting
Salary paid to staffs
Staff
Ram
Basic salary 15000
Bonus 2000
Overtime 600
Allowance 10000
Hari
Basic salary 20000
Bonus 1500
Overtime 600
Allowance 10000
Sita
Basic salary 30000
Bonus 1500
Overtime 600
Allowance 5000
Janak
Basic salary 25000
Bonus 1500
Overtime 600
Allowance 10000
DISPLAY OF PAYSHEET:
1. Select display > press enter.
2. Select payroll report.
3. Select statement of payroll.
4. Select pay sheet.
Process of expiry dates and batch no.
· press f11
· select inventory feature press enter
· go to storage and classification
· maintain batch wise details (yes)
· set expiry dates for batches (yes)
· press ctrl+a
Creating stock items having expiry dates and batches
· select inventory info press enter
· select stock items press enter
· select create press enter
· e.g. name : rara, waiwai
Under: chauchau
Maintain in batches (yes)
Track date of mfg (yes)
Use expiry date (yes)
Display of stock items having expiry dates.
· select display
· select inventory books
· select Ageing analysis
· select required stock group
· press Alt+S to choose ageing style
· choose required style
· eg.Accounting to the m.f.g. expiry date
Purchase entry of stock items having expiry dates
· select Accounting voucher
· Press F9 for Purchased voucher
· Type Ref. no.
· Party's A/c Name & Purchase ledger A/c
· select required item
· select new number for batches
Eg.Batch No.64/5, Quantity 10, Rate 20, Amount 200
Type Mfg.date: April-2005 Expire date: April: 2009
· Save it
Creating stock categories:
· press F11
· select inventory features
· Go to storage & classification
· (maintain stock categories-yes)
· press Ctrl+A
· Select inventory info.
· select stock categories
· select create
Eg.Name-Entertainment
Under-Primary
Create stock item having stock categories:
· Select inventory info.
· select stock items
· select create
eg.Name: Sony
Under: TV
Categories: Entertainment
Maintain batcher: No
Process of Discount in quantities:
· press F11
· select inventory features
· Go to Storage & Classification
(Use different Account's billed Qty-yes)
· press Ctrl+A
Entry of purchases having discount in quantity:
· select Accounting voucher
· press purchase voucher
· select required item
E.g. Actual billed Rate Amount
Name Sony 20sets 15sets 1500 225000
· save it
Display of stock categories:
· select display
· select statement of inventory
· select categories
· select required categories
Questions related to expiry dates/batch no.
Stock categories discount and enter
Categories:
· mansuli rice 1 quintel@70 kg
· basmati rice 90 kg @60 kg
· pokhreli rice 80 kg @70 kg
· Sony color TV 5 sets @ 15000
· LG color TV 6 sets @ 12000
· Samsung color TV 5 sets @10000
There is 2kg discount in every set at TV.
Then batch no. at consumption item
62/3 and Mfg date 1-4-2002
Expire date 1-4-2009
Process of Multiple Currencies:
· press F11
· select Accounting features
· Go to General-Allow multiple currency-yes
· press Ctrl+A
· select inventory info press enter
· select stock items press enter
· select create press enter
· e.g. name : rara, waiwai
Under: chauchau
Maintain in batches (yes)
Track date of mfg (yes)
Use expiry date (yes)
Display of stock items having expiry dates.
· select display
· select inventory books
· select Ageing analysis
· select required stock group
· press Alt+S to choose ageing style
· choose required style
· eg.Accounting to the m.f.g. expiry date
Purchase entry of stock items having expiry dates
· select Accounting voucher
· Press F9 for Purchased voucher
· Type Ref. no.
· Party's A/c Name & Purchase ledger A/c
· select required item
· select new number for batches
Eg.Batch No.64/5, Quantity 10, Rate 20, Amount 200
Type Mfg.date: April-2005 Expire date: April: 2009
· Save it
Creating stock categories:
· press F11
· select inventory features
· Go to storage & classification
· (maintain stock categories-yes)
· press Ctrl+A
· Select inventory info.
· select stock categories
· select create
Eg.Name-Entertainment
Under-Primary
Create stock item having stock categories:
· Select inventory info.
· select stock items
· select create
eg.Name: Sony
Under: TV
Categories: Entertainment
Maintain batcher: No
Process of Discount in quantities:
· press F11
· select inventory features
· Go to Storage & Classification
(Use different Account's billed Qty-yes)
· press Ctrl+A
Entry of purchases having discount in quantity:
· select Accounting voucher
· press purchase voucher
· select required item
E.g. Actual billed Rate Amount
Name Sony 20sets 15sets 1500 225000
· save it
Display of stock categories:
· select display
· select statement of inventory
· select categories
· select required categories
Questions related to expiry dates/batch no.
Stock categories discount and enter
Categories:
· mansuli rice 1 quintel@70 kg
· basmati rice 90 kg @60 kg
· pokhreli rice 80 kg @70 kg
· Sony color TV 5 sets @ 15000
· LG color TV 6 sets @ 12000
· Samsung color TV 5 sets @10000
There is 2kg discount in every set at TV.
Then batch no. at consumption item
62/3 and Mfg date 1-4-2002
Expire date 1-4-2009
Process of Multiple Currencies:
· press F11
· select Accounting features
· Go to General-Allow multiple currency-yes
· press Ctrl+A
Process of multiple currencies
· press f11 press enter
· maintain multiple currency (yes)
· press ctrl+a
Creating currency
· select account info press enter
· select currency press enter
· select create press enter
· Symbol e.g. $, IC, NC etc.
· formal name-Dollar, Indian Currency,Nepali currency
· no. of Decimal places-2
· Show Account million-NO
· Is symbol sufficient to Amount-yes
· put a space between amount and symbol-yes
· symbol for Decimal portion Amount-2cents
· Decimal places for printing Amount in words-2
Setting rate of exchange of currency:
· Select Account info.
· select Currencies
· select required currency
· type setting Rate & Buying Rate
· then save it
Display of Balance Sheet or Profit & Loss with Multiple Currencies:
· select Balance Sheet
· click on new column or press Alt+C
· column in details
From: 1-4-2006
To:
Currency: NC/IC
Method of stock valuation: Default
Process of interest calculation:
· press F11
· select accounting features
· Go to Outstanding Management
· Activate Interest calculation
· press Ctrl+A
Setting of interest on the ledger:
· Select Account info.
· select ledger
· select create
eg.Name: Himalayan Bank A/c
Under: Bank A/c
Currency of ledger=Rs
Active interest cash=yes
Effective date for Decimalization
Interest parameters (% of interest)
· Rate:-e.g. 10% per 365 days
· then save it
Ques.Make a contra voucher related to the bank
Display of Interest Calculation:
· select display
· select statement of account
· select interest calculation
· select ledger
· select required ledger
· press Alt+F2
· defined then period
eg.from:1-4-2006
To : 2-4-2006
Questions:-
· Create the currency e.g. Dollor, Euro, & sets their exchange rate.
· Display the B/S on P/L with multiple currency
· Cash deposited at Himalayan Bank Rs.10, 00,000 & calculate the interest with 5% Rate 1 days or 1 year.
Entry of additional cost of purchase:
(Transfer charge, labor charge etc.)
· press F11
· select inventory features
· Go to purchase management
· (track additional cost of purchase-yes)
· press Ctrl+A
Question: Create the ledger of additional cost.
Eg.labour charge, transport charge
(Direct expense)
Entry of purchased voucher with extra charge:
· select accounting voucher
· select purchased voucher
· select party's Name & ledger of extra charge
· transport charge (type the amount)
· then save it
Setting of credit limit to the customer:
· press F11
· select accounting features
· Go to Budget & Scenario Management
· Maintain Budget & Control-yes
· press Ctrl+A
Creating ledger for credit limit
(Ledger for credit limit)
E.g. Name: xyz company'
Under: Sundry Debtors
Then Save it
Currency of ledger -Rs
Maintain Balance Bill by bill=NO
Active interest calculation= NO
Voucher entry of sales with the customer having Credit limit:
· select sales voucher
· select party's A/c name & sales ledger
· select required item
· type quantity & rate
(Note:-transaction must be credit and amount must be greater than credit limit value loan entry will not accept save.)
Transfer of stock items from one Go down to another Godown:
Create Godowns & make the purchase voucher to the Godown-
· select inventory voucher
· select stock journal voucher
· select required item from source
Eg.select required Godowns-
Kuleshwor
· type the quantity and rate
· press Enter
· select Go down
· type quantity and rate from destination
· then save it
Revenue / Non Revenue:
1. Revenue: Related to profit and loss item.
(Related to income and expenditure.)
2. Non Revenue:
Related to balance sheet item. (Related to assets and liabilities.
Cost category: staff/owners/branch/bank/stationery
Cost centers: ram/shiva/mohan/newroad/pataqn/rular
COST CENTER AND COST CATEGORY
Process of cost categories and cost centers.
1. Press F 11 > Select accounting features.
2. Select required company
3. Go to cost / profit center management.
(Maintain cost centers> yes)
More than one payroll / cost category > yes (press CTRL +A)
CREATING COST CATAGORIES:
1. Select account info.
2. Select cost categories.
3. Select create.
Eg: Name: owners.
Staff.
· press f11 press enter
· maintain multiple currency (yes)
· press ctrl+a
Creating currency
· select account info press enter
· select currency press enter
· select create press enter
· Symbol e.g. $, IC, NC etc.
· formal name-Dollar, Indian Currency,Nepali currency
· no. of Decimal places-2
· Show Account million-NO
· Is symbol sufficient to Amount-yes
· put a space between amount and symbol-yes
· symbol for Decimal portion Amount-2cents
· Decimal places for printing Amount in words-2
Setting rate of exchange of currency:
· Select Account info.
· select Currencies
· select required currency
· type setting Rate & Buying Rate
· then save it
Display of Balance Sheet or Profit & Loss with Multiple Currencies:
· select Balance Sheet
· click on new column or press Alt+C
· column in details
From: 1-4-2006
To:
Currency: NC/IC
Method of stock valuation: Default
Process of interest calculation:
· press F11
· select accounting features
· Go to Outstanding Management
· Activate Interest calculation
· press Ctrl+A
Setting of interest on the ledger:
· Select Account info.
· select ledger
· select create
eg.Name: Himalayan Bank A/c
Under: Bank A/c
Currency of ledger=Rs
Active interest cash=yes
Effective date for Decimalization
Interest parameters (% of interest)
· Rate:-e.g. 10% per 365 days
· then save it
Ques.Make a contra voucher related to the bank
Display of Interest Calculation:
· select display
· select statement of account
· select interest calculation
· select ledger
· select required ledger
· press Alt+F2
· defined then period
eg.from:1-4-2006
To : 2-4-2006
Questions:-
· Create the currency e.g. Dollor, Euro, & sets their exchange rate.
· Display the B/S on P/L with multiple currency
· Cash deposited at Himalayan Bank Rs.10, 00,000 & calculate the interest with 5% Rate 1 days or 1 year.
Entry of additional cost of purchase:
(Transfer charge, labor charge etc.)
· press F11
· select inventory features
· Go to purchase management
· (track additional cost of purchase-yes)
· press Ctrl+A
Question: Create the ledger of additional cost.
Eg.labour charge, transport charge
(Direct expense)
Entry of purchased voucher with extra charge:
· select accounting voucher
· select purchased voucher
· select party's Name & ledger of extra charge
· transport charge (type the amount)
· then save it
Setting of credit limit to the customer:
· press F11
· select accounting features
· Go to Budget & Scenario Management
· Maintain Budget & Control-yes
· press Ctrl+A
Creating ledger for credit limit
(Ledger for credit limit)
E.g. Name: xyz company'
Under: Sundry Debtors
Then Save it
Currency of ledger -Rs
Maintain Balance Bill by bill=NO
Active interest calculation= NO
Voucher entry of sales with the customer having Credit limit:
· select sales voucher
· select party's A/c name & sales ledger
· select required item
· type quantity & rate
(Note:-transaction must be credit and amount must be greater than credit limit value loan entry will not accept save.)
Transfer of stock items from one Go down to another Godown:
Create Godowns & make the purchase voucher to the Godown-
· select inventory voucher
· select stock journal voucher
· select required item from source
Eg.select required Godowns-
Kuleshwor
· type the quantity and rate
· press Enter
· select Go down
· type quantity and rate from destination
· then save it
Revenue / Non Revenue:
1. Revenue: Related to profit and loss item.
(Related to income and expenditure.)
2. Non Revenue:
Related to balance sheet item. (Related to assets and liabilities.
Cost category: staff/owners/branch/bank/stationery
Cost centers: ram/shiva/mohan/newroad/pataqn/rular
COST CENTER AND COST CATEGORY
Process of cost categories and cost centers.
1. Press F 11 > Select accounting features.
2. Select required company
3. Go to cost / profit center management.
(Maintain cost centers> yes)
More than one payroll / cost category > yes (press CTRL +A)
CREATING COST CATAGORIES:
1. Select account info.
2. Select cost categories.
3. Select create.
Eg: Name: owners.
Staff.
CREATING COST CENTERS.
1. Select account info.
2. Select cost centers.
3. Select create.
Ex:
Category: Owners.
Name: Ram
Under: primary.
CREATING LEDGERS HAVING COST CENTERS AND COST
CATAGORIES.
1. Select account info.
2. Ledger. Press enter.
3. Create. Press enter.
Name: Capital a/c
Under: capital a/c
Cost centers are applicable: Yes.
DISPLAY OF COST CENTERS AND COST CATAGORIES REPORTS:
1. Select display.
2. Statements of account
3. Cost center.
4. category summary, cost centers. Break up of ledger breakup. Press enter.
Tally ends here.
1. Select account info.
2. Ledger. Press enter.
3. Create. Press enter.
Name: Capital a/c
Under: capital a/c
Cost centers are applicable: Yes.
DISPLAY OF COST CENTERS AND COST CATAGORIES REPORTS:
1. Select display.
2. Statements of account
3. Cost center.
4. category summary, cost centers. Break up of ledger breakup. Press enter.
Tally ends here.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.