Auto Fill Fiscal Appropriation Detail V1

Commands

Parse to evidence JSON:

python scripts/fill_fiscal_appropriation_detail.py parse path/to/summary.md -o path/to/evidence.json

Fill a workbook:

python scripts/fill_fiscal_appropriation_detail.py fill path/to/summary.md -o path/to/output.xlsx --evidence-json path/to/evidence.json

Fill with a frozen cutoff date for testing:

python scripts/fill_fiscal_appropriation_detail.py fill path/to/summary.md -o path/to/output.xlsx --evidence-json path/to/evidence.json --as-of-date 2026-04-07

Convert bundled fixtures and refresh template assets:

python scripts/convert_fixtures.py

Run bundled regression tests:

python scripts/run_regression.py --as-of-date 2026-04-07

Run unit tests:

python -m pytest tests/test_fiscal_appropriation_detail.py

Assets

• assets/template.xlsx: bundled blank workbook template used for all production fills.
• assets/template-fingerprint.json: generated asset provenance and hashes.
• references/fixtures/: bundled sample summaries and reference answer workbooks.
• references/field-rules.md: field mapping and extraction rules.
• references/template-structure.md: workbook layout and row-writing rules.
• references/acceptable-differences.md: regression difference categories.
• references/executable-prompt.md: user-facing executable prompt and operating specification.

Guardrails

• Never treat a bookkeeping date as the payment date.
• Never treat an aggregate paid total as a payment detail.
• Never treat contract price, submitted settlement price, audited settlement price, or final account price as payment amount.
• Never include fees with no actual non-zero cash-flow transaction.
• Include refund rows as negative amounts when they are actual cash-flow transactions.
• Mark missing, inferred, unreliable, or OCR-suspicious cells in red in the original cell.
• Use the last-level fee title as the contract item.
• Reset sequence numbers inside each last-level fee item.
• Apply worker-wage and advance-payment receiver rules before default receiver rules.