Reimbursement Overview

Without a consolidated reimbursement view, administrators must manually compile expense data from individual approvals or external spreadsheets to understand their organization's financial exposure and reimbursement patterns. This overhead is both time-consuming and error-prone, particularly for organizations with large volunteer networks and high activity volumes. A purpose-built overview eliminates this manual work, giving administrators instant visibility into pending financial obligations, approval backlogs, and historical spend patterns. This supports better budget planning, faster detection of anomalies or abuse, and streamlined handoff to accounting systems like Xledger or Dynamics. For Bufdir-funded organizations, the ability to report on reimbursement totals by period is also directly relevant to grant reporting requirements.

The reimbursement overview is a server-side rendered Next.js dashboard page that aggregates data from the expenses and reimbursement_approvals tables via dedicated API endpoints returning pre-computed summary statistics. Aggregations are computed at query time using SQL GROUP BY on status, expense_type_id, and date ranges, with organization-scoped filtering enforced at the API layer. Time-series trend data is rendered using a lightweight charting library (e.g., Recharts). Drill-down navigation links from summary cards to the filtered expense approval queue. Export functionality generates CSV files server-side from the same filtered dataset, with content-disposition headers for direct download. Role scoping ensures coordinators see only their local association's data while org admins see the full organization. All queries are indexed on organization_id and status for performance.