INSURANCE ANALYTICS/Overview
PILOT ENVIRONMENTDEMO · SYNTHETIC DATA
YOUR REIMBURSEMENT WORKSPACE

Know what to expect.

Reliable context for better admissions conversations, grounded in actual payment history.

✦
You're viewing illustrative data. All payers, rates and cases below are fictional examples—not actual facility reimbursements.
▤
Historical records—Finalized claims
⌁
Insurance plans—Across all facilities
⌂
Locations tracked—Different reimbursement profiles
01 / QUICK LOOKUP

Check reimbursement

Select the details to find comparable paid claims.

⌕
BASED ON PRIOR CASES

Authorization & payment routing

THE DATA BEHIND THE NUMBER

Comparable paid cases

PAYMENT PERFORMANCE

Reimbursement trend

↗
HOW WE CALCULATE

Estimate details

✧

For admissions conversations

Use these figures as a historical guide. Confirm eligibility, benefits, initial approval, concurrent-review extensions, payment direction, assignment of benefits, network status and patient cost-sharing directly with the insurer. Authorization is not a promise of payment.

YOUR EVIDENCE LIBRARY

Payment history.

Inspect adjudicated claims and identify patterns over time.

Case / payment dateFacilityInsurance / planCareAuthorizationsPaid toPaid / dayTotal paid
BRING YOUR HISTORY TOGETHER

Import your data.

Bring records in from Excel or Google Sheets with a simple paste or CSV upload.

↓ Sample CSV
STEP 01 / ADD RECORDS

Upload or paste a table

CSV files, or rows copied from a spreadsheet (tabs or commas).

⇧
Drop a CSV here, or choose a fileCSV only. Convert .xlsx to CSV first.
OR PASTE FROM A SPREADSHEET
STEP 02 / IMPORT GUIDE

One row per paid claim segment

Keep a separate row for each level-of-care or payment segment, and use anonymous references instead of patient names.

01
Include basic identifiersFacility, insurer, plan, care level, and anonymous case reference.
02
Include payment factsCovered days, date paid, and actual insurer-paid total.
03
Optional extra valuesInitial authorized days, total authorized days, payment recipient, allowed amount, patient responsibility and notes.
Supported headers & synonymsfacility, payer, plan, level_of_care, case_ref, service_date, paid_date, covered_days, payer_paid

Also recognizes aliases such as location, insurance, days, and amount paid. New optional columns: authorization_initial_days, authorization_total_days, payment_recipient.

Important privacy boundary

This prototype stores records in local browser storage and has no login, audit log, or protected backend. Do not import PHI or real patient-identifiable records.

KEEP YOUR DATA ORGANIZED

Data management.

Review facilities, plans, access and audit-ready history from one place.

FACILITY DIRECTORY

Locations

INSURANCE DIRECTORY

Carriers & plans

Security and privacy

Authenticated data uses Supabase RLS. Admins can manage facilities and imports; regular users are scoped to their assigned facility and can see their own lookup history. Keep guest names and other direct identifiers out of Clear Rates until your compliance review, retention policy and any required BAA are complete.