Cashflow for Checking Account Balance

Spreadsheets Microsoft Excel
,
1

Hello Community! I’ve just joined Tiller and am loving the excel interface/flexibility. Has anyone made a workbook that tracks the balance needed in checking account vs upcoming bill pays?

For example:

  • Monthly Pay period goes into checking / savings account.
  • No interest on checking so balance is kept in savings.
  • My credit card payments come automatically out of the checking account.

I would like to have something that forecasts the upcoming bill payments VS the current balance of the checking account to make sure that there is enough moved from savings to cover this. Or obviously if there is extra in checking it should be moved to savings. I currently do this manually by checking all the accounts 1-2 times weekly.

2

hi @ericdmoores perhaps this would work - Expense Forecasting and seeing upcoming expenses on a Calendar - UPDATED 4/15/24