1 / 51

Trading-BSE-Repots2-branch P&L detail-Report no 309-Branch Management

Trading-BSE-Repots2-branch P&L detail-Report no 309-Branch Management.

brinley
Download Presentation

Trading-BSE-Repots2-branch P&L detail-Report no 309-Branch Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Trading-BSE-Repots2-branch P&L detail-Report no 309-Branch Management This is branch wise exchange wise report which shows total number of client of that branch , number of clients having POA, number of clients with web-ex id, number of New clients added within the period, number of clients who have done trading within the period, total turnover- trading & delivery of those clients , total brokerage of those clients, and exchange wise net debit balance of that branch

  2. Trading-BSE-Repots2-branch P&L detail-Report no 310-Branch Management Details This is branch wise- exchange wise- client wise- detail report which shows whether the client is POA or not, Web EX ID yes or no, total trading turnover, & total delivery turnover , total brokerage, debit balance of client in different exchanges

  3. Trading-BSE-Repots2-branch P&L detail-Report no 853-Branch Profit & Loss This is a summary report showing exchange wise-branch wise- income & expenses along with total number of clients, number of new clients added in that branch, number of clients having done trading during that period On further drill down – report no 851 is called for details

  4. Trading-BSE-Repots2-branch P&L detail-Report no 851-Branch Profit & Loss This is a summary report shows branch wise income and expenses account from date – to date represents -accounting date for general ledgers other income from brokerage, Refund brokerage Ref: - to the example shown below

  5. Trading-BSE-Repots2-branch P&L detail-Report no 851-Branch Profit & Loss

  6. Trading-BSE-Repots2-brokerage report -Report no 154-Brokerage calculation This report shows calculation of brokerage on dynamic basis that is what would have been the brokerage according to the values inputted in options given without cancellation of bill – (PER-REPRESENTS PERCENTAGE,MIN REPRESENTS MINIMUM for example ONESIDEPER- represents ONE SIDE PERCENTAGE , ONESIDEMIN – represents ONE SIDE MINIMUM OPTIONONESIDEPER-represents derivatives options one side percentage, OPTIONSONESIDEMIN- represents derivatives options minimum as example shown below

  7. Trading-BSE-Repots2-brokerage report -Report no 154-Brokerage calculation The above report will display Gross Quantity, Rate, Brokerage rate , Net Rate, Net Amount and the actual brokerage calculation on per trade along with terminal id

  8. Trading-BSE-Repots2-brokerage report -Report no 922 - Client Brokerage Performance This report is Branch wise- Family wise – Client wise showing total month wise clients brokerage total for different exchanges or we can say exchange wise month wise performance of clients brokerage

  9. Trading-BSE-Repots2-brokerage report -Report no 128 - Global Brokerage Summary II This report is branch wise global brokerage summary report showing total brokerage along with remeshire brokerage sharing too

  10. Trading-BSE-Repots2-brokerage report -Report no 113 - Global Brokerage Summary III This report is Exchange wise – Branch wise showing global branch brokerage total for different exchanges or we can say exchange wise performance of branch Brokerage

  11. Trading-BSE-Repots2-brokerage report -Report no 366 - Global Brokerage Summary IV This report is Exchange wise – Branch wise –Family wise showing global branch brokerage total for different exchanges or we can say exchange wise performance of branch Brokerage

  12. Trading-BSE-Repots2-brokerage report -Report no 49- Global Brokerage Branch Summary This report is Branch wise -date wise – exchange wise summary

  13. Trading-BSE-Repots2-brokerage report -Report no 925- Month wise Global Brokerage This reports shows month wise exchange wise brokerage that is per month total company’s gross brokerage for all segments.

  14. Trading-BSE-Repots2-Compliance -Report no 285 – Client Pan No Block Details This reports gives information about Pan Numbers blocked by SEBI / Exchange In the above example client code -54000 can been seen in how many segments it is opened /activated

  15. Trading-BSE-Repots2-BTST Reports -Report no 942 – BTST Report BTST- means buy today and sell tomorrow Input parameters from date to date ,select exchange from company code, select client if want to generate report for a single client, penalty percentage- in this option input the percentage figure for charging penalty on report level if the client is have net outstanding position of yesterday's Buy Refer to the example show below

  16. Trading-BSE-Repots2-BTST Reports -Report no 942 – BTST Report In the above report as we can see the client has not sold on the next day of buying so it Attracts penalty

  17. Trading-BSE-Repots2-Risk Management -Report no 900 – Risk Management This report gives information of the risk of clients This report is depended on risk management2 process Before generating the report tick on the fields required for considering risk of a client i.e. margin, collateral, client holding, etc Select filter if required , select operator and input value if want to generate above/ below the specific value inputted, select ageing days if required New debit list- ticking on this will show that clients which were credit in yesterday and debit in today

  18. Trading-BSE-Repots2- Risk Management -Report no 900 – Risk Management Client risk report will be generated along with consideration of inward & outward short if any, along with beneficiary valuation, if POA than POA valuation, holding for non POA, ageing days

  19. Trading-BSE-Repots2-Risk Management -Report no 125 – Branch Risk Management This report displays risk figure of a branch / branches for today and previous day

  20. Trading-BSE-Repots2-Risk Management -Report no 136 – Client Trading Frequency This reports shows trading frequency of clients based on different factors as displayed in the report below such as Number of days traded, no of orders, percentage of orders based on traded days, no of trades, percentage of trades, qty traded, qty percentage, trading turnover, delivery turnover, percentage of net turnover, gross brokerage, refund brokerage (remeshire sharing), net brokerage and percentage of it An example is sown in the below screen in excel form for you kind reference

  21. Trading-BSE-Repots2-Risk Management -Report no 136 – Client Trading Frequency Client wise trading frequency report

  22. Trading-BSE-Repots2-Risk Management -Report no 137 – Branch Trading Frequency This reports shows trading frequency of branches based on different factors as displayed in the report below such as Number of days traded, no of orders, percentage of orders based on traded days, no of trades, percentage of trades, qty traded, qty percentage, trading turnover, delivery turnover, percentage of net turnover, gross brokerage, refund brokerage (remeshire sharing), net brokerage and percentage of it An example is sown in the below screen in excel form for you kind reference

  23. Trading-BSE-Repots2-Risk Management -Report no 137 – Branch Trading Frequency Branch wise trading frequency report

  24. Trading-BSE-Repots2- Risk Management -Report no 339 – Risk Management report IV

  25. This is branch wise report displaying • Branch ledger – Total value of ledgers defined in branch master (other than branch clients ledgers)‏ • Value of branch stock- Total value of the stock of ledgers defined in branch master • UNC- The value considered in this option is clients Cash ledger balance, clients beneficiary stock value, clients inward / outward shortage value & value of clients associate account (if any)‏ • Pay in / Payout - Figure of branch pay in / payout • FOUNC- The value derived in this option is from clients derivatives ledger balance, clients collateral stock value, clients associate account and FD value • Comm UNC- The value derived in this option is from clients commodities ledger balance, clients collateral stock value, clients associate account and FD value • On drill down of the above report- report no- 340 is called in which details of client wise UNC figures are shown (as per the example shown below)‏

  26. Trading-BSE-Repots2- Risk Management -Report no 340 – Risk Management report v

  27. Trading-BSE-Repots2- Risk Management -Report no 355 – Risk Management report VI This report gives information of the clients risk This report is depended on risk management2 process Select filter if required , select operator and input value if want to generate above/ below the specific value inputted As per the example shown below clients net ledger (that is BSE, NSE, FNO) is shown Total stock (that is extra collateral, beneficiary stock, SOH, and inward / outward short

  28. Trading-BSE-Repots2-Risk Management -Report no 355 – Risk Management report VI

  29. Trading-BSE-Repots2-Sell Beneficiary Report -Report no 337 – Sell Beneficiary Report

  30. day- in this option in put ageing days • addition un concile credit- tick yes if required to consider unconciled receipt • consider access cash – tick yes if required to consider FNO excess cash (i.e ledger+colletral-margin+cash collateral after this any excess cash is left ) balance if any • poa stock – tick yes if required to consider poa stock • percentage – additional percent for e.g. you want to consider 5% extra on total (hundred percent) debit than input 5 there • scrip not include – select scrip’s from here which are not to be sold for debit • price%- for add or less (than input with minus sign) on previous closing price to be considered at the time generation of file for selling securities • in view data – Option to view only saleable scrip’s or all scrips can be selected from here

  31. Trading-BSE-Repots2-Sell Beneficiary Report -Report no 337 – Sell Beneficiary Report The above report shows cash clients ageing debit along with closing balance’s and their scrip’s parked in your beneficiary which can be sold up to cover up their respective ageing debit (on FIFO/ LIFO basis as per defined in system settings)‏ In system settings options are there for inputting any branch or family or client code which should not be considered while generating sale beneficiary file

  32. Trading-BSE-Day To Day - Sell Beneficiary File Generation Trading-day to day- sale beneficiary file generation- Generation of the file can be done as per the screen shown above and it can be uploaded on neat or bolt (as per exchange) and can also be uploaded in Odeon if ticked yes on Odeon file option in the above screen

  33. Trading-FNO-Repots2-Fo Sell Collateral -Report no 174 – FO Sell Collateral • day- in this option in put ageing days • addition un conciled credit- tick yes if required to consider un conciled receipt • consider access cash – tick yes if required to consider FNO excess cash • (i.e ledger+colletral-margin+cash collateral after this any excess cash is left ) • balance if any • poa stock – tick yes if required to consider poa stock • percentage – additional percent for e.g. you want to consider 5% extra on total • (hundred percent) debit than input 5 there

  34. Trading-BSE-Repots2-Fo Sell Collateral -Report no 174 – FO Sell Collateral The above report shows cash clients ageing debit along with closing balance’s and their scrip’s parked in your beneficiary which can be sold up to cover up their respective ageing debit (on FIFO/ LIFO basis as per defined in system settings)‏

  35. Trading-FNO-Repots2-Fo Margin Release -Report no 236 – FO Margin Release Shortage % - input percentage for shortage Price % - input price percentage Exclude last debit margin- tick here last debit margin is to be excluded SOH Broker Ap. Scrip- tick here if want to considered SOH broker approved scrip's only SOH Max Amount- if want to set soh amount limit tick here Refer to the example shown below

  36. Trading-FNO-Repots2-Fo Margin Release -Report no 236 – FO Margin Release

  37. Accounts-BSE-Repots2-Aeging Report -Report no 50 – Branch Ageing Analysis This is branch wise report and can be generated with or without inputting the parameters as below report type- normal / LIFO (Last in first out) / First in first out Can be filtered on specific column and amount Days I –Days II – Days III – in these options we can define the numbers of days which we want (for e.g. – 30-60-90, 15-30-45). If not inputted by default 3-5-7 days will come Across year – ticking on this option will considers lasts years out standing too. Refer to the example shown below

  38. Accounts-BSE-Repots2-Aeging Report -Report no 50 – Branch Ageing Analysis

  39. Trading-BSE-Repots1-Business Intelligence Report – This report is generated in excel – The uniqueness of this report is that we have a selection list from which one can select columns, define grouping and order by can and generated the report required by him (in short we can define our report and generate it)‏ Example shown below

  40. Trading-BSE-Repots1-Business Intelligence Report –

  41. Trading-BSE-Repots1-Brokers Report – This report can be generated by ticking on the report type options and selection of exchanges It gives us information about- new clients opened in branch with each exchange (as per selection), top ten debtors and creditors exchange wise, exchange wise turnover, client wise brokerage along with remeshire sharing Example shown below

  42. Trading-BSE-Repots1-Brokers Report –

  43. Trading-BSE-Repots1-Brokers Report –

  44. Demat-BSE-Repots2-Ageing Report -Report no 329 – Ageing Report II This report gives information about client shares lying in our beneficiary along with number of days. Through this We can ascertain that from how much time the client may have not cleared his payment. This reports displays Client code, beneficiary (counter), scrip name, isin, date, narration etc.

  45. Demat-BSE-Repots2-Ageing Report -Report no 330 – Ageing Report III Input number of days if required in the fields provided For e.g. 30,60,90 or 15-45-60 See the example below

  46. Demat-BSE-Repots2-Ageing Report -Report no 330 – Ageing Report III This report is branch wise- client wise and scrip wise showing quantity lying in beneficiary as per the number of Days defined at the time of generation

  47. Demat-BSE-Repots1- Settlement Report

  48. The above report provides information of • Missing DP details, Missing ISIN, Missing clients • Settlement process done or pending • Batches generated or pending • Type of files imported or not (e.g. SPEEDY, DPC9, RCBDL etc.)‏ • Pool stock status • Pay in / Pay out status details at a glance • Shortage transfer process done or not • Cell wise drill down available • Confirmed and non confirmed transactions

  49. Demat-BSE-Repots1- Beneficiary wise Summary This report can be generated by selecting respective options available considering debit – Only debit (negative) stock of client Considering credit- Only credit (Positive) stock of client Without beneficiary means only client stock will be shown Only beneficiary means – no clients but only beneficiary

  50. Demat-BSE-Repots2- Beneficiary Reports -Report no 981 – Ben Holding Status Check Through this report we get mismatch / difference of quantity if any between the quantity of shares lying in our beneficiary and actual quantity lying with DP See the example shown below

More Related