NDLI: Audit Lens

Content Provider	TKM College of Engineering
Advisor	Vaheetha Salam
Author	Antony, Agna
Abstract	The term ”audit” typically refers to an examination of financial statements. A financial audit is an independent review and assessment of an organization’s financial statements to ensure that they fairly and accurately reflect the transactions they purport to represent. Employees of the organisation may conduct the audit internally, or an outside company of Certified Public Accountants may do it externally. External audits can be quite beneficial in removing any prejudice when examining the health of a company’s finances. Financial audits look for any significant inaccuracies in the financial statements. Internal auditors work for the business or organisation they are auditing, and they deliver their audit report directly to management and the board of directors. Auditor-friendly features in Excel are numerous. Excel is a potent audit tool since it allows for the input of data and the running of various tests and analyses. Most auditors can easily access it, and it is easy to use. There are numerous analytical tests that Excel is capable of doing. Numerous other sorts of data analysis can also be carried out with this tool, including append and merge, cross tabulation, pivot tables, gaps and duplication detection, extract and filter, connect and relate, sample, sort, summarise, and subtotal. A tool that aids auditees in better understanding audits is thus required which displays the progression of each section of the question using bar graphs and percentages. It saves the user time and permits the monitoring of the auditor’s performance by avoiding the conventional Excel sheet appraisal.It also helps the user to quickly and easily determine the auditing’s progress and track the efficiency of auditor.
Language	English
Publisher Date	2022-07-01
Access Restriction	Open
Subject Keyword	Big Data Audit Excel Financial Audits Python
Content Type	Text
Resource Type	Thesis

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in