Stock Trading

I. SOFTWARE OVERVIEW

Software BRAVO – SECURITIES when applied at specialized units SECURITIES strong>  is customized according to the characteristics of enterprises in the industry. BRAVO Securities software not only fully meets the requirements of financial – accounting activities of securities companies according to  Circular 334, but also supports administrative work such as contract management. ; handling the transaction core connection, managing the work progress flow, connecting the departments of the enterprise such as Human Resources Department, Purchasing Department… as well as connecting to aggregate data from branches and units. member.

II. READING PROBLEMS OF BUSINESSES IN THE SECURITIES INDUSTRY

1. Data organization system on software applied at securities companies

• Describe main activities

​a. (1): Managing stock transactions

– This is the first activity that starts the operation process. business activity of a securities unit.

– Normally, securities units will use specific transaction cores to record Buy – Sell transactions on the stock exchange.

b. (2): Financial and accounting management

– As the division that inherits and records all transactions of the sales transaction department to include in accounting books.

– Play the role of controlling and putting the financial reporting systems in accordance with Circular 210, according to the State Securities Commission and internal management reports of enterprises.< /p>

– Main tasks in the process: Cash accounting; Bank accountancy; Sales accounting (Self-trading of securities, receivables); Purchasing accounting (Self-trading to buy securities, payable); Off-balance sheet securities accounting; Fixed asset management accounting and tools Asset accounting and CCDC; Tax accounting; Connect transaction core and get data; General Accounting; Financial statements according to Circular 210; Some financial statements according to regulations of the State Securities Commission; Management reports at the request of the business.

c. (3): Purchase management .

– After completing the “request for materials”, conduct inquiries, collect quotes and evaluations, select the most suitable supplier.

– After the leader approves the supplier, prepares orders and contracts (according to the quotation) and monitors the purchase process.

– At the same time, prepares a dossier. pay the supplier and transfer it to the accountant for payment.

– After the successful purchase and import process, conduct a survey and evaluate the quality of each supplier as a basis. just to choose, buy in the next time.

– Main tasks in the process: Control purchase offer; Gather quotes and evaluate suppliers; Contract/purchase order management; Monitor purchase status; Make purchase payment records; Supplier survey and evaluation

d. (4): Human Resource Management

– Serving for human resource management (Management of the entire working process of an employee at the enterprise) .

– Serving the human resources department to calculate payroll on the system.

– Main tasks in the process:  Human Resource Management; Timekeeping; Salary calculation

e. (5): Controlling the branch’s activities , Ho Chi Minh, Da Nang, Vung Tau) independent accounting from the head office.

– The system requires a tool to control the activities of branches as well as aggregate data of the entire Company on the same software system.

– The main work in the process (Common departments participating in the system): Accounting Department; Shop; Human Resources Department.

III. BRAVO SOLUTIONS FOR SECURITIES BUSINESS UNITS

1. Software database organization

With all the content as well as the general operating model of a securities unit described above. BRAVO software is comprehensively designed to control the entire operation of the enterprise (applied at the head office and branches) with the data interaction of the departments on the same system and ensures the model centralize the database.

• Description:

​— At the head office:

+ Install 01 BRAVO software including “ running program” and “database” on the server (Server);

+ In departments, computers that are allowed to access the software (Client) will be declared ( machine name, user ID) and installed “running programs” for users to update information and data into the software;

+ Users will be managed and authorized in detail according to each user role at the relevant departments, each department.

– At branches:</st Rong>

+ Installing BRAVO software includes only “running program” (not including “database”) on Client machines of departments, users participating in software use to update and receive online data about the software on the server at the head office;

+ Users are decentralized and authorized to ensure independence and responsibility when updating data into the system.

(Recommendation: To ensure stability and data safety when operating the software, BRAVO recommends equipping an additional one. Backup server, backup server serves two main tasks: replacing the main server operating the system and backing up the software’s data. On the main server and backup server integrate equivalent physical hard drives and configure according to hard drive Raid solutions: Raid 0, Raid1, Raid 10)

a. Grouping user data classes at each use location

In addition to inheriting data arising in the system, each department has its own business , independent and sometimes confidential from other departments. Therefore, for users’ convenience in operating and manipulating the software, BRAVO divides the user interface into layers (Layout). Specifically:

b. Organize and disassemble the software database software, BRAVO advises on data organization plans suitable for each size of the business. Accordingly, the software’s database (database) will be divided into data trays (called base unit trays) corresponding to each point used to receive, store and process broadcast data. born at each point. And there is a general data tray that plays the role of aggregating/unifying data generated throughout the system.

2. Handling the transactions of each department

a. Accounting and financial management operations

• Loan and loan contract management module</li >

​

< strong>Overview: Manage all deposit and loan contracts. Control the revenues and expenditures of the business to give relevant analysis reports.

Detailed business: 

+ Manage deposit contracts..

+ Manage details of contracts Loan agreement, loan contract.

+ Declare information related to borrowing/lending interest rates, term of interest rate changes.

+ Calculation accounting for revenues and expenditures in the period

Reporting system: General amount of deposits; Book of summaries of loans under escrow; Profit detail table; Table of loan balance against loan limit.

• Money Management module (cash, bank money)

< p>​

Overview:  Manage receipts/expenditures/cash balances and bank deposits by type of currency (USD, VND…), control customer collection and payment to suppliers. Full information on funds, revenue and expenditure plans for reasonable revenue and expenditure balance.

Detailed business:

+ Management cash fund in bank;

+ Aggregate expenses by item, department, object…;

+ Automatically calculate and account exchange rate difference and evaluate the exchange rate difference at the end of the period;

+ Monitor credit limit with each bank;

+ Make and monitor revenue and expenditure plans, compare the actual work between the actual and the planned.

Reporting system: Cash book, cash book, deposit book; Cash receipt / payment journal; Tracking number for loans, escrow…

• Buy/sell self-trading securities module

​

Overview: Built in based on the process of buying and selling securities and managing debt. Allows management of securities trading in many different forms and tracking liabilities and receivables for each specific customer… In particular, it also helps managers control get the value, the amount of buying and selling securities. Automatically calculate profit and loss values ​​and automatically account for related transactions.

Detailed transactions: 

+ Software helps managers according to criteria such as: Investment properties: short-term, long-term; Type of investment: Securities (Stocks, bonds, bills, certificates of deposit…); By market: Domestic, foreign, listed, unlisted; Investments: face value, interest rate, interest period, maturity….

+ Or you can create free fields to declare information about investment items;

+ Allow to update investment transactions directly from transaction p/m or excel file;

+ Allow update market value in order to re-evaluate the value of investments;

+ Allows self-determination of ready-to-sell securities and not-yet-available securities (Waiting for payment/additional issuance, stock dividend…);

+ Different payment terms/stocks (T+1. T+4);

+ Support transactions purchase, sale, return, transfer, bonus shares…;

+ Support to import transaction-related costs (transaction fees, custody fees …..);

+ Calculation of investment prices (applicable to securities investments): Choose one of the following pricing methods: Weighted Average (month, day), LIFO…< /p>

+ Allows adjusting entries for debt/ investment adjustments: Business activities (consulting contract…); Management according to each type of business: issuance consulting, listing consulting, restructuring consulting, other (Allow users to create many different types of products themselves) ; Manage sales invoices; Track the due date of your bills; Allows control of Credit Limit for each customer from time to time; …

Reporting system :

+ Purchase and sales report: Detailed report on buying and selling securities; purchase and sale diary…

+ Debt report: Managing debt related to securities buying and selling activities; Report receivables and payables by payment due date, according to employees; Analysis of debt age for each debt.

+ Management reports: Tracking orders, purchase and sale contracts; Implementation deadline…

+ Report on securities trading revenue, financial safety indicators according to Circular 210-BTC.

• Subsystem Inventory management

​​

Overview:  Help businesses control the value, quantity of rotation, use of securities, and avoid damage in storage. Prepare and control securities import/export slips when circulating between exchanges, take profit on securities.

Detailed operations:

+ Prepare and print Entry slip, Export slip, Stock exchange transfer slip, Securities code change slip;

+ Calculate and update the value of profits of stocks and bonds (Taking stock profits);< /p>

+ On the multi-warehouse information processing sheet, securities, import/export in multiple units;

+ Monitor stock inventory, inventory limit;< /p>

+ Calculate cost price automatically by method: Price of name; Weighted Average Price; Average price at the time; First in first out price

+ Follow stock exchange;

+ Update inventory periodically, automatically generate export slips when inventory is available.

Reporting system: Inventory import and export list. contract; General stock export; General stock import; Detailed import and export summary; Securities detail book; Warehouse card; Securities inventory table; Securities demand report…

• Asset Management Module

​

Overview: Help businesses manage assets (Resources) fixed assets, tools) in terms of quantity and detailed value to each user and each department… Track asset fluctuations (increase/decrease in value, major repair, rotation…), manage Manage depreciation calculation, allocation of tools and equipment, installation and liquidation of assets.

+ Make and print details of asset cards;

+ Prepare and print coupons record changes in assets (transfer of parts, increase/decrease in asset value, change of use purpose…); Minutes of asset liquidation; Invoice for using tools; Record changes in tools and equipment (damage, liquidation…);

+ Make and give quick warning screens on the status of assets (such as fixed assets awaiting liquidation, tools, etc.); tools  are being used…);

+ Track details of assets by group, capital source, department, purpose of use, manager…;

< p>+ Track asset fluctuations (major repair, installation, dismantling, write down, depreciation, liquidation…) over periods of use;

+ Track usage status tools and tools (Report damage, repair, liquidation…);

+ Monitor and calculate annual depreciation plan of fixed assets;

+ Automatically calculate and accounting for depreciation of fixed assets according to capital sources. Supports straight-line and amortizing depreciation;

+ Calculation and accounting of tools and equipment value into expenses in different periods.

Reporting system: Asset card, asset book, asset detail table; Table of depreciation of assets; Detailed report on asset inventory,…

• General accounting module

​​

Overview: Connecting organic data to modules. Being the center for updating and building financial management plans, revenue, expenses as well as data collection to make the system of financial statements, tax reports, reports submitted to superiors and corporate governance reports. business.

Detailed transactions:

+ In addition to data from other modules, the general accountant also prepares additional transactions. other accounting and off-balance sheet accounting operations;

+ Managing, tracking and making plans on revenue and expenses;

+ Declaring definitions of types transactions (transactions) arising for other modules to use;

+ Automatic features: Create closing, transfer and allocation entries; Create periodic entries

Reporting system:

+ Print accounting books: books detail book; general account book; balance sheet account; diary books, detailed sales revenue books…

+ Print Financial statements: Balance sheet. Report on business results (profit, loss); Summary table of taxes and state payables; Statements of cash flows; Notes to Financial Statements…

+ Print Tax Report: VAT declaration, List of documents of goods and services purchased and sold; VAT finalization report; Detailed declaration of revenue, expenses and income; Statement of tax payment…

+ Print Management Report: Revenue and expenditure plan; Revenue and expense analysis; Inventory of corporate assets; some criteria for assessing business performance,…

b. Core data connection business

• Method of connection between transaction software and BRAVO management accounting software< /strong>

Types of connection to get data from stock trading software (Core) and BRAVO software: Connecting and retrieving data data from the core is the later stage of the transaction execution process. Therefore, connecting and retrieving data must ensure that receiving data does not have data shortages, as well as errors of data retrieval operations. To avoid this situation, BRAVO recommends that the Company use a direct connection between BRAVO software and transaction core software with the principle of access in a way that only reads data from intermediate database tables. (intermediate database), or through queries (SQL view) instead of through intermediate files like: excel, text, cvs.

– Connection connects directly to transaction core, reads data from virtual table

– Connecting through an intermediate database< /strong>

– Get Portal transaction data

< p>– Accounting for transaction data

–  Update stock portfolio from trading platform

Overview: The connection method to get data into BRAVO 7 software has can be directly from the stock core software through queries, intermediate databases or intermediate files for inclusion in the BRAVO program. This connection helps businesses use transactions made on the floor trading software and helps employees not have to re-enter data many times. The way to connect businesses can be customized according to the management needs of the business.

Detailed business:

+ Declaring the system list of transaction types and accounting operations;

+ Declare connection of securities portfolio, investor list, object;

+ Warning error when connecting and updating (importing) data from core;

+ Update data (import) data from core according to the declared transaction type.

< p>c. Purchases

– Purchasing operations are under the authority and responsibility of the Purchasing Department. However, the operation process is related to all parts and departments in the enterprise.

– Processing purchase requests/requests: at each point of software use (offices). , branch), every department will make all kinds of “proposal/request for procurement” via hard copy (according to the standard form of the enterprise) => purpose to reduce redundant data types and minimize the number of users interacting on the software.

– After being confirmed and approved by the department head (or person in charge) then it will be transferred to a main department to synthesize all kinds of requests/requests to purchase materials and update into the software. This department will base on the elements of materials (inventory on the system…) to approve the purchase proposals => The approved and accepted offers will be displayed on the data screen at the purchasing room at the Head Office/branch.

– At the Purchasing Department, the purchasing officer checks and approves procurement proposals/requests and conducts the process of inquiry/collection of quotations/comparison of quotations to submit to the Board of Directors. approved by the company. After the leader approves, the Purchasing Department proceeds to make orders/contracts (according to the selected supplier, quotation) to proceed with the purchase.

– Follow up. Purchase progress and supplier delivery.

– Track the delivery of supplies and stationery to each department according to approved procurement requirements and purchase.</p >

d. Human Resource Management

< p>- Manage personnel records:

+ Manage detailed information about employees;

+ Update information about employees changes and fluctuations of each employee during the working process (labor contract, reward, discipline, evaluation results,…);

+ Track the entire history of the company’s activities Employee in an enterprise;

+ Human Resources Reporting System (Report on labor situation, General report on personnel, Report on increase or decrease in personnel, employee history information… ).

– Timekeeping and calculation of salary, bonus, insurance:

+ Connecting to data from fingerprint machines at the office head office/branch, import timekeeping data into the software or connect directly to the timekeeping machine to get data;

+ Declare working time Flexibility to work shifts (if any);

+ Flexible design of salary parameters;

+ Update sales and bonus calculation of sales department, department Brokerage department;

+ Update how to calculate daily salary, bonus… and related parameters;

+ Perform salary calculation for Office Team (Time salary) and the Sales and Brokerage team (Time salary + sales salary);

+ Monthly salary analysis reports (Detailed monthly salary, personal pay slips, received salary table… );

+ Insurance reporting system, PIT according to state regulations.

+ Insurance reporting system, PIT according to state regulations.