Nothing Special   »   [go: up one dir, main page]

Tally Problems

Download as pdf or txt
Download as pdf or txt
You are on page 1of 38

ACCOUNTS

ACCOUNTS:-
Accounts are three types
1.personal a/c
2.real a/c

TE
3.nominal a/c

U
IT
ST
1.personal a/c:- IN
Ex: persons,banks,firms etc
R
TE

Debit: debit is receiver


PU

Credit: credit is giver


M

2.real a/c:-
O
C

Assets,liabilities
D
SK

Assets:-
Assets are two typers
a.fixed assets
ex:- land,furniture,etc
b.current assets or variable assets
ex:- bills receivable,prepaid expenses, etc

1
liabilities:-
a.current liabilities:-
ex:- advance from customer, outstanding expenses, payble rent, etc
debit :- what comes in
credit:-what goes out

TE
3. nominal a/c:-

U
Profits , losses , income and expenses

IT
ST
Expenses:-
IN
Expenses are two types
R

a. Direct expenses
TE
PU

Ex: wages
M

b. Indirect expenses
O
C

Ex: salaries
D

Income:-
SK

Income are two types


a.direct income
b.indirect income
debit:- all losses and all expenses
credit:- all profits and all income

2
ENTRIES
1. Goods purchased
Goods purchase a/c to cash a/c
2. Computer purchases
Computer a/c to cash a/c
3. Purchase

TE
Purcashe a/c to cash a/c

U
4. Sales

IT
ST
Cash a/c to sales a/c
IN
5. Sold furniture
R

Cash a/c to furniture a/c


TE
PU

6. Sold goods
M

Cash a/c to sales a/c


O
C

7. Cash deposit form bank


D

Bank a/c to cash a/c


SK

8. Cash withdraw form bank


Cash a/c to bank a/c
9. Purchase goods form ravi
Purchase a/c to ravi a/c
10.purchase goods from ravi for cash
Purchase a/c to cash a/c
3
TALLY LEDGER & GROUP LIST
Accounts Name Groups
Accrued Income Current Assets
Accrued Rent/ Accrued Income Current Assets
Advertisement Expenses Indirect Expenses
Advertisement Payable Current Liabilities
Air Conditioner Fixed Assets
Apprentice Premium Direct Incomes
Audit Fees Indirect Expenses
Bad Debts Indirect Expenses

TE
Bad Debts Received Indirect Incomes
Bad Debts Reserve (last year Indirect Incomes

U
IT
balance)
Bank Bank Account

ST
Bank Balance Bank Account
IN
Bank Charges Indirect Expenses
Bank Commission Indirect Expenses
R
TE

Bank Loan Loans & Liabilities


Bank Overdraft Bank OD
PU

Bills Payable Current Liabilities


Bills Receivable Current Assets
M

Bombay Branch Branch & Division


O

Bonds Current Assets


C

Building Fixed Assets


D

Capital Capital Account


SK

Car Fixed Assets


Car Expenses Indirect Expenses
Car Repair Indirect Expenses
Carriage Direct Expenses
Carriage on Sales Indirect Expenses
Cash Cash in Hand
Cash at Bank Bank Account
Closing Stock Stock in Hand
Coal & Fuel Direct Expenses
Coal, Gas & Water of Factory Direct Expenses

5
Coffee Expenses Indirect Expenses
Coke Expenses Indirect Expenses
Commission (Cr.) / Commission Indirect Incomes
Received
Commission (Dr.) Indirect Expenses
Computer Fixed Assets
Consignment Stock Current Assets
Consumed Material Direct Expenses
Coolage Direct Expenses
Creditors Sundry Creditors
Debtors Sundry Debtors

TE
Deferred Expenses Current Assets
Deferred Income Current Liabilities

U
IT
Delhi Branch Branch & Division

ST
Depreciation Indirect Expenses
Depreciation Reserve Current Liabilities
IN
Difference in Trial Balance (Dr or Cr) Suspense Account
R

Discount (Cr.) / Discount Received Indirect Incomes


TE

Discount (Dr) / Discount Allowed Indirect Expenses


Donation Indirect Expenses
PU

Drawing Capital Account


Electricity Expenses Indirect Expenses
M

Expenses on Purchases Direct Expenses


O
C

Expenses on Sales Indirect Expenses


Export Duty Indirect Expenses
D

Factory Fixed Assets


SK

Factory Expenses (Lighting, Power Direct Expenses


etc.)
Factory Incomes Direct Incomes
Farm House Fixed Assets
FDR Current Assets
Fire Insurance Indirect Expenses
Fitting Charges Received Indirect Income
Forex Gain Loss Indirect Expenses
Freight Direct Expenses
Freight Inward Direct Expenses

6
Freight on Purchase (Freight Direct Expenses
Inward)
Freight on Sale (Freight Outward) Indirect Expenses
Freight Outward Indirect Expenses
Fuel & Power of Factory Direct Expenses
Furniture & Fitting Fixed Assets
Furniture & Fixture Fixed Assets
Gas and Water Direct Expenses
General Expenses Indirect Expenses
General Reserve Current Liabilities
Godown Rent Indirect Expenses

TE
Goods Sent on Consignment Sales Account
Goodwill Fixed Assets

U
IT
Horse & Carts Fixed Assets

ST
House Rent Capital Account
Hundi (Assets) Current Assets
IN
Hundi (Liability) Current Liabilities
R

Import Duty Direct Expenses


TE

Income From Repair Indirect Incomes


Income on Assets Indirect Incomes
PU

Income on Investments Indirect Incomes


Income Tax Capital Account
M

Input VAT 4%, 12.5% Duties & Taxes


O
C

Insurance Indirect Expenses


Insurance Claim Indirect Incomes
D

Insurance Company Sundry Debtors


SK

Interest (Dr.) Indirect Expenses


Interest on Capital Indirect Expenses
Interest on Drawing Indirect Incomes
Interest on Loan Indirect Expenses
Interest Received (Cr.) Indirect Incomes
Invest in Govt. Bond Investment
Investment Investment
Labour Charges Indirect Expenses
Land & Building Fixed Assets
Lease Hold Building Fixed Assets

7
Legal Expenses Indirect Expenses
LIC Premium (Dr) Capital Account
LIC Refund (Cr) Capital Account
Life Insurance Capital Account
Loan on Mortgage, Loans Loans & Liabilities
Loose Tools Fixed Assets
Loss By Damage Indirect Expenses
Loss by Fire Indirect Expenses
Loss in Transit Indirect Expenses
Loss on Assets Indirect Expenses
Loss on Joint Venture Indirect Expenses

TE
Machine & Tools Fixed Assets

U
Machine Repair Indirect Expenses

IT
Manager’s Commission Indirect Expenses

ST
Manufacturing Expenses Direct Expenses
Master Plus Investment
IN
Miscellaneous Expenses Indirect Expenses
R

Miscellaneous Income Indirect Incomes


TE

Motor Cycle Fixed Assets


Motor Cycle Repair Indirect Expenses
PU

Mutual Fund Investment


M

Octroi Direct Expenses


O

Office Expenses Indirect Expenses


C

Oil Direct Expenses


Opening Stock Stock in Hand
D
SK

Output VAT 4%, 12.5% Duties & Taxes


Outstanding Expenses Current Liabilities
Packing Exp. Indirect Expenses
Pan and Tea Expenses Indirect Expenses
Personal Expenses Capital Account
Petrol Expenses Indirect Expenses
Plant & Machine Fixed Assets
Postage & Telegram Indirect Expenses
Power & Fuel Direct Expenses
Prepaid Expenses Current Assets
Printing & Advertisement Indirect Expenses

8
Printing & Stationery Indirect Expenses
Printing, Papers & Advertisement Indirect Expenses
Production Wages Direct Expenses
Profit on Consignment Indirect Incomes
Profit on Jointventure Indirect Incomes
Provision for Bad Debts Indirect Expenses
Provision for Discount on Creditors Indirect Incomes
Provision for Discount on Debtors Indirect Expenses
Provision for Office Expenses Current Liabilities
Purchase Purchase Account
Purchase of New Land Fixed Assets

TE
Purchase of Raw Material Purchase Account

U
Purchase Return Purchase Account

IT
Purchase UP/ Ex-UP Purchase Account

ST
Railway Authority Sundry Debtors
Rates & Taxes Indirect Expenses
IN
Refreshment Expenses Indirect Expenses
R

Refrigerator Fixed Assets


TE

Rent Indirect Expenses


Rent & Tax Indirect Expenses
PU

Rent on Purchase Direct Expenses


M

Rent Payable Current Liabilities


O

Rent Received Indirect Incomes


C

Repair & Renovation Indirect Expenses


Repairing Charges Received Indirect Incomes
D
SK

Return Inward Sales Account


Return Outward Purchase Account
Salary Indirect Expenses
Salary & Wages Indirect Expenses
Salary Payable Current Liabilities
Sales Sales Account
Sales Return Sales Account
Sales UP/ Sales Ex-UP Sales Account
Scooter Fixed Assets
Shares / Bonds Investments
Shop Fixed Assets

9
Shop Expenses Indirect Expenses
Shop Rent Indirect Expenses
Showroom / Shop Fixed Assets
Showroom Repair Indirect Expenses
Stable Expenses Indirect Expenses
Stamp & Postage Indirect Expenses
Stationery Indirect Expenses
Stock (1st April and 31st March) Stock in Hand
Stock of Material Current Assets
Sundry Creditors Sundry Creditors
Sundry Debtors Sundry Debtors

TE
Tea Exp. Payable Current Liabilities

U
Tea or Coffee Expenses Indirect Expenses

IT
Telephone Expenses Indirect Expenses

ST
Telephone Securities Indirect Expenses
Trade Expenses Indirect Expenses
IN
Train Freight & Rent Direct Expenses
R

Travelling Expenses Indirect Expenses


TE

Typewriter Fixed Assets


Unearned Income Current Liabilities
PU

UPTT Duties & Taxes


M

VAT Payable Current Liabilities


O

Vehicle Repair Indirect Expenses


C

Wages Direct Expenses


Wages on Production Direct Expenses
D
SK

10
Basic accounting problem
Problem 1:-

* Mr. surya started a new business with -- 5,00,000/-


* mechinery Purchased -- 50,000/-
* Computer Purchased -- 15,000/-
* Rent paid -- 15,000/-
*Internet bill paid -- 500/-
* Fees received -- 10,000/-
* Donation received -- 20,000/-
* Printer Purchased -- 6,000/-

TE
Problem 2:-

U
* Mr. teja started a new business with -- 3,00,000/-

IT
* Books Purchased -- 5,000/-
* Stationary Purchased -- 1,500/-

ST
* Salary paid -- 7,000/-
*Rent received -- 12,000/-
IN
* Commission received -- 6,000/-
* Interest received -- 2,000/-
R

* Power bill paid -- 1,250/-


TE

* Water bill paid -- 350/-


* Petty Income -- 1600/-
PU
M
O
C
D
SK

11
Deposit and with draw in tally
Problem 1:-

* Mr. Raju Started a new business with -- 2,50,000/-


* Cash Deposited into SBI --35,000/-
* Vehicle Purchased -- 72,000/-
* Computer Purchased through bank -- 15,000/-
* Cash Withdraw from SBI -- 10,000/-
* Rent Received -- 15,000/-
* Cash Deposited into SBI -- 20,000/-

TE
* Power bill paid through bank -- 1,520/-
* Net bill paid -- 600/-

U
* Commission received through bank -- 8000/-

IT
ST
Problem 2:-
IN
* Miss. bhavani started a new business with -- 6,00,000/-
R
* Cash deposited in to Andhra bank --1,00,000/-
TE

* Scooter purchased -- 35,000/-


* Computer purchased --17,000/-
PU

* Petty expediences through bank -- 5,000/-


* Cash withdraw from Andhra bank -- 40,000/-
M

* Donation received through bank --18,000/-


O

* Salary paid through bank-- 2,000/-


C

* Computer was sold -- 60,000/-


D

* Petty income -- 5,000/-


SK

* Petty income through bank -- 3,000/-

Problem 3:-

* Mr. Prasad started a new business with 2,00,000/-


* Cash deposited in to Andhra bank --10,000/-
* Cash deposited in to HDFC bank -- 35,000/-
* Cash withdraw from Andhra bank --30,000/-
* Cash withdraw from HDFC bank --15,000/-
* Cash withdraw from Andhra bank --10,000/-
* Cash deposited in to HDFC bank --28,000/-
* Cash deposited in to Andhra bank-- 20,000/-

* Cash withdraw from HDFC bank -- 10,000/- 13


* Cash withdraw from Andhra bank -- 5,000/-
Bank to bank transctions in tally
Problem 1:-

* Mr. harsha Started a new business with a 4,00,000/-


* Cash deposited into SBI 2,00,000/-
* Cash deposited into HDFC 1,00,000/-
* Cash deposited into Andhra bank 1,00,000/-
* Furnicher purchased through SBI 25,000/-
* Travelling expns 800/-
* HDFC bank to SBI bank 15,000/-
* Andhra bank to HDFC bank 42,000/-

TE
* Donation recived through HDFC bank 10,000/-
* SBI bank to HDFC bank 15,500/-

U
IT
* Andhra bank to SBI bank 23,500/-
* Cash withdraw to Andhra bank 33,000/-

ST
Problem 2:-
IN
R

* Mr. Srikanth Started a new business with a 6,00,000/-


TE

* Cash deposited into Union bank 1,50,000/-


* Cash deposited into SBI 1,00,000/-
PU

* Cash deposited into Canara bank 1,75,000/-


M

* Salary received through SBI bank 15,000/-


O

* Canara bank to SBI bank 25,000/-


C

* Canara bank to Union bank 15,000/-


* SBI bank to Union bank 35,000/-
D

* Computer purchased through Union bank 25,000/-


SK

* Cash deposited into Canara bank 1,00,000/-


* Cash withdraw to Union bank 23,000/-
* Union bank to Canara bank 10,000/-
* Petty Income through SBI bank 1,250/-
* Travelling expns 1,800/-
* Cash deposited into Union bank 12,000/-

15
Partner ships
Ex1:-

Raju and rani


Net profit 50,000/-

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


to -- raju --- 25,000/-
to -- rani --- 25,000/-

F5 - by--cash

TE
to--raju -- 10,000/-

U
IT
F5 - by--cash
to--rani -- 10,000/-

ST
Ex2:-
IN
R

Bhavani and Nandini Loss 50,000/-


TE

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


PU

to -- Bhavani --- 25,000/-


M

to -- Nandini --- 25,000/-


O
C

F6 - by --cash
to --Bhavani -- 25,000/-
D
SK

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

16
Partner ships
Problem 1:-

1. Mr.Raju 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/-

TE
8. Petty expediences 2,000/-
9. Petty income 4,000/-

U
10.Power bill paid 950/-

IT
ST
Problem 2:-
IN
1. Miss.Bhavani and Miss.Nandini invested 6,00,000 (Miss.Bhavani Inv: 30%
,Miss.Nandini Inv: 70%)
R

2. Furnicher purchases 15,000/-


TE

3. Rent Paid 25,000/-


4. Interest Paid 10,000/-
PU

5. Donation Paid 35,000/-


M

6. Furnicher was sold 5,000/-


7. Office expediences 22,000/-
O

8. Travelling expediences 5,000/-


C

9. Petty income 2,500/-


D

10.Net bill paid 1,950/-


SK

17
Inventory management
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........

TE
Stock items:-
In this option we have to specify items information.

U
IT
Steps for crarte measurement:-

ST
1. Goto inventory info IN
2. Goto Unit of Measure
3. Goto Crete Option
R

4. Type the Sets


TE

5. Enter.
PU

Steps for create items:-


M

1. Goto inventory info


O

2. Goto stock items


C

3. Goto create(multiple stock items)


4. Name of the item = color tv's
D

units = sets
SK

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/-

18
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:-

TE
a. Rice 25 Bags each one 1050/-

U
b. Oil 20 Cans each one 2600/-

IT
c. Sugar 35 Bags each one 2350/-
d. Lux Soaps 50 Pisces each one 40/-

ST
6. Cash withdraw from SBI 17,000/- IN
7. Cash Transfer to Andhra Bank to SBI 35,000/-
8. Sales as fallows through Andhra Bank:-
R

a. Rice 15 Bags each one 1500/-


TE

b. Oil 14 Cans each one 3200/-


PU

c. Lux Soaps 30 Pisces each one 55/-


d. Sugar 25 Bags each one 3100/-
M

9. SBI Cheque Issued to Kumar 10,000/- (Cheque No:170589)


O

10. Sales as fallows:-


C

a. Rice 10 Bags each one 1250/-


b. Oil 5 Cans each one 2900/-
D

c. Sugar 7 Bags each one 2700/-


SK

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/-

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/-
19
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/-

TE
b. Oil 5 Cans each one 2900/-

U
c. Sugar 7 Bags each one 2700/-

IT
d. Lux Soaps 20 Pisces each one 47/-
11.Cash Transfer to SBI to Andhra Bank 13,000/-

ST
12.Cash Received from Kumar through SBI 10,000/-IN
R
TE
PU
M
O
C
D
SK

20
Purchase returns/sales returns
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

TE
U
Go to accounting vouchers

IT
Press F11
Press F2

ST
Use debit/credit note -- Yes IN
Use invoice mode for credit note -- Yes
Use invoice mode for debit note -- Yes
R
TE

Problem 1:-
PU

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


M

2. Purchase as Fallows:-
O

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


C

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


D

iii) Headphones - 35 Sets Each one 170/-


SK

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

21
cash discount in tally
Discount can be also referred to as a deduction in price. The seller deducts the discount from
the gross or total price, and the buyer is supposed to pay the net amount.

Types of Discounts
The two kinds or types of discounts are
1.Cash Discount
2.Trade Discount

1.Cash Discount:-

TE
U
Cash discount is an allowance or concession given by the seller to the buyer. This discount is

IT
offered to encourage the buyer for quick payment or settlement. It is allowed for immediate

ST
payment of cash or payment within a short period.
IN
Note:-
To perform the concept we have to perform fallowing setting's
R

Go to accounting vouchers
TE

Press F11
PU

Press F2
M

Separate discount on coloum invoice = Yes.


O
C

PROBLEM 1:-
D
SK

1. Mr. Srinivas started a Mobile business with 4,00,000/-


2. Cash deposited into SBI 50,000/-
3. Furnisher purchased 15,000/-
4. Purchase as follows:-
a. Samsung mobiles – 15 sets @ 7000/- cash discount 12%
b. Lenovo mobiles – 10 sets @ 5500/- cash discount 15%
c. Nokia Lumia mobiles – 5 sets @ 6000/- cash discount 25%
5. Cash with draw from SBI 30,000/-
6. Sales as follows:-
a. Samsung mobiles – 15 sets @ 12,000/- cash discount 10%
b. Lenovo mobiles – 10 sets @ 9,000/- cash discount 20%
c. Nokia Lumia mobiles – 5 sets @ 11,000/- cash discount 30%

22
7. Sales returns:-
a. Lenovo mobiles – 2 sets cash discount 20%
b. Nokia Lumia mobiles – 1 set cash discount 30%
8. Purchase returns:-
a. Lenovo mobiles – 2 sets cash discount 15%
b. Nokia Lumia mobiles – 1 set cash discount 25%

PROBLEM 2:-
1. Mr. Prakash started a Furnicher business with 10,00,000/-
2. Cash deposited into Andhra Bank 50,000/-

TE
3. Rent paid through bank 15,000/-

U
4. Purchase as follows:-

IT
a. Double cots – 10 no’s @ 25,000 cash discount 5.3%

ST
b. Dining Tables – 15 sets @ 40,000/- cash discount 2.5%
c. Divan cots – 10 sets @ 12,000/- cash discount 8%
IN
d. Dressing tables -20 sets @ 10,000/- cash discount 4.5%
5. Sales as follows:-
R

a. Double cots – 7 no’s @ 34,000 cash discount 2.7%


TE

b. Dining Tables – 11 sets @ 48,000/- cash discount 5.5%


PU

c. Divan cots – 5 sets @ 20,000/- cash discount 6.2%


d. Dressing tables -15 sets @ 18,000/- cash discount 3.5%
M

6. Sales returns:-
O

a. Dining Tables – 2 sets cash discount 5.5%


C

b. Dressing tables -1 set cash discount 3.5%


D

7. Purchase returns:-
SK

a. Dining Tables – 2 sets


b. Dressing tables -1 set

23
Trade or credit discount in tally
Trade or Credit Discount:-

Trade Discount is a reduction in the catalogue price of the goods allowed only if the quantity
ordered by the buyer is quite large. Its purpose is to encourage the buyer to make bulk
purchases. It is allowed on cash as well as credit sales.
The trade discount is not shown in the books of account. The trade discount is calculated as
some percentage of the catalogue price. It varies according to the quantity of order.

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

TE
U
IT
Go to accounting vouchers

ST
Press F11
Press F2 IN
R

Use accounting bill country


TE

= Yes.
PU
M
O

PROBLEM 1:-
C
D

1. Mr.Raju Started a New bussiness with 7,00,000/-


SK

2. Rent Paid Through Bank 20,000/-


3. Cash Deposited into HDFC bank 1,00,000/-
4. Purchase as fallows:-
a.Computers 20 Sets @ 15,000/- Bill Counted 17 Sets
b.Laptop's 15 Sets @ 23,000/- Cash Discount 5.7 %
c.Ext Hard Disks 30 Sets @ 4,000/- Bill Counted 25 Sets
5.Purchase as fallow's from Reventh Traders:-
a.Laptop's 10 Sets @ 20,000/- Bill Counted 9 Sets
b.Ext Hard Disks 5 Sets @ 3,500/- Cash Discount 10.7 %
6.Sales as fallow's Through Bank:-
a.Computers 15 Sets @ 21,000/- Bill Counted 14 Sets
b.Laptop's 15 Sets @ 40,000/- Bill Counted 12 Sets

24
c.Ext Hard Disks 20 Sets @ 7,000/- Bill Counted 18 Sets
d.Ext Hard Disks 10 Sets @ 6,200/- Cash Discount 3.5 %
7.Sales as fallow's to Raja Traders:-
a.Laptop's 10 Sets @ 35,000/- Bill Counted 8 Sets
b.Ext Hard Disks 5 Sets @ 6,500/- Bill Counted 4 Sets
8. Cash Withdraw from HDFC bank 75,000/-
9. Cash Paid to Reventh Traders
10. Cash From Raja Traders

PROBLEM 2:-

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

U
2.Internet bill paid 1,200/-

IT
3.cash deposited into SBI bank 1,50,000/-

ST
4.Purchase as follows:-
a) Mine labtop's 10 sets eachone 12,000/- discounted 4% from A1 traders
IN
b) labtops 20 sets each one 14,000/- discounted 4.5% from A2 traders
c) Samsung mobiles 20 sets each one 2,100/- discounted 6% from A3 traders
R

d) Nokia mobiles 10 sets each one 4,000/- discounted 3%


TE

e) Carbon mobiles 10 sets each one 5,500/- discounted 10%


PU

f) Micromax mobiles 10 sets each one 9000/- discounted 7%


g) Lava mobiles 10 sets each one 2900/- discount 1.5%
M

5.Sales as fallows:-
O

a) Mine labtop's 5 sets eachone 16,500/- discounted 2% from B1 traders


C

b) Mine labtop's 5 sets each one 18,000/- discounted 3% from through SBI bank
D

c) Laptop's 20 sets each one 38,000/- bill counted 19 sets


SK

d) Samsung mobiles 20 sets each one 65 ,000/- discounted 6%


e) Nokia mobiles 10 sets each one 15,000/-
f) Carbon mobiles 10 sets each one 13,000/- discounted 5%
g) Lava mobiles 10 sets each one 4900/- discount 6.5%

6. Sales return:
a) Samsung mobiles 1 set
7. Purchases return:
b) Samsung mobiles 1 set
8. cash paid to A1 traders
9. cash paid to A2 traders
10.cash paid to A3 traders
11.cash from B1 traders
25
Purchase order
A purchase order sets forth the descriptions, quantities, prices, discounts, payment terms, date
of performance or shipment, other associated terms and conditions, and identifies a specific
seller. Also called order.

Purchase order (Alt+F4):-


Setting:-
Go to accounting vouchers
Press F11 key

TE
Press F2 key
Allow purchases order processing = yes

U
IT
Ledger:-

ST
Purchases order ---- Purchases accounts
IN
PROBLEM 1:-
R
TE

1. Miss jyothi started a new business with 3,00,000/-


PU

2. Purchase order given to Rupa Traders with Order No:325 - It contain fallowing stock items
a. CRT Monitors 10 no’s Each one 3000/-
M

b. LCD Monitors 15 no’s Each one 4500/- discount 4.5%


O

c. LED Monitors 25 no’s Each one 6000/-


C
D

3. Goods Received from Rupa Traders with Order No: 325


SK

4. Purchase order given to Vijaya Traders with Order No:907 -It contain fallowing stock items
a. Keyboards 10 no’s Each one 300/- bill counted 9 no’s
b. Mouses 20 no’s Each one 150/- discount 2%

5. Goods Received from Vijaya Traders with Order No: 907

6. Cash Paid to Rupa Traders


7. Cash Paid to Viajaya Traders

8. Sales as follows:-
a. CRT Monitors 10 no’s Each one 4200/- discount 1.5%

26
b. LCD Monitors 15 no’s Each one 5600/- bill counted 14 no’s
c. LED Monitors 25 no’s Each one 8500/-
d. Keyboards 10 no’s Each one 550/- bill counted 8 no’s
e. Mouses 20 no’s Each one 220/- discount 3%

PROBLEM 2:-
1. Mr.Deva started a new business with 2,00,000/-
2. Purchases order to kumar trader with order no: 123 the fallowing items
a) B.p.l color tv’s 10 sets each one 3,000/-
b) L.g color tv’s 10 sets each one 5,000/-
c) Onida color tv’s 10 sets each one 5,500/-

TE
U
3. Purchases order to sampanth trader with order no: 120 the fallowing items

IT
a) Lap top’s 50 sets each one 20,000/-

ST
b) Sony mobiles 50 sets each one 5,000/-
IN
4. Items received to kumar trader order no 123
5 Items received to sampanth trader order no 120.
R
TE

6. Cash paid to kumar trader.


PU

7. Cash paid to sampanth trader.


M

8. Sales as fallows:-
O

a) B.p.l color tv’s 10 sets each one 6000/-


C

b) L.g color tv’s 16 sets each one 7500/-


c) Onida color tv’s 10 sets each one 11,000/-
D
SK

d) Sony color tv’s 10 sets each one 6,000/-


e) Laptop’s 40 sets each one 10,000/-

27
Sales order
The sales order, sometimes abbreviated as SO, is an order issued by a business or sole trader to
a customer. A sales order may be for products and/or services. Given the wide variety of
businesses, this means that the orders can be fulfilled in several ways.

Sales order (Alt+F5):-

Setting:-
Go to accounting vouchers

TE
Press F11 key
Press F2 key

U
IT
Allow Sales order processing = yes

ST
Ledger:- IN
Sales order ---- Sales accounts
R
TE

PROBLEM 1:-
PU
M
O
C

1. Mr.Ganesh started a new small business with 50,000/-


2. Purchase order given to Anand Traders with Order No:301 - It contain fallowing stock items
D

a. Liril soaps 10 Peaces Each one 150/- discount 2.5%


SK

b. Lux soaps 20 Peaces Each one 200/- bill counted 18 Peaces


c. Dove soaps 15 Peaces Each one 170/- discount 2.5%
d. Santhoor soaps 10 Peaces Each one 130/- bill counted 9 Peaces
e. Pears soaps 25 Peaces Each one 220/- discount 3.2%
3. Received goods from Anand Traders Order No: 301.
4. Sales order received to Sindhu Traders with Order No:205 - It contain fallowing stock items
a. Liril soaps 8 Peaces Each one 200/- bill counted 7 Peaces
b. Lux soaps 18 Peaces Each one 230/- discount 1.7%
c. Dove soaps 10 Peaces Each one 210/- bill counted 9 Peaces
d. Santhoor soaps 6 Peaces Each one 160/-
e. Pears soaps 20 Peaces Each one 250/- discount 3.1%
5. Goods given to Sindhu Traders Order No:205

28
6. Cash Paid to Anand Traders
7. Cash From Sindhu Traders.

PROBLEM 2:-
1. Miss.swathi started a new business 1, 00,000/-

2. Purchase order given to A1 trader with Order no 108. it contains the fallowing items.
a) Lcd monitors 10 sets each one 2,000/-
b) Dvd players 10 sets each one 1500/-
3. Purchase order given to Big-c with Order no 102. it contain the fallowing items

TE
a) Micro max mobiles 10 sets each one 600/-

U
b) Corbon mobiles 10 sets each one 1200/-

IT
4. Goods received from A1 trader with order no 108.

ST
5. Goods received from Big – c with order no 102.
6. Cash paid to A1 traders. IN
7. Cash paid to Big-c traders.
8. Sales as fallows:
R

a) Lcd monitors 10 sets each one 4000/-


TE

b) Dvd players 10 sets each one 3900/-


PU

9.sales order received from prasad traders with order no 104 it contain the fallowing
a) Carbon mobiles 10 sets each one 6000/-
M

b) Micro max 10 sets 2000/-


O

10. Stock delivered to Prasad traders with order no:104


C

11. Cash from prasad traders.


D
SK

29
Godowns management
Basically every business organization maintains necessary Godowns. To implement this
concept we have to perform the fallowing settings.

Setting’s:-
· Go to accounting vochoures
· Press F11 key
· Press F2 key
· Allow multiple Godowns -- Yes

After Setting:-
· Go to inventory info

TE
· Select the Godowns

U
· Select the multiple option

IT
· Type the Godowns name

ST
· Enter
IN
Ledger:-
Ex:-
R

Autonagar --- Sundry creditor


TE
PU

Alt + F7:-
If you want to shift be stock from specified Godowns to Main Location. Here we can Use
M

Keyword Alt + F7.


O
C

Problem 1:-
D
SK

1. Mr.Ramana Started a new bussiness with 10,00,000/-


2. Purchase LED Tv's 10 Sets Each one 12,000/-
3. Above Stock Under Autonagar Godown.
4. Purchase Aircondition's (A/C's) 10 Sets Each one 40,000/-
5. Above Stock Under Ganesh Godown.
6. 10 Sets LED Tv's Transfer to Main Location
7. 5 Sets Aircondtions (A/C's) Transfer to Main Location
8. Sales as fallows:-
a. LED Tv's 8 Sets Each one 20,000/-
b. Aircondition's (A/C's) 3 Sets Each one 55,000/-
c. Aircondition's (A/C's) 4 Sets Each one 51,000/- from Ganesh Godown.

30
Problem 2:-
1. Mr.Kumar started a new business 3,00,000/- He is having two Godown’s A1 and A2
godown’s

2. Purchases as fallow's:
a) Lcd monitors 20 sets each one 6000/-
b) Laptop’s 20 sets each one 3500/-
The above stock under A1 Godown

3. Purchases as fallowes:
a) Furnicher’s 10 sets each one 7000/-

TE
b) Computer 20 sets each one 10,000/-

U
The above stock under A2 Godown

IT
ST
4. A1 Godown stock transfer to main location
5. A2 Godown stock transfer to main location IN
6. Sales as fallows:
R

a) Lcd monitors 20 sets each one 12,000/-


TE

b) Laptop’s 20 sets each one 20,000/-


PU

c) Computers 20 sets each one 7,000/-


d) Furnicher 10 sets 20,000/-
M
O
C
D
SK

31
multi currency
Basically we are performing accounting operations in the format of Indian currency only.
Some times NRI persons invert amount in the format of Non-Indian currency means. We note
to convert capital amount in to Indian currency format.to perform this concept we have to
specify Necessary setting's.

Setting:-1
1. Go to accounting vochoures
2. Press F11 key
3. Press F1 key
4. Allow multi currency = Yes

TE
Setting :-2

U
1. Go to account info

IT
2. Go to currency’s

ST
3. Go to create
4. Create currency
IN symbol($)
Currency name (dollar)
R

Enter
TE
PU

5. Press Esc button


M

6. Goto rates of exchange and enter exchange value.


O

$ --- 67 ---- 67 --- 67


C
D
SK

32
Problem 1

1. Ajay (USA), Sekhar (Itali), Dinesh (London) Invested 750 $(Dollars),830 Euros,500
Pounds invested our Country.
1$(Dollar) =67 Rs/-
1E(Euro) =71 Rs/-
1P(Pound) =84 Rs/-
2. Cash Deposited into SBI 150 Pounds
3. Furnicher Purchased 13,000 Rs/-

TE
4. Donation Received 170 Dollars
5. Power bill paid 5 Euros

U
IT
6. Office Expns 230 Pounds
7. Salary Paid 90 Euros

ST
8. Cash with draw from bank 10,000 Rs/- IN
9. Cash paid to Wipro Ltd 190 Dollars
10.Commission Received 120 Euros
R

11.Cash Received from Wipro Ltd 50% Dollars


TE

Problem 2
PU

1. Avinash (USA), Sravani (Japan), Manoj (London) Invested 470 $(Dollars),80,000 Yens,900
M

Pounds invested our Country.


O

1$(Dollar) =67 Rs/-


C

1Y(Yen) =1 Rupee.68 Paisa /-


D

1P(Pound) =84 Rs/-


SK

2. Cash Deposited into Andhra Bank 18,000 Yens


3. Mobile Purchased 25,000 Rs/-
4. Inteast Received 270 Dollars
5. Internet bill paid 600 Yens
6. Office Income 230 Pounds
7. Salary Paid 90 Dollars
8. Cash with draw from bank 10,000 Yens
9. Cash paid to Prakasah 15,000 Rs/-
10.Commission Received 1200 Yens
11.Cash Received from Prakash 70% Yens

33
Multi price levels
In this concept we can implement various types of selling prices to perform this concept we
can fallowing settings.

Setting:-1
1. Go to accounting vochoures
2. Press F11 key
3. Press F2 key
4. Allow Multiple Price Levels = Yes
Dealer Price - Enter
Wholesale Price - Enter
Retailer Price - Enter
Customer Price - Enter
5. Enter

TE
Basically the selling price levels are classified into 4 categories:

U
* Dealer Price

IT
* Wholesale Price
* Retailer Price

ST
* Customer Price IN
R
TE
PU
M
O
C
D
SK

34
Problem 1
1. Mr.Naveen started a new business with 5,00,000/-
2. Cash Deposited into Andhra Bank 1,50,000/-
3. Furnicher Purchased 25,000/-
4. Salary Paid 15,000/- through bank
5. Depreciation on F urnicher 4,000/-
6. Purchase as fallows:-
a) Nokia Mobiles 10 Sets Each one 6,000/ -
b) Lava Mobiles 20 Sets Each one 3,500/-
c) Samsung Mobiles 15 Sets Each one 5,000/-
d) Lenovo Mobiles 25 Sets Each one 4,500/-

7. Sales as fallows:-
a) Nokia Mobiles 5 Sets Each one 7,500/ - Dealer Price
b) Samsung Mobiles 2 Sets Each one 9,000/ Retailer Price
-

c) Lenovo Mobiles 10 Sets Each one 5,000/- Dealer Price

TE
d) Lava Mobiles 10 Sets Each one 5,500/- Wholesale P rice

U
e) Nokia Mobiles 2 Sets Each one 9,200/- Customer Price
f) Lenovo Mobiles 8 Sets Each one 6,500/- Wholesale Price

IT
g) Samsung Mobiles 6 Sets Each one 8,000/- Wholesale Price
ST
h) Lava Mobiles 5 Sets Each one 4,200/- Dealer Price
i) Lava Mobiles 2 Sets Each one 6,300/- Retailer Price
IN
j) Nokia Mobiles 2 Sets Each one 8,400/- Wholesale Price
k) Samsung Mobiles 5 Sets Each one 6,500/- Dealer Price
R
TE

l) Lenovo Mobiles 4 Sets Each one 7,500/- Customer Price


m) Samsung Mobiles 2 Sets Each one 9,800/ - Customer Price
PU

n) Lenovo Mobiles 2 Sets Each one 7,000/ Retailer Price


-

o) Lava Mobiles 2 Sets Each one 6,900/ Customer Price


-
M

8. Commission Received through bank 17,000/ -


O
C
D
SK
Problem 2
1. Mr.Prakash started a new business with 1,50,000/-
2. Cash Deposited into SBI 10,000/-
3. Mobile Purchased Through Bank 5,500/-

TE
4. Rent Paid 12,000/- through bank
5. Cash With Draw from SBI 4,000/-

U
6. Purchase as fallows:-

IT
a) Pendrives 30 Pisces Each one 200/-

ST
b) Memory Cards 50 Pisces Each one 150/- IN
c) Routers 35 Pisces Each one 700/-
7. Sales as fallows:-
R

a) Pendrives 10 Pisces Each one 250/- Dealer Price


TE

b) Memory Cards 20 Pisces Each one 400/- Retailer Price


c) Routers 15 Pisces Each one 800/- Dealer Price
PU

d) Routers 10 Pisces Each one 950/- Wholesale Price


M

e) Pendrives 5 Pisces Each one 450/- Customer Price


O

f) Memory Cards 10 Pisces Each one 320/- Wholesale Price


C

g) Memory Cards 5 Pisces Each one 200/- Dealer Price


h) Routers 5 Pisces Each one 1,200/- Customer Price
D

i) Pendrives 5 Pisces Each one 350/- Retailer Price


SK

8. Petty Income 1,700/-


9. Travelling Expenses 250/-
10. Cash Deposited into SBI 5,000/-

35
Last year trading account details
Note 1:-
Last Year Stock items entry to single (with money & sets)

Note 2:-

Last Year Accounts (Fixed assets, Expenses,Incomes, Sundry Creditor & Debitor, Bank
A/c's) Entry to Ledger Name & Under Group with Values.

Ex:- SBI - Bank Account - 50,000.


Problem 1

TE
April – 2015 to March - 2016

U
1. Mr.Kumar Capital a/c 3,00,000/-

IT
2. Tulasi & co 24,000/-
3. Nagesh & co 30,000/-

ST
4. SBI bank 46,000/-
5. Furnicher 50,000/-
IN
6. Cash 1,60,000/-
7. Stock : LED tv’s 5 sets each one 10,000/-
R
TE

April – 2016 to March – 2017


1. Salary Paid 12,000
PU

2. Purchase LED Tv’s 30 sets Each 10,000/- From Nagesh & Co.
3. Sold LED Tv’s 20 sets Each 12,000/- to Tulasi & Co
M

4. Sold LED Tv’s 13 sets Each 13,500/- to Tulasi & Co


O

5. Cash From Tulasi & Co.


C

6. Cash Paid to Nagesh & Co.


7. Rent Paid 10,000/- Through Bank.
D
SK

Problem 2

April – 2015 to March - 2016

36
1. Mr.Ramesh Capital a/c 5,00,000/-
2. Ganesh Traders 45,000/-
3. Rajesh & co 30,000/-
4. Canara bank 46,000/-
5. Computer 25,000/-
6. Cash 2,30,000/-
7. Stock : Samsung Mobiles 8 sets each one 9,000/-

April – 2016 to March – 2017


1. Cash With draw from Bank 15,000/-
2. Purchase Samsung Mobiles 20 sets Each 9,000/- From Ganesh
Traders
3. Sold Samsung Mobiles 12 sets Each 11,000/- to Rajesh & Co

TE
4. Sold Samsung Mobiles 10 sets Each 12,500/- to Rajesh & Co
5. Cash From Rajesh & Co.

U
6. Cash Paid to Ganesh Traders.

IT
7. Salary Paid 15,000/- Through Bank.

ST
IN
R
TE
PU
M
O
C
D
SK

37
Payroll:-

Easily Prepare Pay slip and Payroll report in Tally


Press F11 (Company Feature) > Accounting Features (F1) > Set both given
options “Yes”

Maintain Payroll >Yes


More than one Payroll / Cost Category > Yes
Now Save the information.

TE
If you Want to maintain Employee Contact detail, Passport & visa detail then you
have to Press F12 (Configuration)-> Payroll Configuration -> here Some option to

U
related to employee. According to company you turn on and off the options.

IT
ST
1. UNITS CREATION –
GOT – > Payroll Info –> Unit –> Create –>
IN
Normally Two types of unit creation in case of payroll.
A. Simple unit – e.g. Month, days, hour etc.
R

B. Compound Units – Combination of two simple units. E.g.


TE

Month – of ……Days (Give the total days of working)


Days – of ……..Hour (Give the total working hour in a day).
PU
M

2. ATTENDANCE/ PRODUCTION TYPES –


GOT –> Payroll Info –> Attendance / Production Type –> Create.
O

e.g. Casual leave – Attendance/ leave with pay


C

Absent – Leave Without pay.


D

Overtime – Production.
SK

3. CREATIONS OF PAY HEADS –


(A) Basic salary
Pay head type – Earning for employee.
Under – Indirect expenses
Appear in pay slip- yes
Name of appear in pay slip – According to you.
Used For gratuity – If you want to maintain gratuity then yes other wise no.
always remember this feature only yes for employee earning total.
Calculate Type – select Flat rate or user defines value (normally).

38
(B) DA
Calculate Type – select As Computed value (da is normally calculate on basic of
employee.

(C) Same Create HRA or other earning total.

(D) PF
Pay head type – Deduction from employees.
Under – Current liabilities
Used For gratuity – No (It just yes on earning total).
Calculate Type – According to company.

TE
(E) ABSENT
Pay head type – deduction from employees.

U
Under – current assets

IT
(Select here attendance type with calculate period. E.g. Days)

(F) OVERTIME
ST
IN
Pay head type – earning for employee
Under – indirect expenses
R

(Select here overtime type)


TE

(G) Gratuity (If you want to maintain)


Pay head Type – Gratuity
PU

(Fill the Gratuity day according to Income tax act)


Under – current liabilities.
M
O

4. CREATIONS OF EMPLOYEE GROUP –


C

GOT – > Payroll info –> Employee group –> Create . e.g. Accounts dept.
D
SK

5. CREATIONS OF EMPLOYEE –
GOT –> Payroll Info –> Employee –> Create
(Select here to group which belong employee)

6. SALARY DETAIL MAINTAIN –


GOT –> Payroll Info –> Salary Detail –> Create
NOTE – If you create salary for a particular group then all the employee who is
working under the group apply group salary detail.
But if you want to fill up fresh salary detail then select employee & fill up the
detail under Start a fresh.

39
7. CREATE A VOUCHER TYPE.
Name Of voucher – Anything which you want
Type of voucher – Payroll –
Name of class – which you want
Select here Cash Or Bank a/c if you directly pay the salary without due. But if you
want to pass out due first then select salary payable Pay head, (Not Applicable
Category).

8. ATTENDANCE VOUCHER –
GO in the vouchers –> Press Ctrl + F5 (Fill the attendance of employee)
9. PAYROLL VOUCHER CREATION –
Go in the vouchers –> press CTRL + F4 (Select salary payable voucher type.
Again PressALT + A (For calculate salary Automatic).

TE
10. TO VIEW OR PRINT REPORT –> GOT –> Display –> Payroll Report –>
Statement of Payroll – >Pay slip (Or see the other report).

U
IT
NOTE – If you are selecting salary payable pay head in creation of voucher type

ST
then one more entry to pass in payment voucher.
IN
Salary payable a/c……………Dr
R

To cash/Bank
TE
PU
M
O
C
D
SK

40

You might also like