Accounting & Execution

Obligation analysis

Budget execution the USSGL way. Track obligation rates by quarter, flag aging ULOs, identify expiring-year cancellation risk, and distinguish budget authority from obligations from outlays. Live DoD data pulled weekly from USASpending.gov.

Live data feed — USASpending.gov

DoD obligation data — automated weekly pull

A GitHub Action runs every Sunday and pulls current-period DoD obligation totals, federal account breakdowns, and top contract awards from the USASpending.gov API. The data is automatically chunked, embedded, and added to the accounting knowledge base — no manual upload needed.

Agency obligations Federal accounts Budget functions Top contract awards Obligation rates
USASpending API GitHub Actions

Setup required

  1. 1. In Vercel → Settings → Environment Variables, add INGEST_SECRET with any long random string.
  2. 2. In GitHub → your repo → Settings → Secrets and variables → Actions, add two secrets:
  3. INGEST_URL = https://fedfm.vercel.app/api/ingest
  4. INGEST_SECRET = same value as in Vercel
  5. 3. Push this code to GitHub. The Action runs automatically every Sunday, or trigger it manually from the Actions tab.

Quick actions

Obligation rate analysis
Quarterly obligation rates by TAFS. Flag Q4 spikes, back-loading, expiring fund risk.
ULO / UDO analysis
Stale and aging ULOs by age bucket. Highlight cancellation-risk exposure.
TAFS summary
Period-of-availability table across TAFS with cancellation dates and status.
BA vs Obligations vs Outlays
Three-way comparison with waterfall chart. Identify execution-timing gaps.
Object class breakdown
Spending by OC category. Surface major cost drivers (personnel, contracts, equipment).
Compliance red flags
FFMIA compliance, USSGL posting anomalies, ADA risk indicators.

Document library

Open library

Upload accounting and execution data

Financial statements, SF-133 reports, execution reports, obligations/outlays data, USSGL trial balances.