Reports
Over 200 Readily Available Report Files Are Available Within Relius
Administration!
Our easy to use functionality allows you to:
-
Move between separate plans
-
Sort and search on employees
-
Print on any date range within the same plan year
-
Print on single employees or on your defined range of employees
-
And more!
Plus, the Crystal Reports Pro report writing tool (licensed through SunGard
Relius) gives you complete flexibility to modify existing report files to fit
your needs. You can use Crystal to build custom reports from scratch, perform
sophisticated cross plan and database queries and even build custom mailing
campaigns. Crystal provides access to 100% of your data and can export any data
in a variety of standard data formats such as excel.
Our readily available report files combined with the power of Crystal Reports
Pro gives you a infinite number of reporting and query options.
Below is a comprehensive but not all inclusive list of reports that are
available within Relius Administration. As a note of clarification, each of the
report titles listed also contains their own subset of reports. For instance,
when a user selects Plan Audit the user then has three separate Plan Audit
reports to choose from. The reports may be distinguished by print type or
content or both creating a matrix of over 200 report files available within the
system.
The following are examples of our Report Writer Reports, which come standard
with our system and are readily available to all users.
Plan |
|
Audit |
|
Cover Page |
|
DC Specifications
|
|
DB Specifications |
|
Proxy Reports |
|
Executive Summary |
|
Plan Totals |
|
Census |
|
Audit |
|
Request |
|
Verification |
|
Contributions |
|
DC Analysis (includes 8 sub reports) |
|
Investment Direction |
|
DB Analysis |
|
|
Normal Cost Derivation |
|
|
Current Liabilities |
|
|
412 Full Funding Limit |
|
|
404 Full Funding Limit |
|
|
412 and 404 Contributions |
|
Actuarial Certificate |
|
Amortization Basis |
|
DB Trust Assets |
|
DB Employee |
|
|
Cost Breakdown |
|
|
DB Participant Summary |
|
|
Internal Actuarial Data |
|
|
FASB 87/132 Internal Actuarial Data |
|
|
Individual Aggregate Allocated Assets |
|
Catch Up Contributions |
|
|
Eligible Employees |
|
|
Contributions |
|
Schedule of Active Participants Data |
|
PBGC Premiums |
|
Distributions |
|
Distributions, Confirmed |
|
Age 70.5 Employees, Detail and Total |
|
Distribution Summary |
|
Loans |
|
History |
|
Payments |
|
Summary
|
|
Past Due Payments |
|
Loan Warnings Report |
|
Participants Certificates |
|
Standard (contains 19 sub reports) |
|
|
PstdP2 |
|
|
PstdP5 |
|
|
PstdP6 |
|
|
PstdL6 |
|
1 Page (contains 5 sub reports) |
|
Defined Benefit |
|
Standard with Rate of Return |
|
Summary of Accounts |
|
Summary of Accounts, Detail (contains 17 sub reports) |
|
Summary of Accounts, Totals (contains 14 sub reports) |
|
Misc. |
|
Database |
|
Ledger |
|
Trade
|
|
|
Buy Sell |
|
|
Pending |
|
|
Settled |
|
|
Buy/Sell Worksheet |
|
Fee Transactions |
|
|
Detail, all transactions |
|
|
Detail, confirmed transactions |
|
|
Fund Summary - all transactions |
|
|
Fund Summary - confirmed transactions |
|
|
Totals - all transactions |
|
|
Totals - confirmed transactions |
|
415 Test |
|
Web/CSR |
|
Pin Change Letter |
|
Pin report |
|
Web/CSR Census |
|
Confirmation Letter |
|
Cafeteria Plan
|
|
Plan |
|
|
Premium Payment Invoice |
|
|
FSA Balance Summary |
|
|
Savings to the Organization |
|
Employee Benefit Election by Participant |
|
Employee Benefit Election by Benefit |
|
Census Data |
|
Claims |
|
|
Plan Summary |
|
|
Employee Summary |
|
|
Employee Detail |
|
|
Approved Claims |
|
|
Invalid Claims |
|
|
Rejection Notice |
|
|
Require Additional Information |
|
|
Duplicate Claims |
|
|
Claim History |
|
Contributions |
|
Participant |
|
|
Statement |
|
|
Reenrollment Form |
|
|
Forfeiture Notice |
|
Transactions, Adjustments |
|
Payments |
|
|
Status |
|
|
ACH, Pre Note File |
|
Compliance Reports |
|
ADP/ACP Reports |
|
Passed |
|
Failed |
|
General Non Discrimination Tests - provide at discretion of 3rd
floor (new Crystal Version?) |
|
|
Who benefits under 410(b) |
|
|
Excludables under 410(b) |
|
|
Average Benefit Percentage Test |
|
|
Non-Discrimination Test under 401 (a) (4) |
|
|
Minimum Allocation Gateway Test |
|
|
Overall Report |
|
|
Rate Group Report |
|
|
401(a)(26) Test Summary |
|
|
410(b) Coverage Test Summary |
|
|
401(a)(4) Non Discrimination Test Summary |
|
|
Defined Benefit, Annual and Accrued to Date |
|
Top Heavy |
|
Trust Accounting Reports |
|
Account Activity |
|
Account Reconciliation |
|
Balance Sheet |
|
Cost Analysis, Detail and Summary |
|
Deposit History/Contribution Analysis |
|
Gain/Loss on Sale of Investment |
|
Statement of Change in Financial Position |
|
Transaction without Offsets |
|
5500 Preparation Schedules H & I |
|
Asset Valuation |
|
Contribution Activity |
|
Distribution Activity |
|
Purchase and Sale Activity |
|
Income Activity |
|
Standard Reports |
The following reports are available in the system but do not utilze the Crystal
Reports Pro system to compile.
|
|
Plan Specifications |
|
Plan Management Accounts |
|
Projected Eligibility |
|
Standard and Custom Enrollment |
|
Employees at Normal Retirement |
|
5500 Participant Count |
|
Census Request |
|
Census Verification |
|
Age & Service |
|
Contribution Investment Direction |
|
Age Weighted Factors |
|
Maximum Deductible Contribution |
|
Distribution Summary |
|
Terminees with a Residual Balance |
|
Stock Registration |
|
Loan, Next Payment Due |
|
Loan, Payments Due in Date Range |
|
Loan, History & Summary |
|
Summary of Accounts, Negative/Small Account Balances |
|
Trial Balance by Source |
|
Fund Balance |
|
Participant Count by Fund |
|
Standard Query Reports |
Query entire database, plan groups or single plans for information such as:
|
|
Total Balnces by Fund |
|
Employee Count by Fund |
|
Employee Count with Balances by plan |
|
Employee Average Balance per Fund |
|
Accruals |
|
Funds with no prices
|
|