Use this template to plan your business's cash flow. The template provides data entry areas for cash inflows and outflows from both operations and financing.
The beginning cash balance is entered in the first month and calculated for all subsequent months. Note that the total column summarizes the entire year, from the first month's beginning balance to the last month's ending balance.
Change the starting month by typing the first three letters of the month at the top of the first column. The other month headings will be calculated by formulas.
To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.