AI Modules/Working Papers/Lead Schedules

Schedule III Balance Heads· पत्र

Lead Schedules

Per Schedule III ಬ್ಯಾಲೆನ್ಸ್ ಹೆಡ್ with three-level drill to source ವೌಚರ್‌ಗಳು.

Start the free trial →Book a walk-through

CORAA Schedule III Balance Sheet with three-level drill

ಲೀಡ್ ವೇಳಾಪಟ್ಟಿಗಳು are the ಆಡಿಟರ್'s primary ವರ್ಕಿಂಗ್ ಪೇಪರ್ for every Balance Sheet and P&L head. CORAA composes them automatically from ಯುನಿವರ್ಸಲ್ ಆಡಿಟ್ ಲೆಡ್ಜರ್. 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: Total Assets must equal Total Equity plus Total Liabilities.

Per Schedule III ಬ್ಯಾಲೆನ್ಸ್ ಹೆಡ್, 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 firm's Excel ಟೆಂಪ್ಲೇಟ್ in OneDrive
Live 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

-ಲೀಡ್ ವೇಳಾಪಟ್ಟಿಗಳು built by article assistants in Excel
-Each schedule a separate workbook with manual VLOOKUPs to the ಪ್ರಯೋಗ balance
-PY figures copy-pasted from prior-year ವರ್ಕಿಂಗ್ ಪೇಪರ್ file
-Tie-out checked at the end and reworked if BS doesn't balance

Build time: 2-3 days per ಆಡಿಟ್. Errors: typical. Tie-out failures caught late.

CORAA

On the Ledger

ಲೀಡ್ ವೇಳಾಪಟ್ಟಿಗಳು composed from UAL via live formulas
PY figures pulled from prior-year ಆಡಿಟ್ed closing automatically
Three-level drill from any line for evidence
Tie-out enforced before composition; BS cannot fail to balance
Reclassify a ಲೆಡ್ಜರ್ ಮತ್ತು every dependent schedule recomputes

Build time: 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. ಲೀಡ್ ವೇಳಾಪಟ್ಟಿಗಳು 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 ಲೆಡ್ಜರ್ ನೋಡಲು parties contributing to it. Click any party ನೋಡಲು source ವೌಚರ್‌ಗಳು. Read-only at all three levels; corrections happen via ಲೆಡ್ಜರ್ ವರ್ಗೀಕರಣ.

Step 03

Variance analysis built in

CY and PY columns ಅಕ್ಕಪಕ್ಕ. Variances above 25% flagged for explanation (CARO Rule 11(e) trigger). The variance note ಶುಲ್ಕds CARO 2020 Clause 3(xi)(e) directly.

Inside the module

What you actually get.

Schedule III ಬ್ಯಾಲೆನ್ಸ್ ಹೆಡ್ 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-classification from ಲೆಡ್ಜರ್ ವರ್ಗೀಕರಣ

Three-level drill-down

Three levels deep, all read-only. Corrections happen at the ಲೆಡ್ಜರ್ ವರ್ಗೀಕರಣ screen, which propagates back to every dependent lead schedule.

›Level 1: Sch III line totals
›Level 2: constituent ಲೆಡ್ಜರ್‌ಗಳು
›Level 3: parties under each ಲೆಡ್ಜರ್
›Level 4: source ವೌಚರ್‌ಗಳು under each party

Tie-out invariant enforced

Total Assets must equal Total Equity plus Total Liabilities. CORAA refuses to mark a lead schedule 'ready' if the tie-out fails by more than ₹1. Same for the P&L bottom line ಶುಲ್ಕding Reserves & Surplus.

›BS tie-out: Assets = Equity + Liabilities
›P&L tie-out: bottom line ಶುಲ್ಕds Reserves
›ಕ್ಯಾಶ್ ಫ್ಲೋ tie-out: closing cash matches BS
›Tie-out re-checked on every change

Firm-ಟೆಂಪ್ಲೇಟ್ Excel export

ಲೀಡ್ ವೇಳಾಪಟ್ಟಿಗಳು export to standard Excel in the firm's own ಟೆಂಪ್ಲೇಟ್ format. OneDrive integration means the Excel lives in the firm's cloud, not CORAA's.

›Drop firm ಟೆಂಪ್ಲೇಟ್ once, used thereafter
›Per balance head export
›Bundled export for full lead schedule 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 lead schedule renders both portions on their respective Schedule III ಸಾಲುಗಳು with the percentage shown in the drill.

Three sources, in priority order: (1) prior-year ಆಡಿಟ್ ವರದಿ uploaded at ಎಂಗೇಜ್‌ಮೆಂಟ್ ಸೆಟಪ್, OCR-extracted; (2) prior-year ಪ್ರಯೋಗ Balance Excel uploaded; (3) prior-year CORAA ಎಂಗೇಜ್‌ಮೆಂಟ್, if it exists in your workspace. The source is shown next 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