Accounting Only in Tally Prime




Excise Sum: 1

The following would be recorded in journal using double entry system. Do the posting process from journal and prepare the Trial balance and trading account and profit &loss account and balance sheet in the books of M/S Siva Park for the following financial year of 1.4.2010 to 31.3.2011.

Particulars RS Particulars RS
Cash 50000 Capital 300000
Furniture 30000 Reserves 20000
Building 60000 Bills payable 10000
Free hold property 50000 Bank O/d 5000
SBI bank 80000 Prepaid expenses 12000
Machinery 50000 Typewriter 7000
Sundry Debtors
Nandhu & Co was Rs.1000 Bill no. RM45
Sundry Creditors
SMR & Co was Rs.5000 Bill no.GH34

Transaction During the Period:

  • Apr 01 Bought goods from M/S VINE & CO was Rs.50000 Bill No.TN54
  • Apr 15 Paid Telephone charges Rs.500
  • Apr 17 Issue debit note against to M/S SMR & CO was Rs.5000
  • Apr 19 Credit note received from M/S Nandhu&CO was Rs.1000
  • Apr 21 Goods sold to M/S Maran& CO was Rs.110000
  • Apr 23 Cash withdraw from bank Rs.50000
  • Apr 28 Amount withdraw from personal use Rs.1000
  • May 02 Received interest Rs. 20000
  • May 05 Bank loan received Rs.1000
  • June 01 Bank O/D settled Rs.300
  • June 08 Stolen of typewriter Rs.1000
  • Aug 28 Discount received Rs.10000
  • Sep 01 Paid stationery 500
  • Sep 05 Cash deposit in to bank Rs.2000
  • Sep 08 Salary due Rs1000
  • Sep 20 Withdraw from bank Rs 500
  • Sep 25 Paid wages by cheque Rs.500
  • Oct 01 Divided received Rs.1000
  • Oct 05 Paid water charges Rs.100
  • Oct 20 Paid electrical charges RS.200

Answer

Opening Balance 340000
Gross Profit 63500
NetProfit 91200
Balance Sheet 476900

Create a New Company

  • Go to the Gateway of Tally.
  • Select "Create Company" or "Company Info" (exact wording may vary based on your version).

Enter Company Details:

Fill in the details for M/S Siva Park.

  • Company Name: M/S Siva Park
  • Address: [Enter the company's address]
  • Financial Year: April 1, 2010, to March 31, 2011
  • Books Beginning from: April 1, 2022
  • Country: [Select the country]
Company Create

Go to Gateway of Tally:

  • Navigate to the Gateway of Tally by pressing G or clicking on the Gateway of Tally icon.

Create Ledgers:

  • From the Gateway of Tally, go to "Create".
  • Select "Ledgers" under "Accounts Info."

Create Cash Ledger:

  • Create a ledger for Cash with the opening balance of Rs. 50,000.

Create Capital Ledger:

  • Create a ledger for Capital with the opening balance of Rs. 300,000.

Create Furniture Ledger:

  • Create a ledger for Furniture with the opening balance of Rs. 30,000.

Create Reserves Ledger:

  • Create a ledger for Reserves with the opening balance of Rs. 20,000.

Create Building Ledger:

  • Create a ledger for Building with the opening balance of Rs. 60,000.

Create Bills Payable Ledger:

  • Create a ledger for Bills Payable with the opening balance of Rs. 10,000.

Create Freehold Property Ledger:

  • Create a ledger for Freehold Property with the opening balance of Rs. 50,000.

Create Bank O/D Ledger:

  • Create a ledger for Bank O/D with the opening balance of Rs. 5,000.

Create SBI Bank Ledger:

  • Create a ledger for SBI Bank with the opening balance of Rs. 80,000.

Create Prepaid Expenses Ledger:

  • Create a ledger for Prepaid Expenses with the opening balance of Rs. 12,000.

Create Machinery Ledger:

  • Create a ledger for Machinery with the opening balance of Rs. 50,000.

Create Typewriter Ledger:

  • Create a ledger for Typewriter with the opening balance of Rs. 7,000.

Create Sundry Debtors Ledger (Nandhu & Co):

  • Create a ledger for Sundry Debtors - Nandhu & Co with the opening balance of Rs. 1,000.

Create Sundry Creditors Ledger (SMR & Co):

  • Create a ledger for Sundry Creditors - SMR & Co with the opening balance of Rs. 5,000.

Save and Exit:

  • Save the ledger entries.
  • To use the default ledger, press page up button.
  • Company Create

Select Chart of Accounts:

  • Under the "Display" menu, choose "Account Books" and then select "Ledgers" or "Group Summaries."
  • Company Create

Select Trial Balance:

  • Under the "Display" menu, choose "Trial Balance." You can do this by pressing T or by navigating to "Display" -> "Trial Balance."
  • Company Create


Apr 01 Bought goods from M/S VINE & CO was Rs.50000 Bill No.TN54.

Go to Gateway of Tally:

  • You'll start at the Gateway of Tally, which is the main screen.

Access Accounts Information:

  • From the Gateway of Tally, go to "Transaction" or press V to directly access Vouchers.

Select Voucher Type:

  • Choose the appropriate voucher type. Since you want an accounting-only entry, select "F9: Purchase" as the As Voucher type.

Enter Purchase Entry Details:

  • In the Purchase Voucher screen:
    • Date: Set the date to April 01.
    • Party A/c Name: Select or create the ledger for M/S VINE & CO.
    • Under: Choose the appropriate group for the party (like Sundry Creditors).
    • Amount: Enter Rs. 50,000.
    • Bill No.: Enter TN54 in the Bill No. field.
    • Narration: Enter a brief description, such as "Goods purchased from M/S VINE & CO, Bill No. TN54."

Debit and Credit Accounts:

  • Debit the account representing the goods purchased (e.g., "Purchase Account" under "Goods Purchases") with Rs. 50,000.
  • Credit the account representing the party (e.g., "M/S VINE & CO" under "/b>Sundry Creditors") with Rs. 50,000.

Save the Voucher:

  • Press Ctrl + A to save the Purchase Voucher.
  • Company Create


Apr 15 Paid Telephone charges Rs.500

Go to Gateway of Tally:

  • You'll start at the Gateway of Tally, which is the main screen.

Access Accounts Information:

  • From the Gateway of Tally, go to "Transaction" or press V to directly access Vouchers.

Select Payment Type:

  • Choose "F5: Payment" to create a Payment Voucher.

Enter Voucher Details:

  • In the Payment Voucher screen:
    • Date: Set the date to April 15.
    • Party A/c Name: Select or create the ledger for Telephone Charges.
    • Under: Choose the appropriate group for the party (e.g., "Indirect Expenses").
    • Amount: Enter Rs. 500.
    • Payment Mode: Select "Cash" if you are paying in cash.

Debit and Credit Accounts:

  • Debit the account representing the expense (e.g., "Telephone Charges") with Rs. 500..
  • Credit the account representing the payment (e.g., "Cash" or your cash ledger) with Rs. 500.

Save the Voucher:

  • Press Ctrl + A to save the Payment Voucher.
  • Company Create

  • follow the above steps for the transaction below.
    • Apr 28 Amountwithdraw from personal use Rs.1000
    • Sep 01 Paid stationery Rs.500
    • Sep 25 Paid Wages by Cheque Rs.500
    • Oct 05 Paid Water Charges Rs. 100
    • Oct 20 Paid Electrical charges Rs. 200

Apr 17 Issue debit note against to M/S SMR & CO was Rs.5000

Go to Gateway of Tally:

  • You'll start at the Gateway of Tally, which is the main screen.

Access Accounts Information:

  • From the Gateway of Tally, go to "Transaction" or press V to directly access Vouchers.

Select Debit Note Voucher:

  • Choose "Alt + F5: Debit Note" to create a Debit Note Voucher

Enter Voucher Details:

  • In the Debit Note Voucher screen:
    • Date: Set the date to April 17.
    • Party A/c Name: Select or create the ledger for "M/s SMR & Co.".
    • Under: Choose the appropriate group for the party (like "Sundry Creditors").
    • Amount: Enter Rs. 5000.
    • Narration: Enter a brief description, such as "Debit Note against M/s SMR & Co."

Debit and Credit Accounts:

  • Debit the account representing the party (e.g., "M/s SMR & Co.") with Rs. 5000.
  • Credit the account representing the return (e.g., "Purchase Return") with Rs. 5000.

Save the Voucher:

  • Press Ctrl + A to save the Debit Note Voucher.
  • Company Create


Apr 19 Credit note received from M/S Nandhu&CO was Rs.1000

Go to Gateway of Tally:

  • You'll start at the Gateway of Tally, which is the main screen.

Access Accounts Information:

  • From the Gateway of Tally, go to "Transaction" or press V to directly access Vouchers.

Select Debit Note Voucher:

  • Choose "Alt + F6: Credit Note" to create a Credit Note Voucher.

Enter Voucher Details:

  • In the Debit Note Voucher screen:
    • Date: Set the date to April 19.
    • Party A/c Name: Select or create the ledger for "M/s Nandhu & Co."
    • Under: Choose the appropriate group for the party (like "Sundry Debtors").
    • Amount: Enter Rs. 1000.
    • Narration: Enter a brief description, such as "Credit Note received from M/s Nandhu & Co."

Debit and Credit Accounts:

  • Debit the account representing the party (e.g., "M/s Nandhu & Co.") with Rs. 5000.
  • Credit the account representing the return (e.g., "Sales Return") with Rs. 5000.

Save the Voucher:

  • Press Ctrl + A to save the Debit Note Voucher.
  • Company Create


Apr 21 Goods sold to M/S Maran& CO was Rs.110000

Go to Gateway of Tally:

  • You'll start at the Gateway of Tally, which is the main screen.

Access Accounts Information:

  • From the Gateway of Tally, go to "Transaction" or press V to directly access Vouchers.

Select Debit Note Voucher:

  • Choose "F8: Sales" to create a Sales Voucher

Enter Voucher Details:

  • In the Debit Note Voucher screen:
    • Date: Set the date to April 21.
    • Party A/c Name: Select or create the ledger for "M/S Maran & Co."
    • Under: Choose the appropriate group for the party (like "Sundry Debtors").
    • Amount: Enter Rs. 110,000.
    • Narration: Enter a brief description, such as "Goods sold to M/S Maran & Co."

Debit and Credit Accounts:

  • Debit the account representing the party (e.g., "M/S Maran & Co.") with Rs. 5000.
  • Credit the account representing the return (e.g., "Sales") with Rs. 5000.

Save the Voucher:

  • Press Ctrl + A to save the Debit Note Voucher.
  • Company Create


Apr 23 Cash withdraw from bank Rs.50000

Go to Gateway of Tally:

  • You'll start at the Gateway of Tally, which is the main screen.

Access Accounts Information:

  • From the Gateway of Tally, go to "Transaction" or press V to directly access Vouchers.

Select Debit Note Voucher:

  • Choose "F4: Contra" to create a Contra Voucher.

Enter Voucher Details:

  • In the Debit Note Voucher screen:
    • Date: Set the date to April 23.
    • Debit Account: Select the account to be debited (e.g., "Cash").
    • Amount: Enter Rs. 50,000.
    • Credit Account: Select the account to be credited (e.g., "SBI Bank").
    • Narration: Enter a brief description, such as "Cash withdrawal from SBI Bank."

Save the Voucher:

  • Press Ctrl + A to save the Debit Note Voucher.
  • Company Create

  • follow the above steps for the transaction below.
    • June 01 Bank O/D settled Rs.300
    • Sep 05 Cash deposit in to bank Rs.2000
    • Sep 20 Withdraw from bank Rs.500

May 02 Received interest Rs. 20000

Go to Gateway of Tally:

  • You'll start at the Gateway of Tally, which is the main screen.

Access Accounts Information:

  • From the Gateway of Tally, go to "Transaction" or press V to directly access Vouchers.

Select Debit Note Voucher:

  • Choose "F6: Receipt" to create a Receipt Voucher.

Enter Voucher Details:

  • In the Debit Note Voucher screen:
    • Date: Set the date to May 02.
    • Received From: Enter the name of the party from whom you received the interest.
    • Under: Choose the appropriate group for the party (e.g., "Sundry Creditors").
    • Amount: Enter Rs. 20,000.
    • Credit Account: Select the ledger for "Received Interest."
    • Narration: Enter a brief description, such as "Received interest for May."

Save the Voucher:

  • Press Ctrl + A to save the Debit Note Voucher.
  • Company Create

  • follow the above steps for the transaction below.
    • May 05 Bank Loan Received Rs.1000
    • Aug 28 Discount Received Rs.10000
    • Oct 01 Divided received Rs.1000

June 08 Stolen of typewriter Rs.1000

Go to Gateway of Tally:

  • You'll start at the Gateway of Tally, which is the main screen.

Access Accounts Information:

  • From the Gateway of Tally, go to "Transaction" or press V to directly access Vouchers.

Select Debit Note Voucher:

  • Choose "F7: Journal" to create a Journal Voucher.

Enter Voucher Details:

  • In the Debit Note Voucher screen:
    • Date: Set the date to June 08.
    • Debit Account: Select the account representing the loss or expense (e.g., "Stolen Expense" or "Loss on Theft").
    • Amount: Enter Rs. 1000.
    • Credit Account: Select the account representing the typewriter (e.g., "Typewriter").
    • Narration: Enter a brief description, such as "Stolen of typewriter worth Rs. 1000."

Save the Voucher:

  • Press Ctrl + A to save the Debit Note Voucher.
  • Company Create


Profit and Loss

Go to Gateway of Tally:

  • You'll start at the Gateway of Tally, which is the main screen.

Access Reports:

  • From the Gateway of Tally, go to "Reports" by selecting it from the main menu.

Financial Reports:

  • Under "Reports," navigate to "Profit & Loss" in the "Financial Reports" section.
Company Create


Balance Sheets

Go to Gateway of Tally:

  • You'll start at the Gateway of Tally, which is the main screen.

Access Reports:

  • From the Gateway of Tally, go to "Reports" by selecting it from the main menu.

Financial Reports:

  • Under "Reports," navigate to "Balance Sheet" in the "Financial Reports" section.
Company Create

Tally Prime