Financial Statement Spreading

• Transaction Advisory Manager
• Valuation Analyst
• CMA and Project Finance Team Lead
• Due Diligence Partner

Advisory, valuation and project-finance teams spend hours copying balance sheets, profit and loss statements and notes from annual reports into a standard model before any analysis starts. Every company groups items differently, the real detail sits in the notes, and a typo in a re-keyed figure can travel through ratios, CMA data and valuation outputs unnoticed.

We build a spreading assistant that takes annual reports, audited financial statements or MCA-filed financials and maps them into your firm's template: a standard spread, a CMA data format for working capital proposals, or a due diligence databook. It finds the primary statements and notes, extracts every line with its note reference, and proposes a mapping to your template lines based on the note detail rather than the caption alone. Arithmetic checks confirm that subtotals, totals and the balance sheet hold, and that comparatives agree with last year's spread. Lines with low mapping confidence or failed checks are queued for an analyst before ratios are calculated.

• Locates the balance sheet, profit and loss, cash flow and notes in long annual reports, including scanned years
• Extracts line items with note references across standalone, consolidated, current and comparative columns
• Proposes template mappings from note breakdowns and remembers analyst corrections for each client
• Tie-out checks on subtotals, balance sheet balance, cash flow and comparatives against the prior spread
• Flags restatements, reclassifications and auditor qualifications or emphasis-of-matter paragraphs
• Exports to your Excel model, a CMA format or your credit or valuation template

1. 01Upload the financial statementsAnnual reports, audited statements or XBRL filings for the years in scope are added to the engagement.
2. 02Locate statements and notesPages are classified so that the primary statements and each note are found, whatever the report's layout.
3. 03Extract line itemsFigures are extracted with captions, note references and column context, each linked to its page.
4. 04Map to the templateEach line is mapped to your spreading template using the note breakdown and earlier corrections.
5. 05Check and confirmTie-out failures and low-confidence mappings go to an analyst, who confirms or corrects them.
6. 06Calculate and exportRatios are calculated and the spread is exported with a page-level trace for every figure.

1. Intake
   • PDF upload for annual reports
   • XBRL import for MCA filings
   • OCR for scanned statements
2. Document understanding
   • Page classifier for statements and notes
   • Table extractor
   • LLM line-item and note parser
3. Mapping and checks
   • Template mapping with client-specific rules
   • Arithmetic tie-out engine
   • Comparatives checker against prior spreads
4. Review
   • Analyst mapping workbench
   • Correction memory per client and template
5. Output
   • Ratio calculator
   • Excel and CMA exporter
   • Audit trail of mappings and edits

Analysts confirm every mapping below the confidence threshold and every failed tie-out before ratios are calculated. Interpretation of the numbers, including any credit view, valuation assumption or projection, stays with the advisory team.

• Excel models and CMA templates
• Bank loan origination or credit appraisal systems, for CMA submissions
• MCA filings and XBRL files
• SharePoint or Google Drive engagement folders

• Every figure traced to its page and note
• Balance sheet must balance before export
• No silent reclassification; every mapping change is logged with the user
• Analyst corrections reused only for the same client and template
• The model does not generate projections or assumptions

• Financial statements of unlisted clients are confidential; processing stays in your environment with access limited to the engagement team.
• A spread supports analysis; it is not an audit or assurance opinion on the underlying statements.

• Accounting, Audit & Consulting

  Engagement Proposal Drafting

  Draft proposals, RFP responses and engagement letters from discovery notes and your firm's past work, with scope, staffing and assumptions laid out for the partner to price and sign.

• Accounting, Audit & Consulting

  Audit Sampling and Vouching from Invoices

  Select samples from the ledger, pull invoices, GRNs and payment proofs, and check each voucher against the entry, with every exception sent to the audit senior.

• NBFCs & Lending

  Bank Statement Analysis for Underwriting

  Analyse bank statements from PDFs, scans and Account Aggregator data to surface income, obligations, bounces and red flags, with every figure traceable to transactions.

• Legal

  Due Diligence Data Room Review

  Index a virtual data room against your request list, extract issues from contracts, corporate records and licences, and draft report tables and query lists for lawyers to confirm.