Asset Based fees

This functionality allows you to run a batch, once a month, either for a single Client, or for the Parent, based on the Fund Credit holding at person/member/client level.

30

31

32

= (% style="color:#2980b9" %)**Investment Fee Scale / Flat Rate / Fixed Deduction Setup**(%%) =

33

34

35

To create a new Investment Fee Type go to Administration → Financial Settings → Investment Expense Settings → Investment Fees:

36

37

[[image:image-20250206093912-38.png||data-xwiki-image-style-alignment="center" height="548" width="865"]]

38

39

40

A screen with 2 tabs will open. Make sure you are on the Fee Scale Tab:

41

42

43

[[image:image-20250206092457-2.png]]

44

45

46

Any previously created scales will appear on this screen:

47

48

49

[[image:image-20250206092517-3.png]]

50

51

52

Double clicking on the view scale hyperlink, will populate a section at the bottom of the screen, which displays the scale for that levy:

53

54

55

[[image:image-20250206092559-4.png]]

56

57

58

As can be seen in the example above, you can create an scale based on an asset range, an asset fee% and a fixed amount.

59

60

61

To create a NEW Scale, double click on the “Click here to add a new row” field, on the TOP section of the screen:

62

63

64

[[image:image-20250206092619-5.png]]

65

66

67

Populate the fields as below:

68

69

70

[[image:image-20250206092636-6.png]]

71

72

73

**Investment Scale ID**: do not populate, this will be auto-created by Everest

74

75

**Scale Name**: this is a free form text field – populate the name of the new scale, making sure the name is UNIQUE.

76

77

**Fund Credit Calc Type**: there are 3 options to choose from:

78

79

* Weighted – this is a money weighted calculation that takes into account transactions for the period selected when running the batch to calculate the fees

80

* Open – this will use the Fund Credit value at the Open Date selected on the batch to calculate the fees

81

* Closing – this will use the Fund Credit value at the Closing Date selected on the batch to calculate the fees

82

83

**Accounts Description**: this is the ledger account you want to deduct fees in respect of

84

85

86

In the example image below, the new fee would be for Fund Levies, using the Opening Fund Credit Value.

87

88

89

[[image:image-20250206092653-7.png]]

90

91

92

Select “**Update**” once all fields have been populated.

93

94

95

To populate the scale to be applied, double click the view scale hyperlink:

96

97

98

[[image:image-20250206092711-8.png]]

99

100

101

Populate the applicable scale in the section that opens at the bottom of the screen:

102

103

104

[[image:image-20250206092727-9.png]]

105

106

107

Note about the Fee Fixed Amount field – this is an ANNUAL amount. i.e. if 2 500.00 must be applied per month, then this field would be populated with an amount of 30 000.00.

108

109

110

Save the changes made:

111

112

113

[[image:image-20250206092739-10.png||data-xwiki-image-style-alignment="center"]]

= (% style="color:#2980b9" %)**Setting up the scale to be applied to members**(%%) =

118

119

120

Select the Investment Expense Tab:

121

122

[[image:image-20250206092757-11.png]]

123

124

Any previously created Investment Expenses will appear on the screen:

125

126

[[image:image-20250206092812-12.png]]

127

128

129

To create a NEW Investment Expense, double click on the “Click here to add a new row” field, on the TOP section of the screen:

130

131

132

[[image:image-20250206092844-13.png||data-xwiki-image-style-alignment="center"]]

133

134

135

A popup will open as below:

136

137

138

[[image:image-20250206093012-15.png]]

139

140

141

**NB! When adding a new expense, make sure you understand if the fee must apply to ALL clients, specific clients, ALL products, specific products OR if the client/product must be excluded from the bulk monthly calculation.**

142

143

144

**Client Parent ID**: this will automatically be the Parent that you are loading the fee on

145

146

**Client Name**: populate the client if the fee is ONLY applicable to that client, otherwise leave blank

147

148

**Product Name**: populate the product if the fee is ONLY applicable to that product, otherwise leave blank

149

150

Effective Date: the date from which the fee is applicable

151

152

**Terminated Date**: if the fee must stop calculating, populate this field with the day AFTER the last calculation must be performed. e.g. if the fee must be calculated at 31/12/2024, but must not calculate for 31/01/2025, make the termination date 01/01/2025.

153

154

**Investment Scale**: populate from the available list of investment scales (created on the Fee Scale tab earlier)

155

156

**Payee Name**: who must the fee be paid to?

157

158

**Scale Method**: there are 3 options to choose from:

159

160

* Client – this will ADD the TOTAL fund credit for the whole client, and apply the fee scale to that total

161

* Member – this will use the total Fund Credit value of that member only

162

* Person – this will use the TOTAL Fund Credit value for a person record. i.e. any members who are linked together on the database. e.g. you have a member on a Preservation Pension Fund AND a Preservation Provident Fund – using this method will add the Fund Credit for both records (as long as the records are linked at person level – see batch later in the manual for how to link records), and apply the fee scale applicable to that TOTAL.

163

164

**Scale Method Type**: there are 2 options to choose from:

165

166

* Daily – this method will apply a daily weighted calculation

167

* Monthly – this method will calculate the fee based on the total at month end/opening (depending on what is selected on the Fee Scale created)

168

169

**Product Exclusion**: If this box is ticked, the fee will not calculate. This can apply to a whole client or a whole product.

170

171

172

Some examples are below to explain the different scenarios:

173

174

175

**//Apply fee to the whole Parent~://**

176

177

[[image:image-20250206093121-19.png]]

178

179

180

**//Exclude product from whole Parent//**//- ** **this will exclude the whole product from ALL fee calculations~://

181

182

[[image:image-20250206093045-17.png]]

183

184

185

**//OVERRIDE fee at client level – //**//If a fee is applied to a client, it will override ALL fees loaded at Parent level, and therefore you must load a fee, for that client, for ALL fees that must be applied to that client~://

186

187

[[image:image-20250206093103-18.png]]

188

189

190

**//Exclude Client from fee calculation //**//– this will exclude the whole client from ALL fee calculations~://

191

192

[[image:image-20250206093148-20.png]]

193

194

195

= (% style="color:#2980b9" %)**Member Level Broker Fee Setup**(%%) =

196

197

198

To set up the Broker fees we first need to create the broker, and their applicable agents.

199

200

To create the Brokerage, go to People → Brokerage:

201

202

[[image:image-20250206093215-21.png||data-xwiki-image-style-alignment="center"]]

203

204

A screen will populate with all current Brokers loaded on the system:

205

206

[[image:image-20250206093237-22.png]]

207

208

To create a NEW Brokerage, double click on the “Click here to add a new row” field:

209

210

[[image:image-20250206093301-23.png||data-xwiki-image-style-alignment="center"]]

211

212

On the screen that opens, there are only 2 mandatory fields:

213

214

[[image:image-20250206093320-24.png]]

215

216

217

**Brokerage Name**: this is a free form text field

218

219

**Administrator Bank**: this is the Bank Account that the fees must be paid to. These bank accounts are created via Administration → Financial Settings → System Bank Accounts. Please refer to your supervisor if a new bank account needs to be loaded

220

221

222

Select “**Update**” and then Save the screen change.

223

224

To create the Broker Agent, go to People → People Brokerage:

225

226

227

[[image:image-20250206093338-25.png||data-xwiki-image-style-alignment="center"]]

228

229

230

On the screen that opens, there are only 2 mandatory fields:

231

232

233

[[image:image-20250206093358-26.png]]

234

235

236

**Brokerage **: populate with the brokerage that was created on the People → Brokerage screen

237

238

**Contact Person**: this is the Broker Agent. There must be a person record created for the agent via People → Search. On the Person record created, you must tick the Broker Consultant field in the Designation section of the person record:

239

240

**Administrator Bank**: This would only be populated if the bank account being paid to is different to the Brokerage.

241

242

243

[[image:image-20250206093416-27.png]]

244

245

246

Once these screens are populated, you now need to load the broker fee on the member record.

247

248

249

Search for the applicable member, select the “info” button, and then go to the tab “Member Investment Fee Scale:

250

251

252

[[image:image-20250206093435-28.png]]

This screen is made up of two parts:

257

258

[[image:image-20250206093457-29.png]]

259

260

261

The top section holds the fee to be applied, while the bottom section holds the broker, and broker agent, where the fee must be paid to.

262

263

264

You can update the fee section independently of the broker section and vice versa. e.g. if the broker changes his fee from 0.25% to 0.35%, you terminate the existing row and then add a new row in the fee section only.

265

266

267

To add a new fee to a member, double click on the “Click here to add a new row” field in the top section of the screen:

268

269

270

[[image:image-20250206093539-31.png||data-xwiki-image-style-alignment="center"]]

271

272

273

On the screen that opens, populate the relevant fields:

274

275

276

[[image:image-20250206093600-32.png]]

277

278

279

**Effective Date **: the date from which the fee must apply

280

281

**Investment Scale**: Select the scale to be applied (created earlier in the manual). To note, this screen can be used to override, at member level, any other fee applied via the Investment Fees Screen. In this case, we are adding a broker fee.

282

283

**Fee Percentage**: this is the fee% to be applied

284

285

**Asset Start & numAsset End**: you can create a scale of fees to apply to this expense

286

287

**Fee Fixed Amount**: If the fee is a fixed fee, instead of a %, populate this fee

288

289

**Terminated Date**: if the fee must stop calculating, populate this field with the day AFTER the last calculation must be performed. e.g. if the fee must be calculated at 31/12/2024, but must not calculate for 31/01/2025, make the termination date 01/01/2025.

290

291

292

Select “**Update**” and then Save the screen change.

293

294

295

To add the broker applicable to a member, double click on the “Click here to add a new row” field in the bottom section of the screen:

296

297

298

[[image:image-20250206093539-31.png||data-xwiki-image-style-alignment="center"]]

299

300

301

On the screen that opens, populate the relevant fields:

302

303

304

[[image:image-20250206093624-33.png]]

305

306

307

**Investment Scale**: Select the scale to be applied (created earlier in the manual)

308

309

**Broker**: Select the Broker/Broker Agent combination from the available drop down (created earlier in the manual)

310

311

**Effective Date **: the date from which the fee must apply

312

313

314

Select “**Update**” and then Save the screen change.

315

316

317

= (% style="color:#2980b9" %)**Batch to run Asset Based Fees**(%%) =

318

319

320

Select the batch “**Parent Investment Product Expenses**”.

321

322

323

[[image:image-20250206093646-34.png]]

324

325

326

It is **VITAL** that the dates are populated correctly, based on the way the asset levies must be applied AND that a Test Run is done before running a Live run.

327

328

329

**Client**: populate this field if the fees must be calculated for that client ONLY, otherwise leave it blank

330

331

**Effective Date**: this is the date that the disinvestment will be done on Everest. The Unit Prices must be updated and linked BEFORE this batch is run.

332

333

**From/Open Date **: the date from which the fee must apply. If your fee uses the fund credit at the beginning of the month, you populate this field with the first day of that month.

334

335

**To/Close Date** : the date to which the fee must apply. If your fee uses the fund credit at the end of the month, you populate this field with the last day of that month.

336

337

**Batch Ref**: Do not change

338

339

Client Parent: The Parent the batch is being run on

340

341

**LIVE/TEST**: If Test is selected, a report will be produced that reflects all of the fees that are calculated. The test run can be run multiple times. Once you have checked, and are happy with the test run, you can run the Live batch. Live will write up the creditor entries for the payments to be made, as well as the disinvestment for the fees.

342

343

344

“Save” and “Execute” the batch. An excel report will be generated. Please note that the batch does take a while to run, depending on the size of the membership.

345

346

347

The report will produce a Summary tab, an Accounts Summary tab, and a tab PER CLIENT if the batch is run for the full Parent:

348

349

350

[[image:image-20250206093702-35.png||data-xwiki-image-style-alignment="center"]]

351

352

353

**Summary**: This tab provides a high-level breakdown of what fees are being applied to the Parent, exclusions, payee info, and totals per product:

354

355

356

[[image:image-20250206093730-36.png]]

357

358

359

[[image:image-20250206093757-37.png]]

360

361

362

**Accounts Summary**: This tab provides a high-level breakdown of what accounting transactions are being applied to the Parent, payee info, and switches per product and policy:

363

364

365

[[image:image-20250206094016-39.png]]

366

367

368

**Per Client: **This tab provides a by member, by product, by fee breakdown:

369

370

[[image:image-20250206094052-40.png]]

371

372

373

(% style="color:#e74c3c" %)**A note about members with multiple products and money types. Everest will ratio the applicable fee across the products and money types, so the member statement will have multiple rows reflecting each transaction.**

374

375

376

An example member statement after the LIVE run is performed (transactions in black are unpriced and will affect your closing fund credit value):

377

378

379

[[image:image-20250206094123-41.png]]

380

381

382

= (% style="color:#2980b9" %)**Batch to link person records**(%%) =

383

384

385

Where a member has multiple records and the Fund Credit must be combined for the asset-based fee calculation, use batch “**Person Record Allocation to Existing Member**”.

386

387

388

[[image:image-20250206094140-42.png]]

389

390

391

**Client**: populate with the client that one of the member records belongs to

392

393

**Member**: populate with the member on that client

394

395

**To Member **: populate with the SYSTEM NUMBER of the member you want to link this record to

396

397

398

Once the batch is run, you can do a People Search for the records, select the “Fund Information” tab and you will see the 2 records, on the 2 different clients.

399

400

401

[[image:image-20250206094203-43.png]]

These records will now have their Share of Fund **COMBINED** for the purposes of the fee calculations, as long as the “person” Scale Method is applied to that fee on the Investment Expenses screen.

406

407

408

(% style="text-align: center;" %)

409

= (% style="color:#2980b9" %)**Copyright and Disclaimer**(%%) =

**DISCLAIMER**

Please note, whilst care is taken to illustrate numerous scenarios, it is impossible to detail all instances and therefore this document should merely serve as a guide for the purposes of demonstrating system functionality and conducting employee training.

415

416

417

In accordance with the above paragraph, this training manual is published and distributed on the basis that EBSphere (Pty) Ltd is not responsible/accountable for any actions taken by users of information contained in this training manual nor for any error in or omission from this manual.

418

419

420

EBSphere (Pty) Ltd does not accept any responsibility whatsoever for a misrepresentation performed by any person in respect of claims, losses or damage or any other matter, either direct or consequential arising out of or in relation to the use and reliance, whether wholly or partially, upon any information contained or products referred to in this manual.

421

422

423

Further, the contents of this training manual are subject to change without any notice and further highlight the need for this training manual to serve only as a guide.

**COPYRIGHT**

This documentation and the software described in it is the exclusive property of EBSphere (Pty) Ltd. This manual or the software may not be copied in whole or part, without the express written consent of EBSphere (Pty) Ltd. Under the law, copying includes translating into another language or format.

429

430

431

EBSphere (Pty) Limited

P.O. Box 785803

Sandton