How to Zip and Upload Quote Files

  • Updated

In certain instances, carriers generate quote files where plan files and rate files are provided as separate files. PerfectQuote accepts combined carrier plan summaries (not SBCs) and rate files in Zip (.zip) file format for the carriers listed below.

video walkthrough is available on our YouTube channel with timestamps for certain carriers. 

Zipping Instructions:

1. Zip the carrier plan summaries (not SBCs) + the rate file together

2. Upload the Zip (.zip) file as you normally would on the Quote Upload tab. 

 

Note: There is a zip file max limit size of 10 MB. If the zip file is larger than this, the file will not upload. You will need to reduce the zip file size for a successful upload.

Carrier Product Group Size Funding Type Rate Type Quote File Format Zip Files Needed
Aetna  M small/51+ AF/FI Composite PDF 1 Rate Sheet + Medical Benefit Summaries
AmeriHealth M 51+ FI Composite PDF 1 Rate Sheet + Medical Benefit Summaries
Anthem Blue Cross M,D,V  51+ FI Composite PDF 1 Rate Sheet + Medical Benefit Summaries
Asuris Northwest Health M 51+ FI Composite PDF 1 Rate Sheet + Medical Benefit Summaries
Banner Aetna M 51+ FI Composite PDF/xlsx 1 Rate Sheet (xlsx) +  Medical Benefit Summaries (PDF)
BCBS Arizona M 51+ AF/FI Composite PDF 1 Rate Sheet + Balanced Funding or FI Health Plan PRODUCT GUIDE
BCBS Minnesota  M 51+ FI Composite PDF 1 Rate Sheet +  Medical Benefit Summaries
BCBS North Carolina M 51+ FI Composite PDF/xlsx 1 Rate Sheet (xlsx) +  Medical Benefit Summaries
BCBS South Carolina M 51+ FI Composite PDF Chamber Rate Grid + Medical Benefit Summaries
BCBSTX - Blue Care Dental D 51+ FI Composite PDF 1 Rate Sheet & Dental Benefit Summaries
Blue Shield of California M 51+ FI Composite PDF 1 Rate Sheet +  Medical Benefit Summaries
Capital Blue Cross M 51+ FI Composite PDF 1 Rate Sheet + Medical Benefit Summaries
Delta Dental/Moda - OR/AK D 51+ FI Composite PDF 1 Rate Sheet & Dental Benefit Summaries
EMI M 51+ FI Composite PDF 1 Rate Sheet +  Medical Benefit Summaries
Geisinger M 51+ FI Composite PDF 1 Rate Sheet + Medical Benefit Summaries
Hawaii Medical Assurance Association M small/51+ FI Composite PDF 1 Rate Sheet + Medical Benefit Summaries
HealthNet M 51+ FI Composite PDF 1 Rate Sheet + Medical Benefit Summaries
HealthPartner M Small AF Composite PDF 1 Rate Sheet + Medical Benefit Summaries
Highmark M,D,V 51+ FI Composite PDF - Rate sheet - Rate Summary Report & Dental & Vision Renewal Acceptance Agreement
PDF - Medical Plan Summary
PDF - Dental Plan Summary
PDF - Vision Plan Summary
1 Rate Sheet + Medical, Dental & Vision Benefit Summaries
Horizon BCBS NJ M - New Business 51+ FI Composite PDF 1 Rate Sheet + Medical Benefit Summaries
Horizon BCBS NJ M - Renewal 51+ FI Composite PDF 1 Rate Sheet + Medical Benefit Summaries
Independence Blue Cross M, V 51+ FI Composite PDF 1 Rate Sheet +  Medical/Vision Benefit Summaries
Kaiser Permanente 51+ FI Composite PDF Kaiser Complete Suite quote proposal+Complete Suite plan comparison chart
Kaiser Permanente 51+ FI Composite PDF 1 Rate Sheet + Medical Benefit Summaries
Kaiser Permanente HI M 51+ FI Composite PDF 1 Rate Sheet + Benefit and Payment Chart
Moda/Delta Dental D small/51+ FI Composite PDF 1 Rate Sheet + Dental plan benefit table
Premera AK D, V  51+ FI Composite PDF 1 Rate Sheet + Medical Benefit Summaries
Premera WA M,D  51+ FI Composite PDF 1 Rate Sheet + Medical Benefit Summaries
Providence M, D 51+ FI Composite PDF 1 Rate Sheet  + Medical Benefit Summaries
Prudential BL/ADD, VL/ADD, STD, LTD  Small/Large FI Composite/Age Excel - Rate sheet 
Word - Benefit Summary
1 Rate Sheet + Benefit Summaries
UHC (Bind Design only) M 51+ FI Composite PDF 1 Rate Sheet + Medical Benefit Summaries
UPMC M,D,V  51+ FI Composite PDF 1 Rate Sheet + Medical, Dental & Vision Benefit Summaries

Windows/MAC OS Zipping instructions: 

Windows (10/11)
 

  1. Locate the files you want to compress. (They will be in whatever folder you saved them to)
  2. Select all the files by clicking the check box to the left of the file name. (i.e. Moda/Delta dental rate sheet + Deltal Dental Plan summary)
  3. Right-click on one of the selected files.
  4. Select Send to > Compressed (zipped) folder.
  5. Optional: Rename the new, zipped file.
     

macOS
 

  1. Locate the files. (They will be in whatever folder you saved them to)
  2. Control-click (or right-click) the item.
  3. Select Compress.
    For multiple items, highlight them, then Control-click and select Compress. 

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.