Cash Flow Template

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

Entering Data

Data must be entered on both the Input worksheet and the calculation 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 the appropriate columns of this section, enter 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. Users of the direct method should also complete the Additional Allocation worksheet the same way they completed the Allocation worksheet. Once the required input sheets are completed, the cash flow statement will generate on the Statement worksheet automatically.