Donation Settlement Report

Donation Settlement Report

Component File: src/features/reports/components/DonationSettlementReport.tsx Route / navigation: Path /reports/donation-settlement-report, Zustand reportTool = donation-settlement-report. See 00-REPORTS-HUB.md. Access Level: Parent organization users with Reports access Status: Current

Overview

Donation Settlement Report is a parent-org-only export surface for finance users who need a flat spreadsheet of donation activity, donor contact fields, fund/purpose attribution, Stripe fees, and payout arrival dates.

Runtime Behavior

• Default donation date range is current calendar year through today.
• Payout date filters are optional. When donation and payout filters are both populated, rows must satisfy both ranges.
• Server-side pagination uses 25 / 50 / 100 rows with PaginationControls above and below the table.
• Export supports CSV and XLSX with the full detailed column set, regardless of the smaller on-screen table.
• Missing optional values export as empty strings.
• Payout arrival comes from Stripe payout data and can be blank for manual gifts, non-Stripe gifts, or Stripe donations without resolved payout line evidence.

Data Source

The report uses get_donation_settlement_report_page, which joins:

• donations
• donors
• organizations
• purposes
• donation_fee_components
• stripe_payout_line_items
• stripe_payouts

Fee display uses exact donation_fee_components.actual_amount first, estimated component amount only when actual is unavailable, then legacy donations.stripe_fee_actual for card fee fallback. donations.processing_fee remains a separate donor-covered fee estimate. The report must not infer fees from payout gaps or uncleared receivable balances.

Access / Gating

• Tool id: donation-settlement-report
• Reports hub tile: parentOrgOnly: true
• RPC guard: jwt_is_parent_org_admin()
• Fund users do not see the tile and direct navigation shows the parent-org-only denial screen.

Synced from IFMmvp-Frontend documentation: pages/reports/19-DONATION-SETTLEMENT-REPORT.md