AI Modules/Working Papers/Lead Schedules

Schedule III Balance Heads· पत्र

Lead Schedules

Per Schedule III balance head with three-level drill to source वाउचर.

Start the free trial →Book a walk-through

CORAA Schedule III Balance Sheet with three-level drill

Lead schedules are the ऑडिटर's primary वर्किंग पेपर for every Balance Sheet and P&L head. CORAA composes them automatically from the Universal ऑडिट लेजर. Each schedule shows CY and PY columns with variance analysis. Three-level drill: balance head, लेजर under it, parties under the लेजर, वाउचर under the party. Tie-out enforced at composition: कुल Assets must equal कुल Equity plus कुल Liabilities.

Per Schedule III balance head, Division I or Division II
Three-level drill: line, लेजर, parties, वाउचर
CY and PY columns with variance flag at 25%
Tie-out invariant: Assets = Equity + Liabilities (re-checked on every change)
Exports to फ़र्म's Excel टेम्पलेट in OneDrive
लाइव formulas: change लेजर वर्गीकरण, लीड शेड्यूल recompute

Two paths, one ledger

The old way, and ours.

Two paths to the same audit conclusion. One leaves traces; the other doesn't.

Traditional

The old way

-Lead schedules built by लेख assistants in Excel
-Each schedule a separate workbook with manual VLOठीक हैUPs to the ट्रायल balance
-PY figures copy-pasted from prior-वर्ष वर्किंग पेपर file
-Tie-out checked at the end and reworked if BS doesn't balance

Build समय: 2-3 दिन प्रति ऑडिट. Errors: typical. Tie-out failures caught late.

CORAA

On the Ledger

Lead schedules composed from UAL via लाइव formulas
PY figures pulled from prior-वर्ष audited closing automatically
Three-level drill from any line for evidence
Tie-out enforced before composition; BS cannot fail to balance
Reclassify a लेजर and every dependent schedule recomputes

Build समय: instant. Errors: arithmetic-impossible. Tie-out: enforced.

How it works

Three steps. Every trace logged.

Step 01

Schedule III mapping drives composition

Once लेजर वर्गीकरण's Schedule III dimension is set, every लेजर has a Sch III line code. Lead schedules aggregate लेजर by line code using SUMIFS over the ट्रायल Balance.

Step 02

Three-level drill

Click any Sch III line to expand to its constituent लेजर. Click any लेजर to see the parties contributing to it. Click any party to see the source वाउचर. पढ़ें-only at सभी three levels; corrections happen via लेजर वर्गीकरण.

Step 03

Variance analysis built in

CY and PY columns side by side. Variances above 25% flagged for explanation (CARO Rule 11(e) trigger). The variance note feeds CARO 2020 Clause 3(xi)(e) directly.

Inside the module

What you actually get.

Schedule III balance head coverage

Every line code from A1 Equity Share Capital through F7 Other Current Assets, plus P1 Revenue through P9 Other Expenses. Division I for AS; Division II for Ind AS.

›Division I: Indian GAAP / AS
›Division II: Ind AS
›~90 line codes covered
›Auto-वर्गीकरण from लेजर वर्गीकरण

Three-level drill-down

Three levels deep, सभी पढ़ें-only. Corrections happen at the लेजर वर्गीकरण screen, which propagates वापस to every dependent लीड शेड्यूल.

›Level 1: Sch III line totals
›Level 2: constituent लेजर
›Level 3: parties under each लेजर
›Level 4: source वाउचर under each party

Tie-out invariant enforced

कुल Assets must equal कुल Equity plus कुल Liabilities. CORAA refuses to mark a लीड शेड्यूल 'ready' if the tie-out fails by अधिक than ₹1. Same for the P&L bottom line feeding Reserves & Surplus.

›BS tie-out: Assets = Equity + Liabilities
›P&L tie-out: bottom line feeds Reserves
›Cash Flow tie-out: closing cash matches BS
›Tie-out re-checked on every change

फ़र्म-टेम्पलेट Excel export

Lead schedules export to मानक Excel in the फ़र्म's own टेम्पलेट format. OneDrive एकीकरण means the Excel lives in the फ़र्म's cloud, not CORAA's.

›Drop फ़र्म टेम्पलेट once, used thereafter
›Per balance head export
›Bundled export for full लीड शेड्यूल pack
›OneDrive / SharePoint / local drive

Frequently asked

Answers, up front.

लेजर वर्गीकरण supports percentage-allocated mapping. For example, an accrual लेजर that's 40% current and 60% non-current gets allocated accordingly; the लीड शेड्यूल renders both portions on their respective Schedule III lines with the percentage shown in the drill.

Three sources, in priority order: (1) prior-वर्ष ऑडिट रिपोर्ट uploaded at एंगेजमेंट सेटअप, OCR-extracted; (2) prior-वर्ष ट्रायल Balance Excel uploaded; (3) prior-वर्ष CORAA एंगेजमेंट, if it exists in your वर्कस्पेस. The source is shown अगला to the PY figure for verification.

हाँ. Every line supports inline ऑडिटर notes that flow into the ऑडिट वर्किंग पेपर file. नहींtes are versioned per the एंगेजमेंट log and visible to peer reviewers.

See it on a real ledger

Run lead schedules on one of your engagements.

Bring a Trial Balance and a General Ledger. We'll walk through working papers end-to-end on your data, not a sandbox.

Start the free trial →Book a walk-through