What are the tips for making financial statements?

Financial statements mainly rely on software, and the accounts are carried forward in a step-by-step manner, and the accounts made will be foolproof.

In financial analysis, there are three techniques:

1. The principle of specific analysis of specific problems.

In the analysis of financial proportions, avoid rigid routines. For example, it is generally believed that a current ratio of 2:1 is better, but if no distinction is made, the current ratio of all ** companies is required to be 2:

1. It is too rigid. This indicator is only a reference basis for judging the solvency of the company, not the only standard.

2. Implement the unitized analysis method as much as possible.

Because the scale of assets is generally large, it is difficult to have a specific understanding, so that people can not see the actual operating conditions of the company. Generally, the figures of various financial information or accounting items are converted into unit figures, such as net asset value per share. By using unit figures, you can clearly see the company's operations, especially the company's profitability.

If the profit is unitized and made into a net profit per share, it can not only be used for the first company to make an objective comparison of each year, but also for the comparison between the first company.

3. Learn how to combine absolute and relative numbers.

We see that "the net value growth rate of a certain ** this year increased by 20%", which is an abstract concept, people only know that the growth rate of this ** this year is 20%, but what is the profit? Relative data can help us grasp the development trend of a company as a whole, and absolute numbers can enable us to see the company's development status.

In short, in the first year (mid-year) financial analysis, we not only analyze the company's finances, but also analyze the text of the annual report, as well as the current development of the company.

1. The basic auxiliary tool excel**, fill in the report through the account summary table.

2. Generally, enterprises will automatically generate it through financial software Kingdee, UFIDA, etc.

3. The most basic work is to make entries.

1. Simple financial statements

1) After creating a new worksheet, double-click the current worksheet column of the Qinyou Tangerine Worksheet tab with the mouse, enter the name or abbreviation of the report (such as "Month Balance Sheet") and set the page according to the size of the report.

2) Fill in the text content of the report. According to the needs of the first class, by selecting the position and size of the cells, setting the cell format, merging the cells and other methods, the preliminary preparation of the grinding hole report.

3) Set the function relationship of the report data. For example, in the balance sheet, in the total column of the previous period of liquidity, you can select the relevant cells, enter the "=" sign and click the cells of the relevant functions respectively.

Enter the symbol of the function relationship as needed. After the beginning of the year column is set, the function relationship of the cell is copied to the year-end number column by copying. At this point, the blank table of ** is compiled.

4) Fill in the report data. According to the actual situation, fill in the relevant data in the corresponding cells; The cells that automatically generate data on the computer cannot be filled in with data. For more complex reports with relevant data**, reports can be prepared through data transformation.

5) Data Protection. For important reports, data protection must be done to prevent tampering. The specific method is to select the protection function of the toolbar, and after entering the password, the report can be protected.

1. Dynamic chart of profit analysis table:

**Cover. 2. Built-in hidden correlation series and set formulas.

3. As long as you fill in the previous value, the corresponding result will be automatically obtained below. To a large extent, the error of manual calculation is greatly reduced, and the work efficiency is improved.

4. Select the required data, ** will be automatically changed. In this way, the data will be very three-dimensional and clear.

5. Select the ledger account, and the chart will change accordingly.

Popular science: Financial statements are accounting statements that reflect the capital and profit status of an enterprise or budget unit in a certain period. The types, formats, and requirements for the preparation and reporting of financial statements in China are all stipulated by the unified accounting system, and enterprises are required to prepare and report them on a regular basis.

At the end of the reporting period, state-owned industrial enterprises shall prepare fund balance sheets, special ** and special appropriation statements, capital statements such as infrastructure loans and special loan statements, as well as profit statements such as income statements and product sales profit statements; State-owned commercial enterprises are required to submit a balance sheet of funds, a statement of operating conditions, and a statement of special funds.

You can use the following steps to generate financial statements:

1. First open yonyou financial software, enter the operator and password, and then click the right button to log in.

2. Click the financial accounting button on the left navigation bar of UFIDA software, find the UFO report under the category of financial accounting, and click to enter.

3. Click UFO Report, and the following dialog box will pop up. Click Close directly.

4. After entering the UFO report interface, click the File button in the upper left corner of the page.

5. Then click Open in the drop-down menu of the file.

6. Find the location of the financial statement template on your computer, select it, and then proceed to click Open.

7. After opening the financial statement template, find the data button in the taskbar above and click Open.

8. Click on the data, find the input key, enter the annual status, month and other information in turn, click the OK button after the input is completed, and the report will automatically recalculate the monthly report sail answer information you need.

9. Finally, the report data is successfully generated. If you want to print it, just click the print button at the top of the page to print it.

First, the three financial tables, generally refers to the balance sheet, profit and cash flow statement, the preparation of the three financial tables is not prepared out of thin air, should be in accordance with the accounting principles and the requirements of the "Accounting Standards for Business Enterprises", according to the relevant accounting subjects set up accounting books, accounting for each business of the enterprise, and then settle out the balance and amount of each accounting account, and then according to the balance of each account, the amount of occurrence and the detailed analysis of cash flow items, and finally prepare the financial three tables.

Second, the net profit of the first year should be filled in according to the actual business accounting, in actual work, the first year is not necessarily a negative profit, because based on accounting principles, even if the first year of expenditure is more, but there are many parts of capital expenditure, and profit and loss are not counted, so it will not affect the profit. Of course, most companies will have a negative net operating cash flow in the first year, but this does not mean that profits are necessarily negative.

Third, the investment money should form assets, financing money to form equity (liabilities or owners' equity), it is estimated that the money you said in the first year of investment refers to the money invested by shareholders in the company, which should be called financing (financing for enterprises), and the financial account is accounted for by the enterprise, not by shareholders.

Therefore, if you are talking about the money invested by shareholders, it should be written in the paid-in capital, not in the operating expenses.

Fourth, the order of the three statements is not fixed, according to the order, the first statement is the balance sheet, the second statement is the income statement, and the third statement is the cash flow statement. However, if you do a good job of financial accounting as mentioned in the first article above, then there is no hard and fast rule on which table to compile first, and it can be compiled in any order.