Cigna Supplemental

Cigna for Brokers

https://cignaforbrokers.com/public/login

Username: tylermcdaniel20

  1. 1. Click on Log In

    Click on Log In
  2. 2. Click on Continue

    Click on Continue
  3. 3. Click on Cigna Supplemental

    Click on Cigna Supplemental
  4. 4. Click on Compensation

    Click on Compensation
  5. 5. Click on Latest Commissions

    Click on Latest Commissions
  6. 6. Click on image

    Click on image
  7. 7. Click on <

    Click on <
  8. 8. Click on 1

    Click on 1
  9. 9. Click on image

    Click on image
  10. 10. Click on <

    Click on <
  11. 11. Click on 31

    Click on 31
  12. 12. Click on Search

    Click on Search
  13. 13. Click on View

    Click on View
  14. 14. Click on print

    Click on print

Go to Chatgpt.com

  1. 15. Paste selected text into element

    Copy the text below this line into the chatgpt box


    I need to extract data from a PDF and format it to match a specific Excel template. Please import the data from the PDF into an Excel sheet, ensuring the columns match exactly with the StandardImportRevenue file.

    Map the "Percent" column from the PDF to the InRate column in the Excel file.
    Leave the "CovgType" and "Lives" columns empty in the output.

    Here are the required headers for the output:

    Headers:
    BillFromDate, CarrierAbbrev, PolicyNum, CovgType, Eff Date, Carrier Product, Policyholder, AgentName, Premium, InRate, Lives, Commission, Note, Revenue Type

    Once complete, export the Excel file and name it using the statement date from the PDF in this format:
    CignaSupp_MM.DD.YYYY.xlsx

    Paste selected text into element
  2. 16. Click on Upload files and more

    Click on Upload files and more
  3. 17. Click on Add from Google Drive

    Click on Add from Google Drive
  4. 18. Click on Commission Statements…

    Click on Commission Statements…
  5. 19. Click on `Standard File…

    Click on `Standard File…
  6. 20. Click on StandardImportRevenueType…

    Click on StandardImportRevenueType…
  7. 21. Click on Select

    Click on Select
  8. 22. Click on Upload files and more

    Click on Upload files and more
  9. 23. Click on Upload from computer

    Click on Upload from computer
  10. 24. Upload the Commission Statement.pdf you downloaded before (one at a time)

    Upload the Commission Statement.pdf you downloaded before (one at a time)
  11. 25. Click on Send prompt

    Click on Send prompt
  12. 26. Click on Download Formatted_Commission_Statement.xlsx

    Click on Download Formatted_Commission_Statement.xlsx
  13. 27. Save file in Google Drive

    The Folder is in the MAC Insurance Shared folder > Commission Statements

    BE SURE TO NAME THE DOCUMENT ---> COMPANY_STATEMENT DATE

    This Example would be CignaSupp_01.01.2025