📚 Accrual Report Help & Manual
This report shows all receipts that have been received at facilities but have NOT been matched to MEDSAS payments. These are your accrual items — goods received but not yet paid for.
📊 What Is an Accrual?

Understanding Accrual Liability

An accrual occurs when goods have been received at a facility (recorded in the Receipts table) but the payment has not been recorded in the MEDSAS system. This represents a liability — you have the goods but haven't paid for them yet.

Formula: Accrual = Total Received (Receipts) - Total Paid (MEDSAS)

📋 Data Sources

Where the Data Comes From

📦 Receipts (RX): Uploaded by facilities when goods are received. Contains facility, district, NSN, quantities, and costs.
💰 MEDSAS: Payment records from the MEDSAS system. Contains order numbers, invoice numbers, and amounts paid.
🔗 Matching Logic: First 7 digits of InvoiceNo_str = ord_no AND after '/' = invoice_no

🔍 How to Use This Report

Analyze Your Accruals

Use this report to:
• Identify all unpaid receipts across all facilities
• Track total accrual liability
• Monitor specific order and invoice details
• Export data for financial reporting and audit

📈 Key Metrics

Understanding the Numbers

Total Accrual Liability: Total value of goods received but not paid.
Quantity Received: Total units received but not paid.
Affected Facilities: Number of facilities with accruals.
Affected Suppliers: Number of suppliers with unpaid receipts.

📌 How to Read This Report:
  1. Review Summary Cards: The top cards show total accrual liability, quantity, facility count, supplier count, and record count at a glance.
  2. Analyze Monthly Trends: The monthly breakdown shows how accruals are distributed across months.
  3. Apply Filters: Filter by Facility or Supplier to narrow down results. Use the search box to find specific orders, invoices, or NSNs.
  4. Examine Individual Records: Each row shows a specific receipt that hasn't been paid. Review facility, supplier, order, invoice, NSN, quantities, and amount.
  5. Sort and Paginate: Click column headers to sort data. Use pagination controls to navigate through large datasets.
  6. Export Data: Use PDF or Excel buttons to export the report for external use, audit, or further analysis.

💡 Pro Tip: All records displayed are accrual items — goods received but not yet paid for. Prioritize older receipts for follow-up with suppliers.

📊 Total Accrual Liability
R 111,607.54
Received goods not yet paid for
📦 Total Quantity Received
6,177
Units received awaiting payment
🏥 Affected Facilities
1
Facilities with unpaid receipts
🏢 Affected Suppliers
1
Suppliers with unpaid receipts
📊 Monthly Accrual Breakdown
Oct 2026
💰 R 111,607.54 📦 6,177 units 📋 20 records 🏥 1 facilities
⚠️
What is an Accrual? These are goods that have been received at facilities (recorded in the Receipts table) but do not appear in the MEDSAS paid records. This represents a financial liability — goods received but not yet paid for.
Total accrual liability: R 111,607.54 | Records: 50,702 | Facilities: 1 | Suppliers: 1

📋 Accrual Items — Received but Not Paid

20 of 50,702
📅 Month 🏥 Facility 📍 District 🏢 Supplier 📋 Order No 📄 Invoice 🔢 NSN 📦 Qty Ord ✅ Qty Rec 💰 Amount 📅 Received Date 📋 Receipt No
Oct 2026 TURTON CHC Ugu DDV DEPOT 1726600 8920125539 189708531 1,200 300 R 1,161.27 07 Oct 2026 MAL-REC/26-10-0074
Oct 2026 TURTON CHC Ugu DDV DEPOT 1726672 8920125258 189712241 50 36 R 1,059.14 07 Oct 2026 MAL-REC/26-10-0079
Oct 2026 TURTON CHC Ugu DDV DEPOT 1726521 8920125266 222001255 3,000 390 R 68,620.50 07 Oct 2026 MAL-REC/26-10-0077
Oct 2026 TURTON CHC Ugu DDV DEPOT 1721127 1547352 180018948 408 408 R 7,061.46 07 Oct 2026 MAL-REC/26-10-0073
Oct 2026 TURTON CHC Ugu DDV DEPOT 1662989 STR016250 189762856 3,100 720 R 3,283.20 07 Oct 2026 MAL-REC/26-10-0088
Oct 2026 TURTON CHC Ugu DDV DEPOT 1670016 26140593 181798173 1,350 650 R 4,602.00 07 Oct 2026 MAL-REC/26-10-0083
Oct 2026 TURTON CHC Ugu DDV DEPOT 1670035 24881147 189763013 300 105 R 1,492.05 07 Oct 2026 MAL-REC/26-10-0078
Oct 2026 TURTON CHC Ugu DDV DEPOT 1670087 26141345 222001108 250 200 R 1,392.00 07 Oct 2026 MAL-REC/26-10-0087
Oct 2026 TURTON CHC Ugu DDV DEPOT 1670104 8920125476 189712241 60 36 R 1,059.14 07 Oct 2026 MAL-REC/26-10-0082
Oct 2026 TURTON CHC Ugu DDV DEPOT 1685072 26140592 181798173 560 560 R 3,964.80 07 Oct 2026 MAL-REC/26-10-0081
Oct 2026 TURTON CHC Ugu DDV DEPOT 1685118 INV0017172 189710187 1,135 374 R 2,184.16 07 Oct 2026 MAL-REC/26-10-0080
Oct 2026 TURTON CHC Ugu DDV DEPOT 1701946 26141249 181892380 330 200 R 848.00 07 Oct 2026 MAL-REC/26-10-0086
Oct 2026 TURTON CHC Ugu DDV DEPOT 1721206 8920125279 189708531 1,000 250 R 967.73 07 Oct 2026 MAL-REC/26-10-0072
Oct 2026 TURTON CHC Ugu DDV DEPOT 1721307 8920125304 189712241 50 36 R 1,059.14 07 Oct 2026 MAL-REC/26-10-0071
Oct 2026 TURTON CHC Ugu DDV DEPOT 1726572 8920125592 181821883 1,500 900 R 3,636.99 07 Oct 2026 MAL-REC/26-10-0075
Oct 2026 TURTON CHC Ugu DDV DEPOT 1726573 8920125284 189711820 200 200 R 4,978.12 07 Oct 2026 MAL-REC/26-10-0076
Oct 2026 TURTON CHC Ugu DDV DEPOT 1726590 9010436959 181936074 1,168 268 R 1,240.84 06 Oct 2026 MAL-REC/26-10-0066
Oct 2026 TURTON CHC Ugu DDV DEPOT 1726595 9010437039 189763014 400 144 R 576.00 06 Oct 2026 MAL-REC/26-10-0067
Oct 2026 TURTON CHC Ugu DDV DEPOT 1726609 9010437429 180339466 100 100 R 759.00 06 Oct 2026 MAL-REC/26-10-0056
Oct 2026 TURTON CHC Ugu DDV DEPOT 1726637 9010436540 189711414 300 300 R 1,662.00 06 Oct 2026 MAL-REC/26-10-0057
Page 1 of 2536 (50,702 total records)
⚠️ Accrual Item — Received but NOT in MEDSAS Paid 💰 Total Accrual Liability: R 111,607.54 📦 Total Items: 6,177 🏥 Facilities: 1 🏢 Suppliers: 1
PPSD - Provincial Pharmaceutical Stock Depot • Accrual Report — Received but Not Paid • Generated 14 October 2026 21:58:46