# Spot10 Back Office

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

## Introduction

Spotxl is an especial and important product for National Spot Exchange Ltd. (NSEL) and NCDEX spot exchange (NSPOT) in commodity market. It is an electronic, transparent Spot trading platform, which is poised to transform the commodity market by way of reducing the cost of intermediation and thereby improving marketing efficiency. It is the state-of the-art organized and structured market aid providing facilities of maintaining records for risk free and hassle free purchase and sell of various commodities. With the help of it trades can be done on delivery basis. In it delivery done in demat format and it beautifully managed demat accounting and does not carry any sauda.
Top

## Login Process

1. Double click on spot10.exe icon(as shown below)
2. Following Window will open with login window

Enter userid and password or login by default. Default user id guest and password is guest.

Top

## Initial Setting

Set all parameters according to you and save.

Go to Master >> Client Master >> Default Value Fixer >> Set the following values in the following window:

Top

## Account Opening

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

#### UCI

- Go to Master >> Unique Client Information. Fill all details in this form and click on save.

#### 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

#### Open RM/TL Master

#### Define Brokerage

Go to Master >> Brokerage Schedule. There are three Brokerage Schedule :
- 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 the client without brokerage; and (in this case, User has no need to define all clients’ brokerage.)

Brokerage can be define on the Value basis or Unit basis.

1. For percentage (Value) basis:

1. Go to Masters >> Brokerage Master. It will open the following window.
   If you want to calculate brokerage on percentage basis, select Brokerage type Value and enter Brokerage Percentage per unit, Minimum Brokerage and Auction Brokerage.

- For Unit Basis :

1. Go to Masters >> Brokerage Master
2. If you want to define brokerage lot wise, select Brokerage type Unit

#### Define Margin and 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 NSEL
- For NSPOT

### Daily Processing for NSEL Exchange

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

1. NSEL_Trd20110926.csv : Daily Trades
2. NSEL_MS20110926.csv : Daily Closing Price
3. NSEL_MARGIN_37600_20110926.csv : MG13
4. NSEL_MARGIN_37600_20110926.csv : ADLN File
5. NSEL_Productmaster.csv :
Product Master
Note : Copy all these file in data file folder to pick it by default.
After downloading these files from ftp or from terminal, follow the following steps:

2. Go to Import menu
   1. Select Daily Trades : Whatever trades we do on front office terminal daily, goes into trade file folder in front office and we have to import it into our back office software for further process. The file named NSEL_Trd20110926.csv contains all the trades done on front office terminal.No need to remember the file name.

- Daily Closing Price
  User have to import daily closing price into Back-Office software on daily basis.
- MG13 File
  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.
- ADLN 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
- Protector Master (Optional only for Main Brokers)
- 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 port 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

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 Billing Option >> MTM/Delivery Obligation Posting
  This 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.
- Go to Margin >> Margin Posting
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:

- Contacts(Single Day)
- Contracts (Date Range)

###### Contacts (Single Day)

###### Contracts (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
Step5: Change following parameters in Client Master:

Set Gen Contract= ‘Y’ (to enable)

Contract Type = Digital

Tick on Move to folder and save the information.

Note: Update the record 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 new window will open 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

  ## Introducer Calculation

  ## 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