1. Reconciliation or validation of two years data

1. Work for a day or two on making comparisons

1. Analysing the comparisons

1. Manual errors

1. Time consuming task at year end

1. Analysis of complex provision

1. Multiple thresholds (like or, and combinations)

1. Applying provision analysis on live data

1. Forgetting about which year data to be considered for (like Year-end, preceding year, Avg of previous 3 years … etc)

1. Manual errors in interpreting or application of Provisions

1. Lot of confusion when provisions are similar but with slight deviations

👋🏻 Say good bye to Audit through the Computer / Audit around the Computer / Black box or White Box Approaches 👋🏻

🙏🏻 WELCOME TO:

1. COLUMNAR FINANCIALS

1. YOY COMPARISION

1. COMPOSITION / WEIGHTS of Line Items

1. Ratio Analysis

1. Visual Analysis

1. AI Analysis (by Gemini API)

1. TRIAL BALANCES of 2 Years (i.e., 3years data included)
2. No of Ledgers – 4549 (CY)
3. No of Ledgers – 3932 (PY)

1. 3 levels of Mapping to above TB’s (hardly takes 5-20 mins)

1. Data copied from Automated Analytical procedures (i.e., 3 years Columnar Financials)

1. 3 more key details entered manually (i.e., Name, CIN & Layer)

WEBISTE OUTLOOK IN LIGHT THEME MODE

WEBISTE OUTLOOK IN DARK THEME MODE

TOOLS USED 💻 🌐

For conceptual understanding of: - SA 520 ANALYTICAL PROCEDURES

 - PROVISIONS INTERPRETATION’s (Text & Audio)

Input = Docu on SA 520 & Various acts

Output = Summarised Text & Audio Podcast

Version 2.5 Pro (preview)

For PYTHON & HTML coding

For AI integration into the above coding using “Gemini API KEY” call function

Version 3.13 (64 Bit)

Along with python libraires like Pandas, flask etc.,

🌐Local Web Browser: For hosting & running Website Interface

1. Serves as Audit working proper upon review by auditor with his/her professional scepticism and judgement

1. SIMPLE USER INTERFACE

1. Automated AI ANALYSIS

1. Automation of Data Compilation of 2 years which includes 3 years data

1. Automatic Opening balance reconciliation

1. Automatic Simple Financials Preparation with 3 years data

1. Automatic YOY Comparisons

1. Automatic Composition of Line Items

1. Automatic Ratios Calculation

1. Automatic Trend Analysis

1. Automatic Direct & Indirect relationship analysis

1. Level 1 & 2 Mapping are static as all categories are covered (Level 1 = BS, PL, Level 2 = Non-Current Assets, Current Assets, Non-Current Liabilities, Current Liabilities, Revenue & Expenses.

1. Level 3 Mapping is dynamic and Exhaustive list:

1. Serves as Audit working proper upon review by auditor with his / her professional scepticism and judgement

1. SINPLE USER INTERFACE

1. Automated checking of applicability status

1. Automated status of Due Dates

1. Acts as a reminder for Both CA firms, Auditors & Clients while filings or preparing audit reports

1. INDUSTRY LEVEL BENCHMARK COMPARISION

1. COVERAGE OF MORE RATIOS

1. COVERAGE OF MORE than 3 Years Data

1. COVERAGE OF MORE PROVISIONS & ACTS that related to figures of Trial balance / Financials / Columnar Day Book

1. Summary report to clients on STATUTORY applicability’s & their deadlines in the beginning & end of financial years

1. GIGO: GARBAGE in GARBAGE OUT

1. Incorrect Mapping at Input data level (Results in wrong data classification)

1. Failure in Timely updation of backend code for new accounting categories in Level 3 Mapping if any may result in incorrect output

1. GIGO: GARBAGE in GARBAGE OUT

1. Incorrect Mapping at Input data level (Results in wrong data classification)

1. Failure of Timely updation of backend code for new thresholds, amendments, dynamically changing legal landscapes may result in wrong status indicators.

DATA PRIVACY: 🔐

Data privacy is ensured by deleting client names in Trial balances when uploading

Even with last digit change in CIN Number (Dummy number with right combination) will give best results

UPCOMING DATA PRIVACY FEATURES: 🔃

Users will have option to permanently delete the data uploaded & data generated immediately upon downloading their reports.

End to End encryption for files uploaded and downloaded till the time of deletion

Audit log for Input & Output storage databases

Enclosing below the Project Structure & process flow logic at the backend for Analytical Procedures: (Step 6c shows how GEMINI API request is integrated into the coding *without API key being publicly disclosed)

File “App.py” is the bridge b/w website interface and core logic to run on the file uploaded in the website which is stored into input folder (this file is generate using Geming using chain of prompts)

File “.env” is a secured file which holds the API KEY separately without it being included in the app.py for security purpose.

File “analytical procedure app.py” file is an offline tool to run the logic if online version is unable to run analysis due to bad internet connectivity. The logic picks up which-ever is the recent modified file using time stamp in the “Input files” folder.

Input files is the storage for input files uploaded.

Output files is the storage for output file generated by the logic system.

PROJECT LOGIC WORKFLOW:

Step 1: Loading data from input sheets...

Step 2: Performing data validation...

Step 3: Preparing analysis sheets data...

Step 4: Writing data to output Excel file...

Step 5: Applying formatting and generating detailed reports...

Step 6a: Saving file to evaluate formulas for AI analysis...

Step 6b: Loading calculated values for AI Analysis...

Step 6c: Generating Gemini AI Analysis...

 -> Preparing data for Gemini AI analysis...

 -> Sending request to Gemini API...

 -> Received response from Gemini API.

 -> Creating 'Gemini AI Analysis' sheet...

 -> 'Gemini AI Analysis' sheet created successfully.

Step 7: Finalizing and copying original data...

Step 8: Saving final report for user Download.