๐Ÿ“– 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
73,438
Total Receipts
23,774
Matched (Paid)
49,664
Accruals (Unpaid)
77,058
Medsas Records
Total Invoice Amount
R 970,630,020.81
Total Medsas Paid
R 1,347,961,447.58
Matched Amount
R 313,358,017.44
23,774 records matched
Accrual Amount
R 657,272,003.37
49,664 records unpaid
Reconciliation Rate
32.4%
23,774 of 73,438 reconciled
View Accruals (49,664) View Matched (23,774)
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