1. FAQs and Support
  2. Book of Business Reports

How do I generate a book of business report in Applied Epic?

Step-by-Step instructions

This article is intended to teach you how to download a book of business report from your Applied Epic management system.

These are not official instructions and although we've tried our best, may not fulfill your exact needs. If you have any questions not answered by this article, you may want to call Applied Systems directly (800-999-6512) or submit a ticket through their website.

Instructions

Step 1

Open the Reports/Marketing page by selecting it in the sidebar:

image-png-Feb-01-2024-08-13-47-8652-PM

Step 2

Click "Policy" in the sidebar to open up the policy report menu:

image-png-Feb-01-2024-08-42-44-1432-PM

Step 3

Click the report called "Book of Business – Policy Book" and then click the pencil icon to edit it:
image-png-Feb-01-2024-08-53-11-0262-PM
(Your list of reports may not look exactly the same)

Step 4

Click Modify Criteria
image-png-Feb-01-2024-09-13-57-9374-PM

It will open up the criteria page, which should look similar to this:
image-png-Feb-01-2024-09-16-22-0886-PM
Please make sure that the criteria highlighted in yellow match ours. There is no need to adjust the policy effective date of policy expiration date, as long as the dates are current.

Step 5

Select Delivery Options in the sidebar
image-png-Feb-01-2024-09-23-17-4118-PM

Step 6

Click the pencil icon next to <Current User> in the Report Recipients section:
image-png-Feb-01-2024-09-24-52-9915-PM

A new dialogue will open up:

image-png-Feb-01-2024-09-27-46-8325-PM

Click the checkbox next to "Save to Disk", then change the Save As dropdown to "Microsoft Excel Workbook".

Next, type "Book of Business Report" in the Location field, and click the "Finish" button at the bottom.

Step 7

To download your report, you will need to click Actions in the top navigation, and select "Generate Report":
image-png-Feb-01-2024-09-34-07-5982-PM

This will open up the file explorer:

image-png-Feb-01-2024-09-38-12-7023-PM

Navigate to the folder you'd like to save the report to and click the "Save" button.

Epic may then ask you if you'd like to immediately open the file. You can select either option.

Success! You have downloaded your book of business report.