Tariff knowledge
Not yet approved. Analyses can still use it; approving records the version you stand behind.
What to bring
Drop in everything you hold for this area. More is better — the app tells you what is missing rather than refusing incomplete input.
- The agreed tariff / price list, with its covering letter if there is one
- Any revision, and the letter that transmitted it
- Correspondence agreeing a price for a service missing from the list
Warnings and flags
None of these stop you working. A flag marks something whose absence quietly distorts naira findings; a warning marks something worth knowing.
1 document carries no date
• venus-tariff-UNDATED.xlsx (venus-tariff-UNDATED.xlsx) — no date found in the file
Where the app looked: Searched for an effective date, a commencement date, and any date written in the first pages
What to do: An undated document cannot be shown to have applied on a given date of service. Set the date by hand so findings drawn from it can be cited.
53 services are priced twice at different amounts
• X-Ray - CBCT — ₦61,918.75 and ₦138,368.75 • CORTISOL URINE — ₦84,500.00 and ₦105,625.00 • CSF GLUCOSE — ₦8,450.00 and ₦21,125.00 • WHOLE BLOOD ONE UNIT OF RH (-) BLOOD — ₦73,937.50 and ₦95,062.50 • INTERMEDIATE III — ₦1,563,470.25 and ₦2,248,404.23 • NASOPHARYNGOSCOPY AND BIOPSY — ₦1,145,812.50 and ₦2,000,625.00 • HYSTERECTOMY (SIMPLE) — ₦1,563,470.25 and ₦3,091,875.00 • DEBRIDEMENT III — ₦1,011,225.00 and ₦1,145,812.50 • BSP: RANDOM BLOOD SUGAR — ₦4,875.00 and ₦8,937.50 • PROSTATE ARTERY EMBOLIZATION — ₦195,000.00 and ₦6,444,813.38 • TRANS-ARTERIAL CHEMOEMBOLIZATION — ₦5,334,035.04 and ₦8,923,260.38 • VARICOCEL EMBOLIZATION — ₦100,625.00 and ₦8,923,260.38
Where the app looked: venus-tariff-UNDATED.xlsx, sheet "tariff"
What to do: The app cannot say what the agreed price is for these services, so it will not check them against a bill. Decide which price stands and correct the tariff.
Tariff effective date — not found
Every naira figure this app produces is uncitable without it. An undated price list cannot be shown to have applied on the date of service, so the hospital cannot defend a single price in a reconciliation letter.
Where the app looked: Searched 1 readable document: venus-tariff-UNDATED.xlsx. Looked for: "effective", "with effect from", "valid from", "revised", "w.e.f".
What to do: Add the document that states it, or type the value in directly and approve it.
6 duplicated rows in the price list
• CONSULTATION / NEPHROLOGY — appears 2 times, all at ₦62,500.00 • CONSULTATION / PHYSIOTHERAPY — appears 2 times, all at ₦37,500.00 • ACDF/GENUS — appears 2 times, all at ₦8,014,893.75 • INCISION AND DRAINAGE II — appears 2 times, all at ₦698,400.00 • INCISION AND DRAINAGE I — appears 2 times, all at ₦385,575.00 • OXYGEN 2-5 LITERS PER DAY — appears 2 times, all at ₦20,310.88
Where the app looked: venus-tariff-UNDATED.xlsx, sheet "tariff"
What to do: Harmless for pricing since the amounts agree, but it inflates service counts and suggests the tariff has been edited by hand.
3 services have no price
• Crown - Gold • BIRTH CERTIFICATE • Guided Bone/ Tissue Regeneration
Where the app looked: venus-tariff-UNDATED.xlsx, sheet "tariff"
What to do: These cannot be checked against a bill and will be reported as unpriced when they appear.
Price review cycle — mentioned but not pinned down
The subject is discussed in your documents, but no exact value has been extracted, so the app cannot use it in a finding. How often prices are revisited. Tells the officer whether a tariff is due for renegotiation, which matters in a high-inflation setting.
Where the app looked: "revision" in venus-tariff-UNDATED.xlsx
What to do: Open the item, read the passage, and enter the value so analyses can rely on it.
Currency — not found
Assumed to be naira unless stated. Worth confirming on any tariff that includes imported consumables or foreign-referral items.
Where the app looked: Searched 1 readable document: venus-tariff-UNDATED.xlsx. Looked for: "naira", "NGN", "₦", "currency".
What to do: Add the document that states it, or type the value in directly and approve it.
Digest
This — not the raw documents — is what every analysis reads. Correct anything the app got wrong; your entry always wins and survives re-checks.
Tariff effective date
Every naira figure this app produces is uncitable without it. An undated price list cannot be shown to have applied on the date of service, so the hospital cannot defend a single price in a reconciliation letter.
Enter the value
Priced service list
2069 priced services
Edit
Price review cycle
Discussed in your documents but no value extracted: “…/ZIMMER | Orthopaedics | 5840340 1723 | IMPLANT MAJOR | THR/REVISION/DEPUY/SINGLE STAGE/SECOND STAGE | Orthopaedics | 5840340 1724 | IMPLANT MAJOR | THR/REVISION/FIRST STAGE | Orthopaedics | 5840340 1725 | IMPLANT MAJOR…”
Source: "revision" in venus-tariff-UNDATED.xlsx
Enter the value
Currency
Assumed to be naira unless stated. Worth confirming on any tariff that includes imported consumables or foreign-referral items.
Enter the value
Approving records this as the version you stand behind. It does not clear the warnings and never blocks an analysis.
Documents (1)
venus-tariff-UNDATED.xlsx
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet · 93.0 KB · Read directly
🚩 No date — set one so findings from it can be cited
Set date