You can ultimately estimate cash flow by entering your beginning balance into your spreadsheet, estimate your cash coming in and out, and then subtract your outlays from income. the result will be your cash left at the end of the month. That figure is used as the beginning cash balance at the start of the next month.