Periodical Charge Module
Objective: Broker firm may charge client for optional service such as TELETEXT, which is a fee for client to read real time market price of stocks. Usually, teletext fee is charged monthly, and may be waived if monthly commission income exceed a specified amount e.g. $5,000.00.
This module will handle various fee with optional to waive such fee on specified condition. Refer to Periodical Charge Table
A Periodical Charge Table and a Waive Charge Table will be used to setup various type of charges, rates and frequencies.
Typical application will be TELETEXT, STOCK CUSTODY, FUND MANAGEMENT ..etc.
Different type of charge can be applied for different period to time. Common cases including :-
(W)Weekly, (M)Monthly, (Q)Quarterly, (H) Helf-year, (Y)Yearly, (A) On Date (A date to apply fee)
Charge Rate can be based on a. Flat Rate, e.g $350 per month for teletext b. % of Portfolio Value, c. Commission of the period. d. Number of B/S transaction of the period (not suggested because not work for multiple price module)
and Waive Conditions can be based on a. Commission of a period > "specifed value" b. Number of B/S transaction > "specifed value" c. Net Cash Balance > "specified amount"
Since the impose of charge and the waiving of charge may be on different date.
e.g. 1. Charge of teletext fee on the beginning date of a month, and rebate the fee on the first date of next month (based on waiving condition. The monthly commission is > $5,000 for previous month).
2. Charge of stock custody fee for every 6 months based on lot size of the date before the effective date, and rebate the fee on the same date if the total buy/sell turnover > $10,000,000
Two table will be used to manage the charge scheme and waiving scheme. One for actions to debit client's account, and the other for actions to credit client's account.
Different effective date can be setup accordingly.
| (Windows 細明體) ( ) PERIODICAL CHARGE Share | +------------------------------------------------------------------------------+ 0. EXIT 1. SETUP CODE A. PERIODICAL CHARGE CODE B WAIVE CHARGE CODE 2. CHARGE ACTION ENTRY 3. CHARGE & WAIVE REPORT 4. GENERATE CHARGE(S) & WAIVE 5. RENEW OF CHARGE ACTIONS ENTRY S. SYSTEM SETUP
( A) SETUP PERIODICAL CHARGE CODE & WAIVE CHARGE CODE ----------------------------------------------------------------------------- CHARGE CODE : C01 DESCRIPTION : TELE-TEXT MONTHLY CHARGE ( B) SETUP PERIODICAL CHARGE CODE & WAIVE CHARGE CODE ----------------------------------------------------------------------------- CHARGE CODE : W01 DESCRIPTION : WAIVE CHARGE
-------------------- 2. CHARGE ACTION ENTRY -----------------------
A/C CODE: A00001 NAME OF A00001
CHARGE CODE [C01] Name [ TELE-TEXT MONTHLY CHARGE ]
RATE: Flat Rate Amount [$ 350 ]
[ ] % of Portfolio Value based on last transaction date
Lot size of all stock on hand x [ $ /Lot ] based on qty. on last transaction date
Effective Date: [dd/mm/yyyy] assigned in CLMAST.DBF together with the CHARGE CODE
Frequency : EFFECTIVE DATE + [ ] week / [ ] month (leave blank to use the effective date recorded in CLIENT MASTER)
Instruction:- Weekly = Effective Date + 1 week or the following transaction date Monthly = Effective Date + 1 month or the following transaction date Quarterly = Effective Date + 3 months or the following transaction date Helf Year = Effective Date + 6 months or the following transaction date Annually = Effective Date + 12 months or the following transaction date
WAIVE CONDITION CODE [ W01 ] refer to code table for condition details Blank if no waive is applicable
--------------------- WAIVE ACTIONS ENTRY -----------------------------
A/C CODE: A00001 NAME OF A00001
WAIVE CODE [W01] Name [WAIVE CHARGE ]
RATE: Flat Rate Amount [$ 350 ] <--- Amount to be credit to client
[ ] % of Portfolio Value based on last transaction date
Lot size of all stock on hand x [ $ /Lot ] based on qty. on last transaction date
Effective Date: [dd/mm/yyyy] assigned in CLMAST.DBF together with the CHARGE CODE
WAIVE CONDITIONS:
Commission Amount > [ ] based on monthly commission total of last month.
Turnover > [ ] based on the last day of the effective date
Frequency : EFFECTIVE DATE + [ ] week / [ ] month (leave blank to use the effective date recorded in CLIENT MASTER)
INSTRUCTION:- Weekly = Effective Date + 1 week or the following transaction date Monthly = Effective Date + 1 month or the following transaction date Quarterly = Effective Date + 3 months or the following transaction date Helf Year = Effective Date + 6 months or the following transaction date Annually = Effective Date + 12 months or the following transaction date ------------------------------------------------------------------------------ Create Browse Amend Delete Undel Search Filter Previous Next Top List Exit Query COPY DETAILS FROM PERIODICAL CHARGE CODE [ ] <----
e.g. Charge code Name Period Rate <---- Waived Code---> ---------- --------------------- ----------- ------- --------------------------- C01 Monthly TELETEXT (M)Monthly 350 W01 C02 Stock Custody Fee (H)Helf year $5xlots W02 C03 Fund Management (A)Last trade % of Nil fee date Portfolio value
Waive code Name Period Rate <---- Waived Conditions---> ---------- --------------------- ----------- ------- --------------------------- W01 Monthly TELETEXT (M)Monthly 350 M.Comm.> 5,000 W02 Stock Custody Fee (H)Helf year $5xlots Monthly Turnover >5M W03 Fund Management (A)Last trade % of Nil fee date Portfolio value
|