LORD JEGANNATH COLLEGE OF ENGINEERING AND TECHNOLOGY

PSN Nagar, Ramanathichanputhur, Kumarapuram Thoppur Post-629 402

Kanyakumari District, Tamil Nadu
(Approved by AICTE and Affiliated to Anna University, Chennai)
(Accredited with ‘A’ Grade by NAAC)

RECORD NOTEBOOK

MC4104 - FUNDAMENTALS OF ACCOUNTING

SEMESTER II

2024-2025
ACADEMIC YEAR : 2023-2024

NAME : ……………………………………

[Link] : ……………………………….……
 LORD JEGANNATH COLLEGE OF ENGINEERING AND TECHNOLOGY
PSN Nagar, Ramanathichanputhur, Kumarapuram Thoppur Post-629 402
Kanyakumari District, Tamil Nadu
(Approved by AICTE and Affiliated to Anna University, Chennai)
(Accredited with ‘A’ Grade by NAAC)

MASTER OF COMPUTER APPLICATIONS

LABORATORY RECORD NOTEBOOK

2023 – 2024

This is to certify that this is a bonafide record of the Practical work done by

Mr./Ms.: _______________________________ Register Number: ___________________________

studying ______ Semester ________ Degree programme in the Department of COMPUTER

APPLICATIONS for the Course _____________________________________________.

Course-in-Charge Head of the Department

Submitted for the University Examination held on ………………………..

Internal Examiner External Examiner

 CONTENTS
Ex. Date of Course
Name of the Experiment Page No.
No.: Experiment In-charge Sign.
 PROGRAM NO: 1
DATE:

COMPANY CREATION, COMPANY GROUP

AIM
To create company creation, company group using Tally.

1. COMPANY CREATION DATABASE

Company Name : Arul Traders

Address : Rc Street, Kaliakkavilai
E-Mail : Arul @ [Link]
Income Tax Number 8675431
Local Sales tax Number : RC NO: 273672/dt.1.4.2006
Interstate Sales Tax : -----------
Currency : Rs.
Maintain : Accounts Only
Financial Year From : 1.4.2006
Books Beginning From : 1.4.2006

PROCEDURE

New Ledger Creation

Gateway of Tally  Accounts Info Ledger  Single Ledger Create

Type the Ledger Name.

1. Capital A/c of Shankar - Capital Account

Opening Balance Rs. 1,00,000 Cr
2. Loan from Ramu - Loans (Liability)
Opening Balance Rs. 20,000 Cr
3. Loan from I.O.B - Bank OD/OCC Account
 Opening Balance Rs. 50,000 Cr
4. Furniture and Fittings - Fixed Assets
Opening Balance Rs. 15,000 Dr
5. Shop Advance - Loans and Advance
Opening Balance Rs. 50,000 Dr
6. Telephone Deposit - Deposit
Opening Balance Rs. 3,000 Dr

It should be noted that Tally automatically creates two ledger accounts, viz, cash (Under Cashin
Hand) and Profit & Loss Account (Direct primary account)

7. To enter our Cash Balance

1. Gateway of Tally Accounts Info  Ledgers  Single Ledgers  Alter  Select
Cash Enter our Opening Balance Rs. 1,02,000

OUTPUT

Particulars Liabilities Cr Assets Dr

Capital A/c for Shankar 100000

Loan from Ramu 20000

Loan from I.O.B 50000

Furniture and Fittings 15000

Shop Advance 50000

Telephone Deposit 3000

Cash 102000

170000 170000
 2. COMPANY GROUP CREATION

F3: Company Information

Select Create Company
Enter following details
Company Name : Rajan Co
Address :Manjalumoodu
E-Mail : rajan @ [Link]
Income Tax Number 8675433
Local Sales tax Number : RC NO: 273672/dt.1.4.2007
Interstate Sales Tax : -----------
Currency : Rs.
Maintain : Accounts Only
Financial Year From : 1.4.2006
Books Beginning From : 1.4.2006

OUTPUT

Particulars Liabilities Cr Assets Dr

Capital A/c for Shankar 100000

Loan from Ramu 20000

Loan from I.O.B 50000

Furniture and Fittings 15000

Shop Advance 50000

Telephone Deposit 3000

Cash 102000

170000 170000
Result

The company is created with name Arul Traders and based on the given information
the balance sheet and group creation has been prepared successfully.
PROGRAM NO: 2
DATE:

CREATION OF LEDGERS AND VOUCHERS

AIM
To create Ledgers and Vouchers using Tally.

COMPANY DATABASE
Babu Stores & Co, Main Road, Marthandam
E- Mail address : Babu_co @ [Link]
Income tax number : 3634546
Local Sales Tax Number : TN 5432/2006
Financial Year from : 1-4-2006
Book beginning date : 1-4-2006
Maintain : Accounts only

Trial Balance Sheet of a Company

Particulars Dr Cr
Capital A/c of Mr. Xavier 3,00,000
Drawings 25,000
TMB term loan 37,500
Land & Building 1,25,000
Motor Van 52,000
Plant & Machinery 1,08,000
Ganesh Stores 15,000
Nalaperumal Agency 25,000
Ashok 12,000
Rajesh 10,000
Vinod Agency 25,000
Purchase 60,000
Sales 56,000
Stock of Goods 29,000
 Commission Received 18,600
Brokerage Paid 6,200
Traveling Expenses 1,100
Salaries 6,000
General Expenses 1,150
Cash 15,650
4,64,100 4,64,100

Procedure
F3: Company Information
Select Create Company
Enter the company details
New Ledger Creation
Gateway of Tally Accounts Info Ledger Single Ledger Create
Type the Ledger Name
To enter our Cash Balance
1. Gateway of Tally Accounts Info Ledgers Single Ledgers Alter SelectCash
Enter our Opening Balance Rs. 15650

Particulars Group Dr Cr
Capital A/c of Mr. Xavier Capital Ac 3,00,000
Drawings Capital Ac 25,000
TMB term loan Bank OCC A/c 37,500
Land & Building Fixed Assets 1,25,000
Motor Van Fixed Assets 52,000
Plant & Machinery Fixed Assets 1,08,000
Ganesh Stores Sundry Creditors 15,000
Nalaperumal Agency Sundry Creditors 25,000
Ashok Sundry Creditors 12,000
Rajesh Sundry Debtors 10,000
 Vinod Agency Sundry Debtors 25,000
Purchase Purchase 60,000
Sales Sales 56,000
Stock of Goods Stoct of Goods 29,000
Commission Received Indirect Income 18,600
Brokerage Paid Indirect Expense 6,200
Traveling Expenses Indirect Expense 1,100
Salaries Indirect Expense 6,000
General Expenses Indirect Expense 1,150
Cash Indirect Expense 15,650
4,64,100 4,64,100

Result
The company is created with name Babu Stores & Co, Main Road, Marthandam and based
on the given information trial sheet and balance sheet has been prepared successfully.
 2. Journalise the following transactions under Xavier Stores
Voucher Creation
Cash in Hand 50,000
Capital 50,000
Date Transactions Amount
1.8.2006 Bought goods for Cash 3000.00
1.8.2006 Bought goods for Cash 2000.00
2.8.2006 Bought goods for Cash 1000.00
2.8.2006 Bought goods from Pothys 5000.00
2.8.2006 Bought goods from Nalli 7200.00
2.8.2006 Bought goods for Cash 5400.00
1.8.2006 Sold goods for Cash 4200.00
2.8.2006 Sold goods for Cash 5600.00
1.9.2006 Sold goods to Najma 4250.00
1.9.2006 Sold goods to Chandrika 2350.00
1.10.2006 Bought goods for Cash 2100.00
1.10.2006 Sold goods for Cash 6300.00
2.10.2006 Bought goods from Pothys 2200.00
2.10.2006 Sold goods to Najma 4200.00
2.10.2006 Sold goods for Cash 2100.00
1.11.2006 Cash Received for Najma 4000.00
1.11.2006 Cash Paid to Pothys 1500.00
1.12.2006 Commission Paid 210.00
1.12.2006 Paid General Expenses 550.00
2.12.2006 Paid Salaries 1100.00
Procedure:
Select Create Company Enter
the company details
Name Xavier Stores with needed details

New Ledger Creation

Gateway of Tally Accounts Info Ledger Single Ledger Create
Type the Ledger Name

Ledgers Group
Purchase Purchase
Pothys Sundry Creditors
Nalli Sundry Creditors
Sales Sales
Najma Sundry Debtors
Chandrika Sundry Debtors
Commission Paid Indirect Expense
Paid General Expenses Indirect Expense
Paid Salaries Indirect Expense
Capital Capital A/c

To enter our Cash Balance

1. Gateway of Tally Accounts Info Ledgers Single Ledgers Alter SelectCash
Enter our Opening Balance Rs. 50000
Enter the voucher
1) Gateway of tally -> Voucher entry -> Accounting vouchers
Date Transactions Voucher Type Amount
1.8.2006 Bought goods for Cash F9 Purchase 3000.00
1.8.2006 Bought goods for Cash F9 Purchase 2000.00
2.8.2006 Bought goods for Cash F9 Purchase 1000.00
2.8.2006 Bought goods from Pothys F9 Purchase 5000.00
2.8.2006 Bought goods from Nalli F9 Purchase 7200.00
2.8.2006 Bought goods for Cash F9 Purchase 5400.00
1.8.2006 Sold goods for Cash F8 Sales 4200.00
2.8.2006 Sold goods for Cash F8 Sales 5600.00
1.9.2006 Sold goods to Najma F8 Sales 4250.00
1.9.2006 Sold goods to Chandrika F8 Sales 2350.00
1.10.2006 Bought goods for Cash F9 Purchase 2100.00
1.10.2006 Sold goods for Cash F8 Sales 6300.00
2.10.2006 Bought goods from Pothys F9 Purchase 2200.00
2.10.2006 Sold goods to Najma F8 Sales 4200.00
2.10.2006 Sold goods for Cash F8 Sales 2100.00
1.11.2006 Cash Received for Najma F6 Receipt 4000.00
1.11.2006 Cash Paid to Pothys F5 Payment 1500.00
1.12.2006 Commission Paid F5 Payment 210.00
1.12.2006 Paid General Expenses F5 Payment 550.00
2.12.2006 Paid Salaries F5 Payment 1100.00

Result
The Voucher of given transaction under Xavier stores has been done successfully.
PROGRAM NO: 3
DATE:

POSTING INTO THE JOURNAL

● Go to Gateway of Tally > Accounting Vouchers.

● Click on F7: Journal on the Button Bar or press F7 .

For example, there may be entries made for interest accrued or interest due. If
you have to receiveInterest from a party, the same can be entered using Journal
Voucher.
● Debit the Party.
● Credit the Interest Receivable [Link]

Journal entry is displayed as shown below:

PROGRAM NO: 4
DATE:

CREATION OF LEDGER

 Step 1: Use the following path to create ledger accounts in Tally

Gateway of Tally → Accounts Info → Ledgers → Single Ledger →

Choose Create

 Step 2: Click on Accounts Info under Gateway of Tally screen.

 Step 3: Choose ledger option account info

 Step 4: Under Single Ledger, choose the option Create

 Step 5: Update the following details on Ledger

creation [Link]: Specify the unique name

of the ledger account.

Under: Under List of Groups, choose the group name that pertains to the ledger account.
PROGRAM NO: 5
DATE:

RECEIPTS

 Go to Gateway of Tally > Accounting Vouchers.

 Select F6: Receipt from the button bar or press F6.
 For example, if your company receives money from a customer for an earlier
 Transaction says sales, andthe same is passed through a Receipt Voucher:
 Credit the customer account and debit the Cash account, if you receive cash or
 Debit the Bank account where you need to deposit the money, if you receive Cheques.
The entry in double-entry mode is displayed as shown:
PROGRAM NO: 6
DATE:

PAYMENT VOUCHER

 Go to Gateway of Tally > Accounting Vouchers.

 Select F5: Payment from the Button Bar or press F5.

o Payment voucher can be passed using Single Entry or Double Entry mode by

configuring the setting Use Single Entry mode for Paymt/Rcpt/Contra in F12: Configure.
To use Auto Cheque Numbering during Bank Allocation the following options in F12:
Configure hasto be enabled:
● Use Auto Cheque Numbering
 Allow Selection of Cheque Range

o Record a Payment voucher for the following:

The Company settles a Creditor’s bill (Purchase) via Cheque. This entry can be passed in
single entrymode where you will be crediting the Bank Ledger (for which Cheque Books has
been configured) and debiting the Party Ledger, as shown:
 In the Bank Allocation screen
● The Nickname will appear as defined in the Provide Bank Details during the
ledgercreation.
● The Favouring Name and Amount fields are prefill based on the Payment entry
recorded.
● The Transaction Type is set to Cheque by default. This can be changed
based onrequirement.
● For Transaction Type – Cheque:
o User can choose a Cheque Range (Cheque Books) from the list of Cheque
booksdefined for the bank, in the Cheque Range field.
o The Cheque Number will be automatically filled in the Instrument Number
field. Userstill has the option to manually change the Cheque Number, if
required.
Multiple allocations can be done in Bank Allocation screen as shown:
o For each allocation, a different range can be chosen or the same cheque
range can be chosen. When thesame range is chosen, the subsequent
cheque numbers will be automatically filled in Instrument Number field.

o Once Bank Allocations are done, accept the Payment voucher by pressing Y
or Enter, or by clickingon Yes.
PROGRAM NO: 7
DATE:

CONTRA VOUCHER

 Go to Gateway of Tally > Accounting Vouchers

● Select F4: Contra from the Button Bar or press F4 .

For example, to transfer funds from Cash Account to Bank Account:

● Debit the Bank Account.
● Credit the Cash Account.
The entry will be displayed as shown:

 In the Bank Allocation screen, users can select the mode of transaction from the
List of TransactionType as shown:
 When Cash is selected as a Transaction Type , you can specify the cash
denominations for the transaction in the voucher entry screen, if the option Show
Cash Denomination Details set to Yes in F12: Configurati on (By default, this option
is enabled)
 During Bank Allocation, a new screen – Cash Denominations will appear for Cash
Transaction Type.
PROGRAM NO: 8
DATE:
PURCHASE VOUCHER

1. Go to Gateway of Tally > Accounting Vouchers.

2. In the Voucher Creation screen select F9: Purchase.

3. Select As Invoice.

4. Enter the current date and reference.

5. Select the Party to be credited from the List of Ledger Accounts in Party’s A/c name.

6. Select the required Purchase Ledger from the List of Ledger Accounts.

7. Select an item from the Stock Items List of Items. On selecting the Item, an Item

Allocations subscreen for the selected Item is displayed as shown.

8. Select the Godown and specify the quantity to be allocated under the Quantity field.
9. Enter the Quantity and Rate , and the amount is automatically displayed in the Amount field.
10. Select another Godown and follow the similar procedure for Item allocation.
11. Enter Narration if required and accept to save
The completed Accounting Voucher screen appears as shown below:

12. Enter Narration , if required.

13. Press Enter to save the transaction.
PROGRAM NO: 9
DATE:
SALES VOUCHER

1. Go to Gateway of Tally > Accounts Info. or Inventory Info. > Voucher Type > Create.

2. Enter the Name of the voucher.

3. Select the type of voucher as Sales.

4. Enter the abbreviation in the Abbreviation field, if required.

5. Select the Method of voucher numbering from the Methods of Numbering list, which

appears asshown below:

[Link] Use effective dates for vouchers to enter effective dates for vouchers.

7. Enable Make this voucher type 'Optional' by default to set your voucher to optional
voucher bydefault.

8. Enable Allow narration in voucher to give a common narration for voucher. A common
narrationscreen for voucher appears as shown below
9. Enable Provide narration for each ledger in voucher? if you want to give a separate
narration for each entry of a voucher. This would be applicable for a multiple entry
voucher where you want separate details for each entry. The narrations for each entry
appears as shown below:
10. Enable Print voucher after saving to print every voucher after entering it.

11. Set Use for POS invoicing to Yes to use the sales invoice as POS invoice.

12. Set the Default title to print on invoice to print the same title for POS invoice.

13. Select the bank in Default bank option to print the default bank ledger when the
option PrintBank Details is enabled in a Sales voucher.

14. Enter the Default jurisdiction to be printed on the invoice, if required.

15. Create a voucher class in the Name of Class field, if required.

The completed Voucher Type Creation screen appears as shown below:

16. Press Enter to save.
PROGRAM NO: 10
DATE:
TRIAL BALANCE

 Go to Gateway of Tally > Display > Trial Balance .

 The Trial Balance appears as shown below:

2. Press F12 to configure the Trial Balance , as required.

3. Press Ctrl+A to accept.
Configuration options in Trial
Balance

The Trial Balance shows the flow of the accounts from the opening balance to the effect of
transactions on the closing balance.

 Press F12 to configure. The Configuration screen appears as shown below:

After the configurations have been set, the Trial Balance appears as shown below:
PROGRAM NO: 11
DATE:
PROFIT AND LOSS ACCOUNT

1. Go to Gateway of Tally > Display > Profit & Loss A/c.

2. Click F1: Detailed to view the Profit & Loss Account in detailed format. The Profit &
LossAccount appears as shown below:

The Profit & Loss Account is generated and updated immediately from the date of opening of
books till the date of last entry.

3. Press F2: Period to change the period as required.

The Profit & Loss A/c is in horizontal form, by default. You can view the report in
vertical format by enabling the option Show Vertical Profit & Loss? By clicking F12:
Configure. You can view additional information or toggle to another report using the
options available in the button bar.
4. Click S : Schedule VI in the Schedule VI Profit & Loss A/c, as shown below:
PROGRAM NO: 12
DATE:
BALANCE SHEET
1. Go to Gateway of Tally > Display > Balance Sheet.

2. Press F12 to configure the Balance Sheet.

3. Press Ctrl+A to accept.