{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["HMO and NON-HMO Edit Checks"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"HMO and NON-HMO Edit Checks","index":0,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4]]}
["945 EDIT CHECKS: CONSISTENCY WITH OTHER REPORTS"]
["COMPANY NAME:"]
["NAIC #:"]
["Year:"]
["Edit #","On the 945 Report","Comparison"," 286-A report or the Supplemental Health Care Exhibit on the Annual Statement","Difference"]
[1,"The Sum of line 6 Individual","should =","Bulletin 286-A Report, line 4, Individual (Column 2)"]
[2,"The Sum of Line 6","should =","Total of lines 2, 3, 4, 10, 11 & 12 of Bulletin 286A Report"]
[3,"The Sum of Line 6 Stop Loss","should =","Line 11 Group of Bulletin 286-A Report"]
[4,"The amount in Line 33 (ACA Annual Health Insurance Industry Fee)","should be >",0]
[5,"Line 1, Individual Column","should =","Line 4 on the Supplemental Health Care Exhibit, Other Indicators - Member Months in the Individual Comprehensive Health Coverage column"]
[6,"Line 2, Individual Column","should =","Line 1 on the Supplemental Health Care Exhibit, Other Indicators - Number of Certificates/Policies in the Individual Comprehensive Health Coverage column"]
[7,"Line 5a, Individual Column","should =","Line 2 on the Supplemental Health Care Exhibit, Other Indicators - Covered Lives in the Individual Comprehensive Health Coverage column"]
[8,"Line 7, Individual Column","should =","Line 1.1 on the Supplemental Health Care Exhibit, Part 1 - Premium Earned in the Individual Comprehensive Health Coverage column"]
[9,"Line 1, Large Group Column","should approximate","Line 4 on the Supplemental Health Care Exhibit, Other Indicators - Member Months in the Large Group Employer Comprehensive Health Coverage column"]
[10,"Line 2, Large Group Column","should approximate","Line 1 on the Supplemental Health Care Exhibit, Other Indicators - Number of Certificates/Policies in the Large Group Employer Comprehensive Health Coverage column"]
[11,"Line 5a, Large Group Column","should approximate","Line 2 on the Supplemental Health Care Exhibit, Other Indicators - Covered Lives in the Large Group Employer Comprehensive Health Coverage column"]
[12,"Line 7, Large Group Column","should approximate","Line 1.1 on the Supplemental Health Care Exhibit, Part 1 - Premium Earned in the Large Group Employer Comprehensive Health Coverage column"]