FedReconcile – GTAS Module

AI-Driven GTAS Reconciliation

FedReconcile’s GTAS Module automates federal financial reconciliation, validates Treasury edits, and produces Oracle-ready corrections—ensuring a clean close every time.

Explore Workflow

🔁 Phase 1: File Upload & Initial Reconciliation

  • User uploads:
    • ✅ Trial Balance CSV (ERP source)
    • ✅ GTAS ATB CSV (Treasury source)
  • System performs ERP-to-GTAS Reconciliation:
    • Matches TAS, USSGL, and amounts
    • Detects discrepancies (e.g., TAS mismatch, field-level errors)
    • Stores both files in Supabase
    • Session metadata saved to DB
  • Output:
    • JSON with matched & mismatched records
    • Populates Reconciliation Dashboard

🧠 Phase 2: AI Correction & User Approval

  • AI Suggests Corrections:
    • Field-level fixes
    • Journal voucher recommendations
    • Slack/missing segment warnings
  • User reviews the mismatch dashboard:
    • Accepts or rejects corrections line-by-line
    • Accepted corrections queue Journal FBDI rows
  • System generates:
    • ✅ Updated FBDI file for Oracle Journal Import

🔄 Phase 3: Re-run & Ensure Clean Reconciliation

  • User uploads corrected Trial Balance
  • System re-runs reconciliation against GTAS ATB
  • Goal: Trial Balance cleanly matches GTAS ATB

🔍 Phase 4: GTAS Validation & Edits Checks

  • GTAS ATB file runs through:
    • ✅ GTAS Edit Checks (JSON)
    • ✅ GTAS Validations (JSON + AI explanations via RAG)
  • System identifies:
    • Treasury-critical fails (e.g., improper USSGL pairings)
    • AI-generated rationale + fix logic
  • Final Output:
    • Clean GTAS ATB file
    • Readiness for Treasury submission

Ready to Clean Your Books with Confidence?

Pilot the GTAS Module and reduce time-to-certification by automating validation, correction, and audit support.

Request a Demo