What SMEs need financial analysis tool?



Traditional reporting analysis tools: If UF UFO, Kingdee reporting system, similar to the EXCEL table, to the cell was treated, can function according to the system default check from the financial system, the number of function parameters include: subject, taking the number of type ( debit / credit / beginning / end / balance / volume occurred), the fiscal year, accounting period and so on, while a similar EXCEL also has other functions, such as cell multiplication and division addition and subtraction between the summary and other computing, but also to format layout.

Such reporting tools, better meet the enterprise report design and printing external features, such as balance sheet, income statement, etc., also can be based on the needs, to design a number of management reports for internal use, such as management fees details tables, schedules and other accounts receivable. Together with the total score is included in general ledger system / and a breakdown / project subjects accounts / balance sheet accounts and tables, the composition of the current financial software company's basic reporting analysis tools.

Well, business is not also need other tools to assist financial analysis? The answer is yes. Why, we can start to analyze the financial analysis of SMEs to the major needs:

First, the balance sheet structure and trend analysis: If the balance sheet composition of the assets, current assets / fixed assets and intangible assets constitute the ratio be? The current assets in money funds / stocks / receivables, the proportion is? In the short-term debt liabilities in contrast with the trend of history is like? ... ... And so on, which is often the analysis of business. In the traditional statement analysis, to achieve a certain kind of structural analysis of complex reports need to set the formula, once more during contrast, re-calculation will consume a lot of time, but once the subject structure is changed, they need to maintain statements very convenient.

Second, income statement and profit and loss analysis of class subjects: how the composition of net profit, which is the income statement to show the problem, but at the same time, we often need to compare the historical period, the hopes column or line chart to compare and trend analysis analysis. The traditional statement analysis tools are not graphic display functions. Profit and loss analysis for the class of subjects, is of particular concern enterprises, such as management fees analysis, enterprises often have to conduct detail analysis, comparative analysis of the historical period and with the combination of multi-dimensional accounting of project analysis. In the traditional statement analysis, also requires a lot of maintenance. In the Power-BI, only to go through simply to drag the mouse to complete.

Third, accounting item analysis: In order to achieve fine financial management, subjects linked to the project accounting, processing of accounting documents is commonly used method, common link, such as customer accounts receivable, accounts payable linked to suppliers, other receivables pegged staff , management fees linked to sector. In addition, in order to achieve individual business management, financial software will allow user-defined accounting items, such as construction in progress, will keep detailed records associated with the procurement / inventory / cost / revenue / costs; Another example of a training school, opened many courses, in order to profit on accounting courses, the curriculum set to account for the project, but around the place a program of income / expenses, are recorded in the document dealing with the accounting program. In such circumstances, you need to account for these items out of the income statement. The statements in the traditional treatments, you need to report specific subjects / accounting projects to set the formula, if raised up a course set Yi Ci Jiu Yao formula, Tong Shi, Xiang Jin Xing Butonghesuan the Shouru between projects / cost / Li Run contrast, can not be flexible to achieve.

We then look at the people of the habit of thinking of a problem. For example, our analysis of the cost of carrying out management. First of all, we hope to see the current management fees and a breakdown of the period, then, we hope to compare with the historical period, such as with the previous period or a year earlier comparison, details the discovery of a management costs such as maintenance costs compared with the historical period larger changes, we usually want to immediately know why.

Because the administrative costs linked to the general accounting department of this project, this time, we hope that through the project management and accounting fees to find multi-dimensional analysis of the reasons is the department's maintenance costs were greatly change? Found the cost of the department occurred, we would also like to know what causes it? At this point, we think of the hope of finding records of this cost accounting documents to look at summary, if the summary did not elaborate on, then we can quickly find the font by the original certificate of evidence, such as reimbursement documents.

If you use financial software for financial management staff to see the examples above, you imagine, in the traditional financial software, you need to switch the number of interfaces, enter the number of query conditions? This in turn requires much time? Your financial software needs more skilled operators do? I think this time you will want to have a tool that can only drag the mouse, you can complete the whole process to be analyzed and the corresponding results found.

Thus, based on other tools of financial analysis software also emerged. We will present market to do the financial analysis software, a simple classification.

Category: Automatic generation of financial analysis. Such as Beijing Zhi Zehua software that can be introduced to three statements, you can automatically generate an illustrated analysis. While many financial experts, including intelligence, can be considered quite intelligent, but the small and medium enterprises in China before, a little embarrassed: Who wants to believe that a computer-generated financial analysis reports it?

The second category: financial ratio analysis. If UF / Kingdee own management cockpit, this software can automatically calculate a variety of financial indicators such as asset turnover, current ratio, quick ratio, etc. reflect the profitability of the business / operational capacity / solvency indicators, and assist with so beautiful dashboard interface displayed. Such as instrument panel has a beautiful display methods that can quickly attract interest. But in use, it seems too monotonous.毕竟,一个企业的经济状况,并不是通过几个指标就能完整地展现出来的,更何况,又有几个非财务出身的企业管理者能够完全理解每个指标背后所代表的意义呢?

  第三类:智能报表分析。如北京奥威智动的Power-BI,这种软件以BI的技术为基础,预设丰富的分析模型,通过鼠标拖拽任意变换分析角度与内容,可进行结构分析/趋势分析,有丰富的图形展示,可任意自定义各种常用的分析报表,可进行任意期间的对比分析,可层层钻取到明细账再到会计凭证。

  因为它的直观性与灵活性,适合企业各种管理者使用,就算总经理不懂财务也可以使用:如果全年的业务招待费以一个折线图的方式显示在他的面前,我想,他肯定知道发生了什么,是不是不正常。

  当然,对于中小企业来说,到底需要哪一类的分析工具,见仁见智,但有一点是不容置疑的,那就是,除了财务软件自身提供的功能,还需要另外一个工具来辅助财务分析。