Tally Assignments
Assignment 1
Create a company in Tally ERP 9 with following details:
Company Name: Nova Tech Solution Pvt Ltd
Address: 47 Sunrise Avenue, Maharashtra, India
Financial Year: 01-04-2024
Book Beginning From: 01-04-2024
Create last year closing ledger as per given details:
Nova Tech Solution Pvt Ltd
Balance sheet
1-April-2024 to 31-March-2025
Liabilities Amount Assets Amount
Capital 600000 Plant & Machinery 395000
Loan from HDFC Bank 250000 Furniture 110000
Outstanding Salary 40000 Building 240000
Sundry Creditors 70000 Cash 20000
Profit & Loss Account 190000 Investment in Shares 180000
Axis Bank 60000
Sundry Debtors 95000
Closing Stock 50000
Total 1150000 Total 1150000
Details of Creditors:
Creditor Name Bill No. Bill Date Amount
Galaxy Traders GT-201 10-12-2023 40000
Future Suppliers Co. FS-909 18-03-2024 30000
Details of Debtors:
Debtor Name Bill No. Bill Date Amount
Techno World Ltd. TW-445 20-01-2024 55000
Sparkline SD-672 15-02-2025 40000
Distributors
1
SOLUTION: -
STEP 1: Create company
1) Open Tally ERP 9
2) Gateway of Tally
3) Go to Company (Alt + K)
4) Create Company Enter Details:
• Company Name: Nova Tech Solution Pvt Ltd
• Mailing Name: Nova Tech Solution Pvt Ltd
• Address: 47 Sunrise Avenue, Maharashtra
• Country: India
• Financial Year: 01-04-2024
• Book Beginning From: 01-04-2024
• Currency: INR
5) Press Enter and Save
STEP 2: Create Ledgers
1) Gateway of Tally
2) Select Create
3) Select Ledger
Liabilities Ledgers: -
Ledger Name Under group Opening balance
Capital Account Capital Account 600000
Loan from HDFC Bank Secured Loans 250000
Outstanding Salary Current Liabilities 40000
Sundry Creditors Sundry Creditors 70000
Profit & Loss Account Profit & Loss Account 190000
Assets Ledgers: -
Ledger Name Under group Opening balance
Plant & Machinery Fixed Assets 395000
Furniture Fixed Assets 110000
Building Fixed Assets 240000
Cash Cash-in-Hand 20000
2
Investment in Shares Investments 180000
Axis Bank Bank Accounts 60000
Sundry Debtors Sundry Debtors 95000
Closing Stock Stock-in-hand 50000
STEP 3: Create Sundry Creditors with Bills
1) Gateway of Tally
2) Select Create
3) Select Ledger
1. Galaxy Traders (under sundry creditors)
• Bill No.: GT-201
• Bill Date: 10-12-2023
• Amount: 40000
2. Future suppliers Co. (under sundry creditors)
• Bill No.: FS-909
• Bill Date: 18-03-2024
• Amount: 30000
STEP 4: Create Sundry Debtors with Bills
1. Techno World Ltd. (under sundry Debtors)
• Bill No.: TW-445
• Bill Date: 20-01-2024
• Amount: 55000
2. Sparkline Distributors (under sundry Debtors)
• Bill No.: SD-672
• Bill Date: 15-02-2025
• Amount: 40000
STEP 5: Verify Balance Sheet
1) Gateway of Tally
2) Select Balance Sheet
3
4
Assignment 2
Create a Company BrightFuture Technologies Pvt Ltd and do the following
transactions:
SL No.1 Date Transactions
1 2/5/2024 Ms. Ananya Sharma started business with cash
₹7,50,000.
2 4/5/2024 Deposited ₹5,00,000 into ICICI Bank account.
3 6/5/2024 Bought a laptop for ₹40,000 in cash.
4 8/5/2024 Paid office rent of ₹10,000 in cash.
5 11/5/2024 Purchased cupboard ₹12,000 and desk ₹6,000 on
credit from Star Furniture.
6 14/5/2024 Paid telephone bill ₹1,200 in cash.
7 15/5/2024 Received service income of ₹20,000 in cash.
SOLUTION: -
STEP 1: Create company
1) Open Tally ERP 9
5
2) Gateway of Tally
3) Go to Company (Alt + K)
4) Create Company Enter Details:
• Company Name: BrightFuture Technologies Pvt Ltd
• Mailing Name: BrightFuture Technologies Pvt Ltd
• Address: 2 Digital Park, Bengaluru, Karnataka
• Country: India
• Financial Year: 01-04-2024
• Book Beginning From: 01-04-2024
• Currency: INR
5) Press Enter and Save
STEP 2: Create Ledgers
1) Gateway of Tally
2) Select Create
3) Select Ledger
Create the following Ledgers:
Ledger Name Under Group
Cash Cash-in-Hand
Capital Capital Account
ICICI Bank Bank Account
Cupboard Fixed Account
Rent Indirect Expense
Laptop Fixed Account
Desk Fixed Account
Star Furniture Sundry creditors
Telephone Expenses Indirect Expenses
Service Income Indirect Expenses
Journal Entries: -
1. Gateway of Tally
2. Select Vouchers
3. Select Receipt Voucher (F6)
6
Entry 1
Debit: Cash A/c ---------- 750000
Credit: Capital A/c ---------- 750000
Narration: Being business started with cash investment.
4. Select Contra Voucher (F4)
Entry 2
Debit: ICICI Bank A/c ---------- 500000
Credit: Cash A/c ----------------------500000 Narration:
Being cash deposited into bank.
5. Select Payment Voucher (F5)
Entry 3
Debit: Laptop A/c ---------- 40000
Credit: Cash A/c ---------------- 40000 Narration:
Being purchased laptop in cash.
6. Select Payment Voucher (F5) Entry 4
Debit: Rent A/c ----------- 10000
Credit: Cash A/c---------------10000 Narration:
Being paid office rent.
7. Select Journal Voucher (F7)
Entry 5
Debit: Cupboard A/c----------12000
Desk A/c----------6000
Credit: Star Furniture A/c----------- 18000 Narration:
Being furniture purchase on credit.
8. Select Payment Voucher (F5)
Entry 6
Debit: Telephone Expenses A/c----------- ₹1200
Credit: Cash A/c------------ 1200
Narration: Being telephone expenses paid.
9. Select Receipt Voucher (F6) Entry
7
Debit: Cash A/c----------20000
Credit: Service income A/c ---------20000
Narration: Being income earned and received in cash.
STEP 5: Verify Balance Sheet
1) Gateway of Tally
7
2) Select Balance Sheet
Assignment 3
Create a company S K Electronics and do the following task (Accounts with
Inventory).
Stock Category Sub Category Unit Stock Items
8
Mobile Phones Apple Nos iPhone 13, iPhone 14
Xiaomi Pieces Redmi Note 12, Redmi Note
13
Do the following transactions.
Mobile Type Quantity Rate Amount
iPhone 13 15 ₹60000 ₹900000
iPhone 14 10 ₹75000 ₹750000
Redmi Note 12 20 ₹18000 ₹360000
Redmi Note 13 25 ₹22000 ₹550000
In Party’s A/c Name: Create Ledger Singh Distributors under Sundry Creditors &
under purchase ledger create purchase under accounts.
Display Statement of inventory for Apple, Xiaomi, and Mobile Phones.
Solution:-
STEP 1: Create company
1) Open Tally ERP 9
2) Gateway of Tally
3) Go to Company (Alt + K)
4) Create Company Enter Details:
• Company Name: S K Electronics
• Mailing Name: S K Electronics
• Address: 45, Lake View Road, Park Circus, Kolkata
• Country: India
• Financial Year: 01-04-2024
• Book Beginning From: 01-04-2024
• Currency: ₹
5) Press Enter and Save
STEP 2: Create units of measure
1) Gateway of Tally
2) Select Create
3) Select unit
Enter Details: -
Type: Simple
Symbol: Nos
Formal Name: Numbers
9
Unit Quantity Code (UQC): NOS-NUMBERS
Number of decimal places: 0
4) Accept and Save
STEP 3: Create Stock Groups
1) Select Create
2) Select Stock Group
Enter Details: -
Name: Mobile Phones (under primary group) Quantities:
Yes
STEP 4: Create Stock categories
1) Select Create
2) Select Stock Category
Enter Details:- Name:
Apple
Name: Xiaomi
3) Accept and save
STEP 5: Create Stock Items
1) Select Create
2) Select Stock Items
Enter Details:-
Name: iPhone 13 (under mobile phones)
Units: nos
Quantity: 15
Rate: ₹60000
Amount: ₹900000 Enter
and Save
Name: iPhone 14 (under mobile phones)
Units: nos
Quantity: 10
Rate: ₹75000
Amount: ₹750000 Enter
and Save
Name: Redmi Note 12(under mobile phones)
Units: nos
Quantity: 20
10
Rate: ₹18000
Amount: ₹360000 Enter
and Save
Name: Redmi Note 13 (under mobile phones)
Units: nos
Quantity: 25
Rate: ₹22000
Amount: ₹550000
Enter and Save
STEP 6: Create Ledger Accounts
1) Gateway of Tally
2) Select Create
3) Select Ledger
Enter details:-
1. Party Ledger:
• Name: Singh Distributors
• Under: Sundry Creditors
2. Purchase Ledger:
• Name: Purchase
• Under: Purchase Accounts
STEP 7: Record the Purchase
1) Gateway of Tally
2) Select Voucher
3) Select Purchase (F9)
Entry 1: iPhone 13
• Party A/c Name: Singh Distributors
• Purchase Ledger: Purchase
• Stock Item: iPhone 13 o Quantity: 15 o Rate: ₹60000
o Amount: ₹900000
Entry 1: iPhone 14
• Party A/c Name: Singh Distributors
• Purchase Ledger: Purchase
• Stock Item: iPhone 14 o Quantity: 10 o Rate: ₹75000 o
Amount: ₹750000
Entry 1: Redmi Note 12
11
• Party A/c Name: Singh Distributors
• Purchase Ledger: Purchase
• Stock Item: Redmi Note 12
o Quantity: 20
o Rate: ₹18000 o Amount:
₹360000
Entry 1: Redmi Note 13
• Party A/c Name: Singh Distributors
• Purchase Ledger: Purchase
• Stock Item: Redmi Note 13 o Quantity:25 o
Rate: ₹22000
o Amount: ₹550000
12
Database Assignments
Assignment 1
Create a student database with student_Id Primary key.
Stu_ID Stu Name Class Age Fees
S001 Ayesha BA 21 900
S002 Farhan BBA 22 1200
S003 Ritu BCOM 23 1500
S004 Imran BA 20 1000
S005 Sonal BBA 22 1200
Update fees to Rs. 750 for students in BA class.
Solution:-
STEP 1: Create a Database
1) Open MS Access
2) Click on Blank Database
3) Name it and Click Create
STEP 2: Create a table
1) Click on create
2) Click on Table Design
13
3) Add the following fields
Field Name Data Type
Stu_ID Short Text
Stu Name Short Text
Class Short Text
Age Number
Fees Currency
4) Set Stu_ID as the Primary key 5) Save the table with the student.
STEP 3: Enter the Data
1) Open the Student Table in Database view
2) Enter the data
STEP 4: Update fees for BA Students
1) Click on create
2) Click on Query Design
3) Add student table to the query
4) Click on View
5) Click on SQL View and type
UPDATE Student
SET Fees=750
WHERE Class=”BA”
6) Click on Run (Red Exclamation mark)
7) Click on the Students table to confirm fees
14
Assignment 2
Create an Employee Database with EMP_ID as the Primary Key
EMP_ID EMP Name Designation Age Salary
1001 Rina HR 28 52000
1002 Sameer Analyst 35 48000
1003 Ravi HR 38 60000
1004 Sana Analyst 30 45000
1005 Rahul Supervisor 40 50000
1. Show the name starts with S.
2. Find names whose designation is HR.
15
Solution:-
STEP 1: Create a Database
1) Open MS Access
2) Click on Blank Database
3) Name it and Click Create
STEP 2: Create a table
1) Click on create
2) Click on Table Design
3) Add the following fields
Field Name Data Type
EMP_ID Short Text
EMP Name Short Text
Designation Short Text
Age Number
Salary Currency
STEP 3: Enter the Data
1) Open the Student Table in Database view
2) Enter the data
STEP 4: In MS ACCESS
1) Click on create
2) Click on Query Design
3) Add Employee table to the query
4) Click on View
5) Click on SQL View and type
16
6) Click on Run (Red Exclamation mark) 7) Click on the Employee table
to confirm
1. Show the name starts with S.
2. Find names whose designation is HR.
17
STEP 5: In MS EXCEL
1) Open MS Excel
2) Enter the data in the cells
o Apply Filter o Select the first row (A1 to
E1).
o Click on data tab o Click on Filter.
1. Show the name starts with S.
o Click the drop-down arrow in the EMP Name (Column B).
o Select text filters
o Click on Begins with…. o In the box type S o Click OK.
18
2. Find names whose designation is HR.
o Click the drop-down arrow in the Designation (Column C). o In
the drop-down arrow, uncheck all options and check HR. o Click
OK.
19
