2. There are three parts: operating activities, investing activities and financing activities. Cash inflows are recorded on the left and cash outflows are recorded on the right.
3. Based on the income statement items and combined with the balance sheet, analyze the increase or decrease in each non-cash item, and prepare adjusting entries accordingly.
A detailed description of the cash flows generated by the company's operating, investing and financing activities.
General tips for cash flow statement automatic generator table 1: IF function conditional judgment
The IF function is one of the most commonly used judgment functions, which can complete either-or judgments.
The assessment score standard is 9 points. It is necessary to judge whether the assessment results in column B are qualified.
=IF(B4>=9,"qualified","unqualified")
2: Conditional search
The VLOOKUP function has always been a favorite among the public. The syntax of the function is:VLOOKUP (Who are you looking for, where are you looking for, which column of content is returned, exact or approximate)
You want to query the position of the employee name in cell F5.
=VLOOKUP($F$5,$B$1:$D$10,2,0)
When using this function, you need to pay attention to the following points:
1. The fourth parameter is generally set to 0 (or FASLE) to search in exact matching mode.
2. The column number in the third parameter cannot be understood as the actual column number in the worksheet, but specifies the column in the search range of the return value.
3. If the search value is inconsistent with the data type of the data area keyword, the error value #N/A will be returned.
4. The search value must be located in the first column in the query area.
Recommended by the editor of Huajun Software Park
Cash flow statement automatic generatorIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need an automatic cash flow statement generator, download it quickly. In addition,Trend analysis table,Asset inventory sheetIt is also a good software. Welcome to click to download and experience it!





















Useful
Useful
Useful