▤Invoice Summary — MDMC.2026.02
DRAFT
Logan & Seiler, Inc.
406 S Main St · Charleston, MO 63834 · [email protected]
SOW7SPa.2026.02
Sikeston Pharmacy Management
7465
$43,940.00
SOW7BPa.2026.02
Benton Pharmacy Management
7466
$29,009.00
SOW7SPb.2026.02
Sikeston Pharmacy Pass Through Expenses
7465
$4,235.42
SOW7BPb.2026.02
Benton Pharmacy Pass Through Expenses
7466
$1,589.68
SOW7SPc.2026.02
Sikeston Pharmacy Pass Through COGs LS Inc
7465
-$26,487.61
SOW7BPc.2026.02
Benton Pharmacy Pass Through COGs LS Inc
7466
-$5,335.89
SOW7SPd.2026.02
Sikeston Pharmacy 340B Patient Care Service Delivery
7465
$28,245.47
SOW7BPd.2026.02
Benton Pharmacy 340B Patient Care Service Delivery
7466
$7,723.09
SOWPH1.2026.02
Population Health Chronic Care Management
7700
$3,040.00
Invoice Total
$85,959.16
⟋Sikeston 340B Metrics — Feb 2026
Verified
| Metric | Value | Status |
|---|---|---|
| Total Rx Carved In | 2,986 | ✓ ok |
| Reversals | 41 | ✓ ok |
| Reversal Credit | -$1,381.56 | ⚠ verify |
| CB MSDMA000 (100% Pay) | 202 | exact |
| CB MSDMB000 (Charity) | 0 | exact |
| MDMC Employee Rx | 197 | ✓ ok |
| Qualifying Rx (Svc Fee) | 2,684 | ✓ ok |
| Non-CB/Emp Svc Fee (14%) | $29,061.43 | ✓ ok |
| CE Retained Savings | $178,520.20 | ✓ ok |
| Brands Dispensed (Rx) | 500 | ✓ ok |
| Brand % of Prog Rev | 7.79% | ✓ ok |
| Generics Dispensed (Rx) | 2,184 | ✓ ok |
| Generic % of Prog Rev | 9.91% | ✓ ok |
| Unique Patients | — | manual |
| Patients w/ Active Care Plan | 409 | Pioneer Rx |
✓Ground Truth Validation
9/9 pass
NoReversals Rows
2,986 / target ~2,986 ±15
Savings Rows
2,684 / target ~2,684 ±15
Non-CB/Emp Svc Fee ($)
$29,061 / target $29,061 ±$100
CE Retained Savings ($)
$178,520 / target $178,520 ±$500
Brand % Rev
7.79% / target 7.79% ±0.5%
Generic % Rev
9.91% / target 9.91% ±0.5%
CB MSDMA000 Count
202 / target 202 (exact)
CB MSDMB000 Count
0 / target 0 (exact)
◫Required Inputs — February 2026
1 of 2 uploaded
Exactly 2 files are required each billing run. All processing, savings calculations, service fee calculations, and CE retained calculations derive entirely from these two sources. No other files should be uploaded — the JH workbook, invoice template, and instructions document are internal references only.
File 1 of 2 — Third Party Claims Report
SP_340B_CarveIN_02_2026_SCRUBBED.xlsx
✓ Ready
Pattern: SP_340B_CarveIN_<MM>_<YYYY>_SCRUBBED.xlsx
File 2 of 2 — ABC PHS Catalog Pricing File
Not yet uploaded
Missing
Pattern: <YYYY>_<MM>_<DD>_ABCPHS_Catalog.xlsx
· ⚠ Required before pipeline can run
Drop files here or click to upload
XLSX or CSV · CarveIN claims or ABC PHS Catalog
Pipeline gate
Both files must be uploaded and validated before the 340B pipeline can execute.
☰Internal Reference Files — Not Ingested
Read-only
These files inform the system architecture and are used for QA and output templates, but are not uploaded monthly and are not part of the ingestion pipeline.
📊
SP_340B_CarveIN_02_2026_SCRUBBED_JH.xlsx
Analyst (JH) processed version — QA reference only, not ingested
QA ref
💰
MDMC_Services_Invoice_2026_February.xlsx
Invoice output template — generated by this system, not ingested
output
📈
SP_Trend_Report_2026_February.xlsx
Trend Report — populated from pipeline run metrics + manual values, not ingested
output
📄
MDMC Trend Report Instructions.docx
Processing instructions — informational only, not ingested
ref doc
⟳340B Pipeline — 10-Tab Processor
Last run: 3-10-2026
Load CarveIN file
3,433 rows · 115 cols
Build NDC catalog lookup
42,000+ NDCs · first-match rule
Add 6 computed columns
PHS cost · svc fee · CE returns
Net-pair deduplication
→ 2,986 NoReversals · 43 Reversals
Build Tab 1: All
3,433 rows + computed cols
Build Tab 2: NoReversals
2,986 rows
Build Tab 3: Reversals
43 rows + summary
Build Tabs 4–6: CB / Emp / Patients
CB: 202 · Emp: 197 · Patients sorted
Build Tab 7: Savings
2,684 qualifying rows + summary
Build Tabs 8–9: Brand / Generic
500 brand · 2,184 generic
Compute metrics & write output
Reversal credit requires analyst verify
⚠Data Quality Report
Attention needed
NDC Catalog Match Rate
96.8%
match
3,320 of 3,433 NDCs matched
113 unmatched → 6 computed cols blank
⚠ ABC Catalog file needed for full match
Multi-Price NDCs (first used)
~1,170 NDCs appear with multiple lot prices in catalog. First occurrence used per build spec.
Reversal Credit — ⚠ Analyst Verification Required
Computed reversal credit: -$1,381.56
Excludes MSDMA000 rows & employee bins [24160, 17688].
Analyst manual calc may differ by up to ~$200.
Do not submit invoice without confirmation.
Excludes MSDMA000 rows & employee bins [24160, 17688].
Analyst manual calc may differ by up to ~$200.
Do not submit invoice without confirmation.
⬡Sikeston Pharmacy 340B Patient Care Service Delivery
SOW7SPd.2026.02
DRAFT
Description
Qty
Rate
Amount
340B: Reversal Credits ⚠ analyst verify
41
0.14
-$1,381.56
Community Benefit MSDMB000 Pharmacist Service Fee
—
Carved Out
N/A
Community Benefit MSDMA000 Pharmacist Service Fee
202
$20 × 14%
$565.60
MDMC Employee – Pharmacist Service Fee
—
Carved Out
N/A
Pharmacist Service Fee (excluding Employees & Community Benefits)
2,684
14%
$29,061.43
Invoice Subtotal
$28,245.47
⚠
Reversal credit of -$1,381.56 is system-computed. Analyst confirmation required before submitting invoice. Tolerance vs manual calc: may differ up to ~$200.
⬡Benton Pharmacy 340B Patient Care Service Delivery
SOW7BPd.2026.02
Description
Qty
Rate
Amount
340B: Reversal Credits
14
0.14
-$657.19
Community Benefit Charity Rx Service Fee
—
Carved Out
$0.00
Community Benefit Pharmacist Service Fee
28
$20 × 14%
$78.40
MDMC Employee – Pharmacist Service Fee
—
Carved Out
N/A
Pharmacist Service Fee (excluding Employees & Community Benefits)
693
14%
$8,301.88
Invoice Subtotal
$7,723.09
⬡Sikeston Pharmacy Management
SOW7SPa.2026.02
Description
Qty
Rate
Amount
Completed / Dispensed Rx
6,530
$3.00
$19,590.00
Management Fixed Fee
1
—
$24,350.00
Subtotal
$43,940.00
Benton Pharmacy Management
SOW7BPa.2026.02
$29,009.00
See source invoice tab for breakdown
⬡Population Health CCM
SOWPH1.2026.02
Description
Qty
Rate
Amount
Chronic Care Management – Billed Patients
76
$40.00
$3,040.00
Subtotal
$3,040.00
⌨Manual Entry
2 pending
Values that cannot be derived from the two ingested files are entered here monthly. All entries are tracked in the Audit Trail with entered-by and timestamp metadata.
Section
Adjustment Type
Description
Quantity
Amount ($)
Source Reference (required for validation)
Pending Manual Entries
Blocking export
340B Patients Screened / Active Care Plan
Pending
Pull monthly from Pioneer Rx — not derivable from CarveIN or Catalog
⚠ Required for Trend Report · Feb 2026 not yet entered
Reversal Credit Analyst Confirmation
Unconfirmed
System computed: -$1,381.56 · may differ from manual calc by ~$200
⚠ Analyst must confirm before invoice can be submitted
☰Audit Trail — February 2026
12 events
| Timestamp | Actor | Event | Entity | Detail |
|---|---|---|---|---|
| 2026-03-10 14:32 | JH | FILE_UPLOAD | source_file #1 | SP_340B_CarveIN_02_2026_SCRUBBED.xlsx · 3,433 rows |
| 2026-03-10 14:33 | System | PARSE_COMPLETE | source_file #1 | 115 columns validated · all required cols present |
| 2026-03-10 14:35 | System | PIPELINE_RUN | pipeline_run #1 | 10 tabs · 2,986 NoReversals · 43 Reversals · 2,684 Savings |
| 2026-03-10 14:35 | System | WARNING | pipeline_run #1 | Reversal credit -$1,381.56 flagged — analyst confirm required |
| 2026-03-10 14:35 | System | WARNING | pipeline_run #1 | NDC match rate 96.8% · 113 unmatched (ABC Catalog not uploaded) |
| 2026-03-10 14:40 | System | INVOICE_DRAFT | invoice_run #1 | MDMC.2026.02 · 9 line items · $85,959.16 total |
| 2026-03-10 14:42 | System | VALIDATION | invoice_run #1 | 11/13 checks pass · 2 open items blocking approval |
| — | — | PENDING | manual_adj | Pioneer Rx patient count — not yet entered |
| — | — | PENDING | manual_adj | Reversal credit analyst confirmation — unconfirmed |
⌨Manual Entry
2 pending
Section
Adjustment Type
Description
Quantity
Unit Rate ($)
Amount ($)
Notes / Source Reference
Pending Manual Entries
Requires approval
340B Patients Screened / Active Care Plan
Pending
Source: Pioneer Rx — must be pulled manually each month
⚠ Required for Trend Report row 40 — not yet entered for Feb 2026
Reversal Credit Analyst Confirmation
Unconfirmed
System computed: -$1,381.56 · Analyst must confirm before invoice submit
⚠ May differ from manual calc by up to ~$200
✓Pre-Submission Validation
11/12 pass
SP 340B source file uploaded
PASS
SP 340B pipeline run completed
PASS
ABC PHS Catalog file uploaded (required for full NDC match)
WARN
NoReversals row count within tolerance ±15
PASS
Savings row count within tolerance ±15
PASS
CB MSDMA000 count = 202 (exact)
PASS
CB MSDMB000 count = 0 (exact)
PASS
Non-CB/Emp svc fee within $29,061 ±$100
PASS
CE retained savings within $178,520 ±$500
PASS
All invoice sections have GL code assigned
PASS
Section subtotals reconcile with Summary page
PASS
Reversal credit confirmed by analyst
UNCONFIRMED
Pioneer Rx patient count entered for Feb 2026
MISSING
↗Export Invoice
2 items blocking
XLSX Review
Download
Draft with supporting detail tabs
PDF Final
Locked
Requires full validation pass
Trend Report PDF
Ready
SP Trend Report Feb 2026
Blocking items before final export:
1. Pioneer Rx patient count for February 2026 not yet entered
2. Reversal credit (-$1,381.56) requires analyst confirmation
2. Reversal credit (-$1,381.56) requires analyst confirmation
⟋Sikeston Pharmacy Trend Report — Patient Care Services
Feb 26 SPTR
| Metric | Unit | Nov 25 | Dec 25 | Jan 26 | Feb 26 |
|---|---|---|---|---|---|
| 340B Reversals | Rx | 58 | 41 * | 41 | 41 |
| 340B MDMC Reversal Credit | $ | -$971.68 | -$1,381.56 | -$1,381.56 | ⚠ verify |
| 340B Total Program Revenue | $ | $536,019 | $392,212 | $381,327 | — |
| 340B MDMC Employee | Rx | 213 | 285 | 197 | 197 |
| CB MSDMA000 | Rx | 441 | 224 | 202 | 202 |
| CB MSDMB000 | Rx | 0 | 0 | 0 | 0 |
| Qualifying Rx (Svc Fee) | Rx | 3,274 | 3,287 | 2,684 | 2,684 |
| Non-CB/Emp Svc Fee | $ | $43,738 | $27,055 | $29,061 | $29,061 |
| CE Retained Savings | $ | $268,676 | $166,196 | $178,520 | $178,520 |
| Brands Dispensed | Rx | 584 | 662 | 500 | 500 |
| Brand % Prog Rev | % | 9.04% | 7.45% | 7.79% | 7.79% |
| Generics Dispensed | Rx | 2,256 | 2,567 | 2,184 | 2,184 |
| Generic % Prog Rev | % | 10.42% | 10.19% | 9.91% | 9.91% |
| Active Care Plan Patients | Patients | 405 | 409 | — | ⚠ enter |
* Dec 25 reversal count shown as 41 in trend (corrected). Jan 26 = prior billing period data.
◈User Accounts
| Name | Username | Role | Last Login | Status |
|---|
◈Role Capabilities
| Feature | Admin | User |
|---|---|---|
| Dashboard | ✓ | ✗ |
| Upload Files | ✓ | ✓ |
| 340B Pipeline | ✓ | ✗ |
| Invoice Generation | ✓ | ✗ |
| Validation Cockpit | ✓ | ✗ |
| Trend Report | ✓ | ✗ |
| Audit Trail | ✓ | ✗ |
| Export | ✓ | ✗ |
| User Manager | ✓ | ✗ |
⟋Billing History
Loading…