:: Welcome to Shilpi Computers ::

1. Get TIN, PAN, DIN & e-filing Services

TIN FACILITATION CENTRE (Managed by NSDL)	CERTIFIED FILING CENTER For e-filing under MCA 21
Branch code: 03272 Agent Name: Integrated Enterprise (India) Ltd. PAN, TAN, e-TDS/TCS, digitization, AIR, Tax view information etc. Preparation and e-filing of all TDS returns and issue of TDS certificates. Preparation and e-filing of all Income tax returns	DIN application, DIN –2, DIN -3, Preparation and e-filing of all ROC forms, viz annual returns (Form 20B), balance sheet (Form 23AC, 23ACA) etc., Issuance of digital certificates etc. All the infrastructure as required by NSDL and MCA to provide services are available.

Pls. Contact Atoma For Further Enquires:

        ATOMA NETWORK PVT. LTD.
       51, FRONT BLOCK, 2ND FLOOR,
       RAMA ROAD NAJAFGARH ROAD,
       INDUSTRIAL AREA (Near Zakhira)
       DELHI 110 015 Tel: 41428806, 41428807

Contact person: Arun Kumar Goel, FCA, ACS, AICWA
arungoelca@yahoo.co.in
9811030929
Arjun Ahuja
Arjunahuja_a@yahoo.co.in
9818104041

2. CDSL Sign. Scanning

PROCEDURE FOR CDSL SIGNATURE SCANNING

	Go to utilities option>> System utilities >>System preferences>> Click on Preferences Go to scanned Signature folder, give the path where signature is scanned.
	Then create a signature folder as define in system preferences.
	Go to Client Master >> open a new Account in Customer Profile.
	Go to linking option & then enter internal reference no & then save no.
	Then scan the Signature & save them in path define in system preferences file name as << internalrefno >> bmp.
	After all signature scanned and account opened then export account.
	Go to export to Cdsl from customer profile.
	Click on attach signature internal reference no basis
	Click on export button, it will give message successfully exported.
	There is two file will created one text file & other bmp file of every account.
	Then copy all file from export folder and upload it on cdsl online >> under option bo upload >> file level.

3. Bank Reconciliation

BANK RECONCILIATION

FINANCIAL >> BANK RECONCILIATION

Available bank are HDFC BANK-OLD , HDFC BANK-NEW, KOTACK MAHINDRA BANK , ICICI BANK, IDBI BANK ,OBC, PNB, SBBJ, CANARA, SBI, BOI, BOM, AXIS-OLD, AXIS-NEW,ABN,INDUSIND

For Bank Reconciliation follow the following steps:

(Here, HDFC Bank is taken as an example)

FILE STRUCTURE FOR BANK RECONCILIATION:-

1. HDFC BANK- old file format

Book Date,Description,Ledger Balance,Credit,Debit,Value Date,Ref No,Transaction Branch

2. HDFC BANK- NEW file format

Trxn Date Time,Value Date,Trxn Amt,Debit/Credit,Description,Ref No.,Transaction Branch,Running Balance

HOW TO IMPORT BANK TRANSACTION FILE

Select Financial>>Bank Reconciliation>>Bank Transaction File Import

1            File Format     : Select File Format (Bank Name of your Bank a/c like HDFC BANK etc.)
2            Bank Name    : Select Bank Name
3            File Name       : Give the path and file name with extension or Select from Explore Button
4            Click on          : Import Data

Caution: If you, import already imported Bank Trans., that were reconciled, this will unreconcile all Reconciled Transaction (If exist of that date).

How to delete the wrong imported Bank Transaction file ?

First 3 steps same as above

4.    Click on Delete Only
5.    Enter From date To date
6.    Click On Delete Data

Caution: If you are Deleting Bank Trans. that is already reconciled this will unreconcile all Reconciled Transaction (If exist of that date)

FOR BANK RECONCILIATION

Select Financial>>Bank Reconciliation>>Bank Reconciliation Report

1. Bank name : Select Bank Name
2. Click on unreconciled & show
3. For Automatic Reconciliation : Click Reconcile Button
4. For Manual : Click on Update Manual
5. Enter Reconciliation Date in Voucher Data & Bank Data both
6. Reconcile

For Voucher Entry & Modification : Click on

For Bank Reconciliation Statement

1. Enter Date :

2. Click :

3. For Printing Click :

Want to know Error in Bank Reconciliation : Click on

HOW TO ENTER OPENING ENTRIES ?

Select Financial>>Bank Reconciliation>>Opening Entry
1. For Bank Opening Entries    : Select Bank Data Or
                                                   For Voucher Opening Entries : Select Voucher Data
2. Bank Name                           : Select Bank Name
3. Click                                     :

4. Enter Entries
5. Save

For Opening Balance Entry of Bank :
1. Select Bank Data
2. Enter Amount in Opening Balance
3. Enter As on Date
4. Save

4. New Demat System

Demat Accounts Maintenance System

Features at a glance..

	Multiple Beneficiary a/c and Margin a/c can be maintained.
	Automated facility to stop PayOut in Beneficiary a/c and on Debit Balance PayOut transfer to Margin a/c.
	POA Client Pay-In and PayOut should be maintained.
	Multiple time Pay-In can be created.
	Demat charges posting on date range basis.
	Beneficiary and Margin Account Holding balance with Client and Scrip balance.
	Auction Payout entry automatic updated.
	Now Pay in Shortage can be viewed in your Capex system.
	If you have your own CDSL depository you can do your PayIn-PayOut totally through CDSL.
	Easy to view Client wise and Scrip wise PayIn-PayOut shortage.

5. PDF File Creation

Portable Document Format {PDF} File Creation :-

What is PDF File Format ?
Portable Document Format (PDF) is a file format developed by Adobe Systems for representing documents in a manner that is independent of the original application software, hardware, and operating system used to create those documents. A PDF file can describe documents containing any combination of text, graphics, and images in a device independent and resolution independent format.

Features :-
Open format— De facto standard for more secure, dependable electronic information exchange — recognized by industries and governments around the world. Compliant with industry standards including PDF/A, PDF/X, and PDF/E.

Multiplatform — Viewable and printable on any platform — Macintosh, Microsoft® Windows®, UNIX®, and many mobile platforms.

Extensible — More than 1,800 vendors worldwide offer PDF-based solutions including creation, plug-in, consulting, training, and support tools.

Trusted and reliable — More than 200 million PDF documents on the web today serve as evidence of the number of organizations that rely on Adobe PDF to capture information.

Maintain information integrity — Adobe PDF files look exactly like original documents and preserve source file information — text, drawings, 3D, full-color graphics, photos, and even business logic — regardless of the application used to create them.

Searchable — Leverage full-text search features to locate words, bookmarks, and data fields in documents.

PDF & SHILPI Software :-

PDF File creation incorporated in cApex, Fopro & Commex. In various reports now user can create pdf file format (Trade Confirmations, Net Position, Digital Signed Contracts Notes etc.) and provide it to clients.

How to Configure PDF in Shilpi ?

For Create pdf files through software take below given steps:-

1.Download Dllsetup.exe

Click here to download

2.Run setup, select program folder and finish setup.

3.If you want only pdf file, then go to System File Maintenance & change "Delete Source File After PDF" to "Y".

6.Mail/FTP/Digital Setup

How To Setup Digital/Mail/FTP

Step 1:   Purchase a Registered paid E-mail* account & Digital Signature Certificate*.
              * For sending digitally signed mail.
Step 2: Double click on Digital Signature Certificate for example: Anshuman 1...8.pfx to                import certificate, following window will open

Step 3: Login in package. Go to Master and Click on Mail/FTP/Digital/SMS Setup
Details (Digital Signatures) and enter the asked information.

Step 4: To Import the Digital Signature Certificate.

Go to Master Menu, ‘MAIL\FTP\SMTP Setup’. Click on Cert Imp Button

This Window will be shown, Browse File name for the Digital Certificate and Enter the password and Click on ‘Import’ Button.
Now open internet explorer >>Tools >>Internet Options >>Contents>>certificates.
Double click on a certificate>> select details >>Note down serial no

Enter this serial no in MAIL\FTP\SMTP Setup>>Certificate serial no field and other details

Note: Before save the information please remove spaces between serial no.

Example: -
Your Company Official Mail Id : shilpisofttest@gmail.com // mail id on which bounced
mail returns
Certificate Registered Mail Id : shilpisofttest@gmail.com // digital certificate mail id
Digital File Folder : C:\Datacom // path of folder where digital/html files created
Folder Structure : Date-Client wise /Client –Date wise folder created

Step 5:
a. Select the mail gateway:
DIRECT >> To send the mail directly to the sender.
OUTLOOK >> To Send the mail through Outlook Express.
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.

b. For sending mail directly Enter the following details

For Example :-

SMTP Server name :: smtp.gmail.com // smtp details
SMTP login id :: shilpisofttest@gmail.com // email login id SMTP password :: ***** // email login password
SMTP ports :: 465 // port no. using for sending mail

c. These Options are also mandatory for sending mail directly.

Step 6:

Now Click On

to check the SMTP connection. If the message shows you

unsuccessful connection then allow in firewall/antivirus.

Click On

also and message should be successful

Save the SMTP/ FTP details.

Step 7:

Go to Master >> Client Master. Enter the Client Code of the Client you want to send
Digital Contract Note. Enter their E-mail Id and change following parameters:

a. Move to folder = Tick on it .
b. Contract Type = Digital
c. In the parameters/tags Box, Set Contract generate enable y/n = y
d. Save the information.

Update the record of all the clients you want to send ‘Digital Contract Notes’.

Step 8:

Go to Daily menu, Click Contract Note [HTML]. Click on HTML Details. Enter the name
of the concerned person and address of the corporate Office.

For COMMEX users:-

For cApex10 Users:-

For foPRO10 Users:-

Tick "Sign Document" for Digital Signed Contract Notes, tick "Send Mail" for sending Digital Signed Contract Notes. "Generate HTML" will start sending Contract Notes at end of the process a message will display "HTML Contract Note Successfully Created/Sended"

# If Sign Document option is disabled, contact Shilpi Customer Support

Step 9:

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.

7. Software performance issue

For better performance of software please insure that the following given indexes must be in database :-

1. Valid indexes in Commex10:- For check the indexes in database run utilcap10.exe from Commex10 folder (program folder). Connect the database and go to Commex menu and select "create/verify indexes (commex)" then select table name. It will show all available indexes. If find any invalid/drop indexes then click on Re-create (all) button to create indexes.

2. Valid indexes in cApex10:- For check the indexes in database run utilcap10.exe from cApex10 folder (program folder). Connect the database and go to Maintenance (cap+fo) menu and select "create/verify index" then select table name. It will show all available indexes. If find any invalid/drop indexes then click on Re-create (all) button to create indexes.

3. Valid indexes in DP:- For check the indexes in database run utilcap10.exe from DPORA10 folder (program folder). Connect the database and go to Nsdl (DP) menu and select "create/verify index" then select table name. It will show all available indexes. If find any invalid/drop indexes then click on Re-create (all) button to create indexes.

4. Valid indexes in Cdsl:- For check the indexes in database run utilcap10.exe from CDSLl10 folder (program folder). Connect the database and go to Nsdl (DP) menu and select "create/verify index" then select table name. It will show all available indexes. If find any invalid/drop indexes then click on Re-create (all) button to create indexes.

8. Manage Your Security System

Security system :-
-------------------------------------------------------------------------------
Security means different things to different people. It may even mean different things to the same person, depending on the context. For us, security boils down to enforcing a policy that describes rules for accessing resources. If your software misbehaves, a number of diverse sorts of problems can crop up: reliability, availability, safety, and security.

The way, which can prevent your valuable databases by using, cApex in-built capability. Explore and use it.

Here is tip and tricks, which can help us to implement such powerful capability of cApex security in your system. The dramatic increase in the use of IT has exposed organizations to misuse on their information systems, assets and databases. Unfortunately, protecting against the misperceived threat is expensive and ignores the real danger of intentional or accidental security breaches from internal, trusted sources.

An administrator can authorize application to different level of employees based on there individual responsibility. Suppose there are three types of departments like marketing, trade, finance etc. common application works for all but when security and alteration comes then we have to segrate responsibility so that we can define and understand each department workflow.

CApex have in-built robust security system, which can protect and secured your application and database from unauthorized access. Here is details description how we can impose security system.

Have a security strategy for user and administrator accounts and passwords.

If we don't want unauthorized users logging in to our system, and they do, then we have a security violation on our hands.

Have several accounts for special purposes on your system. Be in control of all access to your system by other users, and don't use Guest access without a good reason.

To access security system, you can logged in by using cApex default admin / password like this.

ID: - admin
Password: - anil

You will find the ‘Security System’ option highlighted in ‘System Utilities’ under ‘Utilities’ menu. This feature will be enabled when logged in through admin controls; means will be disabled (covered with grey colors).

Drag mouse and choose ‘Security System’ under Utility main menu.

When you will click on it, the following window will display.

To creating the new user click on

button. The following window will appear:

1.Enter the required information and Save it.

Branch          : Select the branch for e.g. main office
User id          : write the user id for e.g.shilpi
User name   : write the user name for e.g. shilpi
Password     : write the password for e.g. Sunil
Status            : select enable.

Allowed multi login: if select yes then you are allowed to login in various machine and if select no then once you are logged in one machine you are not allowed to login in other machines .it depends on the Administrator’s choice what login permissions he wants to provide to a user.

Branch, user id, user name, password, status and allowed multilogin these fields are mandatory to fill and save them

2 Message will appear your id has been successfully created
3 Exit from this window

Select the branch, user id and main menu as shown in the above window

Branch >>it contain all the branches. Select the branch under which you create the user id for
e.g. main office

User id >>select the user id for e.g. Shilpi

Main menu >>it contain 12 options which is coming under capex

The windowpane showing as below:

There are the option names and in front of that the permission which we can grant to them. Whatever the permission we want to grant to a user whose user id is selected priorly by checking the checkbox below it

a. Option name >>this contains all the options & sub options which come under the selected
    main menu

b. Edit/del >>by checking edit/del in front of an option, we can grant a user the permission to edit or
    delete a record from the software

c. Add >>by checking grant permission to add record

d. Process >> by checking grant permission to process a file or importing the file

e. View/print >>by checking grant permission of view/printing the file

f. Full lock >>locking the menu completely i.e. user will not be able to use the selected option at all

1 Whatever the permissions the administrator want to grant the user, he checked in front of the option
2 If the administrator does not want that user to access an option completely check full lock in front of it
3 If the administrator wants that user access the option but does not do any type of edition /deletion
   then uncheck that checkbox in front of that option and save it.
4 There is also a provision to hide/dim all the options under a menu. For that select the menu in main
   menu and check auto full lock and save it

>>This icon is used to see the client list. Whenever clicked following window will appear

The user according to their own convenience uses this window. There are three options along with their radio buttons without branch cases, selective branch and all clients

1 if select without branch cases then without branch clients are shown on the screen
2 if select selective branch then select the branch. It will show all the clients under that branch
3 if select all clients then all the clients are shown on the screen

>> Copy security is a powerful and comprehensive data migration solution that automates the copying of data between one Userid into another userid .By click on them following window will appear. select the userid in both the windows and save them

From this window lock up expensive data supplies, locking mechanisms can reduce theft or tampering.

User control. People should only have access to applications and information required to perform their assigned job function. Even if approved for access to a restricted file, a user can be limited to viewing it from a certain workstation at a specific time. Organizations should also control who can create accounts or add users to the system, and audit the system frequently for dummy IDs or accounts.

9. Adjustments/Close/Expiry

Click Here Find more Information About ADJUSTMENTS/CLOSE/EXPIRYYR

10.Payment Control Report

Payment Control Report (Multi-Database)

Connect your all databases one by one through Related Database Info. For it run Capex10 and follow the following steps:
1) In Reports menu >> Payment Control Report (Multi database)-New
2) Click on Related Database Info.
3) Enter the required details and save the information
4) Click on Update Database Information

5) Click on Update DB Info.

6) Click on Ok

7) Now again save all details

8) Go to Report Menu >> Payment Control Report (Multi database)-New
9) Enter details and Select required parameters
10) Click on calculate button to calculate
11) Click on view to view PCR Report

12) Sample PCR Report

Note:
1) This report is available in excel format
2) This is customized report, for more details contact Shilpi support

How to Close your books ?

Oracle Maintenance