cApexsql Manual

(Capital and Derivative Market Back-Office Solutions for Sub-Brokers)

### Contents

v Introduction

v Initial Settings

v Daily Processing

v Account Open

v Voucher Entry

v Support System

v Contact Us

# Introduction

Top

# Initial Settings

Before start working in cApexsql, user has to do some settings. For it follow the following steps:

v Step 1: Go to Masters and select Exchange Master Creation :- New exchange can be added and deleted using this option

v Step2: Go to Utility>> System File Maintenance

v System file maintenance has four tabs : Profile; Settings; F&O Setting and Mail Settings

v Profile: Fill all details in this tab and save.

v Setting: Fill all details in this tab and save.

v F&O Setting: Fill all details in this tab and save.

v Mail Settings:

v Select mail method. If

1. Mail method is outlook then no need to fill SMTP details

2. Mail Method is Direct then fill all SMTP details

Top

# Daily Processing

v For Capital Market

v For F&O Market

## Daily Processing for Capital Market

For daily transaction, follow the following steps:

Step1: Settlement Schedule

Select Master >>Settlement Schedule:

Note: If wants to import all settlement type at once then select Import Sett. Schd. from Master >> Settlement Schedule. Following window will open:

Import Settlement Schedule

Step2: Trade Import (capital)

After importing settlement schedule, Import Trade files. For it go to Daily>>Imports (Capital)>>Trade Transfer. Now select Exchange (NSE or BSE) from where you want to import Trade File.

1.

Trade Import from NSE

To import trade file for NSE, go to Daily >> Imports (Capital) >>Trade Transfer >> NSE

2.

Trade Import for BSE

To import trade file for BSE, go to Daily >> Imports (Capital) >>Trade Transfer >> BSE

3.

Step 3: Trade Edit/Entry

If user wants to Entry/Edit imported trades then go to Daily >> Imports (Capital) >>Trade Transfer >> Trade Edit.

1. For New Entry

2. To Edit exiting record of a settlement number

4.

Step 4: Transfer to Main

After importing the trade files, transfer these files to main system. For it, go to Daily >> Imports (Capital) >>Trade Transfer >> Transfer to Main.

Enter all details and click on proceed.

Step 5: Security Transaction Tax:

Now import Security Transaction File (STT) file for NSE (if working in NSE Exchange) or BSE (If working in BSE Exchange).

STT for NSE: Select Daly>>Security Transaction Tax (cap)>>STT File Import (NSE)

To edit trade code which are without client code: go to Daly >> Security Transaction Tax (cap) >>STT File Import (NSE)>>Edit Without Clients

STT for BSE

To edit trade code which are without client code: go to Daly >> Security Transaction Tax (cap) >>STT File Import (BSE)>>Edit Without Clients

STT Posting/Deletion/Printing: For STT Posting/Deletion/Printing go to Daly >> Security Transaction Tax (cap) >>STT Posting/Deletion/Printing

Step 5: Reports >> Net Position Client Wise/Scrip Wise

Now check STT is imported or not. For it, go to Reports >> Net Position Client Wise/Scrip wise

Note: If all Client-Scrip Wise Net Position reports is ok then do Brokerage Recalculation and If client wise net position miss match then go to DAILY option >> Trade Editing/Insert-Other Sources (Cap).

Step 6: Daily >> Trade Editing / Insert- Other Sources (Cap)

Trades Entry / Modify option will allow user to enter new trades or modify daily imported trade files. User can change client code or add new off market trades from this option.

Step 7: Closing Rate Import

Daily>>Imports (Capital)>>Closing Rate Import

Step 8: No Delv File Updation

Clearing Rate Entry>>Clg Rate Entry (Cap)>> No Delv File Updation

No Delivery File Updation for BSE

Step 9: Clearing Rate Entry

Step 10: No Delv. File Transfer for NSE

Step 11: Stamp Duty Posting in Client a/c-CAP

Select Stamp Type

Select Posting

Enter Settlement No

Click on Proceed

Enter Transaction Date

Step 12: Brokerage Recalculation

Daily >> Brokerage Calculation (Cap)

Step 13: Final Scrip Wise Obligation

Obligation >> Final Scrip Wise Obligation

Step 14: Contract Note

Daily>>Contract Note (Cap)

Top

## Daily Processing for F&O Market

For daily transaction follow the following steps:

Step 1: Trade Import

Before start working for F&O import Trade File, Contract Master File, Order File, Exercise/Assignment Trade File, Closing Price Import and Position File.

Trade Import: To import Trade File for F&O, go to Daily >> Imports (F&O) >>Trade Imports from NSE File

Contract Master Import: To import Contract Master File for F&O, go to Daily >> Imports (F&O) >>Contract Master Imports

Order File Import: To import Order File for F&O, go to Daily >> Imports (F&O) >>Order File Import

Exercise/Assignment Trade File To import Trade Transfer from NSE for F&O, go to Daily >> Imports (F&O) >>Exercise/Assignment Trade File

Closing Price Import: To import Closing Price from NSE for F&O, go to Daily >> Imports (F&O) >>Closing Price Import

Position File Import: To import Position file for F&O, go to Daily >> Imports (F&O) >>Position File Import

Top

Step2: Trade Entry/Edit

If user wants to Entry/Edit imported trades then go to Daily >> Imports (F&O) >>Trade Transfer >> Trade Entry/Modify (F&O).

Trade Entry/Edit

Trade Analysis: Daily >> Trade Entry/Modify (F&O)>>Trade Analysis

Step3: STT for NSE/BSE

STT Import:

Go to Daily>>Security Transaction Tax >>STT File Import

STT Calculation

Go to Daily>>Security Transaction Tax (F&O) >>STT calculation

STT Posting/Deletion/Printing

Go to Daily>>Security Transaction Tax (F&O) >>STT Posting/Deletion/Printing

Step4: Reports >> Client wise Net Position

Step5: Clearing Rate Entry

Step6: Stamp Duty Posting in Client A/c-F&O

Step7: Brokerage Recalculation

Go to Daily>> Brokerage Recalculation

Step8: Bill Processing

Go to F&O >>Bill Processing >>MTM Payin / Payout Processing-Future (Single Day)

Go to F&O >> Bill Processing >>Option Premium Payin / Payout Posting

Go to F&O >>Bill Processing >>Future Bill Processing (Expiry)

Go to F&O >>Bill Processing >>Interim Exercise/Assignment Bill Posting

Go to F&O >>Bill Processing >>Final Exercise/Assignment Bill Posting

Go to F&O >>Bill Processing >>MTM Payin/Payout Processing-Future (Date Range)

Sepp9: Contract Note

Top

# Account open

To open account of a client go to Master >> Client Master. Fill all details and save.

1.

Default Value Fixer: Go to Master >> Client Master>>Default Fixer. Set all values and save.

Top

# Voucher

Voucher Entry:

For Voucher Entry go to Financial>>Voucher Entry/Amendment

1.

Voucher Edit/Delete: To Edit/Delete voucher go to Financial>>Voucher Entry/Amendment>>Voucher Edit/Delete (F5)

Following Window will open. From here user can edit and delete voucher.

Voucher Printing:

For voucher printing go to Financial>> Voucher printing. With this option user can print voucher in the following pattern:

1. All vouchers within date range

2. All Vouchers for specified date

3. Selective voucher for a specific date

## 1. For all Vouchers

## 3.All Vouchers for specified date

## 4. Selective Voucher

##

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, shilpitech@vsnl.com
Support : support@shilpisoft.com

Ø MUMBAI OFFICE :

Shilpi Computers Limited.
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