How do I run a collections applied report?

Running the Premiums Due/Collections Applied Report (Manual and Automated)

Manual process

This procedure allows the Agency Benefits Coordinator (ABC) to run the Premiums Due/Collections Applied report, which shows all the monthly deductions/refunds for insurance coverage for each employee of their agency.

If the report is run for a date in the past, it will be titled “Collections Applied” at the top. If it is run for a future date it will be titled “Premiums Due.” The Premiums Due report is an estimate, whereas the Collections Applied report shows what Benefits Administration (BA) will actually pull from the agency. The changeover date is usually one of the first few working days of the month and is listed on the calendar on the ABC website:

To begin the process to manually run a Premiums Due/Collections applied report:

  1. Click on the “Main Menu” link in Edison.
  2. Click on the “HCM” link.
  3. Click on the “Benefits” link.
  4. Click on the “Reports” link.
  5. Click on the “Contributions and Deductions” link.
  6. Click the “TN Prem Due/Collect App Deduct” link.
  7. Click the “Add a New Value” tab if the ABC has never run this report.

Note: Once the ABC has created the Run Control ID, he or she can simply type the name of the Run Control ID on this screen and click “Search

  1. Create a name for the report and type it in the Run Control ID field. The ABC can name it anything they like with no spaces.
  2. Click “Add
  3. Click on the magnifying glass to select the department number (this is a number provided by BA to each agency).
  4. Click “Both
  5. Click the magnifying glass to the right of the Pay Run ID field to select the month of the report.

(The Pay Run ID has a specific format. The first two digits are the year, followed by NP for “non-payroll”, followed by two digits for the month and two digits for the last day of the previous month).

  1. Click on the date of the desired month.
  2. Click “Run” at the top right.
  3. You can change the report format on this screen if you wish to see it as an Excel document. Otherwise, to see it as a PDF click “OK”
  4. Make a note of the “Process Instance” number and then click the “Report Manager” link at the top.
  5. The report will run when it is ready, it will be visible by clicking the “Refresh” button. (It usually takes a minute or two to run.)
  6. Click the “TN_BA138” link – The process instance for the report will appear on the right. 138 is just the number that Edison uses to refer to the “Premiums Due/Collections Applied” report .
  7. Click the second link under “File List” ending in “.PDF” to view the report. (The report will open in a separate window.)
Have more questions? Submit a request