Tally Practical Question 4c3e6v
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report 2z6p3t
Overview 5o1f4z
& View Tally Practical Question as PDF for free.
More details 6z3438
- Words: 3,651
- Pages: 18
(1)NAME
UNDER NAME
DR
Capital
Capital
Cash In Hand
Cash In Hand
Building
Fixed Asset
Stock
Stock In Hand
47000
Sundry Debtors
Sundry Debtors
50000
Commission Paid
Indirect Expenses
100
Rent & Taxes
Indirect Expenses
3500
Purchases
Purchases
CR
Creditors
Creditors
24000
Travelling Expness
Indirect Expenses
2000
TOTAL
2201 00
900 2500
Result :Gateway of tally-DisplayTrailbalance(Alt+F1)
(2)NAME
UNDER NAME
Drawings
Capital
Goodwill
Current Assets
Building
Fixed Assets
Machinery Bills Receivable
Fixed Assets Current Assets
Opening Stock
Stock In Hand
Purchases
Purchase
70800
Purchase Return
Purcahase
Furniture
Fixed Asset
Loan To Suba
Loans Liability
Discount Allowed
Indirect Expenses
4600
Drawings
Capital
6000
Bills Receivable
Current Assets
5200
Cash At Bank
Bank
2201 00
1100 4500 10000
12500 12800 0
Sales
Sales
Sales Return
Sales
1000
Salaries
Indirect Expenses
9500
Discount Earned
Indirect Income
4000
Bank Overdraft
Bank O/D
6000
Bills Payable
Current Liability
4000
Sundrry
Sundry
43000
Wages Direct Expenses Carriage Outward Indirect Expenses Carriage Inward Direct Expenses Salaries Rent Discount Repairs
Indirect Expenses Indirect Expenses Indirect Expenses Direct Expenses
Bank Cash Debtors
Bank Cash In Hand Sundry Debtors
DR 4500 0 9000 0 6000 0 4000 0 6000 4000 0 5100 0 2600 0 500 1000 3500 0 3000 1100 2300 2500 0 1600 4500
CR
Bad Debtors Sales Return Furniture Advertising Gneral Expenses
Indirect Expenses Sales Fixed Assets Indirect Expenses
0 1200 2000 6000 3500
Indirect Expenses
450
Capital
Capital
Bills Payable
Current Liablility
Creditors Purchase Return
Sundry Creditors
Sales
Sales
Purchase 4856 50
TOTAL Result :Gateway of tally-DisplayTrailbalance(Alt+F1)
(3)NAME
UNDER NAME
DR
Land And Building
Fixed Assets
42000
Machinery
Fixed Assets
20000
Purchase
Purchase
7500
1.4.2009 Stock
Stock In Hand
5760
Sundry Debtors
Sundry Debtors
14500
Patents
Current Assets
40675
CR
Cash In Hand
Cash In Hand
Cash At Bank
Bank
2630
Return Inwards
Sales
680
Wages
Direct Expenses
8480
1600 00 3500 0 7000 0
Fuel & Power
Direct Expenses
4730
Carriage On Sales
Indirect Expenses
3200
Carrage On Purchase
Direct Expenses
2040
2650 2180 00 4856 50
Salaries
Indirect Expenses
15000
General Expenses
Indirect Expenses
3000
Insurance
Indirect Expenses
600
Drawings
Capital
Capital
Capital
62000
Sales
Sales
98780
Return Outwards
Purchase
500
Sundry Creditors
Sundry Creditors
6300
Bills Payable
Current Liability
9000
TOTAL
540
5245
1765 80
1765 80
Result :Gateway of Tally-DisplayTrailbalance(Alt+F1)
(4)NAME
UNDER NAME
DR
CR
Capital
Capital
20000
Sales
Sales
16000
Sundry Creditors
Sundry Creditors
Furniture
Fixed Assets
500
Gneral Expenses
Indirect Expenses
800
Commission
Indirect Expenses
250
Rent
Indirect Expenses
450
Bills Receivable
Curretn Assets
2900
Sundry Debtors
Sundry Debtors
4400
Buildings
Fixed Assets
Stock 1.4.2009
Stock In Hand
6000
Purchase
Purchase
2000
Wages
Direct Expenses
1000
Cash In Hand
Cash In Hand
6500
Cash At Bank
Bank
1700
Drawings
Capital
4000
TOTAL
4050 0
4500
(5)NAME Opening Stock Buildings Furniture Purchase Salaries Bad Debts Cash In Hand Return Inwards Rent Miscellaneous Exp Capital Bank Loan Sundry Creditors Return Outwards
10000
Interest 4050 0
* closing stock 4000
Dividends Sales Postage
RESULT: Gateway of Tally- PROFIT& LOSS A/C / BALANCE SHEET
GROSS PROFIT
RS.
NET PROFIT
RS.
BALANCE SHEET
RS.
Printing Wages Freight Carriage On Sales Repairs
UNDER NAME Stock In Hand Fixed Assets Fixed Assets Purchase Indirect Expenses Indirect Expenses Cash In Hand Sales Indirect Expenses Indirect Expenses Capital Loan Liability Sundry Creditors Purchase Indirect Incomes Indirect Incomes Sales Indirect Expenses Indirect Expenses Direct Expenses Direct Expenses Indirect Expenses Direct
DR 3100 17000 1000 21200
CR
2200 120 1300 1020 600 500 12000 3000 4920 420 130 110 41460 280 260 5200 560 800 900
Sundry Debtors
Expenses Sundry Debtors TOTAL
6000 6204 0
Bank Balance 6204 0
Petty Cash
Cash In Hand Indirect Interest On Loan Expenses Indirect Travelling Expnes Expenses Indirect Printing Expenses Stock On 1.1.2009 Stock In Hand
* closing stock 980 GROSS PROFIT RS: NET PROFIT RS: BALANCE SHEET RS:
(6)NAME
UNDER NAME
Capital
Capital
Loan At 6% P.A
Loans Liability
Sales
Sales
Interest Sundry Creditors Commission Recei
20000 350000
Indirect Income
630
Investment
Investment
Reparis
108850
59000
Purchase
Commission
CR
Indirect Income Sundry Creditors
Return Outward
Furniture
DR
Fixed Assets Indirect Expenses Direct Expenses
Bank
5640
6430
8800 70 300 12000 880 89680
Postage
Indirect Expens
Pruchase
Purchase
Return Inwards Wages And Salary
Sales Direct Expenses
40970
Sundry Debtors
Sundry Debtors
62000
Land & Building
Fixed Assets
37770
Bills Receivable
Current Assets
Drawings
Capital
TOTAL *Closing stock rs.128960 GROSS PROFIT
5620 25659 0 2780
4500 5000 55055 0
550550
RS:
NET PROFIT RS: BALANCE SHEETRS:
19000 500 470 3620
(7) Capital
NAME
UNDER NAME Capital
DR
CR 40000
Gross Profit:9700 Net profit;5890 Balance sheet:42190 Sales
Sales
25000
Purchase
Purchase
Salaries
Indirect Expenses
2000
Rent
Indirect Expenses
1500
Insurance
Indirect Expenses
300
Drawings
Capital
Machinery
Fixed Assets
Bank Balance
Bank
4500
Cash
Cash
2000
Stock 1.1.2009
Stock In Hand
5200
Debtors
Sundry Debtors
2500
Creditors
Sundry Creditors
Next go to Gateway of tally-display-daybook-Alt+F1
15000
5000 28000
100 66000
adjustments:
66000 F7 ONLY
1.Stock 31.12.2009 rs.4900 A/C INFORMATION - LEDGER - CREATE - PAGEUP – SELECT STOCK SELECT OPENING STOCK -TYPE CLSOING STOCK . STOCK DEBIT BALANCE 2.Salaries unpaid rs.300 SALARY A/C DR (IND.EXP) 300 TO OUTSATNDING SALARY(CURRENTLIABILITIES) 300 3.Rent paid in advance rs.200 PREPAID RENT A/C DR 200(CURRENT ASSETS) TO RENT A/C 200(INDIRECTEXP) 4.Insruance prepaid rs.90 PREPAID INSURANCE A/C DR 90(CURREN ASSETS) TO INSURANCE A/C 90(INDIRECT EXP) Result:Gatewayof tally-Profit&loss a/c-Balancesheet
(8) NAME
UNDER NAME
DR
CR
Land And Building
Fixed Assets
42000
Machinery
Fixed Assets
20000
Purchase
Purchase
7500
1.4.2009 Stock
Stock In Hand
5760
Sundry Debtors
Sundry Debtors
14500
Patents
Current Assets
40675
Cash In Hand
Cash In Hand
Cash At Bank
Bank
2630
Return Inwards
Sales
680
Wages
Direct Expenses
8480
Fuel & Power
Direct Expenses
4730
Carriage On Sales
Indirect Expenses
3200
Carrage On Purchase
Direct Expenses
2040
Salaries
Indirect Expenses
15000
General Expenses
Indirect Expenses
3000
Insurance
Indirect Expenses
600
Drawings
Capital
Capital
Capital
62000
Sales
Sales
98780
Return Outwards
Purchase
500
Sundry Creditors
Sundry Creditors
6300
Bills Payable
Current Liability
9000
540
5245
17658 0
17658 0
NEXT GO TO GATEWAY OF TALLY -DISPLAY – DAYBOOK -ALT+FI DETAIL adjustments: F7 (JOURNAL ONLY) 1.Stock on 31.3.2009 was rs.6800 A/C INFORMATION - LEDGER - CREATE - PAGEUP - SELECT STOCK SELECT OPENING STOCK -TYPE CLSOING STOCK STOCK DEBIT BALANCE ONLY
2.Salary outstanding rs.1500 SALARY A/C DR (IND.EXP) 1500 TO OUTSATNDING SALARY(CURRENTLIABILITIES)1500
3.Insurance parepaid rs.150 PREPAID INSURANCE A/C DR 150(CURRENASSETS) TO INSURANCE A/C 150(INDIRECT EXP)
4.Depreciate machinery @ 10% and patents @ 20% DEPRECIATION A/C DR(INDIRECT EXPENSES) 4600 TO MACHINERY A/C(F.A) 2000 TO PATENTS A/C (C.A)2600
5.Create a provision of 2% on debtors for bad debts BAD DEBTS A/C DR (INDIRECT EXPENSES) 290 TOSUNDRY DEBOTS A/C(SUNDRY DEBOTS)290 RESULT: Gateway of tally - PROFIT& LOSS A/C / B S GROSS PROFIT RS:43715 NET PROFIT RS:16775 BALANCE SHEET RS:90330
(9) NAME Drawings Goodwill Building Machinery Bills Receivable Opening Stock Purchases Wages Carriage Outward Carriage Inward Salaries Rent Discount Repairs Bank Cash Debtors Bad Debtors Sales Return Furniture Advertising Gneral Expenses
UNDER NAME Capital Current Assets Fixed Assets Fixed Assets Current Assets Stock In Hand Purchase Direct Expenses Indirect Expenses Direct Expenses Indirect Expenses Indirect Expenses Indirect Expenses Direct Expenses Bank Cash In Hand Sundry Debtors Indirect Expenses Sales Fixed Assets Indirect Expenses Indirect Expenses
DR 45000 90000 60000 40000 6000 40000 51000 26000 500 1000 35000 3000 1100 2300 25000 1600 45000 1200 2000 6000 3500 450
CR
Capital
Capital
16000
Bills Payable
Current Liablility Creditors Sundry Creditors Purchase Return Purchase Sales
35000 70000 2650 21800
Sales 48565 0
48565
TO MENT AIC EXPENSES) 500
(INDIRECT
5.Create 5% on debtors for bad debts as provision BAD DEBTS A/C DR (INDIRECT EXPENSES) 2250 TO SUNDRY DEBOTS A/C(SUNDRY DEBOTS) 2250 RESULT: A/C INFORMATION - PROFIT& LOSS A/C / BALANCE SHEET GROSS PROFIT NET PROFIT
RS.134150 RS.807 50
BALANCE SHEET
RS.302250
*NEXT GO TO GATEWAY OF TALLY -DISPLAY DAYBOOK -ALT+FI adjustments:
Enter the following transactions in the
F7 ONLY
1.closing stock was rs.35000 A/C INFORMATION - LEDGER - CREATE - PAGEUP - SELECT STOCK SELECT OPENING STOCK -TYPE CLSOING STOCK - STOCK DEBIT BALANCE ONLY
entry
voucher
of Idhayam of Kumbakonam
Cash a/c Dr To capital
180000 a/c
Cash in hand 180
Capital
000 2.Depreciate machinery and furniture by 10% DEPRECIATION A/C DR(INDIRECT EXPENSES) 4600 TO MACHINERY A/C (FIXED ASSETS) 4000 TO FURNITURE A/C (FIXED ASSETS) 600 3.Outstanding wages rs.1500 WAGES A/C DR (DIRECT EXPENSES) TOOUTSTANDING WAGES A/C (CURRENT LIABILITY)1500 4.Prepaid ment rs.500 PREPAID MENT A/C DR (CURRENT ASSETS)500
1500
1.1.2010 Commenced business with cash rs.180000 (F6.Receipt)
3 Depostied into Indian bank rs.55000 (F4.Contra)
BAnk a/c Dr To cashl a/c
55000
Bank 55
Cash in hand
000
4
Purchases goods for cash rs.22000 Purchase a/c Dr To cash
22000 a/c
Purchase 22
000
Cash in hand
(F9.Purchase)
5
Bought goods of Siva rs.72000 Purchase a/c Dr To Siva a/c
72000
Purchase 72
000
Sundry creditors
(F9.Purchase)
8
Cash sales rs.16200 Cash a/c Dr To Sales a/c
16200
Cash in hand 16
Sales
200 (F8.Sales)
11
Cash deposited into Bank rs.23000
(F4.Contra)
Indian Bank a/c Dr To Cash a/c
23000
Bank 23
Cash a/c Dr Discount allowed a/c To Ram a/c
Cash in hand
000
14
12446
Cash in hand
254 12 700
Indirect expenses Sundry Debtors
Purchased furniture for cash rs.4000 Furniture a/c Dr To Cash a/c
4000
Fixed assets 40
18
Cash in hand
00
Paid Siva Cash rs.12000 Discount allowed by him rs.240 Siva a/c Dr To cash
(F5.Payment)
12240 a/c
12
Sundry Creditors Cash in hand
000 16
To Discount Received a/c
Sold goods to Ram rs.12700 Ram a/c Dr To Sales a/c
12700 12
Indirect Income
240
* (F5.Payment)
Sundry Debtors Sales
700 (F8.Sales) Wages a/c Dr To Cash a/c
1800 1
Indirect expneses Cash in hand
800 Received cash from Ram rs.12446 Allowed him discount rs.254 (F6.Receipt)
20
17
Paid Wages rs.1800
(F5.Payment)
*
21
Sold goods to Raj rs.35000 Raj Dr To Sales
a/c
35000
a/c
35 000
Sundry Debtors Sales
Purchase a/c Dr
6000
To cash Raj a/c Dr Roja a/c To Sales Dr
a/c
a/c
13000
900
Cash in hand Sundry Debtors
5.bought goods for cash rs.6000-(F9.purchase)
Cash in hand Sales
0
a/c
Furniture a/c Dr To Cash
600 0 9000
ToDiscount Purchase a/c received a/c Dr To Cash To Devi a/c
Purchase
5
13600 00 00 00
Indirec Purchase expenses
14.Sold goods to Raj on Credit 9000-(IGNORED)
125 Sundry 136 Sundry Debtors creditors
9600
Fixed assets
a/c
960
15.Bought goods from Devi on Credit13600-(IGNORED)
Cash in hand
0
20.Purchased furniture9600-(F4.payment)
20
Paid to cash from Roja rs.12500 Discount received rs.254 (F5.Payment)
Stationery Cash a/c a/c Dr
160 24000
To Cash capital a/c a/c
Fixed assets Cash in hand 160 2400
21.Purchased stationery160-(F4.payment)
Cash in hand Capital
0
Result : GATEWAY OF TALLY – DISPLAY – S BOOKS –LEGER - select EACH S LEGER(example. refer to sundry debtors/creditors s) Enter the following transaction in a SIMPLE CASH BOOK of SONA feb.2010 1.Commenced business with cash rs.24000-(F6.Receipt)
23.received cheque from Raj9000-(F6.Receipt) Cash Dr To Raj
a/c a/c
9000
Cash in Hand
9 Sundry 000 Debtors 25.Paid Devi13600-(F5.Payment)
Devi a/c Dr To Cash a/c
3600 3
Sundry Creditors Cash in hand
600 26.Received Commission 740-(F6.Receipt) Cash a/c Dr 740 Cash in hand To Commission 7 Indirect a/c 40 Income 26.Paid into Bank 2500-(F4.Contra) Bank a/c Dr 2500 Bank To Cash a/c 25 Cash in hand 00 27.Paid Telephone Charges300-(F5.Payment) Telephone a/c Dr To Cash a/c
300 30
Indirect Expenses Cash in hand
0 28.Drawn from Bank 3800-(F4.Contra) Cash a/c Dr 3800 Cash in hand To Bank a/c 3800 Bank 28.Goods sold for cash 11200-(F8.Sales) Cash a/c Dr 11200 Cash in hand to Sales a/c 112 Sales 00 Result :Gateway of Tally-Display-s books-Cash a/c (OR)Ledger-cash-E+E DOUBLE COLMN CASH BOOK Enter the following transaction in ROJA’s Cash book with Discount and Cash Columns March 2010 1.cash balance18500 Give Opening balance of cash 3.cash sales 33000-(F8.sales) Cash a/c 33000 Cash in hand Dr To Sales a/c 330 Sales 00
7.paid Dravid15850 and discount allowed by him 150(F5.Payment) Dravid a/c Dr 16000 Sundry creditors To Cash a/c 158 Cash in hand 50 To Discount 1 Indirect Received 50 income 13.sold goods to Manohar on credit 19200 (IGNORED) Manohar a/c Dr 19200 Sundry debtors To Sales a/c 1920 Sales 0 15.cash withdrawn for personal expenses 2400(F5.payment) Drawing a/c Dr 2400 Indirect expenses To cash a/c 2400 Cash 16.purchased goods from charles on credit 14300(IGNORED) Purchase a/c Dr 14300 Purchase To charles a/c 1430 Sundry 0 creditors 22.paid into bank22750(F5.payment) Bank a/c Dr 22750 Bank To cash a/c 2275 Cash in hand 0 25.cash received from Manohar 19000 and allowed him discount200(F6.receipt) Cash a/c Dr 19000 Cash in hand Discount allowed 200 Indirect expenses To Mahohar 1920 Sundry 0 debtors 26.drew a cheque for office use 17500(F4.contra) Cash a/c Dr 17500 Cash in hand To Bank a/c 1750 Bank 0 27.paid cash to saravanan2950 and discount received form him 50(F5.payment) Saravanan a/c 3000 Sundry
Dr To cash a/c
29
creditors Cash in hand
50 To Discount Indirect received 50 income 28.paid cash to charles less discount 14200(F5.payment) Charles a/c Dr 14300 Sundry creditors To cash a/c 1420 Cash in hand 0 To Discount 80 Indirect received 0 income 29.cash purchase 13500(F9.purchase) Purchase a/c Dr 13500 Purchases To cash a/c 135 Cash in hand 00 30.paid for Advertising 600(F5.payment) Advertising a/c 600 Indirect Dr expenses To cash a/c 600 Cash in hand 31.paid Salaries 12000(F5.payment) Salaries a/c Dr 12000 Indirect expenses To cash a/c 1200 Cash in hand 0
PETTY CASH BOOK Petty cashier received rs.600, Give opening balance of cash 3.stamps 50-(F5.payment) Stamps a/c Dr 50 To cash a/c 50 5.taxi fare 100-(F5.payment) Taxi fare a/c 100 Dr
Indirect expenses Cash in hand Indirect expenses
To cash a/c 100 Cash in hand 6.Pencils & Pads 75-(F5.payment) Pencils & pads 75 Indirect a/cDr expenses To cash a/c 75 Cash in hand 7.Registry 25-(F5.payment) Registry a/c Dr 25 Indirect expenses To cash a/c 25 Cash in hand 10.Speed Post 45-(F5.payment) Speed post a/c 45 Indirect Dr expenses To cash a/c 45 Cash in hand 12.Telegram35-(F5.payment) Telegram a/c 35 Indirect Dr expenses Cash a/c 35 Cash in hand 15.Refreshment55-(F5.payment) Refreshment a/c 55 Indirect Dr expenses To cash a/c 55 Cash in hand 16.Auto fare20-(F5.payment) Autor fare a/c 20 Indirect Dr expenses To cash a/c 20 Cash in hand 19.Typing Paper 60-(F5.payment) Typeing paper a/c 60 Indirect Dr expenses To Cash a/c 60 Cash in hand 20.Bus fare 15-(F5.payment) Bus fare a/c Dr 15 Indirect expenses To Cash a/c 15 Cash in hand 22.Trunk calls 43-(F5.payment) Trunk calls a/c 43 Indirect Dr expenses To cash a/c 43 Cash in hand 25.Office cleaning 18-(F5.payment) Office cleaning 18 Indirect a/c Dr expenses To cash a/c 18 Cash in hand
30.Courier Services 17-(F5.payment) Courier service 17 Indirect a/c Dr expenses To Cash a/c 17 Cash in hand Result :Gateway of Tally-Display-s books-Cash a/c (OR)Ledger-cash-E+E-F8.columnar-select Yes or NoType of column(select.All items (automatic columns)Accept.etc., BANK RECONLATION STATEMENT Company Create(Date April.2010)-Gateway of Tallys Info-Ledger-create(indian bank(u/n.Bank s-Rs.1,00,000(Effective dae of Reconcilation ? YES),Raja(S.Dr),Roja(S.Dr)-Ram(S.Dr)Suba(S.Cr),Sutha(S.Cr),Suji(S.Cr)) NEXT go to Voucher EntryApril 2.cheque received on Raja 1500(F6.Receipt) Indian bank a/c 1500 Bank s Dr To Raja a/c 1500 Sundry debtors
April 12.cheque received on Ram 6000(F6.Receipt) Indian bank a/c 6000 Bank s Dr To Ram a/c 6000 Sundry debtors April 15.cheque issued on suji 4000(F5.Payment) Suji a/c Dr 4000 Sundry creditors Indian bank a/c 4000 Bank s Gateway of Tally-Display-s books-Bank bookBank (OR)Ledger-select Indian bank-E+E-press F5.Reconcil-(Checked Balance as per Company books and Balance as per Bank)Newly open BANK DATE give cheques isssued and received DATE(Again Checked Balance as per Company books and Balance as per Bank).Once give the date again you give F5.Reconcil is blanked.
F.11 - FEATURES Allow multi currency
? YES
April 3.cheque issued on Suba 1000(F5.Payment) Suba a/c Dr 1000 Sundry creditors To Indian bank 1000 Bank s a/c
1.Gateway of tally- Info-Currencies-CreateSymbols($,E,R,D,Y)-Formal name (Dallor,Euro,Reyal,Dhinar,Yen)-Accept-Esc+Esc –Next -Rate of Exchange-Std.Rate=50,Selling Rate=60,Buying Rate=40-Accept.NEXT
April 6.cheque received on Roja 3000(F6.Receipt) Indian bank a/c 3000 Bank s Dr To Roja a/c 3000 Sundry debtors
2. info-Ledger-Create-(Purchase(u/nPurchase),Sales(u/n-sales),Rentpaid(u/n-Ind.Exp),Interest received(u/n-Ind.Income).Esc*3 times-NEXT
April 9.cheque issued on Sutha 2000(F5.Payment) Sutha a/c Dr 2000 Sundry creditors To Indian bank 2000 Bank s a/c
3.Voucher Entry-Type 4 entires each entry currencies converted the Display:-Purchase & Payment entry(Take Buying rate), Sales & receipt(Take Selling rate) Maintain Budget and Control? YES
Gateway of tally- Info-Budget-Create(1.Name:Advertising, 2.Under:Primary,3.Period of Budget From 1.4.2009 To 30.6.2009. 4.Set/Alter Budget of (Groups – Yes-NEXT-give Name-Indirect Expenses NEXT Type of Budget = 2 types : 1.on closing balance 2.on nett transactions(you select any one methods)NEXT-give budget amount rs.5000)NEXT(Ledger -Yes-NEXT- Name-(Press Alt+C –Create Ledger Advertising.u/n Indirect Expneses)Advertising NEXT Type of Budget = 2 types : 1.on closing balance 2.on nett transactions(you select any one methods)*select budget Types and Amount is same groups&ledger NEXT-give budget amount rs.5000)-Accept. NEXT-Gateway of tally-Voucher entry-F5.PaymentF2.Date is given each voucher entries (up to Budget Period) 5.4.2009 Paid Advertising 2000 Advertising a/c 2000 Dr To Cash a/c 2000 6.5.2009 Paid Advertising 2500 Advertising a/c 2500 Dr To Cash a/c 2500 30.6.2009 Paid Advertising 1000 Advertising a/c 2000 Dr To Cash a/c 2000 NEXT-Gateway of Tally-Display- bookLedger-Advertising+E-NEXT – 1.Press Alt+C(see commands area-New column)-give budget date-From 1.4.2009 To 30.6.2009, Budget value-Actual. Name of the Ledger-Advertising+E-Display Ledger Monthly Summary-To refer Amount and Grafe-Press Esc.
NEXT-Ledger-advertising – 2.Press Alt+A(see commands area-Alter column)-give budget date-From 1.4.2009 To 30.6.2009, Budget value-Actual. Name of the Ledger-Advertising+E-Display Ledger Monthly Summary-To refer Amount and Grafe-Press Esc. NEXT –-Ledger-advertising- 1.Press Alt+C(see commands area-New column)-give budget date-From 1.4.2009 To 30.6.2009, Budget value-Advertising. Name of the Ledger-Advertising+E-Display Ledger Monthly Summary-To refer Amount and Grafe-Press Esc. NEXT –-Ledger-advertising- 2.Press Alt+A(see commands area-Alter column)-give budget date-From 1.4.2009 To 30.6.2009, Budget value-Advertising. Name of the Ledger-Advertising+E-Display Ledger Monthly Summary-To refer Amount and Grafe-Press Esc. Maintain Billwise detail ? YES (for non trading a/c also) ? YES Gateway of Tally- Info-LedgerCreate1.Sales(u/n.sales), Maintain balances bill-by-bill ? Yes 2.Anbu,Anand,babu,basu (u/n.Sundry Debtors), Maintain balances bill-by-bill ? Yes NEXT:Gateway of Tally-Voucher entry-F8.salesF2.Date1)April.1.Goods sold to Anbu 1000- 30 days creditF8.sales Anbu a/c Dr 1000 Display – Bill wise details(Type of Ref= -select New RefName=Anbu or give number-Credit days=30-Amount 1000+E -NEXT TO Sales a/c 1000 2)April.2.Goods sold to Anand 2000-25 days creditF8.salesAnand a/c Dr 2000
Display – Bill wise details(Type of Ref= -select New RefName=Anand or give number-Credit days=25-Amount 2000+E -NEXT TO Sales a/c 2000 3)April.3.Goods sold to Babu 3000-20 days creditF8.sales Anand a/c Dr 3000 Display – Bill wise details(Type of Ref= -select New RefName=Babu or give number-Credit days=20-Amount 3000+E -NEXT TO Sales a/c 3000 4)April.4.Goods sold to Basu 4000-15 days creditF8.sales Anand a/c Dr 4000 Display – Bill wise details(Type of Ref= -select New RefName=Basu or give number-Credit days=20-Amount 4000+E -NEXT TO Sales a/c 4000 NEXT:Gateway of Tally-Display- book-Ledgerselect Sales+E-select F8.Other report-select Bill wise details-check Ledger outstandings
NEXT: Gateway of tally-Display-Statement of sOutstandings-Check Receivable(credit sales only)\Payable(credit purchase only)
NEXT:Gateway of Tally-Voucher entry-F6.Receipt-give credit days last date(example:31.4.2009) I will give only one (Anbu transaction) results
1)Jan.2. Paid Traveling Expenses rs.500-by CarfareF5.Payment Travelling exp 500 a/cDr Display – Cost allocation(Cost category= Traveling, Name of the Cost Centre=Carefare 500+E )-NEXT To Cash a/c 500 2) 1)Jan.4. Paid Traveling Expenses rs.250-by TrainfareF5.Payment Travelling exp 250 a/cDr Display – Cost allocation(Cost category= Traveling, Name of the Cost Centre=Trainfare- 250+E )-NEXT To Cash a/c 2 50 3) 1)Jan.6. Paid Traveling Expenses rs.125-by BusfareF5.Payment Travelling exp 125 a/cDr
TO Anbu a/c 900 Display – Bill wise details(Type of Ref= -select Agst Ref+E-Name=List of pending bills display+E-900+E -NEXT Cash a/c 900 Accept – NEXT:Gateway of tally-Display-s bookLedger-select Anbu+E-(Display Ledger monthly summary & referred acutal amount and Pending amount)-Select F8.Other report-Bill wise details+E+E(referred detail bill wise details in Anbu). NEXT: Gateway of tally-Display-s book-Ledgerselect Anbu+E-F10.Acc.Rep-Select Bills Receivable(credit sales only) &Bills payable(credit purchase only) refered over dues excess date (OR)
Maintain Cost Centres
? Yes
More than one Cost Categories
? Yes
Gateway of Tally-s Info-Cost Categories-CreateName=Travelling-Accept+Esc+Esc+EscNEXT-Cost Centres-Create-Category=TravellingName=1.Airfare,2.Busfare,3.Trainfare,4.Carfare,5.Autofa re-Under=Primary-Accept.NEXT- Gateway of Tallys Info-Ledger-Create-Travelling Expenses(u/n.Indirect Expenses)-Cost Centre are applicabale ? Yes. Accept. NEXT-Gateway of Tally-Voucher entry-F5.PaymentF2.Date (Different date 3 or 4 voucher entry ed)
Display – Cost allocation(Cost category= Traveling, Name of the Cost Centre=Busfare 125+E )-NEXT To Cash a/c 125 4) 1)Jan.8. Paid Traveling Expenses rs.75-by AutofareF5.Payment Travelling exp 75 a/cDr Display – Cost allocation(Cost category= Traveling, Name of the Cost Centre=Autofare 75+E )-NEXT To Cash a/c 75 5) 1)Jan.2. Paid Traveling Expenses rs.3500-by AirefareF5.Payment Travelling exp 3500 a/cDr Display – Cost allocation(Cost category= Traveling, Name of the Cost Centre=Airfare 3500+E )-NEXT To Cash a/c 3500 NEXT:Gateway of Tally-Display-Statement of sCost centre-referred each heads.(OR)Gateway of tally-Display-s book-Ledger-select Travelling expE- F8.Other Rep-select Cost Centre Breakup- see cost breakup ledger Use Rev. Journals
? Yes
If you want to use Reverse Journal Vouchers, then it will be available in Voucher on Pressiong F10.momos-It is smimiar to Journal Voucher but is not included in regular s. To get mid-year Final s, make entries in Reverse Journal and while viewing Reports ask to include it. Use Debit/Credit note
? Yes
Credit Note: You generally raise a Credit note when a buyer returns some goods that you Sold him (Sales Return) or you grant him credit due to rate difference or
discount/rebate or when is there is an excess debit to any party. Create New Company-Gateway of Tally-s InfoLedger-create(sales(u/n.Sales),Suresh(u/n.Sundry Debtors), NEXT-Voucher Entry-F8.Sales – 1. Jan.10. sold goods to Ram Rs.1000 Ram a/c Dr 1000 To Sales a/c 1000 *goods return(sales return) discount/rebate was adjusted Rs.100 NEXT:Gateway of Tally-Voucher entry-Pressing F7.Journal-select Credit Note+E+F2.Date. To/Cr Ram a/c 1 00 Sales a/c 100 NEXT:Gateway of Tally-Display-s book-Ledgerselect Ram+E+E Result: 1000-100=900 anser(less the Credit Note amount in a/cs) Debit Note: You raise a Debit Note when you make purchase Return or when you have shortbilled a customer or you are granted Credit by your Supplier due to rate difference, discount etc., 1. Jan.20.purchased goods from Ponni Rs.200 Purchase/c Dr 200 To ponni a/c 2 00 *goods return(purchase return) discount/rebate was adjust Rs.20 NEXT:Gateway of Tally-Voucher entry-Pressing F7.Journal-select Debit Note+E+F2.Date. Ponni a/c Dr 20 purchase a/c 20 NEXT:Gateway of Tally-Display-s book-Ledgerselect Ponni+E+E
Result: 200-20=180 anser(less the Debit Note amount in a/cs)
UNDER NAME
DR
Capital
Capital
Cash In Hand
Cash In Hand
Building
Fixed Asset
Stock
Stock In Hand
47000
Sundry Debtors
Sundry Debtors
50000
Commission Paid
Indirect Expenses
100
Rent & Taxes
Indirect Expenses
3500
Purchases
Purchases
CR
Creditors
Creditors
24000
Travelling Expness
Indirect Expenses
2000
TOTAL
2201 00
900 2500
Result :Gateway of tally-DisplayTrailbalance(Alt+F1)
(2)NAME
UNDER NAME
Drawings
Capital
Goodwill
Current Assets
Building
Fixed Assets
Machinery Bills Receivable
Fixed Assets Current Assets
Opening Stock
Stock In Hand
Purchases
Purchase
70800
Purchase Return
Purcahase
Furniture
Fixed Asset
Loan To Suba
Loans Liability
Discount Allowed
Indirect Expenses
4600
Drawings
Capital
6000
Bills Receivable
Current Assets
5200
Cash At Bank
Bank
2201 00
1100 4500 10000
12500 12800 0
Sales
Sales
Sales Return
Sales
1000
Salaries
Indirect Expenses
9500
Discount Earned
Indirect Income
4000
Bank Overdraft
Bank O/D
6000
Bills Payable
Current Liability
4000
Sundrry
Sundry
43000
Wages Direct Expenses Carriage Outward Indirect Expenses Carriage Inward Direct Expenses Salaries Rent Discount Repairs
Indirect Expenses Indirect Expenses Indirect Expenses Direct Expenses
Bank Cash Debtors
Bank Cash In Hand Sundry Debtors
DR 4500 0 9000 0 6000 0 4000 0 6000 4000 0 5100 0 2600 0 500 1000 3500 0 3000 1100 2300 2500 0 1600 4500
CR
Bad Debtors Sales Return Furniture Advertising Gneral Expenses
Indirect Expenses Sales Fixed Assets Indirect Expenses
0 1200 2000 6000 3500
Indirect Expenses
450
Capital
Capital
Bills Payable
Current Liablility
Creditors Purchase Return
Sundry Creditors
Sales
Sales
Purchase 4856 50
TOTAL Result :Gateway of tally-DisplayTrailbalance(Alt+F1)
(3)NAME
UNDER NAME
DR
Land And Building
Fixed Assets
42000
Machinery
Fixed Assets
20000
Purchase
Purchase
7500
1.4.2009 Stock
Stock In Hand
5760
Sundry Debtors
Sundry Debtors
14500
Patents
Current Assets
40675
CR
Cash In Hand
Cash In Hand
Cash At Bank
Bank
2630
Return Inwards
Sales
680
Wages
Direct Expenses
8480
1600 00 3500 0 7000 0
Fuel & Power
Direct Expenses
4730
Carriage On Sales
Indirect Expenses
3200
Carrage On Purchase
Direct Expenses
2040
2650 2180 00 4856 50
Salaries
Indirect Expenses
15000
General Expenses
Indirect Expenses
3000
Insurance
Indirect Expenses
600
Drawings
Capital
Capital
Capital
62000
Sales
Sales
98780
Return Outwards
Purchase
500
Sundry Creditors
Sundry Creditors
6300
Bills Payable
Current Liability
9000
TOTAL
540
5245
1765 80
1765 80
Result :Gateway of Tally-DisplayTrailbalance(Alt+F1)
(4)NAME
UNDER NAME
DR
CR
Capital
Capital
20000
Sales
Sales
16000
Sundry Creditors
Sundry Creditors
Furniture
Fixed Assets
500
Gneral Expenses
Indirect Expenses
800
Commission
Indirect Expenses
250
Rent
Indirect Expenses
450
Bills Receivable
Curretn Assets
2900
Sundry Debtors
Sundry Debtors
4400
Buildings
Fixed Assets
Stock 1.4.2009
Stock In Hand
6000
Purchase
Purchase
2000
Wages
Direct Expenses
1000
Cash In Hand
Cash In Hand
6500
Cash At Bank
Bank
1700
Drawings
Capital
4000
TOTAL
4050 0
4500
(5)NAME Opening Stock Buildings Furniture Purchase Salaries Bad Debts Cash In Hand Return Inwards Rent Miscellaneous Exp Capital Bank Loan Sundry Creditors Return Outwards
10000
Interest 4050 0
* closing stock 4000
Dividends Sales Postage
RESULT: Gateway of Tally- PROFIT& LOSS A/C / BALANCE SHEET
GROSS PROFIT
RS.
NET PROFIT
RS.
BALANCE SHEET
RS.
Printing Wages Freight Carriage On Sales Repairs
UNDER NAME Stock In Hand Fixed Assets Fixed Assets Purchase Indirect Expenses Indirect Expenses Cash In Hand Sales Indirect Expenses Indirect Expenses Capital Loan Liability Sundry Creditors Purchase Indirect Incomes Indirect Incomes Sales Indirect Expenses Indirect Expenses Direct Expenses Direct Expenses Indirect Expenses Direct
DR 3100 17000 1000 21200
CR
2200 120 1300 1020 600 500 12000 3000 4920 420 130 110 41460 280 260 5200 560 800 900
Sundry Debtors
Expenses Sundry Debtors TOTAL
6000 6204 0
Bank Balance 6204 0
Petty Cash
Cash In Hand Indirect Interest On Loan Expenses Indirect Travelling Expnes Expenses Indirect Printing Expenses Stock On 1.1.2009 Stock In Hand
* closing stock 980 GROSS PROFIT RS: NET PROFIT RS: BALANCE SHEET RS:
(6)NAME
UNDER NAME
Capital
Capital
Loan At 6% P.A
Loans Liability
Sales
Sales
Interest Sundry Creditors Commission Recei
20000 350000
Indirect Income
630
Investment
Investment
Reparis
108850
59000
Purchase
Commission
CR
Indirect Income Sundry Creditors
Return Outward
Furniture
DR
Fixed Assets Indirect Expenses Direct Expenses
Bank
5640
6430
8800 70 300 12000 880 89680
Postage
Indirect Expens
Pruchase
Purchase
Return Inwards Wages And Salary
Sales Direct Expenses
40970
Sundry Debtors
Sundry Debtors
62000
Land & Building
Fixed Assets
37770
Bills Receivable
Current Assets
Drawings
Capital
TOTAL *Closing stock rs.128960 GROSS PROFIT
5620 25659 0 2780
4500 5000 55055 0
550550
RS:
NET PROFIT RS: BALANCE SHEETRS:
19000 500 470 3620
(7) Capital
NAME
UNDER NAME Capital
DR
CR 40000
Gross Profit:9700 Net profit;5890 Balance sheet:42190 Sales
Sales
25000
Purchase
Purchase
Salaries
Indirect Expenses
2000
Rent
Indirect Expenses
1500
Insurance
Indirect Expenses
300
Drawings
Capital
Machinery
Fixed Assets
Bank Balance
Bank
4500
Cash
Cash
2000
Stock 1.1.2009
Stock In Hand
5200
Debtors
Sundry Debtors
2500
Creditors
Sundry Creditors
Next go to Gateway of tally-display-daybook-Alt+F1
15000
5000 28000
100 66000
adjustments:
66000 F7 ONLY
1.Stock 31.12.2009 rs.4900 A/C INFORMATION - LEDGER - CREATE - PAGEUP – SELECT STOCK SELECT OPENING STOCK -TYPE CLSOING STOCK . STOCK DEBIT BALANCE 2.Salaries unpaid rs.300 SALARY A/C DR (IND.EXP) 300 TO OUTSATNDING SALARY(CURRENTLIABILITIES) 300 3.Rent paid in advance rs.200 PREPAID RENT A/C DR 200(CURRENT ASSETS) TO RENT A/C 200(INDIRECTEXP) 4.Insruance prepaid rs.90 PREPAID INSURANCE A/C DR 90(CURREN ASSETS) TO INSURANCE A/C 90(INDIRECT EXP) Result:Gatewayof tally-Profit&loss a/c-Balancesheet
(8) NAME
UNDER NAME
DR
CR
Land And Building
Fixed Assets
42000
Machinery
Fixed Assets
20000
Purchase
Purchase
7500
1.4.2009 Stock
Stock In Hand
5760
Sundry Debtors
Sundry Debtors
14500
Patents
Current Assets
40675
Cash In Hand
Cash In Hand
Cash At Bank
Bank
2630
Return Inwards
Sales
680
Wages
Direct Expenses
8480
Fuel & Power
Direct Expenses
4730
Carriage On Sales
Indirect Expenses
3200
Carrage On Purchase
Direct Expenses
2040
Salaries
Indirect Expenses
15000
General Expenses
Indirect Expenses
3000
Insurance
Indirect Expenses
600
Drawings
Capital
Capital
Capital
62000
Sales
Sales
98780
Return Outwards
Purchase
500
Sundry Creditors
Sundry Creditors
6300
Bills Payable
Current Liability
9000
540
5245
17658 0
17658 0
NEXT GO TO GATEWAY OF TALLY -DISPLAY – DAYBOOK -ALT+FI DETAIL adjustments: F7 (JOURNAL ONLY) 1.Stock on 31.3.2009 was rs.6800 A/C INFORMATION - LEDGER - CREATE - PAGEUP - SELECT STOCK SELECT OPENING STOCK -TYPE CLSOING STOCK STOCK DEBIT BALANCE ONLY
2.Salary outstanding rs.1500 SALARY A/C DR (IND.EXP) 1500 TO OUTSATNDING SALARY(CURRENTLIABILITIES)1500
3.Insurance parepaid rs.150 PREPAID INSURANCE A/C DR 150(CURRENASSETS) TO INSURANCE A/C 150(INDIRECT EXP)
4.Depreciate machinery @ 10% and patents @ 20% DEPRECIATION A/C DR(INDIRECT EXPENSES) 4600 TO MACHINERY A/C(F.A) 2000 TO PATENTS A/C (C.A)2600
5.Create a provision of 2% on debtors for bad debts BAD DEBTS A/C DR (INDIRECT EXPENSES) 290 TOSUNDRY DEBOTS A/C(SUNDRY DEBOTS)290 RESULT: Gateway of tally - PROFIT& LOSS A/C / B S GROSS PROFIT RS:43715 NET PROFIT RS:16775 BALANCE SHEET RS:90330
(9) NAME Drawings Goodwill Building Machinery Bills Receivable Opening Stock Purchases Wages Carriage Outward Carriage Inward Salaries Rent Discount Repairs Bank Cash Debtors Bad Debtors Sales Return Furniture Advertising Gneral Expenses
UNDER NAME Capital Current Assets Fixed Assets Fixed Assets Current Assets Stock In Hand Purchase Direct Expenses Indirect Expenses Direct Expenses Indirect Expenses Indirect Expenses Indirect Expenses Direct Expenses Bank Cash In Hand Sundry Debtors Indirect Expenses Sales Fixed Assets Indirect Expenses Indirect Expenses
DR 45000 90000 60000 40000 6000 40000 51000 26000 500 1000 35000 3000 1100 2300 25000 1600 45000 1200 2000 6000 3500 450
CR
Capital
Capital
16000
Bills Payable
Current Liablility Creditors Sundry Creditors Purchase Return Purchase Sales
35000 70000 2650 21800
Sales 48565 0
48565
TO MENT AIC EXPENSES) 500
(INDIRECT
5.Create 5% on debtors for bad debts as provision BAD DEBTS A/C DR (INDIRECT EXPENSES) 2250 TO SUNDRY DEBOTS A/C(SUNDRY DEBOTS) 2250 RESULT: A/C INFORMATION - PROFIT& LOSS A/C / BALANCE SHEET GROSS PROFIT NET PROFIT
RS.134150 RS.807 50
BALANCE SHEET
RS.302250
*NEXT GO TO GATEWAY OF TALLY -DISPLAY DAYBOOK -ALT+FI adjustments:
Enter the following transactions in the
F7 ONLY
1.closing stock was rs.35000 A/C INFORMATION - LEDGER - CREATE - PAGEUP - SELECT STOCK SELECT OPENING STOCK -TYPE CLSOING STOCK - STOCK DEBIT BALANCE ONLY
entry
voucher
of Idhayam of Kumbakonam
Cash a/c Dr To capital
180000 a/c
Cash in hand 180
Capital
000 2.Depreciate machinery and furniture by 10% DEPRECIATION A/C DR(INDIRECT EXPENSES) 4600 TO MACHINERY A/C (FIXED ASSETS) 4000 TO FURNITURE A/C (FIXED ASSETS) 600 3.Outstanding wages rs.1500 WAGES A/C DR (DIRECT EXPENSES) TOOUTSTANDING WAGES A/C (CURRENT LIABILITY)1500 4.Prepaid ment rs.500 PREPAID MENT A/C DR (CURRENT ASSETS)500
1500
1.1.2010 Commenced business with cash rs.180000 (F6.Receipt)
3 Depostied into Indian bank rs.55000 (F4.Contra)
BAnk a/c Dr To cashl a/c
55000
Bank 55
Cash in hand
000
4
Purchases goods for cash rs.22000 Purchase a/c Dr To cash
22000 a/c
Purchase 22
000
Cash in hand
(F9.Purchase)
5
Bought goods of Siva rs.72000 Purchase a/c Dr To Siva a/c
72000
Purchase 72
000
Sundry creditors
(F9.Purchase)
8
Cash sales rs.16200 Cash a/c Dr To Sales a/c
16200
Cash in hand 16
Sales
200 (F8.Sales)
11
Cash deposited into Bank rs.23000
(F4.Contra)
Indian Bank a/c Dr To Cash a/c
23000
Bank 23
Cash a/c Dr Discount allowed a/c To Ram a/c
Cash in hand
000
14
12446
Cash in hand
254 12 700
Indirect expenses Sundry Debtors
Purchased furniture for cash rs.4000 Furniture a/c Dr To Cash a/c
4000
Fixed assets 40
18
Cash in hand
00
Paid Siva Cash rs.12000 Discount allowed by him rs.240 Siva a/c Dr To cash
(F5.Payment)
12240 a/c
12
Sundry Creditors Cash in hand
000 16
To Discount Received a/c
Sold goods to Ram rs.12700 Ram a/c Dr To Sales a/c
12700 12
Indirect Income
240
* (F5.Payment)
Sundry Debtors Sales
700 (F8.Sales) Wages a/c Dr To Cash a/c
1800 1
Indirect expneses Cash in hand
800 Received cash from Ram rs.12446 Allowed him discount rs.254 (F6.Receipt)
20
17
Paid Wages rs.1800
(F5.Payment)
*
21
Sold goods to Raj rs.35000 Raj Dr To Sales
a/c
35000
a/c
35 000
Sundry Debtors Sales
Purchase a/c Dr
6000
To cash Raj a/c Dr Roja a/c To Sales Dr
a/c
a/c
13000
900
Cash in hand Sundry Debtors
5.bought goods for cash rs.6000-(F9.purchase)
Cash in hand Sales
0
a/c
Furniture a/c Dr To Cash
600 0 9000
ToDiscount Purchase a/c received a/c Dr To Cash To Devi a/c
Purchase
5
13600 00 00 00
Indirec Purchase expenses
14.Sold goods to Raj on Credit 9000-(IGNORED)
125 Sundry 136 Sundry Debtors creditors
9600
Fixed assets
a/c
960
15.Bought goods from Devi on Credit13600-(IGNORED)
Cash in hand
0
20.Purchased furniture9600-(F4.payment)
20
Paid to cash from Roja rs.12500 Discount received rs.254 (F5.Payment)
Stationery Cash a/c a/c Dr
160 24000
To Cash capital a/c a/c
Fixed assets Cash in hand 160 2400
21.Purchased stationery160-(F4.payment)
Cash in hand Capital
0
Result : GATEWAY OF TALLY – DISPLAY – S BOOKS –LEGER - select EACH S LEGER(example. refer to sundry debtors/creditors s) Enter the following transaction in a SIMPLE CASH BOOK of SONA feb.2010 1.Commenced business with cash rs.24000-(F6.Receipt)
23.received cheque from Raj9000-(F6.Receipt) Cash Dr To Raj
a/c a/c
9000
Cash in Hand
9 Sundry 000 Debtors 25.Paid Devi13600-(F5.Payment)
Devi a/c Dr To Cash a/c
3600 3
Sundry Creditors Cash in hand
600 26.Received Commission 740-(F6.Receipt) Cash a/c Dr 740 Cash in hand To Commission 7 Indirect a/c 40 Income 26.Paid into Bank 2500-(F4.Contra) Bank a/c Dr 2500 Bank To Cash a/c 25 Cash in hand 00 27.Paid Telephone Charges300-(F5.Payment) Telephone a/c Dr To Cash a/c
300 30
Indirect Expenses Cash in hand
0 28.Drawn from Bank 3800-(F4.Contra) Cash a/c Dr 3800 Cash in hand To Bank a/c 3800 Bank 28.Goods sold for cash 11200-(F8.Sales) Cash a/c Dr 11200 Cash in hand to Sales a/c 112 Sales 00 Result :Gateway of Tally-Display-s books-Cash a/c (OR)Ledger-cash-E+E DOUBLE COLMN CASH BOOK Enter the following transaction in ROJA’s Cash book with Discount and Cash Columns March 2010 1.cash balance18500 Give Opening balance of cash 3.cash sales 33000-(F8.sales) Cash a/c 33000 Cash in hand Dr To Sales a/c 330 Sales 00
7.paid Dravid15850 and discount allowed by him 150(F5.Payment) Dravid a/c Dr 16000 Sundry creditors To Cash a/c 158 Cash in hand 50 To Discount 1 Indirect Received 50 income 13.sold goods to Manohar on credit 19200 (IGNORED) Manohar a/c Dr 19200 Sundry debtors To Sales a/c 1920 Sales 0 15.cash withdrawn for personal expenses 2400(F5.payment) Drawing a/c Dr 2400 Indirect expenses To cash a/c 2400 Cash 16.purchased goods from charles on credit 14300(IGNORED) Purchase a/c Dr 14300 Purchase To charles a/c 1430 Sundry 0 creditors 22.paid into bank22750(F5.payment) Bank a/c Dr 22750 Bank To cash a/c 2275 Cash in hand 0 25.cash received from Manohar 19000 and allowed him discount200(F6.receipt) Cash a/c Dr 19000 Cash in hand Discount allowed 200 Indirect expenses To Mahohar 1920 Sundry 0 debtors 26.drew a cheque for office use 17500(F4.contra) Cash a/c Dr 17500 Cash in hand To Bank a/c 1750 Bank 0 27.paid cash to saravanan2950 and discount received form him 50(F5.payment) Saravanan a/c 3000 Sundry
Dr To cash a/c
29
creditors Cash in hand
50 To Discount Indirect received 50 income 28.paid cash to charles less discount 14200(F5.payment) Charles a/c Dr 14300 Sundry creditors To cash a/c 1420 Cash in hand 0 To Discount 80 Indirect received 0 income 29.cash purchase 13500(F9.purchase) Purchase a/c Dr 13500 Purchases To cash a/c 135 Cash in hand 00 30.paid for Advertising 600(F5.payment) Advertising a/c 600 Indirect Dr expenses To cash a/c 600 Cash in hand 31.paid Salaries 12000(F5.payment) Salaries a/c Dr 12000 Indirect expenses To cash a/c 1200 Cash in hand 0
PETTY CASH BOOK Petty cashier received rs.600, Give opening balance of cash 3.stamps 50-(F5.payment) Stamps a/c Dr 50 To cash a/c 50 5.taxi fare 100-(F5.payment) Taxi fare a/c 100 Dr
Indirect expenses Cash in hand Indirect expenses
To cash a/c 100 Cash in hand 6.Pencils & Pads 75-(F5.payment) Pencils & pads 75 Indirect a/cDr expenses To cash a/c 75 Cash in hand 7.Registry 25-(F5.payment) Registry a/c Dr 25 Indirect expenses To cash a/c 25 Cash in hand 10.Speed Post 45-(F5.payment) Speed post a/c 45 Indirect Dr expenses To cash a/c 45 Cash in hand 12.Telegram35-(F5.payment) Telegram a/c 35 Indirect Dr expenses Cash a/c 35 Cash in hand 15.Refreshment55-(F5.payment) Refreshment a/c 55 Indirect Dr expenses To cash a/c 55 Cash in hand 16.Auto fare20-(F5.payment) Autor fare a/c 20 Indirect Dr expenses To cash a/c 20 Cash in hand 19.Typing Paper 60-(F5.payment) Typeing paper a/c 60 Indirect Dr expenses To Cash a/c 60 Cash in hand 20.Bus fare 15-(F5.payment) Bus fare a/c Dr 15 Indirect expenses To Cash a/c 15 Cash in hand 22.Trunk calls 43-(F5.payment) Trunk calls a/c 43 Indirect Dr expenses To cash a/c 43 Cash in hand 25.Office cleaning 18-(F5.payment) Office cleaning 18 Indirect a/c Dr expenses To cash a/c 18 Cash in hand
30.Courier Services 17-(F5.payment) Courier service 17 Indirect a/c Dr expenses To Cash a/c 17 Cash in hand Result :Gateway of Tally-Display-s books-Cash a/c (OR)Ledger-cash-E+E-F8.columnar-select Yes or NoType of column(select.All items (automatic columns)Accept.etc., BANK RECONLATION STATEMENT Company Create(Date April.2010)-Gateway of Tallys Info-Ledger-create(indian bank(u/n.Bank s-Rs.1,00,000(Effective dae of Reconcilation ? YES),Raja(S.Dr),Roja(S.Dr)-Ram(S.Dr)Suba(S.Cr),Sutha(S.Cr),Suji(S.Cr)) NEXT go to Voucher EntryApril 2.cheque received on Raja 1500(F6.Receipt) Indian bank a/c 1500 Bank s Dr To Raja a/c 1500 Sundry debtors
April 12.cheque received on Ram 6000(F6.Receipt) Indian bank a/c 6000 Bank s Dr To Ram a/c 6000 Sundry debtors April 15.cheque issued on suji 4000(F5.Payment) Suji a/c Dr 4000 Sundry creditors Indian bank a/c 4000 Bank s Gateway of Tally-Display-s books-Bank bookBank (OR)Ledger-select Indian bank-E+E-press F5.Reconcil-(Checked Balance as per Company books and Balance as per Bank)Newly open BANK DATE give cheques isssued and received DATE(Again Checked Balance as per Company books and Balance as per Bank).Once give the date again you give F5.Reconcil is blanked.
F.11 - FEATURES Allow multi currency
? YES
April 3.cheque issued on Suba 1000(F5.Payment) Suba a/c Dr 1000 Sundry creditors To Indian bank 1000 Bank s a/c
1.Gateway of tally- Info-Currencies-CreateSymbols($,E,R,D,Y)-Formal name (Dallor,Euro,Reyal,Dhinar,Yen)-Accept-Esc+Esc –Next -Rate of Exchange-Std.Rate=50,Selling Rate=60,Buying Rate=40-Accept.NEXT
April 6.cheque received on Roja 3000(F6.Receipt) Indian bank a/c 3000 Bank s Dr To Roja a/c 3000 Sundry debtors
2. info-Ledger-Create-(Purchase(u/nPurchase),Sales(u/n-sales),Rentpaid(u/n-Ind.Exp),Interest received(u/n-Ind.Income).Esc*3 times-NEXT
April 9.cheque issued on Sutha 2000(F5.Payment) Sutha a/c Dr 2000 Sundry creditors To Indian bank 2000 Bank s a/c
3.Voucher Entry-Type 4 entires each entry currencies converted the Display:-Purchase & Payment entry(Take Buying rate), Sales & receipt(Take Selling rate) Maintain Budget and Control? YES
Gateway of tally- Info-Budget-Create(1.Name:Advertising, 2.Under:Primary,3.Period of Budget From 1.4.2009 To 30.6.2009. 4.Set/Alter Budget of (Groups – Yes-NEXT-give Name-Indirect Expenses NEXT Type of Budget = 2 types : 1.on closing balance 2.on nett transactions(you select any one methods)NEXT-give budget amount rs.5000)NEXT(Ledger -Yes-NEXT- Name-(Press Alt+C –Create Ledger Advertising.u/n Indirect Expneses)Advertising NEXT Type of Budget = 2 types : 1.on closing balance 2.on nett transactions(you select any one methods)*select budget Types and Amount is same groups&ledger NEXT-give budget amount rs.5000)-Accept. NEXT-Gateway of tally-Voucher entry-F5.PaymentF2.Date is given each voucher entries (up to Budget Period) 5.4.2009 Paid Advertising 2000 Advertising a/c 2000 Dr To Cash a/c 2000 6.5.2009 Paid Advertising 2500 Advertising a/c 2500 Dr To Cash a/c 2500 30.6.2009 Paid Advertising 1000 Advertising a/c 2000 Dr To Cash a/c 2000 NEXT-Gateway of Tally-Display- bookLedger-Advertising+E-NEXT – 1.Press Alt+C(see commands area-New column)-give budget date-From 1.4.2009 To 30.6.2009, Budget value-Actual. Name of the Ledger-Advertising+E-Display Ledger Monthly Summary-To refer Amount and Grafe-Press Esc.
NEXT-Ledger-advertising – 2.Press Alt+A(see commands area-Alter column)-give budget date-From 1.4.2009 To 30.6.2009, Budget value-Actual. Name of the Ledger-Advertising+E-Display Ledger Monthly Summary-To refer Amount and Grafe-Press Esc. NEXT –-Ledger-advertising- 1.Press Alt+C(see commands area-New column)-give budget date-From 1.4.2009 To 30.6.2009, Budget value-Advertising. Name of the Ledger-Advertising+E-Display Ledger Monthly Summary-To refer Amount and Grafe-Press Esc. NEXT –-Ledger-advertising- 2.Press Alt+A(see commands area-Alter column)-give budget date-From 1.4.2009 To 30.6.2009, Budget value-Advertising. Name of the Ledger-Advertising+E-Display Ledger Monthly Summary-To refer Amount and Grafe-Press Esc. Maintain Billwise detail ? YES (for non trading a/c also) ? YES Gateway of Tally- Info-LedgerCreate1.Sales(u/n.sales), Maintain balances bill-by-bill ? Yes 2.Anbu,Anand,babu,basu (u/n.Sundry Debtors), Maintain balances bill-by-bill ? Yes NEXT:Gateway of Tally-Voucher entry-F8.salesF2.Date1)April.1.Goods sold to Anbu 1000- 30 days creditF8.sales Anbu a/c Dr 1000 Display – Bill wise details(Type of Ref= -select New RefName=Anbu or give number-Credit days=30-Amount 1000+E -NEXT TO Sales a/c 1000 2)April.2.Goods sold to Anand 2000-25 days creditF8.salesAnand a/c Dr 2000
Display – Bill wise details(Type of Ref= -select New RefName=Anand or give number-Credit days=25-Amount 2000+E -NEXT TO Sales a/c 2000 3)April.3.Goods sold to Babu 3000-20 days creditF8.sales Anand a/c Dr 3000 Display – Bill wise details(Type of Ref= -select New RefName=Babu or give number-Credit days=20-Amount 3000+E -NEXT TO Sales a/c 3000 4)April.4.Goods sold to Basu 4000-15 days creditF8.sales Anand a/c Dr 4000 Display – Bill wise details(Type of Ref= -select New RefName=Basu or give number-Credit days=20-Amount 4000+E -NEXT TO Sales a/c 4000 NEXT:Gateway of Tally-Display- book-Ledgerselect Sales+E-select F8.Other report-select Bill wise details-check Ledger outstandings
NEXT: Gateway of tally-Display-Statement of sOutstandings-Check Receivable(credit sales only)\Payable(credit purchase only)
NEXT:Gateway of Tally-Voucher entry-F6.Receipt-give credit days last date(example:31.4.2009) I will give only one (Anbu transaction) results
1)Jan.2. Paid Traveling Expenses rs.500-by CarfareF5.Payment Travelling exp 500 a/cDr Display – Cost allocation(Cost category= Traveling, Name of the Cost Centre=Carefare 500+E )-NEXT To Cash a/c 500 2) 1)Jan.4. Paid Traveling Expenses rs.250-by TrainfareF5.Payment Travelling exp 250 a/cDr Display – Cost allocation(Cost category= Traveling, Name of the Cost Centre=Trainfare- 250+E )-NEXT To Cash a/c 2 50 3) 1)Jan.6. Paid Traveling Expenses rs.125-by BusfareF5.Payment Travelling exp 125 a/cDr
TO Anbu a/c 900 Display – Bill wise details(Type of Ref= -select Agst Ref+E-Name=List of pending bills display+E-900+E -NEXT Cash a/c 900 Accept – NEXT:Gateway of tally-Display-s bookLedger-select Anbu+E-(Display Ledger monthly summary & referred acutal amount and Pending amount)-Select F8.Other report-Bill wise details+E+E(referred detail bill wise details in Anbu). NEXT: Gateway of tally-Display-s book-Ledgerselect Anbu+E-F10.Acc.Rep-Select Bills Receivable(credit sales only) &Bills payable(credit purchase only) refered over dues excess date (OR)
Maintain Cost Centres
? Yes
More than one Cost Categories
? Yes
Gateway of Tally-s Info-Cost Categories-CreateName=Travelling-Accept+Esc+Esc+EscNEXT-Cost Centres-Create-Category=TravellingName=1.Airfare,2.Busfare,3.Trainfare,4.Carfare,5.Autofa re-Under=Primary-Accept.NEXT- Gateway of Tallys Info-Ledger-Create-Travelling Expenses(u/n.Indirect Expenses)-Cost Centre are applicabale ? Yes. Accept. NEXT-Gateway of Tally-Voucher entry-F5.PaymentF2.Date (Different date 3 or 4 voucher entry ed)
Display – Cost allocation(Cost category= Traveling, Name of the Cost Centre=Busfare 125+E )-NEXT To Cash a/c 125 4) 1)Jan.8. Paid Traveling Expenses rs.75-by AutofareF5.Payment Travelling exp 75 a/cDr Display – Cost allocation(Cost category= Traveling, Name of the Cost Centre=Autofare 75+E )-NEXT To Cash a/c 75 5) 1)Jan.2. Paid Traveling Expenses rs.3500-by AirefareF5.Payment Travelling exp 3500 a/cDr Display – Cost allocation(Cost category= Traveling, Name of the Cost Centre=Airfare 3500+E )-NEXT To Cash a/c 3500 NEXT:Gateway of Tally-Display-Statement of sCost centre-referred each heads.(OR)Gateway of tally-Display-s book-Ledger-select Travelling expE- F8.Other Rep-select Cost Centre Breakup- see cost breakup ledger Use Rev. Journals
? Yes
If you want to use Reverse Journal Vouchers, then it will be available in Voucher on Pressiong F10.momos-It is smimiar to Journal Voucher but is not included in regular s. To get mid-year Final s, make entries in Reverse Journal and while viewing Reports ask to include it. Use Debit/Credit note
? Yes
Credit Note: You generally raise a Credit note when a buyer returns some goods that you Sold him (Sales Return) or you grant him credit due to rate difference or
discount/rebate or when is there is an excess debit to any party. Create New Company-Gateway of Tally-s InfoLedger-create(sales(u/n.Sales),Suresh(u/n.Sundry Debtors), NEXT-Voucher Entry-F8.Sales – 1. Jan.10. sold goods to Ram Rs.1000 Ram a/c Dr 1000 To Sales a/c 1000 *goods return(sales return) discount/rebate was adjusted Rs.100 NEXT:Gateway of Tally-Voucher entry-Pressing F7.Journal-select Credit Note+E+F2.Date. To/Cr Ram a/c 1 00 Sales a/c 100 NEXT:Gateway of Tally-Display-s book-Ledgerselect Ram+E+E Result: 1000-100=900 anser(less the Credit Note amount in a/cs) Debit Note: You raise a Debit Note when you make purchase Return or when you have shortbilled a customer or you are granted Credit by your Supplier due to rate difference, discount etc., 1. Jan.20.purchased goods from Ponni Rs.200 Purchase/c Dr 200 To ponni a/c 2 00 *goods return(purchase return) discount/rebate was adjust Rs.20 NEXT:Gateway of Tally-Voucher entry-Pressing F7.Journal-select Debit Note+E+F2.Date. Ponni a/c Dr 20 purchase a/c 20 NEXT:Gateway of Tally-Display-s book-Ledgerselect Ponni+E+E
Result: 200-20=180 anser(less the Debit Note amount in a/cs)
Related Documents c2h70
Tally Practical Question 4c3e6v
October 2019 714
Practical Tally Question 1r4o48
April 2020 54
Tally Question Set 1x6e17
December 2019 102
Tally Sample Question Paper 2y1b4e
October 2019 190
Practical Question For Final s 6y61f
October 2019 126
Tally Project 7334z
October 2019 158More Documents from "Barani Dharan" 4t3r5t
Tally Practical Question 4c3e6v
October 2019 714
Tally Notes 2j2p5u
April 2020 25
Practical Tally Question 1r4o48
April 2020 54
Tally.9 Voucher Entry Questions 2t5u3m
October 2019 160
Fox Pro 2.6 22hl
October 2019 46