1---2name: extract-assets-from-financial-declaration3task_id: trusts-estates-private-client/extract-assets-from-financial-declaration4description: 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.5activates_for: [planner, solver, checker]6metadata:7 source: https://skillmd.com/skills/finchipaiorg/extract-assets-from-financial-declaration8---910# Skill: Extract and Reconcile Assets from Opposing Party's Financial Declaration1112## 2. Failure modes the skill is correcting1314- Producing a flat list of items instead of a structured workbook that mirrors the declaration’s own schedule logic15- Missing asset-by-asset reconciliation, especially where value depends on balance date, encumbrances, or cash-surrender treatment16- Treating stated face amounts, estimates, or ranges as if they were settled values without flagging the valuation basis17- Accepting business or professional interest figures without noting methodology gaps, discount treatment, or goodwill classification issues18- Omitting liability classification problems, including pre-existing debt, contingent debt, or unclear payor responsibility19- Failing to compare summary pages against detailed schedules, which leaves internal inconsistencies unflagged20- Overlooking stale statements, unsupported assertions, or missing backup that should be sent back for supplementation21- Drafting an issues memo that describes problems but does not tie each one to the relevant schedule, practical effect, and next step2223## 3. Legal frameworks / domain conventions that apply2425- Use the declaration’s own schedule architecture as the organizing framework for extraction, then normalize it into a workbook with consistent fields26- Distinguish marital, separate, exempt, or disputed classifications where the declaration or supporting materials provide a basis to do so27- For real property, record value, secured debt, and resulting equity; note any missing lien information, tax arrears, or assumed encumbrances28- For liquid accounts, prefer the most current statement date available in the source set and flag older balances as potentially stale29- For retirement assets, note plan type, vested balance if shown, and whether division may require a transfer order or other administrative step30- For life insurance, distinguish term coverage from permanent coverage and report cash value rather than face amount when a divisible value exists31- For business interests, record ownership percentage, valuation method, discounts, and any indication that personal versus enterprise goodwill matters32- For vehicles and tangible personal property, separate asserted value from evidence quality, source date, and any lien or finance balance33- For liabilities, capture creditor, amount, payment status, maturity, and whether the debt predates the relevant relationship period if that appears material34- For income, compare any summary figure to the underlying detailed schedule and flag discrepancies or omitted components35- Apply the governing family-law, property-classification, and disclosure principles recognized in the jurisdiction reflected by the source materials when the declaration itself invokes them3637## 4. Analytical scaffolds38391. 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.402. Build the workbook first as a schedule-aligned extraction, then add a reconciliation sheet that totals assets, liabilities, and net worth across categories.413. For each item, capture at minimum: owner/name, category, description, stated value, statement or valuation date, source document, classification, and review flags.424. 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.435. 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.446. 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.457. For liabilities, note whether the debt is secured or unsecured, whether it appears current or delinquent, and whether the source documents show offsetting collateral.468. 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.479. Treat unsupported estimates, missing backup, old statements, and internally inconsistent dates as separate review issues rather than collapsing them into one generic note.4810. When a figure is uncertain, preserve the declarant’s stated amount and separately mark the uncertainty, rather than substituting a guessed correction.4911. 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.5012. 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.5113. 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.5214. 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.5354## 5. Vertical / structural / temporal relationships5556- Map each schedule in the declaration to a corresponding workbook tab, but preserve cross-references when one item spans multiple schedules or attachments57- Prefer the latest available balance or statement date for each recurring account; where dates differ across documents, preserve the discrepancy rather than overwriting it58- 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 workbook59- Where an asset or debt has changed over time, record the date-specific figure alongside the current figure so later review can track movement60- If the source materials contain both summary and detailed figures, the detailed figure governs extraction but the summary inconsistency should remain flagged61- 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 schedule6263## 6. Output structure conventions6465- Produce two deliverables: a multi-tab `asset-extraction-workbook.xlsx` and an `issues-memo.docx`66- Workbook structure should follow the declaration’s schedules, with standardized columns for description, value, date, source, classification, support quality, and flags67- Include a reconciliation tab that totals assets, liabilities, and net worth, and a separate exceptions or notes tab for unresolved questions68- Preserve source traceability in every row so a reviewer can trace each extracted figure back to the declaration or attachment that supports it69- Use separate rows for separate accounts, parcels, policies, interests, and liabilities; do not aggregate unlike items merely to simplify totals70- 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-up71- Frame recommendations as concrete next steps directed to the appropriate role and tied to the case workflow, discovery posture, or filing timeline