The second step is to analyze the current business and prepare adjusting entries.
The third step is to enter the adjusting entries into the corresponding sections of the work papers.
The fourth step is to check the adjusting entries. The total loans and debits should be equal. After adding and subtracting the borrowing amount in the adjusting entries, the opening amount of the balance sheet item should be equal to the ending amount.
The fifth step is to prepare a formal cash flow statement based on the cash flow statement items in the working paper.
General Tips for Cash Flow Statement Schedule 1, section column hide
Select the first line, hold down [shift+F] to open the "Find and Replace" dialog box, "Remarks to find all, hold down shift+A to select all, then close the dialog box, hold down [ctri+0] to hide
2. Quickly select specific columns
Select the table area, click the "Create from selected content" dialog box under the [Formula] tab, and select "First Row". After the settings are completed, open the name box in the upper left corner, and click the corresponding list to jump to the specified column.
3. Two-column name verification
If you want to check whether the name in Table 2 appears in Table 1, a formula can be used to do it immediately.
=IF(COUNTIF(A:A,C2),"Yes","No")
Recommended by the editor of Huajun Software Park
Cash Flow Statement ScheduleIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need the cash flow statement schedule, download it quickly. also,Statistical table of enterprises and institutions directly under the Ministry,Department daily reportIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works