The Bhawanipur Education Society College Assignment 2023

Department of Commerce (Morning)

Computerised Accounting System and e-Filing of Tax Return

Assignment 2023
A. Tally
23/02/2023
I. Create a company (Accounting Period – 2022-2023) in Tally Prime by naming it with ‘Student name _
College UID’ (West Bengal, Kolkata – 700040). Enable the necessary features as required in the given
question. Show the Steps of creating company. Also attach printout of the company creation page.

25/02/2023
II. Create the following Accounting Ledgers under the appropriate group. Prepare a table showing Accounting
Ledger under Appropriate Group. Also attach printout of Chart of Accounts of All Ledgers created (Ledger
view).
a. Capital A/c
b. ICICI Bank A/c
c. Furniture A/c
d. Purchase A/c
e. Purchase return A/c
f. Sales A/c
g. Sales Return A/c
h. Infotech Pvt Ltd A/c (Supplier)
i. Suresh A/c (Customer)
j. Ramesh A/c (Customer)
k. Mukesh A/c (Customer)
l. Depreciation A/c
m. Salaries A/c
n. General Expense A/c

27/02/2023
III. Create the following Inventory Masters
a. Units – Pcs (Pieces)
b. Stock Group – Computers
c. Stock Item – HP Computers, Dell Computers, Apple Computers

Page 1 of 10 Computerised Accounting System and e-Filing of Tax Return

 The Bhawanipur Education Society College Assignment 2023
Department of Commerce (Morning)

01/03/2023
IV. Pass the following Accounting Entries under appropriate vouchers. Show the process of recording each
Accounting Entries in the rule page. Attach Print out of the Screenshot where-ever mentioned in the blank
page. Assume all transactions took place on the first day of financial year (1st April’ 2022)
1. Cash introduced into the business – Rs. 5,00,000.
2. Furniture purchased in cash – Rs. 1,00,000.
3. Opened a bank account with ICICI Bank and deposited Rs. 50,000 in cash. (Attach Print out)

03/03/2023
4. Purchased 20 pcs of HP computers from Infotech Pvt. Ltd. @ Rs. 35,000 each on credit (Invoice
number – IPL/0047/2022-23). (Attach Print out)
5. Sold 5 pcs to Suresh @ Rs. 50,000 each on credit. (Attach Print out)
6. Sold 5 pcs to Ramesh @ Rs. 60,000 each on credit, amount payable in three equal monthly
instalments starting from 1st of next month. (Attach Print out of Bill-wise Page)

06/03/2023
7. Received Rs. 60,000 from Suresh via cheque number 270034 drawn on Federal Bank and deposited
into the bank on the same day. (Attach Print out)
8. Placed an order for 30 pcs of HP computers @ Rs. 35,000 to Infotech Pvt. Ltd.
9. Received 20 pcs from Infotech Pvt. Ltd. (Challan number – DC-112).

09/03/2023
10. Received remaining 10 pcs from Infotech Pvt. Ltd. (Challan number – DC-147).
11. Received invoice from Infotech Pvt. Ltd. for the above consignments (Invoice number –
IPL/0089/2022-23). (Attach Print out)
12. Paid to Infotech Pvt. Ltd Rs. 45000 via cheque no. 100001 dated 1 st April’ 2022. (Attach Print out)

11/03/2023
13. Returned 2 pcs of damaged computers to Infotech Pvt Ltd. from the second invoice.
14. Received an order from Mukesh for 6 pcs @ Rs.50000 each. (Attach Print out)
15. Delivered 6 pcs to Mukesh.

13/03/2023
16. Issued bill to Mukesh. (Attach Print out)
17. Paid Salaries Rs. 20,000 in cash.
18. Provide depreciation on furniture Rs. 10,000. (Attach Print out)

Page 2 of 10 Computerised Accounting System and e-Filing of Tax Return

 The Bhawanipur Education Society College Assignment 2023
Department of Commerce (Morning)

15/03/2023
Attach Print out of the Following in Detailed mode:
a. Profit & Loss A/c
b. Balance Sheet
c. Stock Summary

17/03/2023
I. Create a company (Accounting Period – 2022-2023) in Tally Prime by naming it with ‘Student name _
College UID_GST’ (West Bengal, Kolkata – 700040). GSTIN - 19DACPP1435G1ZK. Enable the necessary
features as required in the given question. Configure GST rate at the company level - Smart TV (HSN Code –
8528), Rate – 18%. The company also provides maintenance service which attract 18% GST. Show the Steps
of creating company. Also attach printout of the GST Details page.

21/03/2023
III. Create the following Accounting Ledgers under the appropriate group.
a. Purchase A/c (Attach Print out)
b. Sales A/c
c. Create Sundry Debtors Ledgers (Attach Print out of any one Ledger)

Name State (Pin code) GST No.

P West Bengal (700001) 19ABCPP2413N1ZK

Q Tamil Nadu (610512) 33DJPCQ6534M1ZK

R Andhra Pradesh (485751) 37HSBPR2435N1ZK

23/03/2023
d. Create Sundry Creditors Ledgers (Attach Print out of any one Ledger)

Name State (Pin code) GST No.

X West Bengal (700012) 19DCPPX2649N1ZK

Y Odisha (753001) 21JOSPY8572N1ZK

Z West Bengal (700026) 19BAHPZ3628N1ZK

g. Maintenance services with 18% GST (SAC Code – 9987)

Page 3 of 10 Computerised Accounting System and e-Filing of Tax Return

 The Bhawanipur Education Society College Assignment 2023
Department of Commerce (Morning)

25/03/2023
h. CGST A/c
i. SGST A/c
j. IGST A/c (Attach Print out)
IV. Create the following Inventory Masters
a. Units – Pcs (Pieces)
b. Stock Group – Smart TV (HSN Code – 8528)

27/03/2023
c. Stock Item – LG 32” Smart TV (18%), Samsung 32” Smart TV (18%), MI 64” Smart TV (28%)
Note: For MI 64” Smart TV configuration will be done at the item level as rate of GST is different.

IV. Pass the following Accounting Entries under appropriate vouchers. Show the process of recording each
Accounting Entries. Attach Print out of the Screenshot where-ever mentioned. Assume all transactions took
place on the first day of financial year (1st April’ 2022). GST is levied on all purchases and sales.
1. Purchased from X, 10 pcs of LG 32” Smart TV @ ₹ 10,000 each and 5 pcs of Samsung 32” Smart TV
@ ₹ 9,800 each. (Attach Print out)

29/03/2023
2. Purchased from Y, 10 pcs of MI 64” Smart TV @ ₹ 22,500 each. (Attach Print out)
3. Sold to P, 3 pcs of LG 32” Smart TV @ ₹ 20,000 each and 2 pcs of Samsung 32” Smart TV @ ₹ 20,500
each.

31/03/2023
4. Sold to R, 2 pcs of Samsung 32” Smart TV @ ₹ 20,000 each and 2 pcs of MI 64” Smart TV @ ₹ 39,000
each.
5. Provided maintenance services to R worth ₹ 3,000 and bill raised. (Attach Print out)

03/04/2023
Attach Print out of the Following in Detailed mode:
a. GSTR 1
b. GSTR 2
c. GSTR 3B

Page 4 of 10 Computerised Accounting System and e-Filing of Tax Return

 The Bhawanipur Education Society College Assignment 2023
Department of Commerce (Morning)

B. DBMS
Show the steps for the following along with the screenshots as mentioned below [For 01/03/23 and
06/03/23]:
01.03.23
a. Create a Database named “P Ltd”. [Take Screenshot after writing the name]
b. Create a Table named “Student Data”.
c. Create the “Student Data” table whose design is as follow: [Take one Screenshot with Field Size
15 of UID and other of entire Table design of the table after entering all]

Particulars Data Type Field Size

UID (Primary Key) Number 15

Choose
Format: Double

First Name Short Text 10

Last Name Short Text 10

Address Long Text/ Memo

DOB Date/ Time

Contact Number Number Double

06.03.23
d. Enter the following data in the Datasheet View of the table after completing the design: [Take
screenshot after entering the entire data]

UID First Name Last Name Address DOB Contact

Number

10 Aman Singh Kolkata 10/03/2000 9876543210

11 Raja Shah Mumbai 10/07/2001 9786543210

12 Shoumik Ajmal Hyderabad 23/05/2002 9687543210

13 Radhika Das Delhi 30/01/2003 9587643210

e. Create a Query to retrieve UID, First Name, Address and DOB of student. [Take one screenshot
while doing Query design, i.e., before running. Other screenshot shall be of the Query output after
running.

Page 5 of 10 Computerised Accounting System and e-Filing of Tax Return

 The Bhawanipur Education Society College Assignment 2023
Department of Commerce (Morning)

11.03.23
Create a table “Voucher” bearing the following attributes [Take screenshot after creating it of the design
view of the table]:

Field Name Description Date Type

Vchr No Voucher Number (Primary Key) AutoNumber

Date Date/Time

Type of Voucher Receipt, Payment, Contra, Short Text

Sales,Purchase, Memo (Use Lookup
Wizard)

Particulars Short Text

LF Number

Debit A/c Short Text

Credit A/c Short Text

Debit Amount Currency

Credit Amount Currency

Narration Long Text

TrNo/ ChqNo Transaction Number/ Cheque Number Number

Transaction Amount Currency

Submitted By/ Approved By Short Text

18.03.23
Pass following entries in the form as created above in 11/03/23 assignment and take screenshot of the
datasheet view of all entries together:
a) 05.03.2022: Payment made to Chauhan ₹ 5,000/- for good supplied on 10th February, 2022.
b) 07.03.2022: Cash deposited ₹1,750/- into bank.
c) 08.03.2022: Received ₹50,000/- from Saroj Ltd. on account of sales made on January’22
d) 10.03.2022: Goods worth ₹40,000/- purchased from Transporters Ltd.

Page 6 of 10 Computerised Accounting System and e-Filing of Tax Return

 The Bhawanipur Education Society College Assignment 2023
Department of Commerce (Morning)

10.05.23
Create a database name “Atharva Ltd” and create the following two tables [Take screenshot of the design
view of both tables after completing it and a separate screenshot for putting the constraint in the field of
Basic pay in Table 2]:
Table 1: Employee Info.

Field Data Type Description

E Code Text (Width- 4) Identification of Employee

(Primary Key)

E Name Text (Width – 10) First Name of Employee

E Gender Text: look Up M= Male. F= Female

Wizard

E Date of Joining Date/Time

E Address Memo/ Long Text Address of Employee

Table 2: Salary Info.

Field Data Type Description

E Code Text (Width- 4) Identification of Employee

(Foreign Key)

MSal Paid Text (List) Month of Salary Paid (from Jan to Dec)

YSal Paid Text (List) Year of Salary Paid (2021, 2022, 2023)

Basic Pay Currency Basic Pay of Employee (put a constraint that

basic pay should be less than Rs 15000)

Page 7 of 10 Computerised Accounting System and e-Filing of Tax Return

 The Bhawanipur Education Society College Assignment 2023
Department of Commerce (Morning)

C. E-Filing
24/02/2023
1. Who is required to file return of income and discussion about ITR Forms & Mode of Filing

28/02/2023
2. E-Payment of tax through www.incometax.gov.in

02/03/2023
3. Registration and Login procedure

04/03/2023
4. Different functionalities available at the portal like how to view status of last year return, how to add
bank account, etc.

10/03/2023
5. How to (a) e-verify, (b) view Form 26AS and AIS

12/03/2023
6. Tax Calculator and Income & Tax Calculator on MS Excel
From the following details compute gross total income of Mr. Kamal, 32 years, for the A.Y. 2022-23
Gross Salary ₹ 12,00,000
Value of perk ₹ 95,000
Interest paid on home loan ₹ 2,50,000
[Property is self-occupied]
[Attach Excel computation]

14/03/2023
7. Tax Calculator and Income & Tax Calculator on MS Excel
Further, in the excel work done on 12/03/2023, add following income in the computation
Interest received from SB Account ₹ 12,000
Family Pension ₹ 1,50,000
FD Interest ₹ 1,25,000
[Attach Excel computation]

Page 8 of 10 Computerised Accounting System and e-Filing of Tax Return

 The Bhawanipur Education Society College Assignment 2023
Department of Commerce (Morning)

16/03/2023
8. Tax Calculator and Income & Tax Calculator on MS Excel
Further, following details are also made available by Mr. Kamal, compute his total income and tax
liability for the A.Y. 2022-23
LIC Premium paid ₹ 40,000
Mediclaim Premium paid - Self ₹ 27,000
Mediclaim Premium paid – Parents, Senior citizen, ₹ 28,000
Deduction u/s 80TTA ?
[Attach Excel computation]

20/03/2023
9. Tax Calculator and Income & Tax Calculator on MS Excel
Further, following additional information are also available, show interest payable u/s 234A, 234B and
234C:
TDS ₹ 50,000
Return of income filed on 30/09/2022
All due tax and interest paid on the same date.
[Attach Excel computation] Also suggest in which ITR, he is required to file return of income

22/03/2023
10. Use of Tax Calculator and Income & Tax Calculator [with aforesaid data]

24/03/2023
11. Discussion on Relief u/s 89

28/03/2023
12. Computation of relief u/s 89 with the help of Calculator using following data

AY 2022-23 A.Y. 2021-22

Receipt Accrual Receipt Accrual

Income 12,50,000 11,00,000 8,50,000 10,00,000

Tax on above 1,95,000 1,48,200 85,800 1,17,000

Page 9 of 10 Computerised Accounting System and e-Filing of Tax Return

 The Bhawanipur Education Society College Assignment 2023
Department of Commerce (Morning)

30/03/2023
13. Filling of ITR 1 in excel utility for the A.Y. 2022-23 – Personal Details and Salary Income as per
computation made in excel

01/04/2023
14. Filling of ITR 1 in excel utility for the A.Y. 2022-23 – Income from House Property and Income from
Other Sources as per computation made in excel

04/04/2023
15. Filling of ITR 1 in excel utility for the A.Y. 2022-23 – Deduction under chapter VIA [excluding 80G and
80GGA]

06/04/2023
16. Filling of ITR 1 in excel utility for the A.Y. 2022-23 – Deduction under chapter VIA – 80G and 80GGA
Assuming Donation of ₹ 10,000 is made to the Prime Minister's Citizen Assistance and Relief in
Emergency Situation Fund having PAN AAETP3993P and address Under Secretary (Funds), PMO,
South Block, New Delhi, Pin -110011

For Query mail to:

Harshit.chokhani@thebges.edu.in
Priyanka.mukherjee@thebges.edu.in
Vikash.mundhra@thebges.edu.in
Ankit.patwari@thebges.edu.in

Page 10 of 10 Computerised Accounting System and e-Filing of Tax Return