Purchase Return & Sales Return ||Debit note & Credit Note || in Tally (Video)

Purchase Return & Sales Return ||Debit note & Credit Note || in Tally (Notes)

In this concept we are performing stock oriented purchases,purchases returns, sales returns to implement inventory Operations we have to perform following operations.

Ledger :-

Purchases Return = purchases accounts

Sales Return = sales accounts

Accounting Vouchers:-

CTRL + F9 ---- DEBIT NOTE   - Purchase Rerurns
CTRL + F8 ---- CREDIT NOTE - Sales Returns

Note:- 
To perform the concept we have to perform fallowing setting's 

Go to accounting vouchers
Press F11
Press F2
Use debit/credit note -- Yes
Use invoice mode for credit note -- Yes
Use invoice mode for debit note -- Yes

Problem 1:-

1. Mr. Arvind started a new business with 5,00,000/-

2. Purchase as Fallows:-

       i) Computers - 15 Sets Each one  16,000/-

      ii) Pen drives - 50 No's  Each one       350/-

     iii) Headphones - 35 Sets Each one     170/-

3.Purchase Returns:-

       i) Computers -   3 Sets 

      ii) Pen drives -    7 No's  

     iii) Headphones - 5 Sets 

4. Sales as Fallows:-

       i) Computers - 12 Sets Each one  25,000/-

      ii) Pen drives - 43 No's  Each one       550/-

     iii) Headphones - 30 Sets Each one     300/-

5.Sales Returns:-

       i) Pen drives -    8 No's

      ii) Computers -   2 Sets   

     iii) Headphones - 5 Sets 

Problem 2:-

1. Mr. Prasad started a new business with 6,00,000/-

2. Furnicher Purchased  30,000/-

3. Purchase as Fallows:-

       i) LED Tv's - 30 Sets Each one  15,000/- from Vijaya Traders

      ii) Washing Machines - 15  Sets  Each one   22,000/- from Bhuvana Traders

     iii) Home Theaters - 45 Sets Each one     2500/- from Ravi Traders

4. Depreciation on Furnicher 4,000/-

5. Sales as fallows to Ganesh Traders:-

       i) LED Tv's - 20 Sets Each one  27,000/-

      ii) Washing Machines - 8  Sets  Each one  40,000/- 

     iii) Home Theaters - 30 Sets Each one     5000/-

6. Sales as fallows to Santhi & Co:-

         i) Home Theaters - 10 Sets Each one   4200/-

        ii) Washing Machines - 7  Sets  Each one  35,000/- 

       iii) LED Tv's - 10 Sets Each one  24,000/-

7. Sales Returns:-

 i) Washing Machines - 2  Sets  from Santhi & Co

ii) Home Theaters - 5 Sets  from Ganesh Traders.

8. Donation received 10,000/-

9. Travelling Expns 1,700/-

10. Purchase Returns:-

  i) Home Theaters - 5 Sets  from Ravi Traders.

 ii) Washing Machines - 2  Sets  from Bhuvana Traders

11. Cash Paid to Vijaya Traders
12. Cash Paid to Bhuvana Traders
13. Cash Paid to Ravi Traders
14. Cash From Ganesh Traders
15. Cash From Santhi & Co 60% Only.

_________________________________________________________________________

>> Back to Ms-Office Notes
>> Back to C-Language Notes
>> Back to Computer Fundamentals Notes
__________________________________________________________________________
>>Back to Video Tutorials
>>Back to All Courses Quiz
>>Back to Abbreviations
>>Back to All Courses Shortcut Keys

__________________________________________________________________________   

Inventory Management (Extra Problem) (Video)

Inventory Management (or) Stock Base Management (Video)

Two Apps on the screen at the same time in Mobiles.

Inventory Management (or) Stock Base Management in Tally (Notes)

In this concept we are performing stock oriented purchases,purchases returns, sales returns to implement inventory Operations we have to perform following operations.

Ledger :-

Purchases = purchases accounts

Sales = sales accounts

Inventory info ----> units of measure ----> stock items

Units of measure:-

In this option we are specifying stock base measurement like--Kg's, sets,liters,packets,bags etc........

Stock items:-

In this option we have to specify items information.

Steps for crarte measurement:-

1. Goto inventory info

2. Goto Unit of Measure

3. Goto Crete Option

4. Type the Sets

5. Enter.

Steps for create items:-

1. Goto inventory info

2. Goto stock items

3. Goto create(multiple stock items)

4. Name of the item = color tv's

                        units = sets

F8:-With the help of this key only we can per stock sales operations

F9:-To perform all types of stock purchases operations

Note:-

To perform purchases and sales operations we have to create "purchase a/c's and sales a/c's.

Problem 1:-

1. Mr. Praveen Started a New bussiness with 3,00,000/-

2. Power bill paid 1,200/-

3. Salary Paid 15,000/-

4. Interest Received 22,000/-

5. Purchases Color Tv's 10 Sets  Each one 9,000/-

6. Sales as Fallow's:-  

    Color Tv's 5 Sets Each one 15,000/-

    Color Tv's 3 Sets Each one 7,500/-

    Color Tv's 2 Sets Each one 12,000/-

Problem 2:-

1.Mr.Rakesh started a new business 5,00,000/- 
2.cash deposited in to SBI 1,00,000/- 
3.cash deposited in to andhra bank 2,00,000/- 
4.Rent Paid paid - 1000/- 
5.Purchases as fallow's:- 
     a. Rice 25 Bags each one 1050/-
     b. Oil 20 Cans  each one  2600/- 
     c. Sugar 35 Bags each one 2350/-
     d. Lux Soaps 50 Pisces each one 40/-
6. Cash withdraw from SBI 17,000/-
7. Cash Transfer to Andhra Bank to SBI 35,000/-
8. Sales as fallows through Andhra Bank:-
     a. Rice 15 Bags each one 1500/- 
     b. Oil 14 Cans  each one  3200/- 
     c. Lux Soaps 30 Pisces each one 55/-
     d. Sugar 25 Bags each one 3100/-
9. SBI Cheque Issued to Kumar 10,000/- (Cheque No:170589)
10. Sales as fallows:-
     a. Rice 10 Bags each one 1250/- 
     b. Oil 5 Cans  each one  2900/- 
     c. Sugar 7 Bags each one 2700/-
     d. Lux Soaps 20 Pisces each one 47/-
11.Cash Transfer to SBI to Andhra Bank 13,000/-
12.Cash Received from Kumar through SBI 10,000/-

 

 _________________________________________________________________________

>> Back to Ms-Office Notes
>> Back to C-Language Notes
>> Back to Computer Fundamentals Notes
__________________________________________________________________________
>>Back to Video Tutorials
>>Back to All Courses Quiz
>>Back to Abbreviations
>>Back to All Courses Shortcut Keys

__________________________________________________________________________   

Creating '4' Visiting Cards Models in Adobe Page Maker

Adobe Page Maker Complete Tutorial in Telugu

Credit Operations in Tally (Video)

Credit Operations in Tally (Notes)

In this concept we can perform any money transactions. It means barrow and sold items with credit operations. Here we can use credit purchase and credit sales.

In this concept we are having the fallowing operation's

Solution's

1. Computer purchased from Ravi 10,000/-

2. Computer was sold to Dinakar 20,000/-

CREDIT PURCHASES [F7]:-
Computer purchaed from Ravi 10,000/-

Ex:- by - Computer -10,000/-
       to  - Ravi          -10,000/-

Note:- We have to create Ravi has sundry creditor.

CREDIT SALES  [F7]:-
Computer was sold to Dinakar 20,000/-

Ex:- by -  Dinakar    - 20,000/-
       to  - Computer - 20,000/-

Note:- We have to create Dinakar has sundry Debitor.

Problem 1:-

1.  Mr.raju started a new business with  2,00,000/- 

2.  Cash Depositied into SBI  50,000/-3.  Office expenses  5,500/- 

4.  computer purchased from Rafi Technologies  22,000/-
5.  Furniture purchased from vijaya traders  14,000/-
6.  Donation Received through bank 18,000/-

7.  Cash paid to Rafi Technologies.
8.  Cash paid to Vijaya traders.

9.  Depreciation on Computer 2,500/-

10.Cash withdraw from SBI  25,000/-

11.Cash paid to Krishna 30,000/-

12.Cash Received from Krishna 40% Only

13.Computer was sold to Pavani 70% Profit.

14.Cash From Pavani.

Problem 2:-

1.Mr.Bunny started a new business with - 2,00,000/-
2.Cash deposited in to Andhra bank - 60,000/-
3.Rent paid through bank - 12,000/-
4.Interest paid - 2,000/-
5.Intrest received through bank - 8,000/-
6.Donation received through bank - 8,000/-
7.Printer purchased from Venkatesh - 8,000/-
8.Cell purchased from Amar - 9,000/-
9.Computer purchased from Rohini -16,000/-
10.Cash paid to Venkatesh.
11.Cash paid to Amar.
12.Cash Paid to Rohini.

13.Printer was sold to Prasad 25% Loss.

14.Cash from Prasad.

Problem 3:-

1.Miss.Sneha started a new business with - 5,00,000/- 

2.Scooter purchased from Vinay 38,000/- 

3.Furniture purchased from Satish Traders 24,000/- 

4.Cash paid to Vinay.

5. Scooter was sold to Vijay 42,000/-

6. Cash Paid to Satish.

7. Cash Deposited into Canara Bank 1,25,000/-

8. Cash from Vijay.

9. Cash with draw from Canara Bank 78,000/-

10. Internet bill Paid Through Bank 800/-

_________________________________________________________________________

>> Back to Ms-Office Notes
>> Back to C-Language Notes
>> Back to Computer Fundamentals Notes
__________________________________________________________________________
>>Back to Video Tutorials
>>Back to All Courses Quiz
>>Back to Abbreviations
>>Back to All Courses Shortcut Keys

__________________________________________________________________________

Quiz of the Ms-Excel (Week-22)

This set contains 10 multiple choice questions from Ms-Excel. Each question has four possible options and there is one and only one correct answer for each question.

_________________________________________________________________________________
1. Shortcut Key of Autosum
A. Ctrl  + =
B. Shift + =
C. Ctrl  + Enter
D. Alt   + =


2. The Name box
a. Shows the location of the previously active cell
b. Appears  the left of the formula bar
c. Appears below the status bar
d. Appears below the menu bar


3. Hyperlinks cannot be
a. Special shapes like stars and banners
b. Drawing objects like rectangles ovals
c. Pictures
d. All can be hyperlinks
 

4. You can use the horizontal and vertical scroll bars to
a. Split a worksheet into two panes
b. View different rows and columns
c. Edit the contents of a cell
d. View different worksheets
 


5. Which of the following setup options can not be set in the page setup dialog box?
a. Printer selection
b. Vertical or horizontal placement
c. Orientation
d. Row and column titles
 

6. You can open the consolidate dialog box byt choosing Consolidate from the ….. Tab.
a. Insert
b. Format
c. Tools
d. Data
 

7. Each excel file is called a workbook because
a. It can contain text and data
b. It can be modified
c. It can contain many sheets including worksheets and chart sheets
d. You have to work hard to create it


8.Which types of charts can excel produce?
a. Line graphs and pie charts only
b. Only line graphs
c. Bar charts, line graphs and pie charts
d. Bar charts and line graphs only


9. How are data organized in a spreadsheet?
a. Lines and spaces
b. Layers and planes
c. Rows and columns
d. Height and width
 

10. What does the VLOOKUP function do ?
a. Looks up text that contain ‘v’
b. Checks whether text is the same in one cell as in the next
c. Finds related records
d. All of above

---------------------------------------------------------------------------------------------------------------

>> Back to Quiz of All Computer Courses
>> Back to Notes of C-Language
>> Back to Shortcuts of All Computer Courses
>> Back to Video Tutorials of All Computer Courses
>> Back to Abbreviations

---------------------------------------------------------------------------------------------------------------

Ms-Excel Complete Tutorial

Above 30 Formulas & Functions in Ms-Excel

Above 10 Mathematical Problems in Ms-Excel

Ms-Word Complete Tutorial

Ms-Power Point Complete Tutorials

Partner Ship in Tally (Video Tutorials)

Depreciation in Tally (Video Tutorials)

Partner ship in Tally (Notes)

In this concept the company having minimum of partners.
We have to some profit (or) loss amount depends on their capital investment.

Ex1:- 

Ramu and ravi
Net profit 20,000/-

F7  -  by -- profitt & loss  --- 20,000/- 

         to -- ramu               --- 10,000/-
         to -- ravi                 --- 10,000/-

F5 -  by--cash
        to--ramu -- 10,000/-

F5 - by--cash
        to--ravi -- 10,000/-

Ex2:- 

Sitha and Ramya
Loss 50,000/-

F7  -  by -- profitt & loss  --- 50,000/- 

         to -- Sitha               --- 25,000/- 
         to -- Ramya             --- 25,000/- 

F6 -  by --cash
        to  --Sitha   -- 25,000/- 

F6 - by  --cash
        to --Ramya -- 25,000/-

Problem 1:-

1.  Mr.Ramu and Mr.Ravi invested 2,00,000 (Each person)
2.  Vehicle purchases 60,000/-
3.  Commission receive 15,000/-
4.  Interest receive 10,000/-
5.  Donation receive 25,000/-
6.  Vehicle was sold 65,000/-
7.  Office expediences 15,000/-
8.  Petty expediences 2,000/-
9.  Petty income 4,000/-

10.Power bill paid 950/-

Problem 1:- 

1.  Miss.Santhi and Miss.Geetha invested 6,00,000 (Miss.Santhi Inv: 30% ,Miss.Geetha Inv: 70%) 
2.  Furnicher purchases 15,000/- 
3.  Rent Paid 25,000/-
4.  Interest Paid 10,000/- 
5.  Donation Paid 35,000/- 
6.  Furnicher was sold 5,000/- 
7.  Office expediences 22,000/- 
8.  Travelling expediences 5,000/-
9.  Petty income 2,500/-

10.Net bill paid 1,950/-

_________________________________________________________________________

>> Back to Ms-Office Notes
>> Back to C-Language Notes
>> Back to Computer Fundamentals Notes
__________________________________________________________________________
>>Back to Video Tutorials
>>Back to All Courses Quiz
>>Back to Abbreviations
>>Back to All Courses Shortcut Keys

__________________________________________________________________________

Depreciation on Tally (Notes)

In this concept we are having the fallowing operation's

Solution's

      1) Depreciation on Computer

      2) Depreciation on Furnicher

To perform above operating we have create depreciation ledger under indirect expenses and we have to past using (F7).

Ledger Name	Under
Depreciation	Indirect expenses

Ex:- Depreciation on computer 400/-

F7-  By ---Depreciation  - 400
       To ---Computer      - 400

Problem 1:-

* Mr.Sampanth Started a new business with 5,00,000/-

* Computer purchased 23,000/-

* Vechile purchased 79,000/-

* Power bill paid 2,500/-

* Furnicher Purchased 13,500/-

* Depreciation on Computer 1,500/-

* Depreciation on Vechile 6,500/-

* Donation Received 15,000/-

* Computer was sold 30% Profit

* Donation on Furnicher 1,000/- 

Problem 2:-

* Mr.kumar started a new business with 6,00,000/-
* Flat purchases 2,50,000/-
* bike purchases 45,000/-
* Printer  purchases 12,000/- 

* Depreciation on Printer 1,200/-
* Depreciation on bike 12,000/-
* Printer was sold with 25% profit 
* Flat was sold with 100% profit 
* Office expediences 3000/- 

* Office income 8000/-

Problem 3:-

* Mr.Teja started a new business with 8,00,000/-
* Cash deposited in to SBI  60,000/-
* Car purchases 2,50,000/-
* Cell purchases through bank 14,000/-
* Furnisher purchases through bank 20,000/-
* Cash withdraw from bank 10,000/-
* Depreciation on cell 15,00/-
* Depreciation on Car 25,000/-
* Car was sold 40% Loss
* Cell was sold 9000/-

_________________________________________________________________________

>> Back to Ms-Office Notes
>> Back to C-Language Notes
>> Back to Computer Fundamentals Notes
__________________________________________________________________________
>>Back to Video Tutorials
>>Back to All Courses Quiz
>>Back to Abbreviations
>>Back to All Courses Shortcut Keys

__________________________________________________________________________