SCRIPTONIA.Make your own PRD →
PRD · March 6, 2026
SCRIPTONIA FREE

medical bill create

Objective

Medical Bill Create is a B2B billing dashboard that enables healthcare providers to generate, customize, and submit patient invoices directly from their EHR data. This solves the $14B annual revenue leakage problem caused by manual billing workflows, reducing time-to-bill from 7-14 days to under 24 hours and improving cash flow for mid-sized practices (50-500 beds).

Problem Statement

Healthcare billing teams currently spend 6-8 hours daily on manual data entry, spreadsheet reconciliation, and invoice generation across fragmented systems. Providers report 23-30% of claims are rejected due to missing or incorrect billing information, requiring rework. Our customer interviews with 12 billing managers at networks with $50M-$200M annual revenue revealed: (1) 65% manually export patient encounter data into Excel, (2) 71% lack visibility into which claims have been invoiced, and (3) 58% experience 5+ day delays between encounter completion and billing submission. This directly impacts DSO (Days Sales Outstanding), with interviewed providers reporting 52-67 day cycles versus industry benchmark of 38-42 days.

User Stories

As a billing manager, I want to view all completed patient encounters from the past 7 days in a single filterable list so that I can quickly identify which patients need to be invoiced without manual EHR queries.

  • Acceptance: Dashboard loads within 3 seconds with up to 10,000 encounters visible; filters by provider, department, encounter type, and billing status work within 1 second; data refreshes every 15 minutes.
  • Acceptance: I can export the filtered encounter list as CSV with all required billing fields (patient name, DOB, insurance, CPT codes, charges).
  • Acceptance: Encounters already submitted for billing appear with a "Billed" badge and cannot be selected for re-billing.

As a revenue cycle specialist, I want to bulk-generate invoices for 50-200 encounters at once with customizable templates so that I can reduce manual invoice creation time from hours to minutes.

  • Acceptance: Bulk generation completes within 2 minutes for 200 encounters; system validates insurance eligibility before generation.
  • Acceptance: I can select from 5+ pre-configured invoice templates and modify header/footer details (practice name, tax ID, payment terms) without code changes.
  • Acceptance: Generated invoices are staged in a review queue before submission; I can preview and reject individual invoices without regenerating the batch.

As a practice administrator, I want real-time visibility into billing pipeline status (encounters pending invoice, generated, submitted, paid) so that I can track DSO trends and identify bottlenecks.

  • Acceptance: Dashboard shows counts and trending KPIs updated every 10 minutes; I can drill into each stage to see individual encounter details.
  • Acceptance: I can flag specific encounters as "high priority" and they appear in a dedicated queue for billing staff.
  • Acceptance: System alerts billing team when encounters exceed 3 days without invoice generation.

As an EHR integration specialist, I want to map custom fee schedules and modifier logic to the billing system so that charges are calculated correctly for different payer types without manual adjustment.

  • Acceptance: I can upload a fee schedule CSV with CPT code, modifier, payer, and charge mappings; system validates format within 30 seconds.
  • Acceptance: Billing staff see calculated charges pre-populated on invoices; charges are flagged if they exceed payer-specific limits by >10%.
  • Acceptance: Changes to fee schedules take effect within 1 hour; version history tracks all modifications.

As a compliance officer, I want an immutable audit log of all invoice generation and submission activities so that we can demonstrate billing practices during audits and regulatory reviews.

  • Acceptance: Log captures user ID, timestamp, action (generate/modify/submit), affected encounter count, and system response for every operation.
  • Acceptance: I can generate audit reports filtered by date range, user, or encounter; report exports as PDF with cryptographic hash verification.
  • Acceptance: Log retention is guaranteed for 7+ years per HIPAA requirements.

Success Metrics

Time-to-Bill (TTB): Reduce average time from encounter completion to invoice submission from 7 days to ≤1 day. Target: 85% of encounters invoiced within 24 hours by month 4.

Billing Staff Productivity: Reduce hours spent on manual invoice creation per week from 24 hours to ≤8 hours per FTE. Target: 65% reduction in manual touch time by month 3.

Claims Rejection Rate: Decrease initial claim rejections due to missing/incorrect billing data from 23-30% to ≤8%. Target: Achieve 12% by month 2, 8% by month 4.

Days Sales Outstanding (DSO): Reduce average DSO from 52-67 days to 40-45 days. Target: 10-day improvement by month 3, 15-20 day improvement by month 6.

System Adoption Rate: Achieve ≥75% of daily billing operations conducted through Medical Bill Create by month 2. Target: Track % of invoices generated via dashboard vs. legacy systems.

Edge Cases & Constraints

Network Disconnection: If EHR connection is lost mid-sync, system shall retry connection every 30 seconds for 5 minutes, then alert EHR Admin; encounters already synced shall remain queryable, but "last sync" timestamp shall display staleness warning to users.

Duplicate Encounter Submission: If a user accidentally generates invoices for the same encounter twice within 1 hour, the second request shall be rejected with a clear message; system shall check encounter_id + generation_timestamp combination.

Partial Bulk Failure: If bulk invoice generation fails for 15 of 200 encounters due to missing insurance data, system shall complete generation for valid encounters, move them to Review state, and display a detailed error report showing which encounters failed and why; user can fix and retry failed subset.

Fee Schedule Upload Conflicts: If a new fee schedule is uploaded while invoices are being generated using the old schedule, in-flight invoices shall use the old schedule; new invoices generated after upload completes shall use the new schedule; system shall log the cutover time.

Clearinghouse Submission Timeout: If third-party clearinghouse API does not respond within 30 seconds, submission shall timeout and be retried up to 3 times with exponential backoff; after 3 failures, submission shall be moved to "Manual Submission Required" queue and alert Revenue Cycle Director.

Clock Skew / Timestamp Collisions: Audit log entries generated within the same millisecond shall use auto-incrementing sequence numbers to maintain order; system shall detect server time drift >5 seconds and log a warning.

Permission Boundary Crossing: If a Billing Staff user attempts to access another provider's encounters or fee schedules, request shall be denied with 403 Forbidden; action shall be logged as a security event.

Payer-Specific Charge Validation: If a CPT code is submitted for a payer with a contractual maximum charge $X but the calculated charge is >$X, system shall flag the invoice and prevent submission until user manually approves the variance.

Invoice Regeneration with Same Encounter: If a user attempts to generate a new invoice for an already-invoiced encounter (billing status = "Invoiced"), system shall require explicit confirmation with a warning message; confirmation shall create a new invoice with version increment and audit log entry noting the reason.

Multi-Currency Support: If a health system spans multiple countries, fee schedules shall include currency field; system shall support USD, CAD, EUR; charge calculations shall reference the currency and flag mismatches (e.g., USD charge against CAD payer).

Massive Bulk Request: If a user attempts to generate invoices for >5000 encounters simultaneously, system shall queue the request, process in batches of 500, and provide a progress indicator; backend job shall be logged with job_id for tracking.

Open Questions

⚠ EHR Integration Scope: Which EHR systems are in scope for the MVP launch? Currently planning Epic + Cerner. Should we delay launch to support Athena and NextGen, or launch with 2 systems and add others in Phase 2? This impacts initial customer onboarding timeline by 4-6 weeks.

⚠ Clearinghouse Routing Logic: Should the system support automatic payer-to-clearinghouse routing (e.g., Medicare claims always go to Emdeon), or require manual selection per submission batch? Automatic routing reduces user error but requires data maintenance.

Audit Log Storage: Should audit logs be stored in the primary application database or a separate immutable data lake? Separate storage adds operational complexity but improves compliance and query performance for large-scale audits.

Template Customization Depth: Should end users be able to create fully custom templates via a visual editor, or only modify predefined sections (header/footer)? Custom templates increase flexibility but increase support burden.

Fee Schedule Versioning: How many historical versions of fee schedules should we retain? Current proposal is 12 months of history; should this be configurable per customer?

Charge Override Workflow: Should billing staff be allowed to manually override calculated charges, or should all overrides require manager approval? Override-with-approval adds governance but slows workflow.

Invoice Correction / Amendment Support: After an invoice is submitted to a clearinghouse, should we support generating corrected invoices (replacing originals), or require manual claim adjustment workflows outside Medical Bill Create?

Reporting API: Should we provide a REST API for customers to query billing data and metrics in real-time, or rely on periodic CSV export? API support enables third-party BI tool integration but increases security/rate-limiting complexity.

Integration with A/R Systems: Should Medical Bill Create push submitted claims to downstream A/R systems (e.g., athenahealth Collections, NextGen Acc Manager), or remain invoice-generation-only? Integration reduces duplicate data entry but creates dependency on A/R team coordination.

Pilot Customer Selection: Do we have 2-3 design partners (pilot customers) committed to launch with us, or should we plan for design partner recruitment as a dependency? Committed partners enable faster feedback loops; lack of partners may delay launch readiness by 2-3 weeks.

Dependencies

EHR Integration Layer: Requires working FHIR/HL7 connectors to Epic, Cerner, Athena, and NextGen; assumes those vendors' APIs are available and documented. Must coordinate with EHR vendor commercial agreements (API access, rate limits, SLAs).

Third-Party Clearinghouse APIs: Requires active credentials and API access to Emdeon, Change Healthcare, and Availity; assumes test environments are available for staging. Clearinghouse onboarding may add 2-4 week lead time per vendor.

Authentication & Authorization Service: Depends on shared identity platform (Okta, Cognito, or internal SSO) for user login and role-based access control; assumes the platform supports custom role definitions.

Data Warehouse / Analytics Backend: Depends on analytics pipeline to surface real-time KPIs (TTB, DSO, rejection rates); assumes data warehouse team can consume Medical Bill Create event stream and publish metrics endpoints.

Encryption & Key Management: Depends on infrastructure team providing AES-256 encryption and TLS 1.3 support; assumes KMS (Key Management Service) is available for key rotation.

Patient Data Privacy & Compliance: Requires HIPAA-compliant database design review and BAA (Business Associate Agreement) signature with customers; depends on legal and compliance teams for audit log retention policy.

Infrastructure & Deployment: Requires Kubernetes cluster, managed PostgreSQL database, and SFTP/S3 storage for file uploads; assumes infrastructure team provisions staging and production environments with auto-scaling.

Design Partner Pilot Program: Success metrics depend on 2-3 committed pilot customers; recruitment must complete 4 weeks before engineering freeze to allow adequate design iteration cycles.

Product Analytics Instrumentation: Depends on analytics team to instrument user behavior tracking (feature adoption, workflow drop-off); data collection must comply with HIPAA and privacy policies.

Customer Support & Documentation: Depends on product education and support teams to create runbooks, FAQs, and training materials; launch readiness assumes support is trained on core workflows 2 weeks pre-launch.

MADE WITH SCRIPTONIA

Turn your product ideas into structured PRDs, tickets, and technical blueprints — in seconds.

Start for free →
Made with Scriptonia · Free planRemove watermark →