1---2name: extract-assets-from-financial-declaration3description: Focuses the agent on extracting asset, liability, and income data from a sworn financial declaration into a structured workbook, reconciling totals across schedules, computing equity where appropriate, and flagging stale, unsupported, or classification-sensitive entries for follow-up.4---56# Skill: Extract and Reconcile Assets from Opposing Party's Financial Declaration78## 2. Failure modes the skill is correcting910- Producing a flat list of items instead of a structured workbook that mirrors the declaration’s own schedule logic11- Missing asset-by-asset reconciliation, especially where value depends on balance date, encumbrances, or cash-surrender treatment12- Treating stated face amounts, estimates, or ranges as if they were settled values without flagging the valuation basis13- Accepting business or professional interest figures without noting methodology gaps, discount treatment, or goodwill classification issues14- Omitting liability classification problems, including pre-existing debt, contingent debt, or unclear payor responsibility15- Failing to compare summary pages against detailed schedules, which leaves internal inconsistencies unflagged16- Overlooking stale statements, unsupported assertions, or missing backup that should be sent back for supplementation17- Drafting an issues memo that describes problems but does not tie each one to the relevant schedule, practical effect, and next step1819## 3. Legal frameworks / domain conventions that apply2021- Use the declaration’s own schedule architecture as the organizing framework for extraction, then normalize it into a workbook with consistent fields22- Distinguish marital, separate, exempt, or disputed classifications where the declaration or supporting materials provide a basis to do so23- For real property, record value, secured debt, and resulting equity; note any missing lien information, tax arrears, or assumed encumbrances24- For liquid accounts, prefer the most current statement date available in the source set and flag older balances as potentially stale25- For retirement assets, note plan type, vested balance if shown, and whether division may require a transfer order or other administrative step26- For life insurance, distinguish term coverage from permanent coverage and report cash value rather than face amount when a divisible value exists27- For business interests, record ownership percentage, valuation method, discounts, and any indication that personal versus enterprise goodwill matters28- For vehicles and tangible personal property, separate asserted value from evidence quality, source date, and any lien or finance balance29- For liabilities, capture creditor, amount, payment status, maturity, and whether the debt predates the relevant relationship period if that appears material30- For income, compare any summary figure to the underlying detailed schedule and flag discrepancies or omitted components31- Apply the governing family-law, property-classification, and disclosure principles recognized in the jurisdiction reflected by the source materials when the declaration itself invokes them3233## 4. Analytical scaffolds34351. Enumerate each asset, liability, and income source from the declaration and attachments before analysis; do not merge distinct accounts, parcels, policies, or interests into a single row.362. Build the workbook first as a schedule-aligned extraction, then add a reconciliation sheet that totals assets, liabilities, and net worth across categories.373. For each item, capture at minimum: owner/name, category, description, stated value, statement or valuation date, source document, classification, and review flags.384. For real property, compute or restate equity from the declared figures where possible; if debt or value inputs are incomplete, flag the calculation as provisional.395. For business interests, extract the valuation narrative and identify whether the stated figure appears to rely on earnings, book value, market comparison, or another method.406. For life insurance, record policy form and cash value treatment; if only face coverage is shown, flag that the declaration may not reflect an asset value.417. For liabilities, note whether the debt is secured or unsecured, whether it appears current or delinquent, and whether the source documents show offsetting collateral.428. Compare cover-page summaries, financial schedules, and supporting statements against one another; any mismatch should be preserved in the workbook and carried into the issues memo.439. Treat unsupported estimates, missing backup, old statements, and internally inconsistent dates as separate review issues rather than collapsing them into one generic note.4410. When a figure is uncertain, preserve the declarant’s stated amount and separately mark the uncertainty, rather than substituting a guessed correction.4511. Organize the issues memo by issue, and for each issue include the affected item, the nature of the concern, the source location, the practical consequence, and a concrete follow-up step.4612. Assign each issue a uniform severity label using an ordinal scale defined at the top of the memo, and apply it consistently across all entries.4713. End the memo with a short action list that assigns next steps to the appropriate role and ties them to the discovery or case-management timeline.4814. Before finalizing, confirm that the workbook contains the operative extracted data and reconciliation outputs, and that the memo reflects only issues supported by the source set.4950## 5. Vertical / structural / temporal relationships5152- Map each schedule in the declaration to a corresponding workbook tab, but preserve cross-references when one item spans multiple schedules or attachments53- Prefer the latest available balance or statement date for each recurring account; where dates differ across documents, preserve the discrepancy rather than overwriting it54- If a supporting document updates or narrows a declaration entry, treat the support document as a temporal overlay and note the hierarchy explicitly in the workbook55- Where an asset or debt has changed over time, record the date-specific figure alongside the current figure so later review can track movement56- If the source materials contain both summary and detailed figures, the detailed figure governs extraction but the summary inconsistency should remain flagged57- If counsel’s notes or intake materials identify a disputed category, elevate that category in the issues memo and link it back to the underlying schedule5859## 6. Output structure conventions6061- Produce two deliverables: a multi-tab `asset-extraction-workbook.xlsx` and an `issues-memo.docx`62- Workbook structure should follow the declaration’s schedules, with standardized columns for description, value, date, source, classification, support quality, and flags63- Include a reconciliation tab that totals assets, liabilities, and net worth, and a separate exceptions or notes tab for unresolved questions64- Preserve source traceability in every row so a reviewer can trace each extracted figure back to the declaration or attachment that supports it65- Use separate rows for separate accounts, parcels, policies, interests, and liabilities; do not aggregate unlike items merely to simplify totals66- In the memo, define the severity scale once, then provide one entry per issue with the affected item, source basis, concern, impact, and recommended follow-up67- Frame recommendations as concrete next steps directed to the appropriate role and tied to the case workflow, discovery posture, or filing timeline