System Overview
Quick Actions
Upload Data to Database
USASpending.gov CSV File
Or drag and drop your CSV file here
Puerto Rico Government Excel File
Or drag and drop your Excel file here
Run Matching Process
Start Automated Matching
This will match PR government grants with USASpending.gov records using FAIN, UEI, CFDA, and name similarity.
Review & Approve Matches
Sync with USASpending.gov
Automatic Grant Sync
This will connect to the USASpending.gov API, search for grants awarded to Puerto Rico recipients, download new grants, and automatically import them to your database. Duplicates are automatically detected and skipped.
- Syncs ALL Puerto Rico grants from USASpending.gov
- Updates amounts, outlays, CFDA numbers, dates, and agencies
- Imports any new grants not yet in the database
- Processes in chunks to avoid timeouts (~2,000 records per chunk)
Sync History
View your recent sync operations and their results.
Backfill Missing Data
Re-scan the USASpending.gov API to fill in missing CFDA numbers and outlay (disbursement) amounts for existing grants. This scans all Puerto Rico grants and may take a few minutes.
Export Data
📊 Export Matched Data
Export matched grants filtered by status or confidence level.
📁 Export Raw Data
Export complete datasets from your database.
Data Reports
Unmatched Grants Report
View grants from each data source that have no corresponding match.
Unmatched PR Grants
Unmatched USASpending Grants
Discrepancy Report
View amount, CFDA, and date mismatches between approved PR and USASpending records.
CFDA Program Summary
Aggregate view by CFDA program showing totals, match rates, and discrepancies.
Funding Utilization Report
Federal obligated amounts vs. actual outlays — shows how much grant money has been awarded and how much has been disbursed to Puerto Rico.
Recent Grant Changes
View recent field changes detected during syncs and uploads.