2023 CLAIM REPORT ORIENTATION -
This report displays the amount that each of your family members are responsible for in Plan Year 2023.
Date Range:
Plan Year 2023 includes service dates from January 1, 2023 to Dec 31, 2023
| Calendar Year |
First Name |
Last Name |
Relationship |
BDAY |
START DATE |
MAX REMAINING DEDUCTIBLE |
MAX REMAINING OOP |
OOP offset due to max |
|
Deductible and OOP By Period:
| Last NAME |
first NAME |
RElationship |
Bday |
Issued coverage start date |
Issued coverage end date |
health coverage |
Overpayments:
The report may display Overpayment amounts in either plan year. Overpayments are sometimes created this year due to the extra layers of protection that the Plan Underwriter had to deploy in order to accommodate a deductible carryover credit and a short year deductible from May 1, 2022 to Dec 31, 2022. Any unintended Plan Overpayments will be used to offset future plan liabilities or settled at the end of the year.
Need Help?:
Contact the Help Desk by emailing
healthplanhelpdesk@coalitionexchange.org
Click Here to View Calendar Year 2022
Calendar Year:
The below report only display individuals who had claims this year. Any family members that is not displayed means that we have not received claims fro BCBS yet.
| Details |
Name |
Relationship |
Pay your provider |
Allowed Amount Subject To Deductible/Coinsurance |
Amount You Should Owe Under The Deductible In Force For Selected Year
|
Actual Amount Owed Providers Due To BCBS Payments |
Are You Due Additional Funds? |
Amount Due or Overpaid |
res-patientowes |
tpahraowes |
tpahraowes-res-patientowes |
| 2023 |
|
FAMILY TOTAL |
|
|
|
|
|
|
|
|
|
| Plan year |
Name |
Total BCBS Billed |
Total BCBS Allowed |
Total BCBS Paid |
Total Due Provider |
Total BPA Owes |
Total Employee Real Responsibility |
| Please wait...... |
|
|
|
|
|
|
|
|
Claims Subject to Deductible and Coinsurance (Excludes QMG Clinic and Preventative Claims) for
| Processed Date |
Date of Service |
Name |
Claim Number |
Provider |
Pay Your Provider |
Total Billed |
Penalty |
Allowed Amount |
Amount Due Provider |
Plan Year |
Correct Deductible |
Correct Coinsurance |
Correct Patient Owes |
Correct Carrier Owes |
BCBS Paid |
HRA Plan
Over (+) / Under (-)
Credit Attribution |
HRA Credit payment |
HRA Responsibility |
Corrected Pay your provider |
Sort order |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Processed Date |
Date of Service |
Name |
Claim Number |
Provider |
Pay Your Provider |
Total Billed |
Penalty |
Allowed Amount |
Amount Due Provider |
Plan Year |
Correct Deductible |
Correct Coinsurance |
Correct Patient Owes |
Correct Carrier Owes |
BCBS Paid |
HRA Plan
Over (+) / Under (-)
Credit Attribution |
HRA Credit payment |
HRA Responsibility |
Corrected Pay your provider |
Sort order |
Detailed Break Down Of QMG 100% Free Employee Clinic Claims for
| Processed Date |
Date of Service |
Name |
Claim Number |
Provider |
Total Billed |
Penalty |
Allowed Amount |
Amount Due Provider |
Plan Year |
Correct Deductible |
Correct Coinsurance |
Correct Patient Owes |
|
|
|
|
|
|
|
|
|
|
|
|
|
Detailed Break Down Of Preventative Claims for
| Processed Date |
Date of Service |
Name |
Claim Number |
Provider |
Total Billed |
Penalty |
Allowed Amount |
Amount Due Provider |
Plan Year |
Correct Deductible |
Correct Coinsurance |
Correct Patient Owes |
|
|
|
|
|
|
|
|
|
|
|
|
|
Admin View
Plan year:
|
Processed Date |
Date of Service |
Name |
Claim Number |
Provider |
Pay Your Provider |
Total Billed |
Penalty |
Allowed Amount |
Amount Due Provider |
Plan Year |
Correct Deductible |
Correct Coinsurance |
Correct Patient Owes |
Correct Carrier Owes |
BCBS Paid |
HRA Plan
Over (+) / Under (-)
Credit Attribution |
HRA Credit payment |
HRA Responsibility |
Corrected Pay your provider |
Sort order |
HRACreditPayment |
HRAPaymentDate |
HRAPaymentCheckNo |
TPAHRAOwes |
TPAEmployeeOwes |
preventativeexclusion |
HRABudget |
patientowesprovider |
overpayment |
hra_concession |
[L2 Combined Pat Using Allowed] |
[L2 Combined Pat Using Responsibility] |
[L2 Combined HRA Using Allowed] |
[L2 Combined HRA Using Responsibility] |
hhid |
empid |
ScoringIDConcatL1 |
AuditorScoreConcatL1 |
[Allan Inclusion Marker] |
PlaceOfService |
[Diagnosis Code csv] |
[Diagnosis Desc csv] |
[CPT Code csv] |
cpt_desc_csv |
department |
serviceprov |
TotalLineItems2 |
total_match_dept |
total_match_prov |
total_match_cpt |
total_match_bcbs_cpt |
QMG ChargeID or BH ACCT/Voucher# |
Initial Load Date |
Count of Claim Match |
Blessing_Notes |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Processed Date |
Date of Service |
Name |
Claim Number |
Provider |
Pay Your Provider |
Total Billed |
Penalty |
Allowed Amount |
Amount Due Provider |
Plan Year |
Correct Deductible |
Correct Coinsurance |
Correct Patient Owes |
Correct Carrier Owes |
BCBS Paid |
HRA Plan
Over (+) / Under (-)
Credit Attribution |
HRA Credit payment |
HRA Responsibility |
Corrected Pay your provider |
Sort order |
HRACreditPayment |
HRAPaymentDate |
HRAPaymentCheckNo |
TPAHRAOwes |
TPAEmployeeOwes |
preventativeexclusion |
HRABudget |
patientowesprovider |
overpayment |
hra_concession |
[L2 Combined Pat Using Allowed] |
[L2 Combined Pat Using Responsibility] |
[L2 Combined HRA Using Allowed] |
[L2 Combined HRA Using Responsibility] |
hhid |
empid |
ScoringIDConcatL1 |
AuditorScoreConcatL1 |
[Allan Inclusion Marker] |
PlaceOfService |
[Diagnosis Code csv] |
[Diagnosis Desc csv] |
[CPT Code csv] |
cpt_desc_csv |
department |
serviceprov |
TotalLineItems2 |
total_match_dept |
total_match_prov |
total_match_cpt |
total_match_bcbs_cpt |
QMG ChargeID or BH ACCT/Voucher# |
Initial Load Date |
Count of Claim Match |
Blessing_Notes |
| Date Of Service |
Place Of Service |
Billed Amount |
Allowed Amount |
Carrier Paid |
Your Responsibility |
Primary Diagnosis |
Procedure Description |
Procedure Code |
Deductible |
Coinsurance |
Copay |
Penalty |
Medication Name |
Medication QTY |
Medication Supply |
LineId |
Department |
Service Provider |
Match Test Dept |
Match Test Provider |
Match Test CPT |
100 Percent Marker |
CPT CSV grouped |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|