Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -13,16 +13,9 @@
13	13	(% style="text-align:center" %)
14	14	[[image:Calculating and Loading Interim_Final Rates_html_8cba33b1e8c9fa24.gif||height="128" width="463"]]
15	15
16		-{{info}}
17		-(% style="text-align: center;" %)
18		-(% style="color:#2980b9; font-size:22px" %)**TABLE OF CONTENTS**
19	19
20		-{{toc/}}
21	21
22		-
23		-{{/info}}
24	24
25		-
26	26	(% style="text-align: center;" %)
27	27	== (% style="color:#2980b9" %)**How to calculate and load Interim/Final rates on Everest**(%%) ==
28	28
...	...	@@ -40,11 +40,11 @@
40	40
41	41	[[image:Calculating and Loading Interim_Final Rates_html_aeedf1ec7013a979.png||height="178" width="91"]]
42	42
43		-Double Click on the (% style="color:#2980b9" %)**“UPs”**(%%) button for the product you want to update:
	36	+Double Click on the “UPs” button for the product you want to update:
44	44
45	45	[[image:Calculating and Loading Interim_Final Rates_html_559d28bc8ecfc4a0.png||height="100" width="381"]]
46	46
47		-A screen will open that reflects the (% style="color:#2980b9" %)**“Used Unit Prices”**(%%). These are the prices the system is currently using for calculation of member values and benefits.
	40	+A screen will open that reflects the “Used Unit Prices”. These are the prices the system is currently using for calculation of member values and benefits.
48	48
49	49	[[image:Calculating and Loading Interim_Final Rates_html_c6e0cf71f2b8533.png||height="183" width="393"]]
50	50
...	...	@@ -67,13 +67,13 @@
67	67
68	68	The new prices can be manually loaded in Everest, or the user may utilise the import file and function. Imports are preferred to prevent finger error.
69	69
70		-To load the unit prices via the import functionality, first determine the (% style="color:#2980b9" %)‘**ProductID**’(%%) for the product being updated.
	63	+To load the unit prices via the import functionality, first determine the ‘**ProductID**’ for the product being updated.
71	71
72		-To do this, ensure that the Parent is selected, go to (% style="color:#2980b9" %)Client → Investment Products:
	65	+To do this, ensure that the Parent is selected, go to Client → Investment Products:
73	73
74	74	[[image:Calculating and Loading Interim_Final Rates_html_aeedf1ec7013a979.png||height="178" width="91"]]
75	75
76		-On the screen that opens, note the (% style="color:#2980b9" %)**ProductID**(%%) for the relevant product:
	69	+On the screen that opens, note the **ProductID** for the relevant product:
77	77
78	78	[[image:Calculating and Loading Interim_Final Rates_html_b68b72a894d7efaa.png||height="88" width="366"]]
79	79
...	...	@@ -82,28 +82,29 @@
82	82
83	83	[[image:Calculating and Loading Interim_Final Rates_html_d5ab4359b6c55057.gif]]
84	84
85		-Populate the Date, (% style="color:#2980b9" %)**ProductID**(%%) and Unit Price columns:
	78	+Populate the Date, **ProductID** and Unit Price columns:
86	86
87	87	[[image:Calculating and Loading Interim_Final Rates_html_737d85a651d2cf90.png||height="158" width="139"]]
88	88
89		-To import the file, go to (% style="color:#2980b9" %)Accounts → Unit Price Management:
	82	+To import the file, go to Accounts → Unit Price Management:
90	90
91	91	[[image:Calculating and Loading Interim_Final Rates_html_570535c211e85663.png||height="191" width="86"]]
92	92
93		-Locate the (% style="color:#2980b9" %)“**Import your unit prices**”(%%) section:
	86	+Locate the “**Import your unit prices**” section:
94	94
95	95	[[image:Calculating and Loading Interim_Final Rates_html_4f1b11fda376cd0c.png||height="121" width="294"]]
96	96
97		-Click on the second (% style="color:#2980b9" %)**Import**(%%) button – Import Unit Prices for Parent Investment Products:
	90	+Click on the second **Import** button – Import Unit Prices for Parent Investment Products:
98	98
99	99	[[image:Calculating and Loading Interim_Final Rates_html_4f1b11fda376cd0c.png||height="121" width="294"]]
100	100
101	101
	95	+
102	102	Browse to pick up your saved import file:
103	103
104	104	[[image:Calculating and Loading Interim_Final Rates_html_591f84d57fbc47ca.png||height="162" width="252"]]
105	105
106		-Select (% style="color:#2980b9" %)**Save** (%%)and (% style="color:#2980b9" %)**Execute.**
	100	+Select **Save** and **Execute.**
107	107
108	108
109	109	A report will be produced indicating that the headings were recognised.
...	...	@@ -113,26 +113,24 @@
113	113
114	114	To confirm the rates were correctly imported, while on the Parent go to:
115	115
116		-(% style="color:#2980b9" %)Client → Investment Products.
	110	+Client → Investment Products. Double click on “UPs” for the product imported. At the bottom of the screen click on the “New Used UPs” button. The screen that opens will reflect the new prices that are ready for use:
117	117
118		-Double click on “UPs” for the product imported. At the bottom of the screen click on the “New Used UPs” button. The screen that opens will reflect the new prices that are ready for use:
119		-
120	120	[[image:Calculating and Loading Interim_Final Rates_html_c2201debac9c4fd5.png||height="149" width="244"]]
121	121
122	122	Once satisfied that the unit prices have been successfully imported, the prices are required to be linked for use in calculating the member values and benefits for the interim rate period.
123	123
124		-(% style="color:#2980b9" %)Go to Accounts → Unit Price Management:
	116	+Go to Accounts → Unit Price Management:
125	125
126	126	[[image:Calculating and Loading Interim_Final Rates_html_570535c211e85663.png||height="191" width="86"]]
127	127
128	128
129		-Locate the (% style="color:#2980b9" %)“**Link your investments**”(%%) section:
	121	+Locate the “**Link your investments**” section:
130	130
131	131	[[image:Calculating and Loading Interim_Final Rates_html_b993779320601de0.png||height="114" width="630"]]
132	132
133		-Click on the(% style="color:#2980b9" %) **fifth** (%%)“Select” button – Update used product prices from the ‘Start Date’ to the End Date’ section.
	125	+Click on the **fifth** “Select” button – Update used product prices from the ‘Start Date’ to the End Date’ section.
134	134
135		-In the screen that opens, select the product you want to update, date range you want to link and select “Test” in the (% style="color:#2980b9" %)**Custom 1**(%%) field. The Parent should be pre-populated but please do check it.
	127	+In the screen that opens, select the product you want to update, date range you want to link and select “Test” in the **Custom 1** field. The Parent should be pre-populated but please do check it.
136	136
137	137	[[image:Calculating and Loading Interim_Final Rates_html_13e8528d92a2925e.png||height="103" width="250"]]
138	138
...	...	@@ -144,10 +144,8 @@
144	144
145	145	To check that the prices updated correctly, while on the Parent go to:
146	146
147		-(% style="color:#2980b9" %)Client → Investment Products.
	139	+Client → Investment Products. Double click on “Ups” for the product. On the first screen that opens the new prices should appear.
148	148
149		-Double click on “Ups” for the product. On the first screen that opens the new prices should appear.
150		-
151	151	[[image:Calculating and Loading Interim_Final Rates_html_c148949d49fee58c.png||height="141" width="383"]]
152	152
153	153
...	...	@@ -163,12 +163,12 @@
163	163
164	164	__[[Monthly Retrospective Adjustment>>path:#_Retrospective_monthly]]__– All transactions processed in the interim period will have to be repriced. Any claims processed in the interim period will result in either positive or negative orphan units. If you are going to reprocess the claims and either pay additional or claw back overpayments, then this method will work for you.
165	165
166		-(% style="color:#2980b9" %)__Annual Adjustment__(%%) – The transactions for the interim period would be unaffected and the active member values would be adjusted at the final once off date.
	156	+__Annual Adjustment__ – The transactions for the interim period would be unaffected and the active member values would be adjusted at the final once off date.
167	167
168		-(% style="color:#2980b9" %)**NB!** (%%)With both methods, if you were processing claims for the period AFTER the Final rate was declared for, these claims would also create orphan units. It is best practice to hold payment of claims until the Final Rate is declared.
	158	+**NB!** With both methods, if you were processing claims for the period AFTER the Final rate was declared for, these claims would also create orphan units. It is best practice to hold payment of claims until the Final Rate is declared.
169	169
170	170
171		-=== (% style="color:#2980b9" %)**Final - Monthly Retrospective Adjustment**(%%) ===
	161	+=== (% style="color:#2980b9" %)**Final – Monthly Retrospective Adjustment**(%%) ===
172	172
173	173
174	174	To calculate the monthly retrospective adjustment for the period, use the Unit Price calculator provided by your consultant. OVERRIDE the Interim prices used in the original calculation spreadsheet with the new final rate:
...	...	@@ -179,11 +179,11 @@
179	179
180	180	[[image:Calculating and Loading Interim_Final Rates_html_aeedf1ec7013a979.png||height="178" width="91"]]
181	181
182		-Double Click on the(% style="color:#2980b9" %)** “UPs”**(%%) button for the product you want to update:
	172	+Double Click on the “UPs” button for the product you want to update:
183	183
184	184	[[image:Calculating and Loading Interim_Final Rates_html_559d28bc8ecfc4a0.png||height="100" width="381"]]
185	185
186		-Click on the (% style="color:#2980b9" %)**“New Used Ups” **(%%)button at the bottom of the screen:
	176	+Click on the **“New Used Ups” **button at the bottom of the screen:
187	187
188	188	[[image:Calculating and Loading Interim_Final Rates_html_7126ffabb5613f89.png||height="59" width="131"]]
189	189