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
PRIFAS Upload (Periodic Sync)
Upload a PRIFAS export file (CSV or Excel) with columns: Award Number, Award Description, Start Date, End Date, CFDA, Sponsor, Agency, Total Award, Expended, Remaining Balance. Records are matched on Award Number: existing records are updated (preserving USASpending links), new records are inserted.
Or drag and drop your 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.
Discrepancy Report - End Date
Matched PRIFAS records where End Date differs from USASpending Period of Performance End Date.
Discrepancy Report - Amount
Matched PRIFAS records where reported amounts differ from USASpending. Compares both Total Award vs Obligated and Expended vs Outlayed.
Awards Not In PRIFAS
USASpending records that have no active PRIFAS-sourced match.
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.