📚 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 74,626.81
Received goods not yet paid for
📦 Total Quantity Received
6,239
Units received awaiting payment
🏥 Affected Facilities
1
Facilities with unpaid receipts
🏢 Affected Suppliers
4
Suppliers with unpaid receipts
📊 Monthly Accrual Breakdown
Sep 2026
💰 R 74,626.81 📦 6,239 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 74,626.81 | Records: 37,067 | Facilities: 1 | Suppliers: 4

📋 Accrual Items — Received but Not Paid

20 of 37,067
📅 Month 🏥 Facility 📍 District 🏢 Supplier 📋 Order No 📄 Invoice 🔢 NSN 📦 Qty Ord ✅ Qty Rec 💰 Amount 📅 Received Date 📋 Receipt No
Sep 2026 CATO MANOR CHC Ethekwini 1859.38 2007353 20073530 181927637 0 31 R 59.98 03 Sep 2026 CMC-REC/26-09-0244
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 1702707 26135895 181936075 1,370 383 R 1,225.60 03 Sep 2026 CMC-REC/26-09-0189
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 1702708 9010391490 181936074 4,150 354 R 4,417.02 03 Sep 2026 CMC-REC/26-09-0164
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 2007353 20073531 181936074 4,150 600 R 4,417.02 03 Sep 2026 CMC-REC/26-09-0164
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 1702713 9010397352 180292354 3,762 1,166 R 13,618.88 03 Sep 2026 CMC-REC/26-09-0030
Sep 2026 CATO MANOR CHC Ethekwini 5706.8 1702714 26137504 181854324 0 324 R 25.94 03 Sep 2026 CMC-REC/26-09-0045
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 1702717 37767840 180000649 104 40 R 6,812.00 03 Sep 2026 CMC-REC/26-09-0313
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 2007353 20073532 180000649 104 64 R 6,812.00 03 Sep 2026 CMC-REC/26-09-0313
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 1702719 I194720 181917243 357 357 R 5,658.45 03 Sep 2026 CMC-REC/26-09-0155
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 1702721 9010390830 222000438 647 232 R 928.00 03 Sep 2026 CMC-REC/26-09-0166
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 1702733 TPT010795 181859964 3,147 975 R 5,567.25 03 Sep 2026 CMC-REC/26-09-0142
Sep 2026 CATO MANOR CHC Ethekwini 309.16 1702743 9010370822 181830030 0 0 R 0.00 03 Sep 2026 CMC-REC/26-09-0185
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 1702745 9010376481 189762923 1,140 114 R 1,127.46 03 Sep 2026 CMC-REC/26-09-0221
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 1702751 INV91013 189762856 1,934 522 R 2,265.48 03 Sep 2026 CMC-REC/26-09-0035
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 1702755 37800055 181747912 323 78 R 5,727.60 03 Sep 2026 CMC-REC/26-09-0123
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 2007353 20073533 181747912 323 180 R 5,727.60 03 Sep 2026 CMC-REC/26-09-0123
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 1702756 37810232 181747914 133 133 R 4,478.11 03 Sep 2026 CMC-REC/26-09-0032
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 2007353 20073534 189714546 6 6 R 1,857.42 03 Sep 2026 CMC-REC/26-09-0202
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 1702758 INV89475 181750480 183 100 R 508.00 03 Sep 2026 CMC-REC/26-09-0236
Sep 2026 CATO MANOR CHC Ethekwini PPSD DDV 1702759 26135917 181750482 1,673 580 R 3,393.00 03 Sep 2026 CMC-REC/26-09-0186
Page 1 of 1854 (37,067 total records)
⚠️ Accrual Item — Received but NOT in MEDSAS Paid 💰 Total Accrual Liability: R 74,626.81 📦 Total Items: 6,239 🏥 Facilities: 1 🏢 Suppliers: 4
PPSD - Provincial Pharmaceutical Stock Depot • Accrual Report — Received but Not Paid • Generated 23 September 2026 11:01:33