SNDT Arts and Commerce College Pune 38

Conducted College of
SNDT Women’s University Mumbai

INTERNSHIP REPORT

Submitted to the Partial Fulfilment Of The

Requirement for the Degree Of
Bachelor of Commerce with Accountancy and Finance
(BAF)

Internship Report submitted by:

Amruta Murugesan Goundar
INTERNSHIP CERTIFICATE
 ACKNOWLEDGEMENT

The success and final outcome of this project required a lot of guidance
and assistant from many people and I am extremely fortunate to have their support
till the completion of my report work.

The internship opportunity I had with CA Kishorlal Gandhi was a great

chance for learning and professional development.

I would like to express my special thanks of gratitude to our faculty co-

ordinator Mr Ashok Kokate as well as our principal Dr. Anand Jumle who gave
me the golden opportunity to do internship, which helped me in learning a lot of
new things and also a warm exposure to the world of accountancy and finance.

I would also like to thank my parents who gave me the permission to

complete the internship and also my friends who always helped me when there
was a need of their help during the project.

Although this report has been prepared with utmost care and deep routed
interest, even then I accept it respondent and imperfect.

It is a great opportunity and pleasure for me to express my profound

gratitude to wards all the individual who directly and indirectly contributed
towards completion of this report.

Thankyou!

Amruta Murugesan Goundar

BAF. SEM V
 INDEX

Sr No Topics Page No

1 Executive summary 5

2 Organisational profile 6

3 Work description 7

4 Learning outcome 17

5 Conclusion 18
Letter of application to the employer for
6 19
employer

7 Letter of acceptance by employer 20

8 Letter of parents for permission 21

9 Attendance sheet 22

10 Evaluation sheet by employer 24

 EXECUTIVE SUMMARY

I am Amruta Murugesan Goundar currently pursuing my graduation in

Bachelor of Commerce with Accountancy and Finance at SNDT Arts and
Commerce for Women, Pune. My native is from Tamilnadu. Being a resident of
Pune I have completed my 10th from Kilbil High School and 12th from Nowrosjee
Wadia College.

B Com Accounting and Finance is an undergraduate course of 3 years (Full

time). It is the course that teaches the fundamentals of accounting and finance
practices. Through this course, an individual can learn the technical skills
associated with many of the procedures of financial analysis and accounting
standards.

In last year we have a subject internship in which we have to work under

a CA for a period of month in each semester.

As a part of academic, I did my internship at CA Kishorlal Gandhi for 30

days (240 hours). In this period I have learnt to access tally Software, make entries
of Bank Statement and Purchase and Sales bills, export data from tally into excel.
Calculation of GST values such as CGST and SGST. I have also learnt to create
a company in Tally and also to split company data in tally. Creations of ledgers
was also which I learnt there.

This project is about my internship & detail information about the task
which had been undertaken by me during this internship period.
 ORGANISATIONAL PROFILE

Name of the employer: Kishorlal Tarachand Gandhi

Address: 27 Vishram Baug housing society near Sahara Hotel Petrol

pump opp Pavilion mall Senapati Bapat road Pune – 411016

Phone no: 9850072161

Email id: [email protected]

Works provided to the clients

• Maintenance of the accounts and preparation of Financial

Statements.
• Management of reports.
• Filling of Statutory Returns.
• Accounting supervision.
• GST registration and return filing.
 WORK DESCRIPTION

• Creation of ledger.
• Posting entries of bank statement in tally.
• Making entries of purchases.
• Entries of sales bill.
• Splitting company.
• Creating company.
• Posting of opening balance in tally.

BRIEF DESCRIPTION OF WORKS PERFORMED

Creation of ledger
Select company……………Account info ……….Ledger ……..create……..
Enter the name and select the respective group under which it comes.
Tally automatically creates two ledger accounts, i.e., Profit & Loss account
and Cash in Hand account. As per the requirements of the organization, we can
create the ledger accounts.
Types of voucher

Sales Voucher (F8)

It is used to record sales. The sales voucher has purposes for both supplier and
customer. For the supplier, a copy of the voucher is normally left with the
inventory to indicate that it was purchased and paid for.

Purchase Voucher (F9)

Purchase Vouchers is used when you have to purchase some goods from any
party and you get an invoice against cash or credit purchase from the party.

Payment Voucher (F5)

The Payment Voucher (PV) authorizes the spending of money. You can use it
to pay an outside vendor or to transfer money within your entity.

Receipt Voucher (F6)

A Receipt voucher is used to record cash or bank receipt. Here there is an inflow
of funds.

Contra Voucher (F4)

A contra voucher is a set/group of two or more vouchers to record transactions

within the Establishment especially to record transactions for Cash to Bank or
Withdrawal from Bank.

Journal Voucher (F7)

Journal voucher is a document of every financial transaction, having the

necessary information such as the identification number of the voucher, date,
description of the business transaction, etc.

Credit Note Voucher (Ctrl + F8)

Credit note is a document issued to a party stating that account has been credited
in books of account for the stated reason or vice versa. It is commonly used in
case of sales return, escalation/ de –escalation in price.

Debit Note Voucher (Ctrl + F9)

Debit Note is a document/voucher given by a party to other party stating that

such other party's account is debited in the books of sender.

ENTRY OF BANK STATEMENT IN TALLY

Every company has its own bank account. Large amounts of transactions such
payments from the creditors and payment to the debtors take place through
bank. So it is necessary to record this transactions.

Open tally-----select the company-------select balance sheet--------select

current assets---------select the bank A/c--------and select respective vouchers
for respective transactions……

• Cash Deposit Bank entry

Voucher type: Contra Voucher Shortcut Key - F4
entry:
Bank A/c (Dr)
 To Cash (Cr)
• Cash withdrawal
entry:
Cash A/c (Dr)
To Bank A/c (Cr)
• Bank entry for cheque Issued or given to a supplier
entry:
Supplier A/c (Dr)
To Bank A/c (Cr)
• Payments
entry:
Dr the Expenses
Cr the Bank
• Receipt
entry:
Dr the Bank
Cr the Party

HOW TO CREATE A COMPANY

Every company is created in tally for accounting purpose. Each and every
company is created with their name, mailing name, address, financial year,
currency symbol. The company details can be secured by the tally vault
password.
To open Tally Software ……….. Double click on tally icon from your desktop
……... Select Create Company from the Company Info. Menu using up and
down arrow key and press Enter Key………… select the path using Alt+D
……...... enter all the details of the company that you been asked for……..
Enter to accept and save the details.
 SPLIT COMPANY

You can split the company data at the end of the current financial year or at the
beginning of the next financial year when the data size becomes huge.
Go to Gateway of Tally > F3: Comp Info. > Split Company Data > Select
Company …….. Select the required company from the List of Companies
…….Enter the required date in the Split from field………Press Enter to split
the company data.
 ENTERIES OF SALE IN GST

• Local purchase
Bill: A Ltd

plastic 10000

CGST 9% 9000

SGST 9% 9000

Entry

Purchase local purchase A/c Dr 10000

Input CGST 9% Dr 9000

Input SGST 9% Dr 9000

To A Ltd 118000

• Detail of central purchase

Bill: A Ltd

plastic 100000

IGST 18% 18000

total 118000

Entry

Purchase Plastic A/C Dr 100000

Input IGST Dr 18000

To A Ltd 118000
 • Local sales
Bill: X Ltd

plastic 160000

CGST 9% 14400

SGST 9% 14400

Total 188800

Entry

X Ltd Dr 188800

To sales plastic 160000

To output CGST 9% 14400

To output SGST 9% 14400

• Central Sales
Bill X Ltd

Plastic 160000

IGST 18% 28800

Total 188800

Entry

X Ltd Dr 188800

To Sales Plastic 160000

To Output IGST 28800

Goods and Service tax (GST)

Goods and Services Tax (GST) is an indirect tax (or consumption tax) used
in India on the supply of goods and services. Goods and services are divided
into five different tax slabs for collection of tax - 0%, 5%, 12%, 18% and 28%.
From July 1, 2017, GST came up as single taxation system in India and
replaced all the indirect taxes in the country. Some of the indirect taxes that
were abolished were Central Excise Duty, VAT, Entry Tax and Octroi .

Different forms of GST collected by the government are:

State GST (SGST): It is collected by State Government.

Central GST (CGST): It is collected by Central Government.

Integrated GST (IGST): It is collected by Central Government for inter-state

transactions and imports.

Union Territory GST (UTGST): It is collected by Union Territory

Government.

simple formula:

• GST Amount = (Original Cost*GST Rate Percentage) / 100

• Net Price = Original Cost + GST Amount

Example

If a goods or services is sold at Rs. 1,000 and the GST rate applicable is 18%,
then the net price calculated will be = 1,000+ (1,000 X(18/100)) = 1,000+180
= Rs. 1,180.

SHORTCUT KEYS USED IN TALLY

KEYS FUNCTIONS

Esc To remove what has been typed into the data field
while preparing a voucher

ALT + D To delete a voucher/ To delete a master

ALT + C To create a master/ ledger

ALC

ALT + X To cancel a voucher

CTRL + A To accept a form

CTRL + V To toggle between invoice and voucher mode

ALT + 2 To duplicate a voucher

CTRL + N To switch to calculator

ALT + R To remove / hide the line in a report

ALT + P To print the report

ALT + E To export the report in ASCII, Excel, HTML, PDF,

XML format

Alt + R To hide a Ledger

Ctrl + Enter Change Ledger

ALA

Alt + U To unhide a ledger

F1 To select a company

Alt + X To cancel a voucher

Alt + 2 To change system period

DAS To open sales voucher

DAP To open purchase voucher

AUDIT WORK

To RK industries situated at Walhekarwadi, Pimpri Chinchwad. Got to know

about auditing. And meet new persons and a new environmental totally different
from my comfort zone. Work done by me was to check Sales entries in tally
with the bills and also payment advice of payments made to them as well as
payment made by them. And checking of closing balance of banks of each
month of 2020-2021, and also cash vouchers.

Also went to auditing at TRIMURTI ENTERPRISES, Narhegoan, SHARP

SALES CORPORATION, Thadiwala Road…. BRAHMA MOTORS,
Wakdewadi.
 LEARNING OUTCOMES

• Knowledge about accounting works in tally, how to use tally software.

➢ Creation of ledger and posting entries of bank statement in tally.
➢ Making entries of purchases and sales bill.
➢ Splitting company data and creating company.
➢ Posting of opening balance in tally.
• Improve communication skills, communicating with professionals.
• Integrate theory and practice and developing work habits, learn things apart
and more than theoretical knowledge.
• Getting practical experience in a real life, assess interests and abilities in this
field.
• Improvement of my time management, team work, etc.
• Adapting quickly to changing environments, get exposure to do a work in
an organisation and also came to know about organisational behaviour
ethical rules and regulations.
• Plan for future and how to adjust in an organisation.

I met quite a few amazing people who were very warm and caring
towards me and also very willing to share their knowledge and expertise.
During the internship I really felt like it became my second home and I am
very grateful to them for it.
 CONCLUSION

On the whole, this internship was a useful experience. I have

gained new knowledge, skills and met many new people. I achieved several of
my learning goals, however for some the conditions did not permit. I got insight
into professional practice.
The internship was also good to find out what my strengths and
weaknesses are. This helped me to define what skills and knowledge I have to
improve in the coming time. It would be better that the knowledge level of the
language is sufficient to contribute fully.
This internship has been an excellent and rewarding experience.
Two main things that I’ve learned is the importance of time-
management skills and self-motivation.
At last this internship has given me new insights and motivation to
pursue a career in accountancy.
APPLICATION FOR INTERNSHIP
LETTER OF ACCEPTANCE BY EMPLOYER
 PERMISSION LETTER

This is to certify that I am allowing my daughter, Amruta

Murugesan Goundar to go on internship (on-the-job training) for a
minimum of 30 days starting on 25th January 2021 until 25th
February 2021 at CA Kishlorlal T Gandhi firm in partial fulfilment of
the requirements for the degree in Bachelor of Commerce with
Accountancy and Finance.

It is understood that she abides by the rules and

regulations that may be imposed by the Supervisor/Staff-in-Charge
for her welfare and safety

I fully agree to wave any responsibility on the part of

SNDT Arts and Commerce Pune, and /or the representative/s, in case
of any untoward incident that may happen to my daughter during the
duration of the internship.

Murugesan Goundar
ATTENDANCE SHEET
EVALUATION SHEET