Cash flow statement preparation tips

Cash flow statement preparation tipsIt is a replacement for the original statement of changes in financial position or statement of funds flow. It details the cash flows generated by the company's operating, investing and financing activities. The free download of the Excel template for preparing the cash flow statement is provided by Huajun Software Park. The source file is in xlsx format. You can edit and modify the content style by downloading the source file. For more free downloads of the Excel template for preparing the cash flow statement, please pay attention to Huajun Software Park. .

Tips for preparing cash flow statement       1. Open T-shaped accounts for all non-cash items (including balance sheet items and income statement items), and transfer the respective closing and opening changes to each account.

      2. Open a large "cash and cash equivalents" T-shaped account. Each side is divided into three parts: operating activities, investing activities and financing activities. Cash inflows are recorded on the left and cash outflows are recorded on the right. As with other accounts, the ending and opening changes are applied.
      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.
      4. Post the adjusting entries to each T-shaped account and check. The balance after offsetting the debits and credits of the account should be consistent with the changes at the end and beginning of the period originally posted.
      5. Prepare a formal cash flow statement based on the large "cash and cash equivalents" T-shaped account.

      A detailed description of the cash flows generated by the company's operating, investing and financing activities.

General tips for preparing cash flow statement       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: Sum of multiple conditions
It is necessary to count the total amount of subsidies provided by the department for production and the position is for the main operator.
The formula is:
=SUMIFS(D2:D9,B2:B9,F2,C2:C9,G2)
      3: Condition count
It is necessary to count the number of business transactions of the designated store. That is, count how many specified store names there are in column B.
=COUNTIF(B2:B12,E3)
Recommended by the editor of Huajun Software Park

Cash flow statement preparation tipsIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need tips on preparing a cash flow statement, download it quickly. also,Credit sales review form,Fund Management Status StatementIt is also a good software. Welcome to click to download and experience it!