What Are The Computer Skills That Financial Personnel Should Master?

At present, with the popularization of computer application

(1) office software is a basic skill that financial personnel need to master.

In practical operation, Word, Excel and PowerPoint become the main means of work. Word is the most commonly used word processing software in modern office, which meets the requirements for processing various documents.

Excel spreadsheets play a great role in computing, sorting, summarizing and so on, which brings great convenience to accounting functions.

Using PowerPoint, you can create presentation presentations.

(two) financial software is an important working tool for financial personnel.

Financial software not only improves the speed of financial personnel accounting processing, but also optimizes the work.

1. General ledger management

General ledger management is suitable for voucher processing, account book management and personal pactions.

(1) before starting the use of the general ledger system, the initial settings are set up, including accounting subjects, foreign currency settings, initial balances, certificate categories, settlement methods, classification definitions, coding files, customization, etc., according to the contents of the economic business, the entry entry vouchers are prepared. The unit's financial supervisor or designated personnel carries out audit vouchers, accounts at the end of the month, and the system automatically completes the business of profit and loss during the period.

(2) personal pactions mainly involve personal loans and repayment management, and personal loans can be understood in time to control and clear debts.

(3) the accounting department should collect the accounting business as a unit, and control the expenses of various departments in a timely manner through the revenue and expenditure of each department. The financial personnel should analyze the revenue and expenditure of the departments so as to provide basis for the Department's assessment.

(4) project accounting can reflect the trend of gold flow, and also the data source of the cash flow statement at the end of the month.

(5) cashier management details the accounts of money and funds, providing an office environment for cashiers, completing bank journal and cash journal, providing bank entry, query and other functions.

{page_break}

2. Inventory management

Inventory management is suitable for inventory and inventory management of goods and raw materials.

Many enterprises, such as retail and manufacturing, have a large number of inventories and a variety of goods. Strict and scientific management of inventory is an important work objective of the finance department and warehouse department. On the one hand, it classifies and manages the objects, and on the other hand, establishes a complete supply and marketing management system, accounting, controlling and supervising from the books, so as to provide credible basis for achieving the match of accounts and real accounts.

When the purchase, delivery, allocation, scrapping, donation and other business of inventory occur, the information is entered into the inventory module according to the name, quantity, unit price and other information recorded in the original warehousing and outgoing documents. The module also has powerful functions of calculation, query and so on, providing inventory information for purchase and sale.

According to the actual situation, some units do not realize the inventory management by financial software, but adopt other management software and ERP system that meet the needs of unit management, and their functions are consistent with financial software.

3. Cash flow management

The cash flow management is suitable for the pactions between customers and suppliers who have business relationship with the company, and accounts mainly through prepaid accounts, accounts payable and other accounts payable.

When initially set up, such subjects should be set up as supplementary accounting for customers or suppliers, and files of customers and suppliers should be set up. The corresponding auxiliary accounting contents should be recorded when each paction occurs, and the accounts should be checked regularly with current units in actual work, so as to verify the latest situation of incoming funds in time.

4, report management

Report management and the general ledger management complement each other. The general ledger system provides financial data to generate financial statements.

At the end of the month, after completing the month end processing of voucher bookkeeping and profit and loss carry over, enter the report management system, open the report forms, enter the data keywords, and the system will generate basic financial statements after data calculation and finishing.

Note that the report forms a spreadsheet on the computer hard disk and opens the report management system to find out the corresponding path.

5, fixed assets management

Fixed assets management calculates and manages data of fixed assets and accumulated depreciation, reflecting changes in fixed assets, changes in original value and changes in departments.