Payment Reconciliation Dashboard
Complete financial overview and compliance tracking
Step 1
📊 Financial Overview
View key financial metrics including total orders, quantities, and amounts in R.
Step 2
📋 Compliance Tracking
Monitor facility reporting compliance across the last 12 months.
Step 3
🔄 Reconciliation
Click "Check & Reconcile" to refresh all tables and verify payment statuses.
Step 4
📈 Export Reports
Download complete table data as PDF, Excel (XLS), or CSV for analysis.
📌 Quick Start Guide:
- View Financials: Check the summary cards for key metrics in R
- Monitor Compliance: Review the compliance section for facility reporting status
- Reconcile: Click "Check & Reconcile" to update statuses
- Export: Use export buttons to download complete table reports
- Accruals: Click "View Accruals" for unmatched records
59,250
Total Receipts
34,603
Matched (Paid)
24,647
Accruals (Unpaid)
97,223
Medsas Records
68
Total Facilities
Total Invoice Amount
R 949,723,606.07
Total Medsas Paid
R 1,752,449,985.54
Reconciliation Rate
58.4%
Facility Compliance Report
Monthly facility reporting compliance tracking
Total Facilities
68
Avg Compliance Rate
100.0%
Best Month
Oct 2026
Worst Month
Oct 2026
| Month | Submitted | Total | Compliance % | Status | Actions |
|---|---|---|---|---|---|
| October 2026 | 68 | 68 | ✅ Excellent |
Receipts Table
59,250 records
| ID | Invoice No | Demander | Facility | District | Qty Ord | Qty Rec | Supplier | Order Date | Month | Status |
|---|
Medsas Paid Table
97,223 records
| ID | Order No | Invoice No | Amount | Supplier | Depot | Start | End | Qty | Month |
|---|