Reports
How to generate reports in NextAgency
-
The Reports tab in the navigation bar gives you access to the Agency Reports page, from which you can generate Excel reports with data related to:
Agency- Comp Disclosure form (Group)
- Contacts
- Customer Service
- Users
Cases
- Benefits
- Calls
- Cases
- Case Contacts
- Dependents
- Employees
Commissions
- Carrier Overview
- Commissions
- Commission History
- Reconciliation
- Sub Agents
- Unpaid
- Variance
Commissions (Pivot Tables)
- BOR Summary
- Carrier Summary
- Client Summary
- Product Summary
- Sub Agents Summary
- Sub Agency Summary
Sales
- Carrier Offering
- Enrollment Kits
- Proposals
- Sales Team
- Sub Agent Carrier/Products
- Sub Agent Contact
Tasks, Tickets, and Notes
- Notes
- Tasks
- Tasks History
- Tickets
We will use the Cases report as an example to explain to you how NextAgency reports work. To generate a report with specific data related to clients:
- On the Cases tab, click Create.
- The system will suggest that you select the fields which you want to export. The fields are color-coded and divided into several groups: Case Info, Status Info, System Info, and Case Custom Info.
- From the above screenshot, we have selected to export the data related to the case info only.
- It is also possible to save these fields as a template. In the upper-right corner of the page, click Save as Template, enter the name of the template, and then click Save. The report will appear in the list. You can also hit Run on this page to generate the Report.
- To save this report as an Excel file, click Actions > Run.
6. It is also possible to create a copy of the report. To do it, click Actions > Copy Report.
The copy will appear in the list.
To remove the report or report template, click Actions > Delete, and then click Yes in the confirmation dialog.
Let's create another example report on Unpaid commissions. Follow these steps:- Under Commissions, click on Unpaid Reports.
- Click the Create button.
- Select the fields that you wanted to have in the report.
- If needed, customize the columns by dragging them to change their order or adding empty columns.
- When ready, you can save the report as a template to use in the future. You can click on Run to generate the Report.
-
NextAgency helps you comply with Section 202 of the Consolidated Appropriations Act, 2021 (“CAA”). This regulation places obligations on both you and your clients. We strongly recommend you seek guidance from experts to ensure compliance with these requirements. The National Association of Benefits & Insurance Professionals (NABIP) provides valuable information free of charge to its members and can be a helpful resource.
Section 202 requires you to disclose the compensation you expect to receive on a policy under certain circumstances. Regulations spell out the form and content of a Compensation Disclosure Form. NextAgency helps you create this form. However, we can only populate the form with information you provide. This means it's important that you complete specific fields when entering Benefits information as NextAgency uses these fields to generate your Compensation Disclosure Forms.
- Compensation Formula Field: Since a group's premiums may fluctuate from month-to-month, it is challenging to predict the precise commission you expect to earn on their policy. To address this challenge, regulators permit you to report the commission schedule used to calculate your compensation (e.g., 5% or $10 per employee per month). Enter this schedule in this field.
NextAgency can calculate the commission you expect to earn on a policy and use the result to determine if this policy should be included in your Compensation Disclosure Form. To use this calculation you will need to enter the:
- Expected Commission Field: Enter the commission you expect to earn each time your client pays their premium in this field.
- Payment Frequency Field: Enter how often your client pays premium in this field
. - Expected Annual Commission Field: After saving the data you have entered in the Benefits page, NextAgency will calculate this field by multiplying the Expected Commission Field with the Payment Frequency Field. If this amount is $1,000 or more this policy will be included in your Compensation Disclosure Form for this client. If the amount is less than $1,000 it will be excluded from the report unless the Disclosure Required Field is set to Yes.
- Disclosure Required Field: You may instruct NextAgency to ignore the Compensation Disclosure Form in determining whether a policy is included or excluded in the form with this field. When set to Yes, the policy will be included even if the Expected Annual Commission Field is less than $1,000. Setting this field to No excludes the policy from the form even if the Expected Annual Commission Field is $1,000 or more. If left blank, the Expected Annual Commission Field determines whether the policy is included in the form.
Generating Compensation Disclosure Forms
NextAgency will create a Compensation Disclosure Form for each of your clients based on what you have entered in the above fields.
i. Access the Reports section by clicking on "Reports" in the blue navigation pane.
ii. Under the Agency section, select "Comp Disclosure Form (Group)" and click on "Create."
iii. If desired, you can apply filters by clicking on the "Filters" button. For example, you can filter by "Broker Of Record" or generate a disclosure form for a particular client.
iv. By default, the "Disclosure Required" and "Annual Commission" fields are pre-set under the Benefits filter tile. You can modify these values if necessary.
v. Once you have set the desired filters, click on "Run" to generate a zip file containing Word documents for each of your clients that fit the disclosure requirement criteria and include all relevant Benefits information.
NextAgency generates Compensation Disclosure Forms in Word to make it easy to review and edit the form. For example, NextAgency cannot populate information concerning "other compensation" because this data is not tracked in NextAgency. You may also add your agency's logo or other graphic elements as you see fit. You should print the form as a PDF before sending it to your client.
If you have any questions or require assistance, please contact the NextAgency support team.