๐Ÿ“– Payment Reconciliation Dashboard
Complete financial overview and reconciliation management
Step 1

๐Ÿ“Š Financial Overview

View key financial metrics including total orders, quantities, and amounts in R.

Step 2

๐Ÿ” Filtering & Searching

Use the search bar above each table to filter records by any column.

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:
  1. View Financials: Check the summary cards for key metrics in R
  2. Browse Data: Review receipts and medsas paid records
  3. Reconcile: Click "Check & Reconcile" to update statuses
  4. Export: Use export buttons to download complete table reports
  5. Accruals: Click "View Accruals" for unmatched records
59,288
Total Receipts
23,259
Matched (Paid)
36,029
Accruals (Unpaid)
77,058
Medsas Records
Total Invoice Amount
R 776,718,497.01
Total Medsas Paid
R 1,347,961,447.58
Matched Amount
R 290,109,417.50
23,259 records matched
Accrual Amount
R 486,609,079.51
36,029 records unpaid
Reconciliation Rate
39.2%
23,259 of 59,288 reconciled
View Accruals (36,029) View Matched (23,259)
Receipts Table
59,288 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