(Content is best viewed on a larger screen.)
Enter the Company Name, Period information, and the Beginning Cash balance.
From your checkbook, enter the receipts and/or expenditures in the appropriate column.
If you have more than one entry in a column for a day, total the daily entries and enter the total for the day.
The total for each column will be transferred automatically to the Cash Flow Statement.
If you have downloaded the spreadsheet, save as an Excel worksheet.
Print out the Cash Flow Statement when the period is complete and analyze the results.