Cash Flow Template

This template summarizes account activity to help prepare the statement of cash flows using either the direct method or indirect method.

Entering Data

Data must be entered on both the Input worksheet and the Additional Input worksheet. The Input worksheet is used to enter beginning and ending balances for various asset, liability, and equity accounts. On the Additional Input worksheet, amounts must be entered in the “Analysis of Net Change During the Period” section of the worksheet. In this section, enter in the appropriate columns the gross amounts comprising each account's net change during the period. The portion of the net change that has not been allocated to the various columns appears in the "Unallocated Portion of Net Change" column.
Once the required input sheets are completed, the cash flow statement will automatically generate on the Statement worksheet.