E14-F3: Financial Reconciliation Report¶
Epic: E14: Reporting & Analytics
Size: M (Medium)
Problem / Outcome¶
Reconcile payments and manage delayed payments.
Scope¶
In-Scope:
- Payment status by method (card, deferred)
- Delayed payment tracking (pending, overdue, paid)
- Invoice status from e-racuni
Out-of-Scope:
- Bank statement import
Acceptance Criteria¶
- AC1: Report shows payment breakdown by method
- AC2: Delayed payments filterable by status (pending, overdue, paid)
- AC3: Invoice status from e-racuni displayed
Data Model Impact¶
No new tables required (read queries).
Report sections:
1. Payment Summary by Method:
- card_payments_count
- card_payments_amount
- deferred_payments_count
- deferred_payments_amount
- total_revenue
2. Delayed Payments:
- debtor_name
- payment_offer_number
- total_amount
- due_date
- status (pending, overdue, paid)
- days_overdue
- e_racuni_status
3. Invoice Status:
- invoice_number
- e_racuni_reference
- amount
- fiscalization_status
- issued_at
Filters:
- date_from, date_to
- match_id
- payment_method
- payment_status
Permissions/Roles¶
- Admin (Finance)
How to Verify¶
npm test -- --grep "financial report"
Expected: Correct payment data displayed.
Dependencies¶
Implementation Tasks¶
See E14: Reporting ## Doc References Analytics Tasks
Doc References¶
Last Updated: January 2026