Docstoc

Stock Ledger in Excel

Document Sample
Stock Ledger in Excel Powered By Docstoc
					


Win-eX
a complete exchange management
solution


From
Web Masters L.L.C.
P. O. Box 4750,
Dubai – UAE


Tel:    +971- 4- 351 1426
Fax:    +971- 4- 359 1688
E Mail: wmasters@emirates.net.ae
Win-eX
a complete Exchange management solution



Contents

WIN-EX SOLUTION AND ITS FEATURES.... ....................................................................... 3

MASTERS ......................................................................................................................... 4

FRONT OFFICE TRANSACTIONS ..................................................................................... 5

INQUIRIES ....................................................................................................................... 7

BACK OFFICE TRANSACTIONS ...................................................................................... 8

LEDGERS ......................................................................................................................... 9

REGISTERS ..................................................................................................................... 10

REPORTS ....................................................................................................................... 11

UTILITY ........................................................................................................................... 12

HELP .............................................................................................................................. 13




c7af5ae1-c0db-4dd0-aa4c-385cb451fbdd.doc                    22-Aug-11                                                  Page 2 of 13
Win-eX
a complete Exchange management solution




         WIN-eX SOLUTION AND ITS FEATURES....
A window based software with Front-end of Visual Basic and back-end of
Microsoft SQL Server. The following menu options of the software will cover up
the complete solution and requirement of the business in Exchange industry.

1.        Masters
2.        Front Office Transactions
3.        Inquires
4.        Back Office Transactions
5.        Ledgers
6.        Registers
7.        Reports
8.        Utility
9.        Help

All the options details have been given in by its usage.

All the MIS reports can be designed and customized with the detailed discussion
with management and its periodical requirement. Any report or print out
generated from the system can be exported in to word or excel file from the
report itself.




c7af5ae1-c0db-4dd0-aa4c-385cb451fbdd.doc   22-Aug-11                  Page 3 of 13
Win-eX
a complete Exchange management solution




                                          MASTERS
This option will set one time master for the setting various parameter of the
software and its accounting effect on implementation of the software


Organisation Set up
    Group of Companies
    Company
    Branch

Set up
     Account set up

Chart of Account
   Schedule Master
   Schedule for the Central Banks
   Accounts for the Central Banks

Account Master
   Party Accounts
   General accounts

Bank Master
    Bank Masters
    Bank Branch Masters

Other master
    Currency Master
    Country Master
    City Master

Stationery Masters
     Stationery Master
     Stationer Series Master

User / Rights




c7af5ae1-c0db-4dd0-aa4c-385cb451fbdd.doc   22-Aug-11                Page 4 of 13
Win-eX
a complete Exchange management solution




                     FRONT OFFICE TRANSACTIONS
This option will allow user to do the day-to-day front office transactions of the
business organization.

Currency Trade
    Currency Trade Transaction
    Currency Trade Cancel Transaction
    Currency Inward / Outward (Wholesale)
    Currency Inward / Outward Cancel (Wholesale)

Incoming Telegraphic Transfer & Demand Draft Transaction
    TT Advise
    TT Advise Authorise
    TT Payment
    DD Advise
    DD Advise Authorise
    DD Payment
    Cheque Delivery
    TT/DD Advise Change
    TT/DD Payment Change
    TT/DD Payment Cancel

Outgoing Telegraphic Transfer Transaction
    TT Receipt
    TT Receipt Cancel
    Receipt for TT

Demand Draft Issue
   DD Issue
   DD Cancel
   Receipt for DD

Travelers’ Cheque
    TC Receipt
    TC Sale
    TC Purchase
    TC Returned

Expected TT
    Received for collection
    Collection Sent
    Realised
    Returned


c7af5ae1-c0db-4dd0-aa4c-385cb451fbdd.doc   22-Aug-11                    Page 5 of 13
Win-eX
a complete Exchange management solution


Other Transactions

         Debit Note

         Credit Note

         Cash-Bank Receipt Transaction

         Cash-Bank Payment Transaction

         Cheque Printing




c7af5ae1-c0db-4dd0-aa4c-385cb451fbdd.doc   22-Aug-11   Page 6 of 13
Win-eX
a complete Exchange management solution




                                          INQUIRIES
This option will give the screen inquires on the basis of data entered in to system

         Currency Inquiry (Monthly, Daily, Quarterly & Yearly)
         Currency Update
         Usage Log Detail (Drill Down)




c7af5ae1-c0db-4dd0-aa4c-385cb451fbdd.doc    22-Aug-11                      Page 7 of 13
Win-eX
a complete Exchange management solution




                      BACK OFFICE TRANSACTIONS

This option will allow user to do the day-to-day back office transactions of the
business organization.

Cash & Bank Transaction
   Petty Cash
   Bank Deposit
   PDC Issue Clear

Journal
    Base Currency Journal
    Foreign Currency Journal

Reconciliation Process
    Bank Reconciliation
    Account Reconciliation
    Demand Draft Reconciliation

Exchange Rate Module

Stock Valuation Process

Test Key Generation




c7af5ae1-c0db-4dd0-aa4c-385cb451fbdd.doc   22-Aug-11                   Page 8 of 13
Win-eX
a complete Exchange management solution




                                          LEDGERS
This option will give the information in ledger format.

Financial Ledger
         Ledger in base currency

Currency Stock Ledger
         Currency-wise stock ledger




c7af5ae1-c0db-4dd0-aa4c-385cb451fbdd.doc   22-Aug-11      Page 9 of 13
Win-eX
a complete Exchange management solution




                                          REGISTERS
This option will give the transaction listing of the transaction entered in to the
system in the report format.

         Day Book
         Receipt register
         Payment register
         Bank deposit register
         PDC Clear register
         Currency Trade Register
         Currency Inward-Outward Register
         Incoming TT
           Incoming TT Advise Register
           Incoming TT Payment Register
           Incoming TT Outstanding
           Incoming DD Advise Register
           Incoming DD Payment Register
           Cheque Delivery Register
           Payment Mode-wise TT Advise Register
           Limit-wise Payment Mode-wise TT Advise Register
         Outgoing TT
           Outgoing TT Register
           Outgoing TT Register (Special Format)
           Limit-wise Outgoing TT Report
         Demand Draft Issue
           Demand Draft Issue Register
           Statement of Remittances
           Limit-wise Demand Draft Issue Report
         Travelers’ Cheque
           Receipt Register
           Sales Register
           Purchase Register
           Return Register
         Expected TT Register
         Stationary Usage Register




c7af5ae1-c0db-4dd0-aa4c-385cb451fbdd.doc    22-Aug-11                   Page 10 of 13
Win-eX
a complete Exchange management solution




                                          REPORTS
This option will give the information on periodic financial, MIS and central bank
reports

Financial Statement
         Opening Trial Balance
         Trial Balance with group
         Movement trial balance
         Drill down trial balance
         Profit and loss account
         Movement profit and loss account
         Balance sheet
         Movement balance sheet
         Drill Down Balance Sheet

Central Bank Reports
   Quarterly Return
   Statement of Asset and Liabilities
   Statement of Profit and Loss

Demand Draft Reports
   DD Weekly Report
   NRI Part I Report
   NRI Part II Report
   NRI Internal Report

Analytical reports
         Summary of Sales – Purchase
         Quantity Turnover


Other reports
         Statement of account
         Summarised Statement of Account
         Travelers’ Cheque Stock Summary
         Travelers’ Cheque Stock List
         Bank Reconciliation




c7af5ae1-c0db-4dd0-aa4c-385cb451fbdd.doc   22-Aug-11                   Page 11 of 13
Win-eX
a complete Exchange management solution




                                           UTILITY
This option will give the various utility to be perform by the user to run the
software and its precaution for use

         Refresh Exchange Rate
         Active Counter Information
         Day End Processing
         Colour Settings




c7af5ae1-c0db-4dd0-aa4c-385cb451fbdd.doc    22-Aug-11               Page 12 of 13
Win-eX
a complete Exchange management solution




                                           HELP
This option will give the detailed help for the use of the various options and its
conceptual understanding.


         Text help
         Show me help




c7af5ae1-c0db-4dd0-aa4c-385cb451fbdd.doc   22-Aug-11                    Page 13 of 13

				
DOCUMENT INFO
Description: Stock Ledger in Excel document sample