Annual Report Review (Ind AS, Schedule III, CARO)
Forensic financial statement reviewer for listed Indian companies, checking Ind AS compliance and Excel-to-PDF tie-outs.
$8
Works with the AI Agents you already use
Annual Report Review (Ind AS, Schedule III, CARO)
Example session with this skill installed
Review the attached standalone Balance Sheet and Note 4 (Trade Payables) from the draft PDF against the Excel working set. Check for casting errors and tie-out consistency.
- Read your context and instructions
- Compiled the annual report review
- Generated the document
I have completed the forensic review of the standalone Balance Sheet and Note 4 (Trade Payables) by comparing the draft PDF (v4_final_typeset.pdf) against the Excel working set (BS_Workings_March24.xlsx).
Pre-Signing Review Report
| Reference | Finding Type | Observation | Severity | Citation |
|---|---|---|---|---|
| BS-01 | Error | The total for Non Current Liabilities on the face of the Balance Sheet (₹14,250.50 Lakhs) does not foot. The sum of the components is ₹14,250.55 Lakhs. | Critical | Schedule III, Div II |
| NOTE-04.1 | Error | Note 4 (Trade Payables) total of ₹8,420.10 Lakhs in the PDF does not tie to the Excel working paper 'Lead_TP', which shows ₹8,425.10 Lakhs. A manual entry of ₹5.00 Lakhs in the PDF is unsupported. | Critical | SA 230 |
| NOTE-04.2 | Disclosure incomplete | The aging schedule for Trade Payables in Note 4 lacks the "Unbilled Dues" category required for the current year. | Major | Schedule III, Div II |
| REF-04 | Error | The cross reference in the Auditor's Report (Page 12) refers to Note 4 for MSME disclosures, but the MSME breakdown is actually located in Note 4.3 on page 45. | Minor | SEBI LODR |
| CAST-01 | Rounding | The components of Note 4.2 (Other Payables) sum to ₹1,200.41 Lakhs while the total shows ₹1,200.40 Lakhs. Review of Excel confirms this is a rounding artifact from the sub-ledger. | Observation | N/A |
Next steps
1.
Adjust Balance Sheet face: Correct the Non Current Liabilities subtotal in the typesetting software to match the component sum.
2.
Reconcile Note 4: Update the PDF figure for Trade Payables to match the ₹8,425.10 Lakhs supported by the Excel working papers.
3.
Update Cross-References: Correct the page and note number pointers in the Independent Auditor's Report before final signing.
v4_final_typeset.pdf
PDF · document
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
Final reviews of listed Indian company annual reports are high-stakes. A single casting error or a broken cross-reference in the final PDF can delay publication, trigger auditor disputes, or invite regulatory scrutiny from NFRA. This skill executes a forensic, pre-signing audit of financial statements, tying printed figures back to Excel working papers to ensure absolute accuracy.
What it does
- Recalculates arithmetic by re-footing every subtotal, total, and cross-cast in both standalone and consolidated statements.
- Ties print to source by identifying discrepancies between the typeset PDF and the underlying Excel working papers.
- Verifies cross-references to ensure every "refer note N" citation in the statements and auditor's report points to the correct note.
- Audits disclosures against a battery of requirements including Ind AS, Schedule III Division II, Companies Act 2013, and SEBI LODR.
- Tracks revision cycles using a closure matrix to confirm which previous observations were fixed and which fixes introduced new errors.
- Benchmarks peers by comparing disclosure structures and revenue classifications against published reports of industry competitors.
How it works
- Inventory assets. Run the probe script to index all PDFs, Excel sheets, and Word docs, identifying the most current versions and checking for stale data.
- Verify face statements. Re-foot the Balance Sheet, P&L, Cash Flow, and Statement of Changes in Equity to ensure they balance and reconcile with each other.
- Execute reconciliation battery. Test every note total back to the face statements and verify all internal note components.
- Review auditor reports. Analyze the Independent Auditor's Report, CARO 2020 annexures, and IFC reports for internal consistency and regulatory compliance.
- Generate review report. Produce a structured report classifying findings by severity with specific citations for every identified error or gap.
Frameworks & tools
This tool is built for the Indian regulatory environment, covering Ind AS, Schedule III, Companies Act 2013, SEBI LODR/ICDR, CARO 2020, and Income Tax Act reporting. It uses specialized Python scripts for layout-preserving PDF extraction and Excel formula analysis.
Why this beats prompting it yourself
Generic prompts often miss rounding artifacts or fail to catch errors introduced during note renumbering. This skill uses a systematic order of work and specific reconciliation batteries that distinguish between presentation rounding and actual accounting errors, preventing the loss of credibility caused by false positives.
Use cases
- Final pre-signing check of a 200 page annual report PDF against the final finance team Excel file.
- Auditor query preparation to identify gaps in the CARO annexure or IFC report before the formal audit committee meeting.
- Revision tracking to ensure that corrections made in draft three did not break the cross-references in draft four.
- Compliance gap analysis to identify missing mandatory disclosures required under new SEBI regulations.
Known limitations
Cannot verify inter-company eliminations or consolidation adjustments that are not visible in the provided printed statements or working papers. Requires clear PDF or Excel inputs to perform extraction.
How to use
Skills on Agensi run inside your AI agent. Copy the prompt, paste it into your agent, and it connects to Agensi and installs this skill for you. If a payment is needed, your agent shows it to you first.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill passes our trust checks below.
Security scanned
Passed our 8-point scan before listing
1 install
Downloaded by developers to date
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scanned
Verified clean 4 days ago
- Passed all security checks, Safe to install
Requires