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
73,438
Total Receipts
23,774
Matched (Paid)
49,664
Accruals (Unpaid)
77,058
Medsas Records
88
Total Facilities
Total Invoice Amount
R 970,630,020.81
Total Medsas Paid
R 1,347,961,447.58
Reconciliation Rate
32.4%
Facility Compliance Report
Monthly facility reporting compliance tracking
Total Facilities
88
Avg Compliance Rate
93.2%
Best Month
Aug 2026
Worst Month
Oct 2026
| Month | Submitted | Total | Compliance % | Status | Actions |
|---|---|---|---|---|---|
| August 2026 | 85 | 88 | ✅ Excellent | ||
| September 2026 | 85 | 88 | ✅ Excellent | ||
| October 2026 | 76 | 88 | ✅ Excellent |
Receipts Table
73,438 records
| ID | Invoice No | Demander | Facility | District | Qty Ord | Qty Rec | Supplier | Order Date | Month | Status |
|---|
Medsas Paid Table
77,058 records
| ID | Order No | Invoice No | Amount | Supplier | Depot | Start | End | Qty | Month |
|---|