How to make a simple excel financial statement?

(1) After creating a new worksheet, double-click the current worksheet column in the Worksheet tab and enter the name or abbreviation of the report.

(2) Fill in the text of the report. According to the needs of the table, the report is compiled by selecting the position and size of cells, setting the format of cells, merging cells and other methods.

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

(4) Fill in the report data. According to the actual situation, fill in the relevant data in the corresponding cells; Cells with computer-generated data cannot be filled with data.

(5) data protection. For important reports, data must be protected to prevent others from tampering. The specific method is to select the protection function of the toolbar and enter the password to protect the report.

Before compiling the report, the accounting subjects should be adjusted, settled and checked to ensure the authenticity and accuracy of the account books. Financial statements mainly include: balance sheet, income statement and cash flow statement. ?

Balance sheet: a statement that comprehensively reflects the financial situation of an enterprise in a specific period. The main content is to list the composition of assets, liabilities and owners' equity. And calculate and fill in the column according to the principle of accounting identity. The left side of the report is arranged in the order of current assets, fixed assets, long-term liabilities and owners' equity, and the items of current assets are arranged in the order of liquidity. The right side of the statement is arranged in the order of current liabilities, long-term liabilities and owners' equity. Relevant items in the balance sheet shall be filled in according to the opening balance and closing balance of relevant accounts.

Income statement: a statement that comprehensively reflects the operating results of an enterprise in a certain period. The main content is to list the matching results of various incomes, expenses and costs, so as to reflect the profits realized by the enterprise in a certain period of time. The relevant items are generally filled in according to the amount of the relevant account.

Cash flow statement: a statement of changes in financial position based on cash. It reflects the dynamic situation of business activities, investment activities and capital activities of enterprises in a certain period with the inflow and outflow of cash, and reflects the whole picture of cash inflow and outflow of enterprises. Cash here refers to cash on hand, deposits that can be used for payment at any time and cash equivalents.