Fiancial Accounting (Tally - Steps)
Fiancial Accounting (Tally - Steps)
Fiancial Accounting (Tally - Steps)
Output 1: Gateway of Tally -> Display -> Account Books -> Ledger -> Bank A/c
Output 2: Gateway of Tally -> Display -> Account Books -> Ledger -> Cash
Problem 3:
Assuming your own figures prepare a cash book for the following cash
transactions:
a) Ramu brought in cash towards Capital Rs.25,000.
b) Deposited into bank Rs.20,000
c) Purchased goods Rs.3,000
d) Sale of goods worth Rs.8,000
e) Paid to Hrithik ( a supplier) Rs.5,000
f) Received from Mohan ( a customer) Rs.6,000.
Step 1: Creation of Company: Gateway of Tally -> Creation of Company
Step 2: Creation of Ledger Accounts
Company Info -> Esc -> Gateway of Tally-> Accounts Info -> Ledgers -> Create
Sl. No. Name of Ledger Under Opening Balance
1 Ramu’s Capital A/c Capital Account
2 Bank A/c Bank Accounts
3 Purchase A/c Purchase Accounts
4 Sale A/c Sales Accounts
5 Hrithik A/c Sundry Creditor
6 Mohan A/c Sundry Debtor
Step 3: Enter Transactions: Gateway of Tally -> Accounting Vouchers
Output: Gateway of Tally -> Display -> Account Books -> Ledger -> Cash
Problem 4:
Prepare cash book with bank column for the following bank transactions in Andhra Bank
and ascertain Bank balance.
Balance at Bank Rs.2,00,000
Paid to Rajesh Rs.10,000 by cheque
Paid to Mahesh Babu Rs.25,000 by cheque
Received a cheque from Ragini Rs.38,000
Received from Sneha Rs.50,000 by cheque.
Step 1: Creation of Company: Company Info -> Creation of Company
Step 2: Creation of Ledger Accounts
Company Info -> Esc -> Gateway of Tally-> Accounts Info -> Ledgers -> Create
Problem 7:
Compute Net Profit from the given transactions:
Rs.
Started business with capital 75,000
Cash deposited into the SBI 10,000
Cash purchases 5,000
Cash Sales 6,000
Paid Rent 600
Step 1: Creation of Company: Gateway of Tally -> Creation of Company
Step 2: Creation of Ledger Accounts
Company Info -> Esc -> Gateway of Tally-> Accounts Info -> Ledgers -> Create
Problem 8:
Prepare the Trading and Profit and Loss account and the Balance Sheet.
Opening Balance: Rs.
Capital 2,00,000
Machinery 1,00,000
Cash 1,00,000
Transactions:
Purchased good from ANKIT (cash) 4,500
Sold goods for cash 11,500
Sold good to NIKHIL (Credit) 17,000
Paid Salaries 3,000
Selling Expenses 1,500
Voucher
Date Particulars Dr Cr
[Function Keys]
Purchase A/c Dr 4500
To Cash A/c 4500 F9
[Being goods purchased for Cash]
Cash A/c Dr 11500
To Sales A/c 11500 F8
[Being cash sales made]
Nikhil A/c Dr 17000
To Sales A/c 17000 F8
[Being goods sold to Nikhil on credit basis]
Salaries A/c Dr 3000
To Cash A/c 3000 F5
[Being salaries paid]
Selling Expenses A/c Dr 3000
To Cash A/c 3000 F5
[Being expenses incurred for selling goods]
Problem 9:
Opening Balance sheet: Rs.
Capital 2,00,000
Furniture 50,000
Cash 50,000
Buildings 1,00,000
Transactions:
Salaries paid 5,000
Rent paid 2,000
Adjustments:
Outstanding rent at the end of the year Rs.500
Depreciation on Buildings 10% p.a.
Pass adjustment entries and finalize the P & L account and Balance sheet.
Step 1: Creation of Company: Gateway of Tally -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Problem 10:
Create a company of your own and generate a Petty cash book with 10 transactions. Assume
own amounts.
(a) Received advance from cashier Rs. 350
(b) Paid for Bus charges Rs. 10
(c) Purchased White Papers Rs. 5
(d) Paid Auto Charges Rs. 20
(e) Paid Wages Rs. 30
(f) Telegram Charges Rs. 10
(g) Purchased Stationery Rs. 15
(h) Tea Expenses Rs. 6
(i) Paid for Speed Post Rs. 15
(j) Refreshment Expenses Rs. 25
(k) Paid for carriage Rs. 15
Output: Gateway of Tally -> Display -> Account Books -> Ledger -> Petty Cash Book
Output 1: Gateway of Tally -> Display -> Account Books -> Purchase Register
Output 2: Gateway of Tally -> Display -> Account Books -> Sales Register
Problem 12: Prepare the trading and P & L A/C and also Balance Sheet:
Opening Balance: Rs.
Capital 4,00,000
Furniture 1,00,000
Cash 30,000
Building 2,00,000
Machinery 70,000
Transactions:
Purchased goods 20,000
Sales 40,000
Paid rent 1,000
Salaries paid 3,000
Interest received 2000
Problem 13:
From the following information prepare P & L account and B/S.
Opening balance sheet
Capital Rs.6,00,000
Motor car Rs.2,00,000
Machinery Rs.1,00,000
S.Debtors Rs.1,50,000
Cash Rs.1,50,000
Transactions:
Paid wages Rs. 2,000
Paid salaries Rs. 3,000
Insurance paid Rs. 500
Commission paid Rs. 200
Sales Rs. 20,000
Purchases Rs. 12,000
Furniture purchased Rs. 2,300
Adjustments:
Outstanding wages at the end of the year Rs.500
Outstanding salaries at the end of the year Rs.100
Prepaid Insurance Rs.100
Problem 14:
Enter the following transactions by creating relevant accounts and groups and show
sales register and purchase register.
Purchased goods from Ram Rs.10,000
Purchased goods from Roshan Rs.5,000
Purchased goods from Mohan Rs.20,000
Sold goods to Leela Rs.25,000
Sold goods to Praveena Rs.30,000
Sold goods to Praveen Rs.20,000.
Step 1: Creation of Company: Gateway of Tally -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Output 1: Gateway of Tally -> Display -> Account Books -> Purchase Register
Output 2: Gateway of Tally -> Display -> Account Books -> Sales Register
Problem 15:
From the following information prepare P & L account and B/S
Opening balance sheet
Capital 2,50,000
Building 2,00,000
Cash 50,000
Transactions:
Paid Audit fee Rs.500,
Paid General Exp. Rs.1,000,
Advertisement Rs.1,000
Paid postage Rs.500,
Printing Rs.100,
Rent Rs.500.
Sales Rs.60,000.
Purchases Rs.21,000.
Adjustments:
Outstanding rent Rs.200,
Depreciation on Building 10%.
Problem 16:
From the information given below prepare P & L account & B/S.
Salaries 70,000 Capital 6,00,000
Rent 30,000 Commission received 10,000
Stationary 5,000 Sales 1,65,000
Cash 45,000
Furniture 4,60,000
Purchases 84,000
Machinery 81,000
Adjustments:
Outstanding Rent Rs.1,000,
Depreciation on furniture @ 5%,
Machinery @ 4%.
Problem 17:
Enter the following transactions in books of Bajaj and show P&L A/c.
Goods purchased from Prem Rs.30,000.
Cash paid to Prem Rs.29,500 and discount allowed by him Rs.500.
Goods Sold to Mukthi Rs.40,000.
Cash received from Mukthi Rs.39,000 allowed her discount Rs.1,000.
Problem 19:
Mr.Sudhir started business with cash Rs.3,00,000:
Purchased 20 CTV’s @10,000 each for cash.
Paid carriage on purchase Rs.2000
Sold 10 CTV’s @12,000 each for cash
Sold 10 CTV’s @12,000 each to Shyam.
Paid salaries Rs.2,000 and Rent Rs.1,000
Prepare P & L A/c.
Step 1: Creation of Company: Gateway of Tally -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Problem 20:
Prepare Trading and P & L A/c and also Balance sheet.
Manisha started business with cash Rs.5,00,000
Purchased 15 colour TVs @15,000 each for cash
Paid carriage on purchase Rs.2000
Sold 10 CTVs @20,000 each for cash
Sold 3 CTVs @20,000 each to Mr.Raju on credit paid salaries Rs.1,000
Closing stock valued at Rs.30,000.
Step 1: Creation of Company: Gateway of Tally -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Problem 21:
Prepare Trading and P & L a/c and Balance sheet.
Sunitha started business with Rs.5,00,000.
Purchased furniture worth Rs.20,000.
Purchased computer worth Rs.10,000 for business use.
Purchased 10 Printers @ Rs.5,000 each from TVS Ltd.
Purchased 10 computers @20,000 each for cash.
Sold 10 Printer @6,000 each for cash .
Sold 10 computers @25,000 each to Sunil.
Paid cash to TVS Ltd. Rs.50,000.
Received cash from Sunil Rs.2,50,000.
Paid salaries Rs.1,000 and Rent Rs.1,500
Step 1: Creation of Company: Gateway of Tally -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Problem 22:
Mr.Kartik started business with Rs.3,00,000; Purchased 10 colour TVs @15,000 each for
cash; Purchased 10 colour TVs @15,000 each from Manoj; Sold 18 CTVs @18,000 each
for cash; Paid salaries Rs1,000 and rent Rs.1,000.
Prepare Trading & P & L a/c.
Step 1: Creation of Company: Gateway of Tally -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Problem 23:
Enter the following transactions and generate a sales register.
Sold goods to Birla Traders Rs.2,000
Sold goods to Kamlesh & Sons Rs.2,000
Malik & Bros bought from us Rs.2,000
Sold on credit to Birla Traders Rs.6,500
Goods sold to little Roses Ltd. Rs.5,600.
Step 1: Creation of Company: Company Info -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Problem 24:
Enter the following transaction and generate a purchases register.
i. Purchased goods from Gupta Rs.10,000
ii. Purchased goods from Vijay Rs.5,000
iii. Purchased goods from Gopi Rs.2,000
iv. Purchased goods from Ram Rs.5,000
v. Purchased goods from Shashi Rs.20,000
vi. Purchased furniture on credit from Godrej Ltd., Rs.12,000
vii. Purchase of goods for cash Rs.3,000
Step 1: Creation of Company: Company Info -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Output: Gateway of Tally -> Display -> Account Books -> Purchase Register
Problem 25:
Prepare a Bank Reconciliation Statement of Mr.Nagesh as on 2nd April.
a) Bank balance as per pass book (Bank book) Rs.26,000.
b) Cheques received from Mohan worth Rs. 11000 and from Mahesh worth Rs. 10000
were deposited into bank. Mahesh Cheque not collected by bank up to 2nd April.
c) Cheques issued to Raju but not presented for payment till 2nd April Rs.12,000.
d) Bank charges Rs.500 debited in pass book only.
e) Interest and dividend collected by bank Rs.6,500.
f) Insurance premium paid by bank as per standing instructionsRs.2,800 not recorded in
cash book
Step 1: Creation of Company: Company Info -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Voucher
Date Particulars Dr Cr
[Function Keys]
1 Bank A/c Dr 11000
To Mohan A/c 11000 F6
[Being cheques received]
2 Bank A/c Dr 10000
To Mahesh A/c 10000 F6
[Being cheques received]
3 Raju A/c Dr 12000
To Bank A/c 12000 F5
[Being cheque issued]
4 Bank Charges A/c Dr 500
To Bank A/c 500 F5
[Being bank charges paid]
5 Bank A/c Dr 6500
To Interest & Dividend Received A/c 6500
F6
[Being interest and dividend collected by
bank]
6 Insurance Premium A/c Dr 2800
To Bank A/c 2800 F5
[Being bank charges paid]
Output: Gateway of Tally -> Display -> Account Books -> Ledger -> Bank A/c
Problem 26:
Create a company with full details. Enter the following transactions and show P& L A/c.
a. Priyanka started Business with Rs. 1,00,000
b. Opened account with bank Rs. 20,000
c. Bought Furniture by Cheque Rs. 3,000
d. Paid office rent Rs. 600
e. Cash Purchases Rs. 15,000
f. Cash Sales Rs. 4,000
Step 1: Creation of Company: Company Info -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
B.Com First Year [General, Computers & Computer Applications] Page 44
Financial Accounting – Practical Problems with Solutions – Tally. ERP 9
St. PAUL’S DEGREE COLLEGE Ph.No. 27602533
Problem 27:
Assuming your own figures, prepare a cash book for the following cash transactions:
a. Ramu’s introduced Rs.25,000 into business
b. Deposited into the bank Rs.20,000
c. Purchased goods Rs.3,000
d. Sold good worth Rs.5,000
e. Paid to Somu Rs.3,000
Step 1: Creation of Company: Company Info -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Problem 28:
Prepare a Bank book for the following Bank transactions and ascertain Balance.
a. Balance at Bank Rs.2,00,000
b. Paid to Rajkumar Rs.25,000 by Cheque
c. Received a Cheque from Rajni Rs.25,000
d. Paid to Ramakanth by Cheque Rs.10,000
e. Received from Sneha Rs.8,000 by Cheque
f. Cheque received from Rajini dishonoured.
Step 1: Creation of Company: Company Info -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Problem 30:
Show the trail balance given below.
Name of the Account Dr. (Rs.) Cr. (Rs.)
Capital 5,00,000
S.Creditors 50,000
Bank Loan 50,000
Buildings 4,00,000
S.Debtors 1,00,000
Motor car 1,00,000
Problem 31: Create a Company / firm with your own name full details. Enter 10 cash
transactions and show cash book.
(i) Nanda started business with cash Rs. 500000
(ii) Cash Purchases Rs. 50000
(iii) Cash Sales Rs. 100000
(iv) Carriage Inward Rs. 500
(v) Carriage outward Rs. 200
(vi) Paid Salaries Rs. 6000
(vii) Paid insurance premium Rs. 500
(viii) Rent Rs. 300
(ix) Cash Paid to Prasad Rs. 1000
(x) Cash Received from Johnson Rs. 2000
Step 1: Creation of Company: Company Info -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Problem 33:
Enter the following transactions.
a) Purchase of furniture for 3,000 included in purchases.
b) Salary paid to Mr. X Rs.2,000 debited to his personal account.
c) Sale of plant Rs.1,500 credited to sales account.
d) Bad debts recovered Rs.800 credited to the personal a/c of Mr. Ramu.
Step 1: Creation of Company: Company Info -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Problem 35:
Create a company with full details. Enter the following transactions and Show P& L A/c.
Priyanka started Business Rs. 3,00,000
Opened account with bank Rs. 20,000
Bought Furniture by cheque Rs. 3,000
Paid office rent Rs. 500
Cash purchases Rs. 15,000
Cash Sales Rs. 5,000
Step 1: Creation of Company: Company Info -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Problem 36:
Assuming you own figures, prepare a cash book for the following cash transactions:
i. Raju introduced into business Rs.45,000
ii. Deposited into the bank Rs.40,000
iii. Purchased goods Rs.4,000
iv. Sold Goods worth Rs.4,000
v. Paid to Somu Rs.23,000
Step 1: Creation of Company: Company Info -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Output: Gateway of Tally -> Display -> Account Books -> Ledger -> Cash
Problem 37:
Edit the following transactions
a. Bought goods worth Rs.5,500, alter it to Rs.10,000
b. Sold Goods to Madhu Rs.5,000 alter into Rs.7,000
c. Cash received from Venkat Rs.1,000 alter it to Ramana
d. Paid cash to Vasu Rs1,000, alter to bank
Step 1: Creation of Company: Company Info -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Problem 38:
Show the trail balance given below:
Name of the Account Dr. (Rs.) Cr. (Rs.)
Furniture 1,30,000
Plant 5,00,000
Bank 3,00,000
Buildings 8,00,000
Capital 10,00,000
Bills Payable 7,00,000
Outstanding salaries 30,000
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Problem 40:
Show the balance sheet of Kalyan & Co. with the following accounts under relevant
groups: Assume your own figures.
i. 3 Current Liabilities and 2 long term liabilities.
ii. 5 Current Assets and 3 Fixed Assets.
iii. 1 Capital account.
iv. 1 Drawing account.
Step 1: Creation of Company: Company Info -> Creation of Company
Step 2: Creation of Ledger Accounts: Gateway of Tally-> Accounts Info -> Ledgers -> Create
Problem 47:
Opening Balance sheet
Capital 6,00,000
Motor car 2,00,000
Machinery 1,00,000
S.Debtors 50,000
Cash 1,50,000
Transactions:
Purchases R. 28,000
Sales Rs.49,000
Paid Wages Rs,2,000
Paid salaries 3,000
Insurance paid 500
Commission paid 200
Adjustments:
Outstanding wages at the end of the year Rs.500
Outstanding salaries at the end of the year Rs.100
Prepaid insurance Rs.100 Closing Stock Rs.6,000
Problem 48:
Enter the following balance and create B/S:
Particulars Dr. (Rs.) Cr. (Rs.)
Cash in hand 1,00,000
B/R 10,000
S.Debtors 40,000
Patents 20,000
Plant 30,000
S.Creditors 50,000
B/R 50,000
Capital 1,00,000