# Commex Back Office

Table of contents
Introduction
Login Process
Initial Settings
Menu Bar
How to open Account
Daily Processing
Contract Note
Voucher Entry
Payment Control Report
Introducer Calculation
Support System
Contact Us

## Introduction

Commex is the latest state-of-the-art Multi-Commodity software for Indian Commodity Exchange like NCDEX, MCX , ICEX, NMCE, ACE etc. that will help you become more efficient, competitive and highly productive Service Center for Commodity Market and you can extend your business into a global market. Commex is used extensively throughout Asian market by some of the largest broking firm in India. Extensive functionality includes Client Data Management, Trade Done, Daily MTM Bills, Margin Management, Corporate Actions and Accounting. Commex is very user friendly, tried and time tested software with all functionality of Commodity Market Segments which covers all exchange based compliances and your client needs. Whether you are small stock broking house or big, this software includes essential integrated functions for effective and accurate accounting.
Top

## Login Process

1. Double click on commex.exe icon(as shown below)
2. Following Window will open
3. Select database in which you want to work
4. After database selection, login window will open (as shown below)

Enter userid and password or login by default

Top

## Initial Settings

1. Do the following settings before starting Commex
2. Select Masters>>Margin and Transaction Fee
3. Select Margin and Transaction Fee, following window will open
Transaction fee is default set by NCDEX,which is 0.0004% chargeable from CLIENT and paid to Exchange and Sub -Broker to Main Broker. In this option we can define exposure Margin also on %age basis.
4. Select Branch/User ID file maintenance (Trades) from master menu, following window will open
5. If a member of any exchange wish to open Branch Office at different location then he can maintain the branch details i.e. Branch name, User ID and other details. OR
If main member or the branch has allotted id's to other clients and wish to maintain trade ID wise, he has to define User ID and the client code to get the relevant information.
6. Select Client Master from Master menu, following window will open
To maintain client account fixers go to Client master and Default value Fixer and define client's related information setting.
7. Select System file maintenance form Utility Menu and set parameters carefully, as shown in the following window

Top

## Menu Bar

Masters
Imports
Daily
Processing
Bills
Delivery/Stock
Reports
Margins
Financial
Backup
Utility
Shortcut Keys

### Masters

1. When user click on the master menu, following drop-down list will open
2. Contract Specification:
   This option provides details about commodities. After importing Contract Specification file, all the information related to contract symbol would automatically added into the database.
   In MCX all contracts having margin indicator with % will be added automatically
3. Region Master
4. RM/TL Master
5. Branch(Location)Master Creation/Modification
   If a member of any exchange wish to open Branch office in different locations, he can create Branch details with this option. i.e. Branch Name, Branch Head, Branch Id, Branch Contact Name, Email Address etc. If a member of any exchange wish to open Branch office in different locations, he can create Branch details with this option. i.e. Branch Name, Branch Head, Branch Id, Branch Contact Name, Email Address etc.And select it from client master while adding details about branch client.This is for central accounting purpose.
6. Sub-Branch(Location)Master Creation/Modification
7. Client Master
   To maintain client’s information, first of all users have to define a unique code along with its related information in this option. User has to define all the information given in the following screen.

   Default Value Fixer
   With this option, user can define default values while opening account

   PARAMETERS for CLIENT MASTERS

   S.No | Parametere's Name | Description
   --- | --- | ---
   1. | Opening Balance(+ -) | 0.00 (If any); select minus (-) sign for debit balance and + for credit balance
   2. | Brokerage Method(Charge/Pay) | Charge(C)/Pay(P) (C: Charge from Sub Broker or client for main broker and P: Pay to Main Broker for sub broker only)
   3. | Trading Short Code | Terminal Client Code. But not necessary.
   4. | Brokerage Slab Id | Enter brokerage slab id
   5. | Brok. Calculation Upto decimal(2 to 9)) | Client can define decimal place (2 to 9) for brokerage calculation.
   6. | Contract Generate Enabled Y/N | Enter Y to generate contract note otherwise enter N
   7. | Stamp Duty Applied(C/P/N) | Enter C for charge; P for Pay; N for not applicable
   8. | Stamp Duty % | Define Stamp Suty percentage
   9. | Stamp Duty %(Delivery) | Define Stamp Duty percentages applied on Delivery
   10. | Dly Mgn Posting(MG13/Span/G.Exp)Y/N | If wants to post daily margin then Enter Y otherwise N
   11. | Transaction Fee Applied C/P/N | Enter C for Charge; P for Pay; N for not aplicable
   12. | Regular(Exposure) Margin Applied Y/N | write Y if wish to calculate Exposure wise flat margin other wise N
   13. | Special Margin Applied Y/N | Enter Y to apply special margin otherwise enter N
   14. | Delv. Margin Applied Y/N | Enter Y to apply margin otherwise enter N
   15. | S.Tax Method(C-Charge,P-Pay,I-Ignore) | Enter C for charge, P for pay; I for ignore tax Cash
   16. | Cash Margin Account Code | Define seperate cash magin account code for main code
   17. | Dly MTM Account Code | It will automatically update M+Client Code (separate MTM a/c) (N/A)
   18. | Dly Margin Account Code(Mg13) | It will automatically update D+ Client Code (separate daily margin a/c
   19. | DP ID | Client’s depository id
   20. | DP Client ID | Client’s unique id nos. from that depository
   21 | Introducer Account code | Client’s first introducer code.
   22. | Introducer Account Code-2 | Client’s second introducer code
   23. | Introducer % for 2ND | Client’s second introducer percentage.
   24. | Intoducer Account code-3 | Client’s third introducer code.
   25. | Intoducer % for 3RD | Client’s third introducer percentage.
   26. | Intrest on Debit Balance(Rate of Int. %) | Define interest percentage on debit balance
   27. | Intrest on Credit Balance(Rate of Int. %) | Define interest percentage on credit balance
   28. | Intrest on Debit Balance(Applied when Int.) | Interest on debit balance is applied when intrest is greater then the interest defined here
   29. | Pan No | Enter pan no
   30. | Serv. Tax on traxn.Fee C/P/N | Write C for charge ; write P for pay ; write N for not applicable
   31. | Other Charges % | Define other charges percentage
   32. | Account Status | Write Disable or D to disable the account status or Enable or E to enable
   33. | Account Status Changed Date | Enter account status date from when account status is applied
   34. | Clg. Charges Applied C/P/N | Write C if wants to charge ; write P if wants to pay ; write N for not applicable
   35. | S.Tax Applied on Clg. Charges C/P/N? | Write C if wants to charge ; write P if wants to pay ; write N for not applicable

   After define each parameter in client master, save the information by click on SAVE or Press F9
8. Bank Details
9. Balance Sheet Account Head Master
   To create Balance Sheet Account Head for financial entries such as Bank, Cash, and Expenses advances & other Journal entries etc user can create a/c code and name from this option.
Click Balance Sheet Account Head Master, Give Account Code, Account Description, Account Group and SAVE For Example: Cash Account under Group Cash in Hand Bank Account under Group Bank Account under Current Assets Expenses account under Group Expenditure Account
10. Account Group Transfer
    By mistake if we have created any account in some group, with this option we can transfer the existing group to the new group.
11. Brokerage Schedule
    Here user can define brokerage as per client. In following manner:
    Brokerage Schedule can be defined in the following ways:
    - Client wise -(Means create all client’s brokerage separately using this method) It means that if you have 100 clients then you have to create brokerage hundred times.
    - Slab ID -(Means you can define slab id system and then select the slab id provided in Client Master; it means that you create slab1 for .5%, slab2 for .3%, slab3 for .4%.And select this slab id from Client Master.
    - Common - Means if user will define brokerage here then it will be applicable to all client’s having without brokerage; and (in this case User will not have to define all clients’ brokerage.)
    Note:Define Brokerage 0% for NCDEX or MCOMM or PRO while setting Common brokerage We can define brokerage separately with Fixed (%), Minimum (in paisa) & Expiry (%) parameters. Minimum brokerage will be defined in Rs and paisa (like (11.15)); if the calculated % brokerage is less than the minimum brokerage then the minimum brokerage will be charged. User can define symbol wise brokerage either Unit based (which is charged in rupees) or percentage wise as per their requirement. User can define delivery brokerage, which is applicable at delivery entry time provided at delivery section.
12. Branch User/Id File Maintenance (Trades)
    If a member of any exchange wish to allot user id to Branch Office or individual client in different locations,he can maintain the Branch Id details i.e.Branch or client user id and id's releted client code and pro trades code details.Means if main Broker has given ID to sub broker and wish to have seperate trade ID wise; he has to define User ID and client code to get the relevent information.
13. Margin and Transaction Fee
    Transaction Fee is default set by NCDEX, which is now 0.0035%, or define as per circular announced by exchange time to time. User can define here either default or client wise turnover charges.In this option user can define Exposure Margin on %age basis and symbol wise too. (Not necessary if you are importing margin file (MG13) from Exchange.)
14. Clg. Charges Master
15. Unique Client Information
    In this option user can define details about the clients, trading on terminal with all relevant information required by the Exchange such as the personal information PAN number, and send to exchange as per Exchange requirements or more details see Circular provided by exchange.
16. Account Group Master
    We can create separate Account Group for the clients define in separate category
17. Group Master
    If user wish to create separate sub group in Balance Sheet’s, which is not defined, can create new group up to two levels. For example if we want to create Brokerage Group under Revenue Account group, we can create the same. For more details consult your Chartered Accountant.
18. Depository Participents Maintenance
    Here user can add all information about Depository Participants for demat delivery purpose.
19. Warehouse Location Maintenance
    Here user can add warehouse locations of different commodities. User can import warehouseloc.txt provided in Import options at next module or call exchange for more details.
20. State Master
21. Holiday Master
    User here can add holyday provided in circular time to time By default we skip all Sundays and national holyday (as 26 January, 15th August,02 October and 25December) and except this user can add here.
22. Mail/FTP/Digital setup
23. Expenses Master(Charged on Clients)

Top

### Imports

1. When user click on the Imports menu,following drop-down list will open
2. Daily Trades
   Whatever trades we do on front office terminal daily, goes in to trade file folder in front office and we have to import it into our back office software for further process. The file named Tradecom.txt contains all the trades done on front office terminal
3. Contract Specification File
   To add commodities and its contracts schedule. User need not remember this file when you select either MCX or NCDEX its file name and type will automatically appear ion box. Commodity opened in exchange has its own specification decided by the exchange and import all commodity to the back office software for further process. The file name for this file is like NCDEX_CN01_.csv. For MCX contracts file is contractmaster.csv
4. Daily Closing Price
   We have to import daily closing price into back office software on daily basis. User need not remember these files when you select either MCX or NCDEX its file name and type will automatically will appear on box.NCDEX provides three type of closing rate files user can choose any one of them.
5. Margin File
   For client’s margin imposed by exchange we have to import margin file from exchange’s FTP system. This is for main broker named MG13 file.
   User need not to remember these files when you select either MCX or NCDEX its file name and type will automatically will appear on box.
6. Margin File(Dly Margin-Additional/Pre-Expiry)
7. Order File NCDEX
   If the sub broker or client is using REMARK field on front office for client code and wish to transfer trades automatically in actual client accounts (which is opened in back office), one has to import the order file first and while importing trade file click on “ Use Order file for client from REMARK” at TRADE IMPORT options. It will transfer all the trades in their original code automatically. User need not remember these files when you select either MCX or NCDEX its file name and type will automatically appear on box. This is optional.
8. Order File(Mcx)
9. Exposure Margin
10. Position File
    This file is to compare the trades done by a client in different codes verses exchange. Basically to find differences between exchange position and our exchange trades. MCX not provides exchange positions file like (PS03) to import.
11. Risk Parameters File for Span
    To calculate risk margin on trades, software has a facility to calculate risk margin on trades done by client specially for LIVE SPAN Margin. File name is Nsccl_ncdex.20060612.s.spn
12. Delivery File Import(SS06/SS05)
    NCDEX provides delivery file named “ncdex_ss06_00537_R20060206.csv”, delivery done by clients.
13. Depository participants
    This file is for depository participants imports.
14. Warehouse Location
    This file is for warehouse locations. By import user can add all warehouse locations.

Top

### Daily

1. When user click on the Daily menu, following drop-down list will open
2. Daily Closing Price Manual Entry/Edit(c/F Rates)
   If users do not get the closing price file from the FTP he will have to enter daily closing price manually to match the MTM.
3. Closing Price Entry/Edit(for Expiry)
   If we do not get the closing price file for expiry from the FTP we will have to enter the closing price manually to match the expiry MTM. NCDEX and MCX do not provides separate expiry closing price; daily closing price file will do expiry too.
4. Userid Wise Summary for the day
   User Id wise summary option will provide the confirmed trade information imported by trades file about all user id like this which sorted user id wise.
5. Trade Entry/Modify
   Trades Entry / Modify option will allow us to enter new trades or modify daily trades. At this options user add off market transactions or that transactions which is not in trades file. While entering manual transactions add contra transactions of broker or exchange i.e.
   For example: contra sauda—CA001 is purchasing crude oil of 1000 qty @1500 price
   MCX is selling crude oil of –1000 qty @1500 price
6. Without Brokerage Trade
   his option will provide the trade details having without brokerage CLIENT. If found without brokerage client and want to impose brokerage go to brokerage master and define brokerage then run BROKERAGE RECALCULATION options in DAILY.
7. Trade Check List
   Trade check list option will provides all the details of traded commodity such as sale or buy, multiplier, trade price, traded qty value, order no., order time, trade no, etc. by client wise.
8. Trade Check LIst Details(New)
9. Trade Reconciliation
   With this option we can reconcile all our trades done on front office terminal. If any error or mismatch in trade quantity or trade market price found. All row related this information would be red in color.
   We use simple formula here i.e.
   (Trade qty * market rate = contract value) minus (trade qty * market rate = contract value)
   of of
   Client Exchange or Broker
   The reconciliation will be zero.
10. Trade Confirmation
    We can provide trade confirmation of all contracts to the clients to have documentary proof for the same. It will provide all trades having qty, trade price of all commodities with carry forward or brought forward position of all clients. Either you email or print or view trade information or can make file for branch clients
11. Brokerage Recalculation
    To implement brokerage on trades done by the client we have to run Brokerage Recalculation option. This option will recalculate the brokerage define in Brokerage Slab of client.
12. Client Day Obligation with MTM
    With the option of client day obligation with MTM we can provide an obligation report on daily basis if required. It will show client wise position having brought or carry forward from previous day, current days buy and sell qty with value and net position with profit and loss of each client.
13. Export CTCL Interface for FT/NSEIT
    From this option user can send client’s information like it’s fund margin, financial ledger balance, client’s open position trades up to given trade date, running margin balance of client’s all these information can send to CTCL for client’s back office information. These information can be send in FT or NSEIT format. User can send information about share’s valuation with stock value’s variances. User can select all these information for NCDEX or MCX too. By generating this file send to CTCL.
14. Export for Asian-CRC
15. Day Book
    Detailed daybook report can be viewed through this option like this.
16. Day Book Summary
    Summarized daybook report can be generated through with profit or loss of each clients the same option.
17. Day Summary with MTM
18. Trade Analysis
19. Contracts
    User can get all the contract details with this option.
20. Contracts(Date Range)
21. Contracts Cum Bill
22. Contract Notes(HTML)
    In HTML format user can send contract note digitally signed by generating from contract options.
23. Contract Issued Register
24. Turnover
    User can get their daily turnover of all clients with this option. User can also show turnover with or without market price.
25. Brokerage Statement
    User can get daily brokerage statement to know the details of brokerage on every trade or client. This will also show specific client’s brokerage and its turnover of all commodity or specific commodity, any branch client details of given date. It will also show total company’s brokerage in details.
26. Position Reconciliation
27. Trade Editing Order Wise

Top

### Processing

1. When user click on the Processing menu, following drop-down list will open
2. MTM Posting-Daily Daily MTM bills option will post all the trades in related client financial accounts. It will close out trades with closing rate and will post net debit or credit in client accounts. If you find any differences in client’s ledgers you can delete MTM bill at using same options.
3. MTM Posting(Daily+Exp.Day)
4. MTM Payin/Payout(Date Range)
   MTM bills with date range are generated with this option. If a Main Broker or sub Broker required to generate bills from one date to another (in date range), he will have to define the periodical billing future (Y) in Utility/ System File Maintenance option; otherwise to get the daily bills we have to define N in periodical billing future option. With this option your MTM will not match with exchange payout because Exchange calculates payout on daily basis calculating exposure with closing price.
5. MTM Posting-Daily(On Expiry Day)
   We will have run this option only on expiry date to transfer the entire pending quantity and bill post separate bill in client’s accounts. The expiry of NCDEX and MCX differ each other, so user have to take care of about this options.
6. MTM Posting-Cuml. System
   With this options user can generate bill to given trade date from reversal date. This option gets outstanding positions from reversal date. With this option your MTM will not match with exchange payout because Exchange calculates payout on daily basis calculating exposure with closing price.
7. Final Expiry Billing
   By this option user can generate one bill on expiry day means monthly expiry billings. With this option your MTM will not match with exchange payout because Exchange calculates payout on daily basis calculating exposure with closing price.
8. MTM Posting-Daily(Date Range)
   From this options user can generate MTM bill or delete MTM bill. This option is very fast MTM bill deletion and generation options, user can delete MTM bills between the two given trade date range within 5 minutes; either one week or one month or one year. Example: Suppose user want to change transaction of one client traded done on 1st, April and today date is 10th may, then he will delete MTM bill of aprox.30 days. And I think it will take half an hour to delete and reprocess. But by this option you can delete within one minutes and change position and regenerate bill within 5 minutes. This option will not delete Expiry bills if using above condition please delete expiry bill separately.

Top

### Bills

1. When user click on the Bills menu, following drop-down list will open
2. Daily MTM Bills
   By making daily MTM bill user can print all client bill of particular trade date or selective clients, which is posted in financial, accounts. Either you view or send email or create text file of separate clients
3. Daily MTM Bills(Daily + Exp. Day MTM)
4. MTM Bills-Date Range
   If we define periodical billing option Yes in Utility option “System file Maintenance” option software will allow us to print the bill of selective date range, other wise generate bills on daily basis.
5. MTM/Diff bills-Expiry Day
   This process will print expiry bill only on expiry day. By this options user can print expiry bill that is processed at the end of expiry date.
6. Final future-Expiry Bills
   This option will print expiry bill on expiry billing system.
7. Combined Contract Bill
   To print all bill from specified range date This options prints all bill from given date range from and to. The user can print all bill or email or view of a particular client or all clients, or can generate text file for Branch.
8. Bill Summary(Date Range)
   In this options user either can view or print: daily MTM bills or daily MTM-Cumlv. System bills or final expiry bill (future) or daily MTM bill of expiry day. Please select one option at a time.

Top

### Delivery/Stock

1. Delivery option
   Here user can maintain delivery of Off Market or Market. Exchange NCDEX provides delivery’s file that contains client delivery name you just import this file from import options and process here in delivery options. When user click on the Delivery/stock menu,following drop-down list will open
2. Manual Delivery Entry/Edit(Mkt.Delv.)
   If you do not have delivery file for import use this options to add delivery. In this options user can add delivery name done through Exchange and save. It will post automatically in client’s accounts. First input expiry date, delivery date, and posting date and press show button. Than add delivery name and save. This is toggle option user can delete delivery and while saving it will delete delivery posting from financial.
3. ManualDelivery Entry/Edit(Off Mkt.Delv.)
   In this option user can add delivery name having off market delivery of client, or client to client or any exchange or warehouse delivery. Put 'C' in tag coloumn for client to client
4. Delivery Obligation Posting(NCDEX)
   In this option user can post Exchange delivery payin / payout into exchange clearing bank. From this options user can delete exchange delivery pay in / payout also.
5. Delivery/Short Delivery Entry/Edit(NCDEX)
   User can show imported delivery files from IMPORT options and define client code and save to post in client accounts. If user want to delete delivery posting from accounts; first put delivery date and click on enable edit/delete when click on row then save. It will delete delivery entry from financial ledger. User can impose sale tax and brokerage or PREM /discount on bills too.
   Delivery report date: Insert delivery imported date.
   Delivery (recd. Or Delvrd): Select one at a time and press show button.
   Balance Qty.: Insert quantity.
   Client code: Select client code to whom is associated for delivery.
   Sale tax form: Select sale tax form type.
   Sale tax (%): Type sale tax percentage if any.
   Delivery Date: Select delivery date for financial posting.
   Quantity Delv/Recvd: Type exact quantity of client.
   Prem./discount price per Qty.: Add discount quantity if any.
   Brokerage : Insert brokerage percentage if charging brokerage on delivery.
   Service tax: Tick here for service tax posing too.
   Our Ref. No: Type reference no. if any.
   And press SAVE to save all the information.
6. Delivery Bill
   User can print, view or email delivery bills from this option.
7. Client Opening Stock Entry/Edit
   User can insert opening stocks with value price of all commodities from this option.
   Expiry date: Select expiry date
   Opening date: Select opening date.
   Contract: Select commodity items for.
   Press (+) sign for new entry.
   Then insert client code, quantity and opening price; then save.
8. Stock Ledger Query
   User can get commodity wise client wise information about the stock with the information Date, recd. Quantity, Debit, delivered Quantity, Credit Closing Quantity with Closing Balances.
9. Stock Ledger Printing
   Stock ledger printing option will allow us to print the same information given in stock ledger.
10. Stock Statement
    This report will print all opening stock of client’s, and with commodity wise.

Top

### Reports

1. In this option user can view or print or mail client’s client wise net position, client wise portfolio, daily MTM summary, payment control report and client wise net position on actual basis i.e. When user click on the Reports menu,following drop-down list will open.
2. Client Wise Portfolio
   Here user can see client wise portfolio either sell or purchase (only outstanding qty.) of all commodity and their exposure (qty*given closing rate) with expiry wise. User can view this report of all exchange or selective exchange or all branch.
   User can view or print or create text file for branch.
   Business Date: Insert Correct Business date
   Closing price date: Insert closing price date for viewing commodity exposures.
3. Clinet Wise Net position
   Date Selection: Select as on date or Date Range (by default as on date).
   Business date: Type business date or (in range)
   Closing Price date: Type current closing price date.
   Expiry date: Select Expiry date to view particular expiry data.
   Client From Client to: Type client code or select client range.
   Group Client: Select particular group in case of showing particular group data.
   Symbol: Select specific symbol if showing specific symbol data.
   A/C Group: Select to show for particular group data.
   Include BF/CF: Tick if showing BF or CF Transaction in case of date range and want to see Marked to Market.
   Fin. Ledger printing req.: Tick here if want to show financial balance of all clients on net position.
   Move to group folder: Tick to send report to specific client’s folder.
   Send Mail: Tick and press Email Button to email report to clients.
   Bf (1st date): Tick here if want to view data of given date range.
   Position of Mkt. Rate: ` Tick if you want to view data on market rate basis but by default it Will shows data on net rate basis.
   Report on Client Code/org. Client Code: To view data on actual code basis as that code in which traded done On Terminal.
   Ignore Net Qty.=0 Case: Tick here to view only outstanding position.
   Symbol wise (All client Together): Tick here to view data commodity wise not client wise.
   Combined Report (all Exchange): Tick here to view data of all exchange.
   User can show client wise net position having sell or purchase qty, sale value or purchase value, (with net rate or market rate) and net outstanding qty. up to date with value at average price.
   User can show all net position of given date range.
   User can show all commodity or specific as required.
   User can show all net position of particular group or branch wise. User either email or view or print or make text file.
   This position show exposure calculating net position qty. multiplied by given closing price date. It also shows net profit/loss of client and commodity wise.
   User can show financial balance with net position simple (ticking financial ledger printing required.)
4. Client Wise Net Position(Actual Basis)
   In this options user can view all report describe above in (client wise net position). But this report is slightly different from client wise net position; i.e.
   Client selection: Select all for all client or select range or selective client.
   Client group: Select for particular client group in case of showing particular group data.
   Branch: Select branch if (the data is on branch system)
   Date Selection: Select as on date or Date Range (by default as on date).
   Closing Price date: Type current closing price date.
   Expiry date (optional): Select Expiry date to view particular expiry data.
   Symbol: Select specific symbol if showing specific symbol data.
   Position of Mkt. Rate: Tick if you want to view data on market rate basis but by default it Will shows data on net rate basis.
   Example:
   Here Arvinder Singh purchase commodity CHARJDDEL of expiry (20-06-2006) purchases qty 700 ton and sell 900 ton at different rates. And last closing price is 2068.00
   This report give out information like
Above information shows us that client square up qty of 700 tons (means 700 ton buy and 700 ton sell) and its outstanding 200-ton extra sold.
It show 700 buy value minus 700 sell value=actual profit or loss and It again show outstanding 200 sold value at average price and calculates profit or loss at closing price as per given date.
At last it sums both actual profit/loss jobbing with outstanding (with closing price) profit/loss giving Net Amount with adjusting transaction fee, service tax on brokerage and service tax on transactions fee etc.
Actually it gives output as what you buy or sell in FIFO basis and shows separate outstanding position.
5. Client Wise Detail MTM Statement/Summary
   User can view information about opening positions including long or short, net traded value of given transaction date, its MTM value, and finally its actual net profit/loss or particular client or all client with selective contract or all contract.In this summary option shows only net debit or net credit of all client or selective client of given transaction date.
6. Days Net Dr/Cr summary
   This report will give you information about all client net MTM profit/loss of particular date range with control accounts.When user click on particular rows it show margin status, stamp duty, MTM profit/loss, and if at expiry date it shows expiry bills too.User can view or print this information of a particular client or group as per given date range.
7. Payment Control Report
   Margin date: Type Margin Date.
   Previous Margin date: It will automatically appear.
   Financial as On: Type financial date to print financial balance up to this date of client
   A/c Group: Select for any particular group.
   Client code: Type client code for particular client data.
   Group client: Select for particular group only.
   Monetary Unit: Type number to decrease values.
   Financial Breakup: To separate vouchers and MTM bills.
   This report gives you information about net financial balance (which having MTM bill + vouchers entry + expiry bills + delivery positions etc.), and client’s margin imposed by exchange, cash fund received against margin from client if any, and net final balance after (adjusting with net financial balance and margin balance). This option has facility of monetary unit so that you can control larger amount. In this option user can view or print report of particular client or particular group. And if clicked on financial breakup it shows net MTM amount and voucher separately.This option has no emailing facility because it is MIS report of company not for client.
8. Payment Control Report(New)
   In this options user can print this report of all exchange or selective exchange.
   Trade date: Type Margin Date.
   Financial as On: Type financial date to print financial balance up to this date of client
   A/c Group: Select for any particular group.
   Client code: Type client code for particular client data.
   Group client: Select for particular group only.
   Report Sequence: Select for report sequence.
   Financial Breakup: To separate vouchers and MTM bills.
   Combined Reports(all Exchange): Tick to view report of all exchange.
   In this options this reports also gives you information about net financial balance (which having MTM bill + vouchers entry + expiry bills + delivery positions etc.), and margin imposed by exchange to client, cash fund (received against margin from client if any), and if clicked on financial breakup it show net MTM amount and voucher separately, and if cash margin is less than initial margin (imposed by exchange) it will show required amount in initial margin shortage.This options shows given trade date total turnover (means days total purchase value + days total sell value), and up to given trade date total exposure value means (total outstanding qty of commodity*current closing rate) too.This option also shows you marked to market (MTM) value of current date, which is already included in financial balances, and today’s trade net brokerage earned from client. In this option user can view or print report of particular client or particular group. And if clicked on financial breakup it shows net MTM amount and voucher separately.This option has no emailing facility because it is MIS report of company and not for client.
9. Statement(Without Carryover)
10. Original client Code Printing
    In this report user can see report having mismatch original client with traded client code, or if ticked on transaction value exceed 1 laces, or missing PAN no. Clients of given date range. User can view this report branch or client’s wise separately.
11. A/C opening Analysis
12. Feasibility Report
13. Portfolio Tracker

Top

### Margins

1. This option shows details about margin.When user click on the Margins menu, following drop-down list will open
Note: Select one procedure for margin posing.
2. Exch.Margin File Edit
   In this option user will edit margin imported (MG13) from IMPORT options. User can correct client’s code or put pro client code whenever required.
3. Exch. Adln Margin Edit
   In this option user can edit margin additional imported (MG12) from IMPORT options. User can correct client’s code or put pro client code whenever required
4. Margin Posting
   Margin Type: Select margin type as
   : Select MG13 for margin (as per exchange imported file)
   : Select GE13 for Exposure type margin posting
   : Select SH13 for Span (Span calculated by client)
   : Select ADLN for additional margin
   Current Margin Posting date: Select current date for margin.
   Reversal Of Margin Date: It will automatically appear (the date in which margin will be reversed).
   Margin Control Code: Will automatically appear (if defined at system file maintenance).
   In this option user (if wants) can post margins (MG13) to client’s accounts to maintain margin accounts. First put current margin posting date and reversal margin date will automatically appear. It debits client’s account and credit’s margin control’s account i.e. like (EMARG) here. Systematically previous margin’s releases and new margin debits in client’s account. User can delete by clicking on (Delete Only) then click on proceed.
5. Client Margin Export to Exchange
   User can edit margin and then export margins to exchange as per their requirement. Before export confirm margin’s export parameters from exchange’s circular. Currently Exchange is not accepting any margin file from broker.
6. Position file export For SPAN
   From this options user can export margin to exchange but exchange is not required yet. So export margin currently not applicable.
7. Security Deposity Posting
8. Span

1. Calculator
   From this option user can hash their position by putting their temporary transaction; calculates position for margin. For this process first of all import risk parameter file (nsccl_ncdex.20060616.s.spn) from IMPORT option and then import exposure margin (MG12) from IMPORT. Then put your position as commodity name, expiry date, net qty sell or purchase and then calculate.
2. Margin Requirement
   In this option user can see span margin like (MG13) in case of absence of MG13 file. Especially this is for sub broker who cannot get MG13 and wish to calculate margin (span) like exchange then he can do following step
   1. IMPORT risk parameter file like (nsccl_ncdex.20060616.s.spn) daily from IMPORT option.
   2. IMPORT exposure margin (MG12) from IMPORT or edit this in EXPOSURE MARGIN (%) ENTRY/EDIT option.
   3. Then put date in position up to and show. This will show span margin and exposure margin as per exchange requirement and if you want to post in client’s account then save by clicking on Plus sign. Then select SH13 from MARGIN POSTING option and put margin date and proceed. User can show margin here either client wise or client instrument wise.

9. Exposure Margin(%) Entry/Edit
   If not available Exposure margin (MG12) file then user can update exposure margin % here manually time to time as per exchange’s circular.

- Gross Exposure Margin (Portfolio Basis)
  In this option user can view exposure margin (particular fixed % margin) of total exposure. Users have to follow these steps.
  1. First go to MASTER / MARGIN & TRANSACTION FEE option.
  2. Set exposure margin % in REGULAR GROSS EXPOSURE MARGIN %.
  3. User can set exposure margin % either client wise or commodity wise or client/commodity wise.
  4. User can set exposure margin % date range wise too.
  5. Import closing rate from IMPORT / DAILY CLOSING PRICE options. And in case of already imported closing rate then need not to import closing rate again.
  6. Then go to MARGIN and GROSS EXPOSURE MARGIN (PORTFOLIO BASIS).
  7. Set business date as trade date.
  8. Set current closing rate date and view.
  9. You will show here exposure value and it’s %age margin value. If users want to post in client’s accounts then press button (CREATE GE RECORD FOR POSTING).
  10. If wishing to post margin in client accounts then go to MARGIN / MARGIN POSITING.
  11. Select margin type as GE13 then insert correct date and post it.
- Margin Status Report(Date Range)
- Stock (Cap.Mkt)
  This is for capital market scrip maintenance. User can create scrip name and if wants to open with files, import CPRACT.CSV (this is available at National Stock Exchange).

1. Scrip Master
   Create here scrip code and name to open scrip (share) name.
   Click on Create/Update Scrip(CPRACT File) to import scrip from file, following window will open:
   If want to open share code and name with file, so obtain CPRACT.CSV from NSE broker.
2. Stock Entry/Modification
   Here user can add or delete manual shares for security deposit stock entry.
3. Closing Rate Import
   This is the option where user can import cash market closing rate file (MD FILE) to find out stock valuations.
4. Stock Valuation
   In this option user can show their stock, valuation price (closing stock *closing rate), and if giving variance % it will show variance % of total stock value.User can set variance either of stock wise or client wise.

Top

### Financial

1. This is most important option of software FINANCIAL ACCOUNTING. Here user can insert vouchers, see firm’s cash book, bank book, journals, trial balance, service tax report, introducer calculation system, interest calculation facility, balance sheet, bank reconciliation, profit & loss statements etc.When user click on the Financial menu, following drop-down list will open
2. Voucher Entry/Amendments
   This is the option where user can add or delete vouchers. User can edit voucher’s here.
   User can add new client code and name or add new balance sheet code (like expenses, assets, liabilities, revenue etc.) from this options also.
   Example:
   Voucher Type: Select voucher type
   Voucher date: Type voucher date
   Voucher No.: Type voucher no. if any or it will generate automatically.
   Branch: Select Branch if voucher entry branch wise.
   Bank/Cash Code: Then select its correspondent bank or cash book
   Click on new row button.
   Then type client code and narrations and cheque no. Then amount. When you save it; it will automatically insert its contra entry in bank or cash account. User can delete voucher from this option. When user select vouchers (simple by typing voucher date and click on show button) then deletion cross symbol will appear and it becomes red in color. This means that, this voucher is ready for deletion mode. And when you will click on it, this voucher will be deleted. User can insert vouchers branch wise also.
3. Voucher Verify/Release
4. Voucher Printing
   User can print voucher from this option’s. Either select on voucher or select all vouchers for print or view. Voucher print sequence will be either date wise or entry wise as per user requirement.
5. Cheque Printing
6. Brokerage A/c Creation
   1. From this option user can transfer brokerage from brokerage difference account (profit account) to brokerage account. Basically all brokerage and profits (means rate difference either by mistake or...) shows in brokerage difference (net profit) accounts. And if you want to show total brokerage (earn from client and paid to broker) from this account, you will have to transfer brokerage from brokerage difference (profit) account to new brokerage account.And after then, the brokerage difference account (net profit account) will be either zero or some rate difference (means profit.
   2. User can reconcile it.
   3. User can remove transferred brokerage from this option too.
7. Brokerage Scheme Posting
8. Expenses Posting in Client A/cs
9. Introducer Commission Calculation/Report
   From this option user can calculate introducer (%)age brokerage. In this case first user have to define introducer code and its percentage client master. Then come in FINANCIAL /INTRODUCER COMMISSION REPORT. User can either view or post (introducer commission) in client accounts. This is toggle key options by this user can delete posting from here too by simple clicking on (delete only) and click on FA Posting.
10. Interest on Debit/credit Balances

1. Posting in Client Account
   From this option user can calculate interest rate on its financial debit balance. First define interest rate in CLIENT MASTER then go to FINANCIAL / INTEREST CALCULATION POSTING option. And put from to date range and proceed. This is toggle key options by this user can delete posting from here too by simple clicking on (delete only) and click on PROCEED.
2. Interest Calculation Statement
   From this option user can view or print interest calculated report of client.

11. Bank Reconciliation

1. Bank Reconciliation(old)
   From here user can reconcile bank statement by adding realization date. User can show Un cleared debit or credits also. User can view reports either realization date wise or as per financial posting date wise too.
2. Bank Transaction File Import(New)
3. Bank Reconciliation Report(New)
Click On view to view/print report. Report (as shown below) will open
4. Opening Entry(New)

12. Cash Book
    From this options user can print or view cash book related entry. User can print combined exchange cash book also.
13. Bank Book
    From this options user can print or view bankbook related entry. User can print combined exchange bank book also. User can view one bank’s related entry at a time.
14. Journal
    From this options user can view or print journal voucher related entry.
15. Financial Ledger
    From this options user can print, view or email financial statement of client. User can print of all clients or selective or client’s range. User can print all ledgers of specific branch too. By this options user can print client’s control accounts like margin and security (cash fund) accounts too. User can send email of client ledger or make text file too. User can print or view combined exchange ledger too.
16. Debtor/creditor List
    As on date: Type Financial date here.
    Account Group: Select account group or leave as it is.
    Client A/c Only: Select here for all client or particular group.
    Combined Report (all Exchange: Tick here for combined exchange data.
    Merge All Related A/c BalanceTick here for all sub a/c merge data in main account.
    Then select code wise, name wise or group code wise.
    From this options user can print or view debtor/creditors list of all client or particular account group.
    User can print or view all with all exchange report too.
    User can print or view or make file of particular branch.
17. Service Tax/Stamp Register
    User can print service tax register and with it’s related brokerage. User can print either receivable account or payable account at a time. User can print or view of specific client’s service tax too.
18. Form ST-3
    From this option user can view or print FORM ST-3 of service tax register which having details of service tax.
19. Trail Balance
    Trial type: Select trial type
    As on date: Select as on date
    Sub Group: Select if for any sub group printing.
    Branch Selection: Select branch for specific branch trial balance.
    Report type: Select any report type
    Opening Balance Trial only: Select ‘Y’ for opening trial balance else type ‘N’.
    Print of nil account required. Tick for nil account balance required.
    Multi Exchange Trial Balance: Tick here for multi exchange trial balance.
    User can view only opening trial balance too.
    User can view date range trial balance.
    See details before printing trial balance.
20. Profit/Loss statement
    From this options user can view firm’s profit or loss statement as on given date.
21. Branch Wise PL Statements
22. Balance Sheet
    User can view or print balance sheet from this option. User can view balance sheet of all exchange too. For more details contact your Chartered Accountant.
23. Ageing Report
    From this option user can view those client who have minimum balance (as given in box).
24. Balance Confirmation Letter
25. Turnover/Brokerage Costing Report
    From this option user can view total turnover of all clients and it’s brokerage. User can view reports all exchange either NCDEX or MCX. User can view reports of all clients or particular client or particular group too. While selecting Report type as Date Wise it will show all clients turnover and brokerage with date wise; and Report Type as Summary it will show total turnover and brokerage client wise. User can view report of all branch or particular branch. Please change monetary unit as per your requirement.
26. Other Charges Posting
27. Financial posting with Open Position

Top

### Backup

1. When user click on the Backup menu,following drop-down list will open
2. BackUp of Database
   From this options user can take data backup. Other than back office software backup facility, we suggest that you must have one or two sets of backup on any other media i.e. ZIP Media, CD.

Top

### Utility

1. This is utility option where user can delete wrong transactions, create/update balance, change user password, or set user’s security system , merge client accounts etc. It is recommended to use this option after consulting SCL SUPPORT. When user click on the Utility menu,following drop-down list will open
2. System Utilities

1. System File Maintenance
2. Security System
   From this options admin user can set security system. Admin user can set permission to specific user for any option either add or delete or view or process. Admin user can set full lock mode of any options to any user.
3. Query Analyzer
   This option is for running SQL queries to find out specific result. This is specially run by SCL SUPPORT STAFF only. User can use this option on advice of SCL SUPPORT STAFF.
4. PLB Maintenance Utility
   using this option user can download coshilpi.plb from shilpi site(www.shilpisoft.com) without opening site.
When user click on download latest pbl,following window will open with a message.If you want to download then clieck on 'yes'otherwise on 'no' button.
5. Download License File(licclient.exe)
   Using this option license file can be downloaded form shilpi site(www.shilpisoft.com) without opening site.
6. Database Backup
7. Download Costumized Report File(qrp)
8. Upload file for Support
9. Download file from Support
10. Web Live Setup

1. I-Net Users Maintenance
2. I-Net Users Cross Reference
3. Database Attach(parent)
4. Database Configuration
5. Auto update common User

3. Change Password
   At here user can set his own password.
4. Data Conversion(MCX Lot Tradeing)

1. Update code
2. Symbol Close
3. External Export

1. Export Trade In txt Format
2. Export Party Master(code,name,email)
3. Export For Portfolio Tracker
4. Export For SMS
5. Export For CRM

4. Contra Trade Generation
5. Branch Allocation to Clients
   This is for branch allocation to all clients.
6. User login Creation/Deletion
   From this options admin user can create user id, user name and it’s password. Admin user can also delete wrong user id.
7. Transaction Deletion
   From this option user can delete wrong trades of particular trade date. And after then re-import from import options
8. Contract Deletion
   If your contract number is mismatch then user can delete contract number on and after this date. And regenerate contract number from contract menu.
9. Client Account Merging
   This is very critical option. From here user can merge client code from old client code to new client code. User can opt either full merging or date range merging. It is strictly recommended to take backup before run this option; there is no data recovery at wrong merging condition. If possible call SCL SUPPORT before run this option.
10. Update Parent code in Related Accounts
11. Disable clients No. trxn in 6 Months
12. Days Task Completing status
    This option shows your daily task completion status. It updates (ok) whatever options you have run of particular date as shown above.
13. Reconfigure Database
    Don’t run this option; please call SCL SUPPORT.
14. Create/Uodate Balances
    This options updates account’s balances of all clients. It is recommended to run this option when a/c balances not showing properly in trial balance or debtor/creditor list.
15. Balance Carry forward
16. Financial Adjustment Across Exchange
17. Digital Signed Log
18. Delete Digital Log
19. Bounce Mail Scanning
20. System Log
21. Position Export
22. Updates S.Tax on Turn.Tax Record
23. Voucher Audits

Top

### Shortcut Keys

- User can use shortcuts for fast access, following shortcuts are available

Top

### Account Open

- How to open the following:
Account
Branch
Region
Client
RM/TL Master
- How to define the following:
Brokerage
Scrip
Transaction Tax
Stamp Duty

#### Open Account

- Go to Master >> Unique Client Information
- Fill all details in this form and click on save.
- UCI Import from Capital Database : Select client code from this window and now save this code for commodity.
- Export: This option is used to make export file which is required by exchange

#### Open Branch

Go to Master>>Branch (Location) Master Creation/Modification.
Fill all details and click on save.

#### Open Region

Go to Master >> RM/TL Master

#### Open Client account

Go to Master >> Client Master
Default Value Fixer
Brokerage
Printing
Print Tag
Bank Details
Scheme Entry/Modify
Customer Signature and photo

#### Open RM/TL Master

#### Define Brokerage

1. For percentage basis:

1. Go to masters >> Client Master Entry >> Define Introduce percentage
2. It will open the following window. Define Brokerage on percentage basis here and save the settings.

Brokerage Schedule can be defined in the following ways:
- Client wise -(Means create all client’s brokerage separately using this method) It means that if you have 100 clients then you have to create brokerage hundred times.
- Slab ID -(Means you can define slab id system and then select the slab id provided in Client Master; it means that you create slab1 for .5%, slab2 for .3%, slab3 for .4%.And select this slab id from Client Master.
- Common - Means if user will define brokerage here then it will be applicable to all client’s having without brokerage; and (in this case User will not have to define all clients’ brokerage.)

- For percentage basis :

1. Go to Masters >> Brokerage Master >> Speedup
2. Define fixed and min brokerage for different settlement type (NN-Normal, NW-Trade for Trade, NA-Auction) and save it.

#### Define Transaction Tax

Go to master >> Margin and Transaction Fee. Using this option user can define transaction tax client wise or by default.

#### Define Stamp Duty

Go to Master>>State Master. Using this option user can define Stamp Duty client wise or by default.

Top

## Daily Processing

- For NCDEX
- For MCX

### Daily Processing for NCDEX Exchange

1. Before using COMMEX Take Online Backup of the following files from Main Terminal or from FTP :

1. TRADECOM.TXT(on SINGLE TERMINAL: trade file for sub broker)
2. Ncdex_tr01_ddmmyyyy.csv (on FTP: trades file for member only)
   ddmmyyyy_memberid.txt (on FTP: trades file for member only)
   Both files having multiple terminal id’s trades).
3. ncdex_cn01_ddmmyyyy.csv (on FTP: closing rate file for sub broker or Main broker)
4. nsccl_ncdex_ddmmyyyy.s.spn (on FTP: span margin file for sub broker or Main broker) (if user want to calculate span margin)
5. ncdex_mg13_memberid_ddmmyyyy.lis (on FTP: margin file only for Member) (not for sub broker only for main broker)
6. ncdex_ss06_memberid_ryyyymmdd.csv (on FTP: delivery file only for Member)
7. ncdex_cn01_ddmmyyyy.csv (on FTP: contract recreation file)

Note: Copy all these file in data file folder to pick it by default. After downloading these files from ftp or from terminal please follow the steps described below.

2. Go to Import menu

1. Select Contract Specification file:(This is complusory for Main Broker and Sub-Broker), To add commodities and its contract schedule.No need to remember the file names.

- Daily Closing Price(This is complusory for Main Broker and Sub-Broker),
  User have to import daily closing price into Back-Office software on daily basis.
- Order File (Compulsory for Main Broker and Sub broker)
  If the sub broker or client is using REMARK field on front office for client code and wish to transfer trades automatically in actual client accounts.If not using remark ignore to import this file.
- Daily Trades
  Whatever trades we do on front office terminal daily, goes in to trade file folder in front office and we have to import it into our back office software for further process. The file named Tradecom.txt contains all the trades done on front office terminal
- Margin File Import (Compulsory for Main Broker)
  For client’s margin imposed by exchange we have to import margin file from exchange’s FTP system. This is for main broker named MG13 file
- Position File Import (Optional only for Main Brokers)
  This file is to compare the trades done by a client in different codes verses exchange. Basically to find differences between exchange position and our exchange trades.
- Risk Parameter File for Span(NCDEX)
  (Compulsory for sub broker for span margin posting or for main broker for live span calculation.) To calculate risk margin on trades, software has a facility to calculate risk margin on trades done by client specially for LIVE SPAN Margin.
- Delivery File Import(SS06): (Compulsory for main broker if participating in delivery with exchange) NCDEX provides delivery file named “ncdex_ss06_00537_R20060206.csv”, delivery done by clients.
If you wants to delete previous imported file then do the following as shown below:
- Go to Report Menu

1. Select Client wise Net Position
   After importing trades check client wise net position either as on date or date range of all clients.
2. Client Wise Portfolio
   Note: If all client wise net position or client wise report folio reports is ok then go to PROCESSING or If client wise net position miss match then go to DAILY option.
   IF POSITION MISS MATCHED then
3. Go to Daily option

1. Select Trades Entry/Modify
   Trades Entry / Modify option will allow us to enter new trades or modify daily trades.
   Note: Again check client wise net position from REPORTS option and be sure for position.

- Go to Processing option

1. MTM Posting Daily
   Daily MTM bills option will post all the trades in related client financial accounts.
   It will close out trades with closing rate and will post net debit or credit in client accounts. If you find any differences in client’s ledgers you can delete MTM bill at using same options.
   Note: On Expiry date run below option too.
2. MTM Posting Daily(on Expiry Day)
   We will have run this option only on expiry date to transfer the entire pending quantity and will post separate bill in client’s accounts.

- For Members

1. Go to Margin option
2. Select Exchange Margin File Edit
3. Margin Posting
   In this option user (if wants) can post margins (MG13) to client’s accounts to maintain margin accounts.

- For sub-Brokers(Span+Exposure wise-Margin)

1. Import exposure margin(MG12) file from Import>>Exposure Margin
OR
For Exposure Margin Manual edit
Go to MARGIN>>SPAN>>EXPOSURE MARGIN (%) ENTRY EDIT
Insert here exposure (%) as per exchange’s circular and update it time to time.

- Import risk parameter file (S.SPN) from IMPORT>>RISK PARAMETER FILE FOR SPAN (NCDEX)
- Go To MARGIN>>SPAN>>MARGIN REQUIREMENT
- Margin Posting
  In this option user (if wants) can post margins (SH13) to client’s accounts to maintain margin accounts.
- Exposure wise-Margin
  Go to MASTER>>Margin & Transaction Fees
  1. Put here exposure margin (%) of SYMBOL either client wiser or default.
  2. Set exposure margin % in REGULAR GROSS EXPOSURE MARGIN %.
  3. User can set exposure margin % either client wise or commodity wise or client/commodity wise.
  4. User can set exposure margin % date range wise too.
  5. Import closing rate from IMPORT / DAILY CLOSING PRICE options. And in case of already imported closing rate then need not to import closing rate again.
- Go to Margin>>Gross Exposure Margin (Portfolio Basis)
  In this option user can view exposure margin (particular fixed % margin) of total exposure. If he wants to post in client’s accounts then press button named : Create GE Record For Posting.
- Margin Posting
  In this option user (if wants) can post margins (GE13) to client’s accounts to maintain margin accounts.
- Delivery (FOR NCDEX MAIN BROKER)
  1. Go to Import>>Delivery File Import(SS06).
- DELIVERY OBLIGATION POSTING (NCDEX)
  Go to DELIVERY/Stock >> DELIVERY OBLIGATION POSTING (NCDEX).
- Delivery(FOR NCDEX Sub-Brokers Only)
  Go to Delivery/Stock>>Manual Delivery Entry-Edit (Off Market Delivery) Expiry date: Put expiry date Delivery date: Put delivery date (same as expiry date) FA posting date:Put financial posting date And Press Show Again press (+) Sign to add delivery name. Insert all details like client code, contracts name, quantity, delivery price etc. And press SAVE
  Note: NCDEX does not provide any delivery name for sub broker
  Note: In case of Sub Broker:
  In case of sub broker system will automatically post contra delivery amount in broker’s account which is defined in System File Maintenance. In case of Client to Client Delivery Either (MAIN BROKER or SUB BROKER): In this case user will have to put ‘C’ in tag column and insert separate contra delivery of client.
- Financail Accounting Go to Financial>>Voucher Entry Amendments Insert vouchers (Bank or Cash payment or receipt or Journal) here. For details about vouchers please refer our COMMEX MANUAL.
- REPORTS can be viewed on daily basis are as given below:
  1. All reports from REPORTS; specially CLIENT WISE NET POSITION or CLIENT WISE PORTFOLIO CLIENT WISE NET POSITION (ACTUAL BASIS) PAYMENT CONTROL REPORT PAYMENT CONTROL REPORTS (NEW).
  2. All reports from FINANCIALS; specially TRIAL BALANCE DBITOR/CREDITER LIST FINANCIAL LEDGERS etc.
  3. All reports from DAILY; specially USERID WISE SUMMARY FOR THE DAY TRADES CONFIRMATION TURNOVER BROKERGE STATEMENT
  4. All reports from BILLS Options in case of bill requirement for clients DAILY MTM BILLS MTM DIFF. BILLS – ON EXPIRY DAY COMBINED CONTRACTS BILLS
  Note:And print or view as your requirement. Print bill from BILLS Options in case of bill requirement for clients. For more detail about options described above please refer COMMEX manuals.
  Top

  ### Dialy Processing for MCX Exchange

  Note: First of all create client code, client’s detail and it’s brokerage from MASTER then follow these step
  1. Before using COMMEX Take Online Backup files from Main Terminal or from FTP :
  1. DDMMTRD.TXT(0712TRD.TXT): (on SINGLE TERMINAL: trade file for sub broker)
  2. ORDERCOM.TXT: (on SINGLE TERMINAL: remark file for sub broker) Note:Import it if using client code at REMARK column. Both are for sub broker and single terminal id’s trades. Or Trdyyyymmdd.txt: (on FTP: trades file for member only) (The trade files having multiple terminal id’s trades).
  3. Bcyyyymmdd.csv: (on FTP: closing rate file for sub broker or Main broker)
  4. Margin_memberid_yyyymmdd.csv: (on FTP: margin file only for Member) (not available for sub broker only for main broker)
  5. ContractMaster.csv: (on FTP: contract recreation file)
  Note:Copy all these file in data file folder to pick it by default. After downloading these files from ftp or from terminal please follow these steps described below.
- Contract Specification File (Compulsory for Main Broker and Sub broker) Go to Import Menu and select Contract Specification File To add commodities and its contract schedule. User need not remember this file.
- Daily closing Price (Compulsory for Main Broker and Sub broker) We have to import daily closing price into back office software on daily basis.
- Order File (Compulsory for Main Broker and Sub broker) If the sub broker or client is using REMARK field on front office for client code and wish to transfer trades automatically in actual client accounts. If not using remark ignore to import this file.
- Daily Trades Whatever trades we do on front office terminal daily, goes in to trade file folder in front office and we have to import it into our back office software for further process. The file named ddmmtrd.txt contains all the trades done on front office terminal
  1. DDMMTRD.TXT(0712TRD.TXT) (on SINGLE TERMINAL: trade file for sub broker)
  2. ORDERCOM.TXT (on SINGLE TERMINAL: remark file for sub broker) Note:Import it if using client code at REMARK column.) Both are for sub broker and single terminal id’s trades. Or Trdyyyymmdd.txt (on FTP: trades file for member only) (The trade files having multiple terminal id’s trades).
- Margin File IMport (Compulsory for Main Broker) For client’s margin imposed by exchange we have to import margin file from exchange’s FTP system. This is for main broker named MARGIN file.
- Client Wise Net Position(MCX) Go to Reports and select client Wise Net Position After importing trades check client wise net position either as on date or date range of all clients. Date Selection: Select AS ON DATE or DATE RANGE. Business Date: Type current trade date (to see net position up to date) Or Type current trade date as from and to date (same trade date) for one day position. Click on VIEW(F11) or Click on Print to print report.
- Client Wise Portfolio: Here user can see client wise portfolio either sell or purchase (only outstanding qty.) of all commodity and their exposure (qty*given closing rate) with expiry wise.
Note:If all client wise net position or client wise report folio reports is ok then go to PROCESSING or If client wise net position miss match then go to DAILY option. IF POSITION MISS MATCHED then Go to DAILY option
- Trade Entry/Modify
  Go to daily and select Trade Entry/Modify
- MTM Posting Daily Go to Processing menu and select MTM Posting Daily Daily MTM bills option will post all the trades in related client financial accounts. It will close out trades with closing rate and will post net debit or credit balance in client accounts. If you find any differences in client’s ledgers you can delete MTM bill at using same options.
  Trade Date: Select correct trade date
  Postings date: System will automatically update.
  Next Working Date: System will automatically update
  Click on PROCEED and after then Click on EXIT.
  Note: On Expiry date run below option too.
- MTM Posting Daily (On Expiry Day) We will have run this option only on expiry date to transfer the entire pending quantity and will post separate bill in client’s accounts. The expiry of NCDEX and MCX differ each other, so user have to take care of about this options. Expiry Date: Type current expiry date (on such trade when contract expires). Posting Date: Type posting date (but system automatically updates it.) Client selection: Tick on All Clients. Click on PROCEED and after that Click on EXIT.
- For Members
  1. Exchange Margin File Edit Go to margin option In this option user will edit margin file imported (MARGIN) from IMPORT options. User can correct client’s code or put pro client code whenever required.
     Trade Date: Type correct trade date
     Margin type: Select MG13
     then Click on SHOW Verify client’s code and change code if necessary. Click on TICK button to SAVE and Exit.
  2. Margin Posting In this option user (if wants) can post margins (MG13) to client’s accounts to maintain margin accounts. Margin Type: Select MG13. Current Margin Posting date: Type exact margin date Reversal of Margin Date: System will automatically update it. Click on PROCESS and then Click on CLOSE.
- For Sub Brokers

1. Commodity Wise Exposure - MARGIN Go to Master>>Contract Specification Put here contract wise margin (%) of SYMBOL; but by default system will update when user will import sCONTRACTMASTER.CSV Margin Applicable: Margin Indicator: Select 1 for (%) or 2 for flat value margin; as per described below Set exposure margin % in Margin Type BUY ----- SELL (It will automatically update when user will import CONTRACTMASTER.CSV). User can set exposure margin % either client wise or commodity wise or client/commodity wise.
   Note : User need not come into this option while importing file.
2. Gross Exposure Margin (Portfolio Basis)
   Go to Margin>>Gross Exposure Margin (Portfolio Basis) In this option user can view exposure margin (particular fixed % margin) of total exposure. Business Date: Set business date as trade date. Closing rate date: Set current closing rate date and click on View. You will show here exposure value and it’s %age margin value. If users want to post in client’s accounts then press button (CREATE GE RECORD FOR POSTING).

- Margin Posting In this option user (if wants) can post margins (GE13) to client’s accounts to maintain margin accounts. Margin Type: Select GE13.
  Current Margin Posting date: Type exact margin date
  Reversal of Margin Date: System will automatically update it.
  Click on PROCESS and then Click on CLOSE.
- Client Exposure Wise - MARGIN
  Go to Master>>Margin & Transaction Fees Put here exposure margin (%) of each client wise or default. Set exposure margin % in REGULAR GROSS EXPOSURE MARGIN %. User can set exposure margin % either client wise or commodity wise or client/commodity wise. User can set exposure margin % date range wise too. Import closing rate from IMPORT / DAILY CLOSING PRICE options. And in case of already imported closing rate then need not to import closing rate again.
- Gross Exposure Margin (PORTFOLIO BASIS) Go to Margin>>Gross Exposure Margin (PORTFOLIO BASIS) In this option user can view exposure margin (particular fixed % margin) of total exposure. Business Date: Set business date as trade date. Closing rate date: Set current closing rate date and click on View. You will show here exposure value and it’s %age margin value. If users want to post in client’s accounts then press button (CREATE GE RECORD FOR POSTING).
- Margin Posting
  In this option user (if wants) can post margins (GE13) to client’s accounts to maintain margin accounts. Margin Type: Select GE13. Current Margin Posting date: Type exact margin date Reversal of Margin Date: System will automatically update it. Click on PROCESS and then Click on CLOSE.
  Note: OPT for One Process Either Client Wise Exposure Margin or Commodity Wise Exposure Margin
- Delivery( for MCX Member or MCX Sub-Broker ) MCX does not provide any Delivery files. So users have to maintain manual deliveries from this. Go To DELIVERY-STOCK>>MANUAL ENTRY-EDIT(Market Delivery) Expiry date: Put expiry date Delivery date: Put delivery date (same as expiry date) FA posting date: Put financial posting date and Press Show Again press (+) Sign to add delivery name. Insert all details like client code, contracts name, quantity, delivery price etc. And press SAVE For FINANCIAL POSTING.
  Note: In case of Main Broker:
  The system will automatically post contra delivery amount in bank account defined in system file maintenance.
  In case of Sub Broker:
  And in case of sub broker system will automatically post contra delivery amount in broker’s account which is defined in System File Maintenance.
  In case of Client to Client Delivery Either (MAIN BROKER or SUB BROKER):
  In this case user will have to put ‘C’ in tag column and insert separate contra delivery of client.
- Financial Accounting Go to Financial>>Voucher Entry Amendments Insert vouchers (Bank or Cash payment or receipt or Journal) here. For details about vouchers please refer to COMMEX MANUAL.
- Reports
  Reports can be viewed on daily basis, which are as follow
  1. All reports from REPORTS; specially
     CLIENT WISE NET POSITION or
     CLIENT WISE PORTFOLIO
     CLIENT WISE NET POSITION (ACTUAL BASIS)
     PAYMENT CONTROL REPORT
     PAYMENT CONTROL REPORTS (NEW)
  2. All reports from FINANCIALS; specially
     TRIAL BALANCE
     DEBITOR/CREDITER LIST
     FINANCIAL LEDGERS etc.
  3. All reports from DAILY; specially
     USERID WISE SUMMARY FOR THE DAY
     TRADES CONFIRMATION
     TURNOVER
     BROKERGE STATEMENT
  4. All reports from BILLS Options in case of bill requirement for clients
     DAILY MTM BILLS
     MTM DIFF. BILLS – ON EXPIRY DAY
     COMBINED CONTRACTS BILLS
     Note: And print or view as your requirement. Print bill from BILLS Options in case of bill requirement for clients. For more detail about options described above please refer COMMEX manuals.
Top

## Contract Note

##### Step1: Generate Digital Contract Notes

##### Step2: Send Digital Contract Notes

##### How to Generate Digital Contract Notes

Contract Note can be generated in the following ways:

- Contact
- Contract Nos Generate(Date Range)
- Contract Note Printing Date Range

###### Contact

###### Contract Nos Generate (Date Range)

Using this option user can regenerate/delete contract notes within a date range

##### How to Send Digital Contract Notes

Steps for sending Digital contract notes are as follows:
- Step1: Purchase a Registered paid E-mail* account & Digital Signature Certificate (for sending digitally signed mail).
- Step2: Configure your Outlook Express (Optional) on your Paid E-Mail account to send Digital Contract Notes. Do this step only if the client wants to send the mails through Outlook otherwise they can send mails directly.
- Step3: Log on to www.shilpisoft.com . Click on ‘Downloads’ and Download file DLLSETUP.EXE in program folder. Run DLLSETUP.EXE & give destination folder path of your program folder, it will register all the required dll files in the registry.
- Step4: Go to Master >> Client Master. Enter the Client Code of the Client to whom you want to send Digital Contract Note and enter his E-mail Id
Note: Update records of all the clients you want to send ‘Digital Contract Notes’.
- Step6: Login in package. Go to Master and Click on Mail/FTP/Digital/SMTP Setup. Fill all information
- Step7:
Select the mail gateway :

DIRECT >> To send the mail directly to the sender.

Outlook >> To Send the mail thru Outlook Express.

Enter the following details For Example :-

SMTP host name :: smtp.ncr.airtelbroandband.in // smtp details

SMTP login id :: test.airtelbroandband.in // email login id

SMTP password :: ***** // email login password

SMTP ports :: 25 // port no. using for sending mail

These Options are also mandatory
For Example :-

Your Company Official Mail Id : test.airtelbroandband.in ( mail id on which bounced mail returns)

Certificate Registered Mail Id : test.airtelbroadband.in ( digital certificate mail id )

Digital File Folder :C:\Datafile\Digital ( path of folder where digital/html files created )

Folder Structure : Date-Client wise ( folder created)

- Step8: To Import the Digital Signature Certificate.
Go to Master Menu, ‘DIGITAL\MAIL\FTP Setup’. Click on Cert Imp Button. Following window will open
Browse for the File name for the Digital Certificate and Enter the password and Click on ‘Import’ Button.
- Step9: Now Click On to check the SMTP connection. If the message shows you unsuccessful connection then allow in firewall/antivirus
- Step10: For transferring the files on FTP server. Select the check box and Give the Inputs like:
For Example :-

I.P. Address : 64.38.35.100

User id : abc@abc.shilpisoft.net

Password : ******

Local path : c:\datafiles\client

Remote path : public_html\datafiles\client

Now click on button and check its status.
Save the SMTP/ FTP details.
- Step11: Go to Daily menu, Click Contract Note [HTML] new. Following window will open

1. Tick on Move to folders and Sign Document to make log only. If user wants to mail then tick on Move to folders Sign Document and send mail.
2. Click on HTML Details. It will open a new window as shown below:
3. Enter the name of the concerned person and address and other details
4. Address of the corporate Office and other details
5. Save all details

- Step12: To see whether the Contract Note has been sent or not, Click on the log button in Master ‘DIGITAL/MAIL/FTP Setup’ or you can also see from the option Utilities >> Digital Signed Log. Enter Date of the contract notes generated and Click on View, here you will find the sending information of digital contact notes.
Other Reports send to Clients via Email are:

- Margin Details Inform to clients (As per SEBI guidelines)
Note: Before sending this report user has to import it first from Margin>>Client wise Margin report (as per exchange).
- Financial Ledger
- Demat Ledger
- Stock Entry
- Client Wise Holding
- STT –annexure II

Top

## Voucher Entry

From this option user can insert voucher like bank payment or receipt, cash payment or receipt, and journal vouchers. From this option user can amend or delete pre inserted voucher.
- Voucher Type : Select voucher type like bank payment or receipt, cash payment or receipt, and journal vouchers.
- Voucher Date : Type voucher date and voucher number will automatically generates.
- Bank / Cash Code : After selecting voucher date select Bank’s name.
- Bank Code. Details : The bank detail of client automatically appear.
- And press ( + ) button to insert detail and press ( - ) button to delete row.
- And press ( Tick ) button to save the voucher.

Edit/Delete(F5):

Predefine Narration

New BS Heads

Find Missing Cheques

##### Voucher release

##### Voucher Printing

Top

## Payment Control Report

- Using this option user can get multi databases reports
- Go to Reports >>Payment Control Report-new
Top

## Introducer Calculation

Before calculating and posting Introducer report, define brokerage and follow the following steps:
- Step1: Initial Setting

1. Go to Master >> Client Master: Open Introducer code. Define this Introducer code with Percentage in client's account, as shown below:

- Step2 : Go to financial >> Introducer Commission Report and enter all details and view report. From this option user can calculate introducer’s commission and post in accounts.
  Top

  ## Support System

  | Shilpi provide online support and services to customer using world known Webex connectivity. https://shilpi.webex.com/sc
  | Shilpi provide offline support and messages system using world known support interface , in this system , customer can send or get reply from Shilpi support. support@shilpisoft.com
  | Shilpi provides online chat system where customer can log in and can chat with our support representative and get immediate solutions. www.shilpisoft.com
  | Shilpi uses 30 lines telephone panel support system. Customer can dial 011-43500600 for telephonic support
  | Customer can download latest product updates from our web site www.shilpisoft.com
  | Top

## Contact Us

CORPORATE OFFICE : NEW DELHI
Shilpi Computers Ltd.
501-502, Prakashdeep building, 7 Tolstoy Marg New Delhi-110 001, India
Ph.Nos : 011-43500600 (30 lines), Fax Number : 23738 772
Email : shilpitech@vsnl.com
Web Site :www.shilpisoft.com
Purchase Product : sales@shilpisoft.com
Support : support@shilpisoft.com
MUMBAI OFFICE :
Shilpi Computers Ltd.
204 Knox Plaza, Mindspace, Malad (West), Mumbai- 400 064 India
Ph.Nos : 09311066966, 09350582253
Email :sales@shilpisoft.com
AUTHORISED DISTRIBUTOR :
Bhushan Systems & Consultants P. Ltd.
69/99, 1st Floor, Ganpati Marg, V.T Road, Mansarover, Jaipur-302 020, India
Ph.Nos :+91-141-2783323, 5178608, 09829059517
Email :vbhushan@bhushansystems.co.in
Top