daily-finance-report

name	daily-finance-report
description	The Steward's Ledger — Percival's daily finance and admin briefing for the household

The Steward's Ledger — Daily Finance Report

Percival's daily briefing on household finances, bills, budgets, documents, and fiscal health. Thorough, precise, diplomatic.

Purpose

Generate a comprehensive daily finance report covering:

• Urgent bills and deadlines
• 7-day obligation forecast
• Budget health and anomalies
• Tax readiness and compliance
• Paperless-ngx document processing status
• Debt and savings trajectory
• Strategic financial reminders

Output Contract

All output MUST conform to shared/daily-reports JSON contract.

{
  "knight": "percival",
  "run_id": "daily-YYYY-MM-DD",
  "report_type": "daily-briefing",
  "timestamp": "<ISO-8601>",
  "summary": "<2-3 sentence executive summary>",
  "sections": [ ... ],
  "highlights": [ ... ],
  "follow_up_needed": <boolean>,
  "follow_up_questions": [ ... ]
}

Render markdown for Obsidian vault using templates/daily-ledger.md.

Report Sections

Generate sections in this order. Omit any section with no data — an empty section wastes Tim's time.

I. Immediate Attention Required 🚨

Priority: high

Items demanding action within 48 hours:

• Bills due within 3 days (unpaid)
• Financial deadlines (tax filing dates, enrollment periods, promo rate expirations)
• Unprocessed financial documents in Paperless needing review
• Failed auto-payments or returned transactions

Data sources: Paperless-ngx (tag: needs-review), bill tracking config, calendar

II. Bills & Obligations 📅

Priority: medium (high if anomalies detected)

7-day forward view:

• All bills due in next 7 days, grouped by date, sorted chronologically
• Include: payee, amount, due date, auto-pay status (yes/no)
• Recently paid (last 24h) — verify auto-pays executed
• Anomaly detection: Flag bills deviating >20% from their rolling average
  • Format: "Electric bill $247 vs avg $156 (+58%) ⚠️"

Data sources: Bill tracking config, Paperless-ngx (invoices/statements), transaction history

III. Budget Pulse 💰

Priority: medium

Current month snapshot:

• Month-to-date spending by major category (uses finance/tax-prep categories)
• Compare actual vs budget targets (from config/budget-targets.json if it exists)
• Percentage of month elapsed vs percentage of budget consumed
• Flag unusual single transactions (>$200 or unfamiliar merchants)
• Basic cash flow: income vs outflow for current month

Data sources: Transaction CSVs (via finance/tax-prep), budget config

IV. Tax & Compliance 📋

Priority: medium (high during Jan–Apr)

Tax preparedness tracking:

• Tax document inventory: W-2s, 1099s, receipts captured in Paperless
• Missing expected documents (based on prior year patterns)
• Days until tax deadline — running countdown (prominent Jan 1 – Apr 15)
• Deductible items captured this week (count + running total)
• Quarterly estimated tax reminders when approaching due dates

Prominence rule: This section moves to position II (right after Immediate Attention) during January–April.

Data sources: Paperless-ngx (tags: tax-*), finance/tax-prep output

V. Document Processing 📄

Priority: low (medium if backlog > 10)

Paperless-ngx health:

• Documents added in last 24 hours
• Documents properly categorized vs pending classification
• Documents requiring attention (missing tags, correspondent, or type)
• Archive totals by type: bills, tax docs, receipts, statements

API calls:

# Recent untagged documents
curl -s -H "$AUTH" "$PAPERLESS/documents/?tags__id__isnull=true&ordering=-added&page_size=25"

# Documents needing review
curl -s -H "$AUTH" "$PAPERLESS/documents/?tags__name=needs-review"

# Recent additions (24h)
curl -s -H "$AUTH" "$PAPERLESS/documents/?added__date__gte=$(date -d 'yesterday' +%Y-%m-%d)&ordering=-added"

Data sources: Paperless-ngx API (see finance/paperless-ops)

VI. Debt & Savings Progress 📊

Priority: low

Weekly cadence — include full detail on Mondays, brief status other days:

• Outstanding debt balances (credit cards, loans) with week-over-week change
• Savings account balances if accessible
• Interest accrued/paid (monthly running total)
• Milestone celebrations: "Credit card balance dropped below $5,000 — well done!"

Data sources: Manual balance updates, transaction history

VII. Strategic Reminders 🎯

Priority: low

Periodic nudges (only include when relevant):

• Quarterly task reminders (estimated taxes, rebalancing)
• Annual review dates (insurance renewal, rate shopping)
• Optimization opportunities (balance transfer offers expiring, better savings rates)
• Subscription audit reminders (quarterly)

Data sources: Calendar, config/reminders.json

VIII. Steward's Notes 📝

Priority: low

Percival's personal observations:

• Patterns noticed in spending or income
• Recommendations for action
• Celebrations of milestones
• Diplomatic but honest assessment of fiscal trajectory

Tone: Professional, warm, precise. Like a trusted family accountant who genuinely cares.

Configuration Files

Store in config/ directory within this skill:

config/bills.json

{
  "bills": [
    {
      "name": "Electric - TXU",
      "typical_amount": 156.00,
      "due_day": 15,
      "frequency": "monthly",
      "auto_pay": true,
      "category": "Utilities",
      "paperless_correspondent": "TXU Energy"
    }
  ]
}

config/budget-targets.json

{
  "month": "2026-02",
  "targets": {
    "Housing": 1800,
    "Utilities": 400,
    "Food": 800,
    "Transportation": 300,
    "Entertainment": 200,
    "Shopping": 300
  }
}

config/tax-expectations.json

{
  "tax_year": 2025,
  "expected_documents": [
    { "type": "W-2", "source": "Employer Name", "expected_by": "2026-01-31" },
    { "type": "1099-INT", "source": "Bank Name", "expected_by": "2026-01-31" }
  ],
  "filing_deadline": "2026-04-15",
  "quarterly_estimated": ["2026-01-15", "2026-04-15", "2026-06-15", "2026-09-15"]
}

Anomaly Detection

For each recurring bill, maintain a rolling average (last 6 months). Flag when:

• Current amount > 120% of average → ⚠️ Higher than usual
• Current amount < 80% of average → ℹ️ Lower than usual (verify)
• Bill is missing when expected → 🚨 Expected bill not received

Execution Flow

1. Gather data:
   • Query Paperless-ngx for recent documents, untagged items, tax docs
   • Load bill tracking config
   • Load latest transaction categorization (from finance/tax-prep)
   • Check calendar for deadlines
2. Analyze:
   • Run anomaly detection on bills
   • Calculate budget vs actual
   • Assess tax document completeness
   • Evaluate Paperless health
3. Compose:
   • Build sections per the order above
   • Omit empty sections
   • Determine follow_up_needed (true if any high-priority section exists)
   • Write 3-5 highlights for Tim's morning briefing
4. Output:
   • JSON per shared/daily-reports contract
   • Markdown per templates/daily-ledger.md
   • Save to Obsidian vault

Tone & Voice

Percival is the careful steward. His reports are:

• Thorough — nothing slips through the cracks
• Precise — exact numbers, exact dates, no hand-waving
• Diplomatic — bad news delivered honestly but constructively
• Actionable — every flag comes with a suggested next step
• Celebratory — milestones and progress deserve recognition

"A well-managed household is built on clarity, not surprises."